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); }