protected void Page_Load(object sender, EventArgs e)
{
//1.微信消息处理
string sDel = Request["del"];
switch (Request["f"])
{
case "xml":
MPWXReturn();
if (!string.IsNullOrWhiteSpace(Request["kfid"]))
{
WeiXinMsgInfo.FakeId = Request["kfid"];
}
break;
default:
if (!string.IsNullOrWhiteSpace(Request["openid"]))
{
WeiXinMsgInfo.OpenId = Request["openid"];
}
else if (!string.IsNullOrWhiteSpace(Request["from"]))
{
WeiXinMsgInfo.OpenId = Request["from"];
}
else
{
WritePage("不合法的请求！请不要窃取他人劳动成果，如有问题请联系QQ：5420470");
}
if (!string.IsNullOrWhiteSpace(Request["content"]))
{
WeiXinMsgInfo.Text = Request["content"];
}
if (!string.IsNullOrWhiteSpace(Request["kfid"]))
{
WeiXinMsgInfo.FakeId = Request["kfid"];
}
WeiXinMsgInfo.ToUser = Request["to"];
break;
}
ReturnInitialization();
WeiXinMsgInfo.OriginalId = Request["OriginalId"];
if (!WeiXinTool.OriginalIdIsRegUser(WeiXinMsgInfo.OriginalId))
{
WritePage("无效的Key值，请在管理后台查看完整API地址!");
}
//2.回复微信消息
WritePage(MsgServer.MsgFeedback());
}
/*ERROR CODE:
* -10011 MP帐号密码未设置
* -10001 系统错误
* 1绑定成功
* 0记录成功
*/
public static string IsBindFakeId()
{
bool bGetFans = WeiXinTool.OpenIdToFans(WeiXinMsgInfo.OpenId);
string[] aMPInfo = WeiXinTool.GetMPUserInfo(WeiXinMsgInfo.OriginalId);
WeiXinBindInfo.MPUser = aMPInfo[0];
WeiXinBindInfo.MPPass = aMPInfo[1];
Weixin_Server.Bind.Helper.WeiXinLogin.ExecLogin(WeiXinBindInfo.MPUser, WeiXinBindInfo.MPPass);
if (aMPInfo == null)
{
return("-10011");
}
WeiXinBindInfo.BreakMsg = Guid.NewGuid().ToString().Substring(0, 5);
//WeiXinBindInfo.BreakMsg = "cbe5c";
if (!bGetFans)
{
string sOutText = string.Format("您是首次使用本平台，将会为您自动注册，如果在5秒内收到绑定成功信息则代表注册成功！<a href=\"http:////Rmbz.Net\\{0}\"> </a>", WeiXinBindInfo.BreakMsg);
//MPServer mp = new MPServer();
WritePage(sOutText, false);
Thread.Sleep(2500);
string[] aFakeId = Bind.MPBind.BindFakeId(WeiXinBindInfo.BreakMsg, WeiXinBindInfo.MPUser, WeiXinBindInfo.MPPass);
if (aFakeId.Length == 2)
{
WeiXinFans.sFakeId = aFakeId[0];
string sSql = string.Format("INSERT INTO `mpserver_bridge` (`openid`, `fakeid`, `name`, `time`) VALUES ('{0}', '{1}', '{2}', '{3}')", WeiXinMsgInfo.OpenId, aFakeId[0], WeiXinTool.Base64Code(aFakeId[1]), DateTime.Now);
CDBAccess.MySqlDt(sSql);
Weixin_Server.Bind.Helper.SendMsg.SendMessageText(aFakeId[1] + " 绑定成功，现在您可以体验完整功能啦。", WeiXinFans.sFakeId);
return("1");
}
else
{
string sSql = string.Format("INSERT INTO `mpserver_bridge` (`openid`, `fakeid`, `name`, `time`) VALUES ('{0}', '{1}', '{2}', '{3}')", WeiXinMsgInfo.OpenId, 0, 0, DateTime.Now);
CDBAccess.MySqlDt(sSql);
return("-10001");
}
}
else
{
string sSql = string.Format("INSERT INTO `Push_logs` (`openid`, `text`, `do`, `datetime`, `OriginalId`) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}')", WeiXinMsgInfo.OpenId, WeiXinMsgInfo.Text, WeiXinMsgInfo.Do, DateTime.Now, WeiXinMsgInfo.OriginalId);
CDBAccess.MySqlDt(sSql);
return("0");
}
}
public void Task()
{
try
{
DateTime now = DateTime.Now;
DateTime end15 = DateTime.Now.AddMinutes(15);
DateTime end = DateTime.Now.AddDays(1);
using (DBContext db = new DBContext())
{
foreach (var meeting in db.md_seminar_meeting_main.Where(x => x.mbegintime > now && x.mbegintime < end && x.meetingmode != (int)MeetingModeTypeEnum.LargeUnderLine).ToList())
{
if (meeting.mbegintime < end15)
{
string key = meeting.mbegintime.Value.ToString() + "10";
if (db.messagelog.Any(x => x.meetingid == meeting.mid && x.key == key))
{
continue;
}
db.messagelog.Add(new messagelog()
{
meetingid = meeting.mid,
key = key
});
}
else
{
//string key = meeting.mbegintime.Value.ToString() + "24";
//if (db.messagelog.Any(x => x.meetingid == meeting.mid && x.key == key))
//{
// continue;
//}
//db.messagelog.Add(new messagelog()
//{
// meetingid = meeting.mid,
// key = key
//});
//if (meeting.mid == 794||meeting.mid==795)
//{
// db.Commit();
// continue;
//}
continue;
}
foreach (var accept in db.td_seminar_meeting_accept.Where(x => x.MId == meeting.mid).ToList())
{
string AppID = System.Configuration.ConfigurationManager.ConnectionStrings["weixin.AppID"].ConnectionString;
if (db.Publicnumber.Any(x => x.AppID == AppID))
{
Publicnumber number = db.Publicnumber.FirstOrDefault(x => x.AppID == AppID);
string accessToken = number.access_token;
int? res = WeiXinTool.sendTemplateMessage(AppID, accessToken, new
{
touser = accept.OPenID,
template_id = System.Configuration.ConfigurationManager.ConnectionStrings["tmpKey"].ConnectionString,
url = System.Configuration.ConfigurationManager.ConnectionStrings["Host"].ConnectionString + "/WeiXin/MeetingInfo/" + meeting.mid,
data = new
{
first = new
{
value = "",
color = ""
},
keyword1 = new
{
value = meeting.mtitle,
color = "#173177"
},
keyword2 = new
{
value = meeting.mbegintime.Value.ToString("yyyy-MM-dd HH:mm") + "至" + meeting.mendtime.Value.ToString("yyyy-MM-dd HH:mm"),
color = "#173177"
},
keyword3 = new
{
value = meeting.msite,
color = "#173177"
},
keyword4 = new
{
value = "",
color = "#173177"
},
remark = new
{
value = "会议即将召开，请点击查看",
color = "#173177"
},
}
});
}
}
db.Commit();
}
}
}
catch (Exception ex)
{
log.Error("推送消息错误");
log.Error(ex);
}
try
{
using (DBContext db = new DBContext())
{
log.Info("开启调研");
string AppID = System.Configuration.ConfigurationManager.ConnectionStrings["weixin.AppID"].ConnectionString;
if (db.Publicnumber.Any(x => x.AppID == AppID))
{
Publicnumber number = db.Publicnumber.FirstOrDefault(x => x.AppID == AppID);
string accessToken = number.access_token;
DateTime start = DateTime.Now.AddDays(-1);
//DateTime end = start.AddMinutes(30);&& x.mendtime < end
foreach (var meeting in db.md_seminar_meeting_main.Where(x => x.mendtime < start && x.meetingmode != (int)MeetingModeTypeEnum.LargeUnderLine && db.md_seminar_survey.Any(s => s.mid == x.mid && s.sstate == 0)).ToList())
{
log.Info("开启调研" + meeting.mid);
foreach (var survey in db.md_seminar_survey.Where(s => s.mid == meeting.mid && s.sstate == 0))
{
survey.sstate = 1;
}
db.Commit();
var openList = db.td_seminar_meeting_accept.Where(x => x.MId == meeting.mid).Select(accept => accept.OPenID).ToList().Union(db.MeetingSign.Where(m => m.meetingid == meeting.mid).Select(m => m.openid).ToList()).ToList();
foreach (var openId in openList)
{
try
{
//发送消息
var res = WeiXinTool.sendTemplateMessage(AppID, accessToken, new
{
touser = openId,
template_id = System.Configuration.ConfigurationManager.ConnectionStrings["SurveytmpKey"].ConnectionString,
url = System.Configuration.ConfigurationManager.ConnectionStrings["Host"].ConnectionString + "Authorization/SurveyData/" + meeting.mid,
data = new
{
first = new
{
value = "您好，您关注的会议有资料更新",
color = "#173177"
},
keyword1 = new
{
value = "IO在握",
color = "#173177"
},
keyword2 = new
{
value = meeting.mtitle,
color = "#173177"
},
keyword3 = new
{
value = meeting.mbegintime.Value.ToString("yyyy-MM-dd HH:mm") + "至" + meeting.mendtime.Value.ToString("yyyy-MM-dd HH:mm"),
color = "#173177"
},
keyword4 = new
{
value = meeting.msite,
color = "#173177"
},
remark = new
{
value = "您参加的会议有资料更新，请点击查看会议详情。",
color = "#173177"
}
}
});
}
catch (Exception ex)
{
log.Info("开启调研-发送模板消息失败");
log.Error(ex);
}
}
}
}
}
}
catch (Exception ex)
{
log.Info("开启调研-异常");
log.Error(ex);
}
//try
//{
// DateTime start = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 11:56:00"));
// DateTime end = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 12:12:00"));
// if (DateTime.Now > start && DateTime.Now < end)
// {
// start = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 23:59:59"));
// end = start.AddDays(1);
// using (DBContext db = new DBContext())
// {
// foreach (var meeting in db.md_seminar_meeting_main.Where(x => x.mbegintime > start && x.mbegintime < end).ToList())
// {
// foreach (var accept in db.td_seminar_meeting_accept.Where(x => x.MId == meeting.mid).ToList())
// {
// string AppID = System.Configuration.ConfigurationManager.ConnectionStrings["weixin.AppID"].ConnectionString;
// if (db.Publicnumber.Any(x => x.AppID == AppID))
// {
// Publicnumber number = db.Publicnumber.FirstOrDefault(x => x.AppID == AppID);
// string accessToken = number.access_token;
// int? res = WeiXinTool.sendTemplateMessage(AppID, accessToken, new
// {
// touser = accept.OPenID,
// template_id = System.Configuration.ConfigurationManager.ConnectionStrings["tmpKey"].ConnectionString,
// url = "http://vmeeting.bms.com.cn/QR/0",
// data = new
// {
// first = new
// {
// value = "",
// color = ""
// },
// keyword1 = new
// {
// value = meeting.mtitle,
// color = "#173177"
// },
// keyword2 = new
// {
// value = meeting.mbegintime.Value.ToString("yyyy-MM-dd HH:mm") + "至" + meeting.mendtime.Value.ToString("yyyy-MM-dd HH:mm"),
// color = "#173177"
// },
// keyword3 = new
// {
// value = meeting.msite,
// color = "#173177"
// },
// keyword4 = new
// {
// value = "",
// color = ""
// },
// remark = new
// {
// value = "会议即将召开，点击进入我的会议列表",
// color = "#173177"
// },
// }
// });
// }
// }
// }
// }
// }
//}
//catch(Exception ex)
//{
//}
}
public void PushMessageToDoctor()
{
lock (obj)
{
try
{
var templateId = System.Configuration.ConfigurationManager.ConnectionStrings["MeetingInvitationTemplateId"].ConnectionString;
DateTime now = DateTime.Now;
//DateTime end24 = now.AddHours(24);
//DateTime end72 = now.AddHours(72);
DateTime end24 = now.AddMinutes(24 * 60);
DateTime end48 = now.AddMinutes(48 * 60);
using (DBContext db = new DBContext())
{
string AppID = System.Configuration.ConfigurationManager.ConnectionStrings["weixin.AppID"].ConnectionString;
if (db.Publicnumber.Any(x => x.AppID == AppID))
{
Publicnumber number = db.Publicnumber.FirstOrDefault(x => x.AppID == AppID);
string accessToken = number.access_token;
var meetingList = db.md_seminar_meeting_main.Where(x => x.mbegintime < end48 && (!x.pushCount.HasValue || x.pushCount.Value != 2) && x.meetingmode == (int)MeetingModeTypeEnum.LargeUnderLine).ToList();
foreach (var meeting in meetingList)
{
if (string.IsNullOrEmpty(meeting.mhyrc_type))
{
continue;
}
if (!string.IsNullOrEmpty(meeting.createtime) && meeting.mbegintime < Convert.ToDateTime(meeting.createtime).AddHours(24))
{
continue;
}
var doctorList = db.table_input.Where(t => t.mcode == meeting.mcode && t.ModelType == "邀请文件").ToList();
var networkIdList = doctorList.Select(d => d.networkid).ToList();
var doctorCodeList = db.sfe_register.Where(s => networkIdList.Contains(s.NETWORK_EXTERNAL_ID_BMS_CN__C) && s.doc_code != null).Select(s => s.doc_code).ToList();
var openIdList = db.UserInfo.Where(u => doctorCodeList.Contains(u.doctorCode)).Select(u => u.openid).ToList();
if (meeting.mbegintime > end24 && meeting.mbegintime < end48 && (!meeting.pushCount.HasValue || meeting.pushCount.Value == 0))
{
if (!string.IsNullOrEmpty(meeting.createtime) && meeting.mbegintime < Convert.ToDateTime(meeting.createtime).AddHours(48))
{
continue;
}
foreach (var openid in openIdList)
{
//发送消息
var res = WeiXinTool.sendTemplateMessage(AppID, accessToken, new
{
touser = openid,
template_id = templateId,
url = System.Configuration.ConfigurationManager.ConnectionStrings["qrHost"].ConnectionString + "WeiXin/MyMeetingSchedule/" + meeting.mid,
data = new
{
//first = new
//{
// value = "",
// color = ""
//},
keyword1 = new
{
value = meeting.mtitle,
color = "#173177"
},
keyword2 = new
{
value = (meeting.mbegintime)?.ToString("yyyy年MM月dd日 HH:mm"),
color = "#173177"
},
keyword3 = new
{
value = meeting.msite,
color = "#173177"
},
keyword4 = new
{
value = "邀请您参加会议，请点击进入查看会议邀请函。",
color = "#173177"
}
//remark = new
//{
// value = "邀请您参加会议，请点击进入查看会议邀请。",
// color = "#173177"
//}
}
});
}
meeting.pushCount = 1;
}
else if (meeting.mbegintime < end24 && meeting.mbegintime > now)
{
if (!meeting.pushCount.HasValue || meeting.pushCount.Value == 0)
{
foreach (var openid in openIdList)
{
//发送消息
var res = WeiXinTool.sendTemplateMessage(AppID, accessToken, new
{
touser = openid,
template_id = templateId,
url = System.Configuration.ConfigurationManager.ConnectionStrings["qrHost"].ConnectionString + "WeiXin/MyMeetingSchedule/" + meeting.mid,
data = new
{
//first = new
//{
// value = "",
// color = ""
//},
keyword1 = new
{
value = meeting.mtitle,
color = "#173177"
},
keyword2 = new
{
value = (meeting.mbegintime)?.ToString("yyyy年MM月dd日 HH:mm"),
color = "#173177"
},
keyword3 = new
{
value = meeting.msite,
color = "#173177"
},
keyword4 = new
{
value = "邀请您参加会议，请点击进入查看会议邀请函。",
color = "#173177"
}
//remark = new
//{
// value = "邀请您参加会议，请点击进入查看会议邀请。",
// color = "#173177"
//}
}
});
}
meeting.pushCount = 2;
}
else if (meeting.pushCount == 1)
{
foreach (var openid in openIdList)
{
//发送消息
var res = WeiXinTool.sendTemplateMessage(AppID, accessToken, new
{
touser = openid,
template_id = templateId,
url = System.Configuration.ConfigurationManager.ConnectionStrings["qrHost"].ConnectionString + "WeiXin/MyMeetingSchedule/" + meeting.mid,
data = new
{
//first = new
//{
// value = "",
// color = ""
//},
keyword1 = new
{
value = meeting.mtitle,
color = "#173177"
},
keyword2 = new
{
value = (meeting.mbegintime)?.ToString("yyyy年MM月dd日 HH:mm"),
color = "#173177"
},
keyword3 = new
{
value = meeting.msite,
color = "#173177"
},
keyword4 = new
{
value = "邀请您参加会议，请点击进入查看会议邀请函。",
color = "#173177"
}
//remark = new
//{
// value = "邀请您参加会议，请点击进入查看会议邀请。",
// color = "#173177"
//}
}
});
}
meeting.pushCount = 2;
}
}
}
db.Commit();
}
}
}
catch (Exception ex)
{
}
}
}
