public static int RunSP(string spName, Paras paras)
{
switch (DBAccess.AppCenterDBType)
{
case DBType.MSSQL:
SqlConnection conn = new SqlConnection(SystemConfig.AppCenterDSN);
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
return(DBProcedure.RunSP(spName, paras, conn));
break;
case DBType.Informix:
IfxConnection conn1 = new IfxConnection(SystemConfig.AppCenterDSN);
if (conn1.State != ConnectionState.Open)
{
conn1.Open();
}
return(DBProcedure.RunSP(spName, paras, conn1));
break;
default:
throw new Exception("尚未处理。");
break;
}
}
public static int RunSP(string spName, string para, string paraVal)
{
Paras paras = new Paras();
Para p = new Para(para, DbType.String, paraVal);
paras.Add(p);
return(DBProcedure.RunSP(spName, paras, DBAccessOfOracle1.GetSingleConn));
}
/// <summary>
/// 运行存储过程
/// </summary>
/// <param name="spName">名称</param>
/// <param name="paras">参数</param>
/// <returns>返回影响的行数</returns>
public static int RunSP(string spName, Paras paras)
{
return(DBProcedure.RunSP(spName, paras, DBAccessOfMSSQL2.GetSingleConn));
}
/// <summary>
/// 运行存储过程
/// </summary>
/// <param name="spName">名称</param>
/// <returns>返回影响的行数</returns>
public static int RunSP(string spName)
{
return(DBProcedure.RunSP(spName, DBAccessOfOracle1.GetSingleConn));
}
