| | |
| | | { |
| | | |
| | | } |
| | | // æç»åä¿¡æ¯ |
| | | 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; |