protected void btnFind_Click(object sender, EventArgs e) { condObj = new WEC_U_USER(); //if(txtID.Value !="" ) // condObj.Like(WEC_U_USER.Attribute.ID, Convert.ToDecimal(txtID.Value)); //if(txtOPENID.Value !="" ) // condObj.Like(WEC_U_USER.Attribute.OPENID, Convert.ToString(txtOPENID.Value)); //if(txtUSERNAME.Value !="" ) // condObj.Like(WEC_U_USER.Attribute.USERNAME, Convert.ToString(txtUSERNAME.Value)); //if(txtSEX.Value !="" ) // condObj.Like(WEC_U_USER.Attribute.SEX, Convert.ToString(txtSEX.Value)); //if(txtCOMMENT.Value !="" ) // condObj.Like(WEC_U_USER.Attribute.COMMENT, Convert.ToString(txtCOMMENT.Value)); //if(txtADDTIME.Value !="" ) // condObj.Like(WEC_U_USER.Attribute.ADDTIME, Convert.ToDateTime(txtADDTIME.Value)); hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<WEC_U_USER>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <WEC_U_USER>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void btnSetPageSize_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageSize.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<WEC_U_USER>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void btnSetPageSize_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageSize.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <WEC_U_USER>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
/// <summary> /// 根据openid判断 WEC_U_USER是否已存在 /// </summary> /// <param name="user"></param> /// <returns></returns> public Boolean isExist(WEC_U_USER user) { WEC_U_USER conf = new WEC_U_USER(); conf.AID = wx_publiclist.AID; conf.OPENID = user.OPENID; WEC_U_USER u = BLLTable <WEC_U_USER> .GetRowData(conf); if (u != null) { return(true); } return(false); }
private void BindList(WEC_U_USER condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序 { condObj.af_PageBy(WEC_U_USER.Attribute.ID, Order.Desc); } valObj.Distinct = true; #region//数据权限条件 #endregion //condObj.PID = decimal.Parse(pid); condObj.AID = Convert.ToDecimal(userBase2.Curraid); listObj = BLLTable <WEC_U_USER> .SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }
/// <summary> /// 当用户发送信息或者订阅时保存用户信息 /// ygh 2014/4/24 /// </summary> /// <param name="openid"></param> /// <param name="type"></param> public void saveUser(string openid, int type, int channelid, string toUserName) { string access_token = HttpUtil.getAccessToken(this.APPID, this.APPSECRET); string user_info = HttpUtil.httpForm("", "https://api.weixin.qq.com/cgi-bin/user/info?access_token=" + access_token + "&openid=" + openid + "&lang=zh_CN", "GET"); JavaScriptSerializer jss = new JavaScriptSerializer(); Dictionary <string, object> map = (Dictionary <string, object>)jss.DeserializeObject(user_info); WEC_U_USER user = new WEC_U_USER(); WEC_PUBLICLIST conf = new WEC_PUBLICLIST(); conf.PLC_SOURCEID = toUserName; WEC_PUBLICLIST publiclist = BLLTable <WEC_PUBLICLIST> .GetRowData(new WEC_PUBLICLIST(), conf); user.AID = publiclist.AID;//用户所订阅公众号ID user.OPENID = openid; //如果公众号没有访问用户信息的借口的权限则报错,则不包含以下键值 if (map.ContainsKey("nickname")) { user.USERNAME = (string)map["nickname"]; int sex = (int)map["sex"]; if (sex == 0) { user.SEX = "未知"; } else if (sex == 1) { user.SEX = "男"; } else if (sex == 2) { user.SEX = "女"; } user.ADDTIME = GetTime(map["subscribe_time"] + ""); } if (!isExist(user)) { BLLTable <WEC_U_USER> .Insert(user, WEC_U_USER.Attribute.ID); } else { BLLTable <WEC_U_USER> .Update(user, WEC_U_USER.Attribute.ID); } saveUserMessage(openid, type, "", channelid, toUserName); }
private void BindList(WEC_U_USER condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ����������������� condObj.af_PageBy(WEC_U_USER.Attribute.ID, Order.Desc); valObj.Distinct = true; #region//����Ȩ������ #endregion //condObj.PID = decimal.Parse(pid); condObj.AID = Convert.ToDecimal(userBase2.Curraid); listObj = BLLTable<WEC_U_USER>.SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }