/// <summary>
/// 执行语句
/// 例如：insert into Person(id,name) values(@ID,@Name)
/// valuePairs["ID"]=1;valuePairs["Name"]="jason";
/// </summary>
/// <param name="source"></param>
/// <param name="Sql"></param>
/// <param name="valuePairs"></param>
/// <returns></returns>
public static int ExecuteUpdate(this HikariDataSource source, string Sql, Dictionary <string, object> valuePairs = null)
{
using (var con = source.GetConnection())
{
var cmd = con.CreateCommand();
cmd.CommandText = Sql;
if (valuePairs != null)
{
foreach (var kv in valuePairs)
{
var p = cmd.CreateParameter();
p.ParameterName = "@" + kv.Key;
p.Value = kv.Value;
cmd.Parameters.Add(p);
}
}
return(cmd.ExecuteNonQuery());
}
}
/// <summary>
/// 查询数据
/// 例如：select * from Person where id=@ID
/// valuePairs["ID"]=1;
/// </summary>
/// <param name="source"></param>
/// <param name="querySql"></param>
/// <param name="valuePairs"></param>
/// <returns></returns>
public static IDataReader ExecuteQueryReader(this HikariDataSource source, string querySql, Dictionary <string, object> valuePairs = null)
{
var con = source.GetConnection();
var cmd = con.CreateCommand();
cmd.CommandText = querySql;
// cmd.Connection = con;
if (valuePairs != null)
{
foreach (var kv in valuePairs)
{
var p = cmd.CreateParameter();
p.ParameterName = "@" + kv.Key;
p.Value = kv.Value;
cmd.Parameters.Add(p);
}
}
return(cmd.ExecuteReader());
}
/// <summary>
/// 查询数据
/// 例如：select * from Person where id=@ID
/// valuePairs["ID"]=1;
/// </summary>
/// <param name="source"></param>
/// <param name="querySql"></param>
/// <param name="valuePairs"></param>
/// <returns></returns>
public static DataSet ExecuteQuery(this HikariDataSource source, string querySql, Dictionary <string, object> valuePairs = null)
{
using (var con = source.GetConnection())
{
var cmd = con.CreateCommand();
cmd.CommandText = querySql;
if (valuePairs != null)
{
foreach (var kv in valuePairs)
{
var p = cmd.CreateParameter();
p.ParameterName = "@" + kv.Key;
p.Value = kv.Value;
cmd.Parameters.Add(p);
}
}
var da = source.DataAdapter;
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds);
cmd.Dispose();
return(ds);
}
}