public int InsertWorkshop(Workshop workshop)
{
using (IDbConnection conn = OpenConnection())
{
return(conn.Execute("Insert into tbl_Workshop values "
+ "(@Id, @Name)",
new { Id = workshop.Id, Name = workshop.Name }));
}
}
private void btn_Add_Click(object sender, RoutedEventArgs e)
{
DataAccessLayer db = new DataAccessLayer();
if (txt_WorkshopName.Text.Trim() == String.Empty)
{
SystemSounds.Beep.Play();
MessageBox.Show("请输入车间名称！");
return;
}
else if (db.QueryWorkshopByName(txt_WorkshopName.Text).Count() > 0)
{
SystemSounds.Beep.Play();
MessageBox.Show("已存在车间名称：" + txt_WorkshopName + "!");
return;
}
else if (txt_WorkshopId.Text.Trim() == String.Empty)
{
SystemSounds.Beep.Play();
MessageBox.Show("请输入车间编号！");
return;
}
else if (db.QueryWorkshopById(int.Parse(txt_WorkshopId.Text)).Count() > 0)
{
SystemSounds.Beep.Play();
MessageBox.Show("已存在车间编号：" + txt_WorkshopId.Text + "!");
return;
}
else
{
Workshop ws = new Workshop();
ws.Name = txt_WorkshopName.Text;
try
{
ws.Id = int.Parse(txt_WorkshopId.Text);
}
catch
{
SystemSounds.Beep.Play();
MessageBox.Show("车间编号必须为数字！");
return;
}
db.InsertWorkshop(ws);
wsmPage.FillListView();
this.Close();
return;
}
}
private void btn_Modify_Click(object sender, RoutedEventArgs e)
{
Workshop modifiedWorkshop = new Workshop();
if (txt_WorkshopName.Text != OriginWorkshop.Name)
{
if (db.QueryWorkshopByName(txt_WorkshopName.Text).Count() > 0)
{
SystemSounds.Beep.Play();
MessageBox.Show("已存在车间名称：" + txt_WorkshopName.Text + "!");
return;
}
}
if (txt_WorkshopId.Text != OriginWorkshop.Id.ToString())
{
if (db.QueryWorkshopById(int.Parse(txt_WorkshopId.Text)).Count() > 0)
{
SystemSounds.Beep.Play();
MessageBox.Show("已存在车间编号：" + txt_WorkshopId.Text + "!");
return;
}
}
modifiedWorkshop.Name = txt_WorkshopName.Text;
try
{
modifiedWorkshop.Id = int.Parse(txt_WorkshopId.Text);
}
catch
{
SystemSounds.Beep.Play();
MessageBox.Show("车间编号必须为数字！");
return;
}
try
{
db.DeleteWorkshopById(OriginWorkshop.Id);
}
catch
{
SystemSounds.Beep.Play();
MessageBox.Show("更改失败！");
return;
}
db.InsertWorkshop(modifiedWorkshop);
wsmPage.FillListView();
this.Close();
}