public static DataSet GetPageSizeData(string strlist, string strtablename, string strwhere, string strorderid, string strorder, int strno, int pagesize, out string ii)
{
DB_OPT db_opt = new DB_OPT();
object parameters = GetPara(strlist, strtablename, strwhere, strorderid, strorder, strno, pagesize);
DataSet set = db_opt.SqlSelectProcPar("GETDATASETBYNUM.GetListByNum", parameters);
if (DB_OPT.DBT == DataBaseType.SqlServer)
{
ii = ((SqlParameter[])parameters)[7].Value.ToString();
return set;
}
ii = ((OracleParameter[])parameters)[7].Value.ToString();
return set;
}
public override DataSet GetList(int PageSize, int PageIndex, string strWhere, DB_OPT dbo)
{
if (DB_OPT.DBT == DataBaseType.SqlServer)
{
SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@tblName", SqlDbType.NVarChar, 0xff), new SqlParameter("@fldName", SqlDbType.NVarChar, 0xff), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@IsReCount", SqlDbType.Int), new SqlParameter("@OrderType", SqlDbType.Int), new SqlParameter("@strWhere", SqlDbType.NVarChar, 0x3e8) };
parameterArray[0].Value = "Users";
parameterArray[1].Value = "UserPK";
parameterArray[2].Value = PageSize;
parameterArray[3].Value = PageIndex;
parameterArray[4].Value = 0;
parameterArray[5].Value = 0;
parameterArray[6].Value = strWhere;
return dbo.SqlSelectProcPar("UP_GetRecordByPage", parameterArray);
}
OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":tblName", OracleType.VarChar, 0xff), new OracleParameter(":fldName", OracleType.VarChar, 0xff), new OracleParameter(":PageSize", OracleType.Int32), new OracleParameter(":PageIndex", OracleType.Int32), new OracleParameter(":IsReCount", OracleType.Int32), new OracleParameter(":OrderType", OracleType.Int32), new OracleParameter(":strWhere", OracleType.VarChar, 0x3e8) };
parameters[0].Value = "Users";
parameters[1].Value = "UserPK";
parameters[2].Value = PageSize;
parameters[3].Value = PageIndex;
parameters[4].Value = 0;
parameters[5].Value = 0;
parameters[6].Value = strWhere;
return dbo.SqlSelectProcPar("UP_GetRecordByPage", parameters);
}