| | |
| | | { |
| | | string str = sDate.Replace("-", ""); |
| | | StringBuilder stringBuilder = new StringBuilder(); |
| | | stringBuilder.Append("select AP_MID,CLIENT_ID,a.SP_ID,AP_ID,a.OP_ID,a.ACCESS_CODE,MOBILE,PK_NUMBER,AP_FEE_COUNT,OP_FEE_COUNT,TPUDHI,a.PRIORITY,RD_FLAG,a.MSG_FORMAT,MSG_LENGTH,AP_RESULT,OP_MID,OP_RESULT,AP_SUBMIT_TIME,OP_SUBMIT_TIME,OP_DELIVER_TIME,MSG_CONTENT,STAT,b.op_name from LG_SM_").Append(str).Append(" a left join gw_op b on a.op_id=b.op_id where 1=1 "); |
| | | stringBuilder.Append("select AP_MID,CLIENT_ID,a.SP_ID,AP_ID,b.OP_NAME,a.ACCESS_CODE,MOBILE,PK_NUMBER,PK_TOTAL,AP_FEE_COUNT,OP_FEE_COUNT,TPUDHI,a.PRIORITY,RD_FLAG,a.MSG_FORMAT,MSG_LENGTH,AP_RESULT,OP_MID,OP_RESULT,AP_SUBMIT_TIME,OP_SUBMIT_TIME,OP_DELIVER_TIME,MSG_CONTENT,STAT,ROUND(TO_NUMBER(a.op_deliver_time-a.ap_submit_time)*24*60*60,0) as OUT_TIME from LG_SM_").Append(str).Append(" a left join gw_op b on a.op_id=b.op_id where 1=1 "); |
| | | OracleParameter[] oracleParameterArray = new OracleParameter[11]; |
| | | if (apID != null && apID != "") |
| | | { |
| | |
| | | /// <param name="pageSize"></param> |
| | | /// <param name="pageIndex"></param> |
| | | /// <returns></returns> |
| | | public List<GwSm> LoadInfoList(string apMID, string opName, string clientID, string spID, string destnationId, string sDate, string beginTime, string endTime, string content, string opstat, int TStatus, out int recordcount, int pageSize, int pageIndex) |
| | | public List<GwSm> LoadInfoList(string apMID, string opName, string clientID, string spID, string destnationId, string sDate, string beginTime, string endTime, string content, string opstat, int TStatus, out int recordcount, int pageSize, int pageIndex,string ReSend=null) |
| | | { |
| | | List<GwSm> list1 = new List<GwSm>(); |
| | | recordcount = 0; |
| | |
| | | { |
| | | string str = sDate.Replace("-", ""); |
| | | StringBuilder stringBuilder = new StringBuilder(); |
| | | stringBuilder.Append("from LG_SM_").Append(str).Append(" sm left join GW_OP op on sm.op_id=op.op_id where 1=1 "); |
| | | List<OracleParameter> list2 = new List<OracleParameter>(); |
| | | if (ReSend == "ReSend") |
| | | { |
| | | stringBuilder.Append("from LG_SM_").Append(str).Append(" sm left join GW_OP op on sm.op_id=op.op_id where 1=1 and ResendStatus = 1 and ResendFlag = 0 "); |
| | | } |
| | | else |
| | | { |
| | | stringBuilder.Append("from LG_SM_").Append(str).Append(" sm left join GW_OP op on sm.op_id=op.op_id where 1=1 "); |
| | | } |
| | | List<OracleParameter> list2 = new List<OracleParameter>(); |
| | | if (apMID != null && apMID != "") |
| | | { |
| | | OracleParameter oracleParameter = new OracleParameter(":ApMID", (OracleDbType)126); |