private void updateCom() { load = false; string[] otdelar = null; string[] postavar = null; string[] vzrivar = null; string[] klimatar = null; string[] ipar = null; FunctionUse.ChangeComboInBase(SveraB.DataBaseList, FilterTipPostav, FilterTipOborud, FilterEdIzm, FilterPostav, FilterVzriv, FilterKlimat, FilterOtdel, FilterIp, ref otdelar, ref postavar, ref vzrivar, ref klimatar, ref ipar); for (int i = 0; i <= SveraB.RowNamesShort.Count - 1; i++) { if (sverPDataGrid.Rows[i].Tag.ToString() == SveraParam.RowsDatagridNames.otdel || sverPDataGrid.Rows[i].Tag.ToString() == SveraParam.RowsDatagridNames.klimat || sverPDataGrid.Rows[i].Tag.ToString() == SveraParam.RowsDatagridNames.vzriv || sverPDataGrid.Rows[i].Tag.ToString() == SveraParam.RowsDatagridNames.postav) { DataGridViewComboBoxCell cc = new DataGridViewComboBoxCell(); cc.FlatStyle = FlatStyle.Flat; if (SveraB.RowNamesShort[i].nameRow == SveraParam.RowsDatagridNames.otdel && otdelar != null) { cc.Items.AddRange(otdelar); } else if (SveraB.RowNamesShort[i].nameRow == SveraParam.RowsDatagridNames.postav && postavar != null) { cc.Items.AddRange(postavar); } else if (SveraB.RowNamesShort[i].nameRow == SveraParam.RowsDatagridNames.klimat && klimatar != null) { cc.Items.AddRange(klimatar); } else if (SveraB.RowNamesShort[i].nameRow == SveraParam.RowsDatagridNames.vzriv && vzrivar != null) { cc.Items.AddRange(vzrivar); } cc.Value = sverPDataGrid.Rows[i].Cells[sverPDataGrid.Columns[SveraParam.ColDatagridNames.Value].Index].Value; sverPDataGrid.Rows[i].Cells[sverPDataGrid.Columns[SveraParam.ColDatagridNames.Value].Index] = cc; } } load = true; }
public BaseChoose(SveraParam SveraP) { InitializeComponent(); try { // SetDoubleBuffered(CableData, True); this.SveraP = SveraP; if (Svera.Properties.Settings.Default.BaseSize != new Size(0, 0)) { this.Size = Svera.Properties.Settings.Default.BaseSize; } if (Svera.Properties.Settings.Default.BaseLocation != new Point(0, 0)) { this.Location = Svera.Properties.Settings.Default.BaseLocation; } dataBaseList = FunctionUse.LoadFromDataBase(); // if (dataBaseList.Count > 0) // { // string[] BaseArray = dataBaseList.ConvertAll<string>(x => x.ToString()).ToArray(); // ComboDate.Items.(BaseArray); //ComboDate.DataSource = dataBaseList; //ComboDate.SelectedIndex = 0; // } if (SveraP.ColList.Count > 0) { DataGridViewColumn[] dataGridColSver = new DataGridViewColumn[SveraP.ColList.Count - 1]; ColumnNames colName; for (int i = 0; i <= SveraP.ColList.Count - 1; i++) { colName = SveraP.ColList[i]; if (colName.nameColumn != SveraParam.ColDatagridNames.Redact) { dataGridColSver[i] = new DataGridViewTextBoxColumn(); dataGridColSver[i].Name = colName.nameColumn; dataGridColSver[i].HeaderText = colName.textColumn; dataGridColSver[i].SortMode = DataGridViewColumnSortMode.NotSortable; if (i == 0) { dataGridColSver[i].ReadOnly = true; } } } sverPDataGrid.Columns.AddRange(dataGridColSver); sverPDataGrid.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; sverPDataGrid.Columns[SveraParam.ColDatagridNames.Value].DefaultCellStyle.WrapMode = DataGridViewTriState.True; } if (SveraP.RowList.Count > 0) { DataGridViewRow[] dataGridRowSver = new DataGridViewRow[SveraP.RowNamesShort.Count]; RowsNames rowName; for (int i = 0; i <= SveraP.RowNamesShort.Count - 1; i++) { rowName = SveraP.RowNamesShort[i]; if (rowName.extended == false) { dataGridRowSver[i] = new DataGridViewRow(); dataGridRowSver[i].CreateCells(sverPDataGrid); //if (SveraP.RowList[i].dataCellType == typeof(DataGridViewComboBoxCell)) //{ // DataGridViewComboBoxCell cc = new DataGridViewComboBoxCell(); // cc.FlatStyle = FlatStyle.Flat; // cc.Items.AddRange(SveraP.RowList[i].ArrayValue); // dataGridRowSver[i].Cells[sverPDataGrid.Columns[SveraParam.ColDatagridNames.Value].Index] = cc; //} dataGridRowSver[i].Cells[sverPDataGrid.Columns[SveraParam.ColDatagridNames.Parametr].Index].Value = SveraP.RowNamesShort[i].textRow; // dataGridRowSver[i].Cells[sverPDataGrid.Columns[SveraParam.ColDatagridNames.Value].Index].Value = SveraP.RowList[i].NullValue; dataGridRowSver[i].Tag = SveraP.RowNamesShort[i].nameRow; if (i == 0) { dataGridRowSver[i].ReadOnly = true; } } } string[] mas = null; FunctionUse.ChangeComboInBase(dataBaseList, FilterTipPostav, FilterTipOborud, FilterEdIzm, FilterPostav, FilterVzriv, FilterKlimat, FilterOtdel, FilterIp, ref mas, ref mas, ref mas, ref mas, ref mas); sverPDataGrid.Rows.AddRange(dataGridRowSver); } ChangeFilter(); if (SveraP.FromDataBaseWideForSvera.IdBase != 0) { int ind = dataBaseList.FindIndex(d => (d.IdBase == SveraP.FromDataBaseWideForSvera.IdBase)); if (ind > -1) { ComboDate.SelectedIndex = ind; } } ChangeSpec(); SizeChange(); load = true; } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); if (ex.InnerException != null) { MessageBox.Show(ex.InnerException.ToString()); } } }
public BaseChange() { InitializeComponent(); try { // SetDoubleBuffered(CableData, True); SveraB = new SveraBaseChange(); if (Svera.Properties.Settings.Default.BaseChangeSize != new Size(0, 0)) { this.Size = Svera.Properties.Settings.Default.BaseChangeSize; } if (Svera.Properties.Settings.Default.BaseChangeLocation != new Point(0, 0)) { this.Location = Svera.Properties.Settings.Default.BaseChangeLocation; } if (SveraB.DataBaseList.Count > 0) { ComboDate.DataSource = SveraB.DataBaseList; ComboDate.SelectedIndex = 0; } if (SveraB.ColList.Count > 0) { DataGridViewColumn[] dataGridColSver = new DataGridViewColumn[SveraB.ColList.Count]; ColumnNames colName; for (int i = 0; i <= SveraB.ColList.Count - 1; i++) { colName = SveraB.ColList[i]; // if (colName.nameColumn != SveraParam.ColDatagridNames.Redact) // { dataGridColSver[i] = new DataGridViewTextBoxColumn(); dataGridColSver[i].Name = colName.nameColumn; dataGridColSver[i].HeaderText = colName.textColumn; dataGridColSver[i].SortMode = DataGridViewColumnSortMode.NotSortable; dataGridColSver[i].ReadOnly = colName.readOnly; if (i == 0) { dataGridColSver[i].ReadOnly = true; } //} } sverPDataGrid.Columns.AddRange(dataGridColSver); sverPDataGrid.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; sverPDataGrid.Columns[SveraParam.ColDatagridNames.Value].DefaultCellStyle.WrapMode = DataGridViewTriState.True; } if (SveraB.RowNamesShort.Count > 0) { DataGridViewRow[] dataGridRowSver = new DataGridViewRow[SveraB.RowNamesShort.Count]; RowsNames rowName; string[] otdelar = null; string[] postavar = null; string[] vzrivar = null; string[] klimatar = null; string[] ipar = null; FunctionUse.ChangeComboInBase(SveraB.DataBaseList, FilterTipPostav, FilterTipOborud, FilterEdIzm, FilterPostav, FilterVzriv, FilterKlimat, FilterOtdel, FilterIp, ref otdelar, ref postavar, ref vzrivar, ref klimatar, ref ipar); for (int i = 0; i <= SveraB.RowNamesShort.Count - 1; i++) { rowName = SveraB.RowNamesShort[i]; if (rowName.extended == false) { //dataGridRowSver[i] = new DataGridViewRow(); //dataGridRowSver[i].CreateCells(sverPDataGrid); //if (SveraB.RowNamesShort[i].dataCellType == typeof(DataGridViewComboBoxCell) || // SveraB.RowNamesShort[i].nameRow == SveraParam.RowsDatagridNames.otdel || // SveraB.RowNamesShort[i].nameRow == SveraParam.RowsDatagridNames.klimat || // SveraB.RowNamesShort[i].nameRow == SveraParam.RowsDatagridNames.vzriv || // SveraB.RowNamesShort[i].nameRow == SveraParam.RowsDatagridNames.postav) //{ // DataGridViewComboBoxCell cc = new DataGridViewComboBoxCell(); // cc.FlatStyle = FlatStyle.Flat; // if (SveraB.RowNamesShort[i].ArrayValue != null) // { // cc.Items.AddRange(SveraB.RowNamesShort[i].ArrayValue); // } // else // { // if (SveraB.RowNamesShort[i].nameRow == SveraParam.RowsDatagridNames.otdel && otdelar != null) // { // cc.Items.AddRange(otdelar); // } // else if (SveraB.RowNamesShort[i].nameRow == SveraParam.RowsDatagridNames.postav && postavar != null) // { // cc.Items.AddRange(postavar); // } // else if (SveraB.RowNamesShort[i].nameRow == SveraParam.RowsDatagridNames.klimat && klimatar != null) // { // cc.Items.AddRange(klimatar); // } // else if (SveraB.RowNamesShort[i].nameRow == SveraParam.RowsDatagridNames.vzriv && vzrivar != null) // { // cc.Items.AddRange(vzrivar); // } // } // dataGridRowSver[i].Cells[sverPDataGrid.Columns[SveraParam.ColDatagridNames.Value].Index] = cc; //} //dataGridRowSver[i].Cells[sverPDataGrid.Columns[SveraParam.ColDatagridNames.Parametr].Index].Value = SveraB.RowNamesShort[i].textRow; //dataGridRowSver[i].Cells[sverPDataGrid.Columns[SveraParam.ColDatagridNames.Value].Index].Value = SveraB.RowNamesShort[i].NullValue; //dataGridRowSver[i].Tag = SveraB.RowNamesShort[i].nameRow; //if (SveraB.RowNamesShort[i].readonlyT == true) //{ // dataGridRowSver[i].ReadOnly = true; //} //if (SveraB.RowNamesShort[i].redact == true) //{ // DataGridViewButtonCell bb = new DataGridViewButtonCell(); // bb.FlatStyle = FlatStyle.Flat; // bb.Value = "Ред."; // bb.Style.BackColor = Color.LightGray; // dataGridRowSver[i].Cells[sverPDataGrid.Columns[SveraParam.ColDatagridNames.Redact].Index] = bb; //} rowName = SveraB.RowNamesShort[i]; dataGridRowSver[i] = new DataGridViewRow(); dataGridRowSver[i].CreateCells(sverPDataGrid); if (SveraB.RowNamesShort[i].dataCellType == typeof(DataGridViewComboBoxCell)) { DataGridViewComboBoxCell cc = new DataGridViewComboBoxCell(); cc.FlatStyle = FlatStyle.Flat; if (SveraB.RowNamesShort[i].ArrayValue != null) { cc.Items.AddRange(SveraB.RowNamesShort[i].ArrayValue); } dataGridRowSver[i].Cells[sverPDataGrid.Columns[SveraParam.ColDatagridNames.Value].Index] = cc; } dataGridRowSver[i].Cells[sverPDataGrid.Columns[SveraParam.ColDatagridNames.Parametr].Index].Value = SveraB.RowNamesShort[i].textRow; dataGridRowSver[i].Tag = SveraB.RowNamesShort[i].nameRow; if (SveraB.RowNamesShort[i].readonlyT == true) { dataGridRowSver[i].ReadOnly = true; } if (SveraB.RowNamesShort[i].redact == true) { DataGridViewButtonCell bb = new DataGridViewButtonCell(); bb.FlatStyle = FlatStyle.Flat; bb.Value = "Ред."; bb.Style.BackColor = Color.LightGray; dataGridRowSver[i].Cells[sverPDataGrid.Columns[SveraParam.ColDatagridNames.Redact].Index] = bb; } } } sverPDataGrid.Rows.AddRange(dataGridRowSver); } ChangeSpec(); SizeChange(); load = true; } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); if (ex.InnerException != null) { MessageBox.Show(ex.InnerException.ToString()); } } }