当前位置:编程学习 > C#/ASP.NET >>

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
{
 /// <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();
 &nbs

上一个:asp.net三种重定向方法的总结
下一个:一个在ASP.NET中打印的问题

CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,