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