| | |
|---|
| | | Entity entity = this.BusinessInfo.GetEntity("FEntity");//获取明细信息 |
|---|
| | | foreach (var billObj in e.DataEntitys) |
|---|
| | | { |
|---|
| | | var forgName = Context.CurrentOrganizationInfo.Name; |
|---|
| | | |
|---|
| | | |
|---|
| | | var id = billObj["Id"].ToString(); |
|---|
| | | |
|---|
| | |
|---|
| | | 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={ids} |
|---|
| | | select a.FID HInterID ,2000 HYear,1 HPeriod,'3710' HBillType,a.FDATE HDate,a.FbillNo HBillNo,'2' HBillStatus,0 HEMPID,0 HRoutingInterID |
|---|
| | | select a.FID HInterID ,YEAR(a.FCREATEDate) AS HYear,MONTH(a.FCREATEDate) AS 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 |
|---|
