private void LoadMstOrdersFromDb(int recordsQuantity)
{
var nc = MST.MES.SqlOperations.ConnectDB.Nc12ToModelFullDict();
DataTable sqlTable = SqlOperations.GetMstSmtRecordsFromDb(recordsQuantity, smtLine);
var smto = MST.MES.SqlDataReaderMethods.SMT.GetOneOrder("");
dataGridViewMstOrders.Columns["MstOrdersStart"].DefaultCellStyle.Format = "HH:mm dd-MMM";
dataGridViewMstOrders.Columns["MstOrdersEnd"].DefaultCellStyle.Format = "HH:mm dd-MMM";
List <EfficiencyCalculation.OrderDataForEfficiencyStructure> ordersEff = new List <EfficiencyCalculation.OrderDataForEfficiencyStructure>();
if (sqlTable.Rows.Count > 0)
{
HashSet <string> nc12ToModelList = new HashSet <string>();
foreach (DataRow row in sqlTable.Rows)
{
DateTime startDate = DateTime.Parse(row["DataCzasStart"].ToString().Trim());
DateTime endDate = DateTime.Parse(row["DataCzasKoniec"].ToString().Trim());
string nc10 = row["Model"].ToString();
double qty = 0;
string orderNo = row["NrZlecenia"].ToString();
double efficiency = 0;
if (double.TryParse(row["IloscWykonana"].ToString(), out qty))
{
efficiency = Math.Round(EfficiencyCalculation.CalculateEfficiency(startDate, endDate, nc10, qty, true) * 100, 0);
}
string name = nc.ContainsKey(nc10 + "00") ? nc[nc10 + "00"] : nc10;
dataGridViewMstOrders.Rows.Insert(0, startDate, endDate, orderNo, nc10.Insert(4, " ").Insert(8, " "), qty, efficiency + "%", name);
nc12ToModelList.Add(nc10 + "00");
ordersEff.Add(new EfficiencyCalculation.OrderDataForEfficiencyStructure()
{
start = startDate, end = endDate, qty = qty, modelId = nc10
});
var owningShift = DateTools.GetOrderOwningShift(startDate, endDate);
var currentShift = DateTools.whatDayShiftIsit(DateTime.Now);
//1878856
if (orderNo == "1878856")
{
;
}
if (owningShift.fixedDate != currentShift.fixedDate)
{
if (owningShift.fixedDate.Date == currentShift.fixedDate.Date)
{
DgvTools.ColorDgvRow(dataGridViewMstOrders.Rows[0], Color.LightGray);
}
else
{
DgvTools.ColorDgvRow(dataGridViewMstOrders.Rows[0], Color.Silver);
}
}
}
//Dictionary<string, string> nc12toName = SqlOperations.nc12ToModelDict(nc12ToModelList.ToArray());
//foreach (DataGridViewRow row in dataGridViewMstOrders.Rows)
//{
// string nc12 = row.Cells["Column12NC"].Value.ToString().Replace(" ","") + "00";
// row.Cells["ColumnName"].Value = nc12toName[nc12];
//}
DgvTools.AutoSizeColumns(dataGridViewMstOrders, DataGridViewAutoSizeColumnMode.AllCells);
EfficiencyRecordsForOrdersHistory.FillOutListView(lVMstEfficiencyRecord, ordersEff);
}
var eff = Math.Round(MstCurrentShiftEfficiency.CalculateCurrentShiftEff(currentMstOrder, dataGridViewMstOrders), 0);
angularGauge1.Value = Math.Min(100, eff);
labelCurrentShiftEfficiency.Text = $"Wydajność aktualnej zmiany: {eff}%";
}
