public ActionResult Edit(tblUser_Sys collection) { ReturnMessage RM = new ReturnMessage(false); if (ModelState.IsValid) { try { var query = BusinessContext.tblUser_Sys.GetList( Query.And(Query <tblUser_Sys> .EQ(t => t.LoginName, collection.LoginName), Query <tblUser_Sys> .NE(t => t.Rid, collection.Rid))); if (query.Count > 0) { RM.Message = "登录名已被占用"; } else { tblUser_Sys old = BusinessContext.tblUser_Sys.Get(Query <tblUser_Sys> .EQ(t => t.Rid, collection.Rid)); RM.IsSuccess = BusinessContext.tblUser_Sys.Update(collection); if (RM.IsSuccess) { OperateLogHelper.Edit <tblUser_Sys>(collection, old); var list = BusinessContext.tblUser_Roles.GetList(Query <tblUser_Roles> .EQ(t => t.LoginName, collection.LoginName)).Where(p => p.Role_Id == collection.DefaultRoleId).ToList(); if (list != null && list.Count > 0) { tblUser_Roles role = list[0]; role.IsDefault = true; role.Role_Id = collection.DefaultRoleId; tblUser_Roles old_Roles = BusinessContext.tblUser_Roles.Get(Query <tblUser_Roles> .EQ(t => t.Rid, role.Rid)); BusinessContext.tblUser_Roles.Update(role); OperateLogHelper.Edit <tblUser_Roles>(role, old_Roles); } else { tblUser_Roles role = new tblUser_Roles(); role.IsDefault = true; role.LoginName = collection.LoginName; role.Role_Id = collection.DefaultRoleId; BusinessContext.tblUser_Roles.Add(role); OperateLogHelper.Create <tblUser_Roles>(role); } } } } catch (Exception ex) { RM.Message = ex.Message; } } return(Json(RM)); }
public ActionResult Edit(tblUser_Sys collection) { ReturnMessage RM = new ReturnMessage(false); if (ModelState.IsValid) { try { var query = BusinessContext.tblUser_Sys.GetModelList(String.Format("LoginName='{0}' and TblRcdId<>{1}", collection.LoginName, collection.TblRcdId)); if (query.Count > 0) { RM.Message = "登录名已被占用"; } else { tblUser_Sys old = BusinessContext.tblUser_Sys.GetModel(collection.TblRcdId); RM.IsSuccess = BusinessContext.tblUser_Sys.Update(collection); if (RM.IsSuccess) { OperateLogHelper.Edit <tblUser_Sys>(collection, old); var list = BusinessContext.tblUser_Roles.GetModelList("LoginName='" + collection.LoginName + "'").Where(p => p.Role_Id == collection.DefaultRoleId).ToList(); if (list != null && list.Count > 0) { tblUser_Roles role = list[0]; role.IsDefault = true; role.Role_Id = collection.DefaultRoleId; tblUser_Roles old_Roles = BusinessContext.tblUser_Roles.GetModel(role.TblRcdId); BusinessContext.tblUser_Roles.Update(role); OperateLogHelper.Edit <tblUser_Roles>(role, old_Roles); } else { tblUser_Roles role = new tblUser_Roles(); role.IsDefault = true; role.LoginName = collection.LoginName; role.Role_Id = collection.DefaultRoleId; BusinessContext.tblUser_Roles.Add(role); OperateLogHelper.Create <tblUser_Roles>(role); } } } } catch (Exception ex) { RM.Message = ex.Message; } } return(Json(RM)); }
public ActionResult Create(tblUser_Sys collection, string IsContinue = "0") { ReturnMessage RM = new ReturnMessage(false); try { if (collection.UserPwd == "" || string.IsNullOrEmpty(collection.UserPwd)) { //默认密码MD5加密 collection.UserPwd = Md5.Encode("123456"); } //根据登录名称查询是否已经存在, var query = BusinessContext.tblUser_Sys.Get(Query <tblUser_Sys> .EQ(t => t.LoginName, collection.LoginName)); if (query != null) { RM.Message = "登录名已被占用"; } else { //添加用户,并返回数据库ID,保存操作日志 var res = BusinessContext.tblUser_Sys.Add(collection); RM.IsSuccess = res; if (RM.IsSuccess) { //collection.Rid = Rid; tblUser_Roles tblUser_Roles = new tblUser_Roles(); tblUser_Roles.Role_Id = collection.DefaultRoleId; tblUser_Roles.LoginName = collection.LoginName; tblUser_Roles.IsDefault = true; BusinessContext.tblUser_Roles.Add(tblUser_Roles); OperateLogHelper.Create <tblUser_Roles>(tblUser_Roles); OperateLogHelper.Create <tblUser_Sys>(collection); //IsContinue 为1时保存并继续 RM.IsContinue = IsContinue == "1"; } } } catch (Exception ex) { RM.Message = ex.Message; } return(Json(RM)); }
internal static void Edit <T1>(tblUser_Sys collection, tblUser_Roles old) { throw new NotImplementedException(); }