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