asp.net datagrid实现多层表头

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
{
///

1<summary>   
2/// dayenter 的摘要说明。   
3/// </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

  1<e.cells.count #region="" +"',";="" +((textbox)e.cells[j].controls[0]).text="" +this.calendar1.selecteddate.toshortdatestring()+"')";="" ;j++)="" <summary="" asp.net="" base.oninit(e);="" catch(exception="" cmd="new" cmd.executenonquery();="" codegen:="" conn.close();="" conn.open();="" e)="" err)="" finally="" initializecomponent();="" oninit(eventargs="" override="" protected="" response.write(err.tostring());="" response.write(err.tostring()+sqlcmd);="" return;="" sqlcmd+="'" sqlcommand="" sqlcommand(sqlcmd,conn);="" this.initdata();="" this.session["dataset"]="null;" try="" void="" web="" {="" }="" 窗体设计器所必需的。="" 窗体设计器生成的代码="" 该调用是="">   
  2/// 设计器支持所需的方法 - 不要使用代码编辑器修改   
  3/// 此方法的内容。   
  4///    
  5private void InitializeComponent()   
  6{   
  7this.addLineButton.Click += new System.EventHandler(this.addLineButton_Click);   
  8this.updateButton.Click += new System.EventHandler(this.updateButton_Click);   
  9this.Calendar1.SelectionChanged += new System.EventHandler(this.Calendar1_SelectionChanged);   
 10this.dataTable.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dataTable_ItemCreated);   
 11this.dataTable.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dataTable_ItemDataBound);   
 12this.Load += new System.EventHandler(this.Page_Load); 
 13
 14}   
 15#endregion 
 16
 17private void addLineButton_Click(object sender, System.EventArgs e)   
 18{   
 19this.SaveData();   
 20this.AddLine();   
 21  
 22} 
 23
 24private void updateButton_Click(object sender, System.EventArgs e)   
 25{   
 26this.SaveData();   
 27} 
 28
 29private void dataTable_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)   
 30{   
 31  
 32  
 33e.Item.Cells[1].Visible=false;   
 34if(e.Item.ItemType!=ListItemType.Header &amp;&amp; e.Item.ItemType!=ListItemType.Footer)   
 35{   
 36Button delbutton=new Button();   
 37delbutton.Text="删除";   
 38delbutton.ID=e.Item.Cells[1].Text+"d";   
 39delbutton.Click+=new EventHandler(delbutton_Click);   
 40e.Item.Cells[0].Controls.Add(delbutton);   
 41for(int i=2;i&lt;e.Item.Cells.Count;i++)   
 42{   
 43TextBox textbox=new TextBox();   
 44if(!e.Item.Cells[i].Text.Equals("&amp;nbsp;"))   
 45textbox.Text=e.Item.Cells[i].Text;   
 46textbox.Width=new Unit("88px");   
 47  
 48if(!this.InitWriteDataPopedom())   
 49{   
 50textbox.ReadOnly=true;   
 51e.Item.Cells[0].Visible=false;   
 52}   
 53e.Item.Cells[i].Controls.Add(textbox);   
 54}   
 55}   
 56} 
 57
 58private void dataTable_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)   
 59{   
 60  
 61if (e.Item.ItemType == ListItemType.Header)   
 62{ 
 63
 64e.Item.Visible=false;   
 65Table tb = (Table)dataTable.Controls[0];   
 66DataGridItem dgi1=new DataGridItem(0,0,ListItemType.Header);   
 67DataGridItem dgi2 = new DataGridItem(0,0,ListItemType.Header);   
 68TableCell[] cell1=new TableCell[14];   
 69for(int i=0;i&lt;cell1.Length;i++)   
 70{   
 71cell1[i]=new TableCell();   
 72if(i==7 || i==11|| i==12)   
 73{   
 74cell1[i].ColumnSpan=2;   
 75cell1[i].HorizontalAlign=HorizontalAlign.Center;   
 76}   
 77else   
 78{   
 79cell1[i].RowSpan=2;   
 80}   
 81}   
 82cell1[0].Text="删除";   
 83cell1[1].Text="编号";   
 84cell1[1].Visible=false;   
 85cell1[2].Text="巷号名称";   
 86cell1[3].Text="施工单位";   
 87cell1[4].Text="设计长度";   
 88cell1[5].Text="设计断面";   
 89cell1[6].Text="本月计划";   
 90cell1[7].Text="本日";   
 91cell1[8].Text="本月进度累计";   
 92cell1[9].Text="岩性";   
 93cell1[10].Text="角度";   
 94cell1[11].Text="本月";   
 95cell1[12].Text="成巷";   
 96cell1[13].Text="备注";   
 97  
 98for(int i=0;i&lt;cell1.Length;i++)   
 99{   
100dgi1.Cells.Add(cell1[i]);   
101}   
102TableCell[] cell2=new TableCell[6];   
103for(int i=0;i&lt;cell2.Length;i++)   
104{   
105cell2[i]=new TableCell();   
106  
107}   
108cell2[0].Text="计划进度";   
109cell2[1].Text="实际进度";   
110cell2[2].Text="巷道累计";   
111cell2[3].Text="进尺长度";   
112cell2[4].Text="毛面";   
113cell2[5].Text="成型";   
114for(int i=0;i&lt;cell2.Length;i++)   
115{   
116dgi2.Cells.Add(cell2[i]);   
117  
118} 
119
120tb.Rows.AddAt(0,dgi1);   
121tb.Rows.AddAt(1,dgi2);   
122}   
123e.Item.Cells[1].Visible=false;   
124} 
125
126private void Calendar1_SelectionChanged(object sender, System.EventArgs e)   
127{   
128this.Session["dataset"]=null;   
129this.InitData();   
130} 
131
132private void delbutton_Click(object sender, EventArgs e)   
133{   
134Button tmpbutton=(Button)sender;   
135string id=tmpbutton.ID;   
136id=id.Remove(id.Length-1,1);   
137string sqlcmd="delete from dayenter where id="+id;   
138string connstring="workstation id=SERVER;packet size=4096;user id=sa;data source='.';persist security info=True;initial catalog=winneroa;password=pxh2003";   
139SqlConnection conn=new SqlConnection(connstring);   
140try   
141{   
142conn.Open();   
143}   
144catch(Exception err)   
145{   
146Response.Write(err.ToString());   
147}   
148SqlCommand cmd=new SqlCommand(sqlcmd,conn);   
149try   
150{   
151cmd.ExecuteNonQuery();   
152this.Session["dataset"]=null;   
153this.InitData();   
154}   
155catch(Exception err)   
156{   
157Response.Write(err.ToString()+sqlcmd);   
158}   
159finally   
160{   
161conn.Close();   
162}   
163}   
164}   
165}</e.cells.count>
Published At
Categories with Web编程
Tagged with
comments powered by Disqus