public ActionResult ResetPassword(ResetPasswordViewModel model)
{
try
{
UserDto dto = new UserDto();
Message msg = new Message();
DataTable dt = CMSService.SelectOne("User", "CMSUser", "UserId=" + model.UserId);
foreach (DataRow dr in dt.Rows)
{
dto = UserMapping.getDTO(dr);
dto.UserPassword = CommonTools.ToMd5(model.UserPassword);
}
string JsonString = JsonHelper.JsonSerializerBySingleData(dto);
msg = CMSService.Update("User", JsonString);
msg.MessageStatus = "Success";
msg.MessageInfo = "密码修改成功了";
ViewBag.Status = msg.MessageStatus;
// TODO: Add delete logic here
return(RedirectTo("/User/Index", msg.MessageInfo));
}
catch
{
Message msg = new Message();
msg.MessageStatus = "Error";
msg.MessageInfo = "操作出错了";
ViewBag.Status = msg.MessageStatus;
ViewBag.msg = msg.MessageInfo;
return(View());
}
}
public ActionResult PartialInfo(string username)
{
UserViewModel model = new UserViewModel();
DataTable dt = CMSService.SelectOne("User", "CMSUser", "UserName='******'");
foreach (DataRow dr in dt.Rows)
{
UserDto dto = new UserDto();
dto = UserMapping.getDTO(dr);
model.UserId = dto.UserId;
model.UserName = dto.UserName;
model.UserRoles = MyService.RolesIdToRolesName(dto.UserRoles);
model.UserEmail = dto.UserEmail;
model.UserTelephone = dto.UserTelephone;
model.UserStatus = dto.UserStatus;
model.UserRegisterTime = dto.UserRegisterTime;
model.UserRealName = dto.UserRealName;
model.UserSex = dto.UserSex;
model.UserBirthday = dto.UserBirthday.ToShortDateString();
if (String.IsNullOrEmpty(dto.UserImg))
{
model.UserImg = "/UserImg/Img/default_48.jpg";
}
else
{
model.UserImg = dto.UserImg + "_48.jpg";
}
}
ViewData["Sex"] = MyService.GetSexSelectList();
return(View(model));
}
// 返回用户对应的角色， 在实际中， 可以从SQL数据库中读取用户的角色信息
private string GetRole(string UserName)
{
if (string.IsNullOrEmpty(UserName))
{
return("游客");
}
else
{
UserDto dto = new UserDto();
DataTable dt = CMSService.SelectOne("User", "CMSUser", "UserName='******'");
foreach (DataRow dataRow in dt.Rows)
{
dto = UserMapping.getDTO(dataRow);
}
string userRoles = "";
string roleName = "";
string s = dto.UserRoles;
string[] sArray = s.Split(',');
foreach (string i in sArray)
{
DataTable dataTable = CMSService.SelectOne("Role", "CMSRole", "RoleId=" + int.Parse(i));
foreach (DataRow dataRow in dataTable.Rows)
{
RoleDto roleDto = new RoleDto();
roleDto = RoleMapping.getDTO(dataRow);
roleName = roleDto.RoleName;
}
userRoles = userRoles + roleName + ",";
userRoles = userRoles.Substring(0, userRoles.Length - 1);
}
return(userRoles);
}
}
public static string UserIdToName(string strWhere)
{
UserDto dto = new UserDto();
DataTable dt = CMSService.SelectOne("User", "CMSUser", strWhere);
foreach (DataRow dr in dt.Rows)
{
dto = UserMapping.getDTO(dr);
}
return(dto.UserName);
}
public static List <UserDto> GetUserList(string strwhere)
{
List <UserDto> UserList = new List <UserDto>();
DataTable dt = CMSService.SelectSome("User", "CMSUser", strwhere);
foreach (DataRow dr in dt.Rows)
{
UserDto dto = UserMapping.getDTO(dr);
UserList.Add(dto);
}
return(UserList);
}
public ActionResult UserLogin(UserLoginViewModel model)
{
string strwhere = "UserName='******' and UserPassword='******'";
DataTable dt = CMSService.SelectOne("User", "CMSUser", strwhere);
if (dt.Rows.Count > 0)
{
UserDto dto = new UserDto();
foreach (DataRow dr in dt.Rows)
{
dto = UserMapping.getDTO(dr);
}
if (!dto.UserStatus)
{
return(RedirectToAction("Login", "Login", new { ac = "StatusError" }));
}
else
{
HttpCookie cookie = new HttpCookie("User");
cookie.Value = dto.UserName;
System.Web.HttpContext.Current.Response.Cookies.Add(cookie);
HttpCookie cookieid = new HttpCookie("UserId");
cookieid.Value = dto.UserId.ToString();
System.Web.HttpContext.Current.Response.Cookies.Add(cookieid);
HttpCookie cookieImg = new HttpCookie("UserImg");
string urlImg = "";
if (String.IsNullOrEmpty(dto.UserImg))
{
urlImg = "/UserImg/Img/default_48.jpg";
}
else
{
urlImg = dto.UserImg.ToString() + "_48.jpg";
}
cookieImg.Value = urlImg;
System.Web.HttpContext.Current.Response.Cookies.Add(cookieImg);
System.Web.HttpContext.Current.Session["UserId"] = dto.UserId;
FormsAuthentication.SetAuthCookie(dto.UserName, false);
return(Redirect("/Home/Index"));
}
}
else
{
return(RedirectToAction("Login", "Login", new { ac = "LoginError" }));
}
}
public JsonResult ValidateUserEmail(string UserEmail)
{
var result = false;
UserDto userDto = new UserDto();
DataTable dt = CMSService.SelectOne("User", "CMSUser", "UserEmail='" + UserEmail + "'");
foreach (DataRow dr in dt.Rows)
{
userDto = UserMapping.getDTO(dr);
}
result = !(userDto.UserId > 0);
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult PartialEditUserInfo(string id)
{
EditUserInfoViewModel model = new EditUserInfoViewModel();
DataTable dt = CMSService.SelectOne("User", "CMSUser", "UserId=" + id);
foreach (DataRow dr in dt.Rows)
{
UserDto dto = new UserDto();
dto = UserMapping.getDTO(dr);
model.UserId = dto.UserId;
model.UserName = dto.UserName;
model.UserRealName = dto.UserRealName;
model.UserSex = dto.UserSex;
model.UserBirthday = dto.UserBirthday.ToShortDateString();
}
ViewData["Sex"] = MyService.GetSexSelectList();
return(View(model));
}
public ActionResult EditUserInfo(EditUserInfoViewModel model)
{
UserDto dto = new UserDto();
DataTable dt = CMSService.SelectOne("User", "CMSUser", "UserId=" + model.UserId);
foreach (DataRow dr in dt.Rows)
{
dto = UserMapping.getDTO(dr);
// dto.UserRoles = Request.Form["UserRoles"];
dto.UserBirthday = DateTime.Parse(model.UserBirthday);
dto.UserRealName = model.UserRealName;
dto.UserSex = model.UserSex;
}
string JsonString = JsonHelper.JsonSerializerBySingleData(dto);
Message msg = CMSService.Update("User", JsonString);
// TODO: Add update logic here
return(RedirectToAction("UserInfo"));
}
public ActionResult PartialEditUserImg(string id)
{
string imgurl = "";
UserDto dto = new UserDto();
DataTable dt = CMSService.SelectOne("User", "CMSUser", "UserId=" + id);
foreach (DataRow dr in dt.Rows)
{
dto = UserMapping.getDTO(dr);
}
if (string.IsNullOrEmpty(dto.UserImg))
{
imgurl = "/UserImg/Img/default";
}
else
{
imgurl = dto.UserImg;
}
ViewBag.userImg = imgurl + "_48.jpg";
ViewBag.userid = id;
return(View());
}
//用户列表
public static List <SelectListItem> GetUserSelectList(string strwhere)
{
DataTable dt = CMSService.SelectSome("User", "CMSUser", strwhere);
List <SelectListItem> items = new List <SelectListItem>();
foreach (DataRow dr in dt.Rows)
{
UserDto dto = UserMapping.getDTO(dr);
string username = "";
if (String.IsNullOrEmpty(dto.UserRealName))
{
username = dto.UserName;
}
else
{
username = dto.UserRealName;
}
items.Add(new SelectListItem {
Text = username, Value = dto.UserId.ToString()
});
}
return(items);
}
// 显示用户列表页
public ActionResult Index(int?p, int?roleId)
{
int RoleId = roleId ?? 0;
Pager pager = new Pager();
pager.table = "CMSUser";
pager.strwhere = "1=1";
pager.PageSize = 10;
pager.PageNo = p ?? 1;
pager.FieldKey = "UserId";
pager.FiledOrder = "UserId Desc";
if (RoleId > 0)
{
pager.strwhere = pager.strwhere + " and charindex('" + RoleId + "',UserRoles)>0";
}
pager = CMSService.SelectAll("User", pager);
List <UserDto> list = new List <UserDto>();
foreach (DataRow dr in pager.EntityDataTable.Rows)
{
UserDto dto = UserMapping.getDTO(dr);
dto.UserRoles = MyService.RolesIdToRolesName(dto.UserRoles);
list.Add(dto);
}
pager.Entity = list.AsQueryable();
ViewBag.PageNo = p ?? 1;
ViewBag.PageCount = pager.PageCount;
ViewBag.RecordCount = pager.Amount;
ViewBag.Message = pager.Amount;
ViewData["Roles"] = MyService.GetRolesList("1=1");
return(View(pager.Entity));
}
// 编辑权限
public ActionResult EditRoles(int id)
{
EditUserRolesViewModel model = new EditUserRolesViewModel();
DataTable dt = CMSService.SelectOne("User", "CMSUser", "UserId=" + id);
foreach (DataRow dr in dt.Rows)
{
UserDto dto = new UserDto();
dto = UserMapping.getDTO(dr);
model.UserId = dto.UserId;
model.UserName = dto.UserName;
model.UserRoles = dto.UserRoles;
}
DataTable RoleDt = CMSService.SelectSome("Role", "CMSRole", "1=1");
List <RoleDto> ListRoles = new List <RoleDto>();
foreach (DataRow dr in RoleDt.Rows)
{
RoleDto roleDto = RoleMapping.getDTO(dr);
ListRoles.Add(roleDto);
}
ViewData["ListRoles"] = ListRoles;
return(View(model));
}