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