From b318aa82c9309725574368b0f3d254d0c787ef2e Mon Sep 17 00:00:00 2001 From: chenhaozhe <cgz@hz-kingdee.com> Date: 星期四, 26 六月 2025 14:27:23 +0800 Subject: [PATCH] 工程阶段 添加 查询 编辑 API 工程费用 添加 查询 编辑 API --- WebAPI/Controllers/华远datamapping/QC_CheckNote_PNL_TempController.cs | 40 ++++++++++++++++++++-------------------- 1 files changed, 20 insertions(+), 20 deletions(-) diff --git "a/WebAPI/Controllers/\345\215\216\350\277\234datamapping/QC_CheckNote_PNL_TempController.cs" "b/WebAPI/Controllers/\345\215\216\350\277\234datamapping/QC_CheckNote_PNL_TempController.cs" index 0ff28db..79ade4a 100644 --- "a/WebAPI/Controllers/\345\215\216\350\277\234datamapping/QC_CheckNote_PNL_TempController.cs" +++ "b/WebAPI/Controllers/\345\215\216\350\277\234datamapping/QC_CheckNote_PNL_TempController.cs" @@ -181,16 +181,16 @@ } //========================================================= - DataSet ds_exits = oCN.RunProcReturn("select HBarCode from QC_CheckNote_PNL_Temp where HSetNo = N'" + HSetNo + "'" + - "AND HPCSNo = N'" + HPCSNo + "'", "QC_CheckNote_PNL_Temp"); - if (ds_exits.Tables[0].Rows.Count > 0) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "SET缂栧彿鎴朠CS缂栧彿宸插瓨鍦紒"; - objJsonResult.data = null; - return objJsonResult; - } + //DataSet ds_exits = oCN.RunProcReturn("select HBarCode from QC_CheckNote_PNL_Temp where HSetNo = N'" + HSetNo + "'" + + // "AND HPCSNo = N'" + HPCSNo + "'", "QC_CheckNote_PNL_Temp"); + //if (ds_exits.Tables[0].Rows.Count > 0) + //{ + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "SET缂栧彿鎴朠CS缂栧彿宸插瓨鍦紒"; + // objJsonResult.data = null; + // return objJsonResult; + //} StringBuilder sb = new StringBuilder(); sb.Append("Insert Into QC_CheckNote_PNL_Temp(HBarCode, HSetNo, HPCSNo, HPosition_x,HPosition_y,HCheckProc,HPageIndex ,HBadReason, HMaker, HMakeDate) Values("); @@ -400,16 +400,16 @@ } //========================================================= - DataSet ds_exits = oCN.RunProcReturn("select HBarCode from QC_CheckNote_PNL_Temp where HSetNo = N'" + HSetNo + "'" + - "AND HPCSNo = N'" + HPCSNo + "' AND HItemID != " + HItemID, "QC_CheckNote_PNL_Temp"); - if (ds_exits.Tables[0].Rows.Count > 0) - { - objJsonResult.code = "0"; - objJsonResult.count = 0; - objJsonResult.Message = "SET缂栧彿鎴朠CS缂栧彿宸插瓨鍦紒"; - objJsonResult.data = null; - return objJsonResult; - } + //DataSet ds_exits = oCN.RunProcReturn("select HBarCode from QC_CheckNote_PNL_Temp where HSetNo = N'" + HSetNo + "'" + + // "AND HPCSNo = N'" + HPCSNo + "' AND HItemID != " + HItemID, "QC_CheckNote_PNL_Temp"); + //if (ds_exits.Tables[0].Rows.Count > 0) + //{ + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "SET缂栧彿鎴朠CS缂栧彿宸插瓨鍦紒"; + // objJsonResult.data = null; + // return objJsonResult; + //} StringBuilder sb = new StringBuilder(); sb.Append("Update QC_CheckNote_PNL_Temp set "); -- Gitblit v1.9.1