客户端回调实现gridView无刷新分页

// 创建连接
OracleConnection myConnection = new OracleConnection(DatabaseConnectionString);

try
...{
// 打开连接
myConnection.Open();
}
catch (Exception ex)
...{
throw (ex);
}

try
...{
// 创建存储过程
OracleCommand myCommand = new OracleCommand("H_QUERYPACK.QUERYLOG", myConnection);
myCommand.CommandType = CommandType.StoredProcedure;
OracleDataReader dr;

// ============================== 参数定义 ==============================

// 返回值
myCommand.Parameters.Add("RET_CURSOR", OracleType.Cursor);
myCommand.Parameters["RET_CURSOR"].Direction = ParameterDirection.Output;
OracleParameter ret = myCommand.Parameters.Add("ERRORCODE", OracleType.Int32);
ret.Direction = ParameterDirection.Output;

OracleParameter retCountSum = myCommand.Parameters.AddWithValue("p_RecordCount", OracleType.Int32);
retCountSum.Direction = ParameterDirection.Output;

// 编号
myCommand.Parameters.AddWithValue("p_logID", OracleType.Int32).Value = 0;

// 用户编号
myCommand.Parameters.AddWithValue("p_Operator", OracleType.VarChar).Value = strOperator;

// 时间下限
myCommand.Parameters.AddWithValue("p_StartTime", OracleType.DateTime).Value = dtStartTime;

// 时间上限
myCommand.Parameters.AddWithValue("p_EndTime", OracleType.DateTime).Value =dtEndTime;

// 排序字段
myCommand.Parameters.AddWithValue("p_OrderField", OracleType.VarChar).Value = strOrderField;

// 怎么排序
myCommand.Parameters.AddWithValue("p_Desc", OracleType.Int32).Value = intASC;

// 每页行数
myCommand.Parameters.AddWithValue("p_PageSize", OracleType.Int32).Value = rowCount;

//页码
myCommand.Parameters.AddWithValue("p_PageIndex", OracleType.Int32).Value = PageIndex;

// ============================ 参数定义完毕 ============================

// 执行存储过程
dr = myCommand.ExecuteReader();

// 执行未成功
if (Convert.ToInt32(ret.Value) != 0)
throw new Exception("执行存储过程出错!");

// 总记录数
recordSum = Convert.ToInt32(retCountSum.Value);

while (dr.Read())
...{
// 创建新日志
Log log = new Log();

//操作业务类型
if (dr["operationtype"] != DBNull.Value)
...{
log.OperationType = Convert.ToString(dr["operationtype"]);
}
// 时间
if (dr["time"] != DBNull.Value)
log.Time = Convert.ToDateTime(dr["time"]);

// 用户
if (dr["operator"] != DBNull.Value)
...{
log.Operator = Convert.ToString(dr["operator"]);
}

// 信息
if (dr["info"] != DBNull.Value)
log.Info = Convert.ToString(dr["info"]);

// 加入返回集合
myArrayList.Add(log);
}

dr.Close();
return myArrayList;
}
catch (Exception ex)
...{
throw (ex);
}
finally
...{
myConnection.Close();
}
}
}

DataLogic.cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;

/**//// <summary>
/// 业务逻辑层 author: EvoRul date:2007-03-29
/// </summary>
public class DataLogic
...{
public DataLogic()
...{
}

public static int recordSum = 0;

/**//// <summary>
/// 查询日志
/// </summary>
/// <param name="strOperator">操作人</param>
/// <param name="dtStarTime">时间范围下限</param>
/// <param name="dtEndTime">时间上限</param>
/// <param name="Pageid">页码</param>
/// <returns></returns>
public static IEnumerable GetLogData(string strOperator,DateTime dtStarTime,DateTime dtEndTime, string Pageid)
...{
return Log.GetList(strOperator,dtStarTime,dtEndTime,"time",1, Convert.ToInt32(Pageid),DataAccess.RowsPerPage,out recordSum);
}
}

Log.cs

using System;
using System.Data;
using System.Collections;

/**//// <summary>

文章整理：西部数码--专业提供域名注册、虚拟主机服务
http://www.west263.com
以上信息与文章正文是不可分割的一部分,如果您要转载本文章,请保留以上信息，谢谢!