Hidistro.SqlDal/Store/MessageTemplateDao.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

namespace Hidistro.SqlDal.Store
{
    using Hidistro.Entities.VShop;
    using Microsoft.Practices.EnterpriseLibrary.Data;
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Common;

    public class MessageTemplateDao
    {
        private Database database = DatabaseFactory.CreateDatabase();

        public List<string> GetAdminUserMsgList(string MsgFieldName)
        {
            List<string> list = new List<string>();
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand("select * from Hishop_MessageAdminUserMsgList WHERE isnull(" + MsgFieldName + ",0) = 1 ");
            using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
            {
                while (reader.Read())
                {
                    list.Add((string) reader["UserOpenId"]);
                }
                reader.Close();
            }
            return list;
        }

        public MessageTemplate GetMessageTemplate(string messageType)
        {
            MessageTemplate template = null;
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_MessageTemplates WHERE LOWER(MessageType) = LOWER(@MessageType)");
            this.database.AddInParameter(sqlStringCommand, "MessageType", DbType.String, messageType);
            using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
            {
                while (reader.Read())
                {
                    template = this.PopulateEmailTempletFromIDataReader(reader);
                }
                reader.Close();
            }
            return template;
        }

        public MessageTemplate GetMessageTemplateByDetailType(string DetailType)
        {
            MessageTemplate template = null;
            DbCommand sqlStringCommand = this.database.GetSqlStringCommand("  select a.DetailType, a.DetailName, a.AllowToAdmin,a.AllowToDistributor,a.AllowToMember, a.IsSelectedByDistributor,a.IsSelectedByMember,\r\n                    b.* from Hishop_MessageTemplatesDetail a \r\n                left join Hishop_MessageTemplates b on a.MessageType= b.MessageType\r\n                where b.MessageType is not null and isnull(b.IsValid,0)=1\r\n                    and  LOWER(DetailType) = LOWER(@DetailType)");
            this.database.AddInParameter(sqlStringCommand, "DetailType", DbType.String, DetailType);
            using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
            {
                while (reader.Read())
                {
                    template = this.PopulateEmailTempletFromIDataReader(reader);
                }
                reader.Close();
            }
            return template;
        }