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();
}
}
}
