asp.net datagrid实现多层表头

类别:.NET开发 点击:0 评论:0 推荐:

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Xml;
using System.Text;

namespace WinnerOA.newrpt
{
 /// <summary>
 /// dayenter 的摘要说明。
 /// </summary>
 public class dayenter : System.Web.UI.Page
 {
  protected System.Web.UI.WebControls.Calendar Calendar1;
  protected System.Web.UI.WebControls.Button updateButton;
  protected System.Web.UI.WebControls.DataGrid dataTable;
  protected System.Web.UI.WebControls.Button addLineButton;
 
  private void Page_Load(object sender, System.EventArgs e)
  {
   if(this.InitReadDataPopedom())
   {
    if(!this.IsPostBack)
    {
     this.Calendar1.SelectedDate=DateTime.Today;
     
     
    }
    this.InitData();
   }
   else
   {
    this.Response.Clear();
    this.Response.Write("您没有权限!");
    this.Response.End();
    return;
   }
   if(this.InitWriteDataPopedom())
   {
     
    this.addLineButton.Visible=true;
    this.updateButton.Visible=true;
   }
   else
   {
    this.addLineButton.Visible=false;
    this.updateButton.Visible=false;
   }
   
  }
  
  private bool InitWriteDataPopedom()
  {
   ArrayList depts=new ArrayList();
   XmlDocument xmldocument=new XmlDocument();
   XmlNodeReader xmlreader=null;
   try
   {
    
    xmldocument.Load(Server.MapPath("..").ToString()+@"\popedom.xml");
    xmlreader=new XmlNodeReader(xmldocument.ChildNodes[1].ChildNodes[11]);
    while(xmlreader.Read())
    {
     if(xmlreader.NodeType.Equals(XmlNodeType.Element))
     {
      if(xmlreader.Name.ToString().Equals("write"))
      {
       while(xmlreader.Read())
       {
        if(!xmlreader.Name.Equals("user"))
        {
         break;
        }
        else
        {
         depts.Add (xmlreader.ReadString());
        }
       }
      }
     
     }
    }
   }
   catch(Exception err)
   {
    Response.Write(err.ToString());
   }
   finally
   {
    xmlreader.Close();
   }
   string deptname=Request.Cookies["oabusyusername"].Value.ToString();
   Encoding e=Encoding.GetEncoding("gb2312");
   deptname=HttpUtility.UrlDecode(deptname,e);
   if(depts.Contains(deptname))
   {
    return true;
   }
   else
   {
    return false;
   }
  }
  private bool InitReadDataPopedom()
  {
   ArrayList depts=new ArrayList();
   XmlDocument xmldocument=new XmlDocument();
   XmlNodeReader xmlreader=null;
   try
   {
    
    xmldocument.Load(Server.MapPath("..").ToString()+@"\popedom.xml");
    xmlreader=new XmlNodeReader(xmldocument.ChildNodes[1].ChildNodes[11]);
    while(xmlreader.Read())
    {
     if(xmlreader.NodeType.Equals(XmlNodeType.Element))
     {
      if(xmlreader.Name.ToString().Equals("read"))
      {
       while(xmlreader.Read())
       {
        if(!xmlreader.Name.Equals("user"))
        {
         break;
        }
        else
        {
         depts.Add (xmlreader.ReadString());
        }
       }
      }
     
     }
    }
   }
   catch(Exception err)
   {
    Response.Write(err.ToString());
   }
   finally
   {
    xmlreader.Close();
   }
   string deptname=Request.Cookies["oabusyusername"].Value.ToString();
   Encoding e=Encoding.GetEncoding("gb2312");
   deptname=HttpUtility.UrlDecode(deptname,e);
   if(depts.Contains(deptname))
   {
    return true;
   }
   else
   {
    return false;
   }
  }

  private void InitData()
  {
   if(Session["dataset"]==null)
   {
    string sqlcmd="SELECT  id , lanewayName AS 巷道名称, constructunit AS 施工单位,designlength AS 设计长度, designdm AS 设计断面, mplane AS 本月计划, dplaneenter AS 本日,dfactenter AS 本日1, mtotal AS 本月累计, lithology AS 岩性, angle AS 角度,       mplaneenter AS 本月1, mfactenter AS 本月2, hair AS 成巷1, moulding AS 成巷2, memo AS 备注 FROM dayenter where [date]='"+this.Calendar1.SelectedDate.ToShortDateString()+"'";
    string connstring="workstation id=SERVER;packet size=4096;user id=sa;data source='.';persist security info=True;initial catalog=winneroa;password=pxh2003";
    SqlConnection conn=new SqlConnection(connstring);
    try
    {
     conn.Open();
    }
    catch(Exception err)
    {
     Response.Write(err.ToString());
     return;
    }
    SqlDataAdapter sda=new SqlDataAdapter(sqlcmd,conn);
    DataSet ds=new DataSet();
  
    try
    {
     sda.Fill(ds);
     
     this.dataTable.DataSource=ds.Tables[0].DefaultView;
   
     this.dataTable.DataBind();
     this.Session["dataset"]=ds;
    }
    catch(Exception err)
    {
     Response.Write(err.ToString());

    }
    finally
    {
    
     conn.Close();
    }
   }
   else
   {
    DataSet ds=(DataSet)(Session["dataset"]);
    
    //DataRow newrow=ds.Tables[0].NewRow();
    //ds.Tables[0].Rows.Add(newrow);
    this.dataTable.DataSource=ds;
    this.dataTable.DataBind();
    Session["dataset"]=ds;
   }
   
   
  }
  private void AddLine()
  {
   if(Session["dataset"]!=null)
   {
    DataSet ds=(DataSet)(Session["dataset"]);
    
    DataRow newrow=ds.Tables[0].NewRow();
    ds.Tables[0].Rows.Add(newrow);
    this.dataTable.DataSource=ds;
    this.dataTable.DataBind();
    Session["dataset"]=ds;
   }
  }

  private void delData()
  {
   string sqlcmd="delete from dayenter where [date]='"+this.Calendar1.SelectedDate.ToShortDateString()+"'";
   string connstring="workstation id=SERVER;packet size=4096;user id=sa;data source='.';persist security info=True;initial catalog=winneroa;password=pxh2003";
   SqlConnection conn=new SqlConnection(connstring);
   try
   {
    conn.Open();
   }
   catch(Exception err)
   {
    Response.Write(err.ToString());
    return;
   }
   SqlCommand cmd=new SqlCommand(sqlcmd,conn);
   try
   {
    cmd.ExecuteNonQuery();
   }
   catch(Exception err)
   {
    Response.Write(err.ToString());
   }
   finally
   {
    conn.Close();
   }
  }

  private void SaveData()
  {
   this.delData();
   string connstring="workstation id=SERVER;packet size=4096;user id=sa;data source='.';persist security info=True;initial catalog=winneroa;password=pxh2003";
   SqlConnection conn=new SqlConnection(connstring);
   foreach(DataGridItem e in this.dataTable.Items)
   {
    if(e.ItemType!=ListItemType.Header && e.ItemType!=ListItemType.Footer)
    {
     string sqlcmd="insert into dayenter(lanewayName,constructunit,designlength,designdm,mplane,dplaneenter,dfactenter,mtotal,lithology,angle,mplaneenter,mfactenter,hair,moulding,memo,[date]) values(";
     
     
     for(int j=2;j<e.Cells.Count ;j++)
     {
      sqlcmd+="'"+((TextBox)e.Cells[j].Controls[0]).Text +"',";
      
     }
     sqlcmd+="'"+this.Calendar1.SelectedDate.ToShortDateString()+"')";
     try
     {
      conn.Open();
     }
     catch(Exception err)
     {
      Response.Write(err.ToString());
      return;
     }
     SqlCommand cmd=new SqlCommand(sqlcmd,conn);
     try
     {
      cmd.ExecuteNonQuery();
      
     }
     catch(Exception err)
     {
      Response.Write(err.ToString()+sqlcmd);
     }
     finally
     {
      conn.Close();
     }
    }
   }
   this.Session["dataset"]=null;
   this.InitData();
  }
  #region Web 窗体设计器生成的代码
  override protected void OnInit(EventArgs e)
  {
   //
   // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
   //
   InitializeComponent();
   base.OnInit(e);
  }
  
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {   
   this.addLineButton.Click += new System.EventHandler(this.addLineButton_Click);
   this.updateButton.Click += new System.EventHandler(this.updateButton_Click);
   this.Calendar1.SelectionChanged += new System.EventHandler(this.Calendar1_SelectionChanged);
   this.dataTable.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dataTable_ItemCreated);
   this.dataTable.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dataTable_ItemDataBound);
   this.Load += new System.EventHandler(this.Page_Load);

  }
  #endregion

  private void addLineButton_Click(object sender, System.EventArgs e)
  {
   this.SaveData();
   this.AddLine();
   
  }

  private void updateButton_Click(object sender, System.EventArgs e)
  {
   this.SaveData();
  }

  private void dataTable_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
  {
   
   
   e.Item.Cells[1].Visible=false;
   if(e.Item.ItemType!=ListItemType.Header && e.Item.ItemType!=ListItemType.Footer)
   {
    Button delbutton=new Button();
    delbutton.Text="删除";
    delbutton.ID=e.Item.Cells[1].Text+"d";
    delbutton.Click+=new EventHandler(delbutton_Click);
    e.Item.Cells[0].Controls.Add(delbutton);
    for(int i=2;i<e.Item.Cells.Count;i++)
    {
     TextBox textbox=new TextBox();
     if(!e.Item.Cells[i].Text.Equals("&nbsp;"))
      textbox.Text=e.Item.Cells[i].Text;
     textbox.Width=new Unit("88px");
     
     if(!this.InitWriteDataPopedom())
     {
      textbox.ReadOnly=true;
      e.Item.Cells[0].Visible=false;
     }
     e.Item.Cells[i].Controls.Add(textbox);
    }
   }
  }

  private void dataTable_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
  {
   
   if (e.Item.ItemType == ListItemType.Header)
   {

    e.Item.Visible=false;
    Table tb = (Table)dataTable.Controls[0];
    DataGridItem dgi1=new DataGridItem(0,0,ListItemType.Header);
    DataGridItem dgi2 = new  DataGridItem(0,0,ListItemType.Header);
    TableCell[] cell1=new TableCell[14];
    for(int i=0;i<cell1.Length;i++)
    {
     cell1[i]=new TableCell();
     if(i==7 || i==11|| i==12)
     {
      cell1[i].ColumnSpan=2;
      cell1[i].HorizontalAlign=HorizontalAlign.Center;
     }
     else
     {
      cell1[i].RowSpan=2;
     }
    }
    cell1[0].Text="删除";
    cell1[1].Text="编号";
    cell1[1].Visible=false;
    cell1[2].Text="巷号名称";
    cell1[3].Text="施工单位";
    cell1[4].Text="设计长度";
    cell1[5].Text="设计断面";
    cell1[6].Text="本月计划";
    cell1[7].Text="本日";
    cell1[8].Text="本月进度累计";
    cell1[9].Text="岩性";
    cell1[10].Text="角度";
    cell1[11].Text="本月";
    cell1[12].Text="成巷";
    cell1[13].Text="备注";
    
    for(int i=0;i<cell1.Length;i++)
    {
     dgi1.Cells.Add(cell1[i]);
    }
    TableCell[] cell2=new TableCell[6];
    for(int i=0;i<cell2.Length;i++)
    {
     cell2[i]=new TableCell();
     
    }
    cell2[0].Text="计划进度";
    cell2[1].Text="实际进度";
    cell2[2].Text="巷道累计";
    cell2[3].Text="进尺长度";
    cell2[4].Text="毛面";
    cell2[5].Text="成型";
    for(int i=0;i<cell2.Length;i++)
    {
     dgi2.Cells.Add(cell2[i]);
     
    }

    tb.Rows.AddAt(0,dgi1);
    tb.Rows.AddAt(1,dgi2);
   }
   e.Item.Cells[1].Visible=false;
  }

  private void Calendar1_SelectionChanged(object sender, System.EventArgs e)
  {
   this.Session["dataset"]=null;
   this.InitData();
  }

  private void delbutton_Click(object sender, EventArgs e)
  {
   Button tmpbutton=(Button)sender;
   string id=tmpbutton.ID;
   id=id.Remove(id.Length-1,1);
   string sqlcmd="delete from dayenter where id="+id;
   string connstring="workstation id=SERVER;packet size=4096;user id=sa;data source='.';persist security info=True;initial catalog=winneroa;password=pxh2003";
   SqlConnection conn=new SqlConnection(connstring);
   try
   {
    conn.Open();
   }
   catch(Exception err)
   {
    Response.Write(err.ToString());
   }
   SqlCommand cmd=new SqlCommand(sqlcmd,conn);
   try
   {
    cmd.ExecuteNonQuery();
    this.Session["dataset"]=null;
    this.InitData();
   }
   catch(Exception err)
   {
    Response.Write(err.ToString()+sqlcmd);
   }
   finally
   {
    conn.Close();
   }
  }
 }
}

本文地址:http://com.8s8s.com/it/it41360.htm