| | |
| | | /// <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); |