public bool DeleteScript(int scriptId) { IBlazeDatabase db = null; try { db = DbFactory.GetDatabase(); IBlazeTable ibShopTable = db.GetTable(TableString.IbShopTableName); db.BeginTrans(); ibShopTable.Delete(FilterFactory.CreateEqualFilter(TableString.IbShopFieldId, scriptId)); db.CommitTrans(); return(true); } catch (Exception ex) { if (db != null) { db.RollbackTrans(); } throw ex; } finally { if (db != null) { db.Close(); } } }
/// <summary> /// 得到已保存的帐号密码 /// </summary> public string GetSavedPassword(string accountName) { IBlazeDatabase db = null; try { db = DbFactory.GetDatabase(); DataSet dataSet = new DataSet(); IBlazeTable accountTable = db.GetTable(TableString.AccountInfoTableName); accountTable.Get(dataSet, FilterFactory.CreateEqualFilter(TableString.AccountInfoFieldName, accountName)); DataRowCollection rows = dataSet.Tables[TableString.AccountInfoTableName].Rows; if (rows.Count != 0) { return(rows[0][TableString.AccountInfoFieldPassword] as string); } return(null); } catch (Exception ex) { throw ex; } finally { if (db != null) { db.Close(); } } }
/// <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 EditUpdateServer(FTPServer server) { IBlazeDatabase db = null; try { db = DbFactory.GetDatabase(); db.BeginTrans(); IBlazeTable table = db.GetTable(TableString.UpdateServerTableName); DataSet taskData = new DataSet(); table.Get(taskData); DataTable taskTable = taskData.Tables[TableString.UpdateServerTableName]; foreach (DataRow row in taskTable.Rows) { if ((int)row[TableString.UpdateServerFieldId] == server.ID) { row.BeginEdit(); row[TableString.UpdateServerFieldAddress] = server.Address; row[TableString.UpdateServerFieldPort] = server.Port; row[TableString.UpdateServerFieldUsername] = server.UserName; row[TableString.UpdateServerFieldPassword] = server.Password; row[TableString.UpdateServerFieldLiteral] = server.Literal; row.EndEdit(); break; } } table.Set(taskTable); db.CommitTrans(); return(true); } catch (Exception) { if (db != null) { db.RollbackTrans(); } } finally { if (db != null) { db.Close(); } } return(false); }
public bool DeleteUpdateServer(FTPServer server) { IBlazeDatabase db = null; try { db = DbFactory.GetDatabase(); db.BeginTrans(); IBlazeTable table = db.GetTable(TableString.UpdateServerTableName); DataSet taskData = new DataSet(); table.Get(taskData); DataTable taskTable = taskData.Tables[TableString.UpdateServerTableName]; foreach (DataRow row in taskTable.Rows) { if ((int)row[TableString.UpdateServerFieldId] == server.ID) { row.Delete(); break; } } table.Set(taskTable); AdminServer.TheInstance.SecurityManager.Delete(server.ID, db); db.CommitTrans(); this._FTPServerList.Remove(server); return(true); } catch (Exception) { if (db != null) { db.RollbackTrans(); } } finally { if (db != null) { db.Close(); } } return(false); }
public bool LoadUpdateServer() { lock (this) { IBlazeDatabase db = null; try { db = DbFactory.GetDatabase(); IBlazeTable table = db.GetTable(TableString.UpdateServerTableName); DataSet data = new DataSet(); table.Get(data); DataRowCollection rows = data.Tables[TableString.UpdateServerTableName].Rows; foreach (DataRow row in rows) { int id = (int)row[TableString.UpdateServerFieldId]; string address = row[TableString.UpdateServerFieldAddress] as string; int port = (int)row[TableString.UpdateServerFieldPort]; string username = row[TableString.UpdateServerFieldUsername] as string; string password = row[TableString.UpdateServerFieldPassword] as string; string literal = row[TableString.UpdateServerFieldLiteral] as string; FTPServer.FTPServerType type = (FTPServer.FTPServerType)Enum.Parse(typeof(FTPServer.FTPServerType), row[TableString.UpdateServerFieldUpdateServerType].ToString()); FTPServer server = new FTPServer(id, address, port, username, password, literal, type); server.SecurityObject = AdminServer.TheInstance.SecurityManager.Get(id); _FTPServerList.Add(server); } } catch (Exception) { return(false); } finally { if (db != null) { db.Close(); } } } return(true); }
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 IList <IBShopScript> GetScript() { IBlazeDatabase db = null; IList <IBShopScript> resultList = new List <IBShopScript>(); try { db = DbFactory.GetDatabase(); DataSet dataSet = new DataSet(); IBlazeTable ibShopTable = db.GetTable(TableString.IbShopTableName); ibShopTable.Get(dataSet); DataRowCollection rows = dataSet.Tables[TableString.IbShopTableName].Rows; foreach (DataRow row in rows) { IBShopScript ibShopScript = new IBShopScript(); ibShopScript.ID = (int)row[TableString.IbShopFieldId]; ibShopScript.TimeStamp = (DateTime)row[TableString.IbShopFieldTimeStamp]; ibShopScript.Script = Encoding.Default.GetString(row[TableString.IbShopFieldScript] as byte[]); resultList.Add(ibShopScript); } return(resultList); } catch (Exception ex) { 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); }