public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> PRS_BarCreateMate </table> <where> <field name='ID' cp='equal'></field> </where> </settings>"); var service = new PRS_BarCreateMateService(); var result = service.Edit(null, listWrapper, data); }
public dynamic Get(RequestWrapper query) { query.LoadSettingXmlString(@" <settings defaultOrderBy='ID'> <select>a.*,b.FigureCode</select> <from>PRS_BarCreateMate a left join SYS_Part b on a.InventoryCode=b.InventoryCode</from> <where defaultForAll='true' defaultCp='equal' defaultIgnoreEmpty='true'> <field name='ContractCode' cp='equal'></field> </where> </settings>"); var service = new PRS_BarCreateMateService(); var pQuery = query.ToParamQuery(); var result = service.GetDynamicListWithPaging(pQuery); return(result); }
public void PostCreateProductRequest(dynamic data) { var list = data.list; foreach (dynamic item in list) { string ContractCode = item["ContractCode"]; string CreateType = item["CreateType"]; var BoardOrBarData = new List <dynamic>(); switch (CreateType) { case "板材": BoardOrBarData = new PRS_BoardCreateMateService().GetDynamicList(ParamQuery.Instance().AndWhere("ContractCode", ContractCode)); break; case "棒材": BoardOrBarData = new PRS_BarCreateMateService().GetDynamicList(ParamQuery.Instance().AndWhere("ContractCode", ContractCode)); break; case "车间": int MainID = item["ID"]; BoardOrBarData = new MES_WorkshopPurchaseDetailService().GetDynamicList ( ParamQuery .Instance() .Select("InventoryCode,PurchaseQuantity as InventoryNum,Remark") .From("MES_WorkshopPurchaseDetail") .AndWhere("MainID", MainID) ); break; default: break; } using (var db = Db.Context("Mms")) { db.UseTransaction(true); try { int MainID = new APS_ProductPurchaseMainService().GetModelList().Count > 0 ? new APS_ProductPurchaseMainService().GetModelList().Max(a => a.ID) + 1 : 1; db.Insert("APS_ProductPurchaseMain") .Column("ID", MainID) .Column("PurchaseDocumentCode", MmsHelper.GetOrderNumber("APS_ProductPurchaseMain", "PurchaseDocumentCode", "SCQG", "", "")) .Column("ContractCode", ContractCode) .Column("DepartmentCode", "0202") .Column("PurchaseDate", DateTime.Now) .Column("IsEnable", 1) .Column("BillState", 1) .Column("PurchaseType", CreateType.Equals("板材") ? 2 : CreateType.Equals("棒材") ? 3 : CreateType.Equals("车间") ? 4 : 1) .Column("CreateTime", DateTime.Now) .Column("CreatePerson", MmsHelper.GetUserName()).Execute(); foreach (var item_board in BoardOrBarData) { double PurchaseQuantity = Convert.ToDouble(item_board.InventoryNum); string InventoryCode = item_board.New_InventoryCode; string Remark = item_board.Remark; string unit = ""; if (CreateType != "车间") { unit = item_board.Unit; } db.Insert("APS_ProductPurchaseDetail") .Column("MainID", MainID) //.Column("InventoryCode", InventoryCode) .Column("InventoryCode", InventoryCode) .Column("TotalRequestQuantity", Convert.ToInt32(PurchaseQuantity)) .Column("PurchaseQuantity", PurchaseQuantity) .Column("StockQuantity", 0) .Column("PurchaseState", 0) .Column("DepartmentCode", "0202") .Column("DepartmentName", "供应") .Column("IsEnable", 1) .Column("CreateTime", DateTime.Now) .Column("Remark", Remark) .Column("Unit", unit) .Column("CreatePerson", MmsHelper.GetUserName()).ExecuteReturnLastId <int>(); } db.Commit(); } catch (Exception ex) { db.Rollback(); break; } } } }
/// <summary> /// /// </summary> /// <param name="bomList"></param> /// <returns></returns> public bool GetIsSum(string bomList) { bool IsCheck = new PRS_BarCreateMateService().GetIsSum2(bomList).Select(a => Convert.ToString(a.New_InventoryCode)).Distinct().Count() > 1 ? false : true; return(IsCheck); }