From 5b2c8f8d78e2f51d09a62762f19f080663ff40e9 Mon Sep 17 00:00:00 2001
From: ch <37327@LLOOCCY>
Date: 星期一, 12 七月 2021 13:45:53 +0800
Subject: [PATCH] 修改地址
---
WebAPI/Controllers/Sc_MouldController.cs | 692 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 692 insertions(+), 0 deletions(-)
diff --git a/WebAPI/Controllers/Sc_MouldController.cs b/WebAPI/Controllers/Sc_MouldController.cs
index bf84079..658e8b7 100644
--- a/WebAPI/Controllers/Sc_MouldController.cs
+++ b/WebAPI/Controllers/Sc_MouldController.cs
@@ -165,6 +165,457 @@
#endregion
+ #region 妯″叿鐢熶骇棰嗙敤鍗�
+
+ #region 妯″叿鐢熶骇棰嗙敤鍗曚繚瀛�
+
+ [Route("Sc_MouldProdOutBill/MouldProdOutBill_Save")]
+ [HttpPost]
+ public object MouldProdOutAdd([FromBody] JObject sMainSub)
+ {
+ var _value = sMainSub["sMainSub"].ToString();
+ string msg1 = _value.ToString();
+ //淇濆瓨鍗曟嵁
+ return objJsonResult = MouldProdOutAddBill(msg1);
+ }
+
+ public json MouldProdOutAddBill(string msg1)
+ {
+ //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
+ //string msg2 = sArray[0].ToString();
+ //string msg3 = sArray[0].ToString();
+ bool bResult;
+ try
+ {
+ //msg2 = "[" + msg2.ToString() + "]";
+ msg1 = "[" + msg1.ToString() + "]";
+ DAL.ClsSc_MouldProdOutBill BillNew = new DAL.ClsSc_MouldProdOutBill();
+ List<Model.ClsSc_MouldProdOutBillMain> mainList = Newtonsoft
+ .Json
+ .JsonConvert
+ .DeserializeObject<List<Model.ClsSc_MouldProdOutBillMain>>(msg1);
+ List<Model.ClsSc_MouldStockBillSub> subList = Newtonsoft
+ .Json
+ .JsonConvert
+ .DeserializeObject<List<Model.ClsSc_MouldStockBillSub>>(msg1);
+ //鍒ゆ柇浼氳鏈熸槸鍚﹀悎鐞�
+ string s = "";
+ int sYear = 0;
+ int sPeriod = 0;
+ DateTime HDate = mainList[0].HDate;//鏃ユ湡
+ if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = s;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ BillNew.omodel.HYear = sYear;
+ BillNew.omodel.HPeriod = sPeriod;
+ BillNew.omodel.HBillNo = mainList[0].HBillNo.Trim();
+ BillNew.omodel.HMaker = mainList[0].HMaker;
+ BillNew.omodel.HDate = HDate;
+ BillNew.omodel.HWHID = mainList[0].HWHID;
+ BillNew.omodel.HSupID = 0;
+ BillNew.omodel.HSCWHID = 0;
+ BillNew.omodel.HEmpID = 0;
+ BillNew.omodel.HManagerID = 0;
+ BillNew.omodel.HSecManagerID = mainList[0].HSecManagerID;
+ BillNew.omodel.HKeeperID = mainList[0].HKeeperID;
+ BillNew.omodel.HDeptID = mainList[0].HDeptID;
+ BillNew.omodel.HExplanation = mainList[0].HExplanation;
+ BillNew.omodel.HInnerBillNo = mainList[0].HInnerBillNo;
+ BillNew.omodel.HRedBlueFlag = mainList[0].HRedBlueFlag;
+ BillNew.DetailColl = new List<Model.ClsSc_MouldStockBillSub>();
+ Model.ClsSc_MouldStockBillSub oSub = new Model.ClsSc_MouldStockBillSub();
+
+ oSub.HEntryID = 1;
+ oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[0].HRemark);
+ oSub.HSourceInterID = DBUtility.ClsPub.isLong(subList[0].HSourceInterID);
+ oSub.HSourceEntryID = DBUtility.ClsPub.isLong(subList[0].HSourceEntryID);
+ oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillType);
+ oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillNo);
+ oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[0].HRelationQty);
+ oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[0].HRelationMoney);
+ oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[0].HCloseMan);
+ oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[0].HEntryCloseDate);
+ oSub.HCloseType = DBUtility.ClsPub.isBool(subList[0].HCloseType);
+ oSub.HMaterID = DBUtility.ClsPub.isLong(subList[0].HMaterID);
+ oSub.HPropertyID = DBUtility.ClsPub.isLong(subList[0].HPropertyID);
+ oSub.HSecUnitID = DBUtility.ClsPub.isLong(subList[0].HSecUnitID);
+ oSub.HSecUnitRate = DBUtility.ClsPub.isSingle(subList[0].HSecUnitRate);
+ oSub.HUnitID = DBUtility.ClsPub.isLong(subList[0].HUnitID);
+ oSub.HQtyMust = DBUtility.ClsPub.isDoule(subList[0].HQtyMust);
+ oSub.HQty = DBUtility.ClsPub.isDoule(subList[0].HQty);
+ oSub.HBarCode = DBUtility.ClsPub.isStrNull(subList[0].HBarCode);
+ if (oSub.HQty <= 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "娴佽浆鍗℃暟閲忎笉鑳戒负0鎴栬�呭皬浜�0";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ oSub.HDesignLife = DBUtility.ClsPub.isLong(subList[0].HDesignLife);
+ if (oSub.HDesignLife < 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "璁捐瀵垮懡涓嶈兘涓�0鎴栬�呭皬浜�0";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ oSub.HLeaveLife = DBUtility.ClsPub.isLong(subList[0].HLeaveLife);
+ oSub.HPrice = DBUtility.ClsPub.isDoule(subList[0].HPrice);
+ oSub.HWHID = DBUtility.ClsPub.isLong(subList[0].HWHID);
+ oSub.HSPID = DBUtility.ClsPub.isLong(subList[0].HSPID);
+ oSub.HSCWHID = 0;
+ oSub.HSCSPID = 0;
+ oSub.HSPGroupID = DBUtility.ClsPub.isLong(subList[0].HSPGroupID);
+ oSub.HBatchNo = DBUtility.ClsPub.isStrNull(subList[0].HBatchNo);
+ oSub.HNewModel = DBUtility.ClsPub.isStrNull(subList[0].HNewModel);
+ oSub.HWallThickness = DBUtility.ClsPub.isStrNull(subList[0].HWallThickness);
+ oSub.HHardness = DBUtility.ClsPub.isStrNull(subList[0].HHardness);
+ oSub.HLastProdModel = DBUtility.ClsPub.isStrNull(subList[0].HLastProdModel);
+ oSub.HDiameter = DBUtility.ClsPub.isStrNull(subList[0].HDiameter);
+ oSub.HBackFlag = DBUtility.ClsPub.isStrNull(subList[0].HBackFlag);
+ BillNew.DetailColl.Add(oSub);
+ bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo);
+ //鎻愮ず
+ if (bResult == true)
+ {
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = ClsPub.sExeReturnInfo + "鍗曟嵁鍙�:" + mainList[0].HBillNo.Trim();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ else
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "淇濆瓨澶辫触!鍘熷洜:" + ClsPub.sExeReturnInfo;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+
+ #endregion
+
+ #endregion
+
+
+
+
+
+ #region 妯″叿鐢熶骇閫�搴撳崟
+
+ #region 妯″叿鐢熶骇閫�搴撳崟淇濆瓨
+
+ [Route("Sc_MouldProdBackBill/MouldProdBackBill_Save")]
+ [HttpPost]
+ public object MoulddProdBackAdd([FromBody] JObject sMainSub)
+ {
+ var _value = sMainSub["sMainSub"].ToString();
+ string msg1 = _value.ToString();
+ //淇濆瓨鍗曟嵁
+ return objJsonResult = MoulddProdBackAddBill(msg1);
+ }
+
+ public json MoulddProdBackAddBill(string msg1)
+ {
+ bool bResult;
+ try
+ {
+ msg1 = "[" + msg1.ToString() + "]";
+ DAL.ClsSc_MouldProdBackBill BillNew = new DAL.ClsSc_MouldProdBackBill();
+ List<Model.ClsSc_MouldProdBackBillMain> mainList = Newtonsoft
+ .Json
+ .JsonConvert
+ .DeserializeObject<List<Model.ClsSc_MouldProdBackBillMain>>(msg1);
+ List<Model.ClsSc_MouldStockBillSub> subList = Newtonsoft
+ .Json
+ .JsonConvert
+ .DeserializeObject<List<Model.ClsSc_MouldStockBillSub>>(msg1);
+ //鍒ゆ柇浼氳鏈熸槸鍚﹀悎鐞�
+ string s = "";
+ int sYear = 0;
+ int sPeriod = 0;
+ DateTime HDate = mainList[0].HDate;//鏃ユ湡
+ if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = s;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ BillNew.omodel.HYear = sYear;
+ BillNew.omodel.HPeriod = sPeriod;
+ BillNew.omodel.HBillNo = mainList[0].HBillNo.Trim();
+ BillNew.omodel.HMaker = mainList[0].HMaker;
+ BillNew.omodel.HDate = HDate;
+ BillNew.omodel.HWHID = mainList[0].HWHID;
+ BillNew.omodel.HSupID = 0;
+ BillNew.omodel.HSCWHID = 0;
+ BillNew.omodel.HEmpID = 0;
+ BillNew.omodel.HManagerID = 0;
+ BillNew.omodel.HSecManagerID = mainList[0].HSecManagerID;
+ BillNew.omodel.HKeeperID = mainList[0].HKeeperID;
+ BillNew.omodel.HDeptID = mainList[0].HDeptID;
+ BillNew.omodel.HExplanation = mainList[0].HExplanation;
+ BillNew.omodel.HInnerBillNo = mainList[0].HInnerBillNo;
+ BillNew.omodel.HRedBlueFlag = mainList[0].HRedBlueFlag;
+ BillNew.DetailColl = new List<Model.ClsSc_MouldStockBillSub>();
+ Model.ClsSc_MouldStockBillSub oSub = new Model.ClsSc_MouldStockBillSub();
+
+ oSub.HEntryID = 1;
+ oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[0].HRemark);
+ oSub.HSourceInterID = DBUtility.ClsPub.isLong(subList[0].HSourceInterID);
+ oSub.HSourceEntryID = DBUtility.ClsPub.isLong(subList[0].HSourceEntryID);
+ oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillType);
+ oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillNo);
+ oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[0].HRelationQty);
+ oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[0].HRelationMoney);
+ oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[0].HCloseMan);
+ oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[0].HEntryCloseDate);
+ oSub.HCloseType = DBUtility.ClsPub.isBool(subList[0].HCloseType);
+ oSub.HMaterID = DBUtility.ClsPub.isLong(subList[0].HMaterID);
+ oSub.HPropertyID = DBUtility.ClsPub.isLong(subList[0].HPropertyID);
+ oSub.HSecUnitID = DBUtility.ClsPub.isLong(subList[0].HSecUnitID);
+ oSub.HSecUnitRate = DBUtility.ClsPub.isSingle(subList[0].HSecUnitRate);
+ oSub.HUnitID = DBUtility.ClsPub.isLong(subList[0].HUnitID);
+ oSub.HQtyMust = DBUtility.ClsPub.isDoule(subList[0].HQtyMust);
+ oSub.HQty = DBUtility.ClsPub.isDoule(subList[0].HQty);
+ oSub.HBarCode = DBUtility.ClsPub.isStrNull(subList[0].HBarCode);
+ if (oSub.HQty <= 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "娴佽浆鍗℃暟閲忎笉鑳戒负0鎴栬�呭皬浜�0";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ oSub.HDesignLife = DBUtility.ClsPub.isLong(subList[0].HDesignLife);
+ if (oSub.HDesignLife < 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "璁捐瀵垮懡涓嶈兘涓�0鎴栬�呭皬浜�0";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ oSub.HLeaveLife = DBUtility.ClsPub.isLong(subList[0].HLeaveLife);
+ oSub.HPrice = DBUtility.ClsPub.isDoule(subList[0].HPrice);
+ oSub.HWHID = DBUtility.ClsPub.isLong(subList[0].HWHID);
+ oSub.HSPID = DBUtility.ClsPub.isLong(subList[0].HSPID);
+ oSub.HSCWHID = 0;
+ oSub.HSCSPID = 0;
+ oSub.HSPGroupID = DBUtility.ClsPub.isLong(subList[0].HSPGroupID);
+ oSub.HBatchNo = DBUtility.ClsPub.isStrNull(subList[0].HBatchNo);
+ oSub.HNewModel = DBUtility.ClsPub.isStrNull(subList[0].HNewModel);
+ oSub.HWallThickness = DBUtility.ClsPub.isStrNull(subList[0].HWallThickness);
+ oSub.HHardness = DBUtility.ClsPub.isStrNull(subList[0].HHardness);
+ oSub.HLastProdModel = DBUtility.ClsPub.isStrNull(subList[0].HLastProdModel);
+ oSub.HDiameter = DBUtility.ClsPub.isStrNull(subList[0].HDiameter);
+ oSub.HBackFlag = DBUtility.ClsPub.isStrNull(subList[0].HBackFlag);
+ oSub.HDesignLife = DBUtility.ClsPub.isLong(subList[0].HDesignLife);
+ oSub.HUseLife = DBUtility.ClsPub.isLong(subList[0].HUseLife);
+ BillNew.DetailColl.Add(oSub);
+ bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo);
+ //鎻愮ず
+ if (bResult == true)
+ {
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = ClsPub.sExeReturnInfo + "鍗曟嵁鍙�:" + mainList[0].HBillNo.Trim();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ else
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "淇濆瓨澶辫触!鍘熷洜:" + ClsPub.sExeReturnInfo;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+
+ #endregion
+
+ #endregion
+
+
+
+ #region 妯″叿澶勭悊鍑哄簱鍗�
+
+ #region 妯″叿澶勭悊鍑哄簱鍗曚繚瀛�
+
+ [Route("Sc_MouldScrapOutBill/MouldScrapOutBill_Save")]
+ [HttpPost]
+ public object MouldScrapOutAdd([FromBody] JObject sMainSub)
+ {
+ var _value = sMainSub["sMainSub"].ToString();
+ string msg1 = _value.ToString();
+ //淇濆瓨鍗曟嵁
+ return objJsonResult = MouldScrapOutAddBill(msg1);
+ }
+
+ public json MouldScrapOutAddBill(string msg1)
+ {
+ bool bResult;
+ try
+ {
+ msg1 = "[" + msg1.ToString() + "]";
+ DAL.ClsSc_MouldScrapOutBill BillNew = new DAL.ClsSc_MouldScrapOutBill();
+ List<Models.ClsSc_MouldScrapOutBillMain> mainList = Newtonsoft
+ .Json
+ .JsonConvert
+ .DeserializeObject<List<Models.ClsSc_MouldScrapOutBillMain>>(msg1);
+ List<Models.ClsSc_MouldStockBillSub> subList = Newtonsoft
+ .Json
+ .JsonConvert
+ .DeserializeObject<List<Models.ClsSc_MouldStockBillSub>>(msg1);
+ //鍒ゆ柇浼氳鏈熸槸鍚﹀悎鐞�
+ string s = "";
+ int sYear = 0;
+ int sPeriod = 0;
+ DateTime HDate = mainList[0].HDate;//鏃ユ湡
+ if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = s;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ BillNew.omodel.HYear = sYear;
+ BillNew.omodel.HPeriod = sPeriod;
+ BillNew.omodel.HBillNo = mainList[0].HBillNo.Trim();
+ BillNew.omodel.HMaker = mainList[0].HMaker;
+ BillNew.omodel.HDate = HDate;
+ BillNew.omodel.HWHID = mainList[0].HWHID;
+ BillNew.omodel.HSupID = 0;
+ BillNew.omodel.HSCWHID = 0;
+ BillNew.omodel.HEmpID = 0;
+ BillNew.omodel.HManagerID = 0;
+ BillNew.omodel.HSecManagerID = mainList[0].HSecManagerID;
+ BillNew.omodel.HKeeperID = mainList[0].HKeeperID;
+ BillNew.omodel.HDeptID = mainList[0].HDeptID;
+ BillNew.omodel.HExplanation = mainList[0].HExplanation;
+ BillNew.omodel.HInnerBillNo = mainList[0].HInnerBillNo;
+ BillNew.omodel.HRedBlueFlag = mainList[0].HRedBlueFlag;
+ BillNew.DetailColl = new List<Model.ClsSc_MouldStockBillSub>();
+ Model.ClsSc_MouldStockBillSub oSub = new Model.ClsSc_MouldStockBillSub();
+
+ oSub.HEntryID = 1;
+ oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[0].HRemark);
+ oSub.HSourceInterID = DBUtility.ClsPub.isLong(subList[0].HSourceInterID);
+ oSub.HSourceEntryID = DBUtility.ClsPub.isLong(subList[0].HSourceEntryID);
+ oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillType);
+ oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillNo);
+ oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[0].HRelationQty);
+ oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[0].HRelationMoney);
+ oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[0].HCloseMan);
+ oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[0].HEntryCloseDate);
+ oSub.HCloseType = DBUtility.ClsPub.isBool(subList[0].HCloseType);
+ oSub.HMaterID = DBUtility.ClsPub.isLong(subList[0].HMaterID);
+ oSub.HPropertyID = DBUtility.ClsPub.isLong(subList[0].HPropertyID);
+ oSub.HSecUnitID = DBUtility.ClsPub.isLong(subList[0].HSecUnitID);
+ oSub.HSecUnitRate = DBUtility.ClsPub.isSingle(subList[0].HSecUnitRate);
+ oSub.HUnitID = DBUtility.ClsPub.isLong(subList[0].HUnitID);
+ oSub.HQtyMust = DBUtility.ClsPub.isDoule(subList[0].HQtyMust);
+ oSub.HQty = DBUtility.ClsPub.isDoule(subList[0].HQty);
+ oSub.HBarCode = DBUtility.ClsPub.isStrNull(subList[0].HBarCode);
+ if (oSub.HQty <= 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "娴佽浆鍗℃暟閲忎笉鑳戒负0鎴栬�呭皬浜�0";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ oSub.HDesignLife = DBUtility.ClsPub.isLong(subList[0].HDesignLife);
+ if (oSub.HDesignLife < 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "璁捐瀵垮懡涓嶈兘涓�0鎴栬�呭皬浜�0";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ oSub.HLeaveLife = DBUtility.ClsPub.isLong(subList[0].HLeaveLife);
+ oSub.HPrice = DBUtility.ClsPub.isDoule(subList[0].HPrice);
+ oSub.HWHID = DBUtility.ClsPub.isLong(subList[0].HWHID);
+ oSub.HSPID = DBUtility.ClsPub.isLong(subList[0].HSPID);
+ oSub.HSCWHID = 0;
+ oSub.HSCSPID = 0;
+ oSub.HSPGroupID = DBUtility.ClsPub.isLong(subList[0].HSPGroupID);
+ oSub.HBatchNo = DBUtility.ClsPub.isStrNull(subList[0].HBatchNo);
+ oSub.HNewModel = DBUtility.ClsPub.isStrNull(subList[0].HNewModel);
+ oSub.HWallThickness = DBUtility.ClsPub.isStrNull(subList[0].HWallThickness);
+ oSub.HHardness = DBUtility.ClsPub.isStrNull(subList[0].HHardness);
+ oSub.HLastProdModel = DBUtility.ClsPub.isStrNull(subList[0].HLastProdModel);
+ oSub.HDiameter = DBUtility.ClsPub.isStrNull(subList[0].HDiameter);
+ oSub.HBackFlag = DBUtility.ClsPub.isStrNull(subList[0].HBackFlag);
+ oSub.HDesignLife = DBUtility.ClsPub.isLong(subList[0].HDesignLife);
+ oSub.HUseLife = DBUtility.ClsPub.isLong(subList[0].HUseLife);
+ BillNew.DetailColl.Add(oSub);
+ bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo);
+ //鎻愮ず
+ if (bResult == true)
+ {
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = ClsPub.sExeReturnInfo + "鍗曟嵁鍙�:" + mainList[0].HBillNo.Trim();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ else
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "淇濆瓨澶辫触!鍘熷洜:" + ClsPub.sExeReturnInfo;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+
+ #endregion
+
+ #endregion
+
+
+
#region 妯″叿鍏朵粬鍑哄簱鍗�
#region 妯″叿鍏朵粬鍑哄簱鍗曚繚瀛�
@@ -314,5 +765,246 @@
#endregion
+ #region 妯″叿缁翠慨璁板綍鍗�
+
+ #region 妯″叿缁翠慨璁板綍鍗曚繚瀛�
+
+ [Route("Sc_MouldRepairWorkBill/MouldRepairWorkBill_Save")]
+ [HttpPost]
+ public object MouldRepairWorkBill_Save([FromBody] JObject sMainSub)
+ {
+ var _value = sMainSub["sMainSub"].ToString();
+ string msg1 = _value.ToString();
+ return objJsonResult = MouldRepairWorkAddBill(msg1);
+ }
+
+ public json MouldRepairWorkAddBill(string msg1)
+ {
+ bool bResult;
+ try
+ {
+ msg1 = "[" + msg1.ToString() + "]";
+ DAL.ClsSb_MouldRepairWorkBill BillNew = new DAL.ClsSb_MouldRepairWorkBill();
+ List<Model.ClsSb_MouldRepairWorkBillMain> mainList = Newtonsoft
+ .Json
+ .JsonConvert
+ .DeserializeObject<List<Model.ClsSb_MouldRepairWorkBillMain>>(msg1);
+ List<Model.ClsSb_MouldRepairWorkBillSub> subList = Newtonsoft
+ .Json
+ .JsonConvert
+ .DeserializeObject<List<Model.ClsSb_MouldRepairWorkBillSub>>(msg1);
+ string s = "";
+ int sYear = 0;
+ int sPeriod = 0;
+ DateTime HDate = mainList[0].HDate;
+ if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = s;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ BillNew.omodel.HYear = sYear;
+ BillNew.omodel.HPeriod = sPeriod;
+ BillNew.omodel.HBillNo = mainList[0].HBillNo.Trim();
+ BillNew.omodel.HMaker = mainList[0].HMaker;
+ BillNew.omodel.HDate = HDate;
+ BillNew.omodel.HMouldID = mainList[0].HMouldID;
+ BillNew.omodel.HDeptID = mainList[0].HDeptID;
+ BillNew.omodel.HEmpID = mainList[0].HEmpID;
+ BillNew.omodel.HRepairID = mainList[0].HRepairID;
+ BillNew.omodel.HManagerID = mainList[0].HManagerID;
+ BillNew.omodel.HRepairBeginDate = mainList[0].HRepairBeginDate;
+ BillNew.omodel.HRepairEndDate = mainList[0].HRepairEndDate;
+ BillNew.omodel.HRepairContent = mainList[0].HRepairContent;
+ BillNew.omodel.HCycleUnit = mainList[0].HCycleUnit;
+ BillNew.omodel.HPlanTimes = mainList[0].HPlanTimes;
+ BillNew.omodel.HTimes = mainList[0].HTimes;
+ BillNew.omodel.HExplanation = mainList[0].HExplanation;
+ BillNew.omodel.HInnerBillNo = mainList[0].HInnerBillNo;
+ BillNew.omodel.HMouldID = mainList[0].HMouldID;
+ BillNew.omodel.HSupID = mainList[0].HSupID;
+ BillNew.omodel.HRepairType = mainList[0].HRepairType;
+ BillNew.omodel.HNewModel = mainList[0].HNewModel;
+ BillNew.omodel.HNewDesignLife = mainList[0].HNewDesignLife;
+ BillNew.omodel.HEquipID = mainList[0].HEquipID;
+ BillNew.DetailColl = new List<Model.ClsSb_MouldRepairWorkBillSub>();
+ Model.ClsSb_MouldRepairWorkBillSub oSub = new Model.ClsSb_MouldRepairWorkBillSub();
+ oSub.HEntryID = 1;
+ oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[0].HRemark);
+ oSub.HSourceInterID = DBUtility.ClsPub.isLong(subList[0].HSourceInterID);
+ oSub.HSourceEntryID = DBUtility.ClsPub.isLong(subList[0].HSourceEntryID);
+ oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillType);
+ oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillNo);
+ oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[0].HRelationQty);
+ oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[0].HRelationMoney);
+ oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[0].HCloseMan);
+ oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[0].HEntryCloseDate);
+ oSub.HCloseType = DBUtility.ClsPub.isBool(subList[0].HCloseType);
+ oSub.HRepairID = DBUtility.ClsPub.isLong(subList[0].HRepairID);
+ oSub.HManagerID = DBUtility.ClsPub.isLong(subList[0].HManagerID);
+ oSub.HMoney = DBUtility.ClsPub.isDoule(subList[0].HMoney);
+ oSub.HRepairExplanation = DBUtility.ClsPub.isStrNull(subList[0].HRepairExplanation);
+ BillNew.DetailColl.Add(oSub);
+ bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo);
+ if (bResult == true)
+ {
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = ClsPub.sExeReturnInfo + "鍗曟嵁鍙�:" + mainList[0].HBillNo.Trim();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ else
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "淇濆瓨澶辫触!鍘熷洜:" + ClsPub.sExeReturnInfo;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+
+ #endregion
+
+ #endregion
+
+ #region 妯″叿瀵垮懡璋冩暣鍗�
+
+ #region 妯″叿瀵垮懡璋冩暣鍗曚繚瀛�
+
+ [Route("Sc_MouldLifeChangeBill/MouldLifeChangeBill_Save")]
+ [HttpPost]
+ public object MouldLifeChangeBill_Save([FromBody] JObject sMainSub)
+ {
+ var _value = sMainSub["sMainSub"].ToString();
+ string msg1 = _value.ToString();
+ return objJsonResult = MouldLifeChangeAddBill(msg1);
+ }
+
+ public json MouldLifeChangeAddBill(string msg1)
+ {
+ bool bResult;
+ try
+ {
+ msg1 = "[" + msg1.ToString() + "]";
+ DAL.ClsSc_MouldLifeChangeBill BillNew = new DAL.ClsSc_MouldLifeChangeBill();
+ List<Model.ClsSc_MouldLifeChangeBillMain> mainList = Newtonsoft
+ .Json
+ .JsonConvert
+ .DeserializeObject<List<Model.ClsSc_MouldLifeChangeBillMain>>(msg1);
+ List<Model.ClsSc_MouldLifeChangeBillSub> subList = Newtonsoft
+ .Json
+ .JsonConvert
+ .DeserializeObject<List<Model.ClsSc_MouldLifeChangeBillSub>>(msg1);
+ string s = "";
+ int sYear = 0;
+ int sPeriod = 0;
+ DateTime HDate = mainList[0].HDate;
+ if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = s;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ BillNew.omodel.HYear = sYear;
+ BillNew.omodel.HPeriod = sPeriod;
+ BillNew.omodel.HBillNo = mainList[0].HBillNo.Trim();
+ BillNew.omodel.HMaker = mainList[0].HMaker;
+ BillNew.omodel.HDate = HDate;
+ BillNew.omodel.HRemark = mainList[0].HRemark;
+ BillNew.omodel.HMangerID = mainList[0].HMangerID;
+ BillNew.omodel.HEmpID = mainList[0].HEmpID;
+ BillNew.omodel.HDeptID = mainList[0].HDeptID;
+ BillNew.omodel.HReason = mainList[0].HReason;
+ BillNew.omodel.HExplanation = mainList[0].HExplanation;
+ BillNew.omodel.HInnerBillNo = mainList[0].HInnerBillNo;
+ BillNew.DetailColl = new List<Model.ClsSc_MouldLifeChangeBillSub>();
+ Model.ClsSc_MouldLifeChangeBillSub oSub = new Model.ClsSc_MouldLifeChangeBillSub();
+ oSub.HEntryID = 1;
+ oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[0].HRemark);
+ oSub.HSourceInterID = DBUtility.ClsPub.isLong(subList[0].HSourceInterID);
+ oSub.HSourceEntryID = DBUtility.ClsPub.isLong(subList[0].HSourceEntryID);
+ oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillType);
+ oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillNo);
+ oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[0].HRelationQty);
+ oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[0].HRelationMoney);
+ oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[0].HCloseMan);
+ oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[0].HEntryCloseDate);
+ oSub.HCloseType = DBUtility.ClsPub.isBool(subList[0].HCloseType);
+ oSub.HMaterID = DBUtility.ClsPub.isLong(subList[0].HMaterID);
+ oSub.HPropertyID = DBUtility.ClsPub.isLong(subList[0].HPropertyID);
+ oSub.HSecUnitID = DBUtility.ClsPub.isLong(subList[0].HSecUnitID);
+ oSub.HSecUnitRate = DBUtility.ClsPub.isSingle(subList[0].HSecUnitRate);
+ oSub.HLeaveLife = DBUtility.ClsPub.isSingle(subList[0].HLeaveLife);
+ oSub.HDesignLife = DBUtility.ClsPub.isSingle(subList[0].HDesignLife);
+ oSub.HNewLeaveLife = DBUtility.ClsPub.isSingle(subList[0].HNewLeaveLife);
+ if (oSub.HDesignLife < 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "璁捐瀵垮懡涓嶈兘涓�0鎴栬�呭皬浜�0";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ if (oSub.HLeaveLife < 0)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鍓╀綑瀵垮懡涓嶈兘涓�0鎴栬�呭皬浜�0";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ oSub.HSourceInterID = DBUtility.ClsPub.isLong(subList[0].HSourceInterID);
+ oSub.HSourceEntryID = DBUtility.ClsPub.isLong(subList[0].HSourceEntryID);
+ oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillNo);
+ oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillType);
+ oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[0].HRelationQty);
+ oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[0].HRelationMoney);
+ BillNew.DetailColl.Add(oSub);
+ bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo);
+ if (bResult == true)
+ {
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = ClsPub.sExeReturnInfo + "鍗曟嵁鍙�:" + mainList[0].HBillNo.Trim();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ else
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "淇濆瓨澶辫触!鍘熷洜:" + ClsPub.sExeReturnInfo;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+
+ #endregion
+
+ #endregion
+
}
}
\ No newline at end of file
--
Gitblit v1.9.1