public dynamic PostProjectDetailOnSave(List <PMS_BN_ProjectDetail> model) { int result = 0; if (model.Count > 0) { if (model[0].ID <= 0) { model[0].CreateTime = DateTime.Now; model[0].ModifyTime = model[0].CreateTime; model[0].CreatePerson = MmsHelper.GetUserCode(); model[0].ModifyPerson = model[0].CreatePerson; result = new PMS_BN_ProjectDetailService().Insert(model[0]); } else { result = new PMS_BN_ProjectDetailService().Update(model[0]); } } return(new { result = result }); }
public string PostStorage(dynamic data) { string msg = ""; string BillCode = data["BillCode"]; var result = new QMS_ProcessInspectionItemService().AuditBillCode(data["BillCode"].ToString(), out msg); //生成物料条码:自制件 var QMS_ProcessInspectionModel = new QMS_ProcessInspectionService().GetModel(ParamQuery.Instance().AndWhere("BillCode", BillCode)); if (QMS_ProcessInspectionModel != null) { string InnerFactoryBatch = QMS_ProcessInspectionModel.BatchCode; //厂内批次 string OuterFactoryBatch = QMS_ProcessInspectionModel.OuterFactoryBatch; //厂外批次 string PartCode = QMS_ProcessInspectionModel.PartCode; string PartName = QMS_ProcessInspectionModel.PartName; string PartFigureCode = QMS_ProcessInspectionModel.partFigure; string ContractCode = QMS_ProcessInspectionModel.ContractCode; string ProductName = QMS_ProcessInspectionModel.ProductName; int ProductID = new PMS_BN_ProjectDetailService().GetModel(ParamQuery.Instance().AndWhere("ProductName", ProductName)).ID; var ProcessBomModel = new PRS_Process_BOMService().GetModel(ParamQuery.Instance().AndWhere("PartCode", PartCode)); if (ProcessBomModel != null) { string InventoryCode = ProcessBomModel.InventoryCode; //存货编码 string InventoryName = ProcessBomModel.InventoryName; //存货名称 var SYS_MaterialBatchModel = new SYS_MaterialBatchService().GetModel(ParamQuery.Instance() .AndWhere("PartCode", PartCode) .AndWhere("InnerFactoryBatch", InnerFactoryBatch) .AndWhere("OuterFactoryBatch", OuterFactoryBatch)); if (SYS_MaterialBatchModel == null) { var model = new SYS_MaterialBatchService(); string MateBarCode = model.CreateMateBarCode(700000000000); model.Insert(ParamInsert.Instance() .Insert("SYS_MaterialBatch") .Column("MateBarCode", MateBarCode) .Column("InventoryCode", InventoryCode) .Column("InventoryName", InventoryName) .Column("PartCode", PartCode) .Column("PartFigureCode", PartFigureCode) .Column("PartName", PartName) .Column("InnerFactoryBatch", InnerFactoryBatch) .Column("OuterFactoryBatch", OuterFactoryBatch) .Column("ContractCode", ContractCode) .Column("ProductID", ProductID)); } } } return(msg); }
public dynamic GetProductTreeList([FromUri] TreeNodeModel model) { var PMS_BN_ProjectDetailList = new PMS_BN_ProjectDetailService().GetModelList(); var PRS_Process_BOMList = new PRS_Process_BOMService().GetModelList(); var APS_ProjectProduceDetialList = new APS_ProjectProduceDetialService().GetModelList(); var list = TreeNodeManage.GetTreeNodeList <dynamic>( TreeNodeManage.Instance() .SetNode(model.NodeField) .SetParentNode(model.ParentNodeField, model.ParentNodeValue) .SetTableName(model.TableName) .SetNodeLevel(model.IsLevel) .SetTreeSetting(model.TreeSetting) .SetWhereSql(model.WhereSql)); var new_list = new List <dynamic>(); list.ForEach(item => { dynamic item_old = item; string ContractCode = item_old.ContractCode; int ProductID = item_old.ProductID; string PartCode = item_old.PartCode; var Quantity = PMS_BN_ProjectDetailList.Where(a => a.ID == ProductID).FirstOrDefault().Quantity ?? 0; //合同台数 var PartQuantity = PRS_Process_BOMList.Where(a => a.PartCode == PartCode && a.ContractCode == ContractCode && a.ProductID == ProductID).FirstOrDefault().PartQuantity ?? 0; //单台数量 int ProductTotal = Quantity * PartQuantity; //生产总数=合同台数*单台数量 //已生产数量 //var ProcuctList = APS_ProjectProduceDetialList //.Where(a => a.ContractCode == ContractCode && a.ProjectDetailID == ProductID && a.PartCode == PartCode) //.GroupBy(a => new { a.ProcessModelType, a.MonthPlanCode }) //.Select(a => new { ProcessType = a.Key.ProcessModelType, a.Key.MonthPlanCode, Quantity = a.Max(b => b.Quantity) }); var ProcuctList = APS_ProjectProduceDetialList .Where(a => a.ContractCode == ContractCode && a.ProjectDetailID == ProductID && a.PartCode == PartCode) .GroupBy(a => new { a.ProcessModelType, a.ProcessCode }) .Select(a => new { ProcessType = a.Key.ProcessModelType, ProcessCode = a.Key.ProcessCode, Quantity = a.Sum(b => b.Quantity) }); int BlankingTotal = ProcuctList.Where(a => a.ProcessType == "1").FirstOrDefault() == null ? 0 : ProcuctList.Where(a => a.ProcessType == "1").FirstOrDefault().Quantity ?? 0; int WeldingTotal = ProcuctList.Where(a => a.ProcessType == "2").FirstOrDefault() == null ? 0 : ProcuctList.Where(a => a.ProcessType == "2").FirstOrDefault().Quantity ?? 0; int MachiningTotal = ProcuctList.Where(a => a.ProcessType == "3").FirstOrDefault() == null ? 0 : ProcuctList.Where(a => a.ProcessType == "3").FirstOrDefault().Quantity ?? 0; int AssemblingTotal = ProcuctList.Where(a => a.ProcessType == "4").FirstOrDefault() == null ? 0 : ProcuctList.Where(a => a.ProcessType == "4").FirstOrDefault().Quantity ?? 0; item_old.BlankingTotal = BlankingTotal.ToString() + "/" + ProductTotal.ToString(); item_old.WeldingTotal = WeldingTotal.ToString() + "/" + ProductTotal.ToString(); item_old.MachiningTotal = MachiningTotal.ToString() + "/" + ProductTotal.ToString(); item_old.AssemblingTotal = AssemblingTotal.ToString() + "/" + ProductTotal.ToString(); new_list.Add(item_old); }); return(new_list); }
public void Edit(dynamic data) { var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>PMS_BN_ProjectDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); var service = new PMS_BN_ProjectDetailService(); var result = service.EditPage(data, null, tabsWrapper); }
public dynamic GetPageData(string id = "") { var pQuery = ParamQuery.Instance(); if (id == "") { var result = new { tab0 = "", }; return(result); } else { List <dynamic> data = new List <dynamic>(); data = new PMS_BN_ProjectDetailService().GetDynamicList(pQuery.AndWhere("MainID", id)); var result = new { rows = data, total = data.Count }; return(result); } }
public string GetNewRowId(string type, string key, int qty = 1) { var service0 = new PMS_BN_ProjectDetailService(); return(service0.GetNewKey("ID", "maxplus", qty, ParamQuery.Instance().AndWhere("ID", key, Cp.Equal))); }