派生自 MES-WEB-API
WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs
@@ -1,4 +1,6 @@ using Newtonsoft.Json.Linq; using Model; using Newtonsoft.Json; using Newtonsoft.Json.Linq; using Pub_Class; using System; using System.Collections; @@ -13,6 +15,8 @@ //发货通知单Controller public class Xs_SeOutStockBillController : ApiController { //获取系统参数 Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); public DBUtility.ClsPub.Enum_BillStatus BillStatus; private json objJsonResult = new json(); @@ -158,7 +162,635 @@ } } #region 发货通知单 保存/编辑功能 [Route("Xs_SeOutStockBill/SeOutStockBillEdit")] [HttpPost] public object SeOutStockBillEdit([FromBody] JObject sMainSub) { try { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); oCN.BeginTran(); //保存主表 objJsonResult = AddBillMain(msg1); if (objJsonResult.code == "0") { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = objJsonResult.Message; objJsonResult.data = null; return objJsonResult; } oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "单据保存成功！"; objJsonResult.data = null; return objJsonResult; // } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } public json AddBillMain(string msg1) { string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); //主表数据 string msg3 = sArray[1].ToString(); //子表数据 int OperationType = int.Parse(sArray[2].ToString()); // 数据类型 1添加 3修改 string user = sArray[3].ToString(); string msg_allVal = sArray[4].ToString(); //主表+子表所有数据 try { msg2 = "[" + msg2.ToString() + "]"; List<ClsXs_SeOutStockBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsXs_SeOutStockBillMain>>(msg2); long HInterID = mainList[0].HInterID;//递入type得到的单据ID string HBillNo = mainList[0].HBillNo;//递入type得到的单据号 long HPRDORGID = mainList[0].HPRDORGID;//组织 DateTime HDate = mainList[0].HDate;//日期 string HRemark = mainList[0].HRemark;//备注 long HEmpID = mainList[0].HEmpID;//业务员 long HDeptID = mainList[0].HDeptID;//部门 long HWHID = mainList[0].HWHID;//仓库 long HManagerID = mainList[0].HManagerID;//主管 long HCurID = mainList[0].HCurID;//币别 Single HExRate = mainList[0].HExRate;//汇率 string HMaker = user;//制单人 string HExplanation = mainList[0].HExplanation;//摘要 string HInnerBillNo = mainList[0].HInnerBillNo;//内部单据号 long HCusID = mainList[0].HCusID; //客户 string HAddress = mainList[0].HAddress;//地址 long HSSID = mainList[0].HSSID;//结算方式 long HDFflag = Convert.ToInt32(mainList[0].HDFflag); //是否垫付 string HBillType = mainList[0].HBillType; string HBillSubType = mainList[0].HBillSubType; long HBillStatus = mainList[0].HBillStatus; string HMakeDate = mainList[0].HMakeDate; string HChecker = mainList[0].HChecker; string HCheckDate = mainList[0].HCheckDate; string HUpDater = mainList[0].HUpDater; string HUpDateDate = mainList[0].HUpDateDate; string HDeleteMan = mainList[0].HDeleteMan; string HDeleteDate = mainList[0].HDeleteDate; string HCloseMan = mainList[0].HCloseMan; string HCloseDate = mainList[0].HCloseDate; long HERPInterID = mainList[0].HERPInterID; string HERPBillType = mainList[0].HERPBillType; long HSALEORGID = mainList[0].HSALEORGID; long HDELIVERYORGID = mainList[0].HDELIVERYORGID; long HOWNERID = mainList[0].HOWNERID; string HOWNERTYPEID = mainList[0].HOWNERTYPEID; ds = oCN.RunProcReturn("select * from h_v_IF_SeOutStockBillList where hmainid=" + HInterID + " and 单据号='" + HBillNo + "'", "h_v_IF_SeOutStockBillList"); if ((OperationType == 1 || OperationType == 2) && ds.Tables[0].Rows.Count == 0)//新增 { //主表 oCN.RunProc(@"Insert Into Xs_SeOutStockBillMain (HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate,HBillNo,HBillStatus ,HCusID,HManagerID,HDeptID,HRemark,HMaker,HMakeDate ,HAddress,HSSID,HCurID,HWHID,HExRate,HEmpID,HExplanation,HInnerBillNo ,HSALEORGID,HDELIVERYORGID,HOWNERID,HOWNERTYPEID ,HChecker,HCheckDate,HCloseMan,HCloseDate,HERPInterID,HERPBillType,HDFflag) 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 + "'," + HSALEORGID + "," + HDELIVERYORGID + "," + HOWNERID + ",'" + HOWNERTYPEID + "','" + HChecker + "','" + HCheckDate + "','" + HCloseMan + "','" + HCloseDate + "'," + HERPInterID + ",'" + HERPBillType + "'," + HDFflag + ")"); } else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) { //修改 oCN.RunProc("update Xs_SeOutStockBillMain set " + "HRemark='" + HRemark + "', HChecker='" + HMaker + "', HCheckDate=getdate()" + "' where HInterID=" + HInterID); //删除子表 oCN.RunProc("delete from Xs_SeOutStockBillSub where HInterID='" + HInterID + "'"); } //保存子表 objJsonResult = AddBillSub(msg3, HInterID, OperationType); if (objJsonResult.code == "0") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = objJsonResult.Message; objJsonResult.data = null; return objJsonResult; } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = null; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } public json AddBillSub(string msg3, long HInterID, int OperationType) { List<ClsXs_SeOutStockBillSub> DetailColl = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsXs_SeOutStockBillSub>>(msg3); int i = 0; foreach (ClsXs_SeOutStockBillSub oSub in DetailColl) { i++; if (oSub.HQty <= 0 || oSub.HQty == null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "第" + i + "行，数量不能为0或者小于0"; objJsonResult.data = null; return objJsonResult; } if (oSub.HMaterID == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "第" + i + "行，物料不能为空"; objJsonResult.data = null; return objJsonResult; } //if (oSub.HSourceID == 0) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "第" + i + "行，生产资源不能为空"; // objJsonResult.data = null; // return objJsonResult; //} if (oSub.HUnitID == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "第" + i + "行，计量单位不能为空"; objJsonResult.data = null; return objJsonResult; } DataSet Cs; Int64 NewHEntryID = 1; Cs = oCN.RunProcReturn("select MAX(HEntryID)HEntryID from Xs_SeOutStockBillSub", "Xs_SeOutStockBillSub"); if (Cs.Tables[0].Rows.Count != 0 && ClsPub.isLong(Cs.Tables[0].Rows[0]["HEntryID"].ToString()) != 0) { NewHEntryID = ClsPub.isLong(Cs.Tables[0].Rows[0]["HEntryID"].ToString()); NewHEntryID += 1; } oCN.RunProc($@"Insert into Xs_SeOutStockBillSub (HInterID,HEntryID,HMaterID,HUnitID,HQty,HPrice,HMoney,HWHID,HSPID,HRemark ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HSeOrderInterID,HSeOrderEntryID,HSeORderBillNo ,HOWNERID,HOWNERTYPEID,HSETTLEORGID,HMoveStockQty ,HRelationQty,HAuxPropID,HBatchNO,HMTONo,HERPInterID,HERPEntryID) values({HInterID},{NewHEntryID},{oSub.HMaterID},{oSub.HUnitID},{oSub.HQty} ,{oSub.HPrice},{oSub.HMoney},{oSub.HWHID},{oSub.HSPID},'{oSub.HRemark}',{oSub.HSourceInterID},{oSub.HSourceEntryID},'{oSub.HSourceBillNo}','{oSub.HSourceBillType}',{oSub.HSeOrderInterID},{oSub.HSeOrderEntryID},'{oSub.HSeORderBillNo}',{oSub.HOWNERID},'{oSub.HOWNERTYPEID}',{oSub.HSETTLEORGID},{oSub.HMoveStockQty},{oSub.HRelationQty} ,{oSub.HAuxPropID},'{oSub.HBatchNO}','{oSub.HMTONo}',{oSub.HERPInterID},{oSub.HERPEntryID})"); } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = null; objJsonResult.data = null; return objJsonResult; } #endregion #region [同步插件] [Route("Xs_SeOutStockBill/Xs_SeOutStockBillSaveApi")] [HttpPost] public object Xs_SeOutStockBillSaveApi([FromBody] JObject sMainSub) { try { //LogService.Write("发货通知单同步,保存方法执行完成异常：" + sMainSub.ToString()); var model = sMainSub["model"].ToString(); var entry = sMainSub["model"]["HENTRY"].ToString(); model = "[" + model.ToString() + "]"; List<ClsXs_SeOutStockBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsXs_SeOutStockBillMain>>(model); List<ClsXs_SeOutStockBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsXs_SeOutStockBillSub>>(entry); string sql = string.Empty; oCN.BeginTran(); sql = $"delete Xs_SeOutStockBillMain where HinterID = {mainList[0].HInterID}"; oCN.RunProc(sql); sql = $"delete Xs_SeOutStockBillSub where HinterID = {mainList[0].HInterID}"; oCN.RunProc(sql); //主表 oCN.RunProc(@"Insert Into Xs_SeOutStockBillMain (HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate,HBillNo,HBillStatus ,HCusID,HManagerID,HDeptID,HRemark,HAddress,HSSID,HCurID,HWHID,HExRate ,HEmpID,HExplanation,HInnerBillNo,HSALEORGID,HDELIVERYORGID,HOWNERID ,HOWNERTYPEID,HERPInterID,HERPBillType,HMaker,HMakeDate,HChecker,HCheckDate ,HCloseMan,HCloseDate,HSTOCKERGROUPID,HSALEGROUPID,HSALEDEPTID,HBUSINESSTYPE ,HCARRIERID,HRECEIVERID,HSETTLEID,HPAYERID,HHEADLOCID,HRECCONTACTID ,HRECEIPTCONDITIONID,HCORRESPONDORGID,HCARRIAGENO) values(" + mainList[0].HInterID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + 1402 + "','" + mainList[0].HBillSubType + "','" + mainList[0].HDate + "','" + mainList[0].HBillNo + "','" + mainList[0].HBillStatus + "'," + mainList[0].HCusID + "," + mainList[0].HManagerID + "," + mainList[0].HDeptID + ",'" + mainList[0].HRemark + "','" + mainList[0].HAddress + "'," + mainList[0].HSSID + "," + mainList[0].HCurID + "," + mainList[0].HWHID + "," + mainList[0].HExRate + "," + mainList[0].HEmpID + ",'" + mainList[0].HExplanation + "','" + mainList[0].HInnerBillNo + "'," + mainList[0].HSALEORGID + "," + mainList[0].HDELIVERYORGID + "," + mainList[0].HOWNERID + ",'" + mainList[0].HOWNERTYPEID + "'," + mainList[0].HERPInterID + ",'" + mainList[0].HERPBillType + "','" + mainList[0].HMaker + "','" + mainList[0].HMakeDate + "','" + mainList[0].HChecker + "','" + mainList[0].HCheckDate + "','" + mainList[0].HCloseMan + "','" + mainList[0].HCloseDate + "'," + mainList[0].HSTOCKERGROUPID + "," + mainList[0].HSALEGROUPID + "," + mainList[0].HSALEDEPTID + ",'" + mainList[0].HBUSINESSTYPE + "'," + mainList[0].HCARRIERID + "," + mainList[0].HRECEIVERID + "," + mainList[0].HSETTLEID + "," + mainList[0].HPAYERID + "," + mainList[0].HHEADLOCID + "," + mainList[0].HRECCONTACTID + "," + mainList[0].HRECEIPTCONDITIONID + "," + mainList[0].HCORRESPONDORGID + ",'" + mainList[0].HCARRIAGENO + "'" + ")"); //保存主表 foreach (var oSub in subList) { sql = $@" Insert into Xs_SeOutStockBillSub (HInterID,HEntryID,HMaterID,HUnitID,HQty,HPrice,HMoney,HWHID,HSPID,HRemark, HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HSeOrderInterID, HSeOrderEntryID,HSeORderBillNo,HOWNERID,HOWNERTYPEID,HSETTLEORGID,HMoveStockQty, HRelationQty,HAuxPropID,HBatchNO,HMTONo,HERPInterID,HERPEntryID,HCUSTMATID, HBASEUNITID,HBFLOWID,HOUTCONTROL,HSTOCKUNITID,HROWTYPE,HROWID,HPARENTROWID, HPARENTMATID,HTAXCOMBINATION,HPRICECOEFFICIENT,HSYSPRICE,HLIMITDOWNPRICE, HPRICEUNITID,HTAXPRICE,HTAXRATE,HTAXNETPRICE,HDISCOUNTRATE,HISFREE,HLOCALCURRID, HSETTLECURRID,HEXCHANGETYPEID,HSETTLETYPEID,HRECEIPTCONDITIONID,HEXCHANGERATE, HISINCLUDEDTAX,HISPRICEEXCLUDETAX,HTAXRATEID,HTaxRate_TAX,HCOSTPERCENT,HVAT, HSELLERWITHHOLDING,HBUYERWITHHOLDING) values('{oSub.HInterID}','{oSub.HEntryID}','{oSub.HMaterID}','{oSub.HUnitID}','{oSub.HQty}','{oSub.HPrice}','{oSub.HMoney}','{oSub.HWHID}','{oSub.HSPID}','{oSub.HRemark}','{oSub.HSourceInterID}', '{oSub.HSourceEntryID}','{oSub.HSourceBillNo}','{oSub.HSourceBillType}','{oSub.HSeOrderInterID}','{oSub.HSeOrderEntryID}','{oSub.HSeORderBillNo}','{oSub.HOWNERID}','{oSub.HOWNERTYPEID}','{oSub.HSETTLEORGID}','{oSub.HMoveStockQty}', '{oSub.HRelationQty}','{oSub.HAuxPropID}','{oSub.HBatchNO}','{oSub.HMTONo}','{oSub.HERPInterID}', '{oSub.HERPEntryID}','{oSub.HCUSTMATID}','{oSub.HBASEUNITID}','{oSub.HBFLOWID}','{oSub.HOUTCONTROL}','{oSub.HSTOCKUNITID}','{oSub.HROWTYPE}', '{oSub.HROWID}','{oSub.HPARENTROWID}', '{oSub.HPARENTMATID}','{oSub.HTAXCOMBINATION}','{oSub.HPRICECOEFFICIENT}','{oSub.HSYSPRICE}','{oSub.HLIMITDOWNPRICE}','{oSub.HPRICEUNITID}','{oSub.HTAXPRICE}','{oSub.HTAXRATE}','{oSub.HTAXNETPRICE}','{oSub.HDISCOUNTRATE}','{oSub.HISFREE}', '{oSub.HLOCALCURRID}','{oSub.HSETTLECURRID}','{oSub.HEXCHANGETYPEID}','{oSub.HSETTLETYPEID}','{oSub.HRECEIPTCONDITIONID}','{oSub.HEXCHANGERATE}','{oSub.HISINCLUDEDTAX}','{oSub.HISPRICEEXCLUDETAX}','{oSub.HTAXRATEID}', '{oSub.HTaxRate_TAX}','{oSub.HCOSTPERCENT}','{oSub.HVAT}','{oSub.HSELLERWITHHOLDING}','{oSub.HBUYERWITHHOLDING}')"; oCN.RunProc(sql); } oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "单据保存成功！"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { LogService.Write("发货通知单同步异常,保存方法执行完成异常：" + e.Message.ToString()); oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "保存失败！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region [同步单据] [Route("Xs_SeOutStockBill/Xs_SeOutStockBillViewApi")] [HttpGet] public json Xs_SeOutStockBillViewApi(string BillNo, string BillType) { string sql = string.Empty; string sReturn = ""; if (oSystemParameter.ShowBill(ref sReturn) == true) { //系统参数是否为私有云模式,N为公有云模式，Y为私有云模式 if (oSystemParameter.omodel.WMS_CloudMode == "Y") { #region [私有云模式，直接调用数据库存储过程更新] try { oCN.BeginTran(); SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet DS = oCn.RunProcReturn("exec h_p_WMS_ERPSourceBillToLocal '" + BillNo + "','" + BillType + "'", "h_p_WMS_ERPSourceBillToLocal"); if (DS == null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据同步失败"; objJsonResult.data = null; return objJsonResult; } else { if (DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HBack"]) == "2") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ERP中不存在该单据号"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "单据同步成功"; objJsonResult.data = null; return objJsonResult; } } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exception！" + e.ToString(); objJsonResult.data = null; return objJsonResult; } #endregion } else { #region [公有云模式，调用WEBAPI的方式进行更新] var json = new { CreateOrgId = 0, Number = BillNo, Id = "" }; #region [金蝶部分] //登录金蝶 var loginRet = InvokeHelper.Login(); var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>(); //判断是否登录成功 if (isSuccess < 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = loginRet; objJsonResult.data = null; return objJsonResult; } //查看 获取数据 var _result = InvokeHelper.View("SAL_DELIVERYNOTICE", JsonConvert.SerializeObject(json)); var _saveObj = JObject.Parse(_result); //判断数据是否获取成功 if (_saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "金蝶发货通知单同步失败jsonRoot：" + _result; objJsonResult.data = null; return objJsonResult; } #endregion //获取主表数据 DataSet Ds; Int64 InterID = 0; Ds = oCN.RunProcReturn("select * from Xs_SeOutStockBillMain where HBillNo = '" + BillNo + "'", "Xs_SeOutStockBillMain"); if (Ds.Tables[0].Rows.Count != 0 && ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString()) != 0) { InterID = ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString()); } #region [主表数据赋值] var jsonData = new { HInterID = _saveObj["Result"]["Result"]["Id"], HYear = DateTime.Now.Year, HPeriod = DateTime.Now.Month, HBillType = 1402, HBillSubType = 1402, HDate = _saveObj["Result"]["Result"]["Date"], HBillNo = _saveObj["Result"]["Result"]["BillNo"], HBillStatus = _saveObj["Result"]["Result"]["ApproverID_Id"].ToString() == Convert.ToString(0) ? 1 : 2, HCusID = _saveObj["Result"]["Result"]["CustomerID_Id"], HManagerID = _saveObj["Result"]["Result"]["StockerID_Id"], HDeptID = _saveObj["Result"]["Result"]["DeliveryDeptID_Id"], HRemark = _saveObj["Result"]["Result"]["Note"], HAddress = _saveObj["Result"]["Result"]["ReceiveAddress"], HSSID = 0, HCurID = 0, HWHID = 0, HExRate = 1, HEmpID = _saveObj["Result"]["Result"]["SalesManID_Id"], HExplanation = "", HInnerBillNo = "", HSALEORGID = _saveObj["Result"]["Result"]["SaleOrgId_Id"], HDELIVERYORGID = _saveObj["Result"]["Result"]["DeliveryOrgID_Id"], HOWNERID = _saveObj["Result"]["Result"]["OwnerIdHead_Id"], HOWNERTYPEID = _saveObj["Result"]["Result"]["OwnerTypeIdHead"], HERPInterID = _saveObj["Result"]["Result"]["Id"], HERPBillType = _saveObj["Result"]["Result"]["BillTypeID_Id"], HMaker = _saveObj["Result"]["Result"]["CreatorId"]["Name"], HMakeDate = _saveObj["Result"]["Result"]["CreateDate"], HChecker = _saveObj["Result"]["Result"]["ApproverID"]["Name"], HCheckDate = _saveObj["Result"]["Result"]["ApproveDate"], HCloseMan = _saveObj["Result"]["Result"]["CLOSERID_Id"], HCloseDate = _saveObj["Result"]["Result"]["CLOSEDATE"], HSTOCKERGROUPID = _saveObj["Result"]["Result"]["StockerGroupID_Id"], HSALEGROUPID = _saveObj["Result"]["Result"]["SaleGroupID_Id"], HSALEDEPTID = _saveObj["Result"]["Result"]["SaleDeptID_Id"], HBUSINESSTYPE = _saveObj["Result"]["Result"]["BussinessType"], HCARRIERID = _saveObj["Result"]["Result"]["CarrierID_Id"], HRECEIVERID = _saveObj["Result"]["Result"]["ReceiverID_Id"], HSETTLEID = _saveObj["Result"]["Result"]["SettleID_Id"], HPAYERID = _saveObj["Result"]["Result"]["PayerID_Id"], HHEADLOCID = _saveObj["Result"]["Result"]["HeadLocId_Id"], HRECCONTACTID = 0, HRECEIPTCONDITIONID = _saveObj["Result"]["Result"]["FRECEIPTCONDITIONID_Id"], HCORRESPONDORGID = _saveObj["Result"]["Result"]["CorrespondOrgId_Id"], HCARRIAGENO = _saveObj["Result"]["Result"]["CarriageNO"] }; #endregion // 删除主表对应数据 sql = $"delete from Xs_SeOutStockBillMain where HInterID = " + InterID; oCN.RunProc(sql); //插入主表 sql = $@" insert into Xs_SeOutStockBillMain (HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate ,HBillNo,HBillStatus ,HCusID,HManagerID,HDeptID,HRemark,HAddress,HSSID ,HCurID,HWHID,HExRate,HEmpID,HExplanation,HInnerBillNo ,HSALEORGID,HDELIVERYORGID,HOWNERID,HOWNERTYPEID,HERPInterID,HERPBillType ,HMaker,HMakeDate,HChecker,HCheckDate,HCloseMan,HCloseDate ,HSTOCKERGROUPID,HSALEGROUPID,HSALEDEPTID,HBUSINESSTYPE,HCARRIERID,HRECEIVERID ,HSETTLEID,HPAYERID,HHEADLOCID,HRECCONTACTID,HRECEIPTCONDITIONID,HCORRESPONDORGID ,HCARRIAGENO ) values ({jsonData.HInterID},{jsonData.HYear},{jsonData.HPeriod},{jsonData.HBillType},{jsonData.HBillSubType}, '{jsonData.HDate}','{jsonData.HBillNo}',{jsonData.HBillStatus},{jsonData.HCusID},{jsonData.HManagerID},{jsonData.HDeptID}, '{jsonData.HRemark}','{jsonData.HAddress}',{jsonData.HSSID},{jsonData.HCurID},{jsonData.HWHID},{jsonData.HExRate}, {jsonData.HEmpID},'{jsonData.HExplanation}','{jsonData.HInnerBillNo}',{jsonData.HSALEORGID},{jsonData.HDELIVERYORGID}, {jsonData.HOWNERID},'{jsonData.HOWNERTYPEID}',{jsonData.HERPInterID},'{jsonData.HERPBillType}','{jsonData.HMaker}', '{jsonData.HMakeDate}','{jsonData.HChecker}','{jsonData.HCheckDate}','{jsonData.HCloseMan}','{jsonData.HCloseDate}', {jsonData.HSTOCKERGROUPID},{jsonData.HSALEGROUPID},{jsonData.HSALEDEPTID},'{jsonData.HBUSINESSTYPE}',{jsonData.HCARRIERID}, {jsonData.HRECEIVERID},{jsonData.HSETTLEID},{jsonData.HPAYERID},{jsonData.HHEADLOCID},{jsonData.HRECCONTACTID}, {jsonData.HRECEIPTCONDITIONID},{jsonData.HCORRESPONDORGID},'{jsonData.HCARRIAGENO}')"; oCN.RunProc(sql); #region [申请子表变量] var dataArr = _saveObj["Result"]["Result"]["SAL_DELIVERYNOTICEENTRY"]; DataSet Cs; double RelationQty = 0; #endregion int i = 0; // 获取子表数据 Cs = oCN.RunProcReturn("select * from Xs_SeOutStockBillSub where HInterID = " + InterID, "Xs_SeOutStockBillSub"); // 删除子表对应数据 sql = $"delete from Xs_SeOutStockBillSub where HInterID = " + InterID; oCN.RunProc(sql); foreach (var oSub in dataArr) { #region [子表数据赋值] if (Cs.Tables[0].Rows.Count != 0 && ClsPub.isLong(Cs.Tables[0].Rows[0]["HInterID"].ToString()) != 0) { RelationQty = ClsPub.isDoule(Cs.Tables[0].Rows[i]["HRelationQty"].ToString()); i++; } var subData = new { HInterID = _saveObj["Result"]["Result"]["Id"], HEntryID = oSub["Id"], HMaterID = oSub["MaterialID_Id"], HUnitID = oSub["UnitID_Id"], HQty = oSub["Qty"], HPrice = oSub["Price"], HMoney = 0, HWHID = oSub["StockID_Id"], HSPID = oSub["StockLocID_Id"], HRemark = oSub["NoteEntry"], HSourceInterID = 0, HSourceEntryID = 0, HSourceBillNo = oSub["SrcBillNo"], HSourceBillType = oSub["SrcType"], HSeOrderInterID = 0, HSeOrderEntryID = oSub["SOEntryId"], HSeORderBillNo = oSub["OrderNo"], HOWNERID = oSub["OwnerID_Id"], HOWNERTYPEID = oSub["OwnerTypeID"], HSETTLEORGID = _saveObj["Result"]["Result"]["SAL_DELIVERYNOTICEFIN"][0]["SettleOrgID_Id"], HMoveStockQty = oSub["StockBaseTransQty"], HRelationQty = oSub["StockBaseJoinOutQty"], HAuxPropID = oSub["AuxpropID_Id"], HBatchNO = oSub["Lot_Text"], HMTONo = oSub["MTONO"], HERPInterID = _saveObj["Result"]["Result"]["Id"], HERPEntryID = oSub["Id"], HCUSTMATID = oSub["CustMatID_Id"], HBASEUNITID = oSub["BaseUnitID_Id"], HBFLOWID = oSub["FBFLowId_Id"], HOUTCONTROL = oSub["OutContROL"], HSTOCKUNITID = oSub["StockUnitID_Id"], HROWTYPE = oSub["RowType"], HROWID = oSub["RowId"], HPARENTROWID = oSub["ParentRowId"], HPARENTMATID = oSub["ParentMatId_Id"], HTAXCOMBINATION = oSub["TaxCombination_Id"], HPRICECOEFFICIENT = oSub["PriceCoefficient"], HSYSPRICE = oSub["SysPrice"], HLIMITDOWNPRICE = oSub["LimitDownPrice"], HPRICEUNITID = oSub["PriceUnitId_Id"], HTAXPRICE = oSub["TaxPrice"], HTAXRATE = oSub["TaxRate"], HTAXNETPRICE = oSub["TaxNetPrice"], HDISCOUNTRATE = oSub["DiscountRate"], HISFREE = oSub["IsFree"], HLOCALCURRID = _saveObj["Result"]["Result"]["SAL_DELIVERYNOTICEFIN"][0]["LocalCurrID_Id"], HSETTLECURRID = _saveObj["Result"]["Result"]["SAL_DELIVERYNOTICEFIN"][0]["SettleCurrID_Id"], HEXCHANGETYPEID = _saveObj["Result"]["Result"]["SAL_DELIVERYNOTICEFIN"][0]["ExchangeTypeID_Id"], HSETTLETYPEID = _saveObj["Result"]["Result"]["SAL_DELIVERYNOTICEFIN"][0]["SettleTypeID_Id"], HRECEIPTCONDITIONID = 0, HEXCHANGERATE = _saveObj["Result"]["Result"]["SAL_DELIVERYNOTICEFIN"][0]["ExchangeRate"], HISINCLUDEDTAX = _saveObj["Result"]["Result"]["SAL_DELIVERYNOTICEFIN"][0]["IsIncludedTax"], HISPRICEEXCLUDETAX = _saveObj["Result"]["Result"]["SAL_DELIVERYNOTICEFIN"][0]["IsPriceExcludeTax"], HTAXRATEID = 0, HTaxRate_TAX = oSub["TaxRate"], HCOSTPERCENT = 0, HVAT = 0, HSELLERWITHHOLDING = 0, HBUYERWITHHOLDING = 0 }; #endregion //插入子表 sql = $@" insert into Xs_SeOutStockBillSub (HInterID,HEntryID,HMaterID,HUnitID,HQty ,HPrice,HMoney,HWHID,HSPID,HRemark ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HSeOrderInterID,HSeOrderEntryID,HSeORderBillNo ,HOWNERID,HOWNERTYPEID,HSETTLEORGID,HMoveStockQty ,HRelationQty,HAuxPropID,HBatchNO,HMTONo,HERPInterID,HERPEntryID ,HCUSTMATID,HBASEUNITID,HBFLOWID,HOUTCONTROL ,HSTOCKUNITID,HROWTYPE,HROWID,HPARENTROWID,HPARENTMATID ,HTAXCOMBINATION,HPRICECOEFFICIENT,HSYSPRICE,HLIMITDOWNPRICE ,HPRICEUNITID,HTAXPRICE,HTAXRATE,HTAXNETPRICE,HDISCOUNTRATE,HISFREE ,HLOCALCURRID,HSETTLECURRID,HEXCHANGETYPEID,HSETTLETYPEID,HRECEIPTCONDITIONID ,HEXCHANGERATE,HISINCLUDEDTAX,HISPRICEEXCLUDETAX ,HTAXRATEID,HTaxRate_TAX,HCOSTPERCENT,HVAT,HSELLERWITHHOLDING,HBUYERWITHHOLDING ) values ({subData.HInterID},{subData.HEntryID},{subData.HMaterID},{subData.HUnitID},{subData.HQty},{subData.HPrice}, {subData.HMoney},{subData.HWHID},{subData.HSPID},'{subData.HRemark}',{subData.HSourceInterID},{subData.HSourceEntryID}, '{subData.HSourceBillNo}','{subData.HSourceBillType}',{subData.HSeOrderInterID},{subData.HSeOrderEntryID}, '{subData.HSeORderBillNo}',{subData.HOWNERID},'{subData.HOWNERTYPEID}',{subData.HSETTLEORGID},{subData.HMoveStockQty}, {subData.HRelationQty},{subData.HAuxPropID},'{subData.HBatchNO}','{subData.HMTONo}',{subData.HERPInterID},{subData.HERPEntryID}, '{subData.HCUSTMATID}',{subData.HBASEUNITID},'{subData.HBFLOWID}','{subData.HOUTCONTROL}',{subData.HSTOCKUNITID},'{subData.HROWTYPE}', '{subData.HROWID}','{subData.HPARENTROWID}','{subData.HPARENTMATID}',{subData.HTAXCOMBINATION},{subData.HPRICECOEFFICIENT}, '{subData.HSYSPRICE}',{subData.HLIMITDOWNPRICE},{subData.HPRICEUNITID},{subData.HTAXPRICE},'{subData.HTAXRATE}', '{subData.HTAXNETPRICE}',{subData.HDISCOUNTRATE},'{subData.HISFREE}','{subData.HLOCALCURRID}','{subData.HSETTLECURRID}', '{subData.HEXCHANGETYPEID}','{subData.HSETTLETYPEID}','{subData.HRECEIPTCONDITIONID}',{subData.HEXCHANGERATE},'{subData.HISINCLUDEDTAX}', '{subData.HISPRICEEXCLUDETAX}',{subData.HTAXRATEID},{subData.HTaxRate_TAX},'{subData.HCOSTPERCENT}','{subData.HVAT}', {subData.HSELLERWITHHOLDING},{subData.HBUYERWITHHOLDING})"; oCN.RunProc(sql); } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "单据同步成功！"; objJsonResult.data = null; return objJsonResult; #endregion } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "单据读取失败！"; objJsonResult.data = null; return objJsonResult; } } #endregion } }
