Mails.cs
上传用户:simon2hong
上传日期:2021-11-18
资源大小:16746k
文件大小:9k
- //------------------------------------------------------------------------------
- // 创建标识: Copyright (C) 2009 Socansoft.com 版权所有
- // 创建描述: SocanCode代码生成器 V4.3.2.3 自动创建于 2009-11-15 20:10:34
- //
- // 功能描述:
- //
- // 修改标识:
- // 修改描述:
- //------------------------------------------------------------------------------
- using System;
- using System.Data;
- using System.Data.Common;
- using System.Text;
- using System.Collections;
- using System.Collections.Generic;
- namespace SqlServerDAL
- {
- /// <summary>
- /// 数据访问类 Mails
- /// </summary>
- public class Mails : DALHelper
- {
- /// <summary>
- /// 增加一条数据
- /// </summary>
- public int Add(Model.Mails model)
- {
- StringBuilder strSql = new StringBuilder();
- strSql.Append("INSERT INTO Mails(");
- strSql.Append("Title,Body,FromAddress,ToAddress,CCAddress,HTMLFormat,SenderDate,Contain,AttachmentFlag,ReaderFlag,FolderID,IsInnerEmail,UID)");
- strSql.Append(" VALUES (");
- strSql.Append("@in_Title,@in_Body,@in_FromAddress,@in_ToAddress,@in_CCAddress,@in_HTMLFormat,@in_SenderDate,@in_Contain,@in_AttachmentFlag,@in_ReaderFlag,@in_FolderID,@in_IsInnerEmail,@in_UID)");
DbParameter[] cmdParms = {
- DataBaseOAHelper.CreateInDbParameter("@in_Title", DbType.AnsiString, model.Title),
- DataBaseOAHelper.CreateInDbParameter("@in_Body", DbType.String, model.Body),
- DataBaseOAHelper.CreateInDbParameter("@in_FromAddress", DbType.String, model.FromAddress),
- DataBaseOAHelper.CreateInDbParameter("@in_ToAddress", DbType.String, model.ToAddress),
- DataBaseOAHelper.CreateInDbParameter("@in_CCAddress", DbType.String, model.CCAddress),
- DataBaseOAHelper.CreateInDbParameter("@in_HTMLFormat", DbType.Boolean, model.HTMLFormat),
- DataBaseOAHelper.CreateInDbParameter("@in_SenderDate", DbType.String, model.SenderDate),
- DataBaseOAHelper.CreateInDbParameter("@in_Contain", DbType.Int32, model.Contain),
- DataBaseOAHelper.CreateInDbParameter("@in_AttachmentFlag", DbType.Boolean, model.AttachmentFlag),
- DataBaseOAHelper.CreateInDbParameter("@in_ReaderFlag", DbType.Boolean, model.ReaderFlag),
- DataBaseOAHelper.CreateInDbParameter("@in_FolderID", DbType.Int32, model.FolderID),
- DataBaseOAHelper.CreateInDbParameter("@in_IsInnerEmail", DbType.Boolean, model.IsInnerEmail),
- DataBaseOAHelper.CreateInDbParameter("@in_UID", DbType.Int32, model.UID)};
- return DataBaseOAHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms);
- }
- /// <summary>
- /// 更新一条数据
- /// </summary>
- public int Update(Model.Mails model)
- {
- StringBuilder strSql = new StringBuilder();
- strSql.Append("UPDATE Mails SET ");
- strSql.Append("Title=@in_Title,");
- strSql.Append("Body=@in_Body,");
- strSql.Append("FromAddress=@in_FromAddress,");
- strSql.Append("ToAddress=@in_ToAddress,");
- strSql.Append("CCAddress=@in_CCAddress,");
- strSql.Append("HTMLFormat=@in_HTMLFormat,");
- strSql.Append("SenderDate=@in_SenderDate,");
- strSql.Append("Contain=@in_Contain,");
- strSql.Append("AttachmentFlag=@in_AttachmentFlag,");
- strSql.Append("ReaderFlag=@in_ReaderFlag,");
- strSql.Append("FolderID=@in_FolderID,");
- strSql.Append("IsInnerEmail=@in_IsInnerEmail,");
- strSql.Append("UID=@in_UID");
- strSql.Append(" WHERE MailID=@in_MailID");
- DbParameter[] cmdParms = {
- DataBaseOAHelper.CreateInDbParameter("@in_Title", DbType.AnsiString, model.Title),
- DataBaseOAHelper.CreateInDbParameter("@in_Body", DbType.String, model.Body),
- DataBaseOAHelper.CreateInDbParameter("@in_FromAddress", DbType.String, model.FromAddress),
- DataBaseOAHelper.CreateInDbParameter("@in_ToAddress", DbType.String, model.ToAddress),
- DataBaseOAHelper.CreateInDbParameter("@in_CCAddress", DbType.String, model.CCAddress),
- DataBaseOAHelper.CreateInDbParameter("@in_HTMLFormat", DbType.Boolean, model.HTMLFormat),
- DataBaseOAHelper.CreateInDbParameter("@in_SenderDate", DbType.String, model.SenderDate),
- DataBaseOAHelper.CreateInDbParameter("@in_Contain", DbType.Int32, model.Contain),
- DataBaseOAHelper.CreateInDbParameter("@in_AttachmentFlag", DbType.Boolean, model.AttachmentFlag),
- DataBaseOAHelper.CreateInDbParameter("@in_ReaderFlag", DbType.Boolean, model.ReaderFlag),
- DataBaseOAHelper.CreateInDbParameter("@in_FolderID", DbType.Int32, model.FolderID),
- DataBaseOAHelper.CreateInDbParameter("@in_IsInnerEmail", DbType.Boolean, model.IsInnerEmail),
- DataBaseOAHelper.CreateInDbParameter("@in_UID", DbType.Int32, model.UID),
- DataBaseOAHelper.CreateInDbParameter("@in_MailID", DbType.Int32, model.MailID)};
- return DataBaseOAHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms);
- }
- /// <summary>
- /// 删除一条数据
- /// </summary>
- public int Delete(int MailID)
- {
- StringBuilder strSql = new StringBuilder();
- strSql.Append("DELETE FROM Mails ");
- strSql.Append(" WHERE MailID=@in_MailID");
- DbParameter[] cmdParms = {
- DataBaseOAHelper.CreateInDbParameter("@in_MailID", DbType.Int32, MailID)};
- return DataBaseOAHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms);
- }
- /// <summary>
- /// 得到最大ID
- /// </summary>
- public int GetMaxId()
- {
- object obj = DataBaseOAHelper.ExecuteScalar(CommandType.Text, "SELECT MAX(MailID) FROM Mails", null);
- return DataBaseOAHelper.GetInt(obj);
- }
- /// <summary>
- /// 是否存在该记录
- /// </summary>
- public bool Exists(int MailID)
- {
- StringBuilder strSql = new StringBuilder();
- strSql.Append("SELECT COUNT(1) FROM Mails");
- strSql.Append(" WHERE MailID=@in_MailID");
- DbParameter[] cmdParms = {
- DataBaseOAHelper.CreateInDbParameter("@in_MailID", DbType.Int32, MailID)};
- object obj = DataBaseOAHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), cmdParms);
- return DataBaseOAHelper.GetInt(obj) > 0;
- }
- /// <summary>
- /// 得到一个对象实体
- /// </summary>
- public Model.Mails GetModel(int MailID)
- {
- StringBuilder strSql = new StringBuilder();
- strSql.Append("SELECT * FROM Mails ");
- strSql.Append(" WHERE MailID=@in_MailID");
- DbParameter[] cmdParms = {
- DataBaseOAHelper.CreateInDbParameter("@in_MailID", DbType.Int32, MailID)};
- Model.Mails model = null;
- using (DbDataReader dr = DataBaseOAHelper.ExecuteReader(CommandType.Text, strSql.ToString(), cmdParms))
- {
- while (dr.Read())
- {
- model = GetModel(dr);
- }
- return model;
- }
- }
- /// <summary>
- /// 获取泛型数据列表
- /// </summary>
- public List<Model.Mails> GetList()
- {
- StringBuilder strSql = new StringBuilder("SELECT * FROM Mails");
- using (DbDataReader dr = DataBaseOAHelper.ExecuteReader(CommandType.Text, strSql.ToString(), null))
- {
- List<Model.Mails> lst = GetList(dr);
- return lst;
- }
- }
- /// <summary>
- /// 得到数据条数
- /// </summary>
- public int GetCount(string condition)
- {
- return DataBaseOAHelper.GetCount("Mails", condition);
- }
- /// <summary>
- /// 分页获取泛型数据列表
- /// </summary>
- public List<Model.Mails> GetPageList(int pageSize, int pageIndex, string fldSort, bool fldDir, string condition)
- {
- using (DbDataReader dr = DataBaseOAHelper.GetPageList("Mails", pageSize, pageIndex, fldSort, fldDir, condition))
- {
- List<Model.Mails> lst = GetList(dr);
- return lst;
- }
- }
- #region -------- 私有方法,通常情况下无需修改 --------
- /// <summary>
- /// 由一行数据得到一个实体
- /// </summary>
- private Model.Mails GetModel(DbDataReader dr)
- {
- Model.Mails model = new Model.Mails();
- model.MailID = DataBaseOAHelper.GetInt(dr["MailID"]);
- model.Title = DataBaseOAHelper.GetString(dr["Title"]);
- model.Body = DataBaseOAHelper.GetString(dr["Body"]);
- model.FromAddress = DataBaseOAHelper.GetString(dr["FromAddress"]);
- model.ToAddress = DataBaseOAHelper.GetString(dr["ToAddress"]);
- model.CCAddress = DataBaseOAHelper.GetString(dr["CCAddress"]);
- model.HTMLFormat = DataBaseOAHelper.GetBool(dr["HTMLFormat"]);
- model.SenderDate = DataBaseOAHelper.GetDateTime(dr["SenderDate"]);
- model.Contain = DataBaseOAHelper.GetInt(dr["Contain"]);
- model.AttachmentFlag = DataBaseOAHelper.GetBool(dr["AttachmentFlag"]);
- model.ReaderFlag = DataBaseOAHelper.GetBool(dr["ReaderFlag"]);
- model.FolderID = DataBaseOAHelper.GetInt(dr["FolderID"]);
- model.IsInnerEmail = DataBaseOAHelper.GetBool(dr["IsInnerEmail"]);
- model.UID = DataBaseOAHelper.GetInt(dr["UID"]);
- return model;
- }
- /// <summary>
- /// 由DbDataReader得到泛型数据列表
- /// </summary>
- private List<Model.Mails> GetList(DbDataReader dr)
- {
- List<Model.Mails> lst = new List<Model.Mails>();
- while (dr.Read())
- {
- lst.Add(GetModel(dr));
- }
- return lst;
- }
- #endregion
- }
- }