private void btnCreate_Click(object sender, EventArgs e) { if (label1.Text == "발주 수정") { OrderService service = new OrderService(); OrderListVO vo = new OrderListVO() { order_id = Convert.ToInt32(label1.Tag), order_edate = dtpEdate.Text, order_count = Convert.ToInt32(nuCount.Value) }; if (service.UpdateOrder(vo) == 1) { MessageBox.Show("수정 완료"); this.Close(); } } else { SOService service = new SOService(); SOListVO vo = new SOListVO() { so_id = Convert.ToInt32(label1.Tag), so_edate = dtpEdate.Text, so_ocount = Convert.ToInt32(nuCount.Value) }; if (service.UpdateSO(vo) == 1) { MessageBox.Show("수정 완료"); this.Close(); } } }
public int UpdateOrder(OrderListVO vo) { string sql = "update TBL_ORDER set order_count = @ordercount, order_edate = @order_edate where order_id = @order_id"; using (SqlCommand cmd = new SqlCommand(sql, conn)) { try { cmd.Parameters.AddWithValue("@order_id", vo.order_id); cmd.Parameters.AddWithValue("@order_count", vo.order_count); cmd.Parameters.AddWithValue("@order_edate", vo.order_edate); cmd.ExecuteNonQuery(); conn.Close(); return(1); } catch (Exception err) { string msg = err.Message; return(0); } } }
public int UpdateOrder(OrderListVO vo) { OrderDAC dac = new OrderDAC(); return(dac.UpdateOrder(vo)); }