private XialiaoOrder getXialiaoOrder() { XialiaoOrder xialiaoOrder = constructXialiaoOrder(); Console.WriteLine("dataGridViewItem.Rows.Count:" + dataGridViewItem.Rows.Count); foreach (DataGridViewRow row in dataGridViewItem.Rows) { if (row.IsNewRow) { continue; } XialiaoOrderItem item = constructXialiaoOrderItem(xialiaoOrder, row); xialiaoOrder.XialiaoOrderItems.AddLast(item); } Console.WriteLine("dataGridViewItemStats.Rows.Count: " + dataGridViewItemStats.Rows.Count); foreach (DataGridViewRow row in dataGridViewItemStats.Rows) { if (row.IsNewRow) { continue; } XialiaoOrderStats stats = constructXialiaoOrderStats(xialiaoOrder, row); xialiaoOrder.XialiaoOrderstats.AddLast(stats); } return(xialiaoOrder); }
private decimal computeWorkingNumberX(XialiaoOrderItem xialiaoOrderItem, TypeOfProcess workingNameX, ProcessingImage workingDiagramX) { decimal value = 0; OrderItem orderItem = xialiaoOrderItem.OrderItem; if (null == workingNameX || null == workingDiagramX) { return(0); } else { TypeOfProcess typePro = workingNameX; if (Parameter.PACKAGE.Equals(typePro.Unit)) { value = orderItem.Package; } else if (Parameter.METER.Equals(typePro.Unit)) { ProcessingImage proImage = workingDiagramX; int length = 0, width = 0, package = 0; length = Util.getValueOfLWT2(orderItem.Length); width = Util.getValueOfLWT2(orderItem.Width); package = xialiaoOrderItem.UsePackage; decimal sum = 0; if (proImage.Up) { sum += ((decimal)length) / 1000 * package; } if (proImage.Down) { sum += ((decimal)length) / 1000 * package; } if (proImage.Left) { sum += ((decimal)width) / 1000 * package; } if (proImage.Right) { sum += ((decimal)width) / 1000 * package; } value = decimal.Round(sum, Parameter.NUMBER_MANTISSA); } else { MessageBox.Show("不认识的加工类型", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); } } return(value); }
private XialiaoOrderItem constructXialiaoOrderItem(XialiaoOrder xialiaoOrder, DataGridViewRow row) { XialiaoOrderItem item = new XialiaoOrderItem(Util.getIntValue(row.Cells["ColumnXialiaoItemID"].FormattedValue.ToString())); item.OrderItem = new OrderItem(Util.getIntValue(row.Cells["ColumnItemID"].FormattedValue.ToString())); item.XialiaoOrder = xialiaoOrder; item.OriginalPackage = int.Parse(row.Cells["ColumnPackage"].Value.ToString()); item.RemainPackage = int.Parse(row.Cells["ColumnRemainPackage"].Value.ToString()); item.UsePackage = int.Parse(row.Cells["ColumnUsePackage"].Value.ToString()); item.WorkingNumber1 = Util.getDecimalValue(row.Cells["ColumnNumber1"].Value.ToString()); item.WorkingNumber2 = Util.getDecimalValue(row.Cells["ColumnNumber2"].Value.ToString()); item.WorkingNumber3 = Util.getDecimalValue(row.Cells["ColumnNumber3"].Value.ToString()); return(item); }
private void fillXialiaoOrderItemRow(XialiaoOrderItem xialiaoItem, DataGridViewRow row) { OrderItem item = xialiaoItem.OrderItem; row.Cells["ColumnXialiaoItemID"].Value = xialiaoItem.Id; row.Cells["ColumnItemID"].Value = xialiaoItem.OrderItem.Id; row.Cells["ColumnCategoryStone"].Tag = item.CategoryOfStone; row.Cells["ColumnCategoryStone"].Value = item.CategoryOfStone.Name; row.Cells["ColumnProductName"].Tag = item.ProductName; row.Cells["ColumnProductName"].Value = item.ProductName.Name; row.Cells["ColumnLength"].Value = item.Length; row.Cells["ColumnWidth"].Value = item.Width; row.Cells["ColumnThickness"].Value = item.Thickness; row.Cells["ColumnPackage"].Value = xialiaoItem.OriginalPackage; // row.Cells["ColumnRemainPackage"].Value = xialiaoItem.RemainPackage; // row.Cells["ColumnUsePackage"].Value = xialiaoItem.UsePackage; // row.Cells["ColumnUnit"].Value = item.Unit; row.Cells["ColumnNumber"].Value = item.Number; row.Cells["ColumnUnitPrice"].Value = item.UnitPrice; row.Cells["ColumnCost"].Value = item.Cost; row.Cells["ColumnDiagram1"].Value = null == item.WorkingDiagram1 ? null : item.WorkingDiagram1.Image; row.Cells["ColumnDiagram1"].Tag = item.WorkingDiagram1; row.Cells["ColumnName1"].Tag = item.WorkingName1; row.Cells["ColumnName1"].Value = (null == item.WorkingName1 ? "" : item.WorkingName1.Name); row.Cells["ColumnNumber1"].Value = xialiaoItem.WorkingNumber1; // row.Cells["ColumnDiagram2"].Value = null == item.WorkingDiagram2 ? null : item.WorkingDiagram2.Image; row.Cells["ColumnDiagram2"].Tag = item.WorkingDiagram2; row.Cells["ColumnName2"].Tag = item.WorkingName2; row.Cells["ColumnName2"].Value = (null == item.WorkingName2 ? "" : item.WorkingName2.Name); row.Cells["ColumnNumber2"].Value = xialiaoItem.WorkingNumber2; // row.Cells["ColumnDiagram3"].Value = null == item.WorkingDiagram3 ? null : item.WorkingDiagram3.Image; row.Cells["ColumnDiagram3"].Tag = item.WorkingDiagram3; row.Cells["ColumnName3"].Tag = item.WorkingName3; row.Cells["ColumnName3"].Value = (null == item.WorkingName3 ? "" : item.WorkingName3.Name); row.Cells["ColumnNumber3"].Value = xialiaoItem.WorkingNumber3; // }
private void fillXialiaoOrderItems(XialiaoOrder xialiaoOrder) { string sql = "SELECT * FROM tb_order_item_view AS toiv LEFT JOIN " + "(SELECT sum(use_package) AS total_use_package, order_item_id FROM tb_xialiao_order_item GROUP BY order_item_id, order_item_id) AS txoi " + "ON toiv.id = txoi.order_item_id WHERE toiv.[order] = " + xialiaoOrder.Order.Id; try { DataSet dataset = database.RunProcReturn(sql, "tb_xialiao_order_item_view"); int count = 0; if (null != dataset && (count = dataset.Tables[0].Rows.Count) > 0) { int i = 0; for (i = 0; i < count; i++) { OrderItem item = purchaseOrderDao.parseOrderItem(dataset, i); item.Order = xialiaoOrder.Order; XialiaoOrderItem xialiaoOrderItem = new XialiaoOrderItem(); xialiaoOrderItem.OrderItem = item; xialiaoOrderItem.OriginalPackage = item.Package; xialiaoOrderItem.RemainPackage = item.Package - getIntValue(dataset, i, "total_use_package"); xialiaoOrderItem.UsePackage = xialiaoOrderItem.RemainPackage; //默认全部下完 xialiaoOrderItem.WorkingNumber1 = computeWorkingNumberX(xialiaoOrderItem, xialiaoOrderItem.OrderItem.WorkingName1, xialiaoOrderItem.OrderItem.WorkingDiagram1); xialiaoOrderItem.WorkingNumber2 = computeWorkingNumberX(xialiaoOrderItem, xialiaoOrderItem.OrderItem.WorkingName2, xialiaoOrderItem.OrderItem.WorkingDiagram2); xialiaoOrderItem.WorkingNumber3 = computeWorkingNumberX(xialiaoOrderItem, xialiaoOrderItem.OrderItem.WorkingName3, xialiaoOrderItem.OrderItem.WorkingDiagram3); xialiaoOrder.XialiaoOrderItems.AddLast(xialiaoOrderItem); } } } catch (Exception e) { Util.showError(e.Message); Console.WriteLine("178 purchaseDaoImpl: " + e.StackTrace); } }
private SqlParameter[] constructParamsForXialiaoOrderItem(XialiaoOrderItem xialiaoOrderItem) { SqlParameter[] prams = { database.MakeInParam("@id", SqlDbType.Int, 0, xialiaoOrderItem.Id), database.MakeInParam("@xialiao_order_id", SqlDbType.Int, 0, xialiaoOrderItem.XialiaoOrder.Id), database.MakeInParam("@order_item_id", SqlDbType.Int, 0, xialiaoOrderItem.OrderItem.Id), database.MakeInParam("@original_package", SqlDbType.Int, 0, xialiaoOrderItem.OriginalPackage), database.MakeInParam("@remain_package", SqlDbType.Int, 0, xialiaoOrderItem.RemainPackage), database.MakeInParam("@use_package", SqlDbType.Int, 0, xialiaoOrderItem.UsePackage), database.MakeInParam("@working_number_1", SqlDbType.Decimal, 0, xialiaoOrderItem.WorkingNumber1), database.MakeInParam("@working_number_2", SqlDbType.Decimal, 0, xialiaoOrderItem.WorkingNumber2), database.MakeInParam("@working_number_3", SqlDbType.Decimal, 0, xialiaoOrderItem.WorkingNumber3), new SqlParameter("@message", SqlDbType.NVarChar, 50), new SqlParameter("rval", SqlDbType.Int, 4) }; prams[prams.Length - 2].Direction = ParameterDirection.Output; prams[prams.Length - 1].Direction = ParameterDirection.ReturnValue; return(prams); }
private void fillXialiaoOrderItemsForGET(XialiaoOrder xialiaoOrder) { string sql = "SELECT * FROM tb_xialiao_order_item WHERE xialiao_order_id = " + xialiaoOrder.Id; try { DataSet dataset = database.RunProcReturn(sql, "tb_xialiao_order_item"); int count = 0; if (null != dataset && (count = dataset.Tables[0].Rows.Count) > 0) { int i = 0; for (i = 0; i < count; i++) { OrderItem item = purchaseOrderDao.getOrderItemById(getIntValue(dataset, i, "order_item_id")); item.Order = xialiaoOrder.Order; XialiaoOrderItem xialiaoOrderItem = new XialiaoOrderItem(getIntValue(dataset, i, "id")); xialiaoOrderItem.OrderItem = item; xialiaoOrderItem.OriginalPackage = getIntValue(dataset, i, "original_package"); xialiaoOrderItem.RemainPackage = getIntValue(dataset, i, "remain_package"); xialiaoOrderItem.UsePackage = getIntValue(dataset, i, "use_package"); xialiaoOrderItem.WorkingNumber1 = getDecimalValue(dataset, i, "working_number_1"); xialiaoOrderItem.WorkingNumber2 = getDecimalValue(dataset, i, "working_number_2"); xialiaoOrderItem.WorkingNumber3 = getDecimalValue(dataset, i, "working_number_3"); xialiaoOrder.XialiaoOrderItems.AddLast(xialiaoOrderItem); } } } catch (Exception e) { Util.showError(e.Message); Console.WriteLine("178 purchaseDaoImpl: " + e.StackTrace); } }