/// <summary> /// 确认按钮点击事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { string oldPassword = txtOldPassword.Text; string newPassword = txtNewPassword.Text; string confirm = txtConfirm.Text; if (oldPassword == "" || newPassword == "" || confirm == "") { MLMGC.COMP.Jscript.ShowMsg("请认真填写以上内容", this); return; } if (newPassword != confirm) { MLMGC.COMP.Jscript.ShowMsg("两次密码输入不一致", this); return; } E_Admin data = new E_Admin(); data.AdminID = UserID; data.Password = MLMGC.COMP.EncryptString.EncryptPassword(oldPassword); data.NewPassword = MLMGC.COMP.EncryptString.EncryptPassword(newPassword); bool flag = new T_Admin().UpdatePassword(data); MLMGC.COMP.Jscript.ShowMsg(string.Format("修改{0}!", flag?"成功":"失败"), this); }
/// <summary> /// 点击确定按钮处理事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { string name = txtName.Text.Trim(); string password = txtPassword.Text.Trim(); string confirm = txtConfirm.Text.Trim(); if (string.IsNullOrEmpty(name)) { Jscript.ShowMsg("请输入用户名", this); return; } if (string.IsNullOrEmpty(password) & type == "add") { Jscript.ShowMsg("添加用户时必须输入密码", this); return; } if (password != confirm) { Jscript.ShowMsg("两次密码输入不一致", this); return; } E_Admin data = new E_Admin(); data.AdminID = id; data.UserName = name; data.Password = string.IsNullOrEmpty(password) ? "" : EncryptString.EncryptPassword(password); //先判断一下用户名是否存在 bool b = new T_Admin().Exists(data); if (b) { Jscript.ShowMsg("用户名已存在", this); return; } bool flag = false; if (type == "add") { flag = new T_Admin().Add(data); } else if (type == "update") { flag = new T_Admin().Update(data); } if (flag) { Jscript.AlertAndRedirect(this, "操作成功", "adminlist.aspx"); } else { Jscript.ShowMsg("操作失败", this); } }
/// <summary> /// 数据绑定 /// </summary> protected void databind() { E_Admin data = new E_Admin(); data.AdminID = id; data = new T_Admin().GetModel(data); if (data != null) { txtName.Text = data.UserName; } }
/// <summary> /// 删除管理员 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-03-26</remarks> public bool Delete(E_Admin data) { SqlParameter[] parms = { new SqlParameter("@AdminID", SqlDbType.Int) }; parms[0].Value = data.AdminID; int ReturnValue; DbHelperSQL.RunProcedures("ProcB_Admin_Delete", parms, out ReturnValue); return(ReturnValue > 0); }
/// <summary> /// 判断管理员是否存在 /// </summary> /// <param name="data"></param> /// <returns>存在:true 不存在:false</returns> /// <remarks>tianzhenyun 2012-03-27</remarks> public bool Exists(E_Admin data) { SqlParameter[] parms = { new SqlParameter("@AdminID", SqlDbType.Int), new SqlParameter("@UserName", SqlDbType.VarChar, 64) }; parms[0].Value = data.AdminID; parms[1].Value = data.UserName; int ReturnValue; DbHelperSQL.RunProcedures("ProcB_Admin_Exists", parms, out ReturnValue); return(ReturnValue > 0); }
/// <summary> /// 添加管理员 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-03-26</remarks> public bool Add(E_Admin data) { SqlParameter[] parms = { new SqlParameter("@UserName", SqlDbType.VarChar, 64), new SqlParameter("@Password", SqlDbType.VarChar, 64) }; parms[0].Value = data.UserName; parms[1].Value = data.Password; int ReturnValue; DbHelperSQL.RunProcedures("ProcB_Admin_Insert", parms, out ReturnValue); return(ReturnValue > 0); }
/// <summary> /// 管理员用户修改密码 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-03-26</remarks> public bool UpdatePassword(E_Admin data) { SqlParameter[] parms = { new SqlParameter("@AdminID", SqlDbType.Int), new SqlParameter("@OldPassword", SqlDbType.VarChar, 64), new SqlParameter("@NewPassword", SqlDbType.VarChar, 64) }; parms[0].Value = data.AdminID; parms[1].Value = data.Password; parms[2].Value = data.NewPassword; int ReturnValue; DbHelperSQL.RunProcedures("ProcB_Admin_UpdatePassword", parms, out ReturnValue); return(ReturnValue > 0); }
protected void LoginButton_Click(object sender, EventArgs e) { E_Admin data = new E_Admin(); data.UserName = StringUtil.safety(UserName.Text); data.Password = EncryptString.EncryptPassword(StringUtil.safety(Password.Text.Trim())); T_Admin bll = new T_Admin(); E_Admin model = bll.UserLogin(data); if (model != null) { setSession(model.AdminID, model.UserName, model.Password); Response.Redirect("index.aspx"); } Jscript.ShowMsg("帐号或密码错误,无法登录系统!", this); }
/// <summary> /// 获取管理员对象 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-03-26</remarks> public E_Admin GetModel(E_Admin data) { SqlParameter[] parms = { new SqlParameter("@AdminID", SqlDbType.Int) }; parms[0].Value = data.AdminID; DataTable dt = DbHelperSQL.RunProcedureTable("ProcB_Admin_Select", parms); if (dt != null && dt.Rows.Count == 1) { data.UserName = dt.Rows[0]["UserName"].ToString(); data.Password = dt.Rows[0]["Password"].ToString(); return(data); } return(null); }
/// <summary> /// 删除管理员 /// </summary> private void AdminDelete() { int id; if (!int.TryParse(nv["id"], out id)) { HttpContext.Current.Response.Write("参数错误"); return; } E_Admin data = new E_Admin(); data.AdminID = id; bool flag = new T_Admin().Delete(data); HttpContext.Current.Response.Write(flag ? "1" : "0"); }
/// <summary> /// 用户登录 /// </summary> /// <param name="data">username,password</param> /// <returns></returns> public E_Admin UserLogin(E_Admin data) { SqlParameter[] parms = { new SqlParameter("@UserName", SqlDbType.VarChar, 64), new SqlParameter("@Password", SqlDbType.VarChar, 64) }; parms[0].Value = data.UserName; parms[1].Value = data.Password; DataSet ds = DbHelperSQL.RunProcedureDataSet("ProcB_Admin_Login", parms); if (Data.DataSetIsNotNull(ds)) { data.AdminID = int.Parse(ds.Tables[0].Rows[0]["AdminID"].ToString()); return(data); } return(null); }
/// <summary> /// 判断管理员是否存在 /// </summary> private void AdminExists() { int id; if (!int.TryParse(nv["id"], out id)) { HttpContext.Current.Response.Write("参数错误"); return; } string name = nv["name"]; E_Admin data = new E_Admin(); data.AdminID = id; data.UserName = name; bool flag = new T_Admin().Exists(data); HttpContext.Current.Response.Write(flag ? "1" : "0"); }
/// <summary> /// 用户登录 /// </summary> /// <param name="data">username,password,usertype</param> /// <returns></returns> public E_Admin UserLogin(E_Admin data) { dal = F_D_Admin.Create(); return(dal.UserLogin(data)); }
/// <summary> /// 删除管理员 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-03-26</remarks> public bool Delete(E_Admin data) { return(dal.Delete(data)); }
/// <summary> /// 管理员用户修改密码 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-03-26</remarks> public bool UpdatePassword(E_Admin data) { return(dal.UpdatePassword(data)); }
/// <summary> /// 判断管理员是否存在 /// </summary> /// <param name="data"></param> /// <returns>存在:true 不存在:false</returns> /// <remarks>tianzhenyun 2012-03-27</remarks> public bool Exists(E_Admin data) { return(dal.Exists(data)); }
/// <summary> /// 添加管理员 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-03-26</remarks> public bool Add(E_Admin data) { return(dal.Add(data)); }
/// <summary> /// 修改管理员信息 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-03-26</remarks> public bool Update(E_Admin data) { return(dal.Update(data)); }
/// <summary> /// 获取管理员对象 /// </summary> /// <param name="data"></param> /// <returns></returns> /// <remarks>tianzhenyun 2012-03-26</remarks> public E_Admin GetModel(E_Admin data) { return(dal.GetModel(data)); }