| | |
|---|
| | | string sql =string.Empty; |
|---|
| | | sql = $@" |
|---|
| | | /*dialect*/ |
|---|
| | | select a.FENTRYID as HItemID,a.FNUMBER as HNumber,l.FNAME as HName,'' as HHelpCode,a.FNUMBER as HShortNumber,0 as HParentID |
|---|
| | | select a.FENTRYID as HItemID,st.FNUMBER as HNumber,l.FNAME as HName,'' as HHelpCode,st.FNUMBER as HShortNumber,0 as HParentID |
|---|
| | | ,1 as HLevel,'true' as HEndFlag,'false' as HStopflag,'CLD-ERP导入' as HRemark,'' as HUseFlag,0 as HUSEORGID |
|---|
| | | ,a.FOPERATORID as HOperatorId,a.FOPERATORTYPE as HOperatorType,a.FSEQ as HSEQ,a.FSTAFFID as HStaffId,a.FISUSE as HIsUse |
|---|
| | | from T_BD_OPERATORENTRY a with(nolock) |
|---|
| | | inner join T_BD_OPERATORENTRY_L l with(nolock) on a.FENTRYID=l.FENTRYID and FLOCALEID=2052 |
|---|
| | | left join T_BD_STAFF st on a.FSTAFFID = st.FSTAFFID |
|---|
| | | Where a.FOPERATORID={id} |
|---|
| | | "; |
|---|
| | | DataTable dt = DBServiceHelper.ExecuteDataSet(Context, sql).Tables[0]; |
|---|
