private void btnGdelete_Click(object sender, EventArgs e) { BLL.GoodsBLL objUB = new BLL.GoodsBLL(); if (dataGridView1.SelectedRows.Count > 0) { if (MessageBox.Show("确认要删除该行数据吗?", "删除确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { int rst = dataGridView1.SelectedRows.Count; foreach (DataGridViewRow dr in dataGridView1.SelectedRows) { DAL.Goods objU = new DAL.Goods(); objU.gid = (int)dr.Cells["gid"].Value; rst -= objUB.Delete(objU); } if (rst == 0) { MessageBox.Show("删除成功"); BLL.GoodsBLL objB = new BLL.GoodsBLL(); dataGridView1.DataSource = objB.GetList(x => true); dataGridView1.Refresh(); } else { MessageBox.Show("删除失败"); } } } else { MessageBox.Show("请先选中要删除的数据"); } }
private void frmGoodUpdate_Load(object sender, EventArgs e) { DAL.Goods objU = objUB.GetModel(ID); txtGidModify.Text = (objU.gid).ToString(); txtGtypeModify.Text = objU.gtype; txtGnameModify.Text = objU.gname; txtGpriceModify.Text = (objU.gprice).ToString(); }
/// <summary> /// 根据模型中的uid删除指定行 /// </summary> /// <param name="Data"></param> /// <returns></returns> public int Delete(DAL.Goods Data) { try { //找到数据上下文中,满足条件的记录 DAL.Goods objT = objDAL.Goods.First(x => x.gid == Data.gid); //删除该记录 objDAL.Goods.DeleteOnSubmit(objT); //更新数据上下文改变到数据库 objDAL.SubmitChanges(); return(1); } catch (Exception) { return(0); } }
/// <summary> /// 根据模型数据,完成表格的插入 /// </summary> /// <param name="Data"></param> /// <returns></returns> public int Add(DAL.Goods Data) { try { //向数据上下文数据表中增加一个 模型对象(实体) objDAL.Goods.InsertOnSubmit(Data); //更新数据上下文改变到数据库 objDAL.SubmitChanges(); return(1); } catch (Exception) { return(0); } //return objDAL.Add(Data); }
private void btnModify_Click(object sender, EventArgs e) { DAL.Goods objU = new DAL.Goods(); objU.gid = int.Parse(txtGidModify.Text); objU.gtype = txtGtypeModify.Text; objU.gname = txtGnameModify.Text; objU.gprice = double.Parse(txtGpriceModify.Text); if (objUB.Update(objU) > 0) { MessageBox.Show("修改成功"); } else { MessageBox.Show("修改失败"); } }
/// <summary> /// 根据uid指定要删除的行,其余字段用于表示要修改的数据值 /// </summary> /// <param name="Data"></param> /// <returns></returns> public int Update(DAL.Goods Data) { try { //找到数据上下文中,满足条件的记录 DAL.Goods objT = objDAL.Goods.First(x => x.gid == Data.gid); //修改数据记录 objT.gtype = Data.gtype; objT.gname = Data.gname; objT.gprice = Data.gprice; //更新数据上下文改变到数据库 objDAL.SubmitChanges(); return(1); } catch (Exception) { return(0); } }
private void button2_Click(object sender, EventArgs e) { DAL.Goods objR = new DAL.Goods(); objR.gid = Convert.ToInt32(txtGid.Text); objR.gtype = txtGtype.Text; objR.gname = txtGname.Text; objR.gprice = Convert.ToDouble(txtGprice.Text); if (objRB.Add(objR) > 0) { MessageBox.Show("商品添加成功"); } else { MessageBox.Show("添加失败,商品ID已存在,已经返回主窗体并请重新进入"); frmMain frmMain = new frmMain(); this.Hide(); frmMain.ShowDialog(); Application.ExitThread(); } }
public void DAL_SetGood(DAL.Goods good) { this._good = good; }