protected void Page_Load(object sender, EventArgs e) { this.Panel1.Visible = false; if(IsPostBack){ string account = Request.Form["userAccount"]; if (account == "" || account == null) { this.Panel1.Visible = true; controlName = "userAccount"; msg = "账号不能为空!"; } else { string pwd = Request.Form["userPwd"]; if (pwd == null || pwd == "") { this.Panel1.Visible = true; controlName = "userPwd"; msg = "密码不能为空!"; } else { LxyOledb oledb = new LxyOledb(); oledb.Conn.Open(); oledb.Cmd.CommandText = "select * from User_tb where UserAccount=@account or UserNumber=@acountNum"; oledb.Cmd.Parameters.AddWithValue("@account" ,account); oledb.Cmd.Parameters.AddWithValue("@accountNum", account); oledb.Dr = oledb.Cmd.ExecuteReader(); if (oledb.Dr.Read()) { //账号存在,验证密码 if (oledb.Dr["UserPwd"].ToString() == SRLib.Des.EncryptDES(pwd, "SatanRabbit")) { //密码正确,设置session Session["lxyLabUserName"] = oledb.Dr["UserName"].ToString(); Session["lxyLabUserNumber"] = oledb.Dr["UserNumber"].ToString(); Session["lxyLabUserID"] = oledb.Dr["UserID"].ToString(); oledb.Conn.Close(); Response.Redirect("Default.aspx"); } else { this.Panel1.Visible = true; controlName = "userPwd"; msg = "密码错误!"; } } else { this.Panel1.Visible = true; controlName = "userAccount"; msg = "账号不存在!!"; } oledb.Conn.Close(); } } } }
protected void Page_Load(object sender, EventArgs e) { this.Panel1.Visible = false; if (IsPostBack) { string account = Request.Form["userAccount"]; if (account == "" || account == null) { this.Panel1.Visible = true; controlName = "userAccount"; msg = "账号不能为空!"; } else { string pwd = Request.Form["userPwd"]; if (pwd == null || pwd == "") { this.Panel1.Visible = true; controlName = "userPwd"; msg = "密码不能为空!"; } else { LxyOledb oledb = new LxyOledb(); oledb.Conn.Open(); oledb.Cmd.CommandText = "select * from Admin_tb where AdminAccount=@account "; oledb.Cmd.Parameters.AddWithValue("@account", account); oledb.Cmd.Parameters.AddWithValue("@accountNum", account); oledb.Dr = oledb.Cmd.ExecuteReader(); if (oledb.Dr.Read()) { //账号存在,验证密码 if (oledb.Dr["AdminPWD"].ToString() == pwd) { //密码正确,设置session Session["AdminID"] = oledb.Dr["AdminID"].ToString(); oledb.Conn.Close(); Response.Redirect("admin.aspx"); } else { this.Panel1.Visible = true; controlName = "userPwd"; msg = "密码错误!"; } } else { this.Panel1.Visible = true; controlName = "userAccount"; msg = "账号不存在!!"; } oledb.Conn.Close(); } } } }
/* 返回json格式 * id:节点id,对载入远程数据很重要。 text:显示在节点的文本。 state:节点状态,'open' or 'closed',默认为'open'。当设置为'closed'时,拥有子节点的节点将会从远程站点载入它们。 checked:表明节点是否被选择。 attributes:可以为节点添加的自定义属性。 children:子节点,必须用数组定义。 */ public void ProcessRequest(HttpContext context) { //查询数据库获取实验室列表 LxyOledb oledb = new LxyOledb(); oledb.Conn.Open(); oledb.Cmd.CommandText = "select * from Term_tb order by TermStartDay desc"; oledb.Dr = oledb.Cmd.ExecuteReader(); JsonData jd = new JsonData(); while(oledb.Dr.Read()){ JsonData jdWeek = new JsonData(); jdWeek["id"] = Convert.ToInt32(oledb.Dr["TermID"]); jdWeek["text"] = oledb.Dr["TermName"].ToString(); jdWeek["TermStartDay"] = ((DateTime)oledb.Dr["TermStartDay"]).ToString("yyyy-MM-dd"); jdWeek["TermWeeks"] = Convert.ToInt32(oledb.Dr["TermWeeks"]); jdWeek["iconCls"] = "icon-date"; jdWeek["isCurrent"] = oledb.Dr["TermIsCurrent"].ToString(); jd.Add(jdWeek); } string jdString = jd.ToJson(); context.Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); context.Response.Write(jdString); context.Response.End(); }
protected void Page_Load(object sender, EventArgs e) { if (IsPostBack) { int status = 2; string msg = "未知错误,请重试"; //处理提交的数据 string userName = Request.Form["userName"]; if (userName == null || userName == "") { status = 1;//有未填写项 msg = "请填写您的姓名!"; Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); Response.Write(ReturnMsg(status, msg)); Response.End(); } string userPwd = Request.Form["userPwd"]; if (userPwd == null || userPwd == "") { status = 1;//有未填写项 msg = "请填写密码!"; Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); Response.Write(ReturnMsg(status, msg)); Response.End(); } string userPwdCompare = Request.Form["userPwdCpmpare"]; if (userPwdCompare == null || userPwdCompare == "") { status = 1; msg = "请确认密码!"; Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); Response.Write(ReturnMsg(status, msg)); Response.End(); } if (userPwd != userPwdCompare) { //出错,提示密码不一致! status = 2; msg = "密码不一致,请确认密码!"; Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); Response.Write(ReturnMsg(status, msg)); Response.End(); } else { userPwd = SRLib.Des.EncryptDES(userPwd, "SatanRabbit"); } string userAccount = Request.Form["userAccount"]; if (userAccount == null || userAccount == "") { status = 1; msg = "请填写邮箱!"; Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); Response.Write(ReturnMsg(status, msg)); Response.End(); } userAccount = userAccount.ToLower(); string userNumber = Request.Form["userNumber"]; if (userNumber == "" || userNumber == null) { status = 1; msg = "请填写教工卡号或学号!"; Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); Response.Write(ReturnMsg(status, msg)); Response.End(); } string userTel = Request.Form["userTel"]; if (userTel == null || userTel == "") { status = 1; msg = "请填写您的联系电话!"; Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); Response.Write(ReturnMsg(status, msg)); Response.End(); } string userCollege = Request.Form["userCollege"]; if (userCollege == null || userCollege == "") { status = 1; msg = "请填写您所在学院或部门!"; Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); Response.Write(ReturnMsg(status, msg)); Response.End(); } int userIdentity = 3;//未知身份 try { userIdentity = Convert.ToInt32(Request.Form["userIdentity"]); } catch (Exception ex) { status = 2; msg = "你的身份填写有误!请核对!"; Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); Response.Write(ReturnMsg(status, msg)); Response.End(); } //保存数据 LxyOledb oledb = new LxyOledb(); oledb.Conn.Open(); //检查邮箱是否存在 oledb.Cmd.CommandText = "select * from User_tb where UserNumber=@userNumber or UserAccount=@userAccount"; oledb.Cmd.Parameters.Clear(); oledb.Cmd.Parameters.AddWithValue("@userNumber", userNumber); oledb.Cmd.Parameters.AddWithValue("@userAccount", userAccount); oledb.Dr = oledb.Cmd.ExecuteReader(); if (oledb.Dr.Read()) { if (oledb.Dr["UserAccount"].ToString() == userAccount) { oledb.Conn.Close(); Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); Response.Write(ReturnMsg(2, "该邮箱账号已经存在,请更换邮箱或直接用此邮箱登录!")); Response.End(); } else { if (oledb.Dr["UserNumber"].ToString() == userNumber) { oledb.Conn.Close(); Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); Response.Write(ReturnMsg(2,"该教工卡号或学号已经被注册!请更换或直接用此账号登录!")); Response.End(); } } } else { oledb.Dr.Dispose(); //保存账号 oledb.Cmd.CommandText = "INSERT INTO User_tb (UserName,UserPwd,UserAccount,UserNumber,UserTel,UserIdentity,UserCollege) VALUES (@userName,@userPwd,@userAccount,@userNumber,@userTel,@userIdentity,@userCollege)"; oledb.Cmd.Parameters.Clear(); oledb.Cmd.Parameters.AddWithValue("@userName", userName); oledb.Cmd.Parameters.AddWithValue("@userPwd", userPwd); oledb.Cmd.Parameters.AddWithValue("@userAccount", userAccount); oledb.Cmd.Parameters.AddWithValue("@userNumber", userNumber); oledb.Cmd.Parameters.AddWithValue("@userTel", userTel); oledb.Cmd.Parameters.AddWithValue("@userIdentity", userIdentity); oledb.Cmd.Parameters.AddWithValue("@userCollege", userCollege); try { oledb.Cmd.ExecuteNonQuery(); Session["lxyLabUserName"] = userName; Session["lxyLabUserNumber"] = userNumber; oledb.Conn.Close(); } catch (Exception ex) { oledb.Conn.Close(); Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); Response.Write(ReturnMsg(2, ex.Message)); Response.End(); } Response.AddHeader("Content-Type", "text/html; charset=UTF-8"); Response.Write(ReturnMsg(0, "注册成功!")); Response.End(); } oledb.Conn.Close(); } }