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