private static void olv_CellToolTipShowing(object sender, ToolTipShowingEventArgs e)
{
ObjectListView l = (ObjectListView)sender;
LastNgViewColumns s = (LastNgViewColumns)e.Model;
e.Text = s.ModelName;
}
public static List <LastNgViewColumns> LastNgSource()
{
List <LastNgViewColumns> result = new List <LastNgViewColumns>();
var lastNgListOfOrders = DataContainer.sqlDataByOrder.SelectMany(o => o.Value.visualInspection.ngScrapList).OrderByDescending(ng => ng.ngRegistrationDate).Select(o => o.orderNo).Distinct().ToList(); //SqlDataByProcess.VisualInspection.SelectMany(o => o.Value.ngScrapList).OrderByDescending(d => d.ngRegistrationDate).Select(o=>o.orderNo).Distinct().Take(500).ToList();
foreach (var order in lastNgListOfOrders)
{
var viOrder = DataContainer.sqlDataByOrder[order].visualInspection;
LastNgViewColumns newItem = new LastNgViewColumns();
newItem.Date = viOrder.ngScrapList.OrderByDescending(d => d.ngRegistrationDate).Select(d => d.ngRegistrationDate).First();
newItem.NgCount = viOrder.ngCount.ToString();
newItem.OrderNo = viOrder.orderNo;
newItem.ScrapCount = viOrder.scrapCount.ToString();
newItem.ModelId = DataContainer.sqlDataByOrder[order].kitting.modelId;
string modelName = "";
if (DataContainer.nc12ToName.ContainsKey(newItem.ModelId + "00"))
{
modelName = DataContainer.nc12ToName[newItem.ModelId + "00"];;
}
else
{
modelName = newItem.ModelId;
}
newItem.ModelName = modelName;
result.Add(newItem);
}
return(result);
}
public static void Configurate(ref ObjectListView olv)
{
olv.ShowGroups = true;
olv.UseAlternatingBackColors = true;
olv.CellToolTipShowing += new EventHandler<ToolTipShowingEventArgs>(olv_CellToolTipShowing);
olv.CellToolTip.Font = new Font("Tahoma", 14);
OLVColumn dateCol = new OLVColumn();
dateCol.Text = "Data";
dateCol.AspectName = "Date";
//dateCol.AspectToStringFormat ="ToString(HH:mm dd-MM)";
dateCol.GroupKeyGetter = delegate (object rowObject) {
LastNgViewColumns col = (LastNgViewColumns)rowObject;
return new DateTime(col.Date.Year, col.Date.Month, col.Date.Day);
};
dateCol.GroupKeyToTitleConverter = delegate (object groupKey) {
return ((DateTime)groupKey).ToString("dd-MMM-yyyy");
};
olv.Columns.Add(dateCol);
OLVColumn orderCol = new OLVColumn();
orderCol.Text = "Zlecenie";
orderCol.AspectName = "OrderNo";
olv.Columns.Add(orderCol);
OLVColumn modelIdCol = new OLVColumn();
modelIdCol.Text = "ID";
modelIdCol.AspectName = "ModelId";
olv.Columns.Add(modelIdCol);
OLVColumn ngCountCol = new OLVColumn();
ngCountCol.Text = "NG";
ngCountCol.AspectName = "NgCount";
olv.Columns.Add(ngCountCol);
OLVColumn scrapCountCol = new OLVColumn();
scrapCountCol.Text = "SCRAP";
scrapCountCol.AspectName = "ScrapCount";
olv.Columns.Add(scrapCountCol);
}