private void fillXialiaoOrderStatsForGET(XialiaoOrder xialiaoOrder) { string sql = "SELECT * FROM tb_xialiao_order_stats WHERE xialiao_order_id = " + xialiaoOrder.Id; try { DataSet dataset = database.RunProcReturn(sql, "tb_xialiao_order_stats"); int count = 0; if (null != dataset && (count = dataset.Tables[0].Rows.Count) > 0) { int i = 0; for (i = 0; i < count; i++) { XialiaoOrderStats stats = new XialiaoOrderStats(getIntValue(dataset, i, "id")); stats.XialiaoOrder = xialiaoOrder; stats.OrderStats = purchaseOrderDao.getOrderStatsById(getIntValue(dataset, i, "order_stats_id")); stats.TotalNumber = getDecimalValue(dataset, i, "total_number"); stats.AmountOfMoney = getDecimalValue(dataset, i, "amount_of_money"); xialiaoOrder.XialiaoOrderstats.AddLast(stats); } } } catch (Exception e) { Util.showError(e.Message); Console.WriteLine("178 purchaseDaoImpl: " + e.StackTrace); } }
private void fillXialiaoOrderStats(XialiaoOrder xialiaoOrder) { purchaseOrderDao.fillOrderStats(xialiaoOrder.Order); foreach (OrderStats stat in xialiaoOrder.Order.OrderStats) { XialiaoOrderStats stats = new XialiaoOrderStats(); stats.XialiaoOrder = xialiaoOrder; stats.OrderStats = stat; decimal totalNumber = 0; foreach (XialiaoOrderItem item in xialiaoOrder.XialiaoOrderItems) { if (item.OrderItem.Thickness.Equals(stat.ThicknessStats)) { if (null != item.OrderItem.WorkingName1 && item.OrderItem.WorkingName1.Id == stat.TypeOfProcess.Id) { totalNumber += item.WorkingNumber1; } if (null != item.OrderItem.WorkingName2 && item.OrderItem.WorkingName2.Id == stat.TypeOfProcess.Id) { totalNumber += item.WorkingNumber2; } if (null != item.OrderItem.WorkingName3 && item.OrderItem.WorkingName3.Id == stat.TypeOfProcess.Id) { totalNumber += item.WorkingNumber3; } } } stats.TotalNumber = totalNumber; stats.AmountOfMoney = totalNumber * stats.OrderStats.UnitPrice; xialiaoOrder.XialiaoOrderstats.AddLast(stats); } }
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 XialiaoOrderStats constructXialiaoOrderStats(XialiaoOrder xialiaoOrder, DataGridViewRow row) { XialiaoOrderStats stats = new XialiaoOrderStats(Util.getIntValue(row.Cells["ColumnXialiaoStatsID"].FormattedValue.ToString())); stats.OrderStats = new OrderStats(Util.getIntValue(row.Cells["ColumnStatsID"].Value.ToString())); stats.XialiaoOrder = xialiaoOrder; stats.TotalNumber = Util.getDecimalValue(row.Cells["ColumnNumberStats"].Value.ToString()); stats.AmountOfMoney = Util.getDecimalValue(row.Cells["ColumnCostStats"].Value.ToString()); return(stats); }
private SqlParameter[] constructParamsForXialiaoOrderStats(XialiaoOrderStats xialiaoOrderStats) { SqlParameter[] prams = { database.MakeInParam("@id", SqlDbType.Int, 0, xialiaoOrderStats.Id), database.MakeInParam("@xialiao_order_id", SqlDbType.Int, 0, xialiaoOrderStats.XialiaoOrder.Id), database.MakeInParam("@order_stats_id", SqlDbType.Int, 0, xialiaoOrderStats.OrderStats.Id), database.MakeInParam("@total_number", SqlDbType.Decimal, 0, xialiaoOrderStats.TotalNumber), database.MakeInParam("@amount_of_money", SqlDbType.Money, 0, xialiaoOrderStats.AmountOfMoney), 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 fillXialiaoOrderStatsRow(XialiaoOrderStats xialiaoStats, DataGridViewRow row) { OrderStats stats = xialiaoStats.OrderStats; row.Cells["ColumnXialiaoStatsID"].Value = xialiaoStats.Id; row.Cells["ColumnStatsID"].Value = stats.Id; row.Cells["ColumnProcessingName"].Tag = stats.TypeOfProcess; row.Cells["ColumnProcessingName"].Value = stats.TypeOfProcess.Name; row.Cells["ColumnThicknessStats"].Value = stats.ThicknessStats; row.Cells["ColumnProcessingDiagram"].Tag = stats.Image; row.Cells["ColumnProcessingDiagram"].Value = Util.getThumbnailImage(stats.Image); row.Cells["ColumnDWG"].Tag = stats.Dwg; row.Cells["ColumnUnitStats"].Value = stats.Unit; row.Cells["ColumnNumberStats"].Value = xialiaoStats.TotalNumber; // row.Cells["ColumnUnitPriceStats"].Value = stats.UnitPrice; row.Cells["ColumnCostStats"].Value = xialiaoStats.AmountOfMoney; // }