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();
}
