/// <summary>
/// 更新对象
/// </summary>
/// <param name="BackupObj">需要更新的对象</param>
/// <returns>返回受影响的行数</returns>
public virtual string Update(tblBackup BackupObj)
{
tblBackup SchedulerObjUpdate;//需要跟新的对象
string strMessage = "InsertError";
int counts = 0;//影响行数标记
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
SchedulerObjUpdate = ServiceDirectDB.tblBackup.FirstOrDefault(t => t.BackupID == BackupObj.BackupID);
}catch(EntitySqlException)
{
throw;
}
catch (EntityException)
{
throw;
}
if (SchedulerObjUpdate != null)//如果为空则进行插入
{
//对象进行赋值，准备更新
SchedulerObjUpdate.BackupFloder = BackupObj.BackupFloder;
SchedulerObjUpdate.BackupDatabase = BackupObj.BackupDatabase;
SchedulerObjUpdate.DeleteBackupOlder = BackupObj.DeleteBackupOlder;
SchedulerObjUpdate.BackupServer = BackupObj.BackupServer;
SchedulerObjUpdate.BackupUser = BackupObj.BackupUser;
SchedulerObjUpdate.BackupPassword = BackupObj.BackupPassword;
try
{
counts = ServiceDirectDB.SaveChanges();
}
catch (EntityException)
{
throw;
}
}
else
{
try
{
ServiceDirectDBEntitieAdd = new ServiceDirectDBEntities();
ServiceDirectDBEntitieAdd.tblBackup.AddObject(BackupObj);
counts = ServiceDirectDBEntitieAdd.SaveChanges();
}
catch (EntityException)
{
throw;
}
}
if (counts > 0)
{
strMessage = "update success";
return strMessage;
}
return strMessage;
}
/// <summary>
/// 插入的对象
/// </summary>
/// <param name="BackupObj">需要插入的对象</param>
/// <returns>受影响的行数</returns>
public virtual string Insert(tblBackup BackupObj)
{
int counts = 0;//影响行数标记
string strErrorMessage = "InsertError";
//插入数据
try
{
ServiceDirectDBEntitieAdd = new ServiceDirectDBEntities();
ServiceDirectDBEntitieAdd.tblBackup.AddObject(BackupObj);
counts = ServiceDirectDBEntitieAdd.SaveChanges();
}
catch (EntitySqlException)
{
throw;
}
if (counts>0)
{
return BackupObj.BackupID.ToString();
}
return strErrorMessage;
}
/// <summary>
/// 物理删除
/// </summary>
/// <param name="KeyId">需要删除对象的ID</param>
/// <returns>返回受影响的行数</returns>
public virtual int LogicDelete(string KeyId)
{
int counts = 0;//影响行数标记
System.Guid KeyIdGuid = new Guid(KeyId);//转换成Guid类型
tblBackup BackupObjDelete;//需要跟新的对象
try
{
ServiceDirectDBEntitiesDelete = new ServiceDirectDBEntities();
BackupObjDelete = ServiceDirectDBEntitiesDelete.tblBackup.First(t => t.BackupID == KeyIdGuid);
ServiceDirectDBEntitiesDelete.DeleteObject(BackupObjDelete);
counts = ServiceDirectDBEntitiesDelete.SaveChanges();
}
catch (EntityException)
{
throw;
}
return counts;
}
/// <summary>
/// 物理删除
/// </summary>
/// <param name="KeyId">需要删除对象的ID</param>
/// <returns>返回受影响的行数</returns>
public virtual int LogicDelete(string KeyId)
{
int counts = 0;//影响行数标记
ServiceDirectDBEntities objDB;
vUTPCommand vUTPCommandObj;
try
{
objDB = new ServiceDirectDBEntities();
vUTPCommandObj = objDB.vUTPCommand.FirstOrDefault(c => c.RelateID == KeyId);
if (vUTPCommandObj != null)
{
if (vUTPCommandObj.RelateID != null && vUTPCommandObj.RelateID != string.Empty)
{
objDB.DeleteObject(vUTPCommandObj);
counts = objDB.SaveChanges();
}
}
}
catch (EntityException)
{
throw;
}
return counts;
}
/// <summary>
/// 更新对象
/// </summary>
/// <param name="EmailObj">需要更新的对象</param>
/// <returns>返回受影响的行数</returns>
public virtual string Update(tblEmail EmailObj)
{
tblEmail EmailObjUpdate;//需要跟新的对象
string strMessage = "InsertError";
int counts = 0;//影响行数标记
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
EmailObjUpdate = ServiceDirectDB.tblEmail.First(t => t.EmailID == EmailObj.EmailID);
}catch(EntitySqlException)
{
throw;
}
catch (EntityException)
{
throw;
}
//对象进行赋值，准备更新
EmailObjUpdate.EmailFrom = EmailObj.EmailFrom;
//EmailObjUpdate.EmailTo = EmailObj.EmailTo;
EmailObjUpdate.EmailPort = EmailObj.EmailPort;
EmailObjUpdate.EmailSSL = EmailObj.EmailSSL;
EmailObjUpdate.SMTPHost = EmailObj.SMTPHost;
EmailObjUpdate.SMTPUsername = EmailObj.SMTPUsername;
EmailObjUpdate.SMTPPassword = EmailObj.SMTPPassword;
try
{
counts = ServiceDirectDB.SaveChanges();
}
catch (EntityException)
{
throw;
}
if (counts > 0)
{
strMessage = "update success";
return strMessage;
}
return strMessage;
}
public void InsertCommand(UTPCommandBuilder builder, string RelateID)
{
ServiceDirectDBEntities objDB;
vUTPCommand vUTPCommandObj;
//影响行数标记
int counts = 0;
//插入数据
try
{
objDB = new ServiceDirectDBEntities();
vUTPCommandObj = new vUTPCommand();
vUTPCommandObj.CommandID = builder.CommandID;
vUTPCommandObj.CommandLine = builder.CommandString;
vUTPCommandObj.RelateID = RelateID;
vUTPCommandObj.Sequence = 1;
objDB.vUTPCommand.AddObject(vUTPCommandObj);
counts = objDB.SaveChanges();
}
catch (EntitySqlException)
{
throw;
}
}
/// <summary>
/// 更新对象
/// </summary>
/// <param name="SchedulerObj">需要更新的对象</param>
/// <returns>返回受影响的行数</returns>
public virtual Boolean UpdateInTaskView(tblScheduler SchedulerObj)
{
tblScheduler SchedulerObjUpdate;//需要跟新的对象
Boolean flagSuccess = false;
int counts = 0;//影响行数标记
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
SchedulerObjUpdate = ServiceDirectDB.tblScheduler.First(t => t.ScheduleID == SchedulerObj.ScheduleID);
}
catch (EntitySqlException)
{
throw;
}
catch (EntityException)
{
throw;
}
//对象进行赋值，准备更新
//SchedulerObjUpdate.Action = SchedulerObj.Action;
//SchedulerObjUpdate.TraceType = SchedulerObj.TraceType;
//SchedulerObjUpdate.PostAction = SchedulerObj.PostAction;
//SchedulerObjUpdate.ScheduleType = SchedulerObj.ScheduleType;
//SchedulerObjUpdate.StartTime = SchedulerObj.StartTime;
//SchedulerObjUpdate.TaskName = SchedulerObj.TaskName;
//SchedulerObjUpdate.RunOnly = SchedulerObj.RunOnly;
//SchedulerObjUpdate.RunOnlyStart = SchedulerObj.RunOnlyStart;
//SchedulerObjUpdate.RunOnlyEnd = SchedulerObj.RunOnlyEnd;
SchedulerObjUpdate.Trace = SchedulerObj.Trace;
SchedulerObjUpdate.TraceTable = SchedulerObj.TraceTable;
SchedulerObjUpdate.JobID = SchedulerObj.JobID;
//SchedulerObjUpdate.Status = SchedulerObj.Status;
//SchedulerObjUpdate.UTPPwd = SchedulerObj.UTPPwd;
//SchedulerObjUpdate.UTPUser = SchedulerObj.UTPUser;
//SchedulerObjUpdate.Cycle = SchedulerObj.Cycle;
//SchedulerObjUpdate.Calc = SchedulerObj.Calc;
//SchedulerObjUpdate.Company = SchedulerObj.Company;
//SchedulerObjUpdate.Copy = SchedulerObj.Copy;
try
{
counts = ServiceDirectDB.SaveChanges();
}
catch (EntityException)
{
throw;
}
if (counts > 0)
{
flagSuccess = true;
return flagSuccess;
}
return flagSuccess;
}
/// <summary>
/// 更新对象
/// </summary>
/// <param name="SchedulerObj">需要更新的对象</param>
/// <returns>返回受影响的行数</returns>
public virtual string UpdateInTaskDetailForm(tblScheduler SchedulerObj)
{
tblScheduler SchedulerObjUpdate;//需要跟新的对象
string strMessage = "UpdateError";
int counts = 0;//影响行数标记
try
{
ServiceDirectDB = new ServiceDirectDBEntities();
SchedulerObjUpdate = ServiceDirectDB.tblScheduler.First(t => t.ScheduleID == SchedulerObj.ScheduleID);
}
catch (EntitySqlException)
{
throw;
}
catch (EntityException)
{
throw;
}
//对象进行赋值，准备更新
SchedulerObjUpdate.Action = SchedulerObj.Action;
SchedulerObjUpdate.TraceType = SchedulerObj.TraceType;
SchedulerObjUpdate.PostAction = SchedulerObj.PostAction;
SchedulerObjUpdate.ScheduleType = SchedulerObj.ScheduleType;
SchedulerObjUpdate.StartTime = SchedulerObj.StartTime;
SchedulerObjUpdate.TaskName = SchedulerObj.TaskName;
SchedulerObjUpdate.RunOnly = SchedulerObj.RunOnly;
SchedulerObjUpdate.RunOnlyStart = SchedulerObj.RunOnlyStart;
SchedulerObjUpdate.RunOnlyEnd = SchedulerObj.RunOnlyEnd;
SchedulerObjUpdate.BackupID = SchedulerObj.BackupID;
SchedulerObjUpdate.Trace = SchedulerObj.Trace;
SchedulerObjUpdate.TraceTable = SchedulerObj.TraceTable;
//SchedulerObjUpdate.Status = SchedulerObj.Status;
//SchedulerObjUpdate.UTPPwd = SchedulerObj.UTPPwd;
//SchedulerObjUpdate.UTPUser = SchedulerObj.UTPUser;
//SchedulerObjUpdate.Cycle = SchedulerObj.Cycle;
//SchedulerObjUpdate.Calc = SchedulerObj.Calc;
//SchedulerObjUpdate.Company = SchedulerObj.Company;
//SchedulerObjUpdate.Copy = SchedulerObj.Copy;
try
{
counts = ServiceDirectDB.SaveChanges();
}
catch (EntityException)
{
throw;
}
if (counts > 0)
{
strMessage = "Update success";
return strMessage;
}
return strMessage;
}
/// <summary>
/// 物理删除
/// </summary>
/// <param name="KeyId">需要删除对象的ID</param>
/// <returns>返回受影响的行数</returns>
public virtual string LogicDelete(string KeyId)
{
int counts = 0;//影响行数标记
string strMessage = "InsertError";
System.Guid KeyIdGuid = new Guid(KeyId);//转换成Guid类型
tblScheduler SchedulerObjDelete;//需要跟新的对象
try
{
ServiceDirectDBEntitiesDelete = new ServiceDirectDBEntities();
SchedulerObjDelete = ServiceDirectDBEntitiesDelete.tblScheduler.First(t => t.ScheduleID == KeyIdGuid);
ServiceDirectDBEntitiesDelete.DeleteObject(SchedulerObjDelete);
counts = ServiceDirectDBEntitiesDelete.SaveChanges();
}
catch (EntityException)
{
throw;
}
if (counts > 0)
{
strMessage = "update success";
return strMessage;
}
return strMessage;
}
/// <summary>
/// 插入的对象
/// </summary>
/// <param name="SchedulerObj">需要插入的对象</param>
/// <returns>受影响的行数</returns>
public virtual string Insert(tblScheduler SchedulerObj)
{
int counts;//影响行数标记
string strScheduleID;//插入对象的ID
string strErrorMessage="InsertError";
SchedulerObj.ScheduleID = System.Guid.NewGuid();
//插入数据
try
{
ServiceDirectDBEntitieAdd = new ServiceDirectDBEntities();
ServiceDirectDBEntitieAdd.tblScheduler.AddObject(SchedulerObj);
counts = ServiceDirectDBEntitieAdd.SaveChanges();
}
catch (EntitySqlException)
{
throw;
}
if(counts>0)
{
strScheduleID = SchedulerObj.ScheduleID.ToString();
return strScheduleID;
}
return strErrorMessage;
}