/// <summary> /// 查询数据列表、返回 DataTable /// </summary> /// <param name="strSql">Sql语句</param> /// <param name="parameters">sql语句对应参数</param> /// <param name="jqgridparam">分页参数</param> /// <returns></returns> public DataTable FindTablePageBySql(string strSql, DbParameter[] parameters, ref JqGridParam jqgridparam) { string orderField = jqgridparam.sidx; string orderType = jqgridparam.sord; int pageIndex = jqgridparam.page; int pageSize = jqgridparam.rows; int totalRow = jqgridparam.records; DataTable dt = DataFactory.Database().FindTablePageBySql(strSql, parameters, orderField, orderType, pageIndex, pageSize, ref totalRow); jqgridparam.records = totalRow; return(dt); }
/// <summary> /// 查询数据列表、返回List /// </summary> /// <param name="strSql">Sql语句</param> /// <param name="jqgridparam">分页参数</param> /// <returns></returns> public List <T> FindListPageBySql(string strSql, ref JqGridParam jqgridparam) { string orderField = jqgridparam.sidx; string orderType = jqgridparam.sord; int pageIndex = jqgridparam.page; int pageSize = jqgridparam.rows; int totalRow = jqgridparam.records; List <T> List = DataFactory.Database().FindListPageBySql <T>(strSql, orderField, orderType, pageIndex, pageSize, ref totalRow); jqgridparam.records = totalRow; return(List); }