价目表新增审核按钮无效修理bug

llj

2025-08-07 1a94e0e270668ef1cfbcd5043b72bc6591a50706

 WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_PatrolCheckBillController.cs

@@ -232,7 +232,7 @@
                string HRemark = list[0].HRemark;
                bool HStopflag = list[0].HStopflag;
                string HModifyEmp = msg3;
                string HPatrolCheckType = list[0].HPatrolCheckType;
                string HPatrolCheckItemType = list[0].HPatrolCheckItemType;
                bool HEndFlag = list[0].HEndFlag;
                Int64 HPatrolCheckItemClassID = list[0].HPatrolCheckItemClassID;

@@ -268,7 +268,16 @@

                //若MAINDI重复则重新获取
                oCN.BeginTran();

                DataSet ds1 = oCN.RunProcReturn("select * from h_v_Gy_PatrolCheckList where å·¡æ£€é¡¹ç›®ä»£ç  = " + HNumber, "h_v_Gy_PatrolCheckList");
                if(ds1.Tables[0].Rows.Count > 0)
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "代码重复！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                //保存前控制=========================================
                DataSet ds = oCN.RunProcReturn("Exec h_p_Gy_PatrolCheck_BeforeSaveCtrl " + msg3 + ",'1'", "h_p_Gy_PatrolCheck_BeforeSaveCtrl");
@@ -302,7 +311,7 @@
                    ",HUSEORGID=" + HUSEORGID  +
                    ",HHelpCode='" + HHelpCode + "'" +
                    ",HStopflag='" + HStopflag + "'" +
                    ",HPatrolCheckType='" + HPatrolCheckType + "'" +
                    ",HPatrolCheckItemType='" + HPatrolCheckItemType + "'" +
                    ",HPatrolCheckItemClassID=" + HPatrolCheckItemClassID +                     
                    ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo);
                //修改子项目代码
@@ -380,7 +389,7 @@
                string HUseFlag = list[0].HUseFlag;
                string HMakeEmp = list[0].HMakeEmp;
                bool HEndFlag = list[0].HEndFlag;
                string HPatrolCheckType = list[0].HPatrolCheckType;
                string HPatrolCheckItemType = list[0].HPatrolCheckItemType;
                Int64 HPatrolCheckItemClassID = list[0].HPatrolCheckItemClassID;
                //判断权限
                if (!ClsPub.Security_Log("Gy_PatrolCheck_Edit", 1, false, msg3))
@@ -406,6 +415,16 @@
                //若MAINDI重复则重新获取
                oCN.BeginTran();

                DataSet ds1 = oCN.RunProcReturn("select * from h_v_Gy_PatrolCheckList where å·¡æ£€é¡¹ç›®ä»£ç  = " + HNumber, "h_v_Gy_PatrolCheckList");
                if(ds1.Tables[0].Rows.Count > 0)
                {
                    oCN.RollBack();
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "代码重复！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }
                //保存前控制=========================================
                DataSet ds = oCN.RunProcReturn("Exec h_p_Gy_PatrolCheck_BeforeSaveCtrl " + msg3 + ",'1'", "h_p_Gy_PatrolCheck_BeforeSaveCtrl");
                if (ds == null)
@@ -432,11 +451,11 @@
                oCN.RunProc("Insert into Gy_PatrolCheck " +
                   " (HNumber,HName,HHelpCode,HShortNumber" +
                   ",HLevel,HEndFlag,HStopflag,HRemark,HParentID,HPatrolCheckItemClassID" +
                  ",HMakeEmp,HMakeTime,HUSEORGID,HCREATEORGID,HUseFlag,HPatrolCheckType" +
                  ",HMakeEmp,HMakeTime,HUSEORGID,HCREATEORGID,HUseFlag,HPatrolCheckItemType" +
                   " ) " +
                   " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," +
                    +HLevel + ",1," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "',0," + HPatrolCheckItemClassID + "" +
                      ",'" + HMakeEmp + "',getdate()," + HUSEORGID + "," + HCREATEORGID + ",'" + HUseFlag + "','"+ HPatrolCheckType + "')", ref DBUtility.ClsPub.sExeReturnInfo);
                      ",'" + HMakeEmp + "',getdate()," + HUSEORGID + "," + HCREATEORGID + ",'" + HUseFlag + "','"+ HPatrolCheckItemType + "')", ref DBUtility.ClsPub.sExeReturnInfo);
                //修改上级为非末级代码
                //oCN.RunProc("Update Gy_MouldType set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo);