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