public ActionResult UserAdd(CIUser user)
{
user.PassWord = EncryptHelper.MD5(user.PassWord);
user.RegTime = DateTime.Now;
_userService.InsertUser(user);
return(Redirect(Url.Action("Userslist", "Users")));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="userid"></param>
/// <returns></returns>
public int Delete(CIUser CIUser)
{
string cmdText = "delete from CIUser where UserName=@UserName";
using (var conn = new DapperHelper().OpenConnection())
{
return(conn.Execute(cmdText, new { UserName = CIUser.UserName }));
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="CIUser"></param>
/// <returns></returns>
public int Insert(CIUser CIUser)
{
string cmdText = @"INSERT INTO CIUser (UserName,Email,UTMPName,Mobile,Role,PassWord,Status,RegTime,FullName,OrgCode) VALUES
(@UserName,@Email,@UTMPName,@Mobile,@Role,@PassWord,@Status,@RegTime,@FullName,@OrgCode)";
using (var conn = new DapperHelper().OpenConnection())
{
return(conn.Execute(cmdText, CIUser));
}
}
public ProjectModel()
{
Project = new CIProject();
PageList = new ProjectPageList();
ProjectList = new List <CIProject>();
User = new CIUser();
CIReview = new CIReview();
reviewlist = new List <CIReview>();
Release = new CIRelease();
ReleaseList = new List <CIRelease>();
StatusSelectItem = new List <SelectListItem>();
}
public ActionResult UserEdit(CIUser user)
{
if (string.IsNullOrEmpty(user.PassWord))
{
user.PassWord = PressRequest.GetFormString("hidPwd");
}
else
{
user.PassWord = EncryptHelper.MD5(user.PassWord);
}
_userService.UpdateUserOrg(user);
return(Redirect(Url.Action("Userslist", "Users")));
}
public ActionResult CreateUser()
{
var model = new CIUser();
model.UserName = PressRequest.GetFormString("username");
model.PassWord = EncryptHelper.MD5(PressRequest.GetFormString("password"));
model.FullName = PressRequest.GetFormString("fullname");
model.RegTime = DateTime.Now;
model.Role = PressRequest.GetFormString("role");
_userService.InsertUser(model);
return(Redirect(Url.Action("login", "home")));
}
/// <summary>
/// 更新开发人员所属小组
/// </summary>
/// <param name="CIUser"></param>
/// <returns></returns>
public int UpdateUserOrg(CIUser CIUser)
{
string cmdText = @"UPDATE CIUser SET
Role = @Role,
PassWord = @PassWord,
FullName = @FullName,
OrgCode = @OrgCode
WHERE UserName=@UserName" ;
using (var conn = new DapperHelper().OpenConnection())
{
return(conn.Execute(cmdText, CIUser));
}
}
public ReviewModel()
{
ReviewList = new List <CIReview>();
Review = new CIReview();
PageList = new ReviewPageList();
StatusSelectItem = new List <SelectListItem>();
MethodSelectItem = new List <SelectListItem>();
User = new CIUser();
UserList = new List <CIUser>();
IfReviewSelectItem = new List <SelectListItem>();
ReviewPro = new CIReviewProblem();
DemandList = new List <CIDemand>();
IfSolveSelectItem = new List <SelectListItem>();
DemandSelectItem = new List <SelectListItem>();
Demand = new CIDemand();
DemandList = new List <CIDemand>();
}
/// <summary>
/// 更新
/// </summary>
/// <param name="CIUser"></param>
/// <returns></returns>
public int Update(CIUser CIUser)
{
string cmdText = @"UPDATE CIUser SET
Email = @Email,
UTMPName = @UTMPName,
Mobile = @Mobile,
Role = @Role,
PassWord = @PassWord,
FullName = @FullName,
Status = @Status,
OrgCode = @OrgCode
WHERE UserName=@UserName" ;
using (var conn = new DapperHelper().OpenConnection())
{
return(conn.Execute(cmdText, CIUser));
}
}
protected virtual void ValidateLogin(ActionExecutingContext filterContext)
{
var cookie = System.Web.HttpContext.Current.Request.Cookies[CookieUser];
if (cookie != null)
{
CurrentUserId = TypeConverter.ObjectToString(cookie["username"]);
CurrentUser = (new UserService()).GetUser(CurrentUserId);
ViewBag.Role = CurrentUser.Role;
if (string.IsNullOrEmpty(CurrentUserId))
{
filterContext.Result = RedirectToAction("login", "home", new { area = "admin" });
}
}
else
{
//filterContext.Result = RedirectToAction("login", "home", new { area = "admin" });
}
}
/// <summary>
/// 登录验证
/// </summary>
public bool VerifyLogin()
{
CIUser user = null;
string userName = PressRequest.GetFormString("username");
string password = EncryptHelper.MD5(PressRequest.GetFormString("password"));
int expires = PressRequest.GetFormString("rememberme") == "forever" ? 43200 : 0;
user = _userService.GetUser(userName, password);
if (user != null)
{
_userService.WriteUserCookie(user.UserName, user.PassWord, expires);
ViewBag.Role = user.Role;
ViewBag.OrgCode = user.OrgCode;
return(true);
}
else
{
ModelState.AddModelError("", "用户名或密码错误!");
}
return(false);
}
/// <summary>
/// 更新开发人员所属小组
/// </summary>
/// <param name="CIUser"></param>
/// <returns></returns>
public int UpdateUserOrg(CIUser _userinfo)
{
return(_userRepository.UpdateUserOrg(_userinfo));
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="_userinfo"></param>
/// <returns></returns>
public int InsertUser(CIUser _userinfo)
{
return(_userRepository.Insert(_userinfo));
}
