MES-WEB-API.git

parent: c9521814 | 补丁 | 提交 | ignore whitespace

zzr99

2021-12-23 27267fdefada781db7af074465a8263d6f61750c

nothing

3个文件已修改

	Model/车间管理/ClsSc_ProcessPlanMain.cs	5 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebAPI/DLL/ClsSc_MESReturnStepWorkBill.cs	12 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user	34 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 Model/³µ¼ä¹ÜÀí/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;
    }
}

 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;

 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>

			@@ -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;
			}
			}

			@@ -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;

			@@ -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>