//连接数据库:
<appSettings>
<add key="sqllink" value="server=yfq-001;uid=ADM;pwd=sdadm;database=DBMT50"></add>
</appSettings>
//登录
string connstr=System.Configuration.ConfigurationSettings.AppSettings["sqllink"];
SqlConnection conn=new SqlConnection(connstr);
conn.Open();
string sql="select count(*) as icount from sysoper where logname='"+this.usrname.Text+"'";
SqlCommand comm=new SqlCommand(sql,conn);
SqlDataReader dr1=comm.ExecuteReader();
dr1.Read();
string count=dr1["icount"].ToString();
dr1.Close();
if(count!="0")
{
sql="select * from sys where logname='"+this.usrname.Text+"'";
SqlCommand comm1=new SqlCommand(sql,conn);
SqlDataReader dr=comm1.ExecuteReader();
dr.Read();
string drpwd=dr["logpass"].ToString();
dr.Close();
if(drpwd==this.usrpwd.Text)
{
this.Session["logid"]=this.usrname.Text.Trim();
if(dr["PLCName"].ToString()=="")
{
this.Session["level"]="1";
}
if(dr["PLCName"].ToString()!="")
{
this.Session["level"]="2";
this.Session["plcname"]=dr["PLCName"].ToString();
}
this.Response.Redirect("main.aspx");
}
else
{
this.Response.Write("<script>alert('登录密码错误！')</script>");
}
}
if(count=="0")
{
this.Response.Write("<script>alert('没有这个用户！')</script>");
}
//框架的使用
<HTML>
<HEAD>
<TITLE>xxxxx</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</HEAD>
<frameset rows="60,*" cols="*" border="0" frameSpacing="0" frameBorder="0">
<frame name="topFrame" src="top.aspx" scrolling="no" noresize>
<frameset style="CURSOR: w-resize" border="0" frameSpacing="12" frameBorder="yes" cols="143,74%">
<frame name="leftFrame" borderColor="#99ccff" src="left.aspx">
<frame name="mainFrame" src="bottom.htm">
</frameset>
</frameset>
</HTML>
//treeview的使用
<iewc:TreeNode NavigateUrl="aa/bb.aspx" Text="设置" Target="mainFrame"></iewc:TreeNode>
//DataGrid的应用
//动态添加列
BoundColumn column1=new BoundColumn();
column1.HeaderText="用户";
column1.DataField="UsrName";
column1.HeaderStyle.Wrap=false;
column1.ItemStyle.Wrap=false;
column1.ItemStyle.HorizontalAlign=HorizontalAlign.Center;
column1.HeaderStyle.HorizontalAlign=HorizontalAlign.Center;
this.DataGrid1.Columns.Add(column1);
HyperLinkColumn linkcolumn=new HyperLinkColumn();
linkcolumn.HeaderText="帐号";
linkcolumn.DataNavigateUrlField="actid";
linkcolumn.DataTextField="actid";
//linkcolumn.DataNavigateUrlFormatString="bak.aspx?actid={0}";
linkcolumn.DataNavigateUrlFormatString="javascript:varwin=window.open('bak.aspx?id={0}');window.close()";
linkcolumn.HeaderStyle.Wrap=false;
linkcolumn.ItemStyle.Wrap=false;
linkcolumn.ItemStyle.HorizontalAlign=HorizontalAlign.Center;
linkcolumn.HeaderStyle.HorizontalAlign=HorizontalAlign.Center;
this.DataGrid1.Columns.Add(linkcolumn);
HyperLinkColumn linkcolumn1=new HyperLinkColumn();
linkcolumn1.DataNavigateUrlField="actid";
linkcolumn1.HeaderText="修改";
linkcolumn1.Text="修改";
linkcolumn1.DataNavigateUrlFormatString="edit_usr.aspx?actid={0}";
linkcolumn1.HeaderStyle.Wrap=false;
linkcolumn1.ItemStyle.Wrap=false;
linkcolumn1.Visible=true;
linkcolumn1.HeaderStyle.HorizontalAlign=HorizontalAlign.Center;
linkcolumn1.ItemStyle.HorizontalAlign=HorizontalAlign.Center;
this.DataGrid1.Columns.Add(linkcolumn1);
