From 27267fdefada781db7af074465a8263d6f61750c Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期四, 23 十二月 2021 15:43:44 +0800
Subject: [PATCH] nothing
---
WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user | 34 +++++++++++++++++-----------------
WebAPI/DLL/ClsSc_MESReturnStepWorkBill.cs | 12 +++++++-----
Model/车间管理/ClsSc_ProcessPlanMain.cs | 5 +++++
3 files changed, 29 insertions(+), 22 deletions(-)
diff --git "a/Model/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_ProcessPlanMain.cs" "b/Model/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_ProcessPlanMain.cs"
index 7483cfa..cfb5a22 100644
--- "a/Model/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_ProcessPlanMain.cs"
+++ "b/Model/\350\275\246\351\227\264\347\256\241\347\220\206/ClsSc_ProcessPlanMain.cs"
@@ -29,5 +29,10 @@
public int HGroupID;
public int HDeptID;
public int HQty;
+ public int HSourceInterID;// int --源单内码
+ public int HSourceEntryID;// int --源单子内码
+ public string HSourceBillNo;// varchar(50) --源单号
+ public string HSourceBillType;// varchar(10) --源单类型
+ public int HSourceID;
}
}
diff --git a/WebAPI/DLL/ClsSc_MESReturnStepWorkBill.cs b/WebAPI/DLL/ClsSc_MESReturnStepWorkBill.cs
index 33c00b7..9520fd8 100644
--- a/WebAPI/DLL/ClsSc_MESReturnStepWorkBill.cs
+++ b/WebAPI/DLL/ClsSc_MESReturnStepWorkBill.cs
@@ -66,11 +66,12 @@
oCn.RunProc("Insert Into Sc_ProcessPlanSub " +
"(HInterID,HEntryID,HBillNo" +
",HICMOInterID,HICMOBillNo,HProcNo,HProcID" +
- ",HGroupID,HDeptID,HWorkerID,HQty,HPlanBeginDate" +
+ ",HGroupID,HDeptID,HWorkerID,HQty,HPlanBeginDate,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" +
") " +
" values(" + omodel.HInterID.ToString() + ",0,'" + omodel.HBillNo +
"'," + omodel.HICMOInterID.ToString() + ",'" + omodel.HICMOBillNo + "','" + omodel.HProcNo + "'," + omodel.HProcID.ToString() + "," + omodel.HGroupID.ToString() +
- "," + omodel.HDeptID.ToString() + "," + omodel.HWorkerID.ToString() + "," + omodel.HQty.ToString() + ",'" + omodel.HPlanBeginDate.ToString() +
+ "," + omodel.HDeptID.ToString() + "," + omodel.HWorkerID.ToString() + "," + omodel.HQty.ToString() + ",'" + omodel.HPlanBeginDate.ToString() + "'," + omodel.HSourceInterID.ToString() +
+ "," + omodel.HSourceEntryID.ToString() + ",'" + omodel.HSourceBillNo + "','" + omodel.HSourceBillType +
"') ");
sReturn = "淇敼鍗曟嵁鎴愬姛锛�";
oCn.Commit();
@@ -106,12 +107,13 @@
oCn.RunProc("Insert Into Sc_ProcessPlanSub " +
"(HInterID,HEntryID,HBillNo" +
",HICMOInterID,HICMOBillNo,HProcNo,HProcID" +
- ",HGroupID,HDeptID,HWorkerID,HQty,HPlanBeginDate" +
+ ",HGroupID,HDeptID,HWorkerID,HQty,HPlanBeginDate,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HSourceID" +
") " +
" values(" + omodel.HInterID.ToString() + ",0,'" + omodel.HBillNo +
"'," + omodel.HICMOInterID.ToString() + ",'" + omodel.HICMOBillNo + "','" + omodel.HProcNo + "'," + omodel.HProcID.ToString() + "," + omodel.HGroupID.ToString() +
- "," + omodel.HDeptID.ToString() + "," + omodel.HWorkerID.ToString() + "," + omodel.HQty.ToString() + ",'" + omodel.HPlanBeginDate.ToString() +
- "') ");
+ "," + omodel.HDeptID.ToString() + "," + omodel.HWorkerID.ToString() + "," + omodel.HQty.ToString() + ",'" + omodel.HPlanBeginDate.ToString() +"',"+ omodel.HSourceInterID.ToString()+
+ ","+ omodel.HSourceEntryID.ToString()+",'"+ omodel.HSourceBillNo+"','"+ omodel.HSourceBillType+","+ omodel.HSourceID.ToString()+
+ ") ");
sReturn = "鏂板鍗曟嵁鎴愬姛锛�";
oCn.Commit();
return true;
diff --git a/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user b/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user
index cf5d1a7..09cdf98 100644
--- a/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user
+++ b/WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user
@@ -18,25 +18,25 @@
<publishTime>02/22/2013 08:43:40</publishTime>
</File>
<File Include="bin/BLL.dll">
- <publishTime>12/17/2021 17:47:36</publishTime>
+ <publishTime>12/21/2021 13:55:27</publishTime>
</File>
<File Include="bin/BLL.pdb">
- <publishTime>12/17/2021 17:47:36</publishTime>
+ <publishTime>12/21/2021 13:55:27</publishTime>
</File>
<File Include="bin/DAL.dll">
- <publishTime>12/17/2021 17:47:33</publishTime>
+ <publishTime>12/21/2021 13:55:25</publishTime>
</File>
<File Include="bin/DAL.pdb">
- <publishTime>12/17/2021 17:47:33</publishTime>
+ <publishTime>12/21/2021 13:55:25</publishTime>
</File>
<File Include="bin/Dapper.dll">
<publishTime>07/22/2016 14:52:40</publishTime>
</File>
<File Include="bin/DBUtility.dll">
- <publishTime>12/17/2021 17:47:30</publishTime>
+ <publishTime>12/21/2021 13:55:21</publishTime>
</File>
<File Include="bin/DBUtility.pdb">
- <publishTime>12/17/2021 17:47:30</publishTime>
+ <publishTime>12/21/2021 13:55:21</publishTime>
</File>
<File Include="bin/Interop.gregn6Lib.dll">
<publishTime>08/25/2021 10:28:25</publishTime>
@@ -60,10 +60,10 @@
<publishTime>07/25/2012 11:48:56</publishTime>
</File>
<File Include="bin/Model.dll">
- <publishTime>12/17/2021 17:47:30</publishTime>
+ <publishTime>12/21/2021 13:55:22</publishTime>
</File>
<File Include="bin/Model.pdb">
- <publishTime>12/17/2021 17:47:30</publishTime>
+ <publishTime>12/21/2021 13:55:22</publishTime>
</File>
<File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs">
<publishTime>08/16/2021 17:23:15</publishTime>
@@ -72,22 +72,22 @@
<publishTime>08/03/2014 20:33:56</publishTime>
</File>
<File Include="bin/Pub_Class.dll">
- <publishTime>12/17/2021 17:47:28</publishTime>
+ <publishTime>12/21/2021 13:55:20</publishTime>
</File>
<File Include="bin/Pub_Class.pdb">
- <publishTime>12/17/2021 17:47:28</publishTime>
+ <publishTime>12/21/2021 13:55:20</publishTime>
</File>
<File Include="bin/Pub_Control.dll">
- <publishTime>12/17/2021 17:47:28</publishTime>
+ <publishTime>12/21/2021 13:55:20</publishTime>
</File>
<File Include="bin/Pub_Control.pdb">
- <publishTime>12/17/2021 17:47:28</publishTime>
+ <publishTime>12/21/2021 13:55:20</publishTime>
</File>
<File Include="bin/SQLHelper.dll">
- <publishTime>12/17/2021 17:47:29</publishTime>
+ <publishTime>12/21/2021 13:55:20</publishTime>
</File>
<File Include="bin/SQLHelper.pdb">
- <publishTime>12/17/2021 17:47:29</publishTime>
+ <publishTime>12/21/2021 13:55:20</publishTime>
</File>
<File Include="bin/stdole.dll">
<publishTime>05/09/2021 13:35:37</publishTime>
@@ -189,10 +189,10 @@
<publishTime>11/24/2014 11:18:48</publishTime>
</File>
<File Include="bin/WebAPI.dll">
- <publishTime>12/17/2021 17:47:40</publishTime>
+ <publishTime>12/21/2021 13:55:30</publishTime>
</File>
<File Include="bin/WebAPI.pdb">
- <publishTime>12/17/2021 17:47:40</publishTime>
+ <publishTime>12/21/2021 13:55:30</publishTime>
</File>
<File Include="bin/WebGrease.dll">
<publishTime>07/17/2013 17:03:52</publishTime>
@@ -363,7 +363,7 @@
<publishTime>08/06/2021 22:57:28</publishTime>
</File>
<File Include="Web.config">
- <publishTime>12/17/2021 17:47:51</publishTime>
+ <publishTime>12/21/2021 13:55:41</publishTime>
</File>
</ItemGroup>
</Project>
\ No newline at end of file
--
Gitblit v1.9.1