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)); }
public static int RunSPReturnInt(string spName, OracleConnection conn) { object obj = DBProcedure.RunSPReturnObj(spName, conn); if (obj == null || obj == DBNull.Value) { throw new Exception("@SpName 错误:" + spName + ",返回 null 值。"); } return(int.Parse(obj.ToString())); }
/// <summary> /// 运行存储过程返回Table /// </summary> /// <param name="spName">存储过程名称</param> /// <param name="paras">参说集合</param> /// <returns>执行后的Table</returns> public static DataTable RunSPReturnDataTable(string spName, Paras paras) { if (DBAccess.AppCenterDBType == DBType.MSSQL) { return(DBProcedure.RunSPReturnDataTable(spName, paras, (SqlConnection)DBAccess.GetAppCenterDBConn)); } else { return(DBProcedure.RunSPReturnDataTable(spName, paras, (SqlConnection)DBAccess.GetAppCenterDBConn)); } }
/// <summary> /// 运行存储过程 /// </summary> /// <param name="spName">名称</param> /// <param name="paras">参数</param> /// <returns>DataTable</returns> public static DataTable RunSPReTable(string spName, Paras paras) { return(DBProcedure.RunSPReturnDataTable(spName, paras, DBAccessOfMSSQL2.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)); }
public static DataTable RunSPReturnDataTable(string spName, OracleConnection conn) { Paras ens = new Paras(); return(DBProcedure.RunSPReturnDataTable(spName, ens, conn)); }
public static decimal RunSPReturnDecimal(string spName, OracleConnection conn) { return(decimal.Parse(DBProcedure.RunSPReturnDecimal(spName, conn).ToString())); }
public static float RunSPReturnFloat(string spName, OracleConnection conn) { return(float.Parse(DBProcedure.RunSPReturnFloat(spName, conn).ToString())); }
/// <summary> /// 运行存储过程 /// </summary> /// <param name="spName">名称</param> /// <returns>DataTable</returns> public static DataTable RunSPReTable(string spName) { return(DBProcedure.RunSPReturnDataTable(spName, DBAccessOfOracle1.GetSingleConn)); }
/// <summary> /// 运行存储过程 /// </summary> /// <param name="spName">名称</param> /// <returns>返回影响的行数</returns> public static int RunSP(string spName) { return(DBProcedure.RunSP(spName, DBAccessOfOracle1.GetSingleConn)); }