//构造函数
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;
}
