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