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;
}
