コード例 #1
0
        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();
            }
        }
コード例 #2
0
        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);
            }
        }
コード例 #3
0
        public List <updateNonOperation_Vo> UpdateNop(updateNonOperation_Vo item)
        {
            NonOperation_Dac dac = new NonOperation_Dac();

            return(dac.UpdateNop(item));
        }