本文整理匯總了C#中SoMeTech.DataAccess.DB_OPT.SqlSelectProcPar方法的典型用法代碼示例。如果您正苦於以下問題：C# DB_OPT.SqlSelectProcPar方法的具體用法？C# DB_OPT.SqlSelectProcPar怎麽用？C# DB_OPT.SqlSelectProcPar使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類SoMeTech.DataAccess.DB_OPT的用法示例。
在下文中一共展示了DB_OPT.SqlSelectProcPar方法的2個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的C#代碼示例。
示例1: GetPageSizeData
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;
}示例2: GetList
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);
}