public object ExecuteIdentity(string tableName) { bool ist = dataBase.IsBeginTransaction; if (!ist) { dataBase.BeginTransaction(); } try { Execute(tableName); return(dataBase.ExecuteScalar("SELECT @@IDENTITY")); } catch { dataBase.RollbackTransaction(); throw; } finally { if (!ist) { dataBase.CommitTransaction(); } } }
public static object ExecuteEntityIdentity(DbHelper db, string sql, CommandType commandType, object entity) { bool ist = db.IsBeginTransaction; if (!ist) { db.BeginTransaction(); } try { ExecuteEntity(db, sql, commandType, entity); return(db.ExecuteScalar("SELECT @@IDENTITY")); } catch { db.RollbackTransaction(); throw; } finally { if (!ist) { db.CommitTransaction(); } } }
public DataTable GetData() { CreateSql(); bool ist = _db.IsBeginTransaction; if (!ist) { _db.BeginTransaction(); } try { string pcount = string.Empty; if (sqlParams.Count > 0) { pcount = _db.ExecuteScalar <string>(pagerCountSql, sqlParams.ToArray()); _db.ClearParameters(); } else { pcount = _db.ExecuteScalar <string>(pagerCountSql); } if (string.IsNullOrEmpty(pcount)) { pcount = "0"; } pagerCount = int.Parse(pcount); string sql = dbPagerBase.GetSQLByPageIndex(); if (sqlParams.Count > 0) { return(_db.GetDataTable(sql, sqlParams.ToArray())); } else { return(_db.GetDataTable(sql)); } } catch { _db.RollbackTransaction(); throw; } finally { if (!ist) { _db.CommitTransaction(); } } }