| | |
| | | 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; |
| | | } |
| | | } |
| | |
| | | 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(); |
| | |
| | | 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; |
| | |
| | | <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> |
| | |
| | | <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> |
| | |
| | | <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> |
| | |
| | | <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> |
| | |
| | | <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> |