private void RptBind(string _strWhere, string _orderby) { Model.wx_userweixin weixin = GetWeiXinCode(); _strWhere = "sId=" + sid + " " + _strWhere; this.page = MXRequest.GetQueryInt("page", 1); txtKeywords.Text = this.keywords; DataSet ds = uBll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); //计算级别 if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { BLL.wx_ucard_udegree degreeBll = new BLL.wx_ucard_udegree(); IList <Model.wx_ucard_udegree> degreelist = degreeBll.GetModelList("sid=" + sid); DataRow dr; int count = ds.Tables[0].Rows.Count; for (int i = 0; i < count; i++) { dr = ds.Tables[0].Rows[i]; int score = MyCommFun.Obj2Int(dr["ttScore"]); dr["jibie"] = ComputeJiBie(score, degreelist); ds.AcceptChanges(); } } this.rptList.DataSource = ds; this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("user_list.aspx?id=" + sid, "keywords={0}&page={1}", this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void RptBind(string _strWhere, string _orderby) { Model.wx_userweixin weixin = GetWeiXinCode(); _strWhere = "sId=" + sid + " " + _strWhere; this.page = MXRequest.GetQueryInt("page", 1); txtKeywords.Text = this.keywords; DataSet ds = uBll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); //计算级别 if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { BLL.wx_ucard_udegree degreeBll = new BLL.wx_ucard_udegree(); IList<Model.wx_ucard_udegree> degreelist = degreeBll.GetModelList("sid=" + sid); DataRow dr; int count = ds.Tables[0].Rows.Count; for (int i = 0; i < count; i++) { dr = ds.Tables[0].Rows[i]; int score=MyCommFun.Obj2Int(dr["ttScore"]); dr["jibie"] = ComputeJiBie(score, degreelist); ds.AcceptChanges(); } } this.rptList.DataSource = ds; this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("user_list.aspx?id=" + sid, "keywords={0}&page={1}", this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
/// <summary> /// 获取用户的等级名称 /// </summary> /// <param name="score"></param> /// <param name="defaultDegree"></param> /// <returns>若没有取到等级,则返回defaultDegree值</returns> public static string userDegree(int sid, int score, string defaultDegree, out int degreeNum) { degreeNum = 0; string jibie = ""; BLL.wx_ucard_udegree degreeBll = new BLL.wx_ucard_udegree(); IList<Model.wx_ucard_udegree> degreelist = degreeBll.GetModelList("sid=" + sid); IList<Model.wx_ucard_udegree> tmpDegree = (from d in degreelist where d.score_min <= score && d.score_max > score orderby d.degreeNum ascending select d).ToArray<Model.wx_ucard_udegree>(); if (tmpDegree != null && tmpDegree.Count > 0) { jibie = tmpDegree[0].callName; degreeNum = MyCommFun.Obj2Int(tmpDegree[0].degreeNum); } if (jibie == "") { jibie = defaultDegree; } return jibie; }
/// <summary> /// 获取用户的等级名称 /// </summary> /// <param name="score"></param> /// <param name="defaultDegree"></param> /// <returns>若没有取到等级,则返回defaultDegree值</returns> public static string userDegree(int sid, int score, string defaultDegree, out int degreeNum) { degreeNum = 0; string jibie = ""; BLL.wx_ucard_udegree degreeBll = new BLL.wx_ucard_udegree(); IList <Model.wx_ucard_udegree> degreelist = degreeBll.GetModelList("sid=" + sid); IList <Model.wx_ucard_udegree> tmpDegree = (from d in degreelist where d.score_min <= score && d.score_max > score orderby d.degreeNum ascending select d).ToArray <Model.wx_ucard_udegree>(); if (tmpDegree != null && tmpDegree.Count > 0) { jibie = tmpDegree[0].callName; degreeNum = MyCommFun.Obj2Int(tmpDegree[0].degreeNum); } if (jibie == "") { jibie = defaultDegree; } return(jibie); }