From 3e291c359a5ee1a024ccf4daa1c8694d0b1acc3c Mon Sep 17 00:00:00 2001
From: ch <37327@LLOOCCY>
Date: 星期五, 02 七月 2021 08:47:26 +0800
Subject: [PATCH] nothing
---
WebAPI/Controllers/SCGL/QC_LastPieceCheckBillController.cs | 173 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 173 insertions(+), 0 deletions(-)
diff --git a/WebAPI/Controllers/SCGL/QC_LastPieceCheckBillController.cs b/WebAPI/Controllers/SCGL/QC_LastPieceCheckBillController.cs
index 68e40ab..f4ee717 100644
--- a/WebAPI/Controllers/SCGL/QC_LastPieceCheckBillController.cs
+++ b/WebAPI/Controllers/SCGL/QC_LastPieceCheckBillController.cs
@@ -25,6 +25,179 @@
/// <summary>
+ /// 鏂板鍗曟嵁-淇濆瓨鎸夐挳
+ ///鍙傛暟锛歴tring sql銆�
+ ///杩斿洖鍊硷細object銆�
+ /// </summary>
+ [Route("QC_LastPieceCheckBill/AddBill")]
+ [HttpPost]
+ public object AddBill([FromBody] JObject sMainSub)
+ {
+ var _value = sMainSub["sMainSub"].ToString();
+ string msg1 = _value.ToString();
+ oCN.BeginTran();
+ //淇濆瓨涓昏〃
+ objJsonResult = AddBillMain(msg1);
+ if (objJsonResult.code == "0")
+ {
+ oCN.RollBack();
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = objJsonResult.Message;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ oCN.Commit();
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鏂板鍗曟嵁鎴愬姛锛�";
+ return objJsonResult;
+ }
+
+ public json AddBillMain(string msg1)
+ {
+ string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
+ string msg2 = sArray[0].ToString();
+ string msg3 = sArray[1].ToString();
+ try
+ {
+ msg2 = "[" + msg2.ToString() + "]";
+ List<QC_LastPieceCheckBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<QC_LastPieceCheckBillMain>>(msg2);
+ string BillType = "7507";
+ long HInterID = mainList[0].HInterID;//閫掑叆type寰楀埌鐨勫崟鎹甀D
+ string HBillNo = mainList[0].HBillNo;//閫掑叆type寰楀埌鐨勫崟鎹彿
+ DateTime HDate = mainList[0].HDate;//鏃ユ湡
+ int HYear = 2021;
+ double HPeriod = 1;
+ long HBillStatus = mainList[0].HBillStatus;
+ long HCheckItemNowID = mainList[0].HCheckItemNowID;
+ long HCkeckItemNextID = mainList[0].HCheckItemNextID;
+ long HCheckFlowID = mainList[0].HCheckFlowID;
+ string HRemark = mainList[0].HRemark;//澶囨敞
+ string HBacker = mainList[0].HBacker;
+ DateTime HBackDate = mainList[0].HBackDate;
+ string HBackRemark = mainList[0].HBackRemark;
+ string HChecker = mainList[0].HChecker;
+ DateTime HCheckDate = mainList[0].HCheckDate;
+ string HMaker = mainList[0].HMaker;
+ DateTime HMakeDate = mainList[0].HMakeDate;
+ string HUpDater = mainList[0].HUpDater;
+ DateTime HUpDateDate = mainList[0].HUpDateDate;
+ string HCloseMan = mainList[0].HCloseMan;
+ DateTime HCloseDate = mainList[0].HCloseDate;
+ string HCloseType = mainList[0].HCloseType;
+ string HDeleteMan = mainList[0].HDeleteMan;
+ DateTime HDeleteDate = mainList[0].HDeleteDate;
+ string HMainSourceBillType = mainList[0].HMainSourceBillType;
+ long HMainSourceInterID = mainList[0].HMainSourceInterID;
+ long HMainSourceEntryID = mainList[0].HMainSourceEntryID;
+ string HMainSourceBillNo = mainList[0].HMainSourceBillNo;
+ double HPrintQty = mainList[0].HPrintQty;
+ long HICMOInterID = mainList[0].HICMOInterID;
+ string HICMOBillNo = mainList[0].HICMOBillNo;
+ Double HInStockQty = mainList[0].HInStockQty;
+ Double HCheckQty = mainList[0].HCheckQty;
+ Double HRightQty = mainList[0].HRightQTy;
+ Double HBadQty = mainList[0].HBadQty;
+ long HMaterID = mainList[0].HMaterID;
+ long HFirstCheckEmp = mainList[0].HFirstCheckEmp;
+ string HCheckerResult = mainList[0].HCheckerResult;
+ long HCheckDept = mainList[0].HCheckDept;
+ long HCheckDept2 = mainList[0].HCheckDept2;
+ string HCheckDeptResult = mainList[0].HCheckDeptResult;
+ string HCheckDeptResult2 = mainList[0].HCheckDeptResult2;
+ string HBarCode = mainList[0].HBarCode;
+ string HStoveBatchNo = mainList[0].HStoveBatchNo;
+ long HCusID = mainList[0].HCusID;
+ string HSortBillNo = mainList[0].HSortBillNo;
+ string HContrctBatchNo = mainList[0].HContrctBatchNo;
+ long HProdAreaID = mainList[0].HProdAreaID;
+ long HProdTypeID = mainList[0].HProdTypeID;
+ long HRoutingInterID = mainList[0].HRoutingInterID;
+ long HDrawingDireID = mainList[0].HDrawingDireID;
+ long HPackTypeID = mainList[0].HPackTypeID;
+
+ //涓昏〃
+ oCN.RunProc("Insert Into QC_LastPieceCheckBillMain " +
+ "(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" +
+ ",HYear,HPeriod,HRemark" +
+ ",HICMOInterID,HICMOBillNo,HInStockQTy,HCheckQty,HRightQty" +
+ ",HBadQty,HMaterID,HFirstCheckEmp,HCheckerResult,HCheckDept" +
+ ",HCheckDeptResult,HCheckDept2,HCheckDeptResult2,HBarCode,HStoveBatchNo" +
+ ",HCusID,HSortBillNo,HContrctBatchNo,HProdAreaID,HProdTypeID" +
+ ",HRoutingInterID,HDrawingDireID,HPackTypeID" +
+ ") " +
+ " values('" + BillType + "','" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HBillStatus + "','" + HDate + "','" + HMaker + "','" + HDate + "'" +
+ "," + HYear + "," + HPeriod + ",'" + HRemark + "'" +
+ "," + 0 + ",'" + HICMOBillNo + "'," + HInStockQty + "," + HCheckQty + "," + HRightQty +
+ "," + HBadQty + "," + HMaterID + "," + HFirstCheckEmp + ",'" + HCheckerResult + "'," + HCheckDept +
+ ",'" + HCheckDeptResult + "'," + HCheckDept2 + ",'" + HCheckDeptResult2 + "','" + HBarCode + "','" + HStoveBatchNo + "'" +
+ "," + HCusID + ",'" + HSortBillNo + "','" + HContrctBatchNo + "'," + HProdAreaID + "," + HProdTypeID +
+ "," + HRoutingInterID + "," + HDrawingDireID + "," + HPackTypeID +
+ ") ");
+
+
+ //淇濆瓨瀛愯〃
+ objJsonResult = AddBillSub(msg3, HInterID);
+ if (objJsonResult.code == "0")
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = objJsonResult.Message;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = null;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ catch (Exception e)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "Exception锛�" + e.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+
+ public json AddBillSub(string msg3, long HInterID)
+ {
+ List<QC_LastPieceCheckBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<QC_LastPieceCheckBillSub>>(msg3);
+ for (int i = 0; i < subList.ToArray().Length; i++)
+ {
+ long HSourceInterID = 0;//婧愬崟涓诲唴鐮�
+ long HSourceEntryID = 0;//婧愬崟瀛愬唴鐮�
+ string HSourceBillNo = "";//婧愬崟鍗曞彿
+ string HSourceBillType = "";//婧愬崟绫诲瀷
+ double HRelationQty = 0;//鍏宠仈鏁伴噺
+ double HRelationMoney = 0;//鍏宠仈閲戦
+
+
+ oCN.RunProc("Insert into QC_LastPieceCheckBillSub " +
+ "(HInterID,HEntryID,HCloseMan,HRemark,HSourceInterID,HSourceEntryID" +
+ ",HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
+ ",HQCCheckClassID,HQCCheckItemID,HQCStd,HResult,HQCRelValue" +
+ ",HProcCheckEmp" +
+ ") values("
+ + HInterID + "," + i + ",'" + subList[i].HCloseMan + "','" + subList[i].HRemark + "'," + HSourceInterID + "," + HSourceEntryID + "" +
+ ",'" + HSourceBillNo + "','" + HSourceBillType + "'," + HRelationQty + "," + HRelationMoney +
+ "," + subList[i].HQCCheckClassID + "," + subList[i].HQCCheckItemID + ",'" + subList[i].HQCStd + "','" + subList[i].HResult + "','" + subList[i].HQCRelvalue + "'" +
+ "," + subList[i].HProCheckEmp + "" +
+ ") ");
+ }
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = null;
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
+ /// <summary>
/// 杩斿洖浜у搧鍏ュ簱妫�楠屽崟鍒楄〃
///鍙傛暟锛歴tring sql銆�
///杩斿洖鍊硷細object銆�
--
Gitblit v1.9.1