private void bt删除_Click(object sender, EventArgs e) { try { if (MessageBox.Show("确定删除吗?", "提示", MessageBoxButtons.YesNo) == DialogResult.No) { return; } else { DataRow dr = gridView1.GetDataRow(gridView1.FocusedRowHandle); Table_GoodsIn deleteneirong = db.Table_GoodsIn.Find(dr["GoodsID"].ToString()); Table_Stor deletestor = db.Table_Stor.Find(dr["GoodsID"].ToString()); db.Table_GoodsIn.Remove(deleteneirong); db.Table_Stor.Remove(deletestor); db.SaveChanges(); fillToolStripButton_Click(sender, e); MessageBox.Show("删除成功!"); bt添加.Enabled = true; bt修改.Enabled = false; bt删除.Enabled = false; text进货单号框.ReadOnly = false; text商品编号.ReadOnly = false; dr.EndEdit(); bt修改.Enabled = false; bt删除.Enabled = false; Panduan(); } } catch (Exception ex) { MessageBox.Show("删除失败!\n" + ex.Message); } }
//***************************************************************************************** //事件 private void bt添加_Click(object sender, EventArgs e) { try { if (ISNotNULL()) { Table_GoodsIn tgoodsin = new Table_GoodsIn(); //商品 Table_Stor tsr = new Table_Stor(); //库存 //商品信息 tgoodsin.CompanyName = text供货商名称.Text; tgoodsin.Flage = true; tgoodsin.GoodsColor = text商品颜色.Text; tgoodsin.GoodsID = text商品编号.Text; tgoodsin.GoodsInDateTime = DateTime.Parse(text进货日期.Text); tgoodsin.GoodsInPrice = decimal.Parse(Text进货单价框.Text); tgoodsin.GoodsLeibie = text商品类别.Text; tgoodsin.GoodsName = text商品名称框.Text; tgoodsin.GoodsNum = Int32.Parse(text进货数量.Text); tgoodsin.GoodsPinpai = text商品品牌.Text; tgoodsin.GoodsRealPay = decimal.Parse(text实付金额.Text); tgoodsin.GoodsRemark = memoEdit备注.Text; tgoodsin.GoodsSellPrice = decimal.Parse(text销售单价框.Text); tgoodsin.GoodsShouldJijie = text季节.Text; tgoodsin.GoodsShouldPay = decimal.Parse(text应付金额框.Text); tgoodsin.GoodsSize = text商品尺码.Text; tgoodsin.GoodsUnit = Text计量单位框.Text; tgoodsin.ID = text进货单号框.Text; tgoodsin.StroName = text所属仓库.Text; db.Table_GoodsIn.Add(tgoodsin); /************************************************************************************/ //库存 tsr.CompanyName = text供货商名称.Text; tsr.GoodsID = text商品编号.Text; tsr.KcDataTime = DateTime.Parse(text进货日期.Text); tsr.KcGoodsName = text商品名称框.Text; tsr.KcGoodsPrice = decimal.Parse(Text进货单价框.Text); tsr.KcGoodsSellPrice = decimal.Parse(text销售单价框.Text); tsr.KcID = Shar.IDshengcheng.StorID(text所属仓库.Text); tsr.KcJingGaoNumber = 100; tsr.KcName = text所属仓库.Text; tsr.KcNumber = Int32.Parse(text进货数量.Text); tsr.KcRemark = ""; tsr.KcUnit = Text计量单位框.Text; db.Table_Stor.Add(tsr); /************************************************************************************/ db.SaveChanges(); MessageBox.Show("商品信息录入成功!", "提示"); text商品编号.Text = ""; text进货单号框.Text = ""; fillToolStripButton_Click(sender, e); bt修改.Enabled = false; bt删除.Enabled = false; Panduan(); } } catch { MessageBox.Show("信息录入失败!"); } }