| | |
|---|
| | | { |
|---|
| | | StringBuilder stringBuilder = new StringBuilder(); |
|---|
| | | stringBuilder.Append(" FROM ( "); |
|---|
| | | stringBuilder.Append("SELECT GWO.*, GWC.CLIENT_NAME, GWC.COMPANY "); |
|---|
| | | stringBuilder.Append("SELECT GWO.*, GWC.CLIENT_NAME, GWC.COMPANY, GWOA.AUDITOR "); |
|---|
| | | stringBuilder.Append(" FROM GW_ORDER GWO "); |
|---|
| | | stringBuilder.Append(" LEFT JOIN (select ORDER_ID, wm_concat(SU.USER_NAME) AUDITOR from (select ORDER_ID, AUDITOR FROM GW_ORDER_AUDIT order by ORDER_ID, AUDIT_SORT) GOA LEFT JOIN SYS_USER SU ON SU.ACCOUNT = GOA.AUDITOR group by ORDER_ID ) GWOA ON GWOA.ORDER_ID = GWO.ORDER_ID "); |
|---|
| | | stringBuilder.Append(" LEFT JOIN GW_SP GWS ON GWS.SP_ID = GWO.SP_ID "); |
|---|
| | | stringBuilder.Append(" LEFT JOIN GW_CLIENT GWC ON GWC.CLIENT_ID = GWO.CLIENT_ID "); |
|---|
| | | stringBuilder.Append(" WHERE 1=1 "); |
|---|
| | |
|---|
| | | o.BeforeBalanceNum = oracleReaderWrapper.GetInt("BEFORE_BALANCE_NUM", 0); |
|---|
| | | o.Creator = oracleReaderWrapper.GetString("CREATOR", ""); |
|---|
| | | o.CreateTime = oracleReaderWrapper.GetDateTime("CREATE_TIME"); |
|---|
| | | //o.Auditor = oracleReaderWrapper.GetString("AUDITOR", ""); |
|---|
| | | o.Auditor = oracleReaderWrapper.GetString("AUDITOR", ""); //各级审核人 |
|---|
| | | //o.AuditTime = oracleReaderWrapper.GetDateTime("AUDIT_TIME"); |
|---|
| | | o.Status = oracleReaderWrapper.GetInt("STATUS", 0); |
|---|
| | | o.Remark = oracleReaderWrapper.GetString("REMARK", ""); |
|---|
