/// <summary>
/// 将IOperateSection转换为Sql语句执行
/// </summary>
/// <param name="db">数据库对象</param>
/// <param name="sections"></param>
/// <returns></returns>
public static int BatchExecute(EDatabase db, params string[] sqls)
{
int nReturn = 0;
int nMaxSqlLenth = 8000 - 1;//最大的执行Sql语句的长度
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
StringBuilder sbSql = new StringBuilder();
for (int i = 0; i < sqls.Length; i++)
{
string strSql = sqls[i];
if (sbSql.Length + strSql.Length < nMaxSqlLenth)
{
sbSql.Append(strSql).Append(";");
}
else
{
nReturn += db.ExecuteNonQuery(sbSql.ToString());
sbSql.Remove(0, sbSql.Length);
}
}
}
return(nReturn);
}
public static DataTable GetOneDataByID(EDatabase db, IQueryTable table, object id)
{
if (id != null)
{
return(db.Select(table).Where(table.IDColumn == id).ToDataTable());
}
return(null);
}
/// <summary>
/// 获取总记录条数
/// </summary>
/// <param name="column">主键</param>
/// <returns></returns>
public static int GetTotalRecord(EDatabase db, IQueryTable table, WhereClip where, List <JoinTable> joinTables)
{
SelectSqlSection sql = db.Select(table, table.IDColumn.Count());
if (joinTables != null && joinTables.Count > 0)
{
foreach (JoinTable joinTable in joinTables)
{
joinTable.Join(sql);
}
}
object obj = sql.Where(where).ToScalar();
if (obj != null)
{
return(Convert.ToInt32(obj));
}
else
{
return(0);
}
}
public ModalAdapter(IQueryTable table, EDatabase db)
{
this._DB = db;
this._DB.QueryTable = table;
this._tableName = this._DB.QueryTable.GetTableName();
}
public SearchHelper(IQueryTable table, EDatabase db)
{
this._Table = table;
this._DB = db;
}
/// <summary>
/// 获取总的数据条数
/// </summary>
/// <param name="DB"></param>
/// <param name="column"></param>
/// <returns></returns>
public static int GetTotalRecord(EDatabase db, IQueryTable table, QueryColumn column, WhereClip where)
{
return(Convert.ToInt32(db.Select(table, column.Count()).Where(where).ToScalar()));
}
public static int DeleteByWhere(EDatabase db, IQueryTable table, WhereClip where, bool withTran)
{
DeleteSqlSection delSection = db.Delete(table).Where(where);
return(withTran ? delSection.ExecuteWithTran() : delSection.Execute());
}
public static int DeleteByIDs(EDatabase db, IQueryTable table, string ids, bool withTran)
{
return(DeleteByWhere(db, table, table.IDColumn.In(ids.Split(',')), withTran));
}
public static int DeleteByIDs(EDatabase db, IQueryTable table, string ids)
{
return(DeleteByIDs(db, table, ids, false));
}
public static bool DeleteByID(EDatabase db, IQueryTable table, string id)
{
return(db.Delete(table).Where(table.IDColumn == id).Execute() == 1);
}