//public bool UpdateShipInfo(int shipId, string shipDate, decimal freight, int orderID)
public bool UpdateShipInfo(OrderVO order)
{
string sql = @"update Orders
set ShipVia=@shipId, ShippedDate=@shipDate, Freight=@freight
where OrderID = @orderID";
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddWithValue("@shipId", order.ShipVia);
cmd.Parameters.AddWithValue("@shipDate", order.ShippedDate);
cmd.Parameters.AddWithValue("@freight", order.Freight);
cmd.Parameters.AddWithValue("@orderID", order.OrderID);
int iRowAffect = cmd.ExecuteNonQuery();
conn.Close();
if (iRowAffect > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public Order MapOrderVoToEntity(OrderVO orderVO)
{
Order order = orderVO.MapTo<Order>();
order.OrderItems.ToList().ForEach(x => x.Order = order);
return order;
}
private void dgvProduct_KeyUp(object sender, KeyEventArgs e)
{
if (e.KeyCode.Equals(Keys.Enter))
{
if (dgvProduct[5, rowindex].Value.ToString().Trim() != "")
{
if (orderList == null)
{
orderList = new List <OrderVO>();
}
string prodID = dgvProduct[3, rowindex].Value.ToString();
int idx = orderList.FindIndex(p => p.product_id == prodID);
if (idx > -1)
{
orderList[idx].order_count = Convert.ToInt32(dgvProduct[5, rowindex].Value);
}
else
{
OrderVO newItem = new OrderVO();
newItem.product_id = dgvProduct[3, rowindex].Value.ToString();
newItem.company_id = Convert.ToInt32(dgvProduct[1, rowindex].Value);
newItem.order_count = Convert.ToInt32(dgvProduct[5, rowindex].Value);
orderList.Add(newItem);
}
}
}
}
public OrderVO Create(OrderVO item)
{
var orderEntity = _converter.Parse(item);
orderEntity = _repository.Create(_converter.Parse(item));
return(_converter.Parse(orderEntity));
}
private void btnShip_Click(object sender, EventArgs e)
{
//유효성체크
if (cboShipper.SelectedIndex < 1 || txtFreight.Text.Trim().Length < 1)
{
MessageBox.Show("배송정보를 입력하세요.");
return;
}
//선택된 주문ID의 배송정보를 UPDATE
OrderVO order = new OrderVO
{
ShipVia = Convert.ToInt32(cboShipper.SelectedValue),
ShippedDate = dtpShippedDate.Value.ToShortDateString(),
Freight = Convert.ToDecimal(txtFreight.Text.Trim()),
OrderID = int.Parse(lblOrderID.Text)
};
OrderService service = new OrderService();
if (service.UpdateShipInfo(order))
{
MessageBox.Show("배송처리가 완료되었습니다.");
btnSearch.PerformClick();
}
else
{
MessageBox.Show("배송처리중 오류가 발생했습니다. 다시 시도하여 주십시오.");
}
}
/// <summary>
/// 渠道下单接口(yanxuan.order.paid.create)
/// </summary>
public static OrderOut CreatePaidOrder(OrderVO order, ref string jsonstr)
{
try
{
var settings = new JsonSerializerSettings()
{
ContractResolver = new OrderedContractResolver()
};
var orderJson = JsonConvert.SerializeObject(order, Formatting.Indented, settings);
orderJson = orderJson.Replace("\r\n", "");
string postData = GenerateParameter("yanxuan.order.paid.create", new Dictionary <string, string> {
{ "order", orderJson }
});
jsonstr = WebRequestHelper.SendPostInfo(ApiUrl, postData);
LogHelper.Info("YXSV.CreatePaidOrder 渠道下单，Request: " + postData + "，Response: " + jsonstr);
var result = JsonConvert.DeserializeObject <YXResult <string> >(jsonstr);
if (result.Successed && !string.IsNullOrEmpty(result.Result))
{
return(JsonConvert.DeserializeObject <OrderOut>(result.Result));
}
else
{
LogHelper.Error("YXSV.CreatePaidOrder 渠道下单失败，Request: " + postData + "，Response: " + jsonstr);
}
}
catch (Exception ex)
{
LogHelper.Error("YXSV.CreatePaidOrder 渠道下单异常，Request: " + JsonConvert.SerializeObject(order), ex);
}
return(null);
}
private void InitRow(int index, OrderVO vo)
{
bool handled = vo.Handled == HANDLE_FLAG.HANDLED ? true : false;
if (handled)
{
dtgvOrders.Rows[index].Cells[colCkboxs.Name].ReadOnly = true;
dtgvOrders.Rows[index].DefaultCellStyle.BackColor = System.Drawing.Color.LightGray;
}
else
{
if (selectedOrdrMap.ContainsKey(vo.OrderNO__PK))
{
dtgvOrders.Rows[index].Cells[colCkboxs.Name].Value = "true";
}
}
dtgvOrders.Rows[index].Cells[colHandled.Name].Value = vo.Handled;
dtgvOrders.Rows[index].Cells[colAmount.Name].Value = vo.Amount;
dtgvOrders.Rows[index].Cells[colBillNO.Name].Value = StringUtil.isEmpty(vo.BillNO) ? "——" : vo.BillNO;
dtgvOrders.Rows[index].Cells[colCrtTmst.Name].Value = vo.CrtTmst;
dtgvOrders.Rows[index].Cells[colCrtUID.Name].Value = vo.CrtUID;
dtgvOrders.Rows[index].Cells[colCrtUName.Name].Value = vo.CrtUName;
dtgvOrders.Rows[index].Cells[colCustID.Name].Value = vo.CustID;
dtgvOrders.Rows[index].Cells[colDirectDesc.Name].Value = DIRECT.DIRECT_MAP[vo.Direct];
dtgvOrders.Rows[index].Cells[colDirect.Name].Value = vo.Direct;
dtgvOrders.Rows[index].Cells[colOrderNO.Name].Value = vo.OrderNO__PK;
}
private void dgvOrder_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvOrder.SelectedRows.Count < 1)
{
return;
}
//더블클릭해서 선택한 주문ID
int orderID = Convert.ToInt32(dgvOrder[0, e.RowIndex].Value);
//주문ID에 해당하는 주문상세내역
OrderService service = new OrderService();
dgvOrderDetail.DataSource = service.GetOrderDetailList(orderID);
dgvOrderDetail.ClearSelection();
//Ouput 파라미터 사용 예
lblAmount.Text = service.GetOrderAmount(orderID).ToString();
//주문목록에서 주문ID를 찾아서 상세정보를 컨트롤에 바인딩
List <OrderVO> list = (List <OrderVO>)dgvOrder.DataSource;
OrderVO order = list.Find(o => o.OrderID == orderID);
if (order != null)
{
lblOrderID.Text = order.OrderID.ToString();
lblCustomerName.Text = order.CompanyName;
lblEmployeeName.Text = order.EmployeeName;
lblOrderDate.Text = order.OrderDate;
lblRequiredDate.Text = order.RequiredDate;
//배송정보가 이미 등록된 경우, 확인하기 위해서 배송정보를 컨트롤에 바인딩
if (order.ShipVia != null)
{
cboShipper.SelectedValue = order.ShipVia.ToString();
}
else
{
cboShipper.SelectedIndex = 0;
}
dtpShippedDate.Value = string.IsNullOrEmpty(order.ShippedDate) ? DateTime.Now :
Convert.ToDateTime(order.ShippedDate);
txtFreight.Text = order.Freight.ToString();
if (order.ShipVia != null && txtFreight.Text.Length > 0)
{
btnShip.Enabled = false;
btnDelete.Enabled = false;
}
else
{
btnShip.Enabled = true;
btnDelete.Enabled = true;
}
}
}
/// <summary>
/// 신규 주문 등록
/// </summary>
/// <param name="order">주문정보</param>
/// <param name="ordDatails">주문상세내역</param>
/// <returns>주문등록 성공여부</returns>
public bool RegisterOrder(OrderVO order, List <OrderDetailVO> ordDatails)
{
using (SqlCommand cmd = new SqlCommand())
{
SqlTransaction trans = conn.BeginTransaction();
cmd.Connection = conn;
cmd.Transaction = trans;
try
{
//Order 테이블에 1건 Insert
cmd.CommandText = @"insert into Orders (CustomerID, EmployeeID, OrderDate, RequiredDate)
values (@CustomerID, @EmployeeID, @OrderDate, @RequiredDate);
select @@IDENTITY";
cmd.Parameters.AddWithValue("@CustomerID", order.CustomerID);
cmd.Parameters.AddWithValue("@EmployeeID", order.EmployeeID);
cmd.Parameters.AddWithValue("@OrderDate", DateTime.Now.ToShortDateString());
cmd.Parameters.AddWithValue("@RequiredDate", order.RequiredDate);
int orderID = Convert.ToInt32(cmd.ExecuteScalar());
//OrderDatail에 여러 건 Insert
cmd.CommandText = @"insert into [dbo].[Order Details] (OrderID, ProductID, UnitPrice, Quantity)
values (@OrderID, @ProductID, @UnitPrice, @Quantity)";
cmd.Parameters.AddWithValue("@OrderID", orderID);
cmd.Parameters.Add("@ProductID", SqlDbType.Int);
cmd.Parameters.Add("@UnitPrice", SqlDbType.Money);
cmd.Parameters.Add("@Quantity", SqlDbType.SmallInt);
foreach (OrderDetailVO detail in ordDatails)
{
cmd.Parameters["@ProductID"].Value = detail.ProductID;
cmd.Parameters["@UnitPrice"].Value = detail.UnitPrice;
cmd.Parameters["@Quantity"].Value = detail.Quantity;
cmd.ExecuteNonQuery();
}
trans.Commit();
conn.Close();
return(true);
}
catch (Exception err)
{
string msg = err.Message;
trans.Rollback();
conn.Close();
return(false);
}
}
}
public IActionResult PostOrder(OrderVO order)
{
if (order == null)
{
return(BadRequest());
}
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
order.TotalValue = order.itens.Sum(s => s.ProductValue);
return(new ObjectResult(_orderBusiness.Create(order)));
}
public async Task CreateOrderReturnsOrderFromHttpRequest()
{
requestHandler.SendPostRequest(END_POINT, Arg.Any <object>()).Returns(Task.Run <string>(() => ConvertToJson(new OrderVO {
orderId = "orderID", items = new List <ItemVO>()
})));
var expectedResult = new OrderVO {
orderId = "orderID", items = new List <ItemVO>()
};
var actualResult = await orderService.CreateOrder();
Assert.AreEqual(expectedResult.orderId, actualResult.orderId);
Assert.AreEqual(expectedResult.items.Count, actualResult.items.Count);
}
private void BtnCancel_Click(object sender, EventArgs e)
{
List <OrderVO> list = new List <OrderVO>();
foreach (DataGridViewRow row in dataGridView1.Rows)
{
bool isCellChecked = Convert.ToBoolean(row.Cells["chk"].EditedFormattedValue);
if (isCellChecked)
{
OrderVO vo = new OrderVO();
vo.order_id = row.Cells[1].Value.ToString();
vo.plan_id = row.Cells[2].Value.ToString();
vo.order_count = Convert.ToInt32(row.Cells[9].Value);
list.Add(vo);
}
}
//발주취소 버튼 (발주번호, PlanID 값)
PurchasingService service = new PurchasingService();
if (MessageBox.Show("발주 취소하시겠습니까?", "발주취소", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
bool result = service.UpdateOrder(list);
if (result)
{
MessageBox.Show("성공적으로 발주취소가 완료되었습니다.", "발주취소", MessageBoxButtons.OK, MessageBoxIcon.Information);
SetBottomStatusLabel("성공적으로 발주취소가 완료되었습니다.");
btnSearch.PerformClick();
}
else
{
MessageBox.Show("발주취소 실패하였습니다. 다시 시도하여 주십시오.", "발주취소", MessageBoxButtons.OK, MessageBoxIcon.Error);
SetBottomStatusLabel("발주취소 실패하였습니다. 다시 시도하여 주십시오.");
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
else
{
return;
}
}
private void btnEditDate_Click(object sender, EventArgs e)
{
OrderVO vo = new OrderVO();
vo.order_pdate = dataGridView1.SelectedRows[0].Cells[7].Value.ToString();
vo.order_id = dataGridView1.SelectedRows[0].Cells[1].Value.ToString();
vo.plan_id = dataGridView1.SelectedRows[0].Cells[2].Value.ToString();
EditDatePop frm = new EditDatePop(vo);
if (frm.ShowDialog() == DialogResult.OK)
{
btnSearch.PerformClick();
}
}
public async Task GetOrderReturnsOrder()
{
var orderID = "orderID";
requestHandler.SendGetRequest(END_POINT + "/" + orderID, Arg.Any <object>()).Returns(Task.Run <string>(() => ConvertToJson(new OrderVO {
orderId = orderID, items = new List <ItemVO>()
})));
var expectedResult = new OrderVO {
orderId = orderID, items = new List <ItemVO>()
};
var actualResult = await orderService.GetOrder(orderID);
Assert.AreEqual(expectedResult.orderId, actualResult.orderId);
Assert.AreEqual(expectedResult.items.Count, actualResult.items.Count);
}
/// <summary>
/// 납기일 변경
/// </summary>
/// <param name="vo"></param>
/// <returns></returns>
public bool UpdateOrderDate(OrderVO vo)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.CommandType = CommandType.Text;
cmd.CommandText = "update TBL_ORDER set order_pdate = @order_pdate where order_serial = @order_id and plan_id = @plan_id";
cmd.Parameters.AddWithValue("@order_pdate", vo.order_pdate);
cmd.Parameters.AddWithValue("@order_id", vo.order_id);
cmd.Parameters.AddWithValue("@plan_id", vo.plan_id);
cmd.Connection.Open();
var successRow = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(successRow > 0);
}
}
private void btnOrder_Click(object sender, EventArgs e)
{
//유효성체크
if (dgvCart.Rows.Count < 1)
{
MessageBox.Show("주문할 제품을 선택하여 주십시오.");
return;
}
if (cboCustomer.SelectedIndex < 1 || cboEmployee.SelectedIndex < 1)
{
MessageBox.Show("주문정보를 선택하여 주십시오.");
return;
}
//Order에 추가, IDentity조회해서 Order Details에 여러건 추가
try
{
OrderVO order = new OrderVO
{
CustomerID = cboCustomer.SelectedValue.ToString(),
EmployeeID = Convert.ToInt32(cboEmployee.SelectedValue),
RequiredDate = dtpRequiredDate.Value.ToShortDateString()
};
OrderService service = new OrderService();
bool bResult = service.RegisterOrder(order, cartList);
if (bResult)
{
cartList.Clear();
dgvCart.DataSource = null;
MessageBox.Show("주문이 완료되었습니다.");
}
else
{
MessageBox.Show("주문 처리 중 오류가 발생했습니다. 다시 시도하여 주십시오.");
}
}
catch (Exception err)
{
MessageBox.Show(err.Message);
}
}
// Click to confirm the order
private void btnConfirmOrder_Click(object sender, EventArgs e)
{
try
{
if (lbOrderItens.Items.Count == 0)
{
throw new ArgumentNullException("Não é possivel criar um pedido vazio");
}
if (txtCustomerName.TextLength == 0)
{
throw new ArgumentNullException("Insira o nome do cliente para criar o pedido");
}
if (!Regex.IsMatch(txtCustomerName.Text, @"^[a-zA-Z]+$"))
{
throw new InvalidOperationException("Insira apenas letras no nome.");
}
OrderVO order = Classes.Ordering.createOrder(txtCustomerName.Text, lbOrderItens.Items.Cast <String>().ToList());
OrderDAO.insertOrder(order);
updateOrder(lbQueue, order);
addLog("Pedido do " + order.CustomerName + " adicionado. O nº do pedido é: " + order.Id);
txtCustomerName.Text = "";
lbOrderItens.Items.Clear();
}
catch (InvalidOperationException error)
{
MessageBox.Show(error.Message);
}
catch (ArgumentNullException error)
{
MessageBox.Show(error.ParamName);
}
catch (Exception error)
{
MessageBox.Show(error.Message);
}
}
// Method to show details from the delivered order
private void lbDeliveredOrders_DoubleClick(object sender, EventArgs e)
{
if (lbDeliveredOrders.SelectedItem != null)
{
//lbDeliveredOrders.SelectedItem.ToString();
int id = Convert.ToInt32(lbDeliveredOrders.SelectedItem.ToString().Substring(0, lbDeliveredOrders.SelectedItem.ToString().IndexOf(':')));
OrderVO order = GlobalOrders.allOrders.Single <OrderVO>(o => o.Id == id);
string orderDescription = "#" + order.Id + " " + order.CustomerName + Environment.NewLine + "Itens do pedido:" + Environment.NewLine;
foreach (string item in order.Itens)
{
orderDescription += item + Environment.NewLine;
}
MessageBox.Show(orderDescription);
}
}
public async Task DeleteItemInOrderReturnsOrderWithUpdatedItem()
{
var orderID = "orderID";
var itemToAddToOrder = new ItemVO {
id = "item1", quantity = 2
};
requestHandler.SendDeleteRequest(END_POINT + "/" + orderID + "/item", itemToAddToOrder).Returns(Task.Run <string>(() => ConvertToJson(new OrderVO {
orderId = orderID, items = new List <ItemVO> {
}
})));
var expectedResult = new OrderVO {
orderId = orderID, items = new List <ItemVO> {
}
};
var actualResult = await orderService.RemoveItemFromOrder(orderID, itemToAddToOrder);
Assert.AreEqual(expectedResult.orderId, actualResult.orderId);
Assert.AreEqual(expectedResult.items.Count, actualResult.items.Count);
}
protected void btnSend_Click(object sender, EventArgs e)
{
try
{
OrderVO ovo = new OrderVO();
ovo.MemberID = new Member().SelectByUserName(Session["User"].ToString()).MemberID;
ovo.OrderDate = DateTime.Now;
ovo.RequiredDate = DateTime.Parse(RequiredDate.Text);
ovo.ShippedDate = DateTime.Now;
ovo.Total = Basket.Instance.GetSubTotal().ToString();
ovo.ShipAddress = txtAddress.Text;
ovo.ShipCity = txtCity.Text;
ovo.ShipCountry = txtCountry.Text;
ovo.Status = 1;
Order_Base order_base = new Order_Base();
int orderid = order_base.Insert(ovo);
Basket basket = Basket.Instance;
foreach (CartItem i in basket.Items)
{
OrdeDetailVO odvo = new OrdeDetailVO();
odvo.OrderID = orderid;
odvo.ProductID = i.ProductId;
odvo.Price = i.UnitPrice.ToString();
odvo.Amount = i.Quantity;
odvo.Discount = 0;
new OrdeDetail_Base().Insert(odvo);
}
basket.Items.Clear();
Session["ASPNETShoppingCart"] = null;
Response.Redirect("CreateOrderSuccess.htm");
}
catch (Exception ex)
{
Utilties.Alert.Show("Có lỗi xảy ra:" + ex.Message);
}
}
public bool UpdateShipInfo(OrderVO order)
{
OrderDAC dac = new OrderDAC();
return(dac.UpdateShipInfo(order));
}
public bool RegisterOrder(OrderVO order, List <OrderDetailVO> ordDetail)
{
OrderDAC dac = new OrderDAC();
return(dac.RegisterOrder(order, ordDetail));
}
private void btnAddOrder_Click(object sender, EventArgs e)
{
//발주버튼
List <OrderVO> list = new List <OrderVO>();
foreach (DataGridViewRow row in dgvOrdering.Rows)
{
bool isCellChecked = Convert.ToBoolean(row.Cells["chk"].EditedFormattedValue);
if (isCellChecked)
{
OrderVO vo = new OrderVO();
vo.product_codename = row.Cells[3].Value.ToString();
for (int i = 0; i < dgvCompany.Rows.Count; i++)
{
if (dgvCompany.Rows[i].Cells[0].Value.ToString() == row.Cells[2].Value.ToString())
{
vo.order_id = dgvCompany.Rows[i].Cells[1].Value.ToString();
}
}
vo.order_count = Convert.ToInt32(row.Cells[8].Value);
vo.plan_id = row.Cells[1].Value.ToString().Trim();
vo.order_pdate = row.Cells[5].Value.ToString().Trim();
list.Add(vo);
}
}
for (int i = 0; i < dgvCompany.Rows.Count; i++)
{
List <int> orders = new List <int>();
int num = 1;
for (int c = 0; c < list.Count; c++)
{
if (dgvCompany.Rows[i].Cells[1].Value.ToString() == list[c].order_id)
{
if (!orders.Contains(Convert.ToInt32(dgvCompany.Rows[i].Cells[1].Value)))
{
list[c].order_id += "-" + string.Format("{0:D4}", num);
orders.Add(Convert.ToInt32(dgvCompany.Rows[i].Cells[1].Value));
}
else
{
list[c].order_id += "-" + string.Format("{0:D4}", num);
}
num++;
}
}
}
if (MessageBox.Show("발주하시겠습니까?", "발주신청", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
PurchasingService service = new PurchasingService();
bool result = service.InsertOrder(list);
if (result)
{
MessageBox.Show("성공적으로 발주 완료하였습니다.", "발주신청", MessageBoxButtons.OK, MessageBoxIcon.Question);
this.Close();
}
else
{
MessageBox.Show("발주 실패하였습니다. 다시 시도하여 주십시오.", "발주신청", MessageBoxButtons.OK, MessageBoxIcon.Question);
return;
}
}
catch (Exception err)
{
LoggingUtility.GetLoggingUtility(err.Message, Level.Error);
}
}
else
{
return;
}
}
// Updates all queues
private void updateQueues(ListBox from, ListBox to = null)
{
switch (from.Name)
{
case "lbQueue":
if (lbQueue.Items.Count == 0 || lbStartedOrders.Items.Count >= 4)
{
return;
}
else
{
do
{
lbStartedOrders.Items.Add(lbQueue.Items[0]);
OrderVO hasOrder = Classes.GlobalOrders.allOrders.Single(cus => cus.Id == Convert.ToInt16(lbQueue.Items[0].ToString().Substring(0, lbQueue.Items[0].ToString().IndexOf(':'))));
addLog("O pedido de " + hasOrder.CustomerName + " foi atualizado para Iniciado.");
lbQueue.Items.RemoveAt(0);
} while (lbStartedOrders.Items.Count < 4 && lbQueue.Items.Count > 0);
}
break;
case "lbStartedOrders":
List <int> idUpdateList = new List <int>();
for (int n = 0; n < lbStartedOrders.Items.Count; n++)
{
int curTime = Convert.ToInt32(lbStartedOrders.Items[n].ToString().Substring(lbStartedOrders.Items[n].ToString().IndexOf('-') + 1));
if (curTime == 1)
{
idUpdateList.Add(Convert.ToInt16(lbStartedOrders.Items[n].ToString().Substring(0, lbStartedOrders.Items[n].ToString().IndexOf(':'))));
}
else
{
lbStartedOrders.Items[n] = lbStartedOrders.Items[n].ToString().Substring(0, lbStartedOrders.Items[n].ToString().IndexOf('-') + 1) + " " + (curTime - 1).ToString();
}
}
foreach (int id in idUpdateList)
{
List <String> listBoxList = lbStartedOrders.Items.Cast <string>().ToList();
int pos = listBoxList.FindIndex(c => Convert.ToInt32(c.Substring(0, c.IndexOf(':'))) == id);
lbFinishedOrders.Items.Add(lbStartedOrders.Items[pos].ToString().Substring(0, lbStartedOrders.Items[pos].ToString().IndexOf('-')));
OrderVO hasOrder = Classes.GlobalOrders.allOrders.Single(cus => cus.Id == Convert.ToInt16(lbStartedOrders.Items[pos].ToString().Substring(0, lbStartedOrders.Items[pos].ToString().IndexOf(':'))));
addLog("O pedido de " + hasOrder.CustomerName + " foi atualizado para Finalizado.");
lbStartedOrders.Items.Remove(lbStartedOrders.Items[pos]);
}
break;
case "lbFinishedOrders":
if (lbFinishedOrders.Items.Count > 0)
{
lbDeliveredOrders.Items.Add(lbFinishedOrders.Items[0].ToString());
OrderVO found = Classes.GlobalOrders.allOrders.Single(cus => cus.Id == Convert.ToInt16(lbFinishedOrders.Items[0].ToString().Substring(0, lbFinishedOrders.Items[0].ToString().IndexOf(':'))));
addLog("O pedido de " + found.CustomerName + " foi Entregue.");
lbFinishedOrders.Items.RemoveAt(0);
}
break;
case "lbDeliveredOrders":
break;
}
}
// Updates the orders from status' panels
private void updateOrder(ListBox toList, OrderVO order)
{
toList.Items.Add(order.Id + ": " + order.CustomerName + " - " + order.TotalTime);
}
/// <summary>
/// 발주 등록
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public bool InsertOrder(List <OrderVO> olist, HashSet <int> companySet, string employee_id)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(this.ConnectionString);
cmd.Connection.Open();
SqlTransaction tran = cmd.Connection.BeginTransaction();
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Transaction = tran;
int index = 0;
int result = 0;
foreach (int company_id in companySet)
{
cmd.Parameters.Clear();
cmd.CommandText = "SP_ORDER_INSERT";
cmd.Parameters.AddWithValue("@company_id", company_id);
cmd.Parameters.AddWithValue("@regist_employee", employee_id);
int num = Convert.ToInt32(cmd.ExecuteScalar());
int cnt = 1;
cmd.CommandText = "SP_ORDERDETAIL_INSERT";
cmd.Parameters.Clear();
cmd.Parameters.Add("@order_no", SqlDbType.Int);
cmd.Parameters.Add("@product_id", SqlDbType.Int);
cmd.Parameters.Add("@order_seq", SqlDbType.Int);
cmd.Parameters.Add("@order_request_quantity", SqlDbType.Int);
cmd.Parameters.Add("@order_status", SqlDbType.VarChar, 20);
cmd.Parameters.Add("@order_request_date", SqlDbType.DateTime);
cmd.Parameters.Add("@order_product_price", SqlDbType.Decimal);
for (; index < olist.Count; index++)
{
OrderVO item = olist[index];
if (item.company_id != company_id) //같으면 더하고 아니면 break 시키기
{
break;
}
cmd.Parameters["@order_no"].Value = num;
cmd.Parameters["@product_id"].Value = item.product_id;
cmd.Parameters["@order_seq"].Value = cnt;
cmd.Parameters["@order_request_quantity"].Value = item.order_request_quantity;
cmd.Parameters["@order_status"].Value = item.order_status;
cmd.Parameters["@order_request_date"].Value = item.order_request_date;
cmd.Parameters["@order_product_price"].Value = item.order_price;
cnt++;
result += cmd.ExecuteNonQuery();
}
num = 0;
}
tran.Commit();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception err)
{
tran.Rollback();
throw err;
}
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
dgvOrder.EndEdit();
List <OrderVO> olist = new List <OrderVO>();
List <int> cnt = new List <int>();
foreach (DataGridViewRow row in dgvOrder.Rows)
{
DataGridViewCheckBoxCell chk = (DataGridViewCheckBoxCell)dgvOrder[0, row.Index];
if (chk.Value == null)
{
continue;
}
else if ((bool)chk.Value == true)
{
cnt.Add(1);
}
}
if (cnt.Count < 1)
{
MessageBox.Show("발주 할 내역을 선택해주세요.");
return;
}
//dgvOrder.Sort(dgvOrder.Columns["company_id"], ListSortDirection.Ascending);
HashSet <int> companySet = new HashSet <int>();
string employee_id = "admin";
for (int i = 0; i < dgvOrder.RowCount; i++)
{
if (dgvOrder.Rows[i].Cells[0].Value != null)
{
bool IsCheck = (bool)dgvOrder.Rows[i].Cells[0].Value;
if (IsCheck && dgvOrder.Rows[i].Cells[10].Value != null)
{
int c_id = Convert.ToInt32(dgvOrder.Rows[i].Cells[3].Value);
OrderVO orderVO = new OrderVO();
orderVO.company_id = c_id;
orderVO.product_id = Convert.ToInt32(dgvOrder.Rows[i].Cells["_product_id"].Value);
orderVO.order_request_quantity = Convert.ToInt32(dgvOrder.Rows[i].Cells[10].Value);
orderVO.order_status = "발주중";
orderVO.order_seq = 1;
orderVO.order_request_date = DateTime.Now;
orderVO.order_price = Convert.ToDecimal(dgvOrder.Rows[i].Cells["order_product_price"].Value);
olist.Add(orderVO);
companySet.Add(c_id);
}
else if (IsCheck && dgvOrder.Rows[i].Cells[10].Value != null)
{
MessageBox.Show("발주 수량을 입력하지 않았습니다.");
return;
}
}
}
if (olist.Count > 0)
{
orderService.InsertOrder(olist, companySet, employee_id);
MessageBox.Show("발주 되었습니다. ");
this.Close();
}
else
{
MessageBox.Show("발주 실패");
}
}
public bool UpdateOrderDate(OrderVO vo)
{
PurchasingDAC dac = new PurchasingDAC();
return(dac.UpdateOrderDate(vo));
}
public EditDatePop(OrderVO vo)
{
InitializeComponent();
this.vo = vo;
}
