/// <summary>
///同步按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSyn_Click(object sender, EventArgs e)
{
string err = "";
Model.wx_userweixin weixin = GetWeiXinCode();
WeiXinCRMComm wcr = new WeiXinCRMComm();
string accessToken = wcr.getAccessToken(weixin.id, out err);
if (err != "")
{
return;
}
BLL.wx_crm_users uBll = new BLL.wx_crm_users();
//更新时间，作为一个标记
DateTime updateTime = DateTime.Now;
try
{
string ret = SysPersonFun(0, weixin.id, accessToken, "", updateTime);
//查找此次为同步到的，则为已经跑路的
IList <Model.wx_crm_users> userlist = uBll.GetModelList("updateDate<'" + updateTime.ToString() + "'");
if (userlist != null && userlist.Count > 0)
{
for (int i = 0; i < userlist.Count; i++)
{
userlist[i].uStatus = 2;
uBll.Update(userlist[i]);
}
}
JscriptMsg(ret, "user_list.aspx", "Success");
}
catch (Exception ex)
{
lblInfo.Text = ex.Message;
}
}
private void ShowInfo(int _id)
{
BLL.wx_crm_users uBll = new BLL.wx_crm_users();
Model.wx_crm_users user = uBll.GetModel(_id);
BLL.wx_crm_group gBll = new BLL.wx_crm_group();
Model.wx_crm_group group = gBll.GetModel(user.groupId.Value);
BLL.wx_crm_users_tag tBll = new BLL.wx_crm_users_tag();
Model.wx_userweixin weixin = GetWeiXinCode();
Model.wx_crm_users_tag tagEntity = tBll.GetModelByWidAndOpenid(weixin.id, user.openid);
lblnickname.Text = user.nickname;
imgPhoto.ImageUrl = user.headimgurl;
lblSex.Text = GetUserSex(int.Parse(user.sex));
lblArea.Text = user.country + " " + user.province + " " + user.city;
lblsubscribe_time.Text = MyCommFun.GetTime(user.subscribe_time).ToString();
prov = user.province;
if (group != null)
{
lblGroupName.Text = group.name;
}
if (tagEntity != null)
{
hidtagId.Value = tagEntity.id.ToString();
txtTag.Text = tagEntity.tag;
}
hidWid.Value = user.wid.ToString();
hidOpenid.Value = user.openid;
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = MXRequest.GetQueryInt("page", 1);
if (this.group_id > 0)
{
this.ddlGroupId.SelectedValue = this.group_id.ToString();
}
if (this.status.Trim().Length > 0)
{
this.ddlstatus.SelectedValue = this.status.ToString();
}
this.txtKeywords.Text = this.keywords;
BLL.wx_crm_users bll = new BLL.wx_crm_users();
DataSet ds = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataRow dr;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
dr = ds.Tables[0].Rows[i];
dr["subscribe_time"] = MyCommFun.GetTime(dr["subscribe_time"].ToString()).ToString();
}
}
this.rptList.DataSource = ds;
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("user_list.aspx", "status={0}&group_id={1}&keywords={2}&page={3}",
this.status.ToString(), this.group_id.ToString(), this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
/// <summary>
/// 同步一个用户信息，如果库里存在，则修改，不存在，则新增
/// </summary>
/// <param name="userDetail"></param>
private int InsertUserInfo(int wid, string accessToken, List <string> openidStr, DateTime updateTime)
{
int totCount = 0;
// 将数据插入到数据库里
BLL.wx_crm_users uBll = new BLL.wx_crm_users();
Model.wx_crm_users uEntity = new Model.wx_crm_users();
try
{
UserInfoJson userDetail = new UserInfoJson();
for (int i = 0; i < openidStr.Count; i++)
{
userDetail = Senparc.Weixin.MP.AdvancedAPIs.User.Info(accessToken, openidStr[i]);
uEntity = uBll.GetModel(wid, openidStr[i]);
bool isAdd = true;
if (uEntity == null)
{
isAdd = true;
uEntity = new Model.wx_crm_users();
}
else
{
isAdd = false;
}
uEntity.wid = wid;
uEntity.openid = openidStr[i];
uEntity.nickname = userDetail.nickname;
uEntity.sex = userDetail.sex.ToString();
uEntity.city = userDetail.city;
uEntity.country = userDetail.country;
uEntity.province = userDetail.province;
uEntity.language = userDetail.language;
uEntity.headimgurl = userDetail.headimgurl;
uEntity.subscribe_time = userDetail.subscribe_time.ToString();
uEntity.updateDate = updateTime;
uEntity.uStatus = 1;
//查询分组号
GetGroupIdResult gid = Groups.GetId(accessToken, openidStr[i]);
uEntity.groupId = gid.groupid;
if (isAdd)
{
//新增
uEntity.createDate = DateTime.Now;
int succ = uBll.Add(uEntity);
if (succ > 0)
{
totCount++;
}
}
else
{
//修改
bool succ = uBll.Update(uEntity);
if (succ)
{
totCount++;
}
}
}
return(totCount);
}
catch (Exception ex)
{
throw new Exception("用户信息同步失败！" + ex.Message);
}
}
