private void button1_Click(object sender, EventArgs e)
{
SuperMarketDataClassesDataContext db = new SuperMarketDataClassesDataContext();
SISM_console sc = new SISM_console();
//查询是否存在该编号商品
var num = (from m in db.SIMS_commodity
where m.CId == int.Parse(textBox1.Text)
select m).Count();
//存在
if (num > 0)
{
//查询
var q = (from m in db.SIMS_commodity
where m.CId == int.Parse(textBox1.Text)
select m);
foreach (var c in q)
{
sc.Number = textBox2.Text;
int number; //存放当前库存数目
number = int.Parse(c.CQty) + int.Parse(sc.Number);
c.CQty = number.ToString();
db.SubmitChanges();
label5.Text = "商品编号：" + c.CId + "\n" + "剩余库存：" + number + "\n" + "操作人：" + UserName;
//添加开始
sc.CId = int.Parse(textBox1.Text);
sc.Number = textBox2.Text;
sc.Price = textBox3.Text;
sc.Choose = "入库";
sc.UserName = UserName;
db.SISM_console.InsertOnSubmit(sc);
try
{
db.SubmitChanges();
dataGridView1.DataSource = db.SISM_console;
MessageBox.Show("入库成功！");
}
catch (Exception ex)
{
}
//添加结束
clean();
}
}
else
{
MessageBox.Show("没有此编号商品！");
}
}
partial void DeleteSISM_console(SISM_console instance);
partial void UpdateSISM_console(SISM_console instance);
partial void InsertSISM_console(SISM_console instance);
