/// <summary>
/// 获取数据列表(明细数据)
/// </summary>
public PageModel GetDataItemListForPage(CarInfoRequest request)
{
var where = new Where <TbCarInfoDetail>();
if (!string.IsNullOrWhiteSpace(request.keyword))
{
where.And(p => p.UserCode.Like(request.keyword) || p.UserName.Like(request.keyword));
}
if (!string.IsNullOrWhiteSpace(request.CarCode))
{
where.And(p => p.CarCode == request.CarCode);
}
try
{
var data = Db.Context.From <TbCarInfoDetail>()
.Select(
TbCarInfoDetail._.UserCode.As("CarUserCode"),
TbCarInfoDetail._.UserName.As("CarUserName"),
TbCarInfoDetail._.Tel)
.Where(where)
.OrderByDescending(p => p.ID)
.ToPageList(request.rows, request.page);
return(data);
}
catch (Exception)
{
throw;
}
}
public async Task <CarInfoResponse> PersistCarInfo(CarInfoRequest carInfo)
{
CarInfoResponse response = new CarInfoResponse(carInfo);
var collection = _database.GetCollection <CarInfoResponse>("carInfo");
await collection.InsertOneAsync(response);
return(response);
}
public HttpResponseMessage GetDriverInfoList([FromUri] CarInfoRequest request)
{
try
{
var data = _carInfo.GetDataItemListForPage(request);
return(AjaxResult.Success(data).ToJsonApi());
}
catch (Exception)
{
return(AjaxResult.Error("操作失败").ToJsonApi());
}
}
/// <summary>
/// 获取数据列表(分页)
/// </summary>
public PageModel GetDataListForPage(CarInfoRequest request)
{
#region 模糊搜索条件
var where = new Where <TbCarInfo>();
if (!string.IsNullOrWhiteSpace(request.CarCode))
{
where.And(p => p.CarCode.Like(request.CarCode));
}
if (!string.IsNullOrWhiteSpace(request.CarCph))
{
where.And(p => p.CarCph.Like(request.CarCph));
}
if (!string.IsNullOrWhiteSpace(request.ProcessFactoryCode))
{
where.And(p => p.ProcessFactoryCode == request.ProcessFactoryCode);
}
#endregion
try
{
var data = Db.Context.From <TbCarInfo>()
.Select(
TbCarInfo._.All
, TbUser._.UserName
, TbSupplier._.SupplierName
, TbCompany._.CompanyFullName.As("ProcessFactoryName"))
.LeftJoin <TbUser>((a, c) => a.InsertUserCode == c.UserCode)
.LeftJoin <TbSupplier>((a, c) => a.SupplierCode == c.SupplierCode)
.LeftJoin <TbCompany>((a, c) => a.ProcessFactoryCode == c.CompanyCode)
.Where(where)
.OrderByDescending(p => p.ID)
.ToPageList(request.rows, request.page);
return(data);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 获取分页列表数据
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetGridJson(CarInfoRequest request)
{
var data = _carInfo.GetDataListForPage(request);
return(Content(data.ToJson()));
}
public async Task <IActionResult> InsertCarInfo([FromBody] CarInfoRequest carInfo)
{
return(Ok(await _provider.PersistCarInfo(carInfo)));
}
public async Task <CarInfoResponse> PersistCarInfo(CarInfoRequest carInfo)
{
return(await _repo.PersistCarInfo(carInfo));
}
