| | |
| | | /// <returns></returns> |
| | | [Route("Xs_SeOutStockBill/DeltetSeOutStockBill")] |
| | | [HttpGet] |
| | | public object DeltetSeOutStockBill(string HInterID,string user) |
| | | public object DeltetSeOutStockBill(string HInterID, string HsupId, string HQty, string HSourceInterID, string HSourceEntryID, string user) |
| | | { |
| | | try |
| | | { |
| | |
| | | |
| | | oCN.BeginTran(); |
| | | var ds = oCN.RunProcReturn("select * from Xs_SeOutStockBillMain where HInterID=" + HInterID, "Xs_SeOutStockBillMain"); |
| | | |
| | | var dss = oCN.RunProcReturn("exec h_p_Xs_SeOutStockBillMain_Delete " + HQty + ", '" + HSourceInterID + "', '" + HSourceEntryID + "','" + user + " '", "h_p_Xs_SeOutStockBillMain_Delete"); |
| | | //删除前控制 |
| | | DataSet BeforeDs = oCN.RunProcReturn("Exec h_p_Xs_SeOutStockBill_BeforeDelCtrl " + HInterID.ToString() + ",'" + user + "'", "h_p_Xs_SeOutStockBill_BeforeDelCtrl"); |
| | | if (BeforeDs == null || BeforeDs.Tables[0].Rows.Count == 0) |
| | |
| | | oCN.RunProc("delete from Xs_SeOutStockBillSub where HInterID='" + HInterID + "'"); |
| | | } |
| | | //保存子表 |
| | | objJsonResult = AddBillSub(msg3, HInterID, OperationType); |
| | | objJsonResult = AddBillSub(msg3, HInterID, OperationType,user); |
| | | |
| | | |
| | | //保存后控制========================================= |
| | |
| | | } |
| | | } |
| | | |
| | | public json AddBillSub(string msg3, long HInterID, int OperationType) |
| | | public json AddBillSub(string msg3, long HInterID, int OperationType,string user) |
| | | { |
| | | List<ClsXs_SeOutStockBillSub> DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsXs_SeOutStockBillSub>>(msg3); |
| | | |
| | |
| | | ,{oSub.HAuxPropID},'{oSub.HBatchNO}','{oSub.HMTONo}',{oSub.HERPInterID},{oSub.HERPEntryID})"; |
| | | |
| | | oCN.RunProc(sql); |
| | | |
| | | ds = oCN.RunProcReturn("exec h_p_Xs_SeOutStockBillMain " + oSub.HQty + ", '" + oSub.HSourceInterID + "', '" + oSub.HSourceEntryID + "','" + user + " '", "h_p_Xs_SeOutStockBillMain"); |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |