/// <summary> /// 编辑图文消息 /// </summary> /// <param name="info"></param> /// <returns></returns> public DocPic EditDocPic(DocPicEditReqeust info) { ValiDatas.valiData(info); ValiCode(info.Code, info.Id); using (var db = new DefaultContainer()) { var row = db.Db_BaseDocSet.OfType <Db_DocPic>().Single(p => p.Id == this.Id); row.Caption = info.Caption; row.Code = info.Code; row.Content = info.Content; row.Descript = info.Descript; //删除原来的分类 db.Database.ExecuteSqlCommand("delete from Db_BaseDocTreeSet where Db_BaseDocId=@docId", new SqlParameter("@docId", this.Id)); //新增分类 if (info.TreeIds != null) { if (info.TreeIds.Count > 0) { List <Db_BaseDocTree> dbTrees = new List <Db_BaseDocTree>(); foreach (var item in info.TreeIds) { dbTrees.Add(new Db_BaseDocTree() { Id = Guid.NewGuid().ToString(), Db_BaseDocId = this.Id, TreeId = item }); } db.Db_BaseDocTreeSet.AddRange(dbTrees); } } db.SaveChanges(); return(new DocPic(row)); } }
/// <summary> /// 验证用户名和密码是否正确 /// </summary> /// <param name="condtion"></param> /// <returns>验证通过返回后台用户对象 验证不通过直接抛出DataNotFundException异常</returns> public static UserManager checkLogin(UserManagerLoginRequest condtion) { ValiDatas.valiData(condtion); using (var db = new DefaultContainer()) { //判断数据库是否为空,如果为空则添加一个管理员用户 var count = (from c in db.Db_BaseUserSet.OfType <Db_ManagerUser>() select c.Id).Count(); if (count == 0) { return(UserManager.create(new UserManagerCreateRequest() { fullName = "管理员", loginName = "admin", roleNames = new string[] { "admin" } })); } var row = db.Db_BaseUserSet.OfType <Db_ManagerUser>().SingleOrDefault(p => p.loginName == condtion.loginName && p.passWord.ToLower() == condtion.passWord.ToLower() && p.isDeleted == false ); if (row == null) { throw new DataNotFundException("用户名或者密码错误"); } if (row.isDisabled) { throw new ValiDataException("已被禁用的用户无法登录"); } return(new UserManager(row)); } }
/// <summary> /// 新增/编辑 /// </summary> /// <param name="rows"></param> /// <returns></returns> public static List <WorkFlowRole> Edit(List <WorkFlowRole> rows) { List <WorkFlowRole> result = new List <WorkFlowRole>(); foreach (var item in rows) { ValiDatas.valiData(item); } using (var db = new DefaultContainer()) { foreach (var item in rows) { if (string.IsNullOrEmpty(item.Id)) { Db_WorkFlowRole dbRole = new Db_WorkFlowRole() { CreatedOn = DateTime.Now, Descript = string.IsNullOrEmpty(item.Descript) ? null : item.Descript, Id = Guid.NewGuid().ToString(), RoleName = item.RoleName }; db.Db_WorkFlowRoleSet.Add(dbRole); result.Add(new WorkFlowRole(dbRole)); } else { var row = db.Db_WorkFlowRoleSet.Single(p => p.Id == item.Id); row.RoleName = item.RoleName; row.Descript = item.Descript; result.Add(new WorkFlowRole(row)); } } db.SaveChanges(); } return(result); }
/// <summary> /// 更新文档图片集 /// </summary> /// <param name="filesList"></param> public void UpdatImgFileList(List <BaseDocImgFile> filesList) { if (filesList == null) { filesList = new List <BaseDocImgFile>(); } foreach (var item in filesList) { ValiDatas.valiData(item); } using (var db = new DefaultContainer()) { //删除原来的 db.Database.ExecuteSqlCommand("delete from Db_BaseDocFileSet where Db_BaseDocId =@docId", new SqlParameter("@docId", this.Id)); if (filesList.Count > 0) { List <Db_BaseDocFile> dbFiles = new List <Db_BaseDocFile>(); foreach (var item in filesList) { dbFiles.Add(new Db_BaseDocFile() { Caption = item.Caption, CreatedOn = DateTime.Now, Db_BaseDocId = this.Id, Descript = item.Descript, Seq = item.Seq, FileId = item.FileId, Id = Guid.NewGuid().ToString() }); } db.Db_BaseDocFileSet.AddRange(dbFiles); db.SaveChanges(); } } }
/// <summary> /// 编辑基础信息 - 姓名与手机号 /// </summary> /// <param name="condtion"></param> /// <returns></returns> public UserManager editBaseInfo(UserManagerBaseEditRequest condtion) { ValiDatas.valiData(condtion); this.fullName = condtion.fullName; this.mobilePhone = condtion.mobilePhone; saveBaseInfo(); return(this); }
/// <summary> /// 编辑用户信息 信息与角色 /// </summary> /// <param name="condtion"></param> /// <returns></returns> public UserManager edit(UserManagerEditRequest condtion) { ValiDatas.valiData(condtion); this.fullName = condtion.fullName; this.mobilePhone = condtion.mobilePhone; this.rolesList = condtion.roleNames.ToList(); save(); return(this); }
/// <summary> /// 修改用户的密码 /// </summary> /// <param name="condtion"></param> public void changePwd(UserChangePwdRequst condtion) { ValiDatas.valiData(condtion); using (var db = new DefaultContainer()) { var dbuser = db.Db_BaseUserSet.OfType <Db_ManagerUser>().Single(p => p.Id == this.Id); if (dbuser.passWord.ToLower() != condtion.oldPwd.ToLower()) { throw new ValiDataException("您提供的旧密码错误"); } dbuser.passWord = condtion.newPwd; db.SaveChanges(); } }
public BaseResponse <UserManager> setDisabled(string Id, UserManagerSetDisabledRequest condtion) { ValiDatas.valiData(condtion); var thisUser = UserManager.getUserById(User.Identity.Name); UserManager user = UserManager.getUserById(Id); user.saveDisabled(condtion.isDisabled); //记录到日志 //操作员 UserLog.create(string.Format("将用户[{0}]设置为{1},备注:{2}", user.getNameString(), (condtion.isDisabled ? "已禁用" : "未禁用"), condtion.remark), "用户禁用设置", thisUser); //被编辑 UserLog.create(string.Format("被用户[{0}]设置为{1},备注:{2}", thisUser.getNameString(), (condtion.isDisabled ? "已禁用" : "未禁用"), condtion.remark), "用户禁用设置", user); return(BaseResponse.getResult(user, "设置成功")); }
/// <summary> /// 批量新增/编辑业务流程定义 /// </summary> /// <param name="condtion"></param> public static List <WorkFlowDefinition> EditDefs(List <WorkFlowDefinition> condtion) { List <WorkFlowDefinition> result = new List <WorkFlowDefinition>(); if (condtion != null) { if (condtion.Count > 0) { foreach (var item in condtion) { ValiDatas.valiData(condtion); } using (var db = new DefaultContainer()) { foreach (var item in condtion) { if (string.IsNullOrEmpty(item.Id)) { //新增 Db_WorkFlowDefinition dbDef = new Db_WorkFlowDefinition() { Id = SysHelps.GetNewId(), Caption = item.Caption, Descript = string.IsNullOrEmpty(item.Descript)? null :item.Descript, CreatedOn = DateTime.Now }; db.Db_WorkFlowDefinitionSet.Add(dbDef); result.Add(new WorkFlowDefinition(dbDef)); } else { //编辑 var dbDef = db.Db_WorkFlowDefinitionSet.Single(p => p.Id == item.Id); dbDef.Caption = item.Caption; dbDef.Descript = item.Descript; result.Add(new WorkFlowDefinition(dbDef)); } } db.SaveChanges(); } } } return(result); }
/// <summary> /// 新增图文集 /// </summary> /// <param name="info"></param> /// <returns></returns> public static DocPic CreateDocPic(DocPicEditReqeust info) { ValiDatas.valiData(info); ValiCode(info.Code); using (var db = new DefaultContainer()) { var newId = Guid.NewGuid().ToString(); Db_DocPic newRow = new Db_DocPic() { Caption = info.Caption, Code = info.Code, Content = info.Content, CreatedOn = DateTime.Now, Descript = info.Descript, DocType = BaseDocType.图文集.GetHashCode(), Id = newId }; //所在分类信息 if (info.TreeIds != null) { if (info.TreeIds.Count > 0) { List <Db_BaseDocTree> dbTrees = new List <Db_BaseDocTree>(); foreach (var item in info.TreeIds) { dbTrees.Add(new Db_BaseDocTree() { Id = Guid.NewGuid().ToString(), Db_BaseDocId = newId, TreeId = item }); } db.Db_BaseDocTreeSet.AddRange(dbTrees); } } db.Db_BaseDocSet.Add(newRow); db.SaveChanges(); return(new DocPic(newRow)); } }
/// <summary> /// 创建一个后台用户 /// </summary> /// <param name="condtion"></param> /// <returns></returns> public static UserManager create(UserManagerCreateRequest condtion) { ValiDatas.valiData(condtion); lock (locker) { //验证登录名是否已存在 var count = getLoginNameCount(condtion.loginName); if (count > 0) { throw new ValiDataException("该登录名已存在,创建失败"); } string newId = Guid.NewGuid().ToString(); Db_ManagerUser user = new Db_ManagerUser() { createdOn = DateTime.Now, fullName = condtion.fullName, loginName = condtion.loginName, mobilePhone = condtion.mobilePhone, passWord = SysSetingsHelp.DefaultAdminPwd, Id = newId, }; //角色 foreach (var role in condtion.roleNames) { user.Db_BaseUserRole.Add(new Db_BaseUserRole() { Id = Guid.NewGuid().ToString(), roleName = role, }); } using (var db = new DefaultContainer()) { var newrow = db.Db_BaseUserSet.Add(user); db.SaveChanges(); return(getUserById(newId)); } } }