private void PlanningMain_Load(object sender, EventArgs e) { LoadDataPlanning loadData = new LoadDataPlanning(); orderVariables = new List <OrderVariable>(); orderVariables = loadData.LoadOrderInformationbyDate(from, to, ""); List <DataHeader> dataHeaders = new List <DataHeader>(); Dictionary <string, PlanningItem> keyValuePairs = loadData.GetPlanningReport(orderVariables); foreach (var item in keyValuePairs) { DataHeader data = new DataHeader(); data.products = item.Value.KeyProduct; data.clients = item.Value.Client; data.HENN = item.Value._bom.HEN; data.QtyInBox = item.Value._bom.QtyUnit; data.ToolPcs = item.Value._bom.ToolQty; data.StockWH = item.Value.wip.Warehouse; data.WIPQty = item.Value.wip.TotalInWip; data.MQCStock = item.Value.wip.MQCQty; data.PQCStock = item.Value.wip.PQCQty; data.IntoWH = item.Value.wip.StockInWHQTy; data.SemiStock = item.Value.wip.SemiFinished; dataHeaders.Add(data); } dtgv_header.DataSource = dataHeaders; }
private void LoadDataPlanningFFToShow(DateTime from, DateTime to) { try { LoadDataPlanning loadData = new LoadDataPlanning(); orderVariables = new List <OrderVariable>(); orderVariables = loadData.LoadOrderInformationbyDate(from, to, "FF"); List <DataHeader> dataHeaders = new List <DataHeader>(); ListPlanning = loadData.GetPlanningReport(orderVariables); listplanShipmentPage2 = new Dictionary <string, List <dataContent> >(); List <dataContent> datacontents = new List <dataContent>(); dataContent dataContent = new dataContent(); foreach (var item in ListPlanning) { datacontents = new List <dataContent>(); DataHeader data = new DataHeader(); data.products = item.Value.KeyProduct; data.Amount_Of_Order = item.Value.shipmentPlans.Count(); data.Total_Order_Qty = item.Value.TotalQty; data.clients = item.Value.Client; for (int i = 0; i < item.Value._bom.HEN.Count(); i++) { data.HENN += item.Value._bom.HEN[i] + Environment.NewLine; data.HENNStock += item.Value._bom.HENStock[i].ToString("N0") + Environment.NewLine; } data.QtyInBox = item.Value._bom.QtyUnit; data.ToolPcs = item.Value._bom.ToolQty; data.StockWH = item.Value.wip.Warehouse; data.WIPQty = item.Value.wip.TotalInWip; data.MQCStock = item.Value.wip.MQCQty; data.PQCStock = item.Value.wip.PQCQty; data.IntoWH = item.Value.wip.StockInWHQTy; data.SemiStock = item.Value.wip.SemiFinished; data.ShiftA = item.Value.production.targetShiftA; data.ShiftB = item.Value.production.targetShiftB; data.productivity = item.Value.production.QtyOld; data.WorkerQty = item.Value.production.PeopleQty; data.WorkerTarget = item.Value.production.targetPeople; data.ManufactureQty = item.Value.production.ProductionQty; data.ShortageStock = data.Total_Order_Qty - data.StockWH - data.WIPQty; dataHeaders.Add(data); double ShipmentQtySum = 0; foreach (var shipment in item.Value.shipmentPlans) { dataContent = new dataContent(); dataContent.ClientOrderDate = shipment.ClientRequestDate; dataContent.OrderQty = shipment.DeliveryPlanQty; ShipmentQtySum += dataContent.OrderQty; dataContent.ShortageQty = ShipmentQtySum - data.StockWH - data.WIPQty; dataContent.RemainDay = shipment.RemainDay; if (dataContent.RemainDay == 0) { dataContent.TargetQtyDay = (dataContent.ShortageQty < 0) ? 0 : (dataContent.ShortageQty); } else { dataContent.TargetQtyDay = (dataContent.ShortageQty < 0) ? 0 : (dataContent.ShortageQty / dataContent.RemainDay); } dataContent.OrderCode = shipment.OrderCode; dataContent.ClientOrder = shipment.ClientCode; datacontents.Add(dataContent); } listplanShipmentPage2.Add(data.products, datacontents); } dtgv_HeaderPage2.DataSource = dataHeaders; SettingHeaderDataGridViewHeader(dtgv_HeaderPage2); } catch (Exception ex) { SystemLog.Output(SystemLog.MSG_TYPE.Err, "LoadDataPlanningFFToShow(DateTime from, DateTime to)", ex.Message); } }