//构造函数 public ProviderForm(BathDBDataContext dc, Provider provider) { db = dc; if (provider != null) { newProvider = false; m_provider = provider; } InitializeComponent(); }
partial void DeleteProvider(Provider instance);
partial void UpdateProvider(Provider instance);
partial void InsertProvider(Provider instance);
private void dgvStockIn_show(Provider p) { dgvProviderStockIn.Rows.Clear(); var sis = db.StockIn.Where(x => x.providerId == p.id); foreach (var si in sis) { dgvProviderStockIn.Rows.Add(si.name, si.cost, si.amount, si.money, si.unit, si.date, si.transactor, si.checker); } BathClass.set_dgv_fit(dgvProviderStockIn); }
private void dgvProviderPays_show(Provider p) { dgvProviderPays.Rows.Clear(); var pps = db.ProviderPays.Where(x => x.providerId == p.id); foreach (var pp in pps) { dgvProviderPays.Rows.Add(pp.id, pp.cash, pp.bank, pp.date, pp.payer, pp.receiver, pp.confirmer, pp.note); } BathClass.set_dgv_fit(dgvProviderPays); }
//构造函数 public ProviderPaysForm(BathDBDataContext dc, Provider provider) { db = dc; m_provider = provider; InitializeComponent(); }
//确定 private void okBtn_Click(object sender, EventArgs e) { if (name.Text == "") { BathClass.printErrorMsg("需要选择商品名称"); return; } if (amount.Text.Trim() == "") { BathClass.printErrorMsg("需要输入数量!"); return; } if (stock.Text=="") { BathClass.printErrorMsg("需要选择仓库!"); return; } if (transactor.Text=="") { BathClass.printErrorMsg("需要输入经手人!"); return; } if (checker.Text=="") { BathClass.printErrorMsg("需要输入审核!"); return; } if (provider.Text.Trim() == "") { BathClass.printErrorMsg("需要选择供应商!"); return; } stockin.name = name.Text; stockin.cost = MConvert<double>.ToTypeOrDefault(cost.Text.Trim(), 0); stockin.amount = MConvert<double>.ToTypeOrDefault(amount.Text.Trim(),0); stockin.unit = unit.Text; stockin.stockId = db.Stock.FirstOrDefault(x => x.name == stock.Text).id; stockin.note = note.Text; stockin.date = dtPickerIntoStock.Value; stockin.transactor = transactor.Text; stockin.checker = checker.Text; stockin.money = totalmoney; //StockIn inStock = new StockIn(); if (newStockin) { if (db.Unit.Where(x=>x.name==unit.Text.Trim()).Count()==0) { Unit u = new Unit(); u.name = unit.Text.Trim(); db.Unit.InsertOnSubmit(u); db.SubmitChanges(); } var p = db.Provider.FirstOrDefault(x => x.name == provider.Text.Trim()); if (p==null) { p = new Provider(); p.name = provider.Text.Trim(); var form = new ProviderForm(db, p); if (form.ShowDialog() != DialogResult.OK) return; db.Provider.InsertOnSubmit(p); db.SubmitChanges(); } stockin.providerId = p.id; db.StockIn.InsertOnSubmit(stockin); db.SubmitChanges(); stockin = new StockIn(); goodsCat.SelectedIndex = -1; name.Text = ""; stock.SelectedIndex = -1; unit.Text = ""; amount.Text = ""; provider.SelectedIndex = -1; cost.Text = ""; money.Text = ""; checker.Text = ""; transactor.Text = ""; note.Text = ""; checker.Text = LogIn.m_User.name; transactor.Text = LogIn.m_User.name; } else { db.SubmitChanges(); this.DialogResult=DialogResult.OK; this.Close(); } }
private void btnOk_Click(object sender, EventArgs e) { if (name.Text == "") { BathClass.printErrorMsg("需要选择商品名称"); return; } if (amount.Text.Trim() == "") { BathClass.printErrorMsg("需要输入数量!"); return; } if (stock.Text == "") { BathClass.printErrorMsg("需要选择仓库!"); return; } if (transactor.Text == "") { BathClass.printErrorMsg("需要输入经手人!"); return; } if (checker.Text == "") { BathClass.printErrorMsg("需要输入审核!"); return; } if (provider.Text.Trim() == "") { BathClass.printErrorMsg("需要选择供应商!"); return; } //StockIn inStock = new StockIn(); inStock.name = name.Text; if (cost.Text != "") inStock.cost = Convert.ToDouble(cost.Text); inStock.amount = Convert.ToDouble(amount.Text); if (unit.Text != "") inStock.unit = unit.Text; inStock.stockId = db.Stock.FirstOrDefault(x => x.name == stock.Text).id; inStock.note = note.Text; inStock.date = dtPickerIntoStock.Value; inStock.transactor = transactor.Text; inStock.checker = checker.Text; inStock.money = totalmoney; var p = db.Provider.FirstOrDefault(x => x.name == provider.Text.Trim()); if (p == null) { p = new Provider(); p.name = provider.Text.Trim(); var form = new ProviderForm(db, p); if (form.ShowDialog() != DialogResult.OK) return; db.Provider.InsertOnSubmit(p); db.SubmitChanges(); } inStock.providerId = p.id; db.SubmitChanges(); this.DialogResult = DialogResult.OK; }