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); }