From 4d25e6e0201601c001139328a1521392e5a12e9f Mon Sep 17 00:00:00 2001
From: zrg <z18737863051@163.com>
Date: 星期二, 02 七月 2024 09:06:47 +0800
Subject: [PATCH] 不良采集批量汇报方法,改成只插入一条,不进行循环插入
---
WebAPI/Properties/PublishProfiles/FolderProfile13.pubxml.user | 36 ++++++------
WebAPI/Controllers/生产管理/质量汇报单/Sc_QualityReportBillController.cs | 89 ++++++++++++++---------------
2 files changed, 60 insertions(+), 65 deletions(-)
diff --git "a/WebAPI/Controllers/\347\224\237\344\272\247\347\256\241\347\220\206/\350\264\250\351\207\217\346\261\207\346\212\245\345\215\225/Sc_QualityReportBillController.cs" "b/WebAPI/Controllers/\347\224\237\344\272\247\347\256\241\347\220\206/\350\264\250\351\207\217\346\261\207\346\212\245\345\215\225/Sc_QualityReportBillController.cs"
index c938585..0a94916 100644
--- "a/WebAPI/Controllers/\347\224\237\344\272\247\347\256\241\347\220\206/\350\264\250\351\207\217\346\261\207\346\212\245\345\215\225/Sc_QualityReportBillController.cs"
+++ "b/WebAPI/Controllers/\347\224\237\344\272\247\347\256\241\347\220\206/\350\264\250\351\207\217\346\261\207\346\212\245\345\215\225/Sc_QualityReportBillController.cs"
@@ -773,56 +773,51 @@
int i = 0;
foreach (Model.ClsSc_QualityReportBillSub oSub in ls)
{
-
-
- oSub.HMakeDate = DateTime.Now;
- int qty = Convert.ToInt32(oSub.HQty);
- for (int j = 0; j < qty; j++)
- {
- i++;
- oSub.HEntryID = i;
- string subSql = "Insert into Sc_QualityReportBillSub " +
- " (HInterID,HEntryID,HBillNo_bak,HRemark" +
- ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
- ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" +
- ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" +
- ",HBarCode,HReportType" +
- ",HAddr,HMaker,HMakeDate" +
- ") values(" +
- "" + oSub.HInterID.ToString() + "" +
- "," + oSub.HEntryID.ToString() + "" +
- ",'" + oSub.HBillNo_bak + "'" +
- ",'" + oSub.HRemark + "'" +
- "," + oSub.HSourceInterID.ToString() + "" +
- "," + oSub.HSourceEntryID.ToString() + "" +
- ",'" + oSub.HSourceBillNo + "'" +
- ",'" + oSub.HSourceBillType + "'" +
- "," + oSub.HRelationQty.ToString() + "" +
- "," + oSub.HRelationMoney.ToString() +
- "," + oSub.HMaterID.ToString() + "" +
- "," + oSub.HUnitID.ToString() + "" +
- ",'" + 1 +
- "','" + oSub.HResult + "'" +
- "," + oSub.HEmpID.ToString() + "" +
- "," + oSub.HSourceID.ToString() + "" +
- "," + oSub.HBadReasonID.ToString() + "" +
+ i++;
+ oSub.HMakeDate = DateTime.Now;
+ oSub.HEntryID = i;
+ string subSql = "Insert into Sc_QualityReportBillSub " +
+ " (HInterID,HEntryID,HBillNo_bak,HRemark" +
+ ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
+ ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" +
+ ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" +
+ ",HBarCode,HReportType" +
+ ",HAddr,HMaker,HMakeDate" +
+ ") values(" +
+ "" + oSub.HInterID.ToString() + "" +
+ "," + oSub.HEntryID.ToString() + "" +
+ ",'" + oSub.HBillNo_bak + "'" +
+ ",'" + oSub.HRemark + "'" +
+ "," + oSub.HSourceInterID.ToString() + "" +
+ "," + oSub.HSourceEntryID.ToString() + "" +
+ ",'" + oSub.HSourceBillNo + "'" +
+ ",'" + oSub.HSourceBillType + "'" +
+ "," + oSub.HRelationQty.ToString() + "" +
+ "," + oSub.HRelationMoney.ToString() +
- "," + oSub.HICMOInterID.ToString() + "" +
- "," + oSub.HICMOEntryID.ToString() + "" +
- ",'" + oSub.HICMOBillNo + "'" +
- "," + oSub.HProcExchInterID + "" +
- "," + oSub.HProcExchEntryID + "" +
- ",'" + oSub.HProcExchBillNo + "'" +
- ",'" + oSub.HBarCode + "'" +
+ "," + oSub.HMaterID.ToString() + "" +
+ "," + oSub.HUnitID.ToString() + "" +
+ ",'" + oSub.HQty.ToString() +
+ "','" + oSub.HResult + "'" +
+ "," + oSub.HEmpID.ToString() + "" +
+ "," + oSub.HSourceID.ToString() + "" +
+ "," + oSub.HBadReasonID.ToString() + "" +
- ",'" + 3 +
- "','" + oSub.HAddr + "'" +
- ",'" + msg4 + "'" +
- ",'" + oSub.HMakeDate.ToShortDateString() + "'" +
- ") ";
- oCN.RunProc(subSql);
- }
+ "," + oSub.HICMOInterID.ToString() + "" +
+ "," + oSub.HICMOEntryID.ToString() + "" +
+ ",'" + oSub.HICMOBillNo + "'" +
+ "," + oSub.HProcExchInterID + "" +
+ "," + oSub.HProcExchEntryID + "" +
+ ",'" + oSub.HProcExchBillNo + "'" +
+ ",'" + oSub.HBarCode + "'" +
+
+ ",'" + 3 +
+ "','" + oSub.HAddr + "'" +
+ ",'" + msg4 + "'" +
+ ",'" + oSub.HMakeDate.ToShortDateString() + "'" +
+ ") ";
+ oCN.RunProc(subSql);
}
objJsonResult.code = "0";
diff --git a/WebAPI/Properties/PublishProfiles/FolderProfile13.pubxml.user b/WebAPI/Properties/PublishProfiles/FolderProfile13.pubxml.user
index f3960d4..228058f 100644
--- a/WebAPI/Properties/PublishProfiles/FolderProfile13.pubxml.user
+++ b/WebAPI/Properties/PublishProfiles/FolderProfile13.pubxml.user
@@ -5,7 +5,7 @@
<Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
<PropertyGroup>
<_PublishTargetUrl>D:\缃戠珯鍙戝竷\鏅轰簯MESWMS\API</_PublishTargetUrl>
- <History>True|2024-07-01T07:34:19.0810024Z;True|2024-07-01T15:29:41.8587401+08:00;True|2024-07-01T15:06:46.7127992+08:00;True|2024-07-01T14:45:31.0703303+08:00;True|2024-07-01T14:13:18.0986061+08:00;True|2024-07-01T14:11:15.8643251+08:00;True|2024-07-01T13:29:59.6069813+08:00;True|2024-07-01T11:12:59.9147877+08:00;True|2024-07-01T10:22:37.9929084+08:00;True|2024-07-01T10:20:59.0844221+08:00;True|2024-07-01T10:17:38.9582335+08:00;True|2024-07-01T10:09:18.2084318+08:00;True|2024-07-01T10:08:49.4427785+08:00;True|2024-07-01T10:05:38.5373813+08:00;True|2024-07-01T09:47:53.4738455+08:00;</History>
+ <History>True|2024-07-02T00:52:20.9683250Z;True|2024-07-01T15:34:19.0810024+08:00;True|2024-07-01T15:29:41.8587401+08:00;True|2024-07-01T15:06:46.7127992+08:00;True|2024-07-01T14:45:31.0703303+08:00;True|2024-07-01T14:13:18.0986061+08:00;True|2024-07-01T14:11:15.8643251+08:00;True|2024-07-01T13:29:59.6069813+08:00;True|2024-07-01T11:12:59.9147877+08:00;True|2024-07-01T10:22:37.9929084+08:00;True|2024-07-01T10:20:59.0844221+08:00;True|2024-07-01T10:17:38.9582335+08:00;True|2024-07-01T10:09:18.2084318+08:00;True|2024-07-01T10:08:49.4427785+08:00;True|2024-07-01T10:05:38.5373813+08:00;True|2024-07-01T09:47:53.4738455+08:00;</History>
</PropertyGroup>
<ItemGroup>
<File Include="apiapp.json">
@@ -21,28 +21,28 @@
<publishTime>02/22/2013 16:43:40</publishTime>
</File>
<File Include="bin/BLL.dll">
- <publishTime>07/01/2024 15:33:48</publishTime>
+ <publishTime>07/02/2024 08:52:03</publishTime>
</File>
<File Include="bin/BLL.pdb">
- <publishTime>07/01/2024 15:33:48</publishTime>
+ <publishTime>07/02/2024 08:52:03</publishTime>
</File>
<File Include="bin/BouncyCastle.Crypto.dll">
<publishTime>12/18/2020 05:32:28</publishTime>
</File>
<File Include="bin/DAL.dll">
- <publishTime>07/01/2024 15:33:47</publishTime>
+ <publishTime>07/02/2024 08:52:01</publishTime>
</File>
<File Include="bin/DAL.pdb">
- <publishTime>07/01/2024 15:33:47</publishTime>
+ <publishTime>07/02/2024 08:52:01</publishTime>
</File>
<File Include="bin/Dapper.dll">
<publishTime>07/22/2016 22:52:40</publishTime>
</File>
<File Include="bin/DBUtility.dll">
- <publishTime>07/01/2024 15:33:44</publishTime>
+ <publishTime>07/02/2024 08:51:59</publishTime>
</File>
<File Include="bin/DBUtility.pdb">
- <publishTime>07/01/2024 15:33:44</publishTime>
+ <publishTime>07/02/2024 08:51:59</publishTime>
</File>
<File Include="bin/Grpc.Core.Api.dll">
<publishTime>03/22/2022 13:17:26</publishTime>
@@ -87,10 +87,10 @@
<publishTime>07/25/2012 19:48:56</publishTime>
</File>
<File Include="bin/Model.dll">
- <publishTime>07/01/2024 15:33:45</publishTime>
+ <publishTime>07/02/2024 08:51:59</publishTime>
</File>
<File Include="bin/Model.pdb">
- <publishTime>07/01/2024 15:33:45</publishTime>
+ <publishTime>07/02/2024 08:51:59</publishTime>
</File>
<File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs">
<publishTime>05/25/2024 09:46:41</publishTime>
@@ -123,25 +123,25 @@
<publishTime>10/23/2021 17:07:54</publishTime>
</File>
<File Include="bin/Pub_Class.dll">
- <publishTime>07/01/2024 15:33:43</publishTime>
+ <publishTime>07/02/2024 08:51:57</publishTime>
</File>
<File Include="bin/Pub_Class.pdb">
- <publishTime>07/01/2024 15:33:43</publishTime>
+ <publishTime>07/02/2024 08:51:57</publishTime>
</File>
<File Include="bin/Pub_Control.dll">
- <publishTime>07/01/2024 15:33:44</publishTime>
+ <publishTime>07/02/2024 08:51:57</publishTime>
</File>
<File Include="bin/Pub_Control.pdb">
- <publishTime>07/01/2024 15:33:44</publishTime>
+ <publishTime>07/02/2024 08:51:57</publishTime>
</File>
<File Include="bin/RestSharp.dll">
<publishTime>08/31/2012 06:22:50</publishTime>
</File>
<File Include="bin/SQLHelper.dll">
- <publishTime>07/01/2024 15:33:44</publishTime>
+ <publishTime>07/02/2024 08:51:58</publishTime>
</File>
<File Include="bin/SQLHelper.pdb">
- <publishTime>07/01/2024 15:33:44</publishTime>
+ <publishTime>07/02/2024 08:51:58</publishTime>
</File>
<File Include="bin/Swashbuckle.Core.dll">
<publishTime>02/16/2015 01:57:08</publishTime>
@@ -255,10 +255,10 @@
<publishTime>11/24/2014 19:18:48</publishTime>
</File>
<File Include="bin/WebAPI.dll">
- <publishTime>07/01/2024 15:33:52</publishTime>
+ <publishTime>07/02/2024 08:52:11</publishTime>
</File>
<File Include="bin/WebAPI.pdb">
- <publishTime>07/01/2024 15:33:52</publishTime>
+ <publishTime>07/02/2024 08:52:11</publishTime>
</File>
<File Include="bin/WebGrease.dll">
<publishTime>07/18/2013 01:03:52</publishTime>
@@ -453,7 +453,7 @@
<publishTime>05/25/2024 09:46:41</publishTime>
</File>
<File Include="Web.config">
- <publishTime>07/01/2024 15:34:18</publishTime>
+ <publishTime>07/02/2024 08:52:20</publishTime>
</File>
</ItemGroup>
</Project>
\ No newline at end of file
--
Gitblit v1.9.1