/// <summary>
/// 删除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsbtnDel_Click(object sender, EventArgs e)
{
try
{
dc = new DCQUALITYDataContext();
idebarJoinU9 ijU9 = dc.idebarJoinU9.Where(n => n.idebarJoinU9_id == currentId).First();
dc.idebarJoinU9.DeleteOnSubmit(ijU9);
dc.SubmitChanges();
MessageBox.Show("操作成功！");
LoadData("");
}
catch (Exception)
{
MessageBox.Show("操作失败！");
return;
}
}
/// <summary>
/// 不与U9传数据列表修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsbtnUpdate_Click(object sender, EventArgs e)
{
try
{
dc = new DCQUALITYDataContext();
idebarJoinU9 ijU9 = dc.idebarJoinU9.Where(n => n.idebarJoinU9_id == currentId).First();
txtPRODID.Text = ijU9.idebarJoinU9_PROD_ID;
txtRemork.Text = ijU9.idebarJoinU9_remark;
btnSave.Text = "修改";
LoadData("");
}
catch (Exception ex)
{
MessageBox.Show("请选择数据！");
return;
}
}
/// <summary>
/// 添加、修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtPRODID.Text.Trim() == "")
{
MessageBox.Show("货品名称不能为空！");
return;
}
idebarJoinU9 ij = new idebarJoinU9();
dc = new DCQUALITYDataContext();
if (btnSave.Text == "添加")
{
ij.idebarJoinU9_PROD_ID = txtPRODID.Text.Trim();
ij.idebarJoinU9_remark = txtRemork.Text.Trim();
dc = new DCQUALITYDataContext();
dc.idebarJoinU9.InsertOnSubmit(ij);
dc.SubmitChanges();
MessageBox.Show("操作成功！", "提示");
}
else if (btnSave.Text == "修改" && currentId > 0)
{
ij = dc.idebarJoinU9.Where(n => n.idebarJoinU9_id == currentId).First();
ij.idebarJoinU9_PROD_ID = txtPRODID.Text.Trim();
ij.idebarJoinU9_remark = txtRemork.Text.Trim();
dc.SubmitChanges();
MessageBox.Show("操作成功！", "提示");
}
btnSave.Text = "添加";
txtPRODID.Text = "";
txtRemork.Text = "";
LoadData("");
}
catch (Exception ex)
{
MessageBox.Show("操作失败！", "提示");
return;
}
}