???

?? ??? ???? ??? ??? ??? ?? ? ?? ????. ? ????? ??? ???? ??? ?????.

???? ??? ??? ?? ?? ??? ?? ????

? ?? ????? ?? ??? ?? ???? ???

????

?? ?? ??? ???? ???? ?? ????? ???? ?? ?????:

??? ??

????? ??? , ???? ??? ? ????. 3?? ???? ? ? ????: ??? ???, ?? ???, ?? ???

??? ???: ?? ???

?? ???: ???, ???, ?? ?

?? ??? : ???, ???, ??(?? ??, ?? ??)

? ?? ???? ?? ????: ?? ???, ??? ???(+ ?? ??)

? ??? ?? ??? ??? : ??? ??? (+ ?? ?? + ?? ??)

??? ??? ????? ?? ???? ?? ??? ??? ????. ?? ??? ???? ?? ??? ????? ?? ???? ????. . ?? ???

CREATE TABLE [dbo].[WC_MessageResponse](    [Id] [varchar](50) NOT NULL,              --主鍵        
    [OfficalAccountId] [varchar](50) NULL,    --所屬公眾號
    [MessageRule] [int] NULL,                 --消息規(guī)則（枚舉）
    [Category] [int] NULL,                    --類型（枚舉）
    [MatchKey] [varchar](1000) NULL,          --關(guān)鍵字
    [TextContent] [varchar](max) NULL,        --文本內(nèi)容
    [ImgTextContext] [varchar](max) NULL,     --圖文文本內(nèi)容
    [ImgTextUrl] [varchar](1000) NULL,        --圖文圖片URL
    [ImgTextLink] [varchar](1000) NULL,       --圖文圖片超鏈接
    [MeidaUrl] [varchar](1000) NULL,          --語音URL
    [MeidaLink] [varchar](1000) NULL,         --語音超鏈接
    [Enable] [bit] NOT NULL,                  --是否啟用
    [IsDefault] [bit] NOT NULL,               --是否默認(rèn)
    [Remark] [varchar](2000) NULL,            --說明
    [Sort] [int] NOT NULL,                    --排序
    [CreateTime] [datetime] NOT NULL,         --創(chuàng)建時(shí)間
    [CreateBy] [varchar](50) NOT NULL,        --創(chuàng)建人
    [ModifyTime] [datetime] NOT NULL,         --修改時(shí)間
    [ModifyBy] [varchar](50) NULL,            --修改人
 CONSTRAINT [PK_WC_MessageResponse] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]GOSET ANSI_PADDING OFFGOALTER TABLE [dbo].[WC_MessageResponse]  WITH CHECK ADD  CONSTRAINT [FK_WC_MessageResponse_WC_OfficalAcconts] FOREIGN KEY([OfficalAccountId])REFERENCES [dbo].[WC_OfficalAccounts] ([Id])ON DELETE CASCADEGOALTER TABLE [dbo].[WC_MessageResponse] CHECK CONSTRAINT [FK_WC_MessageResponse_WC_OfficalAcconts]GO

???? ???? ???? ????. ??? ?? ???? ???? ?? ???

CREATE TABLE [dbo].[WC_OfficalAccounts](    [Id] [varchar](50) NOT NULL,            --主鍵
    [OfficalId] [varchar](200) NULL,        --公眾號的唯一ID
    [OfficalName] [varchar](200) NOT NULL,    --公眾號名稱
    [OfficalCode] [varchar](200) NOT NULL,  --公眾號帳號
    [OfficalPhoto] [varchar](1000) NULL,    --頭像
    [OfficalKey] [varchar](500) NULL,        --EncodingAESKey
    [ApiUrl] [varchar](1000) NULL,            --我們的資源服務(wù)器
    [Token] [varchar](200) NULL,            --Token
    [AppId] [varchar](200) NULL,            --AppId
    [AppSecret] [varchar](200) NULL,        --Appsecret
    [AccessToken] [varchar](200) NULL,        --訪問Token
    [Remark] [varchar](2000) NULL,            --說明
    [Enable] [bit] NOT NULL,                --是否啟用
    [IsDefault] [bit] NOT NULL,                --是否為當(dāng)前默認(rèn)操作號
    [Category] [int] NOT NULL,                --類別（媒體號，企業(yè)號，個(gè)人號，開發(fā)測試號）
    [CreateTime] [datetime] NOT NULL,        --創(chuàng)建時(shí)間
    [CreateBy] [varchar](50) NOT NULL,        --創(chuàng)建人
    [ModifyTime] [datetime] NOT NULL,        --修改時(shí)間
    [ModifyBy] [varchar](50) NULL,            --修改人
 CONSTRAINT [PK_WC_OfficalAcconts] PRIMARY KEY CLUSTERED (    [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]

?? ?? ??? 70? ??? ????

?? ???

 public enum WeChatReplyCategory
    {        //文本
        Text =1,        //圖文
        Image =2,        //語音
        Voice =3,        //相等，用于回復(fù)關(guān)鍵字
        Equal=4,        //包含，用于回復(fù)關(guān)鍵字
        Contain = 5
    }    public enum WeChatRequestRuleEnum
    {        /// <summary>
        /// 默認(rèn)回復(fù)，沒有處理的        /// </summary>
        Default =0,        /// <summary>
        /// 關(guān)注回復(fù)        /// </summary>
        Subscriber =1,        /// <summary>
        /// 文本回復(fù)        /// </summary>
        Text =2,        /// <summary>
        /// 圖片回復(fù)        /// </summary>
        Image =3,        /// <summary>
        /// 語音回復(fù)        /// </summary>
        Voice =4,        /// <summary>
        /// 視頻回復(fù)        /// </summary>
        Video =5,        /// <summary>
        /// 超鏈接回復(fù)        /// </summary>
        Link =6,        /// <summary>
        /// LBS位置回復(fù)        /// </summary>
        Location =7,
    }

???? ??? ?? ??? ?? ? ???? ?????

At ? ??? ???? ???? ?? ????? ?????

??? ??

??, ??, ?? ? ??? ?? ??????. ?? ?????? ????. ??? ??? ??? ???? ???? ???? ?? ??? ???? ??? ??? ???? ???

[HttpPost]
        [SupportFilter(ActionName = "Edit")]        public JsonResult PostData(WC_MessageResponseModel model)
        {
            WC_OfficalAccountsModel accountModel = account_BLL.GetCurrentAccount();            if (string.IsNullOrEmpty(model.Id))
            {
                model.Id = ResultHelper.NewId;
            }
            
            model.CreateBy = GetUserId();
            model.CreateTime = ResultHelper.NowTime;
            model.ModifyBy = GetUserId();
            model.ModifyTime = ResultHelper.NowTime;
            model.OfficalAccountId = accountModel.Id;
            model.Enable = true;
            model.IsDefault = true;            if (m_BLL.PostData(ref errors, model))
            {
                LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",OfficalAccountId" + model.OfficalAccountId, "成功", "保存", "WC_MessageResponse");                return Json(JsonHandler.CreateMessage(1, Resource.SaveSucceed));
            }            else
            {                string ErrorCol = errors.Error;
                LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",OfficalAccountId" + model.OfficalAccountId + "," + ErrorCol, "失敗", "保存", "WC_MessageResponse");                return Json(JsonHandler.CreateMessage(0, Resource.SaveFail + ErrorCol));
            }

        }

????

BLL

public bool PostData(ref ValidationErrors errors, WC_MessageResponseModel model)
        {            try
            {

                WC_MessageResponse entity = new WC_MessageResponse();                if (IsExists(model.Id))
                {
                    entity = m_Rep.GetById(model.Id);
                }

                entity.Id = model.Id;
                entity.OfficalAccountId = model.OfficalAccountId;
                entity.MessageRule = model.MessageRule;
                entity.Category = model.Category;
                entity.MatchKey = model.MatchKey;
                entity.TextContent = model.TextContent;
                entity.ImgTextContext = model.ImgTextContext;
                entity.ImgTextUrl = model.ImgTextUrl;
                entity.ImgTextLink = model.ImgTextLink;
                entity.MeidaUrl = model.MeidaUrl;
                entity.Enable = model.Enable;
                entity.IsDefault = model.IsDefault;
                entity.Remark = model.Remark;
                entity.CreateTime = model.CreateTime;
                entity.CreateBy = model.CreateBy;
                entity.Sort = model.Sort;
                entity.ModifyTime = model.ModifyTime;
                entity.ModifyBy = model.ModifyBy;                if (m_Rep.PostData(entity))
                {                    return true;
                }                else
                {
                    errors.Add(Resource.NoDataChange);                    return false;
                }

            }            catch (Exception ex)
            {
                errors.Add(ex.Message);
                ExceptionHander.WriteException(ex);                return false;
            }
        }

DAL

DAL ???? ?? ??? ?????

?? ??? 3?? ??? ?? ????- ?? ??: ???, ??? ? ??? ? ??(??? ??? ?? ? ???? ?? ??? ??? ????? ???? IsDefault ??? ??) ??? ? ? ??? ??? ????? ?? ?? ???? ??? ? ????. DAL ??? ?? ??? SQL ?? ?????.

?? ?????? ??? ??????!

?????? ??? ???????

????? ???????:

????? ?? ??

  public bool PostData(WC_MessageResponse model)
        {            //如果所有開關(guān)都關(guān)掉，證明不啟用回復(fù)
            if (model.Category == null)
            {                return true;
            }            //全部設(shè)置為不默認(rèn)
            ExecuteSqlCommand(string.Format("update [dbo].[WC_MessageResponse] set IsDefault=0 where OfficalAccountId ='{0}' and MessageRule={1}", model.OfficalAccountId, model.MessageRule));            //默認(rèn)回復(fù)和訂閱回復(fù),且不是圖文另外處理，因?yàn)樗麄冇?種模式，但是只有一個(gè)是默認(rèn)的
            if (model.Category!= (int)WeChatReplyCategory.Image && (model.MessageRule == (int)WeChatRequestRuleEnum.Default || model.MessageRule == (int)WeChatRequestRuleEnum.Subscriber))
            {                //查看數(shù)據(jù)庫是否存在數(shù)據(jù)
                var entity = Context.WC_MessageResponse.Where(p => p.OfficalAccountId == model.OfficalAccountId && p.MessageRule == model.MessageRule && p.Category == model.Category).FirstOrDefault();                if (entity != null)
                {                    //刪除原來的                    Context.WC_MessageResponse.Remove(entity);
                }
            }            //全部設(shè)置為默認(rèn)
            ExecuteSqlCommand(string.Format("update [dbo].[WC_MessageResponse] set IsDefault=1 where OfficalAccountId ='{0}' and MessageRule={1} and Category={2}", model.OfficalAccountId, model.MessageRule,model.Category));            //修改
            if(IsExist(model.Id))
            {
               Context.Entry<WC_MessageResponse>(model).State = EntityState.Modified;               return Edit(model);
            }            else { 
               return Create(model);
            }
        }

?? ??

??? ????? ???? ????? ??? ??? ???? ?? ??? ??? ? ????

??

??? ??? ?? ?????

1. ???? ?? ?? ??? ?? ?? ?? ??? ????? ???. ??? ??? ???? ??? ?? ??? ?????. ??

2. ??? ???? ????? ?? ???? ?? ??? ????.

?: ???: (????) ??: 1?? ?? ?????. ??, 2?? ??? 50??

　???: (1) ??: 3?? ??? ????, 4?? ??? ???

　???: ( 3 ?? 4) ??: ??, ???? ? ????? ??? ?????

??? ???? ???? ??? ?? ??? ??? ????? ?? ???? ??? ??? ???? ???

? ??? ASP.NET MVC5+EF6+EasyUI ??? ?? ??? WeChat ?? ??? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!