/// <summary>
/// 返回第一行第一列的值
/// </summary>
/// <param name="cmd"></param>
/// <returns></returns>
internal object ExecuteScalar(DbCommand cmd)
{
using (cmd.Connection = DbCommandMng.CreateConnection())
{
cmd.Connection.Open();
object ret = cmd.ExecuteScalar();
cmd.Connection.Close();
return(ret);
}
}
/// <summary>
/// 执行SQL，返回影响行数
/// </summary>
/// <param name="cmd"></param>
/// <returns></returns>
internal int ExecuteNonQuery(DbCommand cmd)
{
using (cmd.Connection = DbCommandMng.CreateConnection())
{
cmd.Connection.Open();
int ret = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(ret);
}
}
/// <summary>
/// 执行SQL，返回datatable
/// </summary>
/// <param name="cmd"></param>
/// <returns></returns>
internal DataTable ExecuteDataTable(DbCommand cmd)
{
using (cmd.Connection = DbCommandMng.CreateConnection())
{
DbDataAdapter dbDataAdapter = DbCommandMng.CreateDataAdapter();
dbDataAdapter.SelectCommand = cmd;
DataTable dataTable = new DataTable();
dbDataAdapter.Fill(dataTable);
return(dataTable);
}
}
/// <summary>
/// 执行SQL，返回dataSet
/// </summary>
/// <param name="cmd"></param>
/// <returns></returns>
internal DataSet ExecuteDataSet(DbCommand cmd)
{
using (cmd.Connection = DbCommandMng.CreateConnection())
{
DbDataAdapter dbDataAdapter = DbCommandMng.CreateDataAdapter();
dbDataAdapter.SelectCommand = cmd;
DataSet dataset = new DataSet();
dbDataAdapter.Fill(dataset);
return(dataset);
}
}
/// <summary>
/// 执行SQL，返回dataSet
/// </summary>
/// <param name="cmd"></param>
/// <returns></returns>
internal DataSet ExecuteDataSet(DbCommand cmd, Trans trans)
{
cmd.Connection = trans.DbConnection;
cmd.Transaction = trans.DbTrans;
DbDataAdapter dbDataAdapter = DbCommandMng.CreateDataAdapter();
dbDataAdapter.SelectCommand = cmd;
DataSet dataset = new DataSet();
dbDataAdapter.Fill(dataset);
return(dataset);
}
/// <summary>
/// 返回第一行，并转化成实体
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="cmd"></param>
/// <returns></returns>
internal T ToSingle <T>(DbCommand cmd) where T : class, new()
{
using (cmd.Connection = DbCommandMng.CreateConnection())
{
cmd.Connection.Open();
using (DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
reader.Read();
var item = FillModel <T>(reader);
//if (cmd.Connection.State == ConnectionState.Open)
// cmd.Connection.Close();
return(item);
}
}
}
/// <summary>
/// 查询第一列集合，返回列表
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="cmd"></param>
/// <returns></returns>
internal List <T> ExecuteScalarList <T>(DbCommand cmd)
{
using (cmd.Connection = DbCommandMng.CreateConnection())
{
List <T> list = new List <T>();
cmd.Connection.Open();
using (DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
list.Add((reader[0].To <T>()));
}
//if(cmd.Connection.State==ConnectionState.Open)
// cmd.Connection.Close();
return(list);
}
}
}
/// <summary>
/// 查询所有集合，返回实体列表
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="cmd"></param>
/// <returns></returns>
internal List <T> ToList <T>(DbCommand cmd) where T : class, new()
{
List <T> list = new List <T>();
using (cmd.Connection = DbCommandMng.CreateConnection())
{
cmd.Connection.Open();
using (DbDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
list.Add(FillModel <T>(reader));
}
//if (cmd.Connection.State == ConnectionState.Open)
// cmd.Connection.Close();
cmd.Connection.Close();
}
}
return(list);
}
/// <summary>
/// 事物
/// mysql表需要设置为alter table userinfo engine=InnoDB;
/// </summary>
public Trans()
{
conn = DbCommandMng.CreateConnection();
conn.Open();
dbTrans = conn.BeginTransaction();
}
private DbQuery(string sql)
{
Command = DbCommandMng.CreateCommand();
CommandText = sql;
}