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

llj

2025-08-07 1a94e0e270668ef1cfbcd5043b72bc6591a50706

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

@@ -355,6 +355,7 @@
        {
            try
            {
                LogService.Write("json:"+msg.ToString());
                var _value = msg["model"].ToString();
                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
                ListModels oListModels = new ListModels();
@@ -387,6 +388,7 @@
            }
            catch (Exception e)
            {
                LogService.Write("员工同步异常:" + e.ToString());
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "保存失败！" + e.ToString();
@@ -496,52 +498,58 @@
                    {

                    }
                    // æ˜Žç»†åˆ—信息
                    var _saveEntry = _saveObj["Result"]["Result"]["PostEntity"];

                    #region [表数据赋值]
                    var jsonData = new
                    foreach (var oSub in _saveEntry)
                    {
                        HItemID = _saveObj["Result"]["Result"]["Id"],
                        HNumber = _saveObj["Result"]["Result"]["Number"],
                        HName          = _saveObj["Result"]["Result"]["Name"][0]["Value"],
                        HShortNumber   = _saveObj["Result"]["Result"]["Number"],
                        HParentID      = 0,
                        HLevel         = 1,
                        HEndFlag       = 1,
                        HStopflag      = _saveObj["Result"]["Result"]["ForbidStatus"].ToString() == "A" ? 0 : 1,
                        HRemark        = "CLD-ERP导入",
                        HUseFlag       = "已使用",
                        HCREATEORGID   = _saveObj["Result"]["Result"]["CreateOrgId_Id"],
                        HUSEORGID      = _saveObj["Result"]["Result"]["UseOrgId_Id"],
                        HPERSONID      = _saveObj["Result"]["Result"]["PersonId_Id"],
                        HPOSTID        = _saveObj["Result"]["Result"]["FPostId_Id"],
                        HFIRSTCARDID   = _saveObj["Result"]["Result"]["FirstCardID_Id"],
                        HDeptID        = _saveObj["Result"]["Result"]["PostEntity"][0]["Post"]["FDept_Id"],
                        HSTAFFNUMBER = _saveObj["Result"]["Result"]["FStaffNumber"]
                    };
                        var jsonData = new
                        {
                            HItemID = oSub["StaffDetails"],
                            HNumber = _saveObj["Result"]["Result"]["Number"],
                            HName          = _saveObj["Result"]["Result"]["Name"][0]["Value"],
                            HShortNumber   = _saveObj["Result"]["Result"]["Number"],
                            HParentID      = 0,
                            HLevel         = 1,
                            HEndFlag       = 1,
                            HStopflag      = _saveObj["Result"]["Result"]["ForbidStatus"].ToString() == "A" ? 0 : 1,
                            HRemark        = "CLD-ERP导入",
                            HUseFlag       = "已使用",
                            HCREATEORGID   = _saveObj["Result"]["Result"]["CreateOrgId_Id"],
                            HUSEORGID      = _saveObj["Result"]["Result"]["UseOrgId_Id"],
                            HPERSONID      = _saveObj["Result"]["Result"]["PersonId_Id"],
                            HPOSTID        = _saveObj["Result"]["Result"]["FPostId_Id"],
                            HFIRSTCARDID   = _saveObj["Result"]["Result"]["FirstCardID_Id"],
                            HDeptID        = oSub["PostDept_Id"],
                            HSTAFFNUMBER = _saveObj["Result"]["Result"]["FStaffNumber"]
                        };

                        // åˆ é™¤ä¸»è¡¨å¯¹åº”数据
                        sql = $"delete from Gy_Staff where HItemID = " + jsonData.HItemID + " and HNumber = '" + Number + "'";
                        oCN.RunProc(sql);

                        sql = "set identity_insert Gy_Staff on";
                        oCN.RunProc(sql);

                        //插入表
                        sql = $@"
                    insert into Gy_Staff
                    (HItemID,HNumber,HName,HShortNumber,HParentID,HLevel
                   ,HEndFlag,HStopflag,HRemark,HUseFlag,HCREATEORGID,HUSEORGID
                   ,HPERSONID,HPOSTID,HFIRSTCARDID,HDeptID,HSTAFFNUMBER
                     )
                    values
                    ({jsonData.HItemID},'{jsonData.HNumber}','{jsonData.HName}',
                    '{jsonData.HShortNumber}',{jsonData.HParentID},{jsonData.HLevel},{jsonData.HEndFlag},{jsonData.HStopflag},'{jsonData.HRemark}','{jsonData.HUseFlag}',{jsonData.HCREATEORGID},{jsonData.HUSEORGID},
                      {jsonData.HPERSONID},{jsonData.HPOSTID},{jsonData.HFIRSTCARDID},{jsonData.HDeptID},'{jsonData.HSTAFFNUMBER}')";

                        oCN.RunProc(sql);

                        sql = "set identity_insert Gy_Staff off";
                        oCN.RunProc(sql);
                    }                   
                    #endregion
                    // åˆ é™¤ä¸»è¡¨å¯¹åº”数据
                    sql = $"delete from Gy_Staff where HItemID = " + jsonData.HItemID + " and HNumber = '" + Number + "'";
                    oCN.RunProc(sql);

                    sql = "set identity_insert Gy_Staff on";
                    oCN.RunProc(sql);

                    //插入表
                    sql = $@"
                insert into Gy_Staff
                (HItemID,HNumber,HName,HShortNumber,HParentID,HLevel
               ,HEndFlag,HStopflag,HRemark,HUseFlag,HCREATEORGID,HUSEORGID
               ,HPERSONID,HPOSTID,HFIRSTCARDID,HDeptID,HSTAFFNUMBER
                 )
                values
                ({jsonData.HItemID},'{jsonData.HNumber}','{jsonData.HName}',
                '{jsonData.HShortNumber}',{jsonData.HParentID},{jsonData.HLevel},{jsonData.HEndFlag},{jsonData.HStopflag},'{jsonData.HRemark}','{jsonData.HUseFlag}',{jsonData.HCREATEORGID},{jsonData.HUSEORGID},
                  {jsonData.HPERSONID},{jsonData.HPOSTID},{jsonData.HFIRSTCARDID},{jsonData.HDeptID},'{jsonData.HSTAFFNUMBER}')";

                    oCN.RunProc(sql);

                    sql = "set identity_insert Gy_Staff off";
                    oCN.RunProc(sql);

                    objJsonResult.code = "1";
                    objJsonResult.count = 1;