/// <summary>
/// 批量更新
/// </summary>
/// <param name="baseList"></param>
public void Commit(List <QH_CapitalAccountTableInfo> baseList)
{
try
{
bool isSuccess = false;
QH_CapitalAccountTableDal dal = new QH_CapitalAccountTableDal();
Database database = DatabaseFactory.CreateDatabase();
using (DbConnection connection = database.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
foreach (var data in baseList)
{
dal.Update(data, database, transaction);
}
transaction.Commit();
isSuccess = true;
}
catch (Exception ex)
{
transaction.Rollback();
LogHelper.WriteError(ex.Message, ex);
}
}
//提交后清除增量表数据
if (isSuccess)
{
QH_CapitalAccountTable_DeltaDal deltaDal = new QH_CapitalAccountTable_DeltaDal();
deltaDal.Truncate();
}
/*DataManager.ExecuteInTransaction((database, transaction) =>
* {
* foreach (var data in baseList)
* {
* dal.Update(data, database, transaction);
* }
*
* //提交后清除增量表数据
* CleanDeltaTable(database, transaction);
* });*/
}
catch (Exception ex)
{
LogHelper.WriteError(ex.Message, ex);
}
}
