|
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 Ad [1] [2] [3] 下一页
[C语言系列]NET 中C#的switch语句的语法 [系统软件]托拽Explore中的文件到VB.net的窗口
[系统软件]Boost库在XP+Visual C++.net中的安装 [常用软件]新配色面板：Paint.Net3.0RC1官方下载
[常用软件]用内建的“Net Meeting”聊天 [VB.NET程序]Henry的VB.NET之旅（三）—共享成员
[VB.NET程序]Henry的VB.NET之旅（二）—构造与析构 [VB.NET程序]Henry的VB.NET之旅（一）—失踪的窗体
[VB.NET程序]在托盘上显示Balloon Tooltip（VB.NET） [VB.NET程序]VB.NET中关于DataGrid颜色的自定义。
|
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
