/// <summary>
/// 发送消息业务（短信，微信）
/// </summary>
private void ActivitySendMessige()
{
#region Business Object
var ActivityBLL = new C_ActivityBLL(c_loggingSessionInfo);
var MessageSendBLL = new C_MessageSendBLL(c_loggingSessionInfo);
var ActivityMessageBLL = new C_ActivityMessageBLL(c_loggingSessionInfo);
var CommonBLL = new CommonBLL();
#endregion
#region 获取所有营销活动
List <IWhereCondition> complexCondition = new List <IWhereCondition> {
};
complexCondition.Add(new EqualsCondition()
{
FieldName = "CustomerID", Value = c_loggingSessionInfo.ClientID
});
//complexCondition.Add(new DirectCondition(" ((IsLongTime=1 and GETDATE()>=StartTime) OR (GETDATE()>=StartTime AND GETDATE()<=EndTime)) AND STATUS=0 and IsDelete=0 "));
complexCondition.Add(new DirectCondition(" (IsLongTime=1 or (IsLongTime=0 and GETDATE()<=EndTime)) and STATUS=0 and IsDelete=0 "));
var ActivityList = ActivityBLL.Query(complexCondition.ToArray(), null);//营销活动
#endregion
//轮循活动获取到当前活动与发送短信，微信消息集合
foreach (var item in ActivityList)
{
//预发送消息源
var ActivityMessageList = ActivityMessageBLL.QueryByEntity(new C_ActivityMessageEntity()
{
ActivityID = item.ActivityID
}, null).ToList();
var ActivitySMSMessageList = new List <C_ActivityMessageEntity>(); //短信消息集合
var ActivityWeChatMessageList = new List <C_ActivityMessageEntity>(); //微信消息集合
ActivitySMSMessageList = ActivityMessageList.Where(m => m.MessageType.Trim().Equals("SMS")).ToList();
ActivityWeChatMessageList = ActivityMessageList.Where(m => m.MessageType.Trim().Equals("WeChat")).ToList();
//遍历消息集合，调用发送消息方法
#region 发送短信
string content = "";
string mobile = "";
foreach (var SMSMessage in ActivitySMSMessageList)
{
List <IWhereCondition> MessageCondition = new List <IWhereCondition> {
};
//获取未发送的信息
MessageCondition.Add(new DirectCondition("MessageID='" + SMSMessage.MessageID + "' and IsSend <>2 order by Priority desc "));
var MessageSendList = MessageSendBLL.Query(MessageCondition.ToArray(), null).ToList().Take(5000).ToList();
StringBuilder PhoneStr = new StringBuilder();
//群发短信接口对象
api api1 = new api();
if (MessageSendList.Count > 100)
{
#region 大于一百条
foreach (var MessageSend in MessageSendList)
{
if (MessageSend.SendTime <= DateTime.Now)
{
PhoneStr.Append(MessageSend.Phone + ",");//手机号
}
if (string.IsNullOrWhiteSpace(content))
{
content = "尊敬的会员," + SMSMessage.Content + "回TD退订【连锁掌柜】"; //消息内容
}
mobile = PhoneStr.ToString(); //手机号
}
mobile = mobile.TrimEnd(',');
//调用群发发送短信接口
SendSmsResult SendSmsResult1 = api1.SendSms("hy_znxx", "znxx", content, mobile, "", "17");
//事物对象
var pTran = ActivityBLL.GetTran();
using (pTran.Connection)
{
try
{
if (SendSmsResult1.code == 2)
{//发送成功
foreach (var updateItem in MessageSendList)
{
updateItem.ActualSendTime = DateTime.Now;
updateItem.IsSend = 2;
updateItem.SendNumber++;
MessageSendBLL.Update(updateItem, pTran);
}
}
else
{//失败
foreach (var updateItem in MessageSendList)
{
updateItem.SendNumber++;
updateItem.Priority = 1;
MessageSendBLL.Update(updateItem, pTran);
}
}
//提交
pTran.Commit();
System.Threading.Thread.Sleep(2000); // 1秒为单位
}
catch (Exception ex)
{
pTran.Rollback();
throw ex;
}
}
#endregion
}
//else
//{
#region 单发
// foreach (var MessageSend in MessageSendList)
// {
// if (MessageSend.SendTime < DateTime.Now)
// {
// //移动手机号不能单发
// string yidong = @"^1(34[0-8]|(3[5-9]|5[017-9]|8[278])\\d)\\d{7}$";
// Regex YD = new Regex(yidong);
// if (YD.IsMatch(MessageSend.Phone))
// continue;
// string NewContent = "尊敬的会员," + MessageSend.Content + "回TD退订【连锁掌柜】";
// //调用群发发送短信接口
// SendSmsResult SendSmsResult2 = api1.SendSms("hy_znxx", "znxx", NewContent, MessageSend.Phone, "", "17");
// if (SendSmsResult2.code == 2)
// {//发送成功
// MessageSend.ActualSendTime = DateTime.Now;
// MessageSend.IsSend = 2;
// MessageSend.SendNumber++;
// MessageSendBLL.Update(MessageSend);
// }
// else
// {//失败
// MessageSend.SendNumber++;
// MessageSend.Priority = 1;
// MessageSendBLL.Update(MessageSend);
// }
// }
// }
#endregion
//}
}
#endregion
#region 发送微信
foreach (var Weitem in ActivityWeChatMessageList)
{
List <IWhereCondition> WeMessageCondition = new List <IWhereCondition> {
};
//获取预发送的微信
WeMessageCondition.Add(new DirectCondition("MessageID='" + Weitem.MessageID + "' and IsSend =0 order by Priority desc "));
var WeMessageSendList = MessageSendBLL.Query(WeMessageCondition.ToArray(), null).ToList().Take(10000);
List <string> OpenIDList = new List <string>();
string WXcontent = "";
foreach (var WeMessageSend in WeMessageSendList)
{
if (WeMessageSend.SendTime <= DateTime.Now)
{
OpenIDList.Add(WeMessageSend.OpenID);
}
if (string.IsNullOrWhiteSpace(WXcontent))
{
WXcontent = WeMessageSend.Content;
}
}
if (OpenIDList.Count > 1)
{
//调用
string Json = CommonBLL.BulkSendWXTemplateMessage(OpenIDList.ToArray(), WXcontent, c_loggingSessionInfo);
if (!string.IsNullOrWhiteSpace(Json))
{
var Data = JsonHelper.JsonDeserialize <Result>(Json);
//事物对象
var pTranWX = ActivityBLL.GetTran();
using (pTranWX.Connection)
{
try
{
if (Data.errcode == 0)
{
foreach (var WXUpdateitem in WeMessageSendList)
{
WXUpdateitem.ActualSendTime = DateTime.Now;
WXUpdateitem.IsSend = 2;
WXUpdateitem.SendNumber++;
MessageSendBLL.Update(WXUpdateitem, pTranWX);
}
}
else
{//失败
foreach (var WXUpdateitem in WeMessageSendList)
{
WXUpdateitem.SendNumber++;
WXUpdateitem.Priority = 1;
WXUpdateitem.IsSend = 3;
MessageSendBLL.Update(WXUpdateitem, pTranWX);
}
}
//提交
pTranWX.Commit();
System.Threading.Thread.Sleep(2000); // 5秒为单位
}
catch (Exception ex)
{
pTranWX.Rollback();
throw ex;
}
}
}
}
}
#endregion
#region 发送邮件
#endregion
}
}
