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