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