public ResponseListDto <Menus> GetCompanyTree() { ResponseListDto <Menus> response = new ResponseListDto <Menus>(); var menuids = _appSystemServices.GetEntitys <CompanyMenus>().Where(x => x.CompanyId == CurrentUser.CompanyId).ToList().Select(p => p.MenuId).ToList(); List <Menus> data = new List <Menus>(); if (menuids.IsNull() || menuids.Count == 0) { data = _appSystemServices.GetEntitys <Menus>().Where(x => x.ParentId == 0 && x.IsDeafult.Value).ToList(); } else { data = _appSystemServices.GetEntitys <Menus>().Where(x => x.ParentId == 0).ToList(); } data.ForEach(x => { GetChildren(x); }); response.Data = data.ToList <Menus>(); return(response); }
public ResponseListDto <Column> GetHeader() { ResponseListDto <Column> response = new ResponseListDto <Column>(); response.Data = _dataBaseServices.GetColumns(typeof(SQLConfig).Name); return(response); }
public ResponseListDto <UserDto> GetUsersList() { ResponseListDto <UserDto> response = new ResponseListDto <UserDto>(); response.Data = _userServices.GetUserList(CurrentUser.CompanyId); return(response); }
public ResponseListDto <Users> GetResult([FromBody] BaseRequest <Users> request) { ResponseListDto <Users> response = new ResponseListDto <Users>(); var userIds = _appSystemServices.GetEntitys <CompanyUsers>().Where(x => x.CompanyId == CurrentUser.CompanyId).ToList().Select(p => p.UserId).ToList(); var data = _appSystemServices.GetEntitys <Users>().Where(x => userIds.Contains(x.Id)); if (!request.IsNull()) { if (!string.IsNullOrEmpty(request.Filter.ToStringExtension())) { data = data.Where(x => x.UserName.Contains(request.Filter) || x.Phone.Contains(request.Filter)); } if (!string.IsNullOrEmpty(request.Sort.ToStringExtension())) { data = data.OrderByPropertyName(request.Sort, request.Asc.ToBoolean()); } else { data = data.OrderBy(x => x.Id); } } response.Total = data.Count(); response.Data = data.Page(request.PageIndex, request.PageSize).ToList <Users>(); response.Data.ForEach(o => { o.DepartmentId = _appSystemServices.GetEntitys <DepartmentUsers>().Where(x => x.UserId == o.Id && x.CompanyId == o.CompanyId).ToList().Select(p => p.DepartmentId).ToList(); o.RoleId = _appSystemServices.GetEntitys <RoleUsers>().Where(x => x.UserId == o.Id && x.CompanyId == o.CompanyId).ToList().Select(p => p.RoleId).ToList(); }); return(response); }
public ResponseListDto <TestModule> GetResult([FromBody] BaseRequest <TestModule> request) { ResponseListDto <TestModule> response = new ResponseListDto <TestModule>(); var data = _appSystemServices.GetEntitys <TestModule>(); data = data.Where(x => x.CompanyId == CurrentUser.CompanyId); if (!request.IsNull()) { if (!string.IsNullOrEmpty(request.Filter.ToStringExtension())) { data = data.Where(x => x.ModuleName.Contains(request.Filter)); } if (!string.IsNullOrEmpty(request.Sort.ToStringExtension())) { data = data.OrderByPropertyName(request.Sort, request.Asc.ToBoolean()); } else { data = data.OrderBy(x => x.Id); } } response.Total = data.Count(); response.Data = data.Page(request.PageIndex, request.PageSize).ToList <TestModule>(); return(response); }
public ResponseListDto <Users> GetRoleChoseUser([FromBody] BaseRequest <Roles> request) { ResponseListDto <Users> response = new ResponseListDto <Users>(); var data = _appSystemServices.GetEntitys <Users>().Where(x => x.CompanyId == CurrentUser.CompanyId); if (!request.IsNull()) { if (!string.IsNullOrEmpty(request.Filter.ToStringExtension())) { data = data.Where(x => x.UserName.Contains(request.Filter)); } if (!request.Model.IsNull() && !request.Model.Id.IsNull()) { var userids = _appSystemServices.GetEntitys <RoleUsers>().Where(x => x.RoleId == request.Model.Id).ToList().Select(p => p.UserId).ToList(); if (userids.Count > 0) { data = data.Where(x => !userids.Contains(x.Id)); } } if (!string.IsNullOrEmpty(request.Sort.ToStringExtension())) { data = data.OrderByPropertyName(request.Sort, request.Asc.ToBoolean()); } else { data = data.OrderBy(x => x.Id); } } response.Total = data.Count(); response.Data = data.Page(request.PageIndex, request.PageSize).ToList <Users>(); return(response); }
public ResponseListDto <TableAreaData> SaveList([FromBody] List <TableAreaData> request) { ResponseListDto <TableAreaData> response = new ResponseListDto <TableAreaData>(); try { var _entity = _appSystemServices.GetEntitys <TableAreaData>(); if (request.Count > 0) { _entity.Where(x => x.TableAreaId == request.FirstOrDefault().TableAreaId).ToDelete().ExecuteAffrows(); request.ForEach(p => { _appSystemServices.Create <TableAreaData>(p); }); } } catch (Exception ex) { response.Message = ex.Message; response.Success = false; _sysservices.AddExexptionLogs(ex, "SaveList"); } return(response); }
public ResponseListDto <Column> GetHeader() { ResponseListDto <Column> response = new ResponseListDto <Column>(); var user = this.CurrentUser; response.Data = _dataBaseServices.GetColumns(typeof(TestModule).Name); return(response); }
public ResponseListDto <EnumClass> GetGrantMode() { ResponseListDto <EnumClass> response = new ResponseListDto <EnumClass>(); var data = EnumExtensions.GetListEnumClass <GrantMode>(); response.Total = data.Count(); response.Data = data; return(response); }
public ResponseListDto <TableAreaDataDto> GetResult([FromBody] BaseRequest <TableAreaDataDto> request) { ResponseListDto <TableAreaDataDto> response = new ResponseListDto <TableAreaDataDto>(); try { var data = _appSystemServices.GetEntitys <TableAreaData>(); if (!request.IsNull()) { if (!string.IsNullOrEmpty(request.Filter.ToStringExtension())) { data = data.Where(x => x.TableName.Contains(request.Filter)); } if ((request.Model.TableAreaId.ToInt64() > 0)) { data = data.Where(x => x.TableAreaId == request.Model.TableAreaId.ToInt64()); } if (!string.IsNullOrEmpty(request.Sort.ToStringExtension())) { data = data.OrderByPropertyName(request.Sort, request.Asc.ToBoolean()); } else { data = data.OrderBy(x => x.Id); } } response.Total = data.Count(); var returndata = data.Page(request.PageIndex, request.PageSize).ToList <TableAreaDataDto>(); List <KeyValuePair <Int32, List <Table> > > ls = new List <KeyValuePair <Int32, List <Table> > >(); returndata.ForEach(x => { if (!ls.Any(p => p.Key == x.DabaBaseId)) { var listtable = _dataBaseServices.GetTables(_dataBaseServices.GetConnectionString(x.DabaBaseId)).ToList(); ls.Add(new KeyValuePair <int, List <Table> >(x.DabaBaseId, listtable)); } x.Description = ls.Where(o => o.Key == x.DabaBaseId).FirstOrDefault().Value.Where(z => z.TableName == x.TableName).FirstOrDefault().TableDescription; }); response.Data = returndata; } catch (Exception ex) { response.Message = ex.Message; response.Success = false; _sysservices.AddExexptionLogs(ex, "GetResult"); } return(response); }
public ResponseListDto <CompanyMenus> GetCompanyMenus([FromBody] Company request) { ResponseListDto <CompanyMenus> response = new ResponseListDto <CompanyMenus>(); var data = _appSystemServices.GetEntitys <CompanyMenus>(); if (!request.IsNull()) { data = data.Where(x => x.CompanyId == request.Id); } response.Total = data.Count(); response.Data = data.ToList(); return(response); }
public ResponseListDto <Column> GetTableColumnList(string TableName) { ResponseListDto <Column> response = new ResponseListDto <Column>(); var Id = TableName.Split(',')[0].ToInt64(); var tablename = TableName.Split(',')[1].ToStringExtension(); var baseconnection = _dataBaseServices.GetConnectionString(Id); var data = _dataBaseServices.GetColumns(baseconnection, tablename); data.ForEach(x => { x.TableName = tablename; x.Id = Id; }); response.Data = data.ToList(); return(response); }
public ResponseListDto <Menus> GetTree() { ResponseListDto <Menus> response = new ResponseListDto <Menus>(); var data = _appSystemServices.GetEntitys <Menus>().Where(x => x.ParentId == 0).ToList(); data.ForEach(x => { GetChildren(x); }); response.Data = data.ToList <Menus>(); return(response); }
public ResponseListDto <TestModule> GetTree() { ResponseListDto <TestModule> response = new ResponseListDto <TestModule>(); var data = _appSystemServices.GetEntitys <TestModule>().Where(x => x.ParentId == 0 && x.CompanyId == CurrentUser.CompanyId).ToList(); data.ForEach(x => { GetChildren(x); }); response.Data = data.ToList <TestModule>(); return(response); }
public ResponseListDto <Column> GetHeader() { ResponseListDto <Column> response = new ResponseListDto <Column>(); try { var user = this.CurrentUser; response.Data = _dataBaseServices.GetColumns(typeof(TableAreaData).Name); } catch (Exception ex) { response.Message = ex.Message; response.Success = false; _sysservices.AddExexptionLogs(ex, "GetHeader"); } return(response); }
public ResponseListDto <DepartmentUsers> RemoveDepartmentUser([FromBody] List <DepartmentUsers> request) { ResponseListDto <DepartmentUsers> response = new ResponseListDto <DepartmentUsers>(); var _entity = _appSystemServices.GetEntitys <DepartmentUsers>(); if (request.Count > 0) { request.ForEach(p => { var departmentuser = _entity.Where(x => x.UserId == p.UserId && x.DepartmentId == p.DepartmentId).First(); if (!departmentuser.IsNull()) { _appSystemServices.Remove <DepartmentUsers>(departmentuser); } }); } return(response); }
public ResponseListDto <RoleUsers> RemoveRoleUser([FromBody] List <RoleUsers> request) { ResponseListDto <RoleUsers> response = new ResponseListDto <RoleUsers>(); var _entity = _appSystemServices.GetEntitys <RoleUsers>(); if (request.Count > 0) { request.ForEach(p => { var roleuser = _entity.Where(x => x.UserId == p.UserId && x.RoleId == p.RoleId).First(); if (!roleuser.IsNull()) { _appSystemServices.Remove <RoleUsers>(roleuser); } }); } return(response); }
public ResponseListDto <RoleUsers> SaveRoleUser([FromBody] List <RoleUsers> request) { ResponseListDto <RoleUsers> response = new ResponseListDto <RoleUsers>(); var _entity = _appSystemServices.GetEntitys <RoleUsers>(); if (request.Count > 0) { request.ForEach(p => { if (!_entity.Any(x => x.UserId == p.UserId && x.RoleId == p.RoleId)) { p.CompanyId = CurrentUser.CompanyId; p.SetCreateDefault(this.CurrentUser); _appSystemServices.Create <RoleUsers>(p); } }); } return(response); }
public ResponseListDto <TreeDto> GetDataBaseConnectionList() { ResponseListDto <TreeDto> response = new ResponseListDto <TreeDto>(); var data = _dataBaseServices.GetDataBaseConnections(); data = data.Where(x => x.CompanyId == CurrentUser.CompanyId).ToList(); List <TreeDto> responsedto = new List <TreeDto>(); data.ForEach(x => { responsedto.Add(new TreeDto() { id = x.Id, label = x.DataBaseName, parentId = 0 }); }); response.Data = responsedto.ToList(); return(response); }
public ResponseListDto <TreeDto> GetDataBaseTableList(Int64 Id) { ResponseListDto <TreeDto> response = new ResponseListDto <TreeDto>(); var baseconnection = _dataBaseServices.GetConnectionString(Id); var data = _dataBaseServices.GetTables(baseconnection); List <TreeDto> responsedto = new List <TreeDto>(); var i = 1; data.ForEach(x => { responsedto.Add(new TreeDto() { id = i, label = $"{ x.TableName}", parentId = Id, description = x.TableDescription }); i++; }); response.Data = responsedto.ToList(); return(response); }
public ResponseListDto <TableArea> GetResult([FromBody] BaseRequest <TableArea> request) { ResponseListDto <TableArea> response = new ResponseListDto <TableArea>(); var data = _appSystemServices.GetEntitys <TableArea>(); data = data.Where(x => x.CompanyId == CurrentUser.CompanyId); if (!request.IsNull()) { if (!string.IsNullOrEmpty(request.Filter.ToStringExtension())) { data = data.Where(x => x.AreaName.Contains(request.Filter)); } if (!string.IsNullOrEmpty(request.Sort.ToStringExtension())) { data = data.OrderByPropertyName(request.Sort, request.Asc.ToBoolean()); } else { data = data.OrderBy(x => x.Id); } } var alldata = data.ToList <TableArea>(); // 组织menus var parent = alldata.Where(x => x.ParentId.ToInt64() == 0).ToList(); parent.ForEach(p => { p.children = GetChilds(p, alldata); }); response.Total = data.Count(); response.Data = parent;// data.Page(request.PageIndex, request.PageSize).ToList<Menus>(); //response.Total = data.Count(); //response.Data = data.Page(request.PageIndex, request.PageSize).ToList<TableArea>(); return(response); }
public ResponseListDto <Element> GetResult([FromBody] BaseRequest <Element> request) { ResponseListDto <Element> response = new ResponseListDto <Element>(); var data = _appSystemServices.GetEntitys <Element>(); data = data.Where(x => x.CompanyId == CurrentUser.CompanyId); if (!request.IsNull()) { if (!string.IsNullOrEmpty(request.Filter.ToStringExtension())) { data = data.Where(x => x.Name.Contains(request.Filter)); } if (request.Model.ParentId.ToInt32() > 0) { List <Int64> rlist = new List <long>(); var testmodule = _appSystemServices.GetEntitys <TestModule>().Where(p => p.Id == request.Model.ParentId).ToList().FirstOrDefault(); rlist.Add(testmodule.Id); GetChildren(testmodule, rlist); data = data.Where(x => rlist.Contains(x.ParentId)); } if (!string.IsNullOrEmpty(request.Sort.ToStringExtension())) { data = data.OrderByPropertyName(request.Sort, request.Asc.ToBoolean()); } else { data = data.OrderBy(x => x.Id); } } response.Total = data.Count(); response.Data = data.Page(request.PageIndex, request.PageSize).ToList <Element>(); return(response); }
/// <summary> /// 新增 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="baseRequest"></param> /// <param name="where"></param> /// <param name="orderby"></param> /// <returns></returns> public Boolean Create <T>(T [] t) where T : class { ResponseListDto <T> response = new ResponseListDto <T>(); return(FreeSqlFactory._Freesql.Insert <T>(t).ExecuteAffrows() > 0); }
/// <summary> /// 新增 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="baseRequest"></param> /// <param name="where"></param> /// <param name="orderby"></param> /// <returns></returns> public Int64 Create <T>(T t) where T : class { ResponseListDto <T> response = new ResponseListDto <T>(); return(FreeSqlFactory._Freesql.Insert <T>(t).ExecuteIdentity()); }
/// <summary> /// 修改 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="baseRequest"></param> /// <param name="where"></param> /// <param name="orderby"></param> /// <returns></returns> public Boolean Modify <T>(T t) where T : class { ResponseListDto <T> response = new ResponseListDto <T>(); return(FreeSqlFactory._Freesql.Update <T>().SetSource(t).ExecuteAffrows() > 1); }
/// <summary> /// 删除 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="baseRequest"></param> /// <param name="where"></param> /// <param name="orderby"></param> /// <returns></returns> public Boolean Remove <T>(T t) where T : class { ResponseListDto <T> response = new ResponseListDto <T>(); return(FreeSqlFactory._Freesql.Delete <T>(t).ExecuteAffrows() > 1); }
/// <summary> /// 查询分页 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="baseRequest"></param> /// <param name="where"></param> /// <param name="orderby"></param> /// <returns></returns> public FreeSql.ISelect <T> GetEntitys <T>() where T : class { ResponseListDto <T> response = new ResponseListDto <T>(); return(FreeSqlFactory._Freesql.Select <T>()); }