/// <summary>
///
/// </summary>
/// <param name="MonitorBackupServer"></param>
/// <param name="conn"></param>
/// <returns></returns>
public int UpdateMonitorBackupServer(MonitorBackupServer MonitorBackupServer, OdbcConnection conn)
{
int result = -1;
string sql = @"UPDATE monitorBackupServer
SET backupServerGroupID = ?
,updater = ?
,updateDate = ?
WHERE monitorServerID=@monitorServerID";
OdbcParameter[] para = new OdbcParameter[] {
new OdbcParameter("@backupServerGroupID", MonitorBackupServer.backupServerGroupId),
new OdbcParameter("@updater", MonitorBackupServer.updater),
new OdbcParameter("@updateDate", MonitorBackupServer.updateDate),
new OdbcParameter("@monitorServerID", MonitorBackupServer.monitorServerId)
};
try
{
result = db.Udaquery(sql, conn, para);
}
catch (Exception e)
{
throw e;
}
return(result);
}
public int InsertMonitorBackupServer(MonitorBackupServer MonitorBackupServer, OdbcConnection conn)
{
try
{
return(db.insert(MonitorBackupServer, "monitorBackupServer", conn));
}
catch (Exception e)
{
throw e;
}
}
public int InsertMonitorBackupServer(MonitorBackupServer MonitorBackupServer)
{
OdbcConnection conn;
int count = 0;
using (conn = OdbcHelper.CreateConntion())
{
conn.Open();
count = MonitorBackupServerDal.InsertMonitorBackupServer(MonitorBackupServer, conn);
conn.Close();
}
return(count);
}