private DataGridViewRow GetRow(Shedule shed)
{
var row = new DataGridViewRow();
row.Cells.Add(new DataGridViewTextBoxCell {
Value = shed.date.ToString("dd.MM.yy")
});
string strTO3 = "", strTR1 = "";
foreach (MVPS mvps in shed.MVPS_Maintenance)
{
strTO3 += mvps.GetSeries() + ",";
}
foreach (MVPS mvps in shed.MVPS_Repair)
{
strTR1 += mvps.GetSeries() + ",";
}
strTO3 = strTO3.TrimEnd(',');
strTR1 = strTR1.TrimEnd(',');
row.Cells.Add(new DataGridViewTextBoxCell {
Value = strTO3
});
row.Cells.Add(new DataGridViewTextBoxCell {
Value = strTR1
});
return(row);
}
private void RemoveFromShed(int v)
{
using (kipEntities context = new kipEntities())
{
var shedule = context.SheduleSet.Where(b => b.date == dateTimePicker1.Value.Date).SingleOrDefault();
if (shedule == null)
{
shedule = new Shedule()
{
date = dateTimePicker1.Value.Date,
};
context.SheduleSet.Add(shedule);
}
var strings = DayMVPSList.Items[v].ToString().Split(' ');
var repairOrMaintenance = strings[0];
var type = strings[1];
var series = strings[2];
var mvps = context.MVPSSet.Where(b => b.series == series && b.MVPSType.name == type).First();
if (repairOrMaintenance == "ТО3")
{
shedule.MVPS_Maintenance.Remove(mvps);
}
else if (repairOrMaintenance == "ТР1")
{
shedule.MVPS_Repair.Remove(mvps);
}
context.SaveChanges();
FillTable();
}
}
private void AddToShed(bool isRepair)
{
CheckFields();
{
using (kipEntities context = new kipEntities())
{
var shedule = context.SheduleSet.Where(b => b.date == dateTimePicker1.Value.Date).SingleOrDefault();
if (shedule == null)
{
shedule = new Shedule()
{
date = dateTimePicker1.Value.Date,
};
context.SheduleSet.Add(shedule);
}
var strings = MVPSSeriesBox.SelectedItem.ToString().Split(' ');
var type = strings[0];
var series = strings[1];
var mvps = context.MVPSSet.Where(b => b.series == series && b.MVPSType.name == type).First();
if (isRepair)
{
shedule.MVPS_Repair.Add(mvps);
}
else
{
shedule.MVPS_Maintenance.Add(mvps);
}
context.SaveChanges();
FillTable();
FillList();
}
}
}
public static void FillGrid(ListBox list, DataGridView view)
{
var str = "";
if (list.SelectedItem != null)
{
str = list.SelectedItem.ToString();
}
gridView = view;
listBox = list;
switch (str)
{
case "Оборудование":
Equipment.FillGrid(view);
break;
case "Типы оборудования":
EquipmentType.FillGrid(view);
break;
case "Производители":
Manufacturer.FillGrid(view);
break;
case "Типы систем":
SystemType.FillGrid(view);
break;
case "Роли МВПС":
MVPSRole.FillGrid(view);
break;
case "Типы МВПС":
MVPSType.FillGrid(view);
break;
case "МВПС":
MVPS.FillGrid(view);
break;
case "Правила компелктования":
EquipmentRule.FillGrid(view);
break;
case "Замены оборудования":
ReplacingLog.FillGrid(view);
break;
case "Работники":
Worker.FillGrid(view);
break;
case "Должности":
Position.FillGrid(view);
break;
case "График ТО и ТР":
Shedule.FillGrid(view);
break;
case "Журнал проверки/ремонта":
ServiceLog.FillGrid(view);
break;
default:
break;
}
}
