public void EncapsulationData()
{
EmailObj = new tblEmail();
BackupObj = new tblBackup();
BackupObj.BackupFloder = txtBackupFolder.Text.Trim();
BackupObj.BackupDatabase = txtDatabase.Text.Trim();
BackupObj.BackupServer = txtServer.Text.Trim();
BackupObj.BackupID = System.Guid.NewGuid();
EmailObj.EmailID = BackupObj.BackupID;
EmailObj.SMTPHost = rtxtServerName.Text.Trim();
EmailObj.EmailFrom = rtxtFrom.Text.Trim();
EmailObj.EmailPort = Convert.ToInt16(rntxtPort.Text.Trim());
EmailObj.SMTPUsername = rtxtName.Text.Trim();
EmailObj.SMTPPassword = rtxtPwd.Text.Trim();
EmailObj.EmailSSL = ckbSSL.Checked;
HttpCookie UserData = Request.Cookies.Get("UserIdCookies");
if (UserData != null)
{
BackupObj.BackupUser = UserData.Value;
}
HttpCookie UserPasswordData = Request.Cookies.Get("UserPasswordCookies");
if (UserPasswordData != null)
{
BackupObj.BackupPassword = UserPasswordData.Value;
}
}
/// <summary>
/// 插入的对象
/// </summary>
/// <param name="EmailObj">需要插入的对象</param>
/// <returns>受影响的行数</returns>
public virtual string Insert(tblEmail EmailObj)
{
string strErrorMessage = "InsertError";
int counts = 0;//影响行数标记
//插入数据
try
{
ServiceDirectDBEntitieAdd = new ServiceDirectDBEntities();
ServiceDirectDBEntitieAdd.tblEmail.AddObject(EmailObj);
counts = ServiceDirectDBEntitieAdd.SaveChanges();
}
catch (EntitySqlException)
{
throw;
}
if (counts > 0)
{
return EmailObj.EmailID.ToString();
}
return strErrorMessage;
}
/// <summary>
/// 创建新的 tblEmail 对象。
/// </summary>
/// <param name="emailID">EmailID 属性的初始值。</param>
public static tblEmail CreatetblEmail(global::System.Guid emailID)
{
tblEmail tblEmail = new tblEmail();
tblEmail.EmailID = emailID;
return tblEmail;
}
/// <summary>
/// 用于向 tblEmail EntitySet 添加新对象的方法，已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。
/// </summary>
public void AddTotblEmail(tblEmail tblEmail)
{
base.AddObject("tblEmail", tblEmail);
}
/// <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;
}
