public CustomJsonResult GetList(BaseSearchCondition condition)
{
string name = condition.Name.ToSearchString();
var query = (from i in CurrentDb.Company
where
(name.Length == 0 || i.Name.Contains(name))
select new { i.Id, i.ImgUrl, i.Name, i.LastUpdateTime, i.CreateTime });
int total = query.Count();
int pageIndex = condition.PageIndex;
int pageSize = 10;
query = query.OrderByDescending(r => r.Id).Skip(pageSize * (pageIndex)).Take(pageSize);
List <object> list = new List <object>();
foreach (var item in query)
{
list.Add(new
{
item.Id,
item.ImgUrl,
item.Name,
item.CreateTime,
});
}
PageEntity pageEntity = new PageEntity {
PageSize = pageSize, TotalRecord = total, Rows = list
};
return(Json(ResultType.Success, pageEntity, ""));
}
public override async Task <PaginatedList <Country> > SearchAsync(BaseSearchCondition <int> searchCondition)
{
if (searchCondition == null)
{
return(null);
}
var result = await _repository.PaginateAsync(searchCondition.TenantId, searchCondition.PageNo, searchCondition.RecordsPerPage);
return(result);
}
//[HttpPost]
//public CustomJsonResult Disable(int id)
//{
// CustomJsonResult reuslt = new CustomJsonResult();
// reuslt = BizFactory.CarInsuranceCompany.Disable(this.CurrentUserId, id);
// return reuslt;
//}
public CustomJsonResult GetList(BaseSearchCondition condition)
{
string name = condition.Name.ToSearchString();
var query = (from c in CurrentDb.CarInsuranceCompany
join i in CurrentDb.Company on c.InsuranceCompanyId equals i.Id into tmp0
from tt0 in tmp0.DefaultIfEmpty()
where
(name.Length == 0 || tt0.Name.Contains(name))
select new { c.Id, c.InsuranceCompanyId, c.Status, c.InsuranceCompanyImgUrl, tt0.Name, c.CreateTime, c.CanInsure, c.CanClaims, c.CanApplyLossAssess });
int total = query.Count();
int pageIndex = condition.PageIndex;
int pageSize = 10;
query = query.OrderByDescending(r => r.CreateTime).Skip(pageSize * (pageIndex)).Take(pageSize);
List <object> list = new List <object>();
foreach (var item in query)
{
list.Add(new
{
item.Id,
item.InsuranceCompanyId,
item.Name,
item.InsuranceCompanyImgUrl,
item.CreateTime,
Status = item.Status,
StatusName = item.Status.GetCnName(),
CanInsure = (item.CanInsure == true ? "是" : "否"),
CanClaims = (item.CanClaims == true ? "是" : "否"),
CanApplyLossAssess = (item.CanApplyLossAssess == true ? "是" : "否"),
});
}
PageEntity pageEntity = new PageEntity {
PageSize = pageSize, TotalRecord = total, Rows = list
};
return(Json(ResultType.Success, pageEntity, ""));
}
/// <summary>
/// 可选择的保险公司列表
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public CustomJsonResult GetInsuranceCompanyList(BaseSearchCondition condition)
{
string name = condition.Name.ToSearchString();
var query = (from i in CurrentDb.Company
where
i.Status == Enumeration.CompanyStatus.Valid &&
i.Type == Enumeration.CompanyType.InsuranceCompany &&
(name.Length == 0 || i.Name.Contains(name)) && !(CurrentDb.CarInsuranceCompany.Any(m => m.InsuranceCompanyId == i.Id))
select new { i.Id, i.ImgUrl, i.Name, i.LastUpdateTime, i.CreateTime });
int total = query.Count();
int pageIndex = condition.PageIndex;
int pageSize = 5;
query = query.OrderByDescending(r => r.CreateTime).Skip(pageSize * (pageIndex)).Take(pageSize);
List <object> list = new List <object>();
foreach (var item in query)
{
list.Add(new
{
item.Id,
item.ImgUrl,
item.Name,
item.LastUpdateTime,
item.CreateTime
});
}
PageEntity pageEntity = new PageEntity {
PageSize = pageSize, TotalRecord = total, Rows = list
};
return(Json(ResultType.Success, pageEntity, ""));
}
/// <summary>
/// Searches the entity data based on the given search condition
/// </summary>
/// <param name="searchCondition">The base search condition</param>
/// <returns>Collection of entity paramters</returns>
public Task <IEnumerable <TEntity> > SearchAsync(BaseSearchCondition <TId> searchCondition)
{
var entities = _dbContext.Set <TEntity>();
IQueryable <TEntity> result = null;
if (searchCondition.TenantIds != null && searchCondition.TenantIds.Count() > 0)
{
result = entities.Where(e => searchCondition.TenantIds.Contains(e.TenantId));
}
if (searchCondition.Ids != null && searchCondition.Ids.Count() > 0)
{
result = entities.Where(e => searchCondition.Ids.Contains(e.Id));
}
if (result == null)
{
result = entities.Where(x => 1 == 1);
}
return(Task.FromResult(result.AsEnumerable()));
}
/// <summary> /// Searches the asynchronous. /// </summary> /// <param name="searchCondition">The search condition.</param> /// <returns></returns> public abstract Task <PaginatedList <TEntity> > SearchAsync(BaseSearchCondition <TId> searchCondition);
