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