Esempio n. 1
0
        // Constructor
        public MainPage()
        {
            InitializeComponent();

            SourceData sd = new SourceData(dbPath);
            if (!sd.DatabaseExists())
            {
                sd.CreateDatabase();
                DatabaseSchemaUpdater dbUpdater = sd.CreateDatabaseSchemaUpdater();
                dbUpdater.DatabaseSchemaVersion = DB_NEWEST_VERSION;
                dbUpdater.Execute();
            }
            else
            {
                DatabaseSchemaUpdater dbUpdater = sd.CreateDatabaseSchemaUpdater();
                int oriDbVersion = dbUpdater.DatabaseSchemaVersion;
                if (oriDbVersion < 1)
                {
                    dbUpdater.AddColumn<Card>("Phone");
                }
                if (oriDbVersion < DB_NEWEST_VERSION)
                {
                    dbUpdater.DatabaseSchemaVersion = DB_NEWEST_VERSION;
                    dbUpdater.Execute();
                }
            }
        }
Esempio n. 2
0
 private void btnDel_Click_1(object sender, RoutedEventArgs e)
 {
     CardListBox.ItemsSource = null;
     SourceData sd = new SourceData(dbPath);
     var results = from item in sd.Cards select item;
     foreach (var i in results)
     {
         sd.Cards.DeleteOnSubmit(i);
     }
     sd.SubmitChanges();
 }
Esempio n. 3
0
 private void btnAdd_Click_1(object sender, RoutedEventArgs e)
 {
     SourceData sd = new SourceData(dbPath);
     try
     {
         Card card = new Card() { ID = 1, Name = "kai1", Email = "*****@*****.**", Address = "地球", Phone="123" };
         Card card2 = new Card() { ID = 2, Name = "测试中文", Email = "*****@*****.**", Address = "月亮", Phone="234" };
         sd.Cards.InsertOnSubmit(card);
         sd.Cards.InsertOnSubmit(card2);
         sd.SubmitChanges();
     }
     catch
     {
         MessageBox.Show("Data already exists");
     }
 }
Esempio n. 4
0
        private void btnAdd_Click_1(object sender, RoutedEventArgs e)
        {
            SourceData sd = new SourceData(dbPath);

            try
            {
                Card card = new Card()
                {
                    ID = 1, Name = "kai1", Email = "*****@*****.**", Address = "地球", Phone = "123"
                };
                Card card2 = new Card()
                {
                    ID = 2, Name = "测试中文", Email = "*****@*****.**", Address = "月亮", Phone = "234"
                };
                sd.Cards.InsertOnSubmit(card);
                sd.Cards.InsertOnSubmit(card2);
                sd.SubmitChanges();
            }
            catch
            {
                MessageBox.Show("Data already exists");
            }
        }
Esempio n. 5
0
 private void btnDis_Click_1(object sender, RoutedEventArgs e)
 {
     SourceData sd = new SourceData(dbPath);
     var results = from item in sd.Cards select item;
     foreach (var item in results)
     {
         System.Diagnostics.Debug.WriteLine("item=" + item);
     }
     CardListBox.ItemsSource = results.ToList();
 }