工程阶段 添加 查询 编辑 API 工程费用 添加 查询 编辑 API

chenhaozhe

2025-06-26 b318aa82c9309725574368b0f3d254d0c787ef2e

 WebAPI/Controllers/华远datamapping/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 ");