protected void btnSubmit_Click(object sender, EventArgs e) { string code = textmanagerID.Text.Trim(); string pass = textpass.Text.Trim(); pass = CY.CYWebsite.Core.Business.PasswordEncrypt.DESEncryptMethod(pass); CY.CYWebsite.Core.Business.Web_Manager manager = new CY.CYWebsite.Core.Business.Web_Manager(); IList<CY.CYWebsite.Core.Business.Web_Manager> list = manager.GetListByName(code); if (list.Count == 0 || list == null) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('该管理员信息不存在!');</script>"); textmanagerID.Text = string.Empty; textmanagerID.Focus(); } else if (pass == list[0].Manage_Pass) { Session["ManagerId"] = list[0].Id;//自增标识符:ID Session["ManagerCode"] = list[0].Manager_Code;//用户名 Session["Manager"] = list[0]; CY.CYWebsite.Core.Business.Web_Log log = new CY.CYWebsite.Core.Business.Web_Log(); log.ManagerCode = list[0].Manager_Code; log.Log_Message = list[0].Manage_RealName + "登录了系统"; log.Log_DateCreated = DateTime.Now; log.Save(); Response.Redirect("/Struct/Mine.aspx");//成功,页面跳转 } else { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('密码输入不正确!');</script>"); } }
public IList<CY.CYWebsite.Core.Business.Web_Manager> GetListByName(string managerName) { IList<CY.CYWebsite.Core.Business.Web_Manager> list = new List<CY.CYWebsite.Core.Business.Web_Manager>(); SqlServerUtility DB = new SqlServerUtility(); DB.AddParameter("@Manager_Code", SqlDbType.VarChar, managerName); SqlDataReader reader = DB.ExecuteSqlReader(SqlSelectManagerByCode); if (reader != null) { while (reader.Read()) { CY.CYWebsite.Core.Business.Web_Manager manager = new CY.CYWebsite.Core.Business.Web_Manager(); if (!reader.IsDBNull(0)) manager.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) manager.Manager_Code = reader.GetString(1); if (!reader.IsDBNull(2)) manager.Manage_Pass = reader.GetString(2); if (!reader.IsDBNull(3)) manager.Manage_RealName = reader.GetString(3); if (!reader.IsDBNull(4)) manager.Manager_AddDate = reader.GetDateTime(4); list.Add(manager); } reader.Close(); return list; } else { reader.Close(); return null; } }
protected void btnAdd_Click(object sender, EventArgs e) { CY.CYWebsite.Core.Business.Web_Manager manager = new CY.CYWebsite.Core.Business.Web_Manager(); if (!manager.IsExistCode(TextManager_Code.Text.Trim())) { Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('此管理员编号已经存在');</script>"); TextManager_Code.Text = string.Empty; TextManager_Code.Focus(); } else { manager.Manager_Code = TextManager_Code.Text.Trim();//管理员编号 manager.Manage_Pass = "******"; //默认密码888888 // TextManage_Pass.Text.Trim();//密码 manager.Manage_Pass = CY.CYWebsite.Core.Business.PasswordEncrypt.DESEncryptMethod(manager.Manage_Pass);//加密 manager.Manage_RealName = TextManage_RealName.Text.Trim();//真实姓名 manager.Manager_AddDate = DateTime.Now;//添加日期 try { manager.Save(); CY.CYWebsite.Core.Business.Web_Log log = new CY.CYWebsite.Core.Business.Web_Log(); log.ManagerCode = Manager.Manager_Code; log.Log_Message = Manager.Manage_RealName +"添加了管理员:" + manager.Manager_Code; log.Log_DateCreated = DateTime.Now; log.Save(); Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script>alert('增加管理员信息成功!');</script>"); } catch (Exception ex) { throw ex; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { lb_err.Text = ""; CY.CYWebsite.Core.Business.Web_Manager manager = new CY.CYWebsite.Core.Business.Web_Manager(); List<CY.CYWebsite.Core.Business.Web_Manager> listManager = manager.GetAllList() as List<CY.CYWebsite.Core.Business.Web_Manager>; ddl_Manager.DataSource = listManager; ddl_Manager.DataTextField = "Manage_RealName"; ddl_Manager.DataValueField = "Manager_Code"; ddl_Manager.DataBind(); ddl_Manager.Items.Insert(0, new ListItem("全部", "")); ddl_Manager.Items.Insert(ddl_Manager.Items.Count, new ListItem("已删除", "已删除")); Bind(); } catch (Exception ex) { lb_err.Text = ex.Message; } } }
public IList<CY.CYWebsite.Core.Business.Web_Manager> GetSearchByName(string name) { SqlServerUtility db = new SqlServerUtility(); db.AddParameter("@Manager_Code", SqlDbType.VarChar, name); IList<CY.CYWebsite.Core.Business.Web_Manager> list = new List<CY.CYWebsite.Core.Business.Web_Manager>(); SqlDataReader reader = db.ExecuteSqlReader(SqlSeach); if (reader != null) { CY.CYWebsite.Core.Business.Web_Manager m; while (reader.Read()) { m = new CY.CYWebsite.Core.Business.Web_Manager(); if (!reader.IsDBNull(0)) { m = CY.CYWebsite.Core.Business.Web_Manager.Load(reader.GetInt32(0)); list.Add(m); } } reader.Close(); } return list; }
private void Bind() { CY.CYWebsite.Core.Business.Web_Manager manager; IList<CY.CYWebsite.Core.Business.Web_Manager> list; if (textSearch.Text.Trim() == string.Empty) { manager = new CY.CYWebsite.Core.Business.Web_Manager(); list = manager.GetAllList(); } else { manager=new CY.CYWebsite.Core.Business.Web_Manager(); string name = textSearch.Text.Trim(); list =manager.GetSearchByName(name); } gvManager.DataSource = list; gvManager.DataBind(); }