protected void ControlButtomRoles() { if (FishEntity.Variable.Roles == null || FishEntity.Variable.Roles.Count < 1) { this.menuStrip1.Visible = false; } else { FishEntity.PersonRole role = FishEntity.Variable.Roles.Find((i) => { return(i.funcode.Equals(_menuCode, StringComparison.OrdinalIgnoreCase)); }); if (role == null) { this.menuStrip1.Visible = false; return; } List <FishEntity.PersonRole> roles = FishEntity.Variable.Roles.FindAll((i) => { return(i.pid == role.funid); }); if (roles == null || roles.Count < 1) { this.menuStrip1.Visible = false; return; } foreach (ToolStripMenuItem item in this.menuStrip1.Items) { string code = item.Tag == null ? "" : item.Tag.ToString(); bool isExist = roles.Exists((i) => { return(i.funcode.Equals(code, StringComparison.OrdinalIgnoreCase)); }); item.Visible = isExist; } } }
public List <FishEntity.PersonRole> GetPersionRoles(int userid) { StringBuilder strSql = new StringBuilder(); strSql.Append(" select * from v_userrole where userid=" + userid); DataSet ds = MySqlHelper.Query(strSql.ToString()); List <FishEntity.PersonRole> list = new List <FishEntity.PersonRole>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow row = ds.Tables[0].Rows[i]; FishEntity.PersonRole model = new FishEntity.PersonRole(); if (row["funid"] != null && row["funid"].ToString() != "") { model.funid = int.Parse(row["funid"].ToString()); } if (row["funcode"] != null) { model.funcode = row["funcode"].ToString(); } if (row["funname"] != null) { model.funname = row["funname"].ToString(); } if (row["type"] != null && row["type"].ToString() != "") { model.type = int.Parse(row["type"].ToString()); } if (row["enable"] != null && row["enable"].ToString() != "") { model.enable = int.Parse(row["enable"].ToString()); } if (row["remark"] != null) { model.remark = row["remark"].ToString(); } if (row["pid"] != null && row["pid"].ToString() != "") { model.pid = int.Parse(row["pid"].ToString()); } if (row["sortid"] != null && row["sortid"].ToString() != "") { model.sortid = int.Parse(row["sortid"].ToString()); } model.userid = userid; list.Add(model); } return(list); }