/// <summary> /// 邀请关注成功通知(发送给邀请人/被邀请人) /// </summary> /// <param name="openid"></param> /// <param name="fid"></param> public void YaoQingGuanZhu(string openid, string fid) { ConfigModel cf = new ConfigModel(); AttentionHelp ah = new AttentionHelp(); SqlHelperModel her = new SqlHelperModel(); DateTime time = System.DateTime.Now; TemplateMsg tm = new TemplateMsg(); //查找被邀请人 string sql1 = "select nID, nickname from ML_Member where openid='" + openid + "'"; DataTable dt1 = her.ExecuteDataTable(sql1); string nIDStu = dt1.Rows[0]["nID"] == null ? "" : dt1.Rows[0]["nID"].ToString(); string nicknameStu = dt1.Rows[0]["nickname"] == null ? "" : dt1.Rows[0]["nickname"].ToString(); //查找邀请人 string sql2 = "select nickname,openid from ML_Member where nID=" + fid; DataTable dt2 = her.ExecuteDataTable(sql2); string nicknameFat = dt2.Rows[0]["nickname"] == null ? "" : dt2.Rows[0]["nickname"].ToString(); string openidFat = dt2.Rows[0]["openid"] == null ? "" : dt2.Rows[0]["openid"].ToString(); //获取时间 string longdate = time.ToLongDateString().ToString(); string shorttime = time.ToShortTimeString().ToString(); //发送给邀请人 ah.AttentionInsert(nIDStu, fid, Convert.ToInt32(cf.gzPart)); tm.InvitationFollow(openidFat, fid, nicknameStu, cf.gzPart.ToString(), nicknameFat, longdate + " " + shorttime); //发送给被邀请人 ah.AttentionInserted(nIDStu, fid, Convert.ToInt32(cf.gzFirst)); tm.InvitationFollowed(openid, nIDStu, nicknameStu, cf.gzFirst.ToString(), nicknameFat, longdate + " " + shorttime); }