/// <summary> /// 添加部门信息 /// </summary> /// <param name="parm"></param> /// <returns></returns> public async Task <ApiResult <string> > AddAsync(SysOrganize parm) { parm.Guid = Guid.NewGuid().ToString(); parm.EditTime = DateTime.Now; SysOrganizeDb.Insert(parm); if (!string.IsNullOrEmpty(parm.ParentGuid)) { // 说明有父级 根据父级,查询对应的模型 var model = SysOrganizeDb.GetById(parm.ParentGuid); parm.ParentGuidList = model.ParentGuidList + parm.Guid + ","; parm.Layer = model.Layer + 1; } else { parm.ParentGuidList = "," + parm.Guid + ","; } //更新 新的对象 SysOrganizeDb.Update(parm); var res = new ApiResult <string> { statusCode = 200, data = "1" }; return(await Task.Run(() => res)); }
/// <summary> /// 查询Tree /// </summary> /// <returns></returns> public async Task <ApiResult <List <SysOrganizeTree> > > GetListTreeAsync() { var list = SysOrganizeDb.GetList(); var treeList = new List <SysOrganizeTree>(); foreach (var item in list.Where(m => m.Layer == 0).OrderBy(m => m.Sort)) { //获得子级 var children = RecursionOrganize(list, new List <SysOrganizeTree>(), item.Guid); treeList.Add(new SysOrganizeTree() { guid = item.Guid, name = item.Name, open = children.Count > 0, children = children.Count == 0?null:children }); } var res = new ApiResult <List <SysOrganizeTree> > { statusCode = 200, data = treeList }; return(await Task.Run(() => res)); }
/// <summary> /// 添加部门信息 /// </summary> /// <param name="parm"></param> /// <returns></returns> public async Task <ApiResult <string> > AddAsync(SysRole parm) { var res = new ApiResult <string>() { data = "1", statusCode = 200 }; try { //根据部门ID查询部门组 var organizeModel = SysOrganizeDb.GetById(parm.DepartmentGuid); parm.DepartmentGroup = organizeModel.ParentGuidList; parm.Guid = Guid.NewGuid().ToString(); parm.EditTime = DateTime.Now; parm.AddTime = DateTime.Now; parm.IsSystem = true; SysRoleDb.Insert(parm); } catch (Exception ex) { res.statusCode = (int)ApiEnum.Error; res.message = ApiEnum.Error.GetEnumText() + ex.Message; } return(await Task.Run(() => res)); }
/// <summary> /// 添加部门信息 /// </summary> /// <param name="parm"></param> /// <returns></returns> public async Task <ApiResult <string> > AddAsync(SysRole parm) { var res = new ApiResult <string>() { data = "1", statusCode = 200 }; try { parm.Guid = Guid.NewGuid().ToString(); parm.EditTime = DateTime.Now; parm.AddTime = DateTime.Now; if (parm.Level == 1) { //根据部门ID查询部门 var organizeModel = SysOrganizeDb.GetById(parm.DepartmentGuid); parm.DepartmentGroup = organizeModel.ParentGuidList; } await Db.Insertable(parm).ExecuteCommandAsync(); } catch (Exception ex) { res.statusCode = (int)ApiEnum.Error; res.message = ApiEnum.Error.GetEnumText() + ex.Message; } return(res); }
/// <summary> /// 修改菜单 /// </summary> /// <param name="parm"></param> /// <returns></returns> public async Task <ApiResult <string> > ModifyAsync(SysRole parm) { var res = new ApiResult <string>() { statusCode = 200 }; try { parm.EditTime = DateTime.Now; if (parm.Level == 1) { //根据部门ID查询部门组 var organizeModel = SysOrganizeDb.GetById(parm.DepartmentGuid); parm.DepartmentGroup = organizeModel.ParentGuidList; } await Db.Updateable(parm).ExecuteCommandAsync(); } catch (Exception ex) { res.statusCode = (int)ApiEnum.Error; res.message = ApiEnum.Error.GetEnumText() + ex.Message; Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message); } return(res); }
/// <summary> /// 修改菜单 /// </summary> /// <param name="parm"></param> /// <returns></returns> public async Task <ApiResult <string> > ModifyAsync(SysRole parm) { var res = new ApiResult <string>() { data = "1", statusCode = 200 }; try { //根据部门ID查询部门组 var organizeModel = SysOrganizeDb.GetById(parm.DepartmentGuid); parm.DepartmentGroup = organizeModel.ParentGuidList; parm.IsSystem = true; parm.EditTime = DateTime.Now; res.data = SysRoleDb.Update(parm) ? "1" : "0"; } catch (Exception ex) { res.statusCode = (int)ApiEnum.Error; res.message = ApiEnum.Error.GetEnumText() + ex.Message; Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message); } return(await Task.Run(() => res)); }
/// <summary> /// 修改菜单 /// </summary> /// <param name="parm"></param> /// <returns></returns> public async Task <ApiResult <string> > ModifyAsync(SysAdmin parm) { var res = new ApiResult <string> { statusCode = (int)ApiEnum.Error }; try { //修改,判断用户是否和其它的重复 var isExisteName = await Db.Queryable <SysAdmin>().AnyAsync(m => m.LoginName == parm.LoginName && m.Guid != parm.Guid); if (isExisteName) { res.message = "用户名已存在,请更换~"; res.statusCode = (int)ApiEnum.ParameterError; return(await Task.Run(() => res)); } parm.LoginPwd = DES3Encrypt.EncryptString(parm.LoginPwd); if (!string.IsNullOrEmpty(parm.DepartmentGuid)) { // 说明有父级 根据父级,查询对应的模型 var model = SysOrganizeDb.GetById(parm.DepartmentGuid); parm.DepartmentGuidList = model.ParentGuidList; } var dbres = await Db.Updateable <SysAdmin>().UpdateColumns(m => new SysAdmin() { LoginName = parm.LoginName, LoginPwd = parm.LoginPwd, DepartmentName = parm.DepartmentName, DepartmentGuid = parm.DepartmentGuid, DepartmentGuidList = parm.DepartmentGuidList, TrueName = parm.TrueName, Number = parm.Number, Sex = parm.Sex, Mobile = parm.Mobile, Email = parm.Email, Status = parm.Status }).Where(m => m.Guid == parm.Guid).ExecuteCommandAsync(); if (dbres > 0) { res.statusCode = (int)ApiEnum.Status; res.message = "更新成功!"; } else { res.message = "更新失败!"; } } catch (Exception ex) { res.message = ApiEnum.Error.GetEnumText() + ex.Message; Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message); } return(res); }
/// <summary> /// 添加部门信息 /// </summary> /// <param name="parm"></param> /// <returns></returns> public async Task <ApiResult <string> > AddAsync(SysAdmin parm) { var res = new ApiResult <string> { statusCode = (int)ApiEnum.ParameterError }; try { //判断用吗是否存在 var isExisteName = await Db.Queryable <SysAdmin>().AnyAsync(m => m.LoginName == parm.LoginName); if (isExisteName) { res.message = "用户名已存在,请更换~"; return(res); } parm.LoginPwd = DES3Encrypt.EncryptString(parm.LoginPwd); if (string.IsNullOrEmpty(parm.HeadPic)) { parm.HeadPic = "/themes/img/avatar.jpg"; } parm.Guid = Guid.NewGuid().ToString(); parm.AddDate = DateTime.Now; if (!string.IsNullOrEmpty(parm.DepartmentGuid)) { // 说明有父级 根据父级,查询对应的模型 var model = SysOrganizeDb.GetById(parm.DepartmentGuid); parm.DepartmentGuidList = model.ParentGuidList; } SysAdminDb.Insert(parm); //查询授权表,type=2 更新新的权限值 //添加新的 var authorityList = new List <SysPermissions>(); foreach (var item in parm.RoleList) { authorityList.Add(new SysPermissions() { RoleGuid = item.guid, AdminGuid = parm.Guid, Types = 2 }); } await Db.Insertable(authorityList).ExecuteCommandAsync(); res.statusCode = (int)ApiEnum.Status; } catch (Exception ex) { res.message = ApiEnum.Error.GetEnumText() + ex.Message; Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message); } return(await Task.Run(() => res)); }
/// <summary> /// 删除部门 /// </summary> /// <param name="parm"></param> /// <returns></returns> public async Task <ApiResult <string> > DeleteAsync(string parm) { var list = Utils.StrToListString(parm); var isok = SysOrganizeDb.Delete(m => list.Contains(m.Guid)); var res = new ApiResult <string> { statusCode = isok ? 200 : 500, data = isok ? "1" : "0", message = isok ? "删除成功~" : "删除失败~" }; return(await Task.Run(() => res)); }
/// <summary> /// 根据唯一编号查询一条部门信息 /// </summary> /// <param name="parm"></param> /// <returns></returns> public async Task <ApiResult <SysOrganize> > GetByGuidAsync(string parm) { var model = SysOrganizeDb.GetById(parm); var res = new ApiResult <SysOrganize> { statusCode = 200 }; var pmdel = Db.Queryable <SysOrganize>().OrderBy(m => m.Sort, OrderByType.Desc).First(); res.data = model ?? new SysOrganize() { Sort = pmdel?.Sort + 1 ?? 1, Status = true }; return(await Task.Run(() => res)); }
/// <summary> /// 修改菜单 /// </summary> /// <param name="parm"></param> /// <returns></returns> public async Task <ApiResult <string> > ModifyAsync(SysAdmin parm) { if (!string.IsNullOrEmpty(parm.DepartmentGuid)) { // 说明有父级 根据父级,查询对应的模型 var model = SysOrganizeDb.GetById(parm.DepartmentGuid); parm.DepartmentGuidList = model.ParentGuidList; } var res = new ApiResult <string> { statusCode = 200, data = SysAdminDb.Update(parm) ? "1" : "0" }; return(await Task.Run(() => res)); }
/// <summary> /// 添加部门信息 /// </summary> /// <param name="parm"></param> /// <returns></returns> public async Task <ApiResult <string> > AddAsync(SysAdmin parm) { parm.Guid = Guid.NewGuid().ToString(); parm.AddDate = DateTime.Now; if (!string.IsNullOrEmpty(parm.DepartmentGuid)) { // 说明有父级 根据父级,查询对应的模型 var model = SysOrganizeDb.GetById(parm.DepartmentGuid); parm.DepartmentGuidList = model.ParentGuidList; } SysAdminDb.Insert(parm); var res = new ApiResult <string> { statusCode = 200, data = "1" }; return(await Task.Run(() => res)); }
/// <summary> /// 添加部门信息 /// </summary> /// <param name="parm"></param> /// <returns></returns> public new async Task <ApiResult <string> > AddAsync(SysAdmin parm) { var res = new ApiResult <string> { statusCode = 200, data = "1" }; try { //判断用吗是否存在 var isExisteName = SysAdminDb.IsAny(m => m.LoginName == parm.LoginName); if (isExisteName) { res.message = "用户名已存在,请更换~"; res.statusCode = (int)ApiEnum.ParameterError; return(await Task.Run(() => res)); } parm.LoginPwd = DES3Encrypt.EncryptString(parm.LoginPwd); if (string.IsNullOrEmpty(parm.HeadPic)) { parm.HeadPic = "/themes/img/avatar.jpg"; } parm.Guid = Guid.NewGuid().ToString(); parm.AddDate = DateTime.Now; if (!string.IsNullOrEmpty(parm.DepartmentGuid)) { // 说明有父级 根据父级,查询对应的模型 var model = SysOrganizeDb.GetById(parm.DepartmentGuid); parm.DepartmentGuidList = model.ParentGuidList; } SysAdminDb.Insert(parm); } catch (Exception ex) { res.message = ApiEnum.Error.GetEnumText() + ex.Message; res.statusCode = (int)ApiEnum.Error; Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message); } return(await Task.Run(() => res)); }
public async Task <ApiResult <string> > ModifyAsync(SysOrganize parm) { parm.EditTime = DateTime.Now; if (!string.IsNullOrEmpty(parm.ParentGuid)) { // 说明有父级 根据父级,查询对应的模型 var model = SysOrganizeDb.GetById(parm.ParentGuid); parm.ParentGuidList = model.ParentGuidList + parm.Guid + ","; parm.Layer = model.Layer + 1; } else { parm.ParentGuidList = "," + parm.Guid + ","; } var res = new ApiResult <string> { statusCode = 200, data = SysOrganizeDb.Update(parm) ? "1" : "0" }; return(await Task.Run(() => res)); }
/// <summary> /// 修改菜单 /// </summary> /// <param name="parm"></param> /// <returns></returns> public async Task <ApiResult <string> > ModifyAsync(SysAdmin parm) { var res = new ApiResult <string> { statusCode = (int)ApiEnum.Error }; try { //修改,判断用户是否和其它的重复 var isExisteName = await Db.Queryable <SysAdmin>().AnyAsync(m => m.LoginName == parm.LoginName && m.Guid != parm.Guid); if (isExisteName) { res.message = "用户名已存在,请更换~"; res.statusCode = (int)ApiEnum.ParameterError; return(await Task.Run(() => res)); } parm.LoginPwd = DES3Encrypt.EncryptString(parm.LoginPwd); if (!string.IsNullOrEmpty(parm.DepartmentGuid)) { // 说明有父级 根据父级,查询对应的模型 var model = SysOrganizeDb.GetById(parm.DepartmentGuid); parm.DepartmentGuidList = model.ParentGuidList; } //查询授权表,type=2 更新新的权限值 //删除 var authority = await Db.Deleteable <SysPermissions>().Where(m => m.AdminGuid == parm.Guid && m.Types == 2).ExecuteCommandAsync(); //添加新的 var authorityList = new List <SysPermissions>(); foreach (var item in parm.RoleList) { authorityList.Add(new SysPermissions() { RoleGuid = item.guid, AdminGuid = parm.Guid, Types = 2 }); } await Db.Insertable(authorityList).ExecuteCommandAsync(); var dbres = await Db.Updateable <SysAdmin>().SetColumns(m => new SysAdmin() { LoginName = parm.LoginName, LoginPwd = parm.LoginPwd, RoleGuid = parm.RoleGuid, DepartmentName = parm.DepartmentName, DepartmentGuid = parm.DepartmentGuid, DepartmentGuidList = parm.DepartmentGuidList, TrueName = parm.TrueName, Number = parm.Number, Sex = parm.Sex, Mobile = parm.Mobile, Email = parm.Email, Status = parm.Status }).Where(m => m.Guid == parm.Guid).ExecuteCommandAsync(); if (dbres > 0) { res.statusCode = (int)ApiEnum.Status; res.message = "更新成功!"; } else { res.message = "更新失败!"; } } catch (Exception ex) { res.message = ApiEnum.Error.GetEnumText() + ex.Message; Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message); } return(res); }