public override ObservableCollection <Isso> BindIssos() { var issos = new ObservableCollection <Isso>(); var issosTable = App.CreateDatabase().Query <IssosList>("SELECT I_ISSO.C_ISSO, NAME, DORNAME, W_ISSO, coalesce(RATINGS, -1) as RATINGS_1, N_OTC_EXP, LATITUDE, LONGITUDE, LENGTH, OBSTACLE from I_ISSO " + "left outer join RATING on (RATING.C_ISSO = I_ISSO.C_ISSO and RATING.RATINGDATE = (select MAX(RATINGDATE) from RATING where C_ISSO = I_ISSO.C_ISSO))" + (SelectedRoad.Equals("[Все]") ? "" : "where DORNAME = '" + SelectedRoad + "'" + " order by DORNAME, W_ISSO")).ToList(); foreach (var isso in issosTable) { var info = $"{isso.NAME} (ОТС: {isso.N_OTC_EXP}) \n{isso.DORNAME} км {isso.W_ISSO>> 16}+{isso.W_ISSO& 0xFFFF} ({isso.OBSTACLE})"; issos.Add(new Isso(isso.C_ISSO, info, (Otc)isso.RATINGS_1, App.AppType)); } return(issos); }
public override ObservableCollection <Isso> BindIssos() { var issos = new ObservableCollection <Isso>(); var connection = ConnectionClass.CreateDatabase(); var issosTable = connection.Query <IssosList>("SELECT I_ISSO.C_ISSO, NAME, CTYPEISSO, DORNAME, W_ISSO, N_OTC_EXP, C_OTC_EXP, LATITUDE, LONGITUDE, LENGTH, OBSTACLE, NAME_ISSO from I_ISSO " + (SelectedRoad.Equals("[Все]") ? "" : "where DORNAME = '" + SelectedRoad + "'" + " order by DORNAME, W_ISSO")).ToList(); foreach (var isso in issosTable) { var info = $"{isso.NAME} (ОТС: {isso.N_OTC_EXP}) \n{isso.DORNAME} км {isso.W_ISSO >> 16}+{isso.W_ISSO & 0xFFFF} ({isso.OBSTACLE})" + $"\n(Код ИССО: {isso.C_ISSO}) {(isso.NAME_ISSO != null && !isso.NAME_ISSO.Equals("") ? $"({isso.NAME_ISSO})" : "")}"; issos.Add(new Isso(isso.C_ISSO, info, (Otc)isso.C_OTC_EXP, App.AppType)); } connection.Close(); return(issos); }