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