public string ExecuteOne(string strSql) { switch (_dbType) { case DatabaseType.Sqlserver: return(SqlServerUtil.ExecuteOne(DbConnectionString, strSql)); //sunjian 2020/2/13 增加MySql的ExecuteOne方法 case DatabaseType.Mysql: return(MySqlUtil.ExecuteOne(DbConnectionString, strSql)); default: return(""); } }
public DataSet GetDataSet(CommandType cmdType, string cmdText) { switch (_dbType) { case DatabaseType.Sqlserver: return(SqlServerUtil.GetDataSet(DbConnectionString, cmdType, cmdText)); case DatabaseType.Mysql: return(MySqlUtil.GetDataSet(DbConnectionString, cmdType, cmdText)); case DatabaseType.Oracle: return(OracleUtil.GetDataSet(DbConnectionString, cmdType, cmdText)); case DatabaseType.Access: return(AccessUtil.GetDataSet(DbConnectionString, cmdText)); default: return(null); } }
public int ExecuteNonQuery(CommandType cmdType, string cmdText) { switch (_dbType) { case DatabaseType.Sqlserver: return(SqlServerUtil.ExecuteNonQuery(DbConnectionString, cmdType, cmdText)); case DatabaseType.Mysql: return(MySqlUtil.ExecuteNonQuery(DbConnectionString, cmdType, cmdText)); case DatabaseType.Oracle: return(OracleUtil.ExecuteNonQuery(DbConnectionString, cmdType, cmdText)); case DatabaseType.Access: return(AccessUtil.ExecuteNonQuery(DbConnectionString, cmdText)); default: return(-1); } }