87 lines
2.8 KiB
C#
87 lines
2.8 KiB
C#
using Model;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
|
|
namespace BLL.Email_Send
|
|
{
|
|
public static class Email_ParamsService
|
|
{
|
|
#region 根据主键查询信息
|
|
/// <summary>
|
|
/// 根据主键查询信息
|
|
/// </summary>
|
|
/// <param name="EmailID">主键</param>
|
|
/// <returns>对象</returns>
|
|
public static Email_Params GetEmail_ParamsPop(string EmailID)
|
|
{
|
|
return Funs.DB.Email_Params.FirstOrDefault(x => x.ID == EmailID);
|
|
}
|
|
#endregion
|
|
|
|
#region 查询列表
|
|
/// <summary>
|
|
/// 查询列表
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public static List<Email_Params> GetEmail_ParamsList()
|
|
{
|
|
return (from x in Funs.DB.Email_Params orderby x.CreateTime descending select x).ToList();
|
|
}
|
|
#endregion
|
|
|
|
#region 新增
|
|
/// <summary>
|
|
/// 新增
|
|
/// </summary>
|
|
/// <param name="email_Params"></param>
|
|
public static void AddEmail_Params(Email_Params email_Params)
|
|
{
|
|
Email_Params newemail_Params = new Email_Params();
|
|
newemail_Params.ID = Guid.NewGuid().ToString();
|
|
newemail_Params.MailClassName = email_Params.MailClassName;
|
|
newemail_Params.MailClassID = email_Params.MailClassID;
|
|
newemail_Params.CreateName = email_Params.CreateName;
|
|
newemail_Params.CreateTime = DateTime.Now;
|
|
newemail_Params.UpdateName = email_Params.UpdateName;
|
|
newemail_Params.UpdateTime = DateTime.Now;
|
|
|
|
Funs.DB.Email_Params.InsertOnSubmit(newemail_Params);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
#endregion
|
|
|
|
#region 修改
|
|
/// <summary>
|
|
/// 修改
|
|
/// </summary>
|
|
/// <param name="email_Params"></param>
|
|
public static void UpdateEmail_Params(Email_Params email_Params)
|
|
{
|
|
Email_Params newemail_Params = Funs.DB.Email_Params.FirstOrDefault(x => x.ID == email_Params.ID);
|
|
newemail_Params.MailClassName = email_Params.MailClassName;
|
|
newemail_Params.MailClassID = email_Params.MailClassID;
|
|
newemail_Params.UpdateName = email_Params.UpdateName;
|
|
newemail_Params.UpdateTime = DateTime.Now;
|
|
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
#endregion
|
|
|
|
#region 删除
|
|
/// <summary>
|
|
/// 删除
|
|
/// </summary>
|
|
/// <param name="EmailId"></param>
|
|
public static void DeleteEmail_ParamsById(string EmailId)
|
|
{
|
|
Email_Params newemail_Params = Funs.DB.Email_Params.FirstOrDefault(e => e.ID == EmailId);
|
|
|
|
Funs.DB.Email_Params.DeleteOnSubmit(newemail_Params);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
#endregion
|
|
}
|
|
}
|