private void AddRight(string menu, List <MenuRightsModel> model) { MenuRightsModel modelRight = new MenuRightsModel(); modelRight.menu = menu; modelRight.isquery = 1; modelRight.isedit = 1; modelRight.isnew = 1; modelRight.isdelete = 1; model.Add(modelRight); }
private async Task GetMenuRights(SqlConnection connection1, string userId, List <MenuRightsModel> model, bool isAdmin) { SqlCommand cmd = new SqlCommand(); string cmdString = "SELECT m.menu, u.isquery, u.isedit, u.isnew, u.isdelete FROM UserRights u " + "left join menu m on u.idmenu = m.id " + "where iduser = @iduser and m.status = 1 " + "order by m.menu"; cmd.CommandText = cmdString; cmd.Connection = connection1; SqlParameter parameter = new SqlParameter("@iduser", SqlDbType.VarChar); parameter.Value = userId; cmd.Parameters.Add(parameter); SqlDataReader reader = await cmd.ExecuteReaderAsync(); while (await reader.ReadAsync()) { if (reader.GetInt32(1) == 1) { MenuRightsModel menu = new MenuRightsModel(); menu.menu = reader.GetString(0); menu.isquery = reader.GetInt32(1); menu.isedit = reader.GetInt32(2); menu.isnew = reader.GetInt32(3); menu.isdelete = reader.GetInt32(4); model.Add(menu); } } reader.Close(); }