/// <summary>分页获取数据列表
///
/// </summary>
/// <param name="strFields">字段</param>
/// <param name="strOrder">排序</param>
/// <param name="strOrderType">排序类型</param>
/// <param name="intPageSize">每页大小</param>
/// <param name="intPageIndex">当前第N页</param>
/// <param name="strWhere">条件</param>
/// <returns>返回符合条件的DataSet数据集</returns>
public DataSet GetList(string strFields, string strOrder, string strOrderType, int intPageSize, int intPageIndex, string strWhere)
{
DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelperDemo();
h.CreateStoredCommand("[proc_SplitPage]");
h.AddParameter("@tblName", "Sys_Roles");
h.AddParameter("@strFields", strFields);
h.AddParameter("@strOrder", strOrder);
h.AddParameter("@strOrderType", strOrderType);
h.AddParameter("@PageSize", intPageSize);
h.AddParameter("@PageIndex", intPageIndex);
h.AddParameter("@strWhere", strWhere);
DataTable dt = h.ExecuteQuery();
DataSet ds = new DataSet();
ds.Tables.Add(dt);
return(ds);
}
/// <summary>分页获取数据列表
///
/// </summary>
/// <param name="strFields">字段</param>
/// <param name="strOrder">排序</param>
/// <param name="strOrderType">排序类型</param>
/// <param name="intPageSize">每页大小</param>
/// <param name="intPageIndex">当前第N页</param>
/// <param name="strWhere">条件</param>
/// <returns>返回符合条件的对象集合</returns>
public List <Nikita.Assist.CodeMaker.Model.Sys_Roles> GetListArray(string strFields, string strOrder, string strOrderType, int intPageSize, int intPageIndex, string strWhere)
{
DataAccess4DBHelper.IDbHelper h = GlobalHelpDemoForm.GetDataAccessHelperDemo();
h.CreateStoredCommand("[proc_SplitPage]");
h.AddParameter("@tblName", "Sys_Roles");
h.AddParameter("@strFields", strFields);
h.AddParameter("@strOrder", strOrder);
h.AddParameter("@strOrderType", strOrderType);
h.AddParameter("@PageSize", intPageSize);
h.AddParameter("@PageIndex", intPageIndex);
h.AddParameter("@strWhere", strWhere);
List <Nikita.Assist.CodeMaker.Model.Sys_Roles> list = new List <Nikita.Assist.CodeMaker.Model.Sys_Roles>();
using (IDataReader dataReader = h.ExecuteReader())
{
while (dataReader.Read())
{
list.Add(ReaderBind(dataReader));
}
h.CloseConn();
}
return(list);
}