工序出站-保存屏蔽包装标识，员工同步更改

yusijie

2023-02-22 b51ed3cea777b1809afe07db7314b0e0a8c0e9b8

工序出站-保存屏蔽包装标识，员工同步更改

 WebAPI/Controllers/Sc_ProcessMangementController.cs

@@ -519,7 +519,7 @@
                    FentityModel.Add("FCostRate", dr1["FCostRate"].ToString());// æˆæœ¬æƒé‡
                    FentityModel.Add("FISBACKFLUSH", dr1["FISBACKFLUSH"].ToString() == "1" ? true : false);// å€’冲领料
                    FentityModel.Add("FMOMAINENTRYID", dr1["FMOENTRYID"].ToString());//
                    FentityModel.Add("F_bsv_Base1", new JObject() { ["Fnumber"] = dr1["FPREBDONENUMBER"].ToString() }); //包装标识
                    //FentityModel.Add("F_bsv_Base1", new JObject() { ["Fnumber"] = dr1["FPREBDONENUMBER"].ToString() }); //包装标识
                    FentityModel.Add("FLot", new JObject() { ["FNumber"] = dr1["FBATCHNO"].ToString() }); //批号
                    FentityModel.Add("F_bsv_Text", dr1["工序流转卡号"].ToString()); //流转卡号
                    JArray Fentity2 = new JArray();

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

@@ -496,52 +496,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;