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