/// <summary> /// 删除订单,先删除外键表,在删主表 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void toolStripButton3_Click(object sender, EventArgs e) { //订单删除后 记得把Enable=False的还原 BLLSalesOrders.SalesManagerServiceClient salesClient = WCFServiceBLL.GetSalesService(); //删除多条数据注意回滚 if (listViewOrders.SelectedItems.Count > 0) { if (MessageBox.Show("确定要删除吗?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { salesID = (listViewOrders.SelectedItems[0].Tag as Model.SalesOrdersModel).ID; if (salesClient.GetSalesCommoditiesByID(salesID).Length == 0 || salesClient.DeleteSalesCommoditiesBySalesOrderID(salesID)) { if (salesClient.DeleteOrderID(salesID)) { MessageBox.Show("删除成功"); //dataGridViewCommoditiesList.Rows.Clear(); dataGridViewCommoditiesList.DataSource = null; labelOrderNumber.Text = "[]"; labelOrderDate.Text = "[]"; labelContract.Text = "[]"; labelTel.Text = "[]"; labelCustomerName.Text = "[]"; labelAddress.Text = "[]"; GetSalesOrdersList(); } } } } else { MessageBox.Show("请选择一条订单"); } }
/// <summary> /// 展示订单中详细产品 /// </summary> private void GetOrderDetail() { //通过调试得知:第一次进入时GetOrderDetail执行一次,且第一个就是listViewOrders.SelectedItems.Count>0 //之后在触发事件,调用这个方法时,要执行两遍GetOrderDetail,第一遍listViewOrders.SelectedItems.Count>)不成立,第二遍成立 if (listViewOrders.SelectedItems.Count > 0) { toolStripButton4.Enabled = true; toolStripButton5.Enabled = true; toolStripButton6.Enabled = true; toolStripButton8.Enabled = true; ListViewItem item = listViewOrders.SelectedItems[0]; selectOrder = (Model.SalesOrdersModel)item.Tag; labelOrderNumber.Text = "[" + selectOrder.OrderNumber + "]"; labelOrderDate.Text = "[" + selectOrder.OrderDate.ToString("yyyy-MM-dd HH:mm:ss") + "]"; labelStatus.Text = "[" + selectOrder.Status + "]"; labelContract.Text = "[" + selectOrder.Contract + "]"; labelTel.Text = "[" + selectOrder.Tel + "]"; labelCustomerName.Text = "[" + selectOrder.CustomerName + "]"; labelAddress.Text = "[" + selectOrder.Address + "]"; BLLSalesOrders.SalesManagerServiceClient client = WCFServiceBLL.GetSalesService(); List <Model.SalesCommodityModel> salesCommoditiesList = client.GetSalesCommoditiesByID(selectOrder.ID).ToList(); dataGridViewCommoditiesList.DataSource = salesCommoditiesList; } else { clearShowOrderItmList(); } }
/// <summary> /// 手动更新销售单总价 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void toolStripButton8_Click(object sender, EventArgs e) { BLLSalesOrders.SalesManagerServiceClient salesClient = WCFServiceBLL.GetSalesService(); if (listViewOrders.SelectedItems.Count > 0) { decimal refreshTotalPrice = 0.0M; SalesOrdersModel selectedSalesOrder = listViewOrders.SelectedItems[0].Tag as Model.SalesOrdersModel; List <Model.SalesCommodityModel> listSalesCommoditys = salesClient.GetSalesCommoditiesByID(selectedSalesOrder.ID).ToList(); foreach (SalesCommodityModel orderItem in listSalesCommoditys) { refreshTotalPrice += orderItem.TotalPrice; } selectedSalesOrder.Contract = refreshTotalPrice.ToString(); if (salesClient.UpdateSalesOrder(selectedSalesOrder)) { labelContract.Text = selectedSalesOrder.Contract; } else { MessageBox.Show("更新订单总价失败!"); } } else { MessageBox.Show("请选择一条订单"); } }
/// <summary> /// 提交订单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void toolStripButton7_Click(object sender, EventArgs e) { //没有产品不能提交订单 if (selectOrder == null) { MessageBox.Show("请先选择一个订单"); return; } if (MessageBox.Show("确定要提交该订单吗?", "提交", MessageBoxButtons.YesNo) == DialogResult.Yes) { try { BLLSalesOrders.SalesManagerServiceClient client = WCFServiceBLL.GetSalesService(); if (client.PostSalesOrder(selectOrder.ID)) { listViewOrders.SelectedItems[0].Tag = client.GetOneSalesOrder(selectOrder.ID); GetOrderDetail(); } } catch (FaultException <Exception> ex) { MessageBox.Show(ex.Message); } } }
/// <summary> /// 查询展示订单列表 /// </summary> public void GetSalesOrdersList() { //Tag里面绑定了对象的详细信息 BLLSalesOrders.SalesManagerServiceClient salesServiceClient = WCFServiceBLL.GetSalesService(); List <Model.SalesOrdersModel> listSalesOrders = salesServiceClient.GetSalesOrders(textBoxOrderNumber.Text, textBoxdateStart.Text, textBoxdateEnd.Text, comboBoxStatus.Text).ToList(); listViewOrders.Items.Clear(); foreach (Model.SalesOrdersModel salesOneOrder in listSalesOrders) { ListViewItem item = new ListViewItem(); item.Text = salesOneOrder.OrderNumber + "(" + salesOneOrder.CustomerName + "||" + salesOneOrder.Contract + ")"; item.Tag = salesOneOrder; listViewOrders.Items.Add(item); } clearShowOrderItmList(); }
private void AddSalesOrder_Load(object sender, EventArgs e) { if (isUpdate) { //Model.SalesOrdersModel salesOrder =new BLLSalesOrders.SalesManagerServiceClient() BLLSalesOrders.SalesManagerServiceClient salesClient = WCFServiceBLL.GetSalesService(); SalesOrdersModel order = salesClient.GetOneSalesOrder(orderID); labelCustomerId.Text = order.CustomerId.ToString(); textBoxOrderNumber.Text = order.OrderNumber; textBoxCustomer.Text = order.CustomerName; labelTotalMoney.Text = "[]"; textBoxTel.Text = order.Tel; textBoxAddress.Text = order.Address; textBoxContract.Text = order.Contract; } }
/// <summary> /// 订单中新增产品 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void toolStripButton4_Click(object sender, EventArgs e) { //已出库就不能新增产品了吧 if (selectOrder == null) { MessageBox.Show("请选择一个订单!"); return; } AddSalesCommodities salesCommodity = new AddSalesCommodities(); salesCommodity.SalesOrderID = selectOrder.ID; if (salesCommodity.ShowDialog() == DialogResult.OK) { BLLSalesOrders.SalesManagerServiceClient client = WCFServiceBLL.GetSalesService(); List <Model.SalesCommodityModel> salesCommoditiesList = client.GetSalesCommoditiesByID(selectOrder.ID).ToList(); dataGridViewCommoditiesList.DataSource = salesCommoditiesList; } }
private void AddSalesCommodities_Load(object sender, EventArgs e) { if (IsUpdate) { //加载页面 BLLSalesOrders.SalesManagerServiceClient salesClinet = WCFServiceBLL.GetSalesService(); Model.SalesCommodityModel salesCommodity = salesClinet.GetOneSalesCommodityByID(CID); UpdateID = salesCommodity.ID; SalesCommodityID = salesCommodity.CommodityID; textBoxName.Text = salesCommodity.CommodityName; labelManufacturer.Text = "[" + salesCommodity.CommodityManufacturer + "]"; labelType.Text = "[" + salesCommodity.CommodityType + "]"; textBoxCount.Text = salesCommodity.Count.ToString(); textBoxPrice.Text = salesCommodity.SalesPrice.ToString(); labelUnit.Text = "[" + salesCommodity.CommodityUnit + "]"; } }
/// <summary> /// 修改订单中产品 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void toolStripButton5_Click(object sender, EventArgs e) { //订单已经提交的情况下,不能修改产品 if (dataGridViewCommoditiesList.SelectedRows.Count > 0) { int cID = int.Parse(dataGridViewCommoditiesList.SelectedRows[0].Cells["ColumnID"].Value.ToString()); AddSalesCommodities updateSalesCommodityForm = new AddSalesCommodities(cID); updateSalesCommodityForm.SalesOrderID = selectOrder.ID; if (updateSalesCommodityForm.ShowDialog() == DialogResult.OK) { BLLSalesOrders.SalesManagerServiceClient client = WCFServiceBLL.GetSalesService(); dataGridViewCommoditiesList.DataSource = client.GetSalesCommoditiesByID(selectOrder.ID); } } else { MessageBox.Show("请选择要修改的商品"); return; } }
private void toolStripButton6_Click(object sender, EventArgs e) { //订单已经提交的情况下,不能删除 if (dataGridViewCommoditiesList.SelectedRows.Count > 0) { int cID = int.Parse(dataGridViewCommoditiesList.SelectedRows[0].Cells["ColumnID"].Value.ToString()); if (MessageBox.Show("确定要删除吗?", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { BLLSalesOrders.SalesManagerServiceClient salesClient = WCFServiceBLL.GetSalesService(); if (salesClient.DeleteSalesCommodity(cID)) { BLLSalesOrders.SalesManagerServiceClient client = WCFServiceBLL.GetSalesService(); dataGridViewCommoditiesList.DataSource = client.GetSalesCommoditiesByID(selectOrder.ID); } } } else { MessageBox.Show("请选择一条记录"); } }
private void GetUpdateOrderDetail() { toolStripButton4.Enabled = true; toolStripButton5.Enabled = true; toolStripButton6.Enabled = true; toolStripButton8.Enabled = true; //ListViewItem item = listViewOrders.SelectedItems[0]; //selectOrder = (Model.SalesOrdersModel)item.Tag; BLLSalesOrders.SalesManagerServiceClient salesClient = WCFServiceBLL.GetSalesService(); selectOrder = salesClient.GetOneSalesOrder(salesID); labelOrderNumber.Text = "[" + selectOrder.OrderNumber + "]"; labelOrderDate.Text = "[" + selectOrder.OrderDate.ToString("yyyy-MM-dd HH:mm:ss") + "]"; labelContract.Text = "[" + selectOrder.Contract + "]"; labelTel.Text = "[" + selectOrder.Tel + "]"; labelCustomerName.Text = "[" + selectOrder.CustomerName + "]"; labelAddress.Text = "[" + selectOrder.Address + "]"; labelContract.Text = "[" + selectOrder.Contract + "]"; BLLSalesOrders.SalesManagerServiceClient client = WCFServiceBLL.GetSalesService(); List <SalesCommodityModel> salesCommoditiesList = client.GetSalesCommoditiesByID(selectOrder.ID).ToList(); dataGridViewCommoditiesList.DataSource = salesCommoditiesList; }
private void buttonOK_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(textBoxOrderNumber.Text)) { MessageBox.Show("订单编号不能为空"); return; } Model.SalesOrdersModel salesOrder = new Model.SalesOrdersModel(); salesOrder.OrderNumber = textBoxOrderNumber.Text; salesOrder.CustomerId = string.IsNullOrWhiteSpace(labelCustomerId.Text) ? 0 : int.Parse(labelCustomerId.Text); salesOrder.CustomerName = textBoxCustomer.Text; salesOrder.Address = textBoxAddress.Text; salesOrder.Tel = textBoxTel.Text; salesOrder.Contract = textBoxContract.Text; salesOrder.OrderDate = DateTime.Now; BLLSalesOrders.SalesManagerServiceClient salesClient = WCFServiceBLL.GetSalesService(); if (isUpdate) { salesOrder.ID = orderID; if (!salesClient.UpdateSalesOrder(salesOrder)) { MessageBox.Show("订单更新失败"); this.DialogResult = DialogResult.None; } } else { var order = salesClient.AddSalesOrder(salesOrder); if (order == null) { MessageBox.Show("新增订单失败"); this.DialogResult = DialogResult.None; } AddSalesID = order.ID; } }
private void buttonSave_Click(object sender, EventArgs e) { if (IsUpdate) { int count = 0; decimal price = 0.0M; try { count = int.Parse(textBoxCount.Text); price = decimal.Parse(textBoxPrice.Text); } catch { MessageBox.Show("数量或金额有误!"); return; } Model.SalesCommodityModel oneSalesCommodity = new Model.SalesCommodityModel(); oneSalesCommodity.ID = UpdateID; oneSalesCommodity.SalesOrderID = SalesOrderID; oneSalesCommodity.CommodityID = SalesCommodityID; oneSalesCommodity.Count = count; oneSalesCommodity.SalesPrice = price; oneSalesCommodity.TotalPrice = count * price;//这儿是个业务 BLLSalesOrders.SalesManagerServiceClient client = WCFServiceBLL.GetSalesService(); if (client.UpdateCommodity(oneSalesCommodity)) { MessageBox.Show("更新成功!"); } } else { if (SalesCommodityID == 0) { MessageBox.Show("请选择一个产品"); return; } int count = 0; decimal price = 0.0M; try { count = int.Parse(textBoxCount.Text); price = decimal.Parse(textBoxPrice.Text); } catch { MessageBox.Show("数量或金额有误!"); return; } Model.SalesCommodityModel oneSalesCommodity = new Model.SalesCommodityModel(); oneSalesCommodity.SalesOrderID = SalesOrderID; oneSalesCommodity.CommodityID = SalesCommodityID; oneSalesCommodity.Count = count; oneSalesCommodity.SalesPrice = price; oneSalesCommodity.TotalPrice = count * price;//这儿是个业务 BLLSalesOrders.SalesManagerServiceClient client = WCFServiceBLL.GetSalesService(); oneSalesCommodity = client.AddSalesCommodity(oneSalesCommodity); if (oneSalesCommodity.Equals(null)) { MessageBox.Show("保存失败"); this.DialogResult = DialogResult.None; } } }