private void BtnImport_Click(object sender, EventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.InitialDirectory = Environment.GetFolderPath(Environment.SpecialFolder.Personal); openFileDialog.Filter = "文本文件(*.txt)|*.txt|所有文件(*.*)|*.*"; if (openFileDialog.ShowDialog(this) == DialogResult.OK) { string FileName = openFileDialog.FileName; CsvParserOptions csvParserOptions = new CsvParserOptions(false, ','); GoodsMapping csvMapper = new GoodsMapping(); CsvParser <GoodsModel> csvParser = new CsvParser <GoodsModel>(csvParserOptions, csvMapper); var result = csvParser .ReadFromFile(FileName, Encoding.UTF8).ToList(); List <GoodsModel> goods = new List <GoodsModel>(); for (int i = 0; i < result.Count; i++) { goods.Add(result[i].Result); } using (var db = new AndroidDb(dbPath)) { int count = db.InsertAll(goods); this.dataGridView1.DataSource = goods; } } }
private void BtnGenerate_Click(object sender, EventArgs e) { List <Object[]> detaillist = new List <Object[]>(); using (var db = new AndroidDb(dbPath)) { stock = db.Stock.ToList(); places = db.Places.ToList(); for (int i = 0; i < stock.Count(); i++) //遍历Stock { int[] counts = new int[places.Count()]; for (int j = 0; j < places.Count(); j++)//遍历Place { detail = db.Query <DetailModel>("select * from detailmodel where stockmodel_id = ? and place = ?", stock[i].Id, places[j].place); if (detail.Count > 0) { counts[j] = detail[0].count; } else { counts[j] = 0; } } Object[] objDetail = new Object[] { stock[i].code, stock[i].name, stock[i].barcode, stock[i].count, counts, stock[i].sum }; detaillist.Add(objDetail); } ExportToExcel2(detaillist); } }
private void StockForm_Load(object sender, EventArgs e) { dbPath = $"{Environment.CurrentDirectory}\\mycount.db"; using (var db = new AndroidDb(dbPath)) { var stock = db.Stock.ToList(); this.dataGridView1.DataSource = stock; } }
private void Form1_Load(object sender, EventArgs e) { dbPath = $"{Environment.CurrentDirectory}\\mycount.db"; using (var db = new AndroidDb(dbPath)) { var goods = db.Goods.ToList(); //var goods = db.Query<GoodsModel>("select code, name, barcode, unit, content, price from GoodsModel"); this.dataGridView1.DataSource = goods; } }
private void BtnDel_Click(object sender, EventArgs e) { using (var db = new AndroidDb(dbPath)) { int count = db.DeleteAll <GoodsModel>(); var goods = db.Goods.ToList(); //var goods = db.Query<GoodsModel>("select code, name, barcode, unit, content, price from GoodsModel"); this.dataGridView1.DataSource = goods; } }
private void BtnClean_Click(object sender, EventArgs e) { using (var db = new AndroidDb(dbPath)) { int count = db.DeleteAll <StockModel>(); int detail = db.DeleteAll <DetailModel>(); var stock = db.Stock.ToList(); this.dataGridView1.DataSource = stock; } }