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;
}
}
