public dynamic PostProductPlanList_Blanking(dynamic data)
{
var ContractCode = data[0].ContractCode;
var SavantCode = data[0].SavantCode;
List <APS_ProjectProduceDetial> IsExistSavant = new APS_ProjectProduceDetialService().GetModelList(
ParamQuery.Instance()
.AndWhere("ContractCode", ContractCode).AndWhere("SavantCode", SavantCode));
if (IsExistSavant.Count > 0)
{
return(new { list = new List <dynamic>(), status = 2 });//已存在该中间件的计划
}
//中间件表
List <dynamic> MES_SavantList = data.ToObject <List <dynamic> >();
//工序表
var ProcessRouteList =
new MES_BN_ProductProcessRouteService()
.GetDynamicList()
.Where(p => p.IsEnable == 1 && p.ProcessModelType == "1")
.ToList <dynamic>();
var ProductPlanList =
(from a in MES_SavantList
join p in ProcessRouteList
on new { PartCode = Convert.ToString(a.PartCode), ContractCode = Convert.ToString(a.ContractCode) } equals new { PartCode = Convert.ToString(p.PartCode), ContractCode = Convert.ToString(p.ContractCode) }
orderby p.ProcessModelType, p.ProcessLineCode
select new
{
ContractCode = a.ContractCode,
SavantCode = a.SavantCode,
//a.ContractCode,
a.ProductID,
p.ProcessModelType,
p.PartCode,
p.ProcessCode,
p.ProcessName,
a.PartFigureCode,
a.PartName,
a.MaterialCode,
Quantity = a.SpareMateNum,
//BomQty = a.PartQuantity,
PlanType = 1,
p.ManHour,
p.WorkshopID,
p.WorkshopName,
p.EquipmentID,
p.EquipmentName,
p.WorkGroupID,
p.WorkGroupName
}).ToList <dynamic>();
return(new { list = ProductPlanList, status = 1 });
}
public void Edit_TopList(dynamic data)
{
var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>
MES_BN_ProductProcessRoute
</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>
");
var service = new MES_BN_ProductProcessRouteService();
var result = service.Edit(null, formWrapper, data);
}
public dynamic GetBom(string parentCode, string ContractCode, string ProductName)
{
var list = new MES_BN_ProductProcessRouteService().GetGYBom(parentCode);
//var notShowList = new MES_BN_MatchingTableDetailService().GetNotShowBom(parentCode, ContractCode, ProductName, "0");
//foreach (var item in notShowList)
//{
// var part = (from p in list where p.PartCode == item select p).FirstOrDefault();
// if (part != null)
// {
// list.Remove(part);
// }
//}
return(list);
}
public dynamic Get(RequestWrapper query)
{
query.LoadSettingXmlString(@"
<settings defaultOrderBy='ProcessLineCode'>
<select>*</select>
<from>MES_BN_ProductProcessRoute</from>
<where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true' >
<field name='ContractCode' cp='equal'></field>
<field name='PartCode' cp='equal'></field>
</where>
</settings>");
var service = new MES_BN_ProductProcessRouteService();
var pQuery = query.ToParamQuery();
var result = service.GetDynamicListWithPaging(pQuery);
return(result);
}
public int PostOnGYSave2(List <MES_BN_ProductProcessRoute> model)
{
if (model.Count < 0)
{
return(0);
}
else
{
int result = 0;
if (model[0].ID <= 0)
{
result = new MES_BN_ProductProcessRouteService().Insert(model[0]);
}
else
{
result = new MES_BN_ProductProcessRouteService().Update2(model[0]);
}
return(result);
}
}
public string GetNewRowId(string type, string key, int qty = 1)
{
switch (type)
{
case "grid0":
var service0 = new MES_BN_ProductProcessRouteDetailService();
return(service0.GetNewKey("ID", "maxplus", qty, null));
case "grid1":
var service1 = new MES_BN_ProductProcessRouteEquipmentService();
return(service1.GetNewKey("ID", "maxplus", qty, null));
case "grid":
var service = new MES_BN_ProductProcessRouteService();
return(service.GetNewKey("ID", "maxplus", qty, null));
default:
return("");
}
}
public void Edit(dynamic data)
{
var tabsWrapper = new List <RequestWrapper>();
tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>MES_BN_ProductProcessRouteDetail</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>"));
tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@"
<settings>
<table>MES_BN_ProductProcessRouteEquipment</table>
<where>
<field name='ID' cp='equal'></field>
</where>
</settings>"));
var service = new MES_BN_ProductProcessRouteService();
var result = service.EditPage(data, null, tabsWrapper);
}
