/// <summary>
/// 返回一个有参MySQLDriverCS.MySQLDataReader（注意要关闭）
/// </summary>
/// <param name="sql">语句</param>
/// <param name="values">参数</param>
/// <returns>MySQLDriverCS.MySQLDataReader</returns>
public static MySQLDriverCS.MySQLDataReader GetReader(string sql, params MySQLDriverCS.MySQLParameter[] values)
{
MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand(sql, Connection);
cmd.Parameters.AddRange(values);
MySQLDriverCS.MySQLDataReader reader = cmd.ExecuteReaderEx();
return(reader);
}
/// <summary>
/// 执行一个(无参)增删改语句
/// </summary>
/// <param name="safeSql">语句</param>
/// <returns>影响行数</returns>
public static int ExecuteCommand(string safeSql)
{
MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand(safeSql, Connection);
int result = cmd.ExecuteNonQuery();
return(result);
}
/// <summary>
/// 执行多条SQL语句，实现数据库事务。
/// </summary>
/// <param name="SQLStringList">多条SQL语句</param>
public static void ExecuteSqlTran(ArrayList SQLStringList)
{
MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand();
cmd.Connection = Connection;
MySQLDriverCS.MySQLTransaction tx = (MySQLDriverCS.MySQLTransaction)Connection.BeginTransaction();
cmd.Transaction = tx;
try
{
for (int n = 0; n < SQLStringList.Count; n++)
{
string strsql = SQLStringList[n].ToString();
if (strsql.Trim().Length > 1)
{
cmd.CommandText = strsql;
cmd.ExecuteNonQuery();
}
}
tx.Commit();
}
catch (System.Data.SqlClient.SqlException E)
{
tx.Rollback();
throw new Exception(E.Message);
}
}
/// <summary>
/// 执行一个无参增删改存储过程
/// </summary>
/// <param name="procName">存储过程名字</param>
/// <returns>影响行数</returns>
public static int ExecuteProc(string procName)
{
MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand();
cmd.Connection = Connection;
cmd.CommandText = procName;
cmd.CommandType = CommandType.StoredProcedure;
return(cmd.ExecuteNonQuery());
}
/// <summary>
/// 执行一个查询无参存储过程，要关闭
/// </summary>
/// <param name="procName">存储过程名字</param>
/// <returns>MySQLDriverCS.MySQLDataReader</returns>
public static MySQLDriverCS.MySQLDataReader ExecuteProcSelect(string procName)
{
MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand();
cmd.Connection = Connection;
cmd.CommandText = procName;
cmd.CommandType = CommandType.StoredProcedure;
return(cmd.ExecuteReaderEx());
}
/// <summary>
/// 执行一个带参查询存储过程,注意要关闭
/// </summary>
/// <param name="procName">存储过程名字</param>
/// <param name="values">参数列表</param>
/// <returns>MySQLDriverCS.MySQLDataReader</returns>
public static MySQLDriverCS.MySQLDataReader ExecuteProcSelect(string procName, params MySQLDriverCS.MySQLParameter[] values)
{
MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand();
cmd.Connection = Connection;
cmd.CommandText = procName;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddRange(values);
return(cmd.ExecuteReaderEx());
}
/// <summary>
/// 返回一个Datatable（有参）
/// </summary>
/// <param name="sql">语句</param>
/// <param name="values">参数</param>
/// <returns>DataTable</returns>
public static DataTable GetDataSet(string sql, params MySQLDriverCS.MySQLParameter[] values)
{
DataSet ds = new DataSet();
MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand(sql, Connection);
cmd.Parameters.AddRange(values);
MySQLDriverCS.MySQLDataAdapter da = new MySQLDriverCS.MySQLDataAdapter(cmd);
da.Fill(ds);
return(ds.Tables[0]);
}
/// <summary>
/// 返回一个Datatable（无参）
/// </summary>
/// <param name="safeSql">语句</param>
/// <returns>DataTable</returns>
public static DataTable GetDataSet(string safeSql)
{
DataSet ds = new DataSet();
MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand("set names gbk", Connection);
cmd.ExecuteNonQuery();
cmd = new MySQLDriverCS.MySQLCommand(safeSql, Connection);
MySQLDriverCS.MySQLDataAdapter da = new MySQLDriverCS.MySQLDataAdapter(cmd);
da.Fill(ds);
return(ds.Tables[0]);
}
/// <summary>
/// 返回string
/// </summary>
/// <param name="sql"></param>
/// <param name="values"></param>
/// <returns></returns>
public static string GetScalarString(string sql, params MySQLDriverCS.MySQLParameter[] values)
{
MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand(sql, Connection);
cmd.Parameters.AddRange(values);
return(Convert.ToString(cmd.ExecuteScalar()));
}
/// <summary>
/// 返回一个MySQLDriverCS.MySQLDataReader（注意要关闭）
/// </summary>
/// <param name="safeSql">语句</param>
/// <returns>MySQLDriverCS.MySQLDataReader</returns>
public static MySQLDriverCS.MySQLDataReader GetReader(string safeSql)
{
MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand(safeSql, Connection);
MySQLDriverCS.MySQLDataReader reader = cmd.ExecuteReaderEx();
return(reader);
}
/// <summary>
/// 查询第一行第一列数据（有参）（返回的是什么类型就转换成什么类型）
/// </summary>
/// <param name="values">参数</param>
/// <returns>object</returns>
public static object GetScalar(string safeSql, params MySQLDriverCS.MySQLParameter[] values)
{
MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand(safeSql, Connection);
cmd.Parameters.AddRange(values);
return(cmd.ExecuteScalar());
}
/// <summary>
/// 查询第一行第一列数据（无参）（返回的是什么类型就转换成什么类型）
/// </summary>
/// <param name="safeSql">语句</param>
/// <returns>object</returns>
public static object GetScalar(string safeSql)
{
MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand(safeSql, Connection);
return(cmd.ExecuteScalar());
}
/// <summary>
/// 执行一个有参增删改操作
/// </summary>
/// <param name="sql">语句</param>
/// <param name="values">参数</param>
/// <returns>影响行数 </returns>
public static int ExecuteCommand(string sql, params MySQLDriverCS.MySQLParameter[] values)
{
MySQLDriverCS.MySQLCommand cmd = new MySQLDriverCS.MySQLCommand(sql, Connection);
cmd.Parameters.AddRange(values);
return(cmd.ExecuteNonQuery());
}