/// <summary>
/// 获取配送装车列表数据
/// </summary>
/// <returns></returns>
public ActionResult GetDistributionEntList(TbDistributionEntRequest request)
{
request.rows = 50;
var data = _siteDiscCargoLogic.GetDistributionEntList(request);
return(Content(data.ToJson()));
}
/// <summary>
/// 获取配送装车列表数据
/// </summary>
/// <returns></returns>
public PageModel GetDistributionEntList(TbDistributionEntRequest request)
{
//参数化
List <Parameter> parameter = new List <Parameter>();
string where = " where 1=1 and de.ProjectId=@ProjectId";
parameter.Add(new Parameter("@ProjectId", request.ProjectId, DbType.String, null));
if (!string.IsNullOrWhiteSpace(request.keyword))
{
where += " and cp.CompanyFullName like @keyword or de.DistributionCode like @keyword or de.TypeCode like @keyword or de.TypeName like @keyword or de.UsePart like @keyword";
parameter.Add(new Parameter("@keyword", '%' + request.keyword + '%', DbType.String, null));
}
string sql = @"select de.*,cp.CompanyFullName as SiteName,ur.UserName,car.CarCph,card.UserName as CarUser from TbDistributionEnt de
left join TbCompany cp on de.SiteCode=cp.CompanyCode
left join TbUser ur on de.InsertUserCode=ur.UserCode
left join TbCarInfo car on de.VehicleCode=car.CarCode
left join TbCarInfoDetail card on de.Driver=card.UserCode ";
var model = Repository <TbDistributionEnt> .FromSqlToPageTable(sql + where, parameter, request.rows, request.page, "ID", "asc");
return(model);
//var ret = Db.Context.From<TbDistributionEnt>()
// .Select(
// TbDistributionEnt._.All
// , TbCompany._.CompanyFullName.As("SiteName")
// , TbUser._.UserName
// , TbCarInfo._.CarCph
// , TbCarInfoDetail._.UserName.As("CarUser"))
// .LeftJoin<TbCompany>((a, c) => a.SiteCode == c.CompanyCode)
// .AddSelect(Db.Context.From<TbCompany>().Select(p => p.CompanyFullName)
// .Where(TbCompany._.CompanyCode == TbDistributionEnt._.ProcessFactoryCode), "ProcessFactoryName")
// .AddSelect(Db.Context.From<TbUser>().Select(p => p.UserName)
// .Where(TbUser._.UserCode == TbDistributionEnt._.Contacts), "ContactsName")
// .LeftJoin<TbUser>((a, c) => a.InsertUserCode == c.UserCode)
// .LeftJoin<TbCarInfo>((a, c) => a.VehicleCode == c.CarCode)
// .LeftJoin<TbCarInfoDetail>((a, c) => a.Driver == c.UserCode)
// .ToDataTable();
//return ret;
}
