| | |
|---|
| | | //采购订单Controller |
|---|
| | | public class Cg_POOrderBillController : ApiController |
|---|
| | | { |
|---|
| | | //获取系统参数 |
|---|
| | | Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); |
|---|
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
|---|
| | | |
|---|
| | | private json objJsonResult = new json(); |
|---|
| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | #region [同步单据] |
|---|
| | | [Route("Cg_POOrderBill/Cg_POOrderBillViewApi")] |
|---|
| | | [HttpGet] |
|---|
| | | public json Cg_POOrderBillViewApi(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("PUR_PurchaseOrder", 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 Cg_POOrderBillMain where HBillNo = '" + BillNo + "'", "Cg_POOrderBillMain"); |
|---|
| | | 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 = 1102, |
|---|
| | | HBillSubType = 1102, |
|---|
| | | HDate = _saveObj["Result"]["Result"]["Date"], |
|---|
| | | HBillNo = _saveObj["Result"]["Result"]["BillNo"], |
|---|
| | | HBillStatus = _saveObj["Result"]["Result"]["ApproverId_Id"].ToString() == Convert.ToString(0) ? 1 : 2 , |
|---|
| | | HAddress = "", |
|---|
| | | HSSID = 0, |
|---|
| | | HSSDate = _saveObj["Result"]["Result"]["Date"], |
|---|
| | | HPSStyleID = 0, |
|---|
| | | HSupID = _saveObj["Result"]["Result"]["SupplierId_Id"], |
|---|
| | | HCurID = 0, |
|---|
| | | HExRate = 0, |
|---|
| | | HEmpID = _saveObj["Result"]["Result"]["PurchaserId_Id"], |
|---|
| | | HManagerID = 0, |
|---|
| | | HDeptID = _saveObj["Result"]["Result"]["PurchaseDeptId_Id"], |
|---|
| | | HExplanation = "CLOUD导入", |
|---|
| | | HRemark = "CLOUD导入", |
|---|
| | | HInnerBillNo = _saveObj["Result"]["Result"]["BillNo"], |
|---|
| | | HChecker = _saveObj["Result"]["Result"]["ApproverId"]["Name"], |
|---|
| | | HCheckDate = _saveObj["Result"]["Result"]["ApproveDate"], |
|---|
| | | HMaker = _saveObj["Result"]["Result"]["CreatorId"]["Name"], |
|---|
| | | HMakeDate = _saveObj["Result"]["Result"]["CreateDate"], |
|---|
| | | HERPInterID = _saveObj["Result"]["Result"]["Id"], |
|---|
| | | HERPBillType = _saveObj["Result"]["Result"]["BillTypeId_Id"], |
|---|
| | | HPURCHASEORGID = _saveObj["Result"]["Result"]["PurchaseOrgId_Id"], |
|---|
| | | HPURCHASERGROUPID = _saveObj["Result"]["Result"]["PurchaserGroupId_Id"], |
|---|
| | | HPROVIDERID = _saveObj["Result"]["Result"]["ProviderId_Id"], |
|---|
| | | HSETTLEID = _saveObj["Result"]["Result"]["SettleId_Id"], |
|---|
| | | HCHARGEID = _saveObj["Result"]["Result"]["ChargeId_Id"], |
|---|
| | | HBUSINESSTYPE = _saveObj["Result"]["Result"]["BusinessType"], |
|---|
| | | HPROVIDERADDRESS = _saveObj["Result"]["Result"]["ProviderAddress"], |
|---|
| | | HCORRESPONDORGID = _saveObj["Result"]["Result"]["CorrespondOrgId_Id"], |
|---|
| | | HPROVIDERCONTACTID = _saveObj["Result"]["Result"]["ProviderContactId_Id"] |
|---|
| | | }; |
|---|
| | | #endregion |
|---|
| | | // 删除主表对应数据 |
|---|
| | | sql = $"delete from Cg_POOrderBillMain where HInterID = " + InterID; |
|---|
| | | oCN.RunProc(sql); |
|---|
| | | |
|---|
| | | //插入主表 |
|---|
| | | sql = $@" |
|---|
| | | insert into Cg_POOrderBillMain |
|---|
| | | (HInterID,HYear,HPeriod,HBillType,HBillSubType,HDate |
|---|
| | | ,HBillNo,HBillStatus,HAddress,HSSID,HSSDate,HPSStyleID |
|---|
| | | ,HSupID,HCurID,HExRate,HEmpID,HManagerID,HDeptID |
|---|
| | | ,HExplanation,HRemark,HInnerBillNo |
|---|
| | | ,HChecker,HCheckDate,HMaker,HMakeDate |
|---|
| | | ,HERPInterID,HERPBillType,HPURCHASEORGID,HPURCHASERGROUPID,HPROVIDERID,HSETTLEID |
|---|
| | | ,HCHARGEID,HBUSINESSTYPE,HPROVIDERADDRESS,HCORRESPONDORGID,HPROVIDERCONTACTID |
|---|
| | | ) |
|---|
| | | values |
|---|
| | | ({jsonData.HInterID},{jsonData.HYear},{jsonData.HPeriod},{jsonData.HBillType},{jsonData.HBillSubType}, |
|---|
| | | '{jsonData.HDate}','{jsonData.HBillNo}',{jsonData.HBillStatus},'{jsonData.HAddress}',{jsonData.HSSID}, |
|---|
| | | '{jsonData.HSSDate}',{jsonData.HPSStyleID},{jsonData.HSupID},{jsonData.HCurID},{jsonData.HExRate},{jsonData.HEmpID},{jsonData.HManagerID}, |
|---|
| | | {jsonData.HDeptID},'{jsonData.HExplanation}','{jsonData.HRemark}','{jsonData.HInnerBillNo}','{jsonData.HChecker}', |
|---|
| | | '{jsonData.HCheckDate}','{jsonData.HMaker}','{jsonData.HMakeDate}',{jsonData.HERPInterID},'{jsonData.HERPBillType}', |
|---|
| | | {jsonData.HPURCHASEORGID},{jsonData.HPURCHASERGROUPID},'{jsonData.HPROVIDERID}',{jsonData.HSETTLEID},{jsonData.HCHARGEID}, |
|---|
| | | '{jsonData.HBUSINESSTYPE}','{jsonData.HPROVIDERADDRESS}',{jsonData.HCORRESPONDORGID},{jsonData.HPROVIDERCONTACTID})"; |
|---|
| | | |
|---|
| | | oCN.RunProc(sql); |
|---|
| | | |
|---|
| | | #region [申请子表变量] |
|---|
| | | var dataArr = _saveObj["Result"]["Result"]["POOrderEntry"]; |
|---|
| | | |
|---|
| | | DataSet Cs; |
|---|
| | | double RelationQty = 0; |
|---|
| | | #endregion |
|---|
| | | int i = 0; |
|---|
| | | |
|---|
| | | // 获取子表数据 |
|---|
| | | Cs = oCN.RunProcReturn("select * from Cg_POOrderBillSub where HInterID = " + InterID, "Cg_POOrderBillSub"); |
|---|
| | | // 删除子表对应数据 |
|---|
| | | sql = $"delete from Cg_POOrderBillSub 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"], |
|---|
| | | HTaxRate_TAX = oSub["TaxRate"], |
|---|
| | | HTaxMoney_TAX = oSub["TaxAmount"], |
|---|
| | | HTaxPrice = oSub["TaxPrice"], |
|---|
| | | HDiscountRate = oSub["DiscountRate"], |
|---|
| | | HRelTaxPrice = 0, |
|---|
| | | HMoney = oSub["Amount"], |
|---|
| | | HTaxRate = oSub["TaxRate"], |
|---|
| | | HTaxMoney = oSub["TaxAmount"], |
|---|
| | | HLineTotal = 0, |
|---|
| | | HlineTotalBB = 0, |
|---|
| | | HDate = oSub["DeliveryDate"], |
|---|
| | | HInStockQty = 0, |
|---|
| | | HInvoiceQty = 0, |
|---|
| | | HRemark = oSub["Note"], |
|---|
| | | HSeOrderBillNo = "", |
|---|
| | | HSeOrderInterID = 0, |
|---|
| | | HSeOrderEntryID = 0, |
|---|
| | | HSourceInterID = 0, |
|---|
| | | HSourceEntryID = 0, |
|---|
| | | HSourceBillNo = "", |
|---|
| | | HSourceBillType = "", |
|---|
| | | HRelationQty = oSub["JOINQTY"], |
|---|
| | | HBackRelationQty = oSub["STOCKRETQTY"], |
|---|
| | | HPropertyID = 0, |
|---|
| | | HBatChNo = oSub["FLot_Text"], |
|---|
| | | HAuxPropID = oSub["AuxPropId_Id"], |
|---|
| | | HMTONo = oSub["MtoNo"], |
|---|
| | | HERPInterID = _saveObj["Result"]["Result"]["Id"], |
|---|
| | | HERPEntryID = oSub["Id"], |
|---|
| | | HSEQ = oSub["Seq"], |
|---|
| | | HRECEIVEDEPTID = oSub["ReceiveDeptId_Id"], |
|---|
| | | HSUPPLIERLOT = oSub["SupplierLot"], |
|---|
| | | HBOMID = oSub["BomId_Id"], |
|---|
| | | HSTOCKUNITID = oSub["StockUnitID_Id"], |
|---|
| | | HBASEUNITID = oSub["BaseUnitId_Id"], |
|---|
| | | HBFLOWID = oSub["FBFLowId_Id"], |
|---|
| | | HGIVEAWAY = oSub["GiveAway"], |
|---|
| | | HROWTYPE = oSub["RowType"], |
|---|
| | | HBASEUNITQTY = oSub["BaseUnitQty"], |
|---|
| | | HSTOCKBASEQTY = oSub["StockBaseQty"], |
|---|
| | | HREQTRACENO = oSub["ReqTraceNo"], |
|---|
| | | HMATERIALDESC = oSub["MultiLanguageText"][0]["MaterialDesc"], |
|---|
| | | HRECEIVEORGID = oSub["ReceiveOrgId_Id"], |
|---|
| | | HREQUIREORGID = oSub["RequireOrgId_Id"], |
|---|
| | | HTAXNETPRICE = oSub["TaxNetPrice"], |
|---|
| | | HPRICECOEFFICIENT = oSub["PriceCoefficient"], |
|---|
| | | HTAXCOMBINATION = oSub["FTaxCombination_Id"], |
|---|
| | | HPRICEUNITID = oSub["PriceUnitId_Id"], |
|---|
| | | HPRICELISTENTRY = oSub["PriceListEntry_Id"], |
|---|
| | | HPAYORGID = oSub["PayOrgId_Id"], |
|---|
| | | HSETTLEMODEID = oSub["EntrySettleModeId_Id"], |
|---|
| | | HSETTLECURRID = 0, |
|---|
| | | HEXCHANGETYPEID = 0, |
|---|
| | | HPAYCONDITIONID = 0, |
|---|
| | | HEXCHANGERATE = 0, |
|---|
| | | HLOCALCURRID = 0, |
|---|
| | | HISINCLUDEDTAX = 0, |
|---|
| | | HISPRICEEXCLUDETAX = 0, |
|---|
| | | HSETTLEORGID = oSub["SettleOrgId_Id"], |
|---|
| | | HTAXRATEID = oSub["POORDERENTRY_TAX"][0]["TaxRateId_Id"], |
|---|
| | | HCOSTPERCENT = oSub["POORDERENTRY_TAX"][0]["CostPercent"], |
|---|
| | | HCOSTAMOUNT = oSub["POORDERENTRY_TAX"][0]["CostAmount"], |
|---|
| | | HVAT = oSub["POORDERENTRY_TAX"][0]["VAT"], |
|---|
| | | HSELLERWITHHOLDING = oSub["POORDERENTRY_TAX"][0]["SellerWithholding"], |
|---|
| | | HBUYERWITHHOLDING = oSub["POORDERENTRY_TAX"][0]["BuyerWithholding"], |
|---|
| | | }; |
|---|
| | | #endregion |
|---|
| | | |
|---|
| | | //插入子表 |
|---|
| | | sql = $@" |
|---|
| | | insert into Cg_POOrderBillSub |
|---|
| | | (HInterID,HEntryID,HMaterID,HUnitID,HQty,HPrice,HTaxRate_TAX,HTaxMoney_TAX |
|---|
| | | ,HTaxPrice,HDiscountRate,HRelTaxPrice,HMoney,HTaxRate,HTaxMoney |
|---|
| | | ,HLineTotal,HlineTotalBB,HDate,HInStockQty,HInvoiceQty,HRemark |
|---|
| | | ,HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType |
|---|
| | | ,HRelationQty,HBackRelationQty,HPropertyID,HBatChNo,HAuxPropID,HMTONo |
|---|
| | | ,HERPInterID,HERPEntryID,HSEQ,HRECEIVEDEPTID,HSUPPLIERLOT,HBOMID |
|---|
| | | ,HSTOCKUNITID,HBASEUNITID,HBFLOWID,HGIVEAWAY,HROWTYPE,HBASEUNITQTY |
|---|
| | | ,HSTOCKBASEQTY,HREQTRACENO,HMATERIALDESC,HRECEIVEORGID,HREQUIREORGID |
|---|
| | | ,HTAXNETPRICE,HPRICECOEFFICIENT,HTAXCOMBINATION,HPRICEUNITID,HPRICELISTENTRY,HPAYORGID |
|---|
| | | ,HSETTLEMODEID,HSETTLECURRID,HEXCHANGETYPEID,HPAYCONDITIONID,HEXCHANGERATE,HLOCALCURRID |
|---|
| | | ,HISINCLUDEDTAX,HISPRICEEXCLUDETAX,HSETTLEORGID |
|---|
| | | ,HTAXRATEID,HCOSTPERCENT,HCOSTAMOUNT,HVAT,HSELLERWITHHOLDING,HBUYERWITHHOLDING |
|---|
| | | ) |
|---|
| | | values |
|---|
| | | ({subData.HInterID},{subData.HEntryID},{subData.HMaterID},{subData.HUnitID},{subData.HQty},{subData.HPrice}, |
|---|
| | | {subData.HTaxRate_TAX},{subData.HTaxMoney_TAX},{subData.HTaxPrice},{subData.HDiscountRate},{subData.HRelTaxPrice},{subData.HMoney},{subData.HTaxRate},{subData.HTaxMoney},{subData.HLineTotal},{subData.HlineTotalBB},'{subData.HDate}',{subData.HInStockQty},{subData.HInvoiceQty},'{subData.HRemark}','{subData.HSeOrderBillNo}',{subData.HSeOrderInterID},{subData.HSeOrderEntryID},{subData.HSourceInterID},{subData.HSourceEntryID},'{subData.HSourceBillNo}','{subData.HSourceBillType}',{subData.HRelationQty},{subData.HBackRelationQty},{subData.HPropertyID},'{subData.HBatChNo}',{subData.HAuxPropID},'{subData.HMTONo}',{subData.HERPInterID},{subData.HERPEntryID},{subData.HSEQ},{subData.HRECEIVEDEPTID},'{subData.HSUPPLIERLOT}',{subData.HBOMID},{subData.HSTOCKUNITID},{subData.HBASEUNITID},'{subData.HBFLOWID}','{subData.HGIVEAWAY}','{subData.HROWTYPE}',{subData.HBASEUNITQTY},{subData.HSTOCKBASEQTY},'{subData.HREQTRACENO}','{subData.HMATERIALDESC}',{subData.HRECEIVEORGID},{subData.HREQUIREORGID},{subData.HTAXNETPRICE},'{subData.HPRICECOEFFICIENT}','{subData.HTAXCOMBINATION}',{subData.HPRICEUNITID},'{subData.HPRICELISTENTRY}',{subData.HPAYORGID},{subData.HSETTLEMODEID},{subData.HSETTLECURRID},'{subData.HEXCHANGETYPEID}',{subData.HPAYCONDITIONID},{subData.HEXCHANGERATE},{subData.HLOCALCURRID},{subData.HISINCLUDEDTAX},{subData.HISPRICEEXCLUDETAX},{subData.HSETTLEORGID},{subData.HTAXRATEID},'{subData.HCOSTPERCENT}',{subData.HCOSTAMOUNT},'{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 |
|---|
| | | |
|---|
| | | } |
|---|
| | | |
|---|
| | | } |
|---|
