Example #1
0
        private void PopulateTable()
        {
            //Connect to db
            CreateDB(DbPath);
            var conn       = new SQLite.SQLiteConnection(DbPath);
            var cmd        = new SQLite.SQLiteCommand(conn);
            var results    = conn.Table <Balance>().Where(x => true).OrderByDescending(x => x.Id);
            var DataSource = new BalanceTableDataSource();

            double totalBalance = 0;

            foreach (var r in results)
            {
                DataSource.Balances.Add(new Balance(r.Id, r.Date, r.Desc, r.Amount));
                totalBalance += r.Amount;
            }


            //populate table
            BalanceTable.DataSource = DataSource;
            BalanceTable.Delegate   = new BalanceTableDelegate(this, DataSource);

            // populate initial
            double initialValue = 1000;

            try
            {
                initialValue = conn.Table <InitialValue>().OrderByDescending(x => x.id).First().Value;
            } catch (Exception e)
            {
                conn.Insert(new InitialValue(initialValue));
            }
            InitialLabel.StringValue = string.Format("(Init. amt: {0})", initialValue);


            //Populate total
            TotalLabel.StringValue = string.Format("结余: {0}", initialValue + totalBalance);
        }
Example #2
0
 //constructor
 public BalanceTableDelegate(ViewController controller, BalanceTableDataSource dataSource)
 {
     this.Controller = controller;
     this.DataSource = dataSource;
 }