| | |
| | | ,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 |
| | | ,o.FNUMBER as HOrganNumber |
| | | ,o.FNUMBER as HOrganNumber,a.FComboXSLX HComboXSLX |
| | | from T_PRD_MO a with(nolock) |
| | | left join T_ORG_Organizations o with(nolock) on a.FPRDORGID=o.FORGID |
| | | Where a.FID={ids} |
| | |
| | | ,case when isnull(ap.FISENABLE,0)='1' then 1 else 0 end as HAuxPropFlag,isnull(s.FAUXUNITID,0) as HAuxUnitID,isnull(s.FSNUNIT,0) as HSNUnitID |
| | | ,case when isnull(s.FISKFPERIOD,0)='1' then 1 else 0 end as HISKFPERIOD |
| | | ,b.FERPCLSID as HMaterTypeID,o.FNUMBER as HOrganNumber |
| | | ,case when isnull(q.FCHECKINCOMING,0)='1' then 1 else 0 end as HCHECKINCOMING,isnull(s.FEXPUNIT,'') as HEXPUNIT,isnull(s.FEXPPERIOD,0) as HEXPPERIOD |
| | | ,isnull(b.FBASEUNITID,0) as HBASEUNITID,isnull(ms.FSALEUNITID,0) as HSALEUNITID,isnull(ms.FSALEPRICEUNITID,0) HSALEPRICEUNITID |
| | | ,isnull(mp.FPERUNITSTANDHOUR,0) as HPERUNITSTANDHOUR,isnull(mp.FSTDLABORPREPARETIME,0) as HSTDLABORPREPARETIME,isnull(mp.FSTDMACHINEPREPARETIME,0) as HSTDMACHINEPREPARETIME |
| | | ,isnull(a.FMASTERID,0) as HMASTERID |
| | | from T_BD_MATERIAL a with(nolock) |
| | | inner join T_BD_MATERIAL_L l with(nolock) on a.FMATERIALID=l.FMATERIALID |
| | | inner join T_BD_MATERIALBASE b with(nolock) on a.FMATERIALID=b.FMATERIALID |
| | |
| | | inner join T_BD_MATERIALPLAN p with(nolock) on a.FMATERIALID=p.FMATERIALID |
| | | left join (select max(FISENABLE) FISENABLE,FMATERIALID from T_BD_MATERIALAUXPTY with(nolock) |
| | | group by FISENABLE,FMATERIALID) ap on a.FMATERIALID=ap.FMATERIALID |
| | | left join T_BD_MATERIALQUALITY q with(nolock) on a.FMATERIALID=q.FMATERIALID |
| | | left join t_BD_MaterialSale ms with(nolock) on a.FMATERIALID=ms.FMATERIALID |
| | | left join t_BD_MaterialProduce mp with(nolock) on a.FMATERIALID=mp.FMATERIALID |
| | | left join T_ORG_Organizations o with(nolock) on a.FUseOrgId=o.FORGID |
| | | Where l.FLOCALEID=2052 |
| | | and a.FMATERIALID = {id} |
| | |
| | | ,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,o.FNUMBER as HOrganNumber |
| | | ,a.FComboXSLX HComboXSLX |
| | | from T_PRD_MO a with(nolock) |
| | | left join T_ORG_Organizations o with(nolock) on a.FPRDORGID=o.FORGID |
| | | Where a.FID={id} |
| | |
| | | ["model"] = model |
| | | }; |
| | | //string clientUrl = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "ClientUrl");//K/3 Cloud 业务站点地址 |
| | | //var client = new RestSharp.RestClient("http://47.96.97.237/api/"); |
| | | var client = new RestSharp.RestClient(http); |
| | | //新增 |
| | | var requestPost = new RestRequest("Sc_ICMOBill/ICMOBillSaveApi", Method.POST); |