From 4fc8ed6e9749869833ac07f00904955961cd6e70 Mon Sep 17 00:00:00 2001
From: jhz <jinghz@oceic.com>
Date: 星期四, 01 九月 2022 09:11:05 +0800
Subject: [PATCH] 2
---
WebAPI/Controllers/SCGL/日计划管理/JIT_DayPlanPlatFormBillController.cs | 46 ++++++++++++++++++++++++++++++++++++----------
1 files changed, 36 insertions(+), 10 deletions(-)
diff --git "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormBillController.cs" "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormBillController.cs"
index b38c925..625ae2d 100644
--- "a/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormBillController.cs"
+++ "b/WebAPI/Controllers/SCGL/\346\227\245\350\256\241\345\210\222\347\256\241\347\220\206/JIT_DayPlanPlatFormBillController.cs"
@@ -265,6 +265,9 @@
return objJsonResult;
}
+ //鍚屾鏃ヨ鍒掑伐鍗�
+ oCN.RunProc("exec REALESE_SC_ICMOBILLSTATUS_TMP");
+
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = null;
@@ -304,7 +307,7 @@
if (count != 1)
{
//鎻掑叆瀛愯〃
- oCN.RunProc("insert into Sc_WorkBillSortBillSub(HInterID,HEntryID," +
+ oCN.RunProc("insert into Sc_WorkBillSortBillSub(HInterID,HSEQ," +
"HMasterDate,HQty)" +
$"values({HInterID}, {(ds.Tables[0].Rows.Count + 1)}," +
$" '{date}', {HQTY})");
@@ -323,7 +326,10 @@
#region 娓呭崟閰嶆枡鏂瑰紡
public class PRD_PPBOM
{
-
+ /// <summary>
+ /// 鏃ヨ鍒掑伐鍗曞彿
+ /// </summary>
+ public string HMainICMOBillNo { get; set; }
/// <summary>
/// 鏃ヨ鍒掑伐鍗旻ID
/// </summary>
@@ -538,6 +544,10 @@
/// </summary>
public string FHMainICMOEntryID { get; set; }
/// <summary>
+ /// 鏃ヨ鍒掕鍗曞崟鍙凤細HMainICMOBillNo
+ /// </summary>
+ public string HMainICMOBillNo { get; set; }
+ /// <summary>
/// 鏃ヨ鍒掕鍗曚富鍐呯爜锛欶HICMOInterID
/// </summary>
public string FHICMOInterID { get; set; }
@@ -643,7 +653,6 @@
{
try
{
- oCN.BeginTran();
Stopwatch sw = new Stopwatch();
omdelMian = JsonConvert.DeserializeObject<Sc_WorkBillSortBillMain>(sWhere);
string sql = $"exec JIT_qtfx {omdelMian.HProdORGID},{omdelMian.HWorkShopID},'{user}' ";
@@ -653,7 +662,14 @@
DataTable resulTable = ds.Tables[0];
if (resulTable.Rows[0][0].ToString().Contains("澶辫触"))
{
- return resulTable.Rows[0][0].ToString();
+ //閲婃斁榻愬鎿嶄綔 閬垮厤澶氫汉鍚屾椂杩涜榻愬鍒嗘瀽
+ oCN.RunProc($"update T_PRD_QTFX set FSTATUS = 0 where FPRDORGID ={omdelMian.HProdORGID} and FSTATUS = 1 ");
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = resulTable.Rows[0][0].ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
}
else
{
@@ -664,7 +680,14 @@
string fDayPlanFEntryids = string.Empty;
if (BomList.Count == 0)
{
- return "娌℃湁闇�瑕佽繘琛岄綈濂楀垎鏋愮殑鏁版嵁";
+ //閲婃斁榻愬鎿嶄綔 閬垮厤澶氫汉鍚屾椂杩涜榻愬鍒嗘瀽
+ oCN.RunProc($"update T_PRD_QTFX set FSTATUS = 0 where FPRDORGID ={omdelMian.HProdORGID} and FSTATUS = 1 ");
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "娌℃湁闇�瑕佽繘琛岄綈濂楀垎鏋愮殑鏁版嵁";
+ objJsonResult.data = null;
+ return objJsonResult;
}
else
{
@@ -787,6 +810,7 @@
FHStockOrgID = _item.FStockOrgId,
FHPRDORGID = _item.FStockOrgId,
FPRDBillNo = _item.HICMOBillNo,
+ HMainICMOBillNo = _item.HMainICMOBillNo,
FOwnerTypeId = "",
FUnitDosage = _item.dwyl,//鍗曚綅鐢ㄩ噺
FSumPlanCount = planNeed,//璁″垝鎬绘暟閲�
@@ -830,6 +854,7 @@
FHStockOrgID = _item.FStockOrgId,
FHPRDORGID = _item.FStockOrgId,
FPRDBillNo = _item.HICMOBillNo,
+ HMainICMOBillNo = _item.HMainICMOBillNo,
FOwnerTypeId = "",
FUnitDosage = _item.dwyl,//鍗曚綅鐢ㄩ噺
FSumPlanCount = planNeed,//璁″垝鎬绘暟閲�
@@ -881,6 +906,7 @@
FHPRDORGID = _item.FStockOrgId,
FErpClsID = _item.FErpClsID,
FPRDBillNo = _item.HICMOBillNo,
+ HMainICMOBillNo = _item.HMainICMOBillNo,
FOwnerTypeId = Inventory.FOwnerTypeId,
FOwnerId = Inventory.FOwnerId,
FUnitDosage = _item.dwyl,//鍗曚綅鐢ㄩ噺
@@ -924,6 +950,7 @@
FHStockOrgID = _item.FStockOrgId,
FHPRDORGID = _item.FStockOrgId,
FPRDBillNo = _item.HICMOBillNo,
+ HMainICMOBillNo = _item.HMainICMOBillNo,
FOwnerTypeId = "",
FUnitDosage = _item.dwyl,//鍗曚綅鐢ㄩ噺
FSumPlanCount = planNeed,//璁″垝鎬绘暟閲�
@@ -960,6 +987,7 @@
insertDT.Columns.Add("FUNITDOSAGE", typeof(decimal));
insertDT.Columns.Add("FSUMPLANCOUNT", typeof(decimal));
insertDT.Columns.Add("FPRDBILLNO", typeof(string));
+ insertDT.Columns.Add("HMainICMOBillNo", typeof(string));
insertDT.Columns.Add("FOWNERID", typeof(long));
insertDT.Columns.Add("FOWNERTYPEID", typeof(string));
insertDT.Columns.Add("FPLANDATE", typeof(DateTime));
@@ -991,6 +1019,7 @@
dr["FUNITDOSAGE"] = item.FUnitDosage;
dr["FSUMPLANCOUNT"] = item.FSumPlanCount;
dr["FPRDBILLNO"] = item.FPRDBillNo;
+ dr["HMainICMOBillNo"] = item.HMainICMOBillNo;
dr["FOWNERID"] = item.FOwnerId == null ? "0" : item.FOwnerId;
dr["FOWNERTYPEID"] = item.FOwnerTypeId;
dr["FPLANDATE"] = item.FPlanDate.ToString("yyyy-MM-dd");
@@ -1017,12 +1046,12 @@
", HICMOEntryID, HMaterID, HStockORGID, HStockQty, HLeftQty" +
", HProdORGID, HUnitDosage, HSumPlanQty, HICMOBillNo, HOwnerID" +
", HOwnerTypeID, HPlanDate, HComplete, HLackQty, HOccupyQty" +
- ", HCompleteQty1, HErpClsID, HWorkShopID, HWHID, HOccupyPickedQTY)values" +
+ ", HCompleteQty1, HErpClsID, HWorkShopID, HWHID, HOccupyPickedQTY,HMainICMOBillNo)values" +
$"({item["FID"].ToString()}, 1, {item["FHMAINICMOINTERIDR"].ToString()}, {item["FHMAINICMOENTRYID"].ToString()}, {item["FHICMOINTERID"].ToString()}" +
$", {item["FHICMOENTRYID"].ToString()}, {item["FHMATERID"].ToString()}, {item["FHSTOCKORGID"].ToString()}, {item["FHSTOCKQTY"].ToString()}, {item["FHLEFTQTY"].ToString()}" +
$" , {item["FHPRDORGID"].ToString()}, {item["FUNITDOSAGE"].ToString()}, {item["FSUMPLANCOUNT"].ToString()}, '{item["FPRDBILLNO"].ToString()}', {item["FOWNERID"].ToString()}" +
$", '{item["FOWNERTYPEID"].ToString()}', '{item["FPLANDATE"].ToString()}','{item["FCOMPLETE"].ToString()}', {item["FLACKCOUNT"].ToString()}, {item["FOCCUPYCOUNT"].ToString()}" +
- $", {item["FCOMPLETECOUNT1"].ToString()}, {item["FERPCLSID"].ToString()}, {item["FWORKSHOPID"].ToString()}, {item["FSTOCKID"].ToString()}, {item["FOCCUPYPICKEDCOUNT"].ToString()})");
+ $", {item["FCOMPLETECOUNT1"].ToString()}, {item["FERPCLSID"].ToString()}, {item["FWORKSHOPID"].ToString()}, {item["FSTOCKID"].ToString()}, {item["FOCCUPYPICKEDCOUNT"].ToString()}, '{item["HMainICMOBillNo"].ToString()}')");
}
LogService.Write("鎵归噺鎻掑叆鍒版暟鎹簱鐢ㄦ椂锛�" + sw.Elapsed);
//鎵ц瀹屾垚鍚� 鏇存柊鏃ヨ鍒掑伐鍗曠姸鎬�
@@ -1045,8 +1074,6 @@
sw.Stop();//缁撴潫璁℃椂
LogService.Write("榻愬鍒嗘瀽杩愯鎬绘椂闀匡細" + sw.Elapsed);
- oCN.Commit();
-
objJsonResult.code = "1";
objJsonResult.count = 1;
objJsonResult.Message = "鎿嶄綔鎴愬姛";
@@ -1055,7 +1082,6 @@
}
catch (Exception e)
{
- oCN.RollBack();
LogService.Write("鎿嶄綔澶辫触锛�" + e.Message.ToString());
objJsonResult.code = "0";
objJsonResult.count = 0;
--
Gitblit v1.9.1