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