public EditForm(BathDBDataContext dc, StockIn stockin)
{
db = dc;
inStock = stockin;
InitializeComponent();
stock.Items.AddRange(db.Stock.Select(x => x.name).ToArray());
provider.Items.AddRange(db.Provider.Select(x => x.name).ToArray());
goodsCat.Items.AddRange(db.GoodsCat.Select(x => x.name).ToArray());
unit.Items.AddRange(db.Unit.Select(x => x.name).ToArray());
var employees = db.Employee.Where(x => !db.Job.FirstOrDefault(y => y.id == x.jobId).name.Contains("技师"));
checker.Items.AddRange(employees.Select(x => x.name).ToArray());
transactor.Items.AddRange(employees.Select(x => x.name).ToArray());
var stocktext = db.Stock.FirstOrDefault(x => x.id == stockin.stockId);
stock.Text = stocktext !=null?stocktext.name:"";
string nametext = stockin.name;
name.Text = nametext != "" ? nametext : "";
var goodCatext = db.GoodsCat.FirstOrDefault(y => y.id == db.StorageList.FirstOrDefault(x => x.name == stockin.name).goodsCatId);
//MessageBox.Show("该商品没分类");
goodsCat.Text = goodCatext != null ? goodCatext.name : "";
string amouttext = stockin.amount.ToString();
amount.Text = amouttext != "" ? amouttext : "";
var providertext = db.Provider.FirstOrDefault(x => x.id == stockin.providerId);
provider.Text = providertext != null ? providertext.name : "";
string costtext = stockin.cost.ToString();
cost.Text = costtext != "" ? costtext : "";
string moneytext = stockin.money.ToString();
money.Text = moneytext != "" ? moneytext : "";
dtPickerIntoStock.Value = stockin.date != null ? stockin.date : DateTime.Now;
string checkertext = stockin.checker;
checker.Text = checkertext != "" ? checkertext : "";
string transactortext=stockin.transactor;
transactor.Text = transactortext != "" ? transactortext : "";
string notetext = stockin.note;
note.Text = notetext != "" ? notetext : "";
}
//构造函数
//public StockInForm(BathDBDataContext dc, IntoStockManagementForm form)
public StockInForm(BathDBDataContext dc, StockIn _stockin)
{
db = dc;
if (_stockin!=null)
{
stockin = _stockin;
newStockin = false;
}
InitializeComponent();
//m_Form = form;
}
partial void DeleteStockIn(StockIn instance);
partial void UpdateStockIn(StockIn instance);
partial void InsertStockIn(StockIn instance);
//确定
private void btnOk_Click(object sender, EventArgs e)
{
if (catId.Text == "")
{
BathClass.printErrorMsg("需要选择商品类别");
return;
}
m_goods.name = name.Text.Trim();
try
{
m_goods.minAmount = Convert.ToInt32(minAmount.Text.Trim());
}
catch
{
m_goods.minAmount = null;
}
m_goods.note = note.Text.Trim();
m_goods.goodsCatId = db.GoodsCat.FirstOrDefault(x => x.name == catId.Text).id;
if (newGoods)
{
if (db.StorageList.FirstOrDefault(x => x.name == m_goods.name) != null)
{
BathClass.printErrorMsg("已经存在此名称的商品!");
name.SelectAll();
return;
}
db.StorageList.InsertOnSubmit(m_goods);
}
if (amount.Text.Trim() != "")
{
if (amount.Text.Trim() == "")
{
BathClass.printErrorMsg("需要输入数量!");
return;
}
if (stock.Text == "")
{
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);
inStock.stockId = db.Stock.FirstOrDefault(x => x.name == stock.Text).id;
inStock.note = stockNote.Text;
inStock.date = DateTime.Now;
inStock.transactor = LogIn.m_User.id;
inStock.checker = LogIn.m_User.id;
string unit_text = ComboUnit.Text.Trim();
if (unit_text != "")
{
inStock.unit = unit_text;
if (!db.Unit.Any(x=>x.name==unit_text))
{
var unit_instance = new Unit();
unit_instance.name = unit_text;
db.Unit.InsertOnSubmit(unit_instance);
}
}
if (money.Text.Trim() != "")
inStock.money = Convert.ToDouble(money.Text.Trim());
db.StockIn.InsertOnSubmit(inStock);
}
db.SubmitChanges();
if (newGoods)
{
name.Text = "";
catId.SelectedIndex = -1;
provider.SelectedIndex = -1;
minAmount.Text = "";
note.Text = "";
cost.Text = "";
amount.Text = "";
stock.SelectedIndex = -1;
stockNote.Text = "";
money.Text = "";
name.Focus();
db.SubmitChanges();
m_form.dgv_show();
m_goods = new StorageList();
}
else
{
this.DialogResult = DialogResult.OK;
this.Close();
}
}
//确定
private void okBtn_Click(object sender, EventArgs e)
{
if (!validateTextFields())
return;
StockIn inStock = new StockIn();
inStock.name = name.Text;
inStock.cost = Convert.ToDouble(cost.Text);
inStock.amount = Convert.ToInt32(amount.Value);
inStock.stockId = db.Stock.FirstOrDefault(x => x.name == stock.Text).id;
inStock.note = note.Text;
inStock.date = BathClass.Now(LogIn.connectionString);
inStock.transactor = transactor.Text;
inStock.checker = checker.Text;
db.StockIn.InsertOnSubmit(inStock);
//bool newSList = false;
//var storage = db.StorageList.FirstOrDefault(x => x.name == name.Text && x.stockId == inStock.stockId);
//if (storage == null)
//{
// newSList = true;
// storage = new StorageList();
//}
//storage.name = name.Text;
//storage.cost = inStock.cost;
//storage.amountThisMonth = MConvert<int>.ToTypeOrDefault(storage.amountThisMonth) + inStock.amount;
//storage.stockId = inStock.stockId;
//if (newSList)
// db.StorageList.InsertOnSubmit(storage);
db.SubmitChanges();
this.DialogResult = DialogResult.OK;
this.Close();
}
//确定
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();
}
}