/// <summary>
/// 获取可以选择的原需求计划(分页)
/// </summary>
public DataTable GetRawMaterialMonthDemandPlanList(RawMonthDemPlanRequest request)
{
try
{
string where = "";
if (!string.IsNullOrWhiteSpace(request.keyword))
{
where += " and DemandPlanCode like '%" + request.keyword + "%' or RebarType='" + request.keyword + "' ";
}
if (!string.IsNullOrWhiteSpace(request.ProjectId))
{
where += " and mdp.ProjectId='" + request.ProjectId + "' ";
}
if (!string.IsNullOrWhiteSpace(request.ProcessFactoryCode))
{
where += " and mdp.ProcessFactoryCode='" + request.ProcessFactoryCode + "' ";
}
if (!string.IsNullOrWhiteSpace(request.SiteCode))
{
List <string> SiteList = _workOrderLogic.GetCompanyWorkAreaOrSiteList(request.SiteCode, 5); //站点
List <string> WorkAreaList = _workOrderLogic.GetCompanyWorkAreaOrSiteList(request.SiteCode, 4); //工区
string siteStr = string.Join("','", SiteList);
string workAreaStr = string.Join("','", WorkAreaList);
where += " and (mdp.SiteCode in('" + siteStr + "') or mdp.WorkAreaCode in('" + workAreaStr + "'))";
}
string sql = @"select mdp.DemandPlanCode,mdp.RebarType,sd.DictionaryText as RebarTypeName,mdp.BranchCode,c1.CompanyFullName as BranchName,mdp.WorkAreaCode,c4.CompanyFullName as WorkAreaName,mdp.SiteCode,c2.CompanyFullName as SiteName,mdp.ProcessFactoryCode,c3.CompanyFullName as ProcessFactoryName,mdp.SupplierCode,sup.SupplierName,mdp.InsertUserCode,mdp.DeliveryAdd,mdp.ProjectId from TbRawMaterialMonthDemandPlan mdp
left join TbCompany c1 on mdp.BranchCode=c1.CompanyCode
left join TbCompany c2 on mdp.SiteCode=c2.CompanyCode
left join TbCompany c3 on mdp.ProcessFactoryCode=c3.CompanyCode
left join TbCompany c4 on mdp.WorkAreaCode=c4.CompanyCode
left join TbSupplier sup on mdp.SupplierCode=sup.SupplierCode
left join TbUser us on mdp.InsertUserCode=us.UserCode
left join TbSysDictionaryData sd on mdp.RebarType=sd.DictionaryCode and sd.FDictionaryCode='RebarType'
where DATEPART(m,mdp.InsertTime)=DATEPART(m,GETDATE()) and mdp.DemandPlanCode not in (select DemandPlanCode from TbRawMaterialMonthDemandSupplyPlan) and mdp.Examinestatus!='未发起' ";
var model = Db.Context.FromSql(sql + where).ToDataTable();
return(model);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 月度需求计划弹窗
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetXQJHGridJson(RawMonthDemPlanRequest request, string keyword)
{
var data = _fbnpBus.GetXQJHGridJson(request, keyword);
return(Content(data.ToJson()));
}
/// <summary>
/// 获取所有列表信息
/// </summary>
/// <returns></returns>
public HttpResponseMessage GetGridJson([FromUri] RawMonthDemPlanRequest pt)
{
var data = _rawPlan.GetDataListForPage(pt);
return(AjaxResult.Success(data).ToJsonApi());
}
/// <summary>
/// 工区材料月度计划提交情况
/// </summary>
/// <returns></returns>
public HttpResponseMessage Img4([FromUri] RawMonthDemPlanRequest pt)
{
var data = _rawPlan.Img4(pt);
return(AjaxResult.Success(data).ToJsonApi());
}
/// <summary>
/// 图形4
/// </summary>
/// <param name="RebarType">钢筋类型</param>
/// <param name="DemandMonth">需求月份</param>
/// <returns></returns>
public ActionResult Img4(RawMonthDemPlanRequest request)
{
var data = _rawMonthDemPlanLogic.Img4(request);
return(Content(data.ToJson()));
}
/// <summary>
/// 获取分页列表数据
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public ActionResult GetGridJson(RawMonthDemPlanRequest request)
{
var data = _rawMonthDemPlanLogic.GetDataListForPage(request);
return(Content(data.ToJson()));
}
public ActionResult GetRawMaterialMonthDemandPlanList(RawMonthDemPlanRequest request)
{
var data = _rawMonthDemSupplyPlanLogic.GetRawMaterialMonthDemandPlanList(request);
return(Content(data.ToJson()));
}
