public void Refresh_Click(object sender, EventArgs e) { TsEntity db = new TsEntity(); string whereCondition = ""; if (Text == "Администратор отдела МТО") { whereCondition = "Склад МТО"; } else { whereCondition = "Склад тестировщиков"; } var devices = db.devices.Where(it => it.placement.Equals(whereCondition)).ToList(); var accessories = db.device_accessories.Where(it => it.placement.Equals(whereCondition)).ToList(); devicesDGV.DataSource = devices; devicesDGV.Columns["device_accessories"].Visible = false; if (Text == "Администратор отдела МТО") { devicesDGV.Columns["ip"].Visible = false; devicesDGV.Columns["networkName"].Visible = false; devicesDGV.Columns["subnetMask"].Visible = false; } accessoriesDGV.DataSource = accessories; accessoriesDGV.Columns["devices"].Visible = false; collectionDGV.DataSource = db.supportCollection().Where(it => it.placement.Equals(whereCondition)).ToList(); placementComboBox.Items.Clear(); typeComboBox.Items.Clear(); FillTypeAndPlaces(devices, this); }
private void supButton_Click(object sender, EventArgs e) { var form = new UserForm(); //this.supButton.Enabled = false; //this.testButton.Enabled = false; form.ipTextBox.Visible = false; form.subnetMaskTextBox.Visible = false; form.networkNameTextBox.Visible = false; form.label5.Visible = false; form.label6.Visible = false; form.label7.Visible = false; TsEntity db = new TsEntity(); form.Text = "Администратор отдела МТО"; var devices = db.devices.Where(it => it.placement.Equals("Склад МТО")).ToList(); var accessories = db.device_accessories.Where(it => it.placement.Equals("Склад МТО")).ToList(); form.devicesDGV.DataSource = devices; form.devicesDGV.Columns["id"].Visible = false; form.devicesDGV.Columns["device_accessories"].Visible = false; form.devicesDGV.Columns["ip"].Visible = false; form.devicesDGV.Columns["networkName"].Visible = false; form.devicesDGV.Columns["subnetMask"].Visible = false; form.devicesDGV.Columns["deviceName"].HeaderText = "Наименование"; form.devicesDGV.Columns["serialNumber"].HeaderText = "Серийный номер"; form.devicesDGV.Columns["guaranteeEnd"].HeaderText = "Гарантия до"; form.devicesDGV.Columns["seller"].HeaderText = "Продавец"; form.devicesDGV.Columns["type"].HeaderText = "Тип"; form.devicesDGV.Columns["entryDate"].HeaderText = "Дата поступления"; form.devicesDGV.Columns["price"].HeaderText = "Цена"; form.devicesDGV.Columns["placement"].HeaderText = "Размещение"; form.devicesDGV.Columns["responsible"].HeaderText = "Ответственный"; form.accessoriesDGV.DataSource = accessories; form.accessoriesDGV.Columns["devices"].Visible = false; form.accessoriesDGV.Columns["id"].Visible = false; form.accessoriesDGV.Columns["deviceId"].Visible = false; form.accessoriesDGV.Columns["accessoryName"].HeaderText = "Наименование"; form.accessoriesDGV.Columns["serialNumber"].HeaderText = "Серийный номер"; form.accessoriesDGV.Columns["guaranteeEnd"].HeaderText = "Гарантия до"; form.accessoriesDGV.Columns["seller"].HeaderText = "Продавец"; form.accessoriesDGV.Columns["type"].HeaderText = "Тип"; form.accessoriesDGV.Columns["entryDate"].HeaderText = "Дата поступления"; form.accessoriesDGV.Columns["price"].HeaderText = "Цена"; form.accessoriesDGV.Columns["placement"].HeaderText = "Размещение"; form.accessoriesDGV.Columns["responsible"].HeaderText = "Ответственный"; form.collectionDGV.DataSource = db.supportCollection().Where(it => it.placement.Equals("Склад МТО")).ToList(); form.collectionDGV.Columns["deviceName"].HeaderText = "Наименование устройства"; form.collectionDGV.Columns["seller"].HeaderText = "Продавец"; form.collectionDGV.Columns["type"].HeaderText = "Тип"; form.collectionDGV.Columns["price"].HeaderText = "Цена"; form.collectionDGV.Columns["placement"].HeaderText = "Размещение"; form.collectionDGV.Columns["responsible"].HeaderText = "Ответственный"; form.collectionDGV.Columns["accessoryName"].HeaderText = "Наименование аксессуара"; form.collectionDGV.Columns["seller1"].HeaderText = "Продавец"; form.collectionDGV.Columns["type1"].HeaderText = "Тип"; form.collectionDGV.Columns["price1"].HeaderText = "Цена"; form.collectionDGV.Columns["placement1"].HeaderText = "Размещение"; form.collectionDGV.Columns["responsible1"].HeaderText = "Ответственный"; form.FillTypeAndPlaces(devices, form); form.Show(); }