📄 default.aspx.cs
字号:
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;
namespace stu
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
//定义默认控件声明
protected stu Utility;
//登录表单、变量等的声名
protected System.Web.UI.WebControls.TextBox Login_name;
protected System.Web.UI.WebControls.TextBox Login_password;
protected System.Web.UI.WebControls.Button Login_login;
protected System.Web.UI.HtmlControls.HtmlTableRow Login_trname;
protected System.Web.UI.HtmlControls.HtmlTableRow Login_trpassword;
protected System.Web.UI.WebControls.Label Login_labelname;
protected System.Web.UI.WebControls.Label Login_message;
protected System.Web.UI.HtmlControls.HtmlInputHidden Login_querystring;
protected System.Web.UI.HtmlControls.HtmlInputHidden Login_ret_page;
//表格表单、相关控制变量声名
protected System.Web.UI.HtmlControls.HtmlTableRow Grid_no_records;
protected System.Web.UI.HtmlControls.HtmlTableRow AdminList_Title;
protected System.Web.UI.HtmlControls.HtmlTableRow AdminStu_Title;
protected System.Web.UI.HtmlControls.HtmlTableRow AdminClass_Title;
protected string Grid_sSQL;
protected string Grid_sCountSQL;
protected int Grid_CountPage;
protected System.Web.UI.WebControls.Repeater Grid_Repeater;
protected int i_Grid_curpage=1;
//查询表单、相关控制变量声名
protected System.Web.UI.WebControls.Button Search_search_button;
protected System.Web.UI.WebControls.DropDownList Search_dep_id;
protected System.Web.UI.WebControls.TextBox Search_name;
protected System.Web.UI.WebControls.TextBox Search_email;
//优秀学生记录表单、相关变量声名
protected System.Web.UI.HtmlControls.HtmlTableRow EmpMonth_no_records;
protected string EmpMonth_sSQL;
protected string EmpMonth_sCountSQL;
protected int EmpMonth_CountPage;
protected System.Web.UI.WebControls.Repeater EmpMonth_Repeater;
protected int i_EmpMonth_curpage=1;
//每个相应表单事件保护字符串
protected string Grid_FormAction=".aspx?";
protected string Search_FormAction="Default.aspx?";
protected System.Web.UI.WebControls.Label EmpMonthForm_Title;
protected System.Web.UI.WebControls.Label SearchForm_Title;
protected System.Web.UI.WebControls.Label GridForm_Title;
protected System.Web.UI.WebControls.LinkButton Grid_Column_name;
protected System.Web.UI.WebControls.LinkButton Grid_Column_title;
protected System.Web.UI.WebControls.LinkButton Grid_Column_dep_id;
protected System.Web.UI.WebControls.LinkButton Grid_Column_work_phone;
protected System.Web.UI.WebControls.LinkButton Grid_Column_email;
protected System.Web.UI.WebControls.Label LoginForm_Title;
protected System.Web.UI.WebControls.HyperLink Form_Field2;
protected System.Web.UI.WebControls.HyperLink Form_Field1;
protected string EmpMonth_FormAction=".aspx?";
public WebForm1()
{
this.Init += new System.EventHandler(Page_Init);
}
//默认自定义控件声名结束
public void ValidateNumeric(object source, ServerValidateEventArgs args)
{
try
{
Decimal temp=Decimal.Parse(args.Value);
args.IsValid=true;
}
catch
{
args.IsValid=false; }
}
// Default Show begin
protected void Page_Load(object sender, EventArgs e)
{
Utility=new stu(this);
if (Session["UserID"] != null && Int16.Parse(Session["UserID"].ToString()) > 0)
Login_logged = true;
//如果初次装载页面，执行Page_Show
if (!IsPostBack)
{
AdminList_Title.Visible = false;
AdminStu_Title.Visible = false;
AdminClass_Title.Visible = false;
Page_Show(sender, e);
}
}
//关闭页面过程
protected void Page_Unload(object sender, EventArgs e)
{
if(Utility!=null) Utility.DBClose();
}
//窗口中控件定义事件处理过程
protected void Page_Init(object sender, EventArgs e)
{
InitializeComponent();
}
private void InitializeComponent()
{
this.Search_search_button.Click += new System.EventHandler(this.Search_search_Click);
this.Login_login.Click += new System.EventHandler(this.Login_login_Click);
this.Unload += new System.EventHandler(this.Page_Unload);
this.Load += new System.EventHandler(this.Page_Load);
}
//页面中的数据显示过程
protected void Page_Show(object sender, EventArgs e)
{
Grid_Bind();
Search_Show();
EmpMonth_Bind();
Login_Show();
}
// Default Show end
//完成表单初始化
//定义登录的控制变量，初始值为false，保证安全管理
protected bool Login_logged = false;
//登录表单显示过程函数
void Login_Show()
{
if (Login_logged)
{
//登录成功的处理
Login_login.Text = "退出";
Login_trpassword.Visible = false;
Login_trname.Visible = false;
Login_labelname.Visible = true;
Login_labelname.Text = Utility.Dlookup("stu", "login", "stu_id=" + Session["UserID"]) + " ";
Utility=new stu(this);
if (Utility.CheckSecurity(3))
{
AdminList_Title.Visible = true;
AdminStu_Title.Visible = true;
AdminClass_Title.Visible = true;
}
}
else
{
//未登录的处理
Login_login.Text = "登录";
Login_trpassword.Visible = true;
Login_trname.Visible = true;
Login_labelname.Visible = false;
AdminList_Title.Visible = false;
AdminStu_Title.Visible = false;
AdminClass_Title.Visible = false;
}
}
//验证登录事件
void Login_login_Click(Object Src, EventArgs E)
{
if (Login_logged)
{
//已经登录成功则退出登录
Login_logged = false;
Session["UserID"] = 0;
Session["UserRights"] = 0;
Login_Show();
}
else
{
//进行登录验证
int iPassed = Convert.ToInt32(Utility.Dlookup("stu", "count(*)", "login ='" + Login_name.Text + "' and password='" + stu.Quote(Login_password.Text) + "'"));
if (iPassed > 0)
{
Login_message.Visible = false;
Session["UserID"] = Convert.ToInt32(Utility.Dlookup("stu", "stu_id", "login ='" + Login_name.Text + "' and password='" + stu.Quote(Login_password.Text) +"'"));
Login_logged = true;
Session["UserRights"] = Convert.ToInt32(Utility.Dlookup("stu", "stu_level", "login ='" + Login_name.Text + "' and password='" + stu.Quote(Login_password.Text) + "'"));
string sQueryString = Utility.GetParam("querystring");
string sPage = Utility.GetParam("ret_page");
if (! sPage.Equals(Request.ServerVariables["SCRIPT_NAME"]) && sPage.Length > 0)
{
Response.Redirect(sPage + "?" + sQueryString);
}
else
{
Response.Redirect(Search_FormAction);
}
}
else
{
Login_message.Visible = true;
}
// Login Login end
}
}
//定义每页显示记录常数
const int Grid_PAGENUM = 20;
public void Grid_Repeater_ItemDataBound(Object Sender, RepeaterItemEventArgs e)
{
// Grid Show Event begin
if (e.Item.ItemType==ListItemType.Item || e.Item.ItemType==ListItemType.AlternatingItem )
{
((Label)e.Item.FindControl("Grid_email")).Text ="<a href=\"mailto:" + ((DataRowView)e.Item.DataItem )["e_email"].ToString() + "\">" + ((DataRowView)e.Item.DataItem )["e_email"].ToString() + "</a>";
}
// Grid Show Event end
}
ICollection Grid_CreateDataSource()
{
//开始用于显示数据
Grid_sSQL = "";
Grid_sCountSQL = "";
string sWhere = "", sOrder = "";
bool HasParam = false;
//建立排序方式(逆序或正序)
sOrder = " order by e.name Asc";
if(Utility.GetParam("FormGrid_Sorting").Length>0&&!IsPostBack)
{
ViewState["SortColumn"]=Utility.GetParam("FormGrid_Sorting");
ViewState["SortDir"]="ASC";}
if(ViewState["SortColumn"]!=null) sOrder = " ORDER BY " + ViewState["SortColumn"].ToString()+" "+ViewState["SortDir"].ToString();
//建立学生属性
System.Collections.Specialized.StringDictionary Params =new System.Collections.Specialized.StringDictionary();
if(!Params.ContainsKey("class_id"))
{
string temp=Utility.GetParam("class_id");
if (Utility.IsNumeric(null,temp) && temp.Length>0) { temp = stu.ToSQL(temp, stu.FIELD_TYPE_Number);}
else {temp = "";}
Params.Add("class_id",temp);}
if(!Params.ContainsKey("email"))
{
string temp=Utility.GetParam("email");
Params.Add("email",temp);}
if(!Params.ContainsKey("name"))
{
string temp=Utility.GetParam("name");
Params.Add("name",temp);}
if (Params["class_id"].Length>0)
{
HasParam = true;
sWhere +="e.[class_id]=" + Params["class_id"];
}
if (Params["email"].Length>0)
{
if (sWhere.Length >0) sWhere +=" and ";
HasParam = true;
sWhere +="e.[email] like '%" + Params["email"].Replace( "'", "''") + "%'";
}
if (Params["name"].Length>0)
{
if (sWhere.Length >0) sWhere +=" and ";
HasParam = true;
sWhere +="e.[name] like '%" + Params["name"].Replace( "'", "''") + "%'";
}
if(HasParam)
sWhere = " AND (" + sWhere + ")";
//定义Sql语句
Grid_sSQL = "select [e].[class_id] as e_class_id, " +
"[e].[email] as e_email, " +
"[e].[stu_id] as e_student_id, " +
"[e].[name] as e_name, " +
"[e].[Bth] as e_no, " +
"[e].[business] as e_business, " +
"[e].[ph] as e_work_ph, " +
"[d].[class_id] as d_class_id, " +
"[d].[class_name] as d_class " +
" from [stu] e, [class] d" +
" where [d].[class_id]=e.[class_id] ";
//装配出完整的Sql语句
Grid_sSQL = Grid_sSQL + sWhere + sOrder;
SqlDataAdapter command = new SqlDataAdapter(Grid_sSQL, Utility.Connection);
DataSet ds = new DataSet();
command.Fill(ds, 0, Grid_PAGENUM, "Grid");
DataView Source;
Source = new DataView(ds.Tables[0]);
if (ds.Tables[0].Rows.Count == 0)
{
Grid_no_records.Visible = true;
}
else
{
Grid_no_records.Visible = false;
}
return Source;
//表格显示数据完成
}
//数据绑定过程
void Grid_Bind()
{
Grid_Repeater.DataSource = Grid_CreateDataSource();
Grid_Repeater.DataBind();
}
//记录排序方式改变
protected void Grid_SortChange(Object Src, EventArgs E)
{
if(ViewState["SortColumn"]==null || ViewState["SortColumn"].ToString()!=((LinkButton)Src).CommandArgument)
{
ViewState["SortColumn"]=((LinkButton)Src).CommandArgument;
ViewState["SortDir"]="ASC";
}
else
{
ViewState["SortDir"]=ViewState["SortDir"].ToString()=="ASC"?"DESC":"ASC";
}
Grid_Bind();
}
//查询显示时获取数据过程
void Search_Show()
{
Utility.buildListBox(Search_dep_id.Items,"select class_id,class_name from class order by 2","class_id","class_name","ALL Class","");
string s;
s=Utility.GetParam("dep_id");
try
{
Search_dep_id.SelectedIndex=Search_dep_id.Items.IndexOf(Search_dep_id.Items.FindByValue(s));
}
catch{}
s=Utility.GetParam("name");
Search_name.Text = s;
s=Utility.GetParam("email");
Search_email.Text = s;
}
//查询提交过程
void Search_search_Click(Object Src, EventArgs E)
{
string sURL;
sURL = Search_FormAction + "class_id="+Search_dep_id.SelectedItem.Value+"&"
+ "name="+Search_name.Text+"&"
+ "email="+Search_email.Text+"&";
//定制查询语句
sURL += "";
Response.Redirect(sURL);
}
//最多显示记录数
const int EmpMonth_PAGENUM = 20;
public void EmpMonth_Repeater_ItemDataBound(Object Sender, RepeaterItemEventArgs e)
{
//显示标题人物的图片
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
((Label)e.Item.FindControl("EmpMonth_picture")).Text ="<img border=0 src=\"images/" + ((DataRowView)e.Item.DataItem )["e_picture"].ToString() + "\">";
}
}
//查询符合“优秀学生”的记录集合
ICollection EmpMonth_CreateDataSource()
{
EmpMonth_sSQL = "";
EmpMonth_sCountSQL = "";
string sWhere = "", sOrder = "";
bool HasParam = false;
System.Collections.Specialized.StringDictionary Params =new System.Collections.Specialized.StringDictionary();
//组合相应的查询Sql语句
sWhere = " WHERE super=1";
EmpMonth_sSQL = "select [e].[name] as e_name, [e].[stu_id] as e_student_id," +
"[e].[picture] as e_picture" +
" from [stu] e ";
EmpMonth_sSQL = EmpMonth_sSQL + sWhere + sOrder;
//联结数据库，实现查询
SqlDataAdapter command = new SqlDataAdapter(EmpMonth_sSQL, Utility.Connection);
DataSet ds = new DataSet();
command.Fill(ds, 0, EmpMonth_PAGENUM, "EmpMonth");
DataView Source;
Source = new DataView(ds.Tables[0]);
if (ds.Tables[0].Rows.Count == 0)
{
EmpMonth_no_records.Visible = true;
}
else
{
EmpMonth_no_records.Visible = false;
}
return Source;
}
//绑定查询结果
void EmpMonth_Bind()
{
EmpMonth_Repeater.DataSource = EmpMonth_CreateDataSource();
EmpMonth_Repeater.DataBind();
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -