simoer_jiekou.git

			@@ -53,11 +53,12 @@
			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];