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); }