| | |
|---|
| | | ,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,0 HMoneyDec,a.F_XG HMinPOQty |
|---|
| | | ,isnull(a.FMASTERID,0) as HMASTERID,0 HMoneyDec |
|---|
| | | -----------小卫自定义字段 |
|---|
| | | ,a.F_XG HMinPOQty,a.F_XLBH_Text_QTR HMaterColor,F_XLBH_Text_83g HMidBoxSize,F_XLBH_TEXT_QTR1 HVolume |
|---|
| | | -------------- |
|---|
| | | 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 |
|---|
| | |
|---|
| | | left join T_ORG_Organizations o with(nolock) on a.FUseOrgId=o.FORGID |
|---|
| | | Where l.FLOCALEID=2052 |
|---|
| | | and a.FMATERIALID = {id} |
|---|
| | | |
|---|
| | | "; |
|---|
| | | DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0]; |
|---|
| | | if (dt.Rows.Count == 0) |
|---|
