| | |
| | | /// <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) |
| | |
| | | long HConveyCompID = mainList[0].HConveyCompID;//运输公司 |
| | | long HConveyMoney = (long)mainList[0].HConveyMoney;//运费 |
| | | long HDFflag = Convert.ToInt32(mainList[0].HDFflag); //是否垫付 |
| | | |
| | | long HProjectID = mainList[0].HProjectID;//工程项目 |
| | | |
| | | string HBillType = mainList[0].HBillType; |
| | | string HBillSubType = mainList[0].HBillSubType; |
| | |
| | | ,HAddress,HSSID,HCurID,HWHID,HExRate,HEmpID,HExplanation,HInnerBillNo,HSeOrderBillNo_M |
| | | ,HConveyTypeID,HConveyCompID,HConveyMoney,HLinkMan,HLinkPhone |
| | | ,HSALEORGID,HDELIVERYORGID,HOWNERID,HOWNERTYPEID |
| | | ,HChecker,HCheckDate,HCloseMan,HCloseDate,HERPInterID,HERPBillType,HDFflag) |
| | | ,HChecker,HCheckDate,HCloseMan,HCloseDate,HERPInterID,HERPBillType,HDFflag,HProjectID) |
| | | values(" + HInterID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + 1402 + "','" + |
| | | 1402 + "','" + HDate + "','" + HBillNo + "'," + HBillStatus + "," + HCusID + |
| | | "," + HManagerID + "," + HDeptID + ",'" + HRemark + "','" + HMaker + "','" + HMakeDate + |
| | | "','" + HAddress + "'," + HSSID + "," + HCurID + "," + HWHID + "," + HExRate + "," + HEmpID + ",'" + |
| | | HExplanation + "','" + HInnerBillNo + "','" + HSeOrderBillNo_M + "','" + HConveyTypeID + "','" + HConveyCompID + "','" + HConveyMoney + "','" + HLinkMan + "','" + HLinkPhone + "'," + HSALEORGID + "," + HDELIVERYORGID + "," + HOWNERID + ",'" |
| | | + HOWNERTYPEID + "','" + HChecker + "','" + HCheckDate + "','" + HCloseMan + "','" + HCloseDate + "'," + HERPInterID + |
| | | ",'" + HERPBillType + "'," + HDFflag + ")"; |
| | | ",'" + HERPBillType + "'," + HDFflag + ",'"+ HProjectID + "')"; |
| | | |
| | | oCN.RunProc(sql); |
| | | |
| | |
| | | "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + |
| | | ",HCusID='" + HCusID + "', HCurID='" + HCurID + "', HWHID = '" + HWHID |
| | | + "',HExRate='" + HExRate + "',HEmpID='" + HEmpID + "',HSeOrderBillNo_M='" + HSeOrderBillNo_M + "',HManagerID='" + HManagerID + "',HDeptID='" + HDeptID + "',HOWNERID='" + HOWNERID |
| | | + "',HAddress='" + HAddress + "' where HInterID=" + HInterID; |
| | | + "',HAddress='" + HAddress + "',HProjectID='"+ HProjectID + "' where HInterID=" + HInterID; |
| | | oCN.RunProc(sql); |
| | | |
| | | //删除子表 |
| | | 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"; |