/// <summary>
/// 발주내역을 DB에 저장 시키고 입고내역의 교환이나 반품은 교환완이나 반품완으로 수정한다. 그리고 발주내역 LIST에 날짜로 출력시켜준다.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSaveOrderDetails_Click(object sender, EventArgs e)
{
orderDetailsVOsList = new List <OrderDetailsVO>();
string date = DateTime.Now.ToShortDateString().Replace("-", "").Substring(2, 6);
for (int i = 0; i < dgvNeedInventoryDetailView.Rows.Count; i++)
{
if (Int32.Parse(dgvNeedInventoryDetailView["필요수량", i].Value.ToString()) > 0)
{
OrderDetailsVO orderDetailsVO = new OrderDetailsVO();
if (dgvNeedInventoryDetailView["발주종류", i].Value.ToString() == "주문")
{
orderDetailsVO.OrderID = "OR" + date + (dgvNeedInventoryDetailView["재고종류코드", i].Value.ToString()).Substring(4, 2);
}
else if (dgvNeedInventoryDetailView["발주종류", i].Value.ToString().Contains("반품"))
{
orderDetailsVO.OrderID = "RE" + date + (dgvNeedInventoryDetailView["재고종류코드", i].Value.ToString()).Substring(4, 2);
new ReceivingDetailsDAO().UpdateReceivingDetails(dgvNeedInventoryDetailView["발주종류", i].Value.ToString().Substring(2, 10),
dgvNeedInventoryDetailView["발주종류", i].Value.ToString().Substring(0, 2));
}
else if (dgvNeedInventoryDetailView["발주종류", i].Value.ToString().Contains("교환"))
{
orderDetailsVO.OrderID = "EX" + date + (dgvNeedInventoryDetailView["재고종류코드", i].Value.ToString()).Substring(4, 2);
new ReceivingDetailsDAO().UpdateReceivingDetails(dgvNeedInventoryDetailView["발주종류", i].Value.ToString().Substring(2, 10),
dgvNeedInventoryDetailView["발주종류", i].Value.ToString().Substring(0, 2));
}
orderDetailsVO.OrderDate = DateTime.Parse(DateTime.Now.ToShortDateString());
orderDetailsVO.InventoryTypeCode = dgvNeedInventoryDetailView["재고종류코드", i].Value.ToString();
orderDetailsVO.Quantity = Int32.Parse(dgvNeedInventoryDetailView["필요수량", i].Value.ToString());
orderDetailsVOsList.Add(orderDetailsVO);
}
}
bool temp = false;
try
{
for (int i = 0; i < dgvOrderDetailsList.Rows.Count; i++)
{
if (dgvOrderDetailsList["발주날짜", i].Value.ToString() == DateTime.Now.ToShortDateString())
{
temp = true;
MessageBox.Show("이미 발주처리되었습니다. 발주내역List에서 수정하시기 바랍니다.");
}
}
if (!temp)
{
new OrderDetailsDAO().InsertOrderDetails(orderDetailsVOsList);
MessageBox.Show("발주내역 저장완료");
}
}
catch (SqlException)
{
MessageBox.Show("이미 발주처리되었습니다. 발주내역List에서 수정하시기 바랍니다.");
}
SelectOrderDetailsList();
}
/// <summary>
/// 발주내역 수정
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdateOrder_Click(object sender, EventArgs e)
{
List <OrderDetailsVO> orderDetailsVOList = new List <OrderDetailsVO>();
for (int i = 0; i < dgvNeedInventoryDetailView.Rows.Count; i++)
{
var orderDetailsVO = new OrderDetailsVO();
orderDetailsVO.OrderID = dgvNeedInventoryDetailView["발주번호", i].Value.ToString();
orderDetailsVO.Quantity = Int32.Parse(dgvNeedInventoryDetailView["수량", i].Value.ToString());
orderDetailsVOList.Add(orderDetailsVO);
}
new OrderDetailsDAO().UpdateOrderDetails(orderDetailsVOList);
dgvNeedInventoryDetailView.DataSource = new OrderDetailsDAO().SelectOrderDetails(dgvOrderDetailsList.SelectedRows[0].Cells["발주날짜"].Value.ToString());
MessageBox.Show("발주내역이 수정되었습니다.");
}
