private void PrepareComboBoxDataSources()
{
var tablep = new AutoparkDBTableAdapters.PodvijnoiTableAdapter();
_bindingAuto.DataSource = tablep.GetDataByType("Л");
if (_bindingAuto.Count == 0)
{
throw new Exception("Пожалуйста, заполните справочник \"Подвижной состав\"");
}
cbNomerAuto.DataSource = _bindingAuto;
cbNomerAuto.DisplayMember = "Гос_номер";
cbNomerAuto.ValueMember = "ID";
var tablel = new AutoparkDBTableAdapters.LichniiTableAdapter();
_bindingVoditel.DataSource = tablel.GetDataSpisokVoditeli();
if (_bindingVoditel.Count == 0)
{
throw new Exception("Пожалуйста, заполните справочник \"Личный состав\"");
}
cbVodUdostoverenie.DataSource = _bindingVoditel;
cbVodUdostoverenie.DisplayMember = "ФИО";
cbVodUdostoverenie.ValueMember = "табельный_номер";
var tableOtdeli = new AutoparkDBTableAdapters.OtdelTableAdapter();
_bindingOtdel.DataSource = tableOtdeli.GetData();
cbOtdel.DataSource = _bindingOtdel;
cbOtdel.DisplayMember = "Подразделение";
cbOtdel.ValueMember = "Код";
}
public OtchetGruzavogo(int id)
{
InitializeComponent();
PutevoiId = id;
var tablePutevoi = new AutoparkDBTableAdapters.TablePutevieGruzovieTableAdapter();
_bindingHead.DataSource = tablePutevoi.GetDataByID(PutevoiId);
var res = tablePutevoi.GetDataByID(id).ToList();
var idauto = res[0].ID_Автомобиля;
var idvod = res[0].ID_Водителя;
var tablep = new AutoparkDBTableAdapters.PodvijnoiTableAdapter();
_bindingAuto.DataSource = tablep.GetDataByID(idauto);
var tablel = new AutoparkDBTableAdapters.LichniiTableAdapter();
_bindingVoditel.DataSource = tablel.GetDataByID(idvod);
var tableDannie = new AutoparkDBTableAdapters.PutevieGruzovieTableAdapter();
_bindingDannie.DataSource = tableDannie.GetData();
_bindingDannie.Filter = "[ID_Путевого листа] = " + PutevoiId;
var tableZadanie = new AutoparkDBTableAdapters.ZadanieVoditelTableAdapter();
_bindingZadanie.DataSource = tableZadanie.GetDataByPutevoiId(PutevoiId);
var tableZapr = new AutoparkDBTableAdapters.ZapravkaTCMTableAdapter();
_bindingDannieZapr.DataSource = tableZapr.GetDataByPutevoiID(PutevoiId);
}
