| | |
| | | oCN.RunProc("update KF_BarCodeStatusChangeBillMain set " + |
| | | "HRemark='" + HRemark + "', HChecker='" + HMaker + "', HCheckDate=getdate()" + ",HBillStatus=" + HBillStatus + |
| | | ",HEmpID=" + HEmpID + ",HDeptID=" + HDeptID + " where HInterID=" + HInterID); |
| | | |
| | | //鍒犻櫎瀛愯〃 |
| | | oCN.RunProc("delete from KF_BarCodeStatusChangeBillSub where HInterID='" + HInterID + "'"); |
| | | } |
| | | //淇濆瓨瀛愯〃 |
| | | objJsonResult = AddBillSub(msg3, HInterID, OperationType); |
| | | objJsonResult = AddBillSub(msg3, HInterID, OperationType, HMaker); |
| | | |
| | | if (objJsonResult.code == "0") |
| | | { |
| | |
| | | } |
| | | } |
| | | |
| | | public json AddBillSub(string msg3, long HInterID, int OperationType) |
| | | public json AddBillSub(string msg3, long HInterID, int OperationType,string user) |
| | | { |
| | | List<ClsKF_BarCodeStatusChangeBillSub> DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsKF_BarCodeStatusChangeBillSub>>(msg3); |
| | | |
| | |
| | | ,HRelationMoney,HBarCode,HBarCodeStatus_Old,HBarCodeStatus_New,HAuxPropID_Old,HAuxPropID_New,HMTONo_Old,HMTONo_New) |
| | | values({HInterID},{NewHEntryID},'{oSub.HBillNo_bak}','{oSub.HRemark}',{oSub.HSourceInterID} |
| | | ,{oSub.HSourceEntryID},'{oSub.HSourceBillNo}','{oSub.HSourceBillType}',{oSub.HRelationQty},{oSub.HRelationMoney},'{oSub.HBarCode}','{oSub.HBarCodeStatus_Old}','{oSub.HBarCodeStatus_New}','{oSub.HAuxPropID_Old}','{oSub.HAuxPropID_New}','{oSub.HMTONo_Old}','{oSub.HMTONo_New}')"); |
| | | oCN.RunProc("update Gy_BarCodeBill set " + |
| | | "HBarCodeStatus='" + oSub.HBarCodeStatus_New + "', HStatusMan='" + user + "'," + " HStatusDate=getdate()" + " where HBarCode='" + oSub.HBarCode+"'"); |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |