public void Edit(dynamic data) { dynamic insert_list = data.list.inserted; if (data.list.inserted.ToString() != "[]") { var PlanCode = MmsHelper.GetOrderNumber("SYS_DrawingApplication", "RequestCode", "TZSQ", "", ""); string PreCode = PlanCode.Substring(0, PlanCode.Length - 3); int StartNumber = Convert.ToInt32(PlanCode.Substring(PlanCode.Length - 3)); foreach (dynamic item in data.list.inserted) { item["RequestCode"] = PreCode + StartNumber.ToString().PadLeft(3, '0'); StartNumber++; } } var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> SYS_DrawingApplication </table> <where> <field name='ID' cp='equal'></field> </where> </settings>"); var service = new SYS_DrawingApplicationService(); var result = service.Edit(null, listWrapper, data); }
public void Edit(dynamic data) { var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> MES_MaterialReturnMain </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>MES_MaterialReturnDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); if (data.form["BillCode"] == "系统生成") { string documentNo = MmsHelper.GetOrderNumber("MES_MaterialReturnMain", "BillCode", "CJTL", "", ""); data.form["BillCode"] = documentNo; } var service = new MES_MaterialReturnMainService(); var result = service.EditPage(data, formWrapper, tabsWrapper); }
public dynamic PostProductionTaskDetailOnSave(List <PMS_ProductPlanDetail> model) { int result = 0; if (model.Count > 0) { if (model[0].ID <= 0) { model[0].ProductPlanCode = MmsHelper.GetOrderNumber("PMS_ProductPlanDetail", "ProductPlanCode", "PCSC", "", ""); 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_ProductPlanDetailService().Insert(model[0]); } else { result = new PMS_ProductPlanDetailService().Update(model[0]); } } return(new { result = result > 0 }); }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> APS_ProjectProduceDetial </table> <where> <field name='ID' cp='equal'></field> </where> </settings>"); var service = new APS_ProjectProduceDetialService(); if (data.list.inserted.ToString() != "[]") { //APS明细表新增 var PlanCode = MmsHelper.GetOrderNumber("APS_ProjectProduceDetial", "ApsCode", "SCJH", "", ""); string PreCode = PlanCode.Substring(0, PlanCode.Length - 3); int StartNumber = Convert.ToInt32(PlanCode.Substring(PlanCode.Length - 3)); foreach (dynamic row in data.list.inserted) { var ApsCode = PreCode + StartNumber.ToString().PadLeft(3, '0'); row["ApsCode"] = ApsCode; StartNumber++; } } var result = service.Edit(null, listWrapper, data); }
public void Edit(dynamic data) { var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> APS_ProductPurchaseMain </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>APS_ProductPurchaseDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); if (data.form["PurchaseDocumentCode"] == "系统生成") { string documentNo = MmsHelper.GetOrderNumber("APS_ProductPurchaseMain", "PurchaseDocumentCode", "SCQG", "", ""); data.form["PurchaseDocumentCode"] = documentNo; } var service = new APS_ProductPurchaseMainService(); var result = service.EditPage(data, formWrapper, tabsWrapper); }
/// <summary> /// 物料转序入库 /// </summary> /// <param name="data"></param> /// <returns></returns> public dynamic PostMaterialTurnInputStorage(dynamic data) { try { DateTime newDT = DateTime.Now; string documentNo = MmsHelper.GetOrderNumber("WMS_BN_BillMain", "BillCode", "ZXRK", "", ""); WMS_BN_BillMain bMainModel = new WMS_BN_BillMain() { ID = Convert.ToInt32(new WMS_BN_BillMainService().GetNewKey("ID", "Maxplus")), BillCode = documentNo, BillType = 8, IsEnable = 1, ContractCode = data["mainData"]["ContractCode"], ProjectName = data["mainData"]["ProjectName"], WarehouseCode = data["mainData"]["WarehouseCode"], WarehouseName = data["mainData"]["WarehouseName"], ApproveState = data["mainData"]["ApproveState"], ApprovePerson = data["mainData"]["UserName"], ApproveDate = newDT, CreatePerson = data["mainData"]["UserName"], CreateTime = newDT, ModifyPerson = data["mainData"]["UserName"], ModifyTime = newDT }; List <WMS_BN_BillDetail> bDetailModels = new List <WMS_BN_BillDetail>(); bDetailModels.Add(new WMS_BN_BillDetail() { BillCode = documentNo, IsEnable = 1, InventoryCode = data["detailData"]["InventoryCode"], InventoryName = data["detailData"]["InventoryName"], Specs = data["detailData"]["Specs"], Unit = data["detailData"]["Unit"], MateNum = data["detailData"]["MateNum"] == null ? null : Convert.ToDouble(data["detailData"]["MateNum"]), ConfirmNum = data["detailData"]["ConfirmNum"] == null ? null : Convert.ToDouble(data["detailData"]["ConfirmNum"]), CreatePerson = data["detailData"]["UserName"], CreateTime = newDT, ModifyPerson = data["detailData"]["UserName"], ModifyTime = newDT, BatchCode = data["detailData"]["BatchCode"], PBillCode = data["detailData"]["PBillCode"] }); return(new WinFormClientService().MaterialInventory(bMainModel, bDetailModels, 1)); } catch (Exception ex) { return(new ResultModel() { Result = false, Msg = ex.Message }); } }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> PRS_DesignChangeRequest </table> <where> <field name='ID' cp='equal'></field> </where> </settings>"); var service = new PRS_DesignChangeRequestService(); List <PMS_DesignTaskDetail> dlist = new List <PMS_DesignTaskDetail>(); if (data.list.inserted.ToString() != "[]") { var dno = MmsHelper.GetOrderNumber("PRS_DesignChangeRequest", "RequestCode", "GGSQ", "", ""); var fno = dno.Substring(0, 10); var con = dno.Substring(10, 3); foreach (JToken row in data["list"]["inserted"].Children()) { row["RequestCode"] = fno + con; int intCon = Convert.ToInt32(con); intCon++; var zeros = 3 - intCon.ToString().Length; con = ""; for (int i = 1; i <= zeros; i++) { con += "0"; } con += intCon.ToString(); //var d = GetMainID(row["ContractCode"].ToString(), row["ProductID"].ToString()); //PMS_DesignTaskDetail dt = new PMS_DesignTaskDetail(); //dt.ID = -1; //dt.MainID = d; //dt.ContractCode = row["ContractCode"].ToString(); //dt.ProductID = row["ProductID"].ToString(); //dt.TaskDescription =row["ChangeContent"].ToString() ; //dt.TaskType = Convert.ToInt32(row["TypeID"]); //dt.IsEnable = 1; //dt.BillState = 0; //dt.BillCode = row["RequestCode"].ToString(); //dt.DesignType = 2; //dlist.Add(dt); } } var result = service.Edit(null, listWrapper, data); //if (dlist.Count>0) //{ // new PMS_ContractInfoApiController().PostDesignDetailOnSave(dlist); //} }
public void PostCreateBoard(out bool result, dynamic data) { try { string SavantCode = data.SavantCode; var Item = new PRS_BlankingResultService().GetModelList(ParamQuery.Instance().AndWhere("SavantCode", SavantCode)); var ItemDetail = new PRS_BlankingPlateDetailService().GetModelList(ParamQuery.Instance().AndWhere("MainID", string.Join(",", Item.Select(a => a.ID)), Cp.In)); var list = from master in Item join detail in ItemDetail on master.ID equals detail.MainID select new { MasterID = master.ID, PartBlankingQuntity = master.PartBlankingQuntity, DetailID = detail.ID, PlateSize = detail.PlateSize }; new Mes_BlankingResultService() .Delete(ParamDelete .Instance() .AndWhere("BlankingResultID", string.Join(",", Item.Select(a => a.ID)), Cp.In)); var BoardCode = MmsHelper.GetOrderNumber("Mes_BlankingResult", "BoardCode", "XJB", "", ""); string PreCode = BoardCode.Substring(0, BoardCode.Length - 3); int StartNumber = Convert.ToInt32(BoardCode.Substring(BoardCode.Length - 3)); foreach (var item in list) { int count = item.PartBlankingQuntity; for (int i = 0; i < count; i++) { BoardCode = PreCode + StartNumber.ToString().PadLeft(3, '0'); StartNumber++; db.UseTransaction(true); db.Insert("Mes_BlankingResult") .Column("BlankingResultID", item.MasterID) .Column("IsEnable", 1) .Column("CreateTime", DateTime.Now) .Column("CreatePerson", MmsHelper.GetUserCode()) .Column("BiankingSize", item.PlateSize.ToString()) .Column("IsBlanking", 0) .Column("BlankingDetailID", item.DetailID) //.Column("BlankingType",1) .Column("BoardCode", BoardCode).Execute(); } } db.Commit(); result = true; } catch { db.Rollback(); result = false; } }
// public int Update(PMS_ProductTask model) // { // var rowsAffected = db.Update<PMS_ProductTask>("PMS_ProductTask", model) //.AutoMap(x => x.ID) //.Where(x => x.ID) //.Execute(); // return rowsAffected; // } public int SaveData(List <PMS_ProductTask> model) { int result = 0; if (model.Count > 0) { using (db.UseTransaction(true)) { foreach (var item in model) { if (item.ID <= 0) { //result = new PMS_ProductTaskService().Insert(item); item.ProductTaskCode = MmsHelper.GetOrderNumber("PMS_ProductTask", "ProductTaskCode", "JYRW", "", ""); item.CreateTime = DateTime.Now; item.CreatePerson = MmsHelper.GetUserCode(); item.ModifyTime = DateTime.Now; item.ModifyPerson = MmsHelper.GetUserCode(); var rowsAffected = item.ID = db.Insert <PMS_ProductTask>("PMS_ProductTask", item) .AutoMap(x => x.ID) .ExecuteReturnLastId <int>(); if (rowsAffected <= 0) { result++; db.Rollback(); } } else { string sql = String.Format(@"select * from PMS_ProductTask where ID='{0}' ", item.ID); var single = db.Sql(sql).QuerySingle <PMS_ProductTask>(); item.CreatePerson = single.CreatePerson; item.CreateTime = single.CreateTime; item.ModifyPerson = MmsHelper.GetUserCode(); item.ModifyTime = DateTime.Now; var rowsAffected = item.ID = db.Update <PMS_ProductTask>("PMS_ProductTask", item) .AutoMap(x => x.ID) .Where(x => x.ID) .Execute(); if (rowsAffected <= 0) { result++; db.Rollback(); } } } if (result <= 0) { db.Commit(); } } } return(result); }
public void Edit(dynamic data) { var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> WMS_BN_BillMain </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>WMS_BN_BillDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); var service = new WMS_BN_BillMainService(); if (data.form["BillCode"] == "系统生成") { if (string.IsNullOrEmpty(WMS_BN_BillMainController.uc.Value)) { return; } string documentNo = MmsHelper.GetOrderNumber("WMS_BN_BillMain", "BillCode", WMS_BN_BillMainController.uc.Description, "", ""); data.form["BillCode"] = documentNo; foreach (JToken tab in data["tabs"].Children()) { foreach (JProperty item in tab.Children()) { if (item.Name == "inserted") { foreach (var row in item.Value.Children()) { row["BillCode"] = documentNo; } } } } } var result = service.EditPage(data, formWrapper, tabsWrapper); }
public void Edit(dynamic data) { var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> QMS_ProcessInspection </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>QMS_ProcessInspectionItem</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); if (data.form["BillCode"] == "系统生成") { string documentNo = MmsHelper.GetOrderNumber("QMS_ProcessInspection", "BillCode", "GCJY", "", ""); data.form["BillCode"] = documentNo; //foreach (JToken tab in data["tabs"].Children()) //{ // foreach (JProperty item in tab.Children()) // { // if (item.Name == "inserted") // { // foreach (var row in item.Value.Children()) // { // row["BillCode"] = documentNo; // } // } // } //} } var service = new QMS_ProcessInspectionService(); var result = service.EditPage(data, formWrapper, tabsWrapper); }
public void Edit(dynamic data) { var service = new MES_WorkshopPurchaseMainService(); if (data.form["WorkshopPurchaseCode"] != "系统生成") { var pQuery = ParamQuery.Instance().Select("*").AndWhere("ID", data.form["ID"]); MES_WorkshopPurchaseMain model = service.GetModel(pQuery); if (model.ApproveState != null && model.ApproveState == "2") { MmsHelper.ThrowHttpExceptionWhen(true, "已发布的不能修改!"); return; } } var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> MES_WorkshopPurchaseMain </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>MES_WorkshopPurchaseDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); if (data.form["WorkshopPurchaseCode"] == "系统生成") { string documentNo = MmsHelper.GetOrderNumber("MES_WorkshopPurchaseMain", "WorkshopPurchaseCode", "CJQG", "", ""); data.form["WorkshopPurchaseCode"] = documentNo; } var result = service.EditPage(data, formWrapper, tabsWrapper); }
public void Edit(dynamic data) { string TurnTargetCode = "", TurnTargetName = ""; var ApsList = new APS_ProjectProduceDetialService().GetModelList(); dynamic insert_list = data.list.inserted; if (data.list.inserted.ToString() != "[]") { var PlanCode = MmsHelper.GetOrderNumber("MES_WorkingTicket", "WorkTicketCode", "ZYGP", "", ""); string PreCode = PlanCode.Substring(0, PlanCode.Length - 3); int StartNumber = Convert.ToInt32(PlanCode.Substring(PlanCode.Length - 3)); foreach (dynamic item in data.list.inserted) { item["ApproveState"] = 1; item["WorkTicketCode"] = PreCode + StartNumber.ToString().PadLeft(3, '0'); string ApsCode = item["ApsCode"]; var ApsItem = ApsList.Where(a => a.ApsCode == ApsCode).FirstOrDefault(); var TurnTargetModel = new WinFormClientService().GetTurnTarget(ApsItem.ID); bool Result = TurnTargetModel.Result; if (Result) { TurnTargetCode = TurnTargetModel.Data.ID; TurnTargetName = TurnTargetModel.Data.Name; } item["TurnTargetCode"] = TurnTargetCode; item["TurnTargetName"] = TurnTargetName; StartNumber++; } } var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> MES_WorkingTicket </table> <where> <field name='ID' cp='equal'></field> </where> </settings>"); var service = new MES_WorkingTicketService(); var result = service.Edit(null, listWrapper, data); }
public void Edit(dynamic data) { var listWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> APS_ProjectProduceDetial </table> <where> <field name='ID' cp='equal'></field> </where> </settings>"); var service = new APS_ProjectProduceDetialService(); if (data.list.inserted.ToString() != "[]") { //APS明细表新增 var PlanCode = MmsHelper.GetOrderNumber("APS_ProjectProduceDetial", "ApsCode", "SCJH", "", ""); string PreCode = PlanCode.Substring(0, PlanCode.Length - 3); int StartNumber = Convert.ToInt32(PlanCode.Substring(PlanCode.Length - 3)); foreach (dynamic row in data.list.inserted) { var ApsCode = PreCode + StartNumber.ToString().PadLeft(3, '0'); row["ApsCode"] = ApsCode; string MonthPlanStr = row.MonthPlanCode; var MonthPlanList = MonthPlanStr.Split(','); for (int i = 0; i < MonthPlanList.Length; i++) { new APS_ProduceAndMonthPlanService().Insert( ParamInsert.Instance() .Insert("APS_ProduceAndMonthPlan") .Column("ProducePlanCode", ApsCode) .Column("MonthPlanCode", MonthPlanList[i]) .Column("CreateTime", DateTime.Now) .Column("CreatePerson", MmsHelper.GetUserCode())); } StartNumber++; } } var result = service.Edit(null, listWrapper, data); }
public void Edit(dynamic data) { var id = data.form["ID"].ToString(); var pQuery = ParamQuery.Instance().Select("*").AndWhere("ID", id); var re = new PRS_RectificationMainService().GetModelList(pQuery); if (re.Count > 0 && re[0].BillState == 1) { MmsHelper.ThrowHttpExceptionWhen(true, "已审核数据不能修改!"); return; } var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> PRS_RectificationMain </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>PRS_RectificationDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); if (data.form["BillCode"] == "系统生成") { string documentNo = MmsHelper.GetOrderNumber("PRS_RectificationMain", "BillCode", "SCZG", "", ""); data.form["BillCode"] = documentNo; } var service = new PRS_RectificationMainService(); var result = service.EditPage(data, formWrapper, tabsWrapper); }
public void Edit(dynamic data) { var BatchingCode = MmsHelper.GetOrderNumber("MES_WorkshopBatching", "BatchingCode", "PLD", "", ""); data.form.BatchingCode = BatchingCode; dynamic InsertList = data.tabs[0].inserted; foreach (dynamic item in InsertList) { item.BatchingCode = BatchingCode; } var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> MES_WorkshopBatching </table> <where> <field name='BatchingCode' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>MES_WorkshopBatchingDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); var service = new MES_WorkshopBatchingService(); var result = service.EditPage(data, formWrapper, tabsWrapper); }
public int AuditBillCode(string BillCode, out string msg) { msg = string.Empty; var rowsAffected = 0; string sql = String.Format(@"SELECT t1.*, t2.InventoryCode, t2.InventoryName, t2.RequiredQuantity, t2.Model, t2.Unit, t2.Material FROM dbo.MES_MaterialPickMain t1 INNER JOIN dbo.MES_MaterialPickDetail t2 ON t1.ID = t2.MainID AND t1.IsEnable = 1 AND t2.IsEnable = 1 where t1.BillCode='{0}'", BillCode); string insertSql = ""; dynamic MaterialPick = db.Sql(sql).QueryMany <dynamic>(); if (MaterialPick.Count == 0) { msg = "请保存数据后审核"; return(0); } if (MaterialPick[0].BillState == 2) { msg = "单据已审核"; return(0); } else { using (var trans = db.UseTransaction(true)) { sql = string.Format(@"update MES_MaterialPickMain set BillState=2 where BillCode='{0}'", BillCode); rowsAffected = db.Sql(sql).Execute(); var dno = MmsHelper.GetOrderNumber("WMS_BN_BillMain", "BillCode", "LLCK", "", ""); insertSql = string.Format(@" INSERT dbo.WMS_BN_BillMain ( ID, BillCode, BillType, ContractCode, ProjectName, DepartmentID, DepartmentName, WarehouseCode, WarehouseName, ApproveState, Remark, CreatePerson, CreateTime, ModifyPerson, ModifyTime, IsEnable, PickPerson, PickPersonCode ) VALUES ( (select MAX(id)+1 from WMS_BN_BillMain), -- ID - int ID, '{0}', -- BillCode - varchar(50) BillCode, ( SELECT Value FROM HBHC_Sys.dbo.sys_code WHERE Text='领料出库' ), --BillType, '{1}','{2}','{3}','{4}','{5}','{6}',1,'','{7}','{8}','{9}','{10}',1,'{11}','{12}' )" , dno, MaterialPick[0].ContractCode, MaterialPick[0].ProjectName, MaterialPick[0].DepartmentID, MaterialPick[0].DepartmentName, MaterialPick[0].WarehouseCode, MaterialPick[0].WarehouseName, MmsHelper.GetUserName(), DateTime.Now, MmsHelper.GetUserName(), DateTime.Now, MmsHelper.GetUserName(), MmsHelper.GetUserCode()); foreach (var item in MaterialPick) { insertSql += string.Format(@"INSERT INTO dbo.WMS_BN_BillDetail ( BillCode, InventoryCode, InventoryName, Specs, Unit, MateNum, ConfirmNum, PBillCode, Remark, CreatePerson, CreateTime, ModifyPerson, ModifyTime, IsEnable ) VALUES ( '{0}', -- BillCode - varchar(50) N'{1}', -- InventoryCode - nvarchar(50) N'{2}', -- InventoryName - nvarchar(50) '{3}', -- Specs - varchar(50) N'{4}', -- Unit - nvarchar(10) '{5}', -- MateNum - float '{6}', -- ConfirmNum - float '{7}', -- PBillCode - varchar(50) N'', -- Remark - nvarchar(500) N'{8}', -- CreatePerson - nvarchar(50) GETDATE(), -- CreateTime - datetime N'{9}', -- ModifyPerson - nvarchar(50) GETDATE(), -- ModifyTime - datetime 1 -- IsEnable - int )", dno, item.InventoryCode, item.InventoryName, item.Model, item.Unit, item.RequiredQuantity, item.RequiredQuantity, item.BillCode, MmsHelper.GetUserName(), MmsHelper.GetUserName()); } var res = db.Sql(insertSql).Execute(); if (rowsAffected > 0 && res == MaterialPick.Count + 1) { msg = "检验记录审核成功"; trans.Commit(); return(rowsAffected); } else { trans.Rollback(); msg = "检验记录审核失败"; return(0); } } } }
public ResultModel SaveBlankingPlanData(dynamic data) { try { //List<int> productIDs = new List<int>(); //List<int> pbomIDs = new List<int>(); // //foreach (var item in data) //{ // productIDs.Add(data[0].product_ID); // pbomIDs.Add(data[0].pbom_ID); //} // //List<PMS_BN_ProjectDetail> listA = db.Sql(string.Format(@"SELECT * FROM dbo.PMS_BN_ProjectDetail WHERE IsEnable = 1 AND ID IN ({0})", string.Join(",", productIDs))).QueryMany<PMS_BN_ProjectDetail>(); //List<PRS_Process_BOM> listB = db.Sql(string.Format(@"SELECT * FROM dbo.PRS_Process_BOM WHERE IsEnable = 1 AND ID IN ({0})", string.Join(",", pbomIDs))).QueryMany<PRS_Process_BOM>(); StringBuilder sb = new StringBuilder(); string savantCode = MmsHelper.GetOrderNumber("MES_SavantManage", "SavantCode", "ZJJ", "", ""); DateTime newDT = DateTime.Now; int partTotalNum = 0; foreach (var item in data) { //PMS_BN_ProjectDetail product = listA.Single(i => i.ID.Equals(item.product_ID)); //PRS_Process_BOM pbom = listB.Single(i => i.ID.Equals(item.pbom_ID)); //零件总数 partTotalNum += ((int?)item.BlankingNum ?? 0); sb.Append(WinFormClientService.GetInsertSQL(new MES_SavantAndPBom() { SavantCode = savantCode, ProcessBomID = item.pbom_ID, BlankingNum = item.BlankingNum, CreatePerson = MmsHelper.GetUserName(), CreateTime = newDT, ModifyPerson = MmsHelper.GetUserName(), ModifyTime = newDT })); } string iCode = new SYS_PartService().GetSysPartAutoMaxICode("030502"); sb.Append(WinFormClientService.GetInsertSQL(new MES_SavantManage() { SavantCode = savantCode, ProcessBomID = data[0].pbom_ID, SpareMateSize = data[0].BlankingSize, SpareMateNum = partTotalNum,//备料数量 IsEnable = 1, CreatePerson = MmsHelper.GetUserName(), CreateTime = newDT, ModifyPerson = MmsHelper.GetUserName(), ModifyTime = newDT, SplitNum = 1,//切分数量 InventoryCode = iCode })); sb.Append(WinFormClientService.GetInsertSQL(new SYS_Part() { InventoryCode = iCode, InventoryName = data[0].SetMateName, Model = data[0].BlankingSize, IsEnable = 1, CreatePerson = MmsHelper.GetUserName(), CreateTime = newDT, ModifyPerson = MmsHelper.GetUserName(), ModifyTime = newDT })); string sql = sb.ToString(); db.UseTransaction(true); bool result = db.Sql(sql).Execute() > 0; if (result) { db.Commit(); } else { db.Rollback(); } return(new ResultModel() { Result = result, Msg = result ? @"操作成功!" : @"操作失败!" }); } catch (Exception ex) { return(new ResultModel() { Result = false, Msg = ex.Message }); } }
public string GetFailureReportCode( ) { string documentNo = MmsHelper.GetOrderNumber("EQP_FailureReport", "FailureReportCode", "GZBG", "", ""); return(documentNo); }
public string GetCode() { string documentNo = MmsHelper.GetOrderNumber("SYS_BN_Supplier", "SupplierCode", "GYBH", "", ""); return(documentNo); }
public string GetCode() { string documentNo = MmsHelper.GetOrderNumber("SYS_BN_User", "UserCode", "YGBH", "", ""); return(documentNo); }
public void Edit(dynamic data) { var service = new MES_MaterialPickMainService(); if (data.form["BillCode"] != "系统生成") { var pQuery = ParamQuery.Instance().Select("*").AndWhere("ID", data.form["ID"]); MES_MaterialPickMain model = service.GetModel(pQuery); if (model.BillState != null && model.BillState == 2) { MmsHelper.ThrowHttpExceptionWhen(true, "已发布的不能修改!"); return; } } var ids = "("; foreach (JToken tab in data["tabs"].Children()) { foreach (JProperty item in tab.Children()) { if (item.Name == "deleted") { foreach (var row in item.Value.Children()) { ids += "'" + row["ID"] + "',"; } item.Value = "[]"; } } } if (ids != "(") { ids = ids.Remove(ids.Length - 1, 1); ids += ")"; using (var db = Db.Context("Mms")) { string sql1 = string.Format("update MES_MaterialPickDetail set IsEnable=0 where ID in {0} ", ids); db.Sql(sql1).Execute(); } } var formWrapper = RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table> MES_MaterialPickMain </table> <where> <field name='ID' cp='equal'></field> </where> </settings> "); var tabsWrapper = new List <RequestWrapper>(); tabsWrapper.Add(RequestWrapper.Instance().LoadSettingXmlString(@" <settings> <table>MES_MaterialPickDetail</table> <where> <field name='ID' cp='equal'></field> </where> </settings>")); if (data.form["BillCode"] == "系统生成") { string documentNo = MmsHelper.GetOrderNumber("MES_MaterialPickMain", "BillCode", "CJLL", "", ""); data.form["BillCode"] = documentNo; } var result = service.EditPage(data, formWrapper, tabsWrapper); }
public int AuditBillCode(string mainID, out string msg) { msg = string.Empty; var rowsAffected = 0; string insertSql = string.Empty; string sql = String.Format(@" SELECT t1.*, t2.MainID, t2.InventoryCode, t2.InventoryName, t2.ArrivalQuatity, t2.Model, t2.Unit, t2.Material FROM MES_GoodsInspection t1 LEFT JOIN MES_GoodsInspectionDetail t2 ON t1.ID = t2.MainID AND t1.IsEnable = 1 AND t2.IsEnable = 1 where t1.ID='{0}'", mainID); var resList = db.Sql(sql).QueryMany <dynamic>(); if (resList.Count == 0) { msg = "请先保存单据后再审核"; return(0); } if (resList[0].BillState == 2) { msg = "单据已审核"; return(0); } else { db.UseTransaction(true); sql = string.Format(@"update MES_GoodsInspection set BillState=2 where ID='{0}'", mainID); rowsAffected = db.Sql(sql).Execute(); if (rowsAffected > 0) { sql = string.Format(@"select ID from MES_PurchaseOrderMain where BillCode='{0}'", resList[0].PurchaseOrderCode); int mID = db.Sql(sql).QuerySingle <int>(); sql = string.Empty; var dno = MmsHelper.GetOrderNumber("QMS_GoodsCheck", "BillCode", "LLJY", "", ""); var fno = dno.Substring(0, 10); var con = dno.Substring(10, 3); StringBuilder sb = new StringBuilder(); foreach (var item in resList) { dno = fno + con; int intCon = Convert.ToInt32(con); intCon++; var zeros = 3 - intCon.ToString().Length; con = ""; for (int i = 1; i <= zeros; i++) { con += "0"; } con += intCon.ToString(); sql = sql + string.Format(@" update MES_PurchaseOrderDetail set GoodsQuantity=ISNULL(GoodsQuantity,0)+ abs({0}) where MainID='{1}' and InventoryCode='{2}' ", item.ArrivalQuatity, mID, item.InventoryCode); sb.Append(string.Format(@"INSERT INTO dbo.QMS_GoodsCheck ( ID, PBillCode, BillCode, ContractCode, ProjectName, SupplierCode, SupplierName, DepartmentID, DepartmentName, WarehouseID, WarehouseName, ProductionUnits, InventoryCode, InventoryName, Model, ArrivalDate, CheckQuantity, QualifiedQuantity, Unit, SalesmanCode, Salesman, BatchCode, BillState, IsEnable, CreatePerson, CreateTime, ModifyPerson, ModifyTime, Material, InspectionQuantity ) VALUES ( (select MAX(id)+1 from QMS_GoodsCheck), -- ID - int '{0}', -- PBillCode - varchar(50) '{1}', -- BillCode - varchar(50) '{2}', -- ContractCode - varchar(50) '{3}', -- ProjectName - varchar(50) '{4}', -- SupplierCode - varchar(50) '{5}', -- SupplierName - varchar(50) '{6}', -- DepartmentID - varchar(50) '{7}', -- DepartmentName - varchar(50) '{8}', -- WarehouseID - varchar(50) '{9}', -- WarehouseName - varchar(50) '{10}', -- ProductionUnits - varchar(50) '{11}', -- InventoryCode - varchar(50) '{12}', -- InventoryName - varchar(50) '{13}', -- Model - varchar(50) '{14}', -- ArrivalDate - datetime '{15}', -- CheckQuantity - int '{16}', -- QualifiedQuantity - int '{17}', -- Unit - varchar(50) '{18}', -- SalesmanCode - varchar(50) '{19}', -- Salesman - varchar(50) '', -- BatchCode - varchar(50) 1, -- BillState - int 1, -- IsEnable - int '{20}', -- CreatePerson - varchar(50) GETDATE(), -- CreateTime - datetime '{21}', -- ModifyPerson - varchar(50) GETDATE(), -- ModifyTime - datetime '{22}', -- Material - varchar(50) '{23}' -- InspectionQuantity - int )", item.BillCode, dno, item.ContractCode, item.ProjectName, item.SupplierCode, item.SupplierName, item.DepartmentID, item.DepartmentName, item.WarehouseID, item.WarehouseName, "", item.InventoryCode, item.InventoryName, item.Model, item.ArrivalDate, item.ArrivalQuatity, item.ArrivalQuatity, item.Unit, item.SaleMan, item.UserCode, MmsHelper.GetUserName(), MmsHelper.GetUserName(), item.Material, item.ArrivalQuatity)); } int res = db.Sql(sb.ToString()).Execute(); rowsAffected = db.Sql(sql).Execute(); if (rowsAffected > 0 && res == resList.Count) { msg = "操作成功"; db.Commit(); return(rowsAffected); } else { msg = "操作失败"; db.Rollback(); return(0); } //return rowsAffected; } else { msg = "采购订单审核失败"; db.Rollback(); return(0); } //sql = string.Format(@"update APS_ProductPurchaseMain set BillState=2 where PurchaseDocumentCode='{0}'", res.ProductPurchaseCode); } }
public int AuditBillCode(string BillCode, out string msg) { msg = string.Empty; var rowsAffected = 0; string sql = String.Format(@"SELECT t1.*, t3.ProductPurchaseCode, t4.Model, t4.Unit, t4.UnitPrice, t4.TotalPrice FROM dbo.QMS_GoodsCheck t1 INNER JOIN dbo.MES_GoodsInspection t2 ON t1.PBillCode = t2.BillCode AND t2.IsEnable = 1 INNER JOIN dbo.MES_PurchaseOrderMain t3 ON t2.PurchaseOrderCode = t3.BillCode AND t3.IsEnable = 1 AND t3.BillState = 2 INNER JOIN dbo.MES_PurchaseOrderDetail t4 ON t4.MainID = t3.ID AND t4.IsEnable = 1 where t1.BillCode='{0}'", BillCode); string insertSql = ""; dynamic GoodsCheck = db.Sql(sql).QueryMany <dynamic>(); if (GoodsCheck.Count == 0) { msg = "请保存数据后审核"; return(0); } if (GoodsCheck[0].BillState == 2) { msg = "单据已审核"; return(0); } else { using (var trans = db.UseTransaction(true)) { #region /* * sql = string.Format(@"update QMS_GoodsCheck set BillState=2 where BillCode='{0}'", BillCode); * rowsAffected = db.Sql(sql).Execute(); * var dno = MmsHelper.GetOrderNumber("WMS_BN_BillMain", "BillCode", "CGRK", "", ""); * insertSql = string.Format(@" INSERT dbo.WMS_BN_BillMain * ( * ID, * BillCode, * BillType, * ContractCode, * ProjectName, * SalesmanCode, * Salesman, * DepartmentID, * DepartmentName, * SupplierCode, * SupplierName, * WarehouseCode, * WarehouseName, * ApproveState, * OrderBillCode, * Remark, * CreatePerson, * CreateTime, * ModifyPerson, * ModifyTime, * IsEnable * ) * VALUES * ( (select MAX(id)+1 from WMS_BN_BillMain), -- ID - int ID, * '{0}', -- BillCode - varchar(50) BillCode, * ( SELECT Value FROM HBHC_Sys.dbo.sys_code WHERE Text='采购入库' ), --BillType, * '{1}', -- ContractCode - varchar(50) ContractCode, * '{2}', -- ProjectName - varchar(50) ProjectName, * '{3}', -- SalesmanCode - varchar(50) SalesmanCode, * '{4}', -- Salesman - varchar(50) Salesman, * '{5}', -- DepartmentID - varchar(50) DepartmentID, * '{6}', -- DepartmentName - varchar(50) DepartmentName, * '{7}', -- SupplierCode - varchar(50) SupplierCode, * '{8}', -- SupplierName - varchar(50) SupplierName, * '{9}', -- WarehouseCode - varchar(50) WarehouseCode, * '{10}', -- WarehouseName - varchar(50) WarehouseName, * '1', -- ApproveState, * '{11}', --OrderBillCode, * '{12}', --Remark, * '{13}', --CreatePerson,) * GETDATE(), -- CreateTime, * '{14}', --ModifyPerson, * GETDATE(), -- ModifyTime, * 1 -- IsEnable * )", dno, GoodsCheck[0].ContractCode, GoodsCheck[0].ProjectName, GoodsCheck[0].SalesmanCode, GoodsCheck[0].Salesman, GoodsCheck[0].DepartmentID, GoodsCheck[0].DepartmentName, GoodsCheck[0].SupplierCode, * GoodsCheck[0].SupplierName, GoodsCheck[0].WarehouseID, GoodsCheck[0].WarehouseName, GoodsCheck[0].ProductPurchaseCode, "", MmsHelper.GetUserName(), MmsHelper.GetUserName()); * insertSql += string.Format(@"INSERT INTO dbo.WMS_BN_BillDetail * ( * BillCode, * OrderBillCode, * InventoryCode, * InventoryName, * Specs, * Unit, * MateNum, * ConfirmNum, * UnitPrice, * TotalPrice, * BatchCode, * PBillCode, * Remark, * CreatePerson, * CreateTime, * ModifyPerson, * ModifyTime, * IsEnable * ) * VALUES * ( '{0}', -- BillCode - varchar(50) * '{1}', -- OrderBillCode - varchar(50) * N'{2}', -- InventoryCode - nvarchar(50) * N'{3}', -- InventoryName - nvarchar(50) * '{4}', -- Specs - varchar(50) * N'{5}', -- Unit - nvarchar(10) * '{6}', -- MateNum - float * '{7}', -- ConfirmNum - float * '{8}', -- UnitPrice - float * '{9}', -- TotalPrice - float * '{10}', -- BatchCode - varchar(50) * '{11}', -- PBillCode - varchar(50) * N'', -- Remark - nvarchar(500) * N'{12}', -- CreatePerson - nvarchar(50) * GETDATE(), -- CreateTime - datetime * N'{13}', -- ModifyPerson - nvarchar(50) * GETDATE(), -- ModifyTime - datetime * 1 -- IsEnable - int * )", dno, GoodsCheck[0].ProductPurchaseCode, GoodsCheck[0].InventoryCode, GoodsCheck[0].InventoryName, GoodsCheck[0].Model, GoodsCheck[0].Unit, GoodsCheck[0].QualifiedQuantity, * GoodsCheck[0].QualifiedQuantity, GoodsCheck[0].UnitPrice, GoodsCheck[0].TotalPrice, GoodsCheck[0].BatchCode, GoodsCheck[0].BillCode, MmsHelper.GetUserName(), MmsHelper.GetUserName()); * * var res = db.Sql(insertSql).Execute(); * if (rowsAffected > 0 && res == 2) * { * msg = "检验记录审核成功"; * trans.Commit(); * return rowsAffected; * } * else * { * trans.Rollback(); * msg = "检验记录审核失败"; * return 0; * } */ #endregion string sqlA = string.Format(@"update QMS_GoodsCheck set BillState=2 where BillCode='{0}'", BillCode); string bCode = MmsHelper.GetOrderNumber("WMS_BN_BillMain", "BillCode", "CGRK", "", ""); DateTime newDT = DateTime.Now; string sqlB = WinFormClientService.GetInsertSQL(new WMS_BN_BillMain() { ID = db.Sql("select MAX(id)+1 from WMS_BN_BillMain").QuerySingle <int>(), BillCode = bCode, BillType = db.Sql("SELECT Value FROM HBHC_Sys.dbo.sys_code WHERE Text='采购入库'").QuerySingle <int>(), ContractCode = GoodsCheck[0].ContractCode, ProjectName = GoodsCheck[0].ProjectName, SalesmanCode = GoodsCheck[0].SalesmanCode, Salesman = GoodsCheck[0].Salesman, DepartmentID = GoodsCheck[0].DepartmentID, DepartmentName = GoodsCheck[0].DepartmentName, SupplierCode = GoodsCheck[0].SupplierCode, SupplierName = GoodsCheck[0].SupplierName, WarehouseCode = GoodsCheck[0].WarehouseID, WarehouseName = GoodsCheck[0].WarehouseName, ApproveState = "1", OrderBillCode = GoodsCheck[0].ProductPurchaseCode, Remark = string.Empty, CreatePerson = MmsHelper.GetUserName(), CreateTime = newDT, ModifyPerson = MmsHelper.GetUserName(), ModifyTime = newDT, IsEnable = 1 }); string sqlC = WinFormClientService.GetInsertSQL(new WMS_BN_BillDetail() { BillCode = bCode, OrderBillCode = GoodsCheck[0].ProductPurchaseCode, InventoryCode = GoodsCheck[0].InventoryCode, InventoryName = GoodsCheck[0].InventoryName, Specs = GoodsCheck[0].Model, Unit = GoodsCheck[0].Unit, MateNum = GoodsCheck[0].QualifiedQuantity, ConfirmNum = GoodsCheck[0].QualifiedQuantity, UnitPrice = GoodsCheck[0].UnitPrice, TotalPrice = GoodsCheck[0].TotalPrice, BatchCode = GoodsCheck[0].BatchCode, PBillCode = GoodsCheck[0].BillCode, Remark = string.Empty, CreatePerson = MmsHelper.GetUserName(), CreateTime = newDT, ModifyPerson = MmsHelper.GetUserName(), ModifyTime = newDT, IsEnable = 1 }); string sqlTemp = string.Format(@" SELECT tbB.* FROM MES_PurchaseOrderMain tbA LEFT JOIN MES_PurchaseOrderDetail tbB ON tbA.ID = tbB.MainID AND tbB.IsEnable = 1 WHERE tbA.IsEnable = 1 AND tbB.InventoryCode = '{0}' AND tbA.BillCode IN ( SELECT PurchaseOrderCode FROM dbo.MES_GoodsInspection WHERE IsEnable = 1 AND BillCode = '{1}' ) ", GoodsCheck[0].InventoryCode, GoodsCheck[0].PBillCode); MES_PurchaseOrderDetail mES_PurchaseOrderDetail = db.Sql(sqlTemp).QuerySingle <MES_PurchaseOrderDetail>(); if (mES_PurchaseOrderDetail != null) { string sqlD = WinFormClientService.GetUpdateSQL(mES_PurchaseOrderDetail, new { ModifyPerson = MmsHelper.GetUserName(), ModifyTime = newDT, CheckedQuantity = (mES_PurchaseOrderDetail.CheckedQuantity ?? 0) + (GoodsCheck[0].QualifiedQuantity ?? 0) }); bool tempA = db.Sql(sqlA).Execute() > 0; bool tempB = db.Sql(sqlB).Execute() > 0; bool tempC = db.Sql(sqlC).Execute() > 0; bool tempD = db.Sql(sqlD).Execute() > 0; bool result = tempA && tempB && tempC && tempD; if (result) { trans.Commit(); msg = "检验记录审核成功"; return(1); } else { trans.Rollback(); msg = "检验记录审核失败"; return(0); } } else { trans.Rollback(); msg = "检验记录审核失败"; return(0); } } } }
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; } } } }
public string GetCode() { string billcode = MmsHelper.GetOrderNumber("WMS_BN_TakeStockMain", "BillCode", "PDDH", "", ""); return(billcode); }
public int AuditBillCode(string BillCode, out string msg) { msg = string.Empty; //var rowsAffected = 0; string sql = String.Format(@" SELECT t1.*, t1.QualifiedQuntity, t3.WarehouseID, t3.WarehouseName, t2.CheckQuantity ,t4.QuantityUnit ,t4.Model , t4.InventoryCode ,t4.InventoryName ,t3.WorkshopID ,t3.WorkshopName FROM dbo.QMS_ProcessInspection t1 LEFT JOIN MES_ProcessInspectionRequest t2 ON t1.PBillCode = t2.BillCode AND t1.IsEnable = 1 AND t2.IsEnable = 1 AND t2.BillState = 2 LEFT JOIN dbo.MES_BN_ProductProcessRoute t3 ON t2.ProductProcessRouteID = t3.ID AND t3.IsEnable = 1 inner JOIN dbo.SYS_Part t4 ON t1.PartCode=t4.PartCode AND t4.IsEnable=1 where t1.BillCode='{0}'" , BillCode); dynamic stateList = db.Sql(sql).QueryMany <dynamic>(); if (stateList[0].BillState == 2) { msg = "单据已审核"; return(0); } else { sql = string.Format(@"update QMS_ProcessInspection set BillState=2 where BillCode='{0}'", BillCode); //string insertSql=string.Format(@"") using (db.UseTransaction(true)) { int countMain = db.Sql(sql).Execute(); string documentNo = ""; documentNo = MmsHelper.GetOrderNumber("WMS_BN_BillMain", "BillCode", "ZXRK", "", ""); //billstate = 2; #region WMS_BN_BillMain表 string sqlA = string.Format(@" INSERT INTO dbo.WMS_BN_BillMain ( ID, BillCode, BillType, ContractCode, ProjectName, SalesmanCode, Salesman, DepartmentID, DepartmentName, SupplierCode, SupplierName, WarehouseCode, WarehouseName, PickPersonCode, PickPerson, ApproveState, ApprovePerson, ApproveDate, ApproveRemark, Remark, CreatePerson, CreateTime, ModifyPerson, ModifyTime, IsEnable ) VALUES ( {0}, -- ID - int '{1}', -- BillCode - varchar(50) {2}, -- BillType - int '{3}', -- ContractCode - varchar(50) '{4}', -- ProjectName - varchar(50) '', -- SalesmanCode - varchar(50) '', -- Salesman - varchar(50) '', -- DepartmentID - varchar(50) '', -- DepartmentName - varchar(50) '', -- SupplierCode - varchar(50) '', -- SupplierName - varchar(50) '{5}', -- WarehouseCode - varchar(50) '{6}', -- WarehouseName - varchar(50) '', -- PickPersonCode - varchar(50) '', -- PickPerson - varchar(50) '1', -- ApproveState - varchar(50) '', -- ApprovePerson - varchar(50) GETDATE(), -- ApproveDate - datetime '', -- ApproveRemark - varchar(500) '', -- Remark - varchar(500) '{7}', -- CreatePerson - varchar(50) GETDATE(), -- CreateTime - datetime '{7}', -- ModifyPerson - varchar(50) GETDATE(), -- ModifyTime - datetime 1 -- IsEnable - int ) ", Convert.ToInt32(new WMS_BN_BillMainService().GetNewKey("ID", "Maxplus")), documentNo, 8, stateList[0].ContractCode, stateList[0].ProjectName, stateList[0].WarehouseID, stateList[0].WarehouseName, MmsHelper.GetUserName()); #endregion int countA = db.Sql(sqlA).Execute(); #region WMS_BN_BillDetail表 string sqlB = string.Format(@" INSERT INTO dbo.WMS_BN_BillDetail ( BillCode, OrderBillCode, InventoryCode, InventoryName, Specs, Unit, MateNum, ConfirmNum, UnitPrice, TotalPrice, PackageCode, BatchCode, PBillCode, AccountabilityCode, Remark, CreatePerson, CreateTime, ModifyPerson, ModifyTime, IsEnable ) VALUES ( '{0}', -- BillCode - varchar(50) '', -- OrderBillCode - varchar(50) N'{1}', -- InventoryCode - nvarchar(50) N'{2}', -- InventoryName - nvarchar(50) '{3}', -- Specs - varchar(50) N'{4}', -- Unit - nvarchar(10) {5}, -- MateNum - float {6}, -- ConfirmNum - float 0.0, -- UnitPrice - float 0.0, -- TotalPrice - float '', -- PackageCode - varchar(50) '', -- BatchCode - varchar(50) '', -- PBillCode - varchar(50) '', -- AccountabilityCode - varchar(50) N'', -- Remark - nvarchar(500) N'{7}', -- CreatePerson - nvarchar(50) GETDATE(), -- CreateTime - datetime N'{7}', -- ModifyPerson - nvarchar(50) GETDATE(), -- ModifyTime - datetime 1 -- IsEnable - int ) ", documentNo, stateList[0].InventoryCode, stateList[0].InventoryName, stateList[0].Model, stateList[0].Unit, stateList[0].QualifiedQuntity, stateList[0].QualifiedQuntity, MmsHelper.GetUserName()); #endregion int countB = db.Sql(sqlB).Execute(); int countC = 0; bool aaa = true; bool ccc = true; //更新库存表 //库存表 List <WMS_BN_RealStock> realStockData = db.Sql("SELECT * FROM WMS_BN_RealStock WHERE IsEnable = 1").QueryMany <WMS_BN_RealStock>(); var realStocks = realStockData.Where(s => { bool a = s.WarehouseCode == null ? false : s.WarehouseCode.Equals(stateList[0].WarehouseID); bool b = s.InventoryCode == null ? false : s.InventoryCode.Equals(stateList[0].InventoryCode); bool c = s.BatchCode == null ? false : s.BatchCode.Equals(stateList[0].BatchCode); return(a && b && c); }).ToList(); string updateStockSal = ""; if (stateList[0].WarehouseName == stateList[0].WorkshopName) { #region //没有库存则新增 if (realStocks.Count <= 0) { WMS_BN_RealStock realStockModel = new WMS_BN_RealStock() { InventoryCode = stateList[0].InventoryCode, InventoryName = stateList[0].InventoryName, Model = stateList[0].Model, RealStock = (double)stateList[0].QualifiedQuntity, TotalStock = (double)stateList[0].QualifiedQuntity, WarehouseCode = stateList[0].WarehouseID, WarehouseName = stateList[0].WarehouseName, BatchCode = stateList[0].BatchCode, Unit = stateList[0].Unit, CreatePerson = MmsHelper.GetUserName(), CreateTime = DateTime.Now, ModifyPerson = MmsHelper.GetUserName(), ModifyTime = DateTime.Now, IsEnable = 1 }; countC = db.Insert("WMS_BN_RealStock", realStockModel).AutoMap(x => x.ID).Execute(); updateStockSal += String.Format(@" update WMS_BN_BillMain set ApproveState=2 where BillCode = '{0}'", documentNo); } //有则更新数量 else if (realStocks.Count.Equals(1)) { updateStockSal = string.Format("UPDATE WMS_BN_RealStock SET RealStock = {0},TotalStock = {1},ModifyPerson = '{2}',ModifyTime = '{3}' WHERE ID = {4} ;\r\n", realStocks[0].RealStock + stateList[0].QualifiedQuntity, realStocks[0].TotalStock + stateList[0].QualifiedQuntity, MmsHelper.GetUserName(), DateTime.Now, realStocks[0].ID); updateStockSal += String.Format(@" update WMS_BN_BillMain set ApproveState=2 where BillCode = '{0}'", documentNo); } else { return(0); msg = @"仓库物料种类繁多,可惜不知取哪一种!"; } #endregion ccc = db.Sql(updateStockSal).Execute() > 0; } if (aaa && countMain > 0 && countA > 0 && countB > 0 && ccc && countC > 0) { db.Commit(); msg = "审核单据成功"; return(1); } else { db.Rollback(); msg = "审核单据失败,请确认数据"; return(1); } } } }
//自动生成盘点单 public int PostBuildPD(int year, int month, int tackStockType, out string msg) { msg = string.Empty; var rowsAffected = 0; string sql = String.Format(@"select * from WMS_BN_TakeStockMain where TakeStockYear='{0}' and TakeStockMonth='{1}'", year, month); var isExit = db.Sql(sql).QuerySingle <int>(); if (isExit > 0) { msg = "一个月只能生成一次盘点!"; return(0); } var list = db.Sql(@"select t1.InventoryCode,MAX( t1.InventoryName) InventoryName,t2.WarehouseCode,MAX( t2.WarehouseName) WarehouseName,isnull( SUM( t2.RealStock),0) TakeStockNum from SYS_Part as t1 inner join WMS_BN_RealStock as t2 on t1.InventoryCode=t2.InventoryCode group by t1.InventoryCode,t2.WarehouseCode ").QueryMany <dynamic>(); if (list.Count <= 0) { msg = "没有数据!"; return(0); } db.UseTransaction(true); WMS_BN_TakeStockMain master = new WMS_BN_TakeStockMain(); master.BillCode = MmsHelper.GetOrderNumber("WMS_BN_TakeStockMain", "BillCode", "PDDH", "", ""); master.TakeStockYear = year; master.TakeStockMonth = month; master.BillState = 1; master.TakeStockType = tackStockType; master.CreateTime = DateTime.Now; master.CreatePerson = MmsHelper.GetUserName(); rowsAffected = db.Sql(@"insert into WMS_BN_TakeStockMain (BillCode,TakeStockYear,TakeStockMonth,TakeStockType,BillState,CreateTime,CreatePerson) values(@0,@1,@2,@3,@4,@5,@6)", master.BillCode, master.TakeStockYear, master.TakeStockMonth, master.TakeStockType, master.BillState, master.CreateTime, master.CreatePerson).Execute(); if (rowsAffected < 0) { db.Rollback(); return(rowsAffected); } sql = String.Format(@"select * from WMS_BN_TakeStockMain where BillCode = '{0}'", master.BillCode); dynamic next = db.Sql(sql).QuerySingle <dynamic>();// foreach (var item in list) { WMS_BN_TakeStockDetail detail = new WMS_BN_TakeStockDetail(); detail.BillCode = next.BillCode; detail.InventoryCode = item.InventoryCode; detail.InventoryName = item.InventoryName; detail.WarehouseCode = item.WarehouseCode; detail.WarehouseName = item.WarehouseName; detail.TakeStockNum = item.TakeStockNum; rowsAffected = db.Insert <WMS_BN_TakeStockDetail>("WMS_BN_TakeStockDetail", detail) .AutoMap(x => x.ID) .Execute(); if (rowsAffected < 0) { db.Rollback(); return(rowsAffected); } } msg = "操作成功!"; db.Commit(); return(rowsAffected); }
public string GetCode() { string billCode = MmsHelper.GetOrderNumber("QMS_UnQualifiedPartHandling", "BillCode", "BHGPCL", "", ""); return(billCode); }
//自动生成出入库单 public int PostBuild(string billCode, out string msg) { msg = string.Empty; var rowsAffected = 0; string sql = String.Format(@" select MAX(t1.BillState) as BillState,t2.WarehouseCode,max(t2.WarehouseName) as WarehouseName,t2.InventoryCode,max(t2.InventoryName) as InventoryName,sum(t2.DValue) as DValue from WMS_BN_TakeStockMain as t1 inner join WMS_BN_TakeStockDetail as t2 on t1.BillCode=t2.BillCode where t1.BillCode='{0}' group by t2.WarehouseCode,t2.Inventorycode", billCode); var list = db.Sql(sql).QueryMany <dynamic>(); var res = list[1].DValue; if (list[0].BillState == 2) { msg = "已锁定的数据不能重复提交!"; return(0); } db.UseTransaction(true); foreach (var item in list) { res = item.DValue; WMS_BN_BillMain master = new WMS_BN_BillMain(); if (item.DValue > 0) { master.BillType = 6; master.WarehouseCode = item.WarehouseCode; master.WarehouseName = item.WarehouseName; master.Remark = "盘盈入库"; } else if (item.DValue < 0) { master.BillType = 7; master.WarehouseCode = item.WarehouseCode; master.WarehouseName = item.WarehouseName; master.Remark = "盘亏出库"; } else { continue; } var sc = new sys_codeService().Getsys_codeByTypeAndID("BillType", Convert.ToInt16(master.BillType)); master.BillCode = MmsHelper.GetOrderNumber("WMS_BN_BillMain", "BillCode", sc.Description, "", ""); master.CreateTime = DateTime.Now; master.CreatePerson = MmsHelper.GetUserName(); rowsAffected = db.Sql(@"insert into WMS_BN_BillMain (BillCode,BillType,WarehouseCode,WarehouseName,Remark, CreatePerson,CreateTime) values(@0,@1,@2,@3,@4,@5,@6)", master.BillCode, master.BillType, master.WarehouseCode, master.WarehouseName, master.Remark, master.CreatePerson, master.CreateTime).Execute(); if (rowsAffected < 0) { db.Rollback(); return(rowsAffected); } var detailList = (from p in list where p.WarehouseCode == item.WarehouseCode select p).ToList(); foreach (var it in detailList) { WMS_BN_BillDetail detail = new WMS_BN_BillDetail(); detail.PBillCode = billCode; detail.BillCode = master.BillCode; detail.InventoryCode = it.InventoryCode; detail.InventoryName = it.InventoryName; detail.MateNum = Math.Abs(item.DValue); detail.ConfirmNum = Math.Abs(item.DValue); rowsAffected = db.Insert <WMS_BN_BillDetail>("WMS_BN_BillDetail", detail) .AutoMap(x => x.ID) .Execute(); if (rowsAffected < 0) { db.Rollback(); return(rowsAffected); } } } sql = string.Format(@"update WMS_BN_TakeStockMain set BillState='2' where BillCode='{0}'", billCode); rowsAffected = db.Sql(sql).Execute(); if (rowsAffected < 0) { db.Rollback(); return(rowsAffected); } msg = "操作成功!"; db.Commit(); return(rowsAffected); }