//保存
protected void btnSave_Click(object sender, EventArgs e)
{
Spread.Model.Admin model = new Spread.Model.Admin();
Spread.BLL.Admin bll = new Spread.BLL.Admin();
string userLevel = string.Empty;
string userName = txtUserName.Text.Trim();
string userPwd = Spread.Common.DESEncrypt.Encrypt(txtUserPwd.Text.Trim(), Spread.Common.Param.EncCode);
string readName = txtReadName.Text.Trim();
string userEmail = txtUserEmail.Text.Trim();
int userType = 1;// Convert.ToInt32(rblUserType.SelectedValue);
bool isLock = Convert.ToBoolean(rblIsLock.SelectedValue);
if (bll.Exists(userName))
{
JscriptMsg(350, 230, "错误提示", "<b>出现错误了！</b>用户名已存在，请输入别的管理帐号吧！", "", "Error");
return;
}
if (userType > 1)
{
userLevel = "," + Request.Form["cbLevel"].Trim() + ",";
}
model.UserName = userName;
model.UserPwd = userPwd;
model.ReadName = readName;
model.UserEmail = userEmail;
model.UserType = userType;
model.IsLock = isLock;
model.UserLevel = userLevel;
bll.Add(model);
JscriptPrint("添加管理员成功啦！", "list.aspx", "Success");
}
//赋值操作
private void ShowInfo(int editID)
{
Spread.BLL.Admin bll = new Spread.BLL.Admin();
Spread.Model.Admin model = new Spread.Model.Admin();
model = bll.GetModel(editID);
txtUserName.Text = model.UserName;
if (model.IsLock == true)
{
this.rblIsLock.Items[1].Selected = true;
}
else
{
this.rblIsLock.Items[0].Selected = true;
}
txtReadName.Text = model.ReadName;
txtUserEmail.Text = model.UserEmail;
this.strLevel = model.UserLevel;
this.strType = model.UserType;
//if (model.UserType == 1)
//{
// this.rblUserType.Items[0].Selected = true;
//}
//if (model.UserType == 2)
//{
// this.rblUserType.Items[1].Selected = true;
//}
//if (model.UserType == 3)
//{
// this.rblUserType.Items[2].Selected = true;
//}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Spread.Model.Admin GetModel(int Id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 Id,UserName,UserPwd,ReadName,UserEmail,UserType,UserLevel,IsLock from Administrator ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters = {
new SqlParameter("@Id", SqlDbType.Int,4)};
parameters[0].Value = Id;
Spread.Model.Admin model=new Spread.Model.Admin();
DataSet ds=DbHelper.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["Id"].ToString()!="")
{
model.Id=int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
model.UserName=ds.Tables[0].Rows[0]["UserName"].ToString();
model.UserPwd=ds.Tables[0].Rows[0]["UserPwd"].ToString();
model.ReadName=ds.Tables[0].Rows[0]["ReadName"].ToString();
model.UserEmail=ds.Tables[0].Rows[0]["UserEmail"].ToString();
if(ds.Tables[0].Rows[0]["UserType"].ToString()!="")
{
model.UserType=int.Parse(ds.Tables[0].Rows[0]["UserType"].ToString());
}
model.UserLevel=ds.Tables[0].Rows[0]["UserLevel"].ToString();
if(ds.Tables[0].Rows[0]["IsLock"].ToString()!="")
{
model.IsLock=Convert.ToBoolean(ds.Tables[0].Rows[0]["IsLock"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 根据用户名取得一行数据给MODEL
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public Spread.Model.Admin GetModel(string UserName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from Administrator");
strSql.Append(" where UserName=@UserName ");
SqlParameter[] parameters = {
new SqlParameter("@UserName", SqlDbType.NVarChar,30)};
parameters[0].Value = UserName;
Spread.Model.Admin model = new Spread.Model.Admin();
DataSet ds = DbHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString();
model.UserPwd = ds.Tables[0].Rows[0]["UserPwd"].ToString();
model.ReadName = ds.Tables[0].Rows[0]["ReadName"].ToString();
model.UserEmail = ds.Tables[0].Rows[0]["UserEmail"].ToString();
model.UserType = int.Parse(ds.Tables[0].Rows[0]["UserType"].ToString());
model.UserLevel = ds.Tables[0].Rows[0]["UserLevel"].ToString();
model.IsLock = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsLock"].ToString());
}
return model;
}
protected void loginsubmit_Click(object sender, ImageClickEventArgs e)
{
string UserName = txtUserName.Text.Trim();
string UserPwd = txtUserPwd.Text.Trim();
//string Code=txtCode.Text.Trim();
string validateCode = string.Empty;
if (Session["ValidateCode"] == null)
{
lbMsg.Text = "你在登陆页面停留的时间过长，验证码已失效！";
}
else
{
validateCode = Session["ValidateCode"].ToString();
}
if (UserName.Equals("") || UserPwd.Equals(""))
{
lbMsg.Text = "请输入您要登录用户名或密码";
}
else
{
#region 记录登录次数
if (Session["AdminLoginSun"] == null)
{
Session["AdminLoginSun"] = 1;
}
else
{
Session["AdminLoginSun"] = Convert.ToInt32(Session["AdminLoginSun"]) + 1;
}
#endregion
//判断登录
#region 判断登录
//if (Code.Equals(""))
//{
// lbMsg.Text = "验证码不能为空！";
//}
//else
//{
//if (validateCode == Code.ToLower())
//{
if (Session["AdminLoginSun"] != null && Convert.ToInt32(Session["AdminLoginSun"]) > 3)
{
lbMsg.Text = "登录错误超过3次，请关闭浏览器重新登录。";
Session["AdminLoginSun"] = 1;
}
else if (bll.chkAdminLogin(UserName, UserPwd))
{
Spread.Model.Admin model = new Spread.Model.Admin();
model = bll.GetModel(UserName);
Session["AdminNo"] = model.Id;
Session["AdminName"] = model.UserName;
Session["AdminType"] = model.UserType;
Session["AdminLevel"] = model.UserLevel;
//设置超时时间
Session.Timeout = 120;
Session["AdminLoginSun"] = null;
bll.SetLoginState(model);
Response.Redirect("Default.aspx");
}
else
{
lbMsg.Text = "您输入的用户名或密码不正确";
}
//}
//else
//{
// lbMsg.Text = "您输入的验证码不正确";
//}
//}
#endregion
}
}
