public IActionResult GetPlanDetail([FromBody] PlanInitDto parm) { string[] subitemids = parm.Ids.Split(','); List <Biz_ContractItem_Sub> subItemlist = _contractitemsubService.GetWhere(m => subitemids.Contains(m.ID)); if (subItemlist.Any(m => m.status > 20000)) { return(toResponse(StatusCodeType.Error, "当前项目已经提交安排,请刷新列表再试!")); } if (subItemlist.Any(m => m.ContractItemSubType == 0) && subItemlist.Any(m => m.ContractItemSubType == 1)) { return(toResponse(StatusCodeType.Error, "不允许同时安排一阶段跟二阶段项目,请核对!")); } string ids = "'" + string.Join("','", subitemids) + "'"; var customerid = Core.DbContext.Db.Ado.SqlQuery <string>(string.Format("select distinct CustomerID from Biz_MainContract where ID in (select MainContractID from Biz_ContractItem_Sub where ID in ({0}))", ids)).ToList(); if (customerid.Count() > 1) { return(toResponse(StatusCodeType.Error, "不同客户下项目不允许一起安排,请核对!")); } //任务信息 ItemPlanVM plandata = new ItemPlanVM(); plandata.CustomerID = customerid.First().ToString(); plandata.ContractItem_SubList = subItemlist; //添加体系项目 //审核员信息 List <PlanAuditorVM> planlist = new List <PlanAuditorVM>(); PlanAuditorVM plan = new PlanAuditorVM(); List <Biz_Contract_PlanAuditor_Item> AuditorItemList = new List <Biz_Contract_PlanAuditor_Item>(); foreach (var subItem in subItemlist) { Biz_Contract_PlanAuditor_Item planauditor_item = new Biz_Contract_PlanAuditor_Item(); //审核员项目信息 planauditor_item.ContractItemSubID = subItem.ID; AuditorItemList.Add(planauditor_item); } plan.PlanAuditItemList = AuditorItemList; planlist.Add(plan); plandata.PlanAuditorList = planlist; return(toResponse(plandata)); }
public IActionResult GetPlanDetail(string id = null) { if (string.IsNullOrEmpty(id)) { return(toResponse(StatusCodeType.Error, "id不允许为空!")); } using (SqlSugarClient db = Core.DbContext.CurrentDB) { Biz_Contract_Plan plan = _contractitemplanService.GetId(id); if (plan == null) { return(toResponse(StatusCodeType.Error, "查询不到相关项目信息,请核对!")); } //任务信息 ItemPlanVM plandata = Api.Common.Helpers.ComHelper.Mapper <ItemPlanVM, Biz_Contract_Plan>(plan); List <Biz_ContractItem_Sub> subItemList = _contractitemsubService.GetWhere(m => m.ContractPlanID == plandata.ID); //审核员信息 List <Biz_Contract_PlanAuditor> planauditorlist = _contractplanauditorService.GetWhere(m => m.ContractPlanID == plandata.ID); List <PlanAuditorVM> planauditorviewlist = new List <PlanAuditorVM>(); foreach (var planauditor in planauditorlist) { PlanAuditorVM planauditorview = Api.Common.Helpers.ComHelper.Mapper <PlanAuditorVM, Biz_Contract_PlanAuditor>(planauditor); planauditorview.PlanAuditItemList = _contractplanauditoritemService.GetWhere(m => m.PlanAuditorID == planauditorview.ID); planauditorviewlist.Add(planauditorview); } plandata.ContractItem_SubList = subItemList; plandata.PlanAuditorList = planauditorviewlist; return(toResponse(plandata)); } }