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); } } }