Exemplo n.º 1
0
        /// <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);
        }