public override void Run()
{
string strsql = "exec usp_rims_wx_notifydoctor @cxlb=2";
DataTable dt = GlobalInstanceManager <GlobalSqlManager> .Intance.GetDataTable(this.Cur_Job.dbtype, this.Cur_Job.dbstring, strsql);
if (dt == null || dt.Rows.Count <= 0)
{
return;
}
var list = dt.AsEnumerable().GroupBy(a => new { ysdm = a["ysdm"].ToString(), ysmc = a["ysmc"].ToString(),
idNo = a["wxsbh"].ToString(), idType = a["wxklx"].ToString(), content = a["txnr"].ToString() }).
Select(a => new { ysdm = a.Key.ysdm, ysmc = a.Key.ysmc, idNo = a.Key.idNo, idType = a.Key.idType, content = a.Key.content, list = a.ToList() });
foreach (var item in list)
{
FszyyWeChatMessage msg = new FszyyWeChatMessage();
msg.url = "";
msg.content = item.content;
msg.idNo = item.idNo;
msg.idType = item.idType;
string result = this.PostRequest(JsonConvert.SerializeObject(msg));
Log4netUtil.Info("作业【" + this.Cur_Job.name + "】返回值：" + result);
FszyyWeChatResult fr = JsonConvert.DeserializeObject <FszyyWeChatResult>(result);
if (fr != null && fr.code == "0")
{
strsql = "exec usp_rims_wx_notifydoctor @cxlb=1,@txxh='" + string.Join(",", item.list.Select(a => a["xh"].ToString())) + "'";
DataTable redt = GlobalInstanceManager <GlobalSqlManager> .Intance.GetDataTable(this.Cur_Job.dbtype, this.Cur_Job.dbstring, strsql);
}
}
}
public override void Run()
{
string strsql = "exec usp_rims_wx_notifypatient";
DataTable dt = GlobalInstanceManager <GlobalSqlManager> .Intance.GetDataTable(this.Cur_Job.dbtype, this.Cur_Job.dbstring, strsql);
if (dt == null || dt.Rows.Count <= 0)
{
return;
}
var list = dt.AsEnumerable().GroupBy(a => new
{
patid = a["patid"].ToString(),
yydm = a["yydm"].ToString(),
xtbz = a["xtbz"].ToString(),
idNo = a["wxsbh"].ToString(),
idType = a["wxklx"].ToString(),
hzxm = a["hzxm"].ToString()
}).Select(a => new
{
hzxm = a.Key.hzxm,
patid = a.Key.patid,
yydm = a.Key.yydm,
xtbz = a.Key.xtbz,
idNo = a.Key.idNo,
idType = a.Key.idType,
list = a.ToList()
});
foreach (var item in list)
{
FszyyWeChatMessage msg = new FszyyWeChatMessage();
string content = "您好，" + item.hzxm + ":您有新治疗需要预约，点击此消息，即可进入预约界面";
//msg.url = "https://wx.fshtcm.com.cn/pat-web/s/oauth/authorize?entry=rims&client=wx";
msg.url = string.Format("http://rims.fshtcm.com.cn/medicalAppointments/orderRecod?PATIENTID={0}&HOSPITALCODE={1}&XTBZ={2}", item.patid, item.yydm, item.xtbz);
msg.content = content;
msg.idNo = item.idNo;
msg.idType = item.idType;
string result = this.PostRequest(JsonConvert.SerializeObject(msg));
Log4netUtil.Info("作业【" + this.Cur_Job.name + "】返回值：" + result);
FszyyWeChatResult fr = JsonConvert.DeserializeObject <FszyyWeChatResult>(result);
if (fr != null && fr.code == "0")
{
strsql = "exec usp_rims_wx_notifypatient @cxlb=1,@txxh='" + string.Join(",", item.list.Select(a => a["xh"].ToString())) + "'";
DataTable redt = GlobalInstanceManager <GlobalSqlManager> .Intance.GetDataTable(this.Cur_Job.dbtype, this.Cur_Job.dbstring, strsql);
}
}
}
