/// <summary> /// 获取导出数据列表 /// </summary> public DataTable GetExportList(RawMonthDemSupplyPlanRequest request) { //组装查询语句 #region 模糊搜索条件 var where = new Where <TbRawMaterialMonthDemandSupplyPlan>(); if (!string.IsNullOrWhiteSpace(request.ProcessFactoryCode)) { where.And(p => p.ProcessFactoryCode == request.ProcessFactoryCode); } //if (!string.IsNullOrWhiteSpace(request.SiteCode)) //{ // List<string> WorkAreaList = _workOrderLogic.GetCompanyWorkAreaOrSiteList(request.SiteCode, 4);//工区 // where.And(p => p.WorkAreaCode.In(WorkAreaList)); //} if (!string.IsNullOrWhiteSpace(request.SiteCode)) { List <string> SiteList = _workOrderLogic.GetCompanyWorkAreaOrSiteList(request.SiteCode, 5); //站点 List <string> WorkAreaList = _workOrderLogic.GetCompanyWorkAreaOrSiteList(request.SiteCode, 4); //工区 where.And(p => p.SiteCode.In(SiteList) || p.WorkAreaCode.In(WorkAreaList)); } if (!string.IsNullOrEmpty(request.ProjectId)) { where.And(p => p.ProjectId == request.ProjectId); } if (!string.IsNullOrWhiteSpace(request.DemandPlanCode)) { where.And(p => p.DemandPlanCode.StartsWith(request.DemandPlanCode)); } if (!string.IsNullOrWhiteSpace(request.SupplyPlanCode)) { where.And(p => p.SupplyPlanCode.StartsWith(request.SupplyPlanCode)); } if (request.HistoryMonth.HasValue) { var historyMonth = new WhereClip("YEAR(TbRawMaterialMonthDemandSupplyPlan.InsertTime)=" + request.HistoryMonth.Value.Year + " and MONTH(TbRawMaterialMonthDemandSupplyPlan.InsertTime)=" + request.HistoryMonth.Value.Month); where.And(historyMonth); } #endregion try { var ret = Db.Context.From <TbRawMaterialMonthDemandSupplyPlan>() .Select( TbRawMaterialMonthDemandSupplyPlan._.All , TbCompany._.CompanyFullName.As("BranchName") , TbSysDictionaryData._.DictionaryText.As("RebarTypeNew") , TbSupplier._.SupplierName , TbUser._.UserName) .LeftJoin <TbCompany>((a, c) => a.BranchCode == c.CompanyCode) .AddSelect(Db.Context.From <TbCompany>().Select(p => p.CompanyFullName) .Where(TbCompany._.CompanyCode == TbRawMaterialMonthDemandSupplyPlan._.SiteCode), "SiteName") .AddSelect(Db.Context.From <TbCompany>().Select(p => p.CompanyFullName) .Where(TbCompany._.CompanyCode == TbRawMaterialMonthDemandSupplyPlan._.ProcessFactoryCode), "ProcessFactoryName") .AddSelect(Db.Context.From <TbCompany>().Select(p => p.CompanyFullName) .Where(TbCompany._.CompanyCode == TbRawMaterialMonthDemandSupplyPlan._.WorkAreaCode), "WorkAreaName") .LeftJoin <TbSysDictionaryData>((a, c) => a.RebarType == c.DictionaryCode && c.FDictionaryCode == "RebarType") .LeftJoin <TbSupplier>((a, c) => a.SupplierCode == c.SupplierCode) .LeftJoin <TbUser>((a, c) => a.InsertUserCode == c.UserCode) .Where(where).OrderByDescending(d => d.ID).ToDataTable(); return(ret); } catch (Exception) { throw; } }
/// <summary> /// 获取分页列表数据 /// </summary> /// <param name="request"></param> /// <returns></returns> public ActionResult GetGridJson(RawMonthDemSupplyPlanRequest request) { var data = _rawMonthDemSupplyPlanLogic.GetDataListForPage(request); return(Content(data.ToJson())); }