private void btn_Write_Click(object sender, EventArgs e)
{
if (MessageBox.Show("변경 하시겠습니까?", "알림", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
NonOperation_Service service = new NonOperation_Service();
updateNonOperation_Vo vo = new updateNonOperation_Vo();
vo.Nop_Ma_Name = txt_Hap.Text;
vo.Nop_Mi_Name = txt_Detail.Text;
vo.Nop_Ma_Name1 = cb_Hap.Text;
vo.Nop_Mi_Name1 = txt_Detail1.Text;
service.UpdateNop(vo);
this.Close();
}
}
public List <updateNonOperation_Vo> UpdateNop(updateNonOperation_Vo item)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandText = "UpdateNop";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Nop_Ma_Name", item.Nop_Ma_Name);
cmd.Parameters.AddWithValue("@Nop_Mi_Name", item.Nop_Mi_Name);
cmd.Parameters.AddWithValue("@Nop_Ma_Name1", item.Nop_Ma_Name1);
cmd.Parameters.AddWithValue("@Nop_Mi_Name1", item.Nop_Mi_Name1);
cmd.Connection.Open();
SqlDataReader reader = cmd.ExecuteReader();
List <updateNonOperation_Vo> list = Helper.DataReaderMapToList <updateNonOperation_Vo>(reader);
cmd.Connection.Close();
return(list);
}
}
public List <updateNonOperation_Vo> UpdateNop(updateNonOperation_Vo item)
{
NonOperation_Dac dac = new NonOperation_Dac();
return(dac.UpdateNop(item));
}