private void Txt_Search2_Click(object sender, EventArgs e)
{
settingManufactures = new List <SettingManufacture>();
loadData = new LoadDataPlanning();
settingManufactures = loadData.LoadingSettingManufactureFilter(txt_productFilter2.Text.Trim());
dtgv_manufacture.DataSource = settingManufactures;
}
private void Btn_Search_Click(object sender, EventArgs e)
{
settingBOMs = new List <SettingBOM>();
loadData = new LoadDataPlanning();
settingBOMs = loadData.LoadingSettingBOMsFilter(txt_productFilter.Text.Trim());
dtgv_SettingBom.DataSource = settingBOMs;
}
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 LoadingSettingBOM()
{
settingBOMs = new List <SettingBOM>();
loadData = new LoadDataPlanning();
settingBOMs = loadData.LoadingSettingBOMs();
dtgv_SettingBom.DataSource = settingBOMs;
}
private void IntilizialBOMSetting()
{
settingBOMs = new List <SettingBOM>();
loadData = new LoadDataPlanning();
settingBOMs = loadData.GetSettingBOMs();
loadData.InsertToManufactureSettingTableIntilizer(settingBOMs);
}
private void LoadingSettingManufacture()
{
settingManufactures = new List <SettingManufacture>();
loadData = new LoadDataPlanning();
settingManufactures = loadData.LoadingSettingManufacture();
dtgv_manufacture.DataSource = settingManufactures;
}
private void PlanningConfigure_Load(object sender, EventArgs e)
{
LoadDataPlanning loadData = new LoadDataPlanning();
orderVariables = loadData.LoadOrderInformationbyDate(from, to, "");
Dictionary <string, PlanningItem> keyValuePairs = loadData.GetPlanningReport(orderVariables);
dt_main.DataSource = orderVariables;
}
private void LoadingSettingBOM()
{
settingBOMs = new List <SettingBOM>();
loadData = new LoadDataPlanning();
settingBOMs = loadData.LoadingSettingBOMs();
dtgv_SettingBom.DataSource = settingBOMs;
SettingHeaderDataGridViewBom();
SettingDatagridview(ref dtgv_SettingBom);
}
private void LoadingSettingManufacture()
{
settingManufactures = new List <SettingManufacture>();
loadData = new LoadDataPlanning();
settingManufactures = loadData.LoadingSettingManufacture();
dtgv_manufacture.DataSource = settingManufactures;
SettingHeaderDataGridViewManufacture();
SettingDatagridview(ref dtgv_manufacture);
}
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);
}
}
