private void btn_Delete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("삭제 하시겠습니까?", "알림", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
Inspect_Service service = new Inspect_Service();
Inspect_Vo vo = new Inspect_Vo();
vo.Item_Name = txt_Item.Text;
vo.Condition_Val = u;
vo.Wc_Name = txt_WorkPlace.Text;
vo.Condition_Group = g;
service.deleteVal(vo);
SetVal();
}
}
public List <Inspect_Vo> deleteVal(Inspect_Vo item)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = "deleteVal";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Item_Name", item.Item_Name);
cmd.Parameters.AddWithValue("@Condition_Val", item.Condition_Val);
cmd.Parameters.AddWithValue("@Wc_Name", item.Wc_Name);
cmd.Parameters.AddWithValue("@Condition_Group", item.Condition_Group);
cmd.Connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
List <Inspect_Vo> list = Helper.DataReaderMapToList <Inspect_Vo>(reader);
cmd.Connection.Close();
return(list);
}
}
public List <Inspect_Vo> deleteVal(Inspect_Vo item)
{
Inspect_Dac dac = new Inspect_Dac();
return(dac.deleteVal(item));
}
