コード例 #1
0
        /// <summary>
        /// 搜索
        /// </summary>
        private void Search(object sender, RoutedEventArgs e)
        {
            var db = App.conn;

            ViewModel = new ViewModels.ListItemViewModel();
            string content = searchBox.Text.Trim();

            if (content != "")
            {
                string searchSQL = @"SELECT * FROM Items WHERE Title LIKE '%" + content + "%' " +
                                   "OR Details LIKE '%" + content + "%' " +
                                   "OR Date LIKE '%" + content + "%'";
                using (var statement = db.Prepare(searchSQL)) {
                    while (SQLiteResult.DONE != statement.Step())
                    {
                        string   tid          = statement[0].ToString();
                        string   ttitle       = statement[1].ToString();
                        string   tdetails     = statement[2].ToString();
                        string   ddate        = statement[3].ToString();
                        string   ttag         = statement[4].ToString();
                        DateTime ddateconvert = Convert.ToDateTime(ddate);

                        ViewModel.AddListItem(ttitle, tdetails, ttag, ddateconvert);
                    }
                }
                Frame root = Window.Current.Content as Frame;
                App.ViewModel = ViewModel;
                root.Navigate(typeof(MainPage));
            }
        }
コード例 #2
0
        private void Tags_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            var db = App.conn;

            ViewModel = new ViewModels.ListItemViewModel();
            if (Tags.SelectedValue.ToString() != "全部")
            {
                string searchSQL = @"SELECT * FROM Items WHERE Tag = '" + Tags.SelectedValue.ToString() + "'";
                using (var statement = db.Prepare(searchSQL))
                {
                    while (SQLiteResult.DONE != statement.Step())
                    {
                        string   tid          = statement[0].ToString();
                        string   ttitle       = statement[1].ToString();
                        string   tdetails     = statement[2].ToString();
                        string   ddate        = statement[3].ToString();
                        string   ttag         = statement[4].ToString();
                        DateTime ddateconvert = Convert.ToDateTime(ddate);

                        ViewModel.AddListItem(ttitle, tdetails, ttag, ddateconvert);
                    }
                }
            }
            else
            {
                using (var statement = App.conn.Prepare("select * from Items"))
                {
                    while (statement.Step() != SQLiteResult.DONE)
                    {
                        string   tid          = statement[0].ToString();
                        string   ttitle       = statement[1].ToString();
                        string   tdetails     = statement[2].ToString();
                        string   ddate        = statement[3].ToString();
                        string   ttag         = statement[4].ToString();
                        DateTime ddateconvert = Convert.ToDateTime(ddate);

                        ViewModel.AddListItem(ttitle, tdetails, ttag, ddateconvert);
                    }
                }
            }
            Frame root = Window.Current.Content as Frame;

            App.ViewModel = ViewModel;
            root.Navigate(typeof(MainPage));
        }
コード例 #3
0
        public MainPage()
        {
            var db = App.conn;

            using (var statement = db.Prepare("SELECT * FROM Tags"))
            {
                while (SQLiteResult.DONE != statement.Step())
                {
                    tags.Add((string)statement[0]);
                }
            }
            tags.Add("全部");
            if (App.ViewModel != null)
            {
                ViewModel     = App.ViewModel;
                App.ViewModel = null;
            }
            else
            {
                ViewModel = new ViewModels.ListItemViewModel();

                using (var statement = App.conn.Prepare("select * from Items"))
                {
                    while (statement.Step() != SQLiteResult.DONE)
                    {
                        string   tid          = statement[0].ToString();
                        string   ttitle       = statement[1].ToString();
                        string   tdetails     = statement[2].ToString();
                        string   ddate        = statement[3].ToString();
                        string   ttag         = statement[4].ToString();
                        DateTime ddateconvert = Convert.ToDateTime(ddate);

                        ViewModel.AddListItem(ttitle, tdetails, ttag, ddateconvert);
                    }
                }
            }
            this.InitializeComponent();
        }