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