protected string SetUserGroup(object author) { string userType = ""; if (author != null) { B_User userBll = new B_User(); M_User userModel = userBll.GetUser(author.ToString()); B_UserGroup userGroupBll = new B_UserGroup(); DataTable dt = userGroupBll.ManageList(""); if (dt.Rows.Count > 0 && userModel != null) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["UserGroupId"].ToString() == userModel.GroupID.ToString()) { userType = dt.Rows[i]["UserGroupName"].ToString(); break; } } } } else { userType = "游客"; } return userType; }
private void BindGroup() { B_UserGroup groupBll = new B_UserGroup(); DataTable dt = groupBll.ManageList(""); chkBoxGroupIdStr.DataTextField = "UserGroupName"; chkBoxGroupIdStr.DataValueField = "UserGroupId"; chkBoxGroupIdStr.DataSource = dt; chkBoxGroupIdStr.DataBind(); dt.Clear(); dt.Dispose(); }
/// <summary> ///绑定专题和用户组 /// </summary> void BindData() { //绑定专题列表 B_Special specialBll = new B_Special(); DataTable dt = specialBll.GetChannelSpecial(ChannelId); if (dt != null) { DataView dvParent = new DataView(dt); dvParent.RowFilter = "ParentId=0"; lBoxTopicIdStr.Items.Clear(); for (int i = 0; i < dvParent.Count; i++) { int parentId = Convert.ToInt32(dvParent[i]["Id"]); lBoxTopicIdStr.Items.Add(new ListItem(dvParent[i]["SpecialCName"].ToString(), parentId.ToString())); DataView dvChild = new DataView(dt); dvChild.RowFilter = "ParentId=" + parentId; for (int j = 0; j < dvChild.Count; j++) { lBoxTopicIdStr.Items.Add(new ListItem("└" + dvChild[j]["SpecialCName"], dvChild[j]["Id"].ToString())); } } } //绑定用户组 B_UserGroup userGroup = new B_UserGroup(); DataTable g = userGroup.ManageList(""); if (g != null) { for (int i = 0; i < g.Rows.Count; i++) { UserGroup.Items.Add(new ListItem(g.Rows[i]["UserGroupName"].ToString(), g.Rows[i]["UserGroupId"].ToString())); } } }