/// <summary>
/// read yonghu info
/// </summary>
/// <param name="cmd"></param>
/// <returns></returns>
Eyousoft_yhq.Model.MWeiXinYongHuInfo ReadYongHuInfo(DbCommand cmd)
{
Eyousoft_yhq.Model.MWeiXinYongHuInfo info = null;
using (var rdr = DbHelper.ExecuteReader(cmd, _db))
{
if (rdr.Read())
{
info = new Eyousoft_yhq.Model.MWeiXinYongHuInfo();
info.city = rdr["city"].ToString();
info.country = rdr["country"].ToString();
info.createtime = rdr.GetDateTime(rdr.GetOrdinal("createtime"));
info.headimgurl = rdr["headimgurl"].ToString();
info.language = rdr["language"].ToString();
info.latesttime = rdr.GetDateTime(rdr.GetOrdinal("latesttime"));
info.nickname = rdr["nickname"].ToString();
info.openid = rdr["openid"].ToString();
info.province = rdr["province"].ToString();
info.sex = rdr["sex"].ToString();
info.subscribe = rdr["subscribe"].ToString();
info.subscribe_time = rdr["subscribe_time"].ToString();
info.unionid = rdr["unionid"].ToString();
info.YongHuId = rdr["YongHuId"].ToString();
info.LeiXing = rdr.GetInt32(rdr.GetOrdinal("LeiXing"));
info.HuiYuanId = rdr["HuiYuanId"].ToString().Trim();
info.BangDingTime = rdr.GetDateTime(rdr.GetOrdinal("BangDingTime"));
}
}
return(info);
}
/// <summary>
/// 关注，取消关注，返回1成功，其它失败
/// </summary>
/// <param name="openid">openid</param>
/// <param name="subscribe">1关注 0取消关注</param>
/// <returns></returns>
public int GuanZhu(string openid, string subscribe)
{
if (string.IsNullOrEmpty(openid) || string.IsNullOrEmpty(subscribe))
{
return(0);
}
if (subscribe != "0" && subscribe != "1")
{
return(0);
}
var info = GetInfo2(openid);
if (info == null)
{
info = new Eyousoft_yhq.Model.MWeiXinYongHuInfo();
info.YongHuId = Guid.NewGuid().ToString();
info.openid = openid;
}
info.subscribe = subscribe;
info.createtime = info.latesttime = DateTime.Now;
var dalRetCode = dal.YongHu_CU(info);
return(dalRetCode);
}
protected void Page_Load(object sender, EventArgs e)
{
string weixin_appid = "";
string weixin_secret = "";
weixin_appid = Utils.GetConfigString("", "YHQAppId").Trim();
weixin_secret = Utils.GetConfigString("", "YHQAppSecret").Trim();
if (Utils.GetQueryStringValue("sync") != "1") Utils.RCWE("");
IMpClient mpClient = new MpClient();
AccessTokenGetRequest request = new AccessTokenGetRequest()
{
AppIdInfo = new AppIdInfo() { AppID = weixin_appid, AppSecret = weixin_secret }
};
AccessTokenGetResponse response = mpClient.Execute(request);
if (response.IsError)
{
Utils.RCWE("获取令牌环失败..");
}
GetAttentionsRequest request2 = new GetAttentionsRequest()
{
AccessToken = response.AccessToken.AccessToken
};
var response2 = mpClient.Execute(request2);
if (response2.IsError)
{
Utils.RCWE("获取关注者列表失败，错误信息为：" + response2.ErrInfo.ErrCode + "-" + response2.ErrInfo.ErrMsg);
}
foreach (var item in response2.Attentions.data.openid)
{
var info1 = Eyousoft_yhq.Web.BsendMsg.WeiXin.GetUserInfo(item);
var info = new Eyousoft_yhq.Model.MWeiXinYongHuInfo();
info.city = info1.City;
info.country = info1.Country;
info.createtime = DateTime.Now;
info.headimgurl = info1.HeadImgUrl;
info.language = info1.Language;
info.latesttime = DateTime.Now;
info.nickname = info1.NickName;
info.openid = info1.OpenId;
info.province = info1.Province;
info.sex = info1.Sex;
info.subscribe = info1.SubScribe;
info.subscribe_time = info1.SubscribeTime;
info.unionid = string.Empty;
info.YongHuId = Guid.NewGuid().ToString();
new Eyousoft_yhq.BLL.BWeiXin().YongHu_C(info);
}
Utils.RCWE("获取关注者列表成功");
}
void YongHu_U()
{
var info = new Eyousoft_yhq.Model.MWeiXinYongHuInfo();
info.YongHuId = "3fd570da-e677-4287-8b51-0b81db3916ae";
info.openid = "A";
info.subscribe = "1";
int bllRetCode = new Eyousoft_yhq.BLL.BWeiXin().YongHu_U(info);
Utils.RCWE(bllRetCode.ToString());
}
void YongHu_U()
{
var info = new Eyousoft_yhq.Model.MWeiXinYongHuInfo();
info.YongHuId = "3fd570da-e677-4287-8b51-0b81db3916ae";
info.openid = "A";
info.subscribe = "1";
int bllRetCode=new Eyousoft_yhq.BLL.BWeiXin().YongHu_U(info);
Utils.RCWE(bllRetCode.ToString());
}
/// <summary>
/// 微信用户修改，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int YongHu_U(Eyousoft_yhq.Model.MWeiXinYongHuInfo info)
{
if (info == null || string.IsNullOrEmpty(info.openid) || string.IsNullOrEmpty(info.YongHuId))
{
return(0);
}
info.latesttime = DateTime.Now;
int dalRetCode = dal.YongHu_CU(info);
return(dalRetCode);
}
/// <summary>
/// 微信用户新增，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int YongHu_C(Eyousoft_yhq.Model.MWeiXinYongHuInfo info)
{
if (info == null || string.IsNullOrEmpty(info.openid))
{
return(0);
}
info.YongHuId = Guid.NewGuid().ToString();
info.createtime = info.latesttime = DateTime.Now;
int dalRetCode = dal.YongHu_CU(info);
return(dalRetCode);
}
/// <summary>
/// 微信用户新增修改，返回1成功，其它失败
/// </summary>
/// <param name="info">实体</param>
/// <returns></returns>
public int YongHu_CU(Eyousoft_yhq.Model.MWeiXinYongHuInfo info)
{
var cmd = _db.GetStoredProcCommand("proc_WeiXin_YongHu_CU");
_db.AddInParameter(cmd, "@YongHuId", DbType.AnsiStringFixedLength, info.YongHuId);
_db.AddInParameter(cmd, "@subscribe", DbType.String, info.subscribe);
_db.AddInParameter(cmd, "@openid", DbType.String, info.openid);
_db.AddInParameter(cmd, "@nickname", DbType.String, info.nickname);
_db.AddInParameter(cmd, "@sex", DbType.String, info.sex);
_db.AddInParameter(cmd, "@city", DbType.String, info.city);
_db.AddInParameter(cmd, "@country", DbType.String, info.country);
_db.AddInParameter(cmd, "@province", DbType.String, info.province);
_db.AddInParameter(cmd, "@language", DbType.String, info.language);
_db.AddInParameter(cmd, "@headimgurl", DbType.String, info.headimgurl);
_db.AddInParameter(cmd, "@subscribe_time", DbType.String, info.subscribe_time);
_db.AddInParameter(cmd, "@unionid", DbType.String, info.unionid);
_db.AddInParameter(cmd, "@createtime", DbType.DateTime, info.createtime);
_db.AddInParameter(cmd, "@latesttime", DbType.DateTime, info.latesttime);
_db.AddOutParameter(cmd, "@RetCode", DbType.Int32, 4);
_db.AddInParameter(cmd, "@LeiXing", DbType.Int32, info.LeiXing);
int sqlExceptionCode = 0;
try
{
DbHelper.RunProcedure(cmd, _db);
}
catch (System.Data.SqlClient.SqlException e)
{
sqlExceptionCode = 0 - e.Number;
}
if (sqlExceptionCode < 0)
{
return(sqlExceptionCode);
}
return(Convert.ToInt32(_db.GetParameterValue(cmd, "RetCode")));
}
/// <summary>
/// handler oauth2 snsapi_userinfo
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
Eyousoft_yhq.Model.MWeiXinYongHuInfo handler_oauth2_snsapi_userinfo(weixin_oauth2_snsapi_userinfo info)
{
var info1 = new Eyousoft_yhq.Model.MWeiXinYongHuInfo();
info1.city = info.city;
info1.country = info.country;
info1.createtime = DateTime.Now;
info1.headimgurl = info.headimgurl;
info1.language = "zh_CN";
info1.latesttime = DateTime.Now;
info1.nickname = info.nickname;
info1.openid = info.openid;
info1.province = info.province;
info1.sex = info.sex;
info1.subscribe = "0";
info1.subscribe_time = "";
info1.unionid = string.Empty;
info1.YongHuId = Guid.NewGuid().ToString();
info1.LeiXing = 1;
new Eyousoft_yhq.BLL.BWeiXin().YongHu_C(info1);
return(info1);
}
/// <summary>
/// 关注，取消关注，返回1成功，其它失败
/// </summary>
/// <param name="openid">openid</param>
/// <param name="subscribe">1关注 0取消关注</param>
/// <returns></returns>
public int GuanZhu(string openid, string subscribe)
{
if (string.IsNullOrEmpty(openid) || string.IsNullOrEmpty(subscribe)) return 0;
if (subscribe != "0" && subscribe != "1") return 0;
var info = GetInfo2(openid);
if (info == null)
{
info = new Eyousoft_yhq.Model.MWeiXinYongHuInfo();
info.YongHuId = Guid.NewGuid().ToString();
info.openid = openid;
}
info.subscribe = subscribe;
info.createtime = info.latesttime = DateTime.Now;
var dalRetCode = dal.YongHu_CU(info);
return dalRetCode;
}
/// <summary>
/// handler oauth2 snsapi_userinfo
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
Eyousoft_yhq.Model.MWeiXinYongHuInfo handler_oauth2_snsapi_userinfo(weixin_oauth2_snsapi_userinfo info)
{
var info1 = new Eyousoft_yhq.Model.MWeiXinYongHuInfo();
info1.city = info.city;
info1.country = info.country;
info1.createtime = DateTime.Now;
info1.headimgurl = info.headimgurl;
info1.language = "zh_CN";
info1.latesttime = DateTime.Now;
info1.nickname = info.nickname;
info1.openid = info.openid;
info1.province = info.province;
info1.sex = info.sex;
info1.subscribe = "0";
info1.subscribe_time = "";
info1.unionid = string.Empty;
info1.YongHuId = Guid.NewGuid().ToString();
info1.LeiXing = 1;
new Eyousoft_yhq.BLL.BWeiXin().YongHu_C(info1);
return info1;
}
protected void Page_Load(object sender, EventArgs e)
{
string weixin_appid = "";
string weixin_secret = "";
weixin_appid = Utils.GetConfigString("", "YHQAppId").Trim();
weixin_secret = Utils.GetConfigString("", "YHQAppSecret").Trim();
if (Utils.GetQueryStringValue("sync") != "1")
{
Utils.RCWE("");
}
IMpClient mpClient = new MpClient();
AccessTokenGetRequest request = new AccessTokenGetRequest()
{
AppIdInfo = new AppIdInfo()
{
AppID = weixin_appid, AppSecret = weixin_secret
}
};
AccessTokenGetResponse response = mpClient.Execute(request);
if (response.IsError)
{
Utils.RCWE("获取令牌环失败..");
}
GetAttentionsRequest request2 = new GetAttentionsRequest()
{
AccessToken = response.AccessToken.AccessToken
};
var response2 = mpClient.Execute(request2);
if (response2.IsError)
{
Utils.RCWE("获取关注者列表失败，错误信息为：" + response2.ErrInfo.ErrCode + "-" + response2.ErrInfo.ErrMsg);
}
foreach (var item in response2.Attentions.data.openid)
{
var info1 = Eyousoft_yhq.Web.BsendMsg.WeiXin.GetUserInfo(item);
var info = new Eyousoft_yhq.Model.MWeiXinYongHuInfo();
info.city = info1.City;
info.country = info1.Country;
info.createtime = DateTime.Now;
info.headimgurl = info1.HeadImgUrl;
info.language = info1.Language;
info.latesttime = DateTime.Now;
info.nickname = info1.NickName;
info.openid = info1.OpenId;
info.province = info1.Province;
info.sex = info1.Sex;
info.subscribe = info1.SubScribe;
info.subscribe_time = info1.SubscribeTime;
info.unionid = string.Empty;
info.YongHuId = Guid.NewGuid().ToString();
new Eyousoft_yhq.BLL.BWeiXin().YongHu_C(info);
}
Utils.RCWE("获取关注者列表成功");
}
/// <summary>
/// read yonghu info
/// </summary>
/// <param name="cmd"></param>
/// <returns></returns>
Eyousoft_yhq.Model.MWeiXinYongHuInfo ReadYongHuInfo(DbCommand cmd)
{
Eyousoft_yhq.Model.MWeiXinYongHuInfo info = null;
using (var rdr = DbHelper.ExecuteReader(cmd, _db))
{
if (rdr.Read())
{
info = new Eyousoft_yhq.Model.MWeiXinYongHuInfo();
info.city = rdr["city"].ToString();
info.country = rdr["country"].ToString();
info.createtime = rdr.GetDateTime(rdr.GetOrdinal("createtime"));
info.headimgurl = rdr["headimgurl"].ToString();
info.language = rdr["language"].ToString();
info.latesttime = rdr.GetDateTime(rdr.GetOrdinal("latesttime"));
info.nickname = rdr["nickname"].ToString();
info.openid = rdr["openid"].ToString();
info.province = rdr["province"].ToString();
info.sex = rdr["sex"].ToString();
info.subscribe = rdr["subscribe"].ToString();
info.subscribe_time = rdr["subscribe_time"].ToString();
info.unionid = rdr["unionid"].ToString();
info.YongHuId = rdr["YongHuId"].ToString();
info.LeiXing = rdr.GetInt32(rdr.GetOrdinal("LeiXing"));
info.HuiYuanId = rdr["HuiYuanId"].ToString().Trim();
info.BangDingTime = rdr.GetDateTime(rdr.GetOrdinal("BangDingTime"));
}
}
return info;
}
