/// <summary> /// 群发消息发送完成后,更新数据库D:\EG_Project_Simgle\QYWechat\trunk\Standard\trunk\EG.WeChat.Standard\EG.WeChat.Web\Controllers\QY\QYConfigController.cs /// </summary> /// <param name="messageid"></param> /// <param name="userId"></param> /// <param name="pSendType"></param> /// <param name="targetUsers"></param> /// <returns></returns> private bool UpdateGsMessageAfterSend(string messageid, string userId, int pSendType, string targetUsers, string pLog) { int imessageid = -1; if (!int.TryParse(messageid, out imessageid)) { return(false); } if (imessageid < 1) { return(false); } WXGsMessageDA pDa = new WXGsMessageDA(); return(pDa.UpdateGsMessage(imessageid, userId, DateTime.Now, pSendType, targetUsers, 3, pLog)); }
/// <summary> /// 获取所有群发消息 /// </summary> public List <T> GetAllGsMessage <T>() { List <T> pList = new List <T>(); this.ExecuteTryCatch(() => { WXGsMessageDA pDa = new WXGsMessageDA(); //获取从服务器当天时间算起,的两个月时间内的群发消息,例如:当天为10月,即是获得9、10月的消息记录 string strDateFilter = GetTargetDateFilter(WXGsMessageDA.FIELD_NAME_MTIME, 1); DataTable dt = pDa.GetGsMessage(strDateFilter, m_sdk.WXType); if (dt == null || dt.Rows.Count == 0) { EGExceptionOperator.ThrowX <Exception>("缺少群发消息数据", EGActionCode.缺少目标数据); } pList = CommonFunction.GetEntitiesFromDataTable <T>(dt); }); return(pList); }
/// <summary> /// 创建群发消息,并加入到待审核队列 /// </summary> /// <param name="pUserID">用戶編號</param> /// <param name="mediaId">媒體ID</param> /// <param name="sendType">發送對象類型</param> /// <param name="sendTarget">發送目標對象</param> /// <param name="content">內容</param> /// <param name="messageType">內容類型</param> public void CreateGsMessage(string pUserID, string mediaId, int sendType, string sendTarget, string content, string messageType, int wx_type, int agendid, int safe) { this.ExecuteTryCatch(() => { bool iResult = false; WXGsMessageDA pDa = new WXGsMessageDA(); if (messageType == "text") { iResult = pDa.InsertGsMessage(pUserID, DateTime.Now, sendType, sendTarget, messageType, content, 1, wx_type, agendid, safe); } else { iResult = pDa.InsertGsMessage(pUserID, DateTime.Now, sendType, sendTarget, messageType, mediaId, 1, wx_type, agendid, safe); } if (!iResult) { EGExceptionOperator.ThrowX <Exception>("群发消息加入队伍错误", EGActionCode.数据库表保存错误); } }); }
/// <summary> /// 获取所有群发消息 /// </summary> public List <T> GetGsMessage <T>(string pFilter) { List <T> pList = new List <T>(); this.ExecuteTryCatch(() => { WXGsMessageDA pDa = new WXGsMessageDA(); //转换前端查询目标 List <object> pQueryItems = CommonFunction.FromJsonTo <List <object> >(pFilter); //转换查询字典 IDictionary <string, object> pDic = WXGsMessageDA.CreateDicItems(pQueryItems); //查询获取dATATABLE DataTable dt = pDa.GetGsMessage(pDic, m_sdk.WXType); if (dt == null || dt.Rows.Count == 0) { EGExceptionOperator.ThrowX <Exception>("缺少群发消息数据", EGActionCode.缺少目标数据); } pList = CommonFunction.GetEntitiesFromDataTable <T>(dt); }); return(pList); }