/// <summary>
/// 用户自定义sql语句批量执行（非查询语句）
/// </summary>
/// <param name="sql">非查询sql语句集合</param>
/// <returns>是否成功</returns>
public static bool Excute(List <String> sqls)
{
DbConnection conn = SQLFactory.CreateDBConnection();
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
DbTransaction tran = conn.BeginTransaction();
try
{
foreach (String sql in sqls)
{
SQLFactory.CreateDBHelper().ExecuteNonQuery(tran, System.Data.CommandType.Text, sql, null);
}
tran.Commit();
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 用户自定义sql语句查询
/// </summary>
/// <param name="sql">查询语句</param>
/// <param name="parms">查询参数列表</param>
/// <returns>查询对象集合</returns>
public static List <T> QueryEx(String sql, List <DbParameter> parms = null)
{
DataTable dt = SQLFactory.CreateDBHelper().Query(sql, parms);
List <T> entities = NDolls.Data.Util.DataConvert <T> .ToEntities(dt);
return(entities);
}
/// <summary>
/// 构造函数
/// </summary>
public DBTransaction()
{
this.dbHelper = SQLFactory.CreateDBHelper();
}
/// <summary>
/// 用户自定义sql语句执行（非查询语句）
/// </summary>
/// <param name="sql">非查询sql语句</param>
/// <returns>执行成功的数据行数</returns>
public static int Excute(String sql)
{
return(SQLFactory.CreateDBHelper().ExecuteNonQuery(System.Data.CommandType.Text, sql, null));
}
/// <summary>
/// 用户自定义sql语句查询
/// </summary>
/// <param name="sql">查询语句</param>
/// <param name="parms">查询参数列表</param>
/// <returns>查询结果集</returns>
public static DataTable Query(String sql, List <DbParameter> parms = null)
{
return(SQLFactory.CreateDBHelper().Query(sql, parms));
}
/// <summary>
/// 用户自定义sql语句查询（返回一行一列）
/// </summary>
/// <param name="sql">查询sql语句</param>
/// <returns>查询结果</returns>
public static object Single(String sql, List <DbParameter> parms = null)
{
return(SQLFactory.CreateDBHelper().ExecuteScalar(System.Data.CommandType.Text, sql, parms));
}