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