| | |
|---|
| | | //区域暂时没有写入数据库 |
|---|
| | | using Common; |
|---|
| | | using Model; |
|---|
| | | using Oracle.DataAccess.Client; |
|---|
| | | using Oracle.ManagedDataAccess.Client; |
|---|
| | | using System; |
|---|
| | | using System.Collections.Generic; |
|---|
| | | using System.Data; |
|---|
| | |
|---|
| | | { |
|---|
| | | 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,string ReSend=null) |
|---|
| | | 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, string permissionsSQL, out int recordcount, int pageSize, int pageIndex,string ReSend=null) |
|---|
| | | { |
|---|
| | | List<GwSm> list1 = new List<GwSm>(); |
|---|
| | | recordcount = 0; |
|---|
| | |
|---|
| | | list2.Add(oracleParameter2); |
|---|
| | | ((DbParameter)oracleParameter2).Value = (object)DateTime.Parse(sDate + " " + endTime); |
|---|
| | | stringBuilder.Append(" and sm.AP_SUBMIT_TIME BETWEEN :BEGIN_TIME AND :END_TIME"); |
|---|
| | | |
|---|
| | | //客户权限SQL脚本 |
|---|
| | | stringBuilder.Append(permissionsSQL); |
|---|
| | | |
|---|
| | | using (OracleDataReader reader = OracleHelper.ExecuteReader("select count(*) as count " + stringBuilder.ToString(), OracleHelper.Connection, list2.ToArray())) |
|---|
| | | { |
|---|
| | | if (((DbDataReader)reader).Read()) |
|---|
