public ActionResult GetSysList(SyncParamDto vm)
{
if (vm != null && vm.Count > 0)
{
var fileInfoService = this.GetService <IFileInfoService>();
List <FileInfoDto> data = fileInfoService.GetSysList(vm);
return(Success(data));
}
return(Error());
}
public virtual List <RoleInfoDto> GetSyncList(SyncParamDto vm)
{
List <RoleInfoDto> list = null;
using (var db = this.CreateDbContext())
{
DateTime?startTime = null;
if (vm.SyncId.HasValue && !string.IsNullOrEmpty(vm.SyncKey))
{
var m = db.Role.Where(q => q.Id == vm.SyncId.Value).FirstOrDefault();
if (m != null && m.Key == vm.SyncKey)
{
startTime = vm.SyncUpdateTime;
}
}
var query = from q in db.Role
where q.IsSystem == false
select new RoleInfoDto
{
Id = q.Id,
Type = q.Type,
Name = q.Name,
IsSystem = q.IsSystem,
Key = q.Key,
UpdateTime = q.UpdateTime,
IsDelete = q.IsDelete
};
if (startTime.HasValue)
{
query = query.Where(q => q.UpdateTime > startTime.Value);
}
query = query.OrderBy(q => q.UpdateTime);
list = query.Take(vm.Count).ToList();
foreach (var m in list)
{
m.AuthList = RoleAuthRepository.Instance.GetList(m.Id, db);
}
}
return(list);
}
public virtual List <FileInfoDto> GetSyncList(SyncParamDto vm)
{
List <FileInfoDto> list = null;
using (var db = this.CreateDbContext())
{
DateTime?startTime = null;
if (vm.SyncId.HasValue && !string.IsNullOrEmpty(vm.SyncKey))
{
var m = db.FileInfo.Where(q => q.Id == vm.SyncId.Value).FirstOrDefault();
if (m != null && m.Key == vm.SyncKey)
{
startTime = vm.SyncUpdateTime;
}
}
var query = from q in db.FileInfo
select new FileInfoDto
{
Id = q.Id,
ParentId = q.ParentId,
Type = q.Type,
Directory = q.Directory,
Name = q.Name,
Length = q.Length,
CreationTime = q.CreationTime,
LastWriteTime = q.LastWriteTime,
Key = q.Key,
UpdateTime = q.UpdateTime,
IsDelete = q.IsDelete,
};
if (startTime.HasValue)
{
query = query.Where(q => q.UpdateTime > startTime.Value);
}
query = query.OrderBy(q => q.UpdateTime);
list = query.Take(vm.Count).ToList();
}
return(list);
}
public virtual List <UserInfoDto> GetSyncList(SyncParamDto vm)
{
List <UserInfoDto> list = null;
using (var db = this.CreateDbContext())
{
DateTime?startTime = null;
if (vm.SyncId.HasValue && !string.IsNullOrEmpty(vm.SyncKey))
{
var m = db.User.Where(q => q.Id == vm.SyncId.Value).FirstOrDefault();
if (m != null && m.Account == vm.SyncKey)
{
startTime = vm.SyncUpdateTime;
}
}
var query = from q in db.User
join r in db.Role on q.RoleId equals r.Id
where q.IsSystem == false
select new UserInfoDto
{
Id = q.Id,
Account = q.Account,
Name = q.Name,
Password = q.Password,
RoleId = q.RoleId,
UpdateTime = q.UpdateTime,
IsDelete = q.IsDelete,
RoleName = r.Name
};
if (startTime.HasValue)
{
query = query.Where(q => q.UpdateTime > startTime.Value);
}
query = query.OrderBy(q => q.UpdateTime);
list = query.Take(vm.Count).ToList();
}
return(list);
}
public virtual List <FileInfoDto> GetSysList(SyncParamDto vm)
{
var fileInfoRepository = this.GetRepository <IFileInfoRepository>();
return(fileInfoRepository.GetSyncList(vm));
}
