public TableUnit GetTableUnitWithSql(string sql)
{
TableUnit unit = null;
unit = new TableUnit(mConn, sql, null);
return(unit);
}
private static object[] GetTableIDs(string tblname, object[] ids, string[] dbnames)
{
DataTable[] tables = new DataTable[dbnames.Length];
int index = 0;
foreach (string db in dbnames)
{
TableUnitManager tm = TableHelper.GetTableUnitManangerByDbname(db);
TableUnit unit = tm.GetTableUnit(tblname);
tables[index] = unit.GetTable();
index++;
}
bool bRet = false;
while (!bRet)
{
bRet = true;
foreach (DataTable table in tables)
{
if (ExistID(table, ids))
{
bRet = false;
break;
}
}
if (!bRet)
{
ids[0] = (int)(ids[0]) + 1;
}
}
return(ids);
}
public void MarkTableChanged(string tblname)
{
TableUnit unit = null;
bool bRet = mTables.TryGetValue(tblname, out unit);
if (bRet)
{
unit.TableChanged = true;
}
}
public void ReleaseTable(string tblname)
{
TableUnit unit = null;
bool bRet = mTables.TryGetValue(tblname, out unit);
if (bRet)
{
unit.ReleaseTable();
mTables.Remove(tblname);
}
}
public int SaveTable(string tblname)
{
TableUnit unit = null;
bool bRet = mTables.TryGetValue(tblname, out unit);
int nRet = 0;
if (bRet)
{
nRet = unit.SaveTable();
}
return(nRet);
}
public static int[] UniteTables(string tblname, string todbname, string[] dblist)
{
DataTable[] tables = new DataTable[dblist.Length - 1];
DataTable totable = null;
DataTable untable = null;
int nInsert = 0;
int nModify = 0;
int index = 0;
bool priority = true;
foreach (string db in dblist)
{
TableUnitManager tm = TableHelper.GetTableUnitManangerByDbname(db);
TableUnit unit = tm.GetTableUnit(tblname);
if (db != todbname)
{
tables[index] = unit.GetTable();
index++;
}
else
{
priority = false;
totable = unit.GetTable();
}
DataTable tbl = unit.GetTable();
tbl.ExtendedProperties["dbname"] = priority;
}
int count = 0;
foreach (DataTable table in tables)
{
if (table != null)
{
bool cover = Convert.ToBoolean(table.ExtendedProperties["dbname"]);
int[] result = UniteTables(totable, table, cover);
nInsert += result[0];
nModify += result[1];
}
}
TableUnitManager totm = TableHelper.GetTableUnitManangerByDbname(todbname);
totm.SaveTable(tblname);
return(new int[] { nInsert, nModify });
}
public TableUnit GetSqlTableUnit(string sql, string tblname)
{
if (mSqlTableCount > mMaxSqlTable)
{
lock (mSqlTables)
{
if (mSqlTableCount > mMaxSqlTable)
{
foreach (Dictionary <string, TableUnit> units in mSqlTables.Values)
{
foreach (TableUnit u in units.Values)
{
u.ReleaseTable();
}
}
mSqlTables.Clear();
mSqlTableCount = 0;
}
}
}
TableUnit unit = null;
bool bRet = mSqlTables.ContainsKey(tblname);
if (!bRet)
{
mSqlTables[tblname] = new Dictionary <string, TableUnit>();
}
bRet = mSqlTables[tblname].TryGetValue(sql, out unit);
if (!bRet)
{
unit = new TableUnit(mConn, sql, null);
mSqlTableCount++;
if ((!tblname.StartsWith("sys")) || tblname.StartsWith("sys_"))
{
mSqlTables[tblname][sql] = unit;
}
}
return(unit);
}
public TableUnit GetTableUnit(string tblname)
{
TableUnit unit = null;
bool bRet = mTables.TryGetValue(tblname, out unit);
if (!bRet)
{
lock (mTables)
{
bRet = mTables.TryGetValue(tblname, out unit);
if (!bRet)
{
unit = new TableUnit(mConn, tblname);
if ((!tblname.StartsWith("sys")) || tblname.StartsWith("sys_"))
{
mTables.Add(tblname, unit);
}
}
}
}
return(unit);
}
public LogHelper(string clientkey)
{
mClientkey = clientkey;
NetClient client = NetClientManager.GetNetClient(clientkey);
if (client.Database != "monitor")
{
mTableUnitManager = TableHelper.GetTableUnitManager(clientkey);
TableUnit unit = mTableUnitManager.GetTableUnit("sys_remote_log");
mLogTable = unit.GetTable();
}
int length = Convert.ToInt32(LogType.END);
mConsoleFlag = new bool[length];
mFileFlag = new bool[length];
for (int i = 0; i < length; ++i)
{
mConsoleFlag[i] = true;
mFileFlag[i] = true;
}
}
public TableUnit GetSqlTableUnit(string sql, string tblname)
{
if (mSqlTableCount > mMaxSqlTable)
{
lock (mSqlTables)
{
if (mSqlTableCount > mMaxSqlTable)
{
foreach (Dictionary<string, TableUnit> units in mSqlTables.Values)
{
foreach (TableUnit u in units.Values)
{
u.ReleaseTable();
}
}
mSqlTables.Clear();
mSqlTableCount = 0;
}
}
}
TableUnit unit = null;
bool bRet = mSqlTables.ContainsKey(tblname);
if (!bRet)
{
mSqlTables[tblname] = new Dictionary<string, TableUnit>();
}
bRet = mSqlTables[tblname].TryGetValue(sql, out unit);
if (!bRet)
{
unit = new TableUnit(mConn, sql, null);
mSqlTableCount++;
if ((!tblname.StartsWith("sys")) || tblname.StartsWith("sys_"))
{
mSqlTables[tblname][sql] = unit;
}
}
return unit;
}
public TableUnit GetTableUnitWithSql(string sql)
{
TableUnit unit = null;
unit = new TableUnit(mConn, sql, null);
return unit;
}
public TableUnit GetTableUnit(string tblname)
{
TableUnit unit = null;
bool bRet = mTables.TryGetValue(tblname, out unit);
if (!bRet)
{
lock (mTables)
{
bRet = mTables.TryGetValue(tblname, out unit);
if (!bRet)
{
unit = new TableUnit(mConn, tblname);
if ((!tblname.StartsWith("sys")) || tblname.StartsWith("sys_"))
{
mTables.Add(tblname, unit);
}
}
}
}
return unit;
}
