| | |
|---|
| | | Entity entity = this.BusinessInfo.GetEntity("FEntity");//获取明细信息 |
|---|
| | | foreach (var billObj in e.DataEntitys) |
|---|
| | | { |
|---|
| | | var sql = $"exec zymes_RealessPRDMO {billObj["Id"]} "; |
|---|
| | | //var sql = $"exec zymes_RealessPRDMO {billObj["Id"]} "; |
|---|
| | | var id = billObj["Id"].ToString(); |
|---|
| | | string sql = string.Empty; |
|---|
| | | sql = $@" |
|---|
| | | /*dialect*/ |
|---|
| | | select a.FID AS HInterID,a.FENTRYID as HENTRYID,a.FSEQ as HSEQ,a.FQTY as HQty,a.FQTY as HQTYMUST,aa.FSTOCKINQUASELAUXQTY as HRelationQty,0 as HRelationMoney,a.FPLANSTARTDATE as HPlanBeginDate,a.FPLANFINISHDATE as HPlanEndDate |
|---|
| | | ,a.FPLANSTARTDATE as HBeginDate,a.FPLANFINISHDATE as HEndDate,a.FMATERIALID as HMaterID,a.FUNITID as HUnitID,a.FSTOCKID as HWHID,isnull(a.FSTOCKLOCID,0) as HSPID,0 as HPROCID,isnull(a.FWORKSHOPID,0) as HDEPTID,0 as HBomID,a.FLOT_TEXT as HBatchNo,'CLOUD导入' as HRemark |
|---|
| | | ,a.FSRCBILLID as HSourceInterID,a.FSRCBILLENTRYID as HSourceEntryID,a.FSRCBILLNO as HSourceBillNo,a.FSRCBILLTYPE as HSourceBillType,a.FSALEORDERID as HSeOrderInterID,a.FSALEORDERENTRYID as HSeOrderEntryID,a.FSALEORDERNO as HSeOrderBillNo |
|---|
| | | ,FSTOCKINORGID as HSTOCKINORGID,FINSTOCKOWNERID as HINSTOCKOWNERID,FINSTOCKOWNERTYPEID as HINSTOCKOWNERTYPEID,FREQUESTORGID as HREQUESTORGID |
|---|
| | | ,0 as HPlanMode,a.FMTONO as HMTONo,a.FID as HERPInterID,a.FENTRYID as HERPEntryID,aa.FSTATUS as HSTATUS |
|---|
| | | ,isnull(orm.FCUSTID,0) as HEntryCusID,aa.FREPQUASELAUXQTY as HICMOReportRelationQty,a.FAUXPROPID as HAuxPropID |
|---|
| | | ,'' as HProdMaterCode,'' as HCusShortName,'' as HCusNeedMaterial,'' as HPlanSendGoodsDate |
|---|
| | | ,'' as HProdMaterName,'' as HWorkRemark,'' as HImportNote,'' as HCusName |
|---|
| | | ,0 as HInstockQty_Max,0 as HInstockQty_Min |
|---|
| | | --,a.FMX_CPCODE,a.FMX_KHNOTE,a.FMX_KHCLCF,a.FMX_CHDATE--江丰戎创金蝶自定义字段 |
|---|
| | | --,a.FMX_CPNAME,a.FMX_SCNOTE,a.FMX_ZYNOTE,a.FMX_KHNAME--江丰戎创金蝶自定义字段 |
|---|
| | | ,'' as HPickLabel,a.FSTOCKINLIMITH as HPickLabelNumber,a.FSTOCKINLIMITL as HCusNumber |
|---|
| | | from T_PRD_MOENTRY a with(nolock) |
|---|
| | | inner join T_PRD_MOENTRY_A aa with(nolock) on a.FENTRYID=aa.FENTRYID |
|---|
| | | left join T_SAL_ORDERENTRY ore with(nolock) on a.FSALEORDERID=ore.FID and a.FSALEORDERENTRYID=ore.FEntryID |
|---|
| | | left join T_SAL_ORDER orm with(nolock) on ore.FID=orm.FID |
|---|
| | | Where a.FID={id} |
|---|
| | | select a.FID HInterID ,2000 HYear,1 HPeriod,'3710' HBillType,a.FDATE HDate,a.FbillNo HBillNo,'2' HBillStatus,0 HEMPID,0 HRoutingInterID |
|---|
| | | ,1 HPlanQty,0 HRelationQty,a.FDATE HPlanBeginDate ,getdate() HPlanEndDate ,a.FDATE HBeginDate,getdate() HEndDate,0 HMaterID,0 HUnitID,0 HBomID,'' HBatchNo |
|---|
| | | ,0 HSourceInterID,0 HSourceEntryID,'' HSourceBillNo,'' HSourceBillType,0 HSeOrderInterID,0 HSeOrderEntryID,'' HSeOrderBillNo |
|---|
| | | ,FPRDORGID HPRDORGID,FENTRUSTORGID HENTRUSTORGID,FOWNERID HOWNERID,FOWNERTYPEID HOWNERTYPEID |
|---|
| | | ,0 HCusID,isnull(a.FWORKSHOPID,0) HDeptID,'CLOUD导入' HRemark,a.FCREATORID HMaker,getdate() HMakeDate,a.FAPPROVERID HChecker,a.FAPPROVEDATE HCheckDate,'' HMTONo,a.FID HERPInterID,a.FBILLTYPE HERPBillType |
|---|
| | | ,case when a.FISREWORK=1 then '返工' else '普通' end HBillSubType |
|---|
| | | from T_PRD_MO a with(nolock) |
|---|
| | | Where a.FID={id} |
|---|
| | | "; |
|---|
| | | DataSet ds = DBServiceHelper.ExecuteDataSet(Context, sql); |
|---|
| | | DataTable maindt = ds.Tables[1]; |
|---|
| | | DataTable subdt = ds.Tables[0]; |
|---|
