From 80072496b2f0014a0e12249d6066a96eb1a8ea5b Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期一, 08 八月 2022 14:21:55 +0800 Subject: [PATCH] 1 --- WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs | 2 +- .gitignore | 2 ++ WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs | 2 +- WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillListController.cs | 2 +- WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs | 2 +- WebAPI/Controllers/Sc_MouldRepairInBillListController.cs | 10 +++++----- WebAPI/Controllers/MJGL/Sc_MouldRepairOutBillController.cs | 2 +- WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepInBillListController .cs | 2 +- WebAPI/Controllers/Sc_MouldOtherInBillController.cs | 2 +- WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs | 2 +- 10 files changed, 15 insertions(+), 13 deletions(-) diff --git a/.gitignore b/.gitignore index 60fedd0..d02851a 100644 --- a/.gitignore +++ b/.gitignore @@ -133,3 +133,5 @@ /NETERPNoWin/obj/Debug/.NETFramework,Version=v4.0.AssemblyAttributes.cs /NETERPNoWin/bin/Debug /NETERPNoWin/obj/Debug +/WebAPI/Sc_MouldProdInBill/Log +/WebAPI/Vlog diff --git a/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepInBillListController .cs b/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepInBillListController .cs index aac2550..9c84d7a 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepInBillListController .cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepInBillListController .cs @@ -322,7 +322,7 @@ } if (bResult) { - string sql = $"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' "; + string sql =string.Format( $"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' "); oCn.RunProc(sql); objJsonResult.code = "0"; objJsonResult.count = 1; diff --git a/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs index 08f4336..fa75bcd 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldMoveStockStepOutBillController.cs @@ -323,7 +323,7 @@ } if (bResult) { - string sql = $"exec h_p_Sc_MouldChangeFileStatus 'out','{oBill.omodel.HInterID.ToString()}' "; + string sql =string.Format($"exec h_p_Sc_MouldChangeFileStatus 'out','{oBill.omodel.HInterID.ToString()}' ") ; oCn.RunProc(sql); objJsonResult.code = "0"; objJsonResult.count = 1; diff --git a/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs index 6dd5bbd..45c636a 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldOtherOutBillController.cs @@ -321,7 +321,7 @@ } if (bResult) { - string sql = $"exec h_p_Sc_MouldChangeFileStatus 'out','{oBill.omodel.HInterID.ToString()}' "; + string sql =string.Format($"exec h_p_Sc_MouldChangeFileStatus 'out','{oBill.omodel.HInterID.ToString()}' "); oCn.RunProc(sql); objJsonResult.code = "0"; objJsonResult.count = 1; diff --git a/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs index 4f3054e..a12cc8c 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldProdInBillController.cs @@ -634,7 +634,7 @@ } if (bResult) { - string sql = $"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' "; + string sql =string.Format($"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' "); DataSet db=oCn.RunProcReturn(sql, "h_p_Sc_MouldChangeFileStatus"); if (db.Tables[0].Rows[0]["issuccess"].ToString()=="0") { diff --git a/WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillListController.cs b/WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillListController.cs index 60c6fa1..28e2ece 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillListController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillListController.cs @@ -323,7 +323,7 @@ } if (bResult) { - string sql = $"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' "; + string sql =string.Format($"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' ") ; oCn.RunProc(sql); objJsonResult.code = "0"; objJsonResult.count = 1; diff --git a/WebAPI/Controllers/MJGL/Sc_MouldRepairOutBillController.cs b/WebAPI/Controllers/MJGL/Sc_MouldRepairOutBillController.cs index 1e9d0dd..ce400bd 100644 --- a/WebAPI/Controllers/MJGL/Sc_MouldRepairOutBillController.cs +++ b/WebAPI/Controllers/MJGL/Sc_MouldRepairOutBillController.cs @@ -328,7 +328,7 @@ } if (bResult) { - string sql = $"exec h_p_Sc_MouldChangeFileStatus 'out',{oBill.omodel.HInterID.ToString()} "; + string sql =string.Format($"exec h_p_Sc_MouldChangeFileStatus 'out',{oBill.omodel.HInterID.ToString()} ") ; oCn.RunProc(sql); objJsonResult.code = "0"; objJsonResult.count = 1; diff --git a/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs b/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs index c5f7462..23aa0b5 100644 --- a/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs +++ b/WebAPI/Controllers/Sc_CheckToolsRepairWorkBillListController.cs @@ -4486,7 +4486,7 @@ } if (bResult) { - string sql = $"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' "; + string sql =string.Format($"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' "); oCn.RunProc(sql); objJsonResult.code = "0"; objJsonResult.count = 1; diff --git a/WebAPI/Controllers/Sc_MouldOtherInBillController.cs b/WebAPI/Controllers/Sc_MouldOtherInBillController.cs index e053b18..fa1d35a 100644 --- a/WebAPI/Controllers/Sc_MouldOtherInBillController.cs +++ b/WebAPI/Controllers/Sc_MouldOtherInBillController.cs @@ -320,7 +320,7 @@ } if (bResult) { - string sql = $"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' "; + string sql =string.Format($"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' ") ; oCn.RunProc(sql); objJsonResult.code = "0"; objJsonResult.count = 1; diff --git a/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs b/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs index a90c3b5..be692fd 100644 --- a/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs +++ b/WebAPI/Controllers/Sc_MouldRepairInBillListController.cs @@ -3804,7 +3804,7 @@ } if (bResult) { - string sql = $"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' "; + string sql =string.Format($"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' "); oCn.RunProc(sql); objJsonResult.code = "0"; objJsonResult.count = 1; @@ -4214,7 +4214,7 @@ } if (bResult) { - string sql = $"exec h_p_Sc_MouldChangeFileStatus 'out','{oBill.omodel.HInterID.ToString()}' "; + string sql =string.Format($"exec h_p_Sc_MouldChangeFileStatus 'out','{oBill.omodel.HInterID.ToString()}' "); oCn.RunProc(sql); objJsonResult.code = "0"; objJsonResult.count = 1; @@ -4791,9 +4791,9 @@ } if (bResult) { - string sql = $"exec h_p_Sc_MouldProdBackBillList '{oBill.omodel.HBillNo}' "; + string sql =string.Format($"exec h_p_Sc_MouldProdBackBillList '{oBill.omodel.HBillNo}' ") ; oCn.RunProc(sql); - string sql1 = $"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' "; + string sql1 =string.Format($"exec h_p_Sc_MouldChangeFileStatus 'in','{oBill.omodel.HInterID.ToString()}' "); oCn.RunProc(sql1); objJsonResult.code = "0"; objJsonResult.count = 1; @@ -5230,7 +5230,7 @@ } if (bResult) { - string sql = $"exec h_p_Sc_MouldChangeFileStatus 'out','{oBill.omodel.HInterID.ToString()}' "; + string sql =string.Format($"exec h_p_Sc_MouldChangeFileStatus 'out','{oBill.omodel.HInterID.ToString()}' "); oCn.RunProc(sql); objJsonResult.code = "0"; objJsonResult.count = 1; -- Gitblit v1.9.1