/// <summary>
/// 添加玩家数量信息
/// </summary>
void AddPlayerCountInfo(PlayerCountStatisticInfo info)
{
if (info == null)
{
throw new ArgumentNullException("info");
}
using (IBlazeDatabase db = DbFactory.GetDatabase())
{
IBlazeTable table = db.GetTable(TableString.PlayerCountTableName);
string[] fieldNames =
{
TableString.PlayerCountFieldServerId,
TableString.PlayerCountFieldRecordTime,
TableString.PlayerCountFieldMaxPlayerCount,
TableString.PlayerCountFieldMinPlayerCount,
TableString.PlayerCountFieldAveragePlayerCount
};
object[] fieldValues =
{
_server.Id,
info.Time,
info.MaxCount,
info.MinCount,
info.AverageCount
};
table.Add(fieldNames, fieldValues);
}
}
/// <summary>
/// 保存帐号密码
/// </summary>
public bool SaveAccountPassword(string accountName, string accountPassword)
{
IBlazeDatabase db = null;
try
{
db = DbFactory.GetDatabase();
IBlazeTable accountTable = db.GetTable(TableString.AccountInfoTableName);
//插入数据到服务器表
string[] fields = new string[] {
TableString.AccountInfoFieldName,
TableString.AccountInfoFieldPassword,
};
object[] values = new object[] {
accountName,
accountPassword
};
db.BeginTrans();
if (GetSavedPassword(accountName) != null)
{
//Update
accountTable.Set(TableString.AccountInfoFieldPassword, accountPassword,
FilterFactory.CreateEqualFilter(TableString.AccountInfoFieldName, accountName));
}
else
{
//Insert
accountTable.Add(fields, values);
}
db.CommitTrans();
return(true);
}
catch (Exception ex)
{
if (db != null)
{
db.RollbackTrans();
}
throw ex;
}
finally
{
if (db != null)
{
db.Close();
}
}
}
public bool SaveScript(string script, out long scriptId)
{
IBlazeDatabase db = null;
try
{
db = DbFactory.GetDatabase();
IBlazeTable ibShopTable = db.GetTable(TableString.IbShopTableName);
//插入数据到服务器表
string[] fields = new string[] {
TableString.IbShopFieldTimeStamp,
TableString.IbShopFieldScript,
};
object[] values = new object[] {
DateTime.Now,
script
};
db.BeginTrans();
scriptId = ibShopTable.Add(fields, values);
db.CommitTrans();
return(true);
}
catch (Exception ex)
{
if (db != null)
{
db.RollbackTrans();
}
throw ex;
}
finally
{
if (db != null)
{
db.Close();
}
}
}
public bool AddUpdateServer(FTPServer server)
{
IBlazeDatabase db = null;
try
{
db = DbFactory.GetDatabase();
db.BeginTrans();
SecurityManager sm = AdminServer.TheInstance.SecurityManager;
//构造相关安全对象
string newUpdateServerObjPath = sm.Root.FullName + SecurityManager.ObjectPathDelimiter + SecurityObjectSystem + SecurityManager.ObjectPathDelimiter + SecurityObjectUpdateManagement + SecurityManager.ObjectPathDelimiter
+ SecurityObjectUpdateServer + SecurityManager.ObjectPathDelimiter + server.Literal;
FSEyeObject newUpdateServerObj = sm.Get(newUpdateServerObjPath, db);
sm.Set(newUpdateServerObj);
AddFatherAce(newUpdateServerObj.Parent, newUpdateServerObj, true);
//IBlazeTable table = db.GetTable(TableString.UpdateServerTableName);
//DataSet taskData = new DataSet();
//table.Get(taskData);
//DataTable taskTable = taskData.Tables[TableString.UpdateServerTableName];
//DataRow addRow = taskTable.Rows.Add(newUpdateServerObj.Id,
// server.Address,
// server.Port,
// server.UserName,
// server.Password,
// server.Literal);
//table.Set(taskTable);
//插入数据到服务器表
string[] fields = new string[] {
TableString.UpdateServerFieldId,
TableString.UpdateServerFieldAddress,
TableString.UpdateServerFieldPort,
TableString.UpdateServerFieldUsername,
TableString.UpdateServerFieldPassword,
TableString.UpdateServerFieldLiteral,
TableString.UpdateServerFieldUpdateServerType
};
object[] values = new object[] {
newUpdateServerObj.Id,
server.Address,
server.Port,
server.UserName,
server.Password,
server.Literal,
(Int16)server.FtpServerType
};
IBlazeTable serverTable = db.GetTable(TableString.UpdateServerTableName);
serverTable.Add(fields, values);
db.CommitTrans();
server.SecurityObject = newUpdateServerObj;
this._FTPServerList.Add(server);
return(true);
}
catch (Exception ex)
{
Util.DebugLog(ex.ToString());
if (db != null)
{
db.RollbackTrans();
}
}
finally
{
if (db != null)
{
db.Close();
}
}
return(false);
}
