/// <summary> /// 2019-09-04发送会员公众号通知 /// </summary> public void getProductbg() { string sqlc = "select * from asm_company"; DataTable dc1 = DbHelperSQL.Query(sqlc).Tables[0]; if (dc1.Rows.Count > 0) { String time1 = DateTime.Now.ToString("HH:mm"); for (int k = 0; k < dc1.Rows.Count; k++) { if (time1 == dc1.Rows[k]["p3"].ToString()) { string sql6 = "select b.mechineName,a.* from asm_orderlistDetail a left join asm_mechine b on a.mechineid = b.id where a.createTime = '" + DateTime.Now.ToString("yyyy-MM-dd") + "' and a.zt = 4 and a.companyID = " + dc1.Rows[k]["id"].ToString(); OperUtil.Debuglog("定时执行正在执行" + sql6, "_tongzhi.txt"); DataTable dd6 = DbHelperSQL.Query(sql6).Tables[0]; if (dd6.Rows.Count > 0) { for (int i = 0; i < dd6.Rows.Count; i++) { string sqlM = "select * from asm_member where id=" + dd6.Rows[i]["memberID"].ToString(); OperUtil.Debuglog("定时执行正在执行" + sqlM, "_tongzhi.txt"); DataTable dm = DbHelperSQL.Query(sqlM).Tables[0]; if (dm.Rows.Count > 0) { wxHelper wx = new wxHelper(dd6.Rows[i]["companyID"].ToString()); string data = TemplateMessage.getProduct(dm.Rows[0]["openID"].ToString(), OperUtil.getMessageID(dd6.Rows[i]["companyID"].ToString(), "OPENTM407685552"), "亲爱的会员,您今日订购的商品还未取货", "" + dd6.Rows[i]["code"].ToString() + "", "" + dd6.Rows[i]["mechineName"].ToString() + "", "请及时取件,否则第二天会自动失效处理"); TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(dd6.Rows[i]["companyID"].ToString()), data); OperUtil.insertNotice(dm.Rows[0]["id"].ToString(), "待取货通知", "您今日订购的商品还未取货,请您及时取货否则第二天作失效处理,请前往指定的售卖机取货,取货码:" + dd6.Rows[i]["code"].ToString()); } } } } //定时检测限时特价 // clearXSTJ(dc1.Rows[k]["id"].ToString()); } } }
public void growUpMember() { //降级 string sql1 = "select * from asm_company"; DataTable dt1 = DbHelperSQL.Query(sql1).Tables[0]; if (dt1.Rows.Count > 0) { for (int i = 0; i < dt1.Rows.Count; i++) { string companyID = dt1.Rows[i]["id"].ToString(); string sql2 = "select * from asm_dj where companyID=" + dt1.Rows[i]["id"].ToString() + " order by djID"; DataTable dt2 = DbHelperSQL.Query(sql2).Tables[0]; if (dt2.Rows.Count > 0) { string day1 = dt2.Rows[0]["consumeDay"].ToString(); string day2 = dt2.Rows[1]["consumeDay"].ToString(); string day3 = dt2.Rows[2]["consumeDay"].ToString(); string sql = "select * from [dbo].[View_member_consumeCount30] where companyID=" + companyID + " and num>=" + day1 + " and num<" + day2 + " and phone!='' and phone is not null and hjhyDays=0"; DataTable dt = DbHelperSQL.Query(sql).Tables[0]; List <string> list = new List <string>(); for (int a = 0; a < dt.Rows.Count; a++) { if (dt.Rows[a]["dj"].ToString() != "1") { if (!string.IsNullOrEmpty(dt.Rows[a]["openID"].ToString())) { try { wxHelper wx = new wxHelper(dt1.Rows[0]["id"].ToString()); string data = TemplateMessage.getDJChange(dt.Rows[a]["openID"].ToString(), OperUtil.getMessageID(dt1.Rows[0]["id"].ToString(), "OPENTM406811407"), "尊敬的会员,您的会员等级发生变更", "" + dt.Rows[a]["dj"].ToString() + "", "1", "如有疑问,请拨打会员服务热线" + dt1.Rows[i]["customerPhone"].ToString()); string result = TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(dt1.Rows[i]["id"].ToString()), data); Util.Debuglog("发送消息模板=" + dt.Rows[a]["openID"].ToString() + ";result=" + result, "会员等级消息模板.txt"); } catch (Exception e) { Util.Debuglog("e=" + e.Message, "会员等级消息模板.txt"); } } } list.Add("update asm_member set dj=1 where id=" + dt.Rows[a]["id"].ToString()); } DbHelperSQL.ExecuteSqlTran(list); sql = "select * from [dbo].[View_member_consumeCount30] where companyID=" + companyID + " and num>=" + day2 + " and num<" + day3 + " and phone!='' and phone is not null and hjhyDays=0"; DataTable d2 = DbHelperSQL.Query(sql).Tables[0]; List <string> list2 = new List <string>(); for (int b = 0; b < d2.Rows.Count; b++) { if (d2.Rows[b]["dj"].ToString() != "2") { if (!string.IsNullOrEmpty(d2.Rows[b]["openID"].ToString())) { try { wxHelper wx = new wxHelper(dt1.Rows[0]["id"].ToString()); string data = TemplateMessage.getDJChange(d2.Rows[b]["openID"].ToString(), OperUtil.getMessageID(dt1.Rows[0]["id"].ToString(), "OPENTM406811407"), "尊敬的会员,您的会员等级发生变更", "" + d2.Rows[b]["dj"].ToString() + "", "2", "如有疑问,请拨打会员服务热线" + dt1.Rows[i]["customerPhone"].ToString()); string result = TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(dt1.Rows[i]["id"].ToString()), data); Util.Debuglog("发送消息模板=" + d2.Rows[b]["openID"].ToString() + ";result=" + result, "会员等级消息模板.txt"); } catch (Exception e) { Util.Debuglog("e=" + e.Message, "会员等级消息模板.txt"); } } } list2.Add("update asm_member set dj=2 where id=" + d2.Rows[b]["id"].ToString()); } DbHelperSQL.ExecuteSqlTran(list2); sql = "select * from [dbo].[View_member_consumeCount30] where companyID=" + companyID + " and num>=" + day3 + " and phone!='' and phone is not null and hjhyDays=0"; DataTable d3 = DbHelperSQL.Query(sql).Tables[0]; List <string> list3 = new List <string>(); string aaa = ""; for (int c = 0; c < d3.Rows.Count; c++) { if (d3.Rows[c]["dj"].ToString() != "3" && !string.IsNullOrEmpty(d3.Rows[c]["openID"].ToString())) { try { wxHelper wx = new wxHelper(dt1.Rows[0]["id"].ToString()); string data = TemplateMessage.getDJChange(d3.Rows[c]["openID"].ToString(), OperUtil.getMessageID(dt1.Rows[0]["id"].ToString(), "OPENTM406811407"), "尊敬的会员,您的会员等级发生变更", "" + d3.Rows[c]["dj"].ToString() + "", "3", "如有疑问,请拨打会员服务热线" + dt1.Rows[i]["customerPhone"].ToString()); string result = TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(dt1.Rows[i]["id"].ToString()), data); Util.Debuglog("发送消息模板=" + d3.Rows[c]["openID"].ToString() + ";result=" + result, "会员等级消息模板.txt"); } catch (Exception e) { Util.Debuglog("e=" + e.Message, "会员等级消息模板.txt"); } } list3.Add("update asm_member set dj=3 where id=" + d3.Rows[c]["id"].ToString()); aaa = aaa + "update asm_member set dj=3 where id=" + d3.Rows[c]["id"].ToString(); } Util.Debuglog("list3=" + aaa, "会员等级消息模板.txt"); DbHelperSQL.ExecuteSqlTran(list3); } } } }