public string SendWXMes(string wxid, string title, string description, string rwmc, string xgry, string url)
{
my_woa wx = new my_woa();
wx.userId = wxid;
wx.title = title;
wx.description = description;
wx.rwmc = rwmc;
wx.xgry = xgry;
wx.url2 = url;
retmsg ret = new Bll.wx.wx().SendMsg_mb_woarwtx(wx);
if (ret.flag == "err")
{
return("error" + ret.message);
}
return("ok");
}
public string getWXUser()
{
//获取微信关注列表
wx_user list2 = new Bll.wx.wx().GetWXUser_list();
if (string.IsNullOrEmpty(list2.count))
{
list2.count = "0";
}
if (int.Parse(list2.count) < 1)
{
return("获取列表失败，或者没有关注者");
}
List <t_wx_user> list = new List <t_wx_user>();
//获取用户详情
foreach (var i in list2.data.openid)
{
wx_user_detail wxuser = new Bll.wx.wx().GetWXUser_detail(i);
t_wx_user model = new t_wx_user();
model.wxgzh = "xxkj";
model.openid = wxuser.openid;
model.nickname = wxuser.nickname;
model.sex = wxuser.sex;
model.city = wxuser.city;
model.country = wxuser.country;
model.province = wxuser.province;
model.remark = wxuser.remark;
model.groupid = wxuser.groupid;
model.ts = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
list.Add(model);
}
SqlConnection conn = new SqlConnection(Dal.DataHelper.constr);
conn.Open();
SqlTransaction tran = conn.BeginTransaction();
try
{
//删除之前记录
DataHelper.ExcuteNonQuery("delete from t_wx_user", tran, null, false);
foreach (var i in list)
{
new Dal.Basedata.t_wx_userDal().Add(i, tran);
}
tran.Commit();
conn.Close();
return("成功");
}
catch (Exception ex)
{
tran.Rollback();
conn.Close();
return(ex.Message);
}
}
