/// <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("발주내역이 수정되었습니다."); }