//修改管理员
public bool Update(XSysAdmin model)
{
string sql = string.Format(@"update XSysAdmin
set LoginName=@LoginName,LoginPWD=@LoginPWD,LoginSign=@LoginSign,Grade=@Grade,IsDisable=@IsDisable,
DisableTime=@DisableTime,SortIndex=@SortIndex,IsDeleted=@IsDeleted,CreateTime=@CreateTime,
UpdateTime=@UpdateTime
where SAID=@SAID");
DbParameter[] parms =
{
new SqlParameter("@SAID", SqlDbType.VarChar, 50)
{
Value = model.SAID
},
new SqlParameter("@LoginName", SqlDbType.VarChar, 50)
{
Value = model.LoginName
},
new SqlParameter("@LoginPWD", SqlDbType.VarChar, 1000)
{
Value = model.LoginPWD
},
new SqlParameter("@LoginSign", SqlDbType.VarChar, 50)
{
Value = model.LoginSign
},
new SqlParameter("@Grade", SqlDbType.Int)
{
Value = model.Grade
},
new SqlParameter("@IsDisable", SqlDbType.Int)
{
Value = model.IsDisable
},
new SqlParameter("@DisableTime", SqlDbType.DateTime)
{
Value = model.DisableTime
},
new SqlParameter("@SortIndex", SqlDbType.Int)
{
Value = model.SortIndex
},
new SqlParameter("@IsDeleted", SqlDbType.Int)
{
Value = model.IsDeleted
},
new SqlParameter("@CreateTime", SqlDbType.DateTime)
{
Value = model.CreateTime
},
new SqlParameter("@UpdateTime", SqlDbType.DateTime)
{
Value = model.UpdateTime
}
};
return(dbHelper.ExecuteNonQuery(sql, parms));
}
//新增管理员
public bool Add(XSysAdmin model)
{
string sql = string.Format(@"insert into XSysAdmin
(SAID,LoginName,LoginPWD,LoginSign,Grade,IsDisable,DisableTime,SortIndex,IsDeleted,CreateTime,UpdateTime)
values(@SAID,@LoginName,@LoginPWD,@LoginSign,@Grade,@IsDisable,@DisableTime,@SortIndex,@IsDeleted,@CreateTime,@UpdateTime)");
DbParameter[] parms =
{
new SqlParameter("@SAID", SqlDbType.VarChar, 50)
{
Value = model.SAID
},
new SqlParameter("@LoginName", SqlDbType.VarChar, 50)
{
Value = model.LoginName
},
new SqlParameter("@LoginPWD", SqlDbType.VarChar, 1000)
{
Value = model.LoginPWD
},
new SqlParameter("@LoginSign", SqlDbType.VarChar, 50)
{
Value = model.LoginSign
},
new SqlParameter("@Grade", SqlDbType.Int)
{
Value = model.Grade
},
new SqlParameter("@IsDisable", SqlDbType.Int)
{
Value = model.IsDisable
},
new SqlParameter("@DisableTime", SqlDbType.DateTime)
{
Value = model.DisableTime
},
new SqlParameter("@SortIndex", SqlDbType.Int)
{
Value = model.SortIndex
},
new SqlParameter("@IsDeleted", SqlDbType.Int)
{
Value = model.IsDeleted
},
new SqlParameter("@CreateTime", SqlDbType.DateTime)
{
Value = model.CreateTime
},
new SqlParameter("@UpdateTime", SqlDbType.DateTime)
{
Value = model.UpdateTime
}
};
return(dbHelper.ExecuteNonQuery(sql, parms));
}
//删除
public bool Delete(XSysAdmin model)
{
string sql = string.Format(@"update XSysAdmin set
IsDeleted=@IsDeleted,UpdateTime=@UpdateTime where
SAID=@SAID");
DbParameter[] parms =
{
new SqlParameter("@SAID", SqlDbType.VarChar, 50)
{
Value = model.SAID
},
new SqlParameter("@IsDeleted", SqlDbType.Int)
{
Value = model.IsDeleted
},
new SqlParameter("@UpdateTime", SqlDbType.DateTime)
{
Value = model.UpdateTime
}
};
return(dbHelper.ExecuteNonQuery(sql, parms));
}
//修改登录签名
public bool UpdateLoginSign(XSysAdmin model)
{
string sql = string.Format(@"update XSysAdmin
set LoginSign=@LoginSign,
UpdateTime=@UpdateTime
where SAID=@SAID");
DbParameter[] parms =
{
new SqlParameter("@SAID", SqlDbType.VarChar, 50)
{
Value = model.SAID
},
new SqlParameter("@LoginSign", SqlDbType.VarChar, 50)
{
Value = model.LoginSign
},
new SqlParameter("@UpdateTime", SqlDbType.DateTime)
{
Value = model.UpdateTime
}
};
return(dbHelper.ExecuteNonQuery(sql, parms));
}
protected void BtnSubmit_Click(object sender, EventArgs e)
{
//登录处理
string tipMsg = "";
if (txtUserName.Text.Length == 0 || txtPassword.Text.Length == 0 || txtYZM.Text.Length == 0)
{
if (txtUserName.Text.Length == 0)
{
tipMsg = "用户名不能为空！";
}
if (txtPassword.Text.Length == 0)
{
tipMsg = "密码不能为空！";
}
if (txtYZM.Text.Length == 0)
{
tipMsg = "验证码不能为空！";
}
}
else
{
if (Session["XCVCode"] != null && txtYZM.Text.ToLower() == Session["XCVCode"].ToString().ToLower())
{
XSysAdmin aobj = bllXSysAdmin.GetOneByLogin(txtUserName.Text, XCommon.Uitl.MD5(txtPassword.Text));
if (aobj != null)
{
if (aobj.IsDisable == 0)
{
string sign = Guid.NewGuid().ToString();
HttpCookie hcookie = new HttpCookie("ALOGIN");
hcookie.Values.Add("ALOGIN", sign);
aobj.LoginSign = sign;
aobj.UpdateTime = DateTime.Now;
if (bllXSysAdmin.UpdateLoginSign(aobj))
{
Response.Cookies.Add(hcookie);
tipMsg = "";
}
}
else
{
tipMsg = "此账号已被禁用，无法登陆！";
}
}
else
{
tipMsg = "用户名或者密码错误！";
}
}
else
{
tipMsg = "验证码错误！";
}
}
if (tipMsg.Length > 0)
{
Panel1.Visible = true;
lit4Tip.Text = tipMsg;
}
else
{
//登录成功
Response.Redirect("./?cmd=admin_main");
}
}
public bool Delete(XSysAdmin model)
{
return(dal.Delete(model));
}
public bool UpdateLoginSign(XSysAdmin model)
{
return(dal.UpdateLoginSign(model));
}
public bool Update(XSysAdmin model)
{
return(dal.Update(model));
}
public bool Add(XSysAdmin model)
{
return(dal.Add(model));
}
