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>());
}
