Example #1
0
 private void sverPDataGrid_CellClick(object sender, DataGridViewCellEventArgs e)
 {
     if (e.ColumnIndex == sverPDataGrid.Columns[SveraParam.ColDatagridNames.Redact].Index)
     {
         if (SveraB.RowNamesShort[e.RowIndex].redact == true)
         {
             if (sverPDataGrid.Rows[e.RowIndex].Tag.ToString() == SveraParam.RowsDatagridNames.vedRabotTable)
             {
                 VedTableForm ved = new VedTableForm(SveraB.FromDataBaseWideForSvera.VedRabotTable);
                 if (ved.ShowDialog(this) == DialogResult.OK)
                 {
                     SveraB.FromDataBaseWideForSvera.VedRabotTable = ved.VedTableP;
                 }
             }
             else
             {
                 RedactText red = new RedactText(sverPDataGrid.Rows[e.RowIndex].Cells[SveraParam.ColDatagridNames.Value].Value.ToString());
                 if (red.ShowDialog(this) == DialogResult.OK)
                 {
                     sverPDataGrid.Rows[e.RowIndex].Cells[SveraParam.ColDatagridNames.Value].Value = red.RedactRichBox.Text;
                     SveraParam.ChangeData(sverPDataGrid, SveraB.FromDataBaseWideForSvera, objectEditDataGrid, load, e.RowIndex, sverPDataGrid.Columns[SveraParam.ColDatagridNames.Value].Index);
                 }
             }
         }
     }
 }
Example #2
0
 private void ChangeSpec()
 {
     if (sverPDataGrid.Rows.Count > 0)
     {
         SveraParam.ChangeSpec(sverPDataGrid, SveraP.FromDataBaseWideForSvera);
     }
 }
Example #3
0
 private void sverPDataGrid_CellEndEdit(object sender, DataGridViewCellEventArgs e)
 {
     SveraParam.ChangeData(sverPDataGrid, SveraP.FromDataBaseWideForSvera, objectEditDataGrid, load, e.RowIndex, e.ColumnIndex);
     if (load == true)
     {
         if (sverPDataGrid.Rows[e.RowIndex].Tag.ToString() == SveraParam.RowsDatagridNames.Podklass)
         {
             ChangeSpec();
         }
     }
 }
Example #4
0
        private void sverPDataGrid_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            SveraParam.ChangeData(sverPDataGrid, SveraF.FromDataBaseWideForSvera, objectEditDataGrid, load, e.RowIndex, e.ColumnIndex);

            if (sverPDataGrid.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != null && sverPDataGrid.Rows[e.RowIndex].Cells[e.ColumnIndex].Value != objectEditDataGrid)
            {
                DataGridViewCheckBoxCell cellChek = sverPDataGrid.Rows[e.RowIndex].Cells[sverPDataGrid.Columns[FindAndChangeCl.ColDatagridNames.Check].Index] as DataGridViewCheckBoxCell;
                cellChek.Value = true;
                sverPDataGrid.RefreshEdit();
                sverPDataGrid.NotifyCurrentCellDirty(true);
            }
        }
Example #5
0
 public SveraBaseChange()
 {
     try
     {
         colList                  = SveraParam.GetColumns();
         rowNamesShort            = SveraParam.GetRows(true, false);
         fromDataBaseWideForSvera = new FromDataBaseWide();
         UpdateDatabase();
     }
     catch (Exception ex)
     {
         throw new Exception("SveraBaseChange", ex);
     }
 }
Example #6
0
 public FindAndChangeCl(List <FromDataBaseWide> fromDataBaseWideSveraCl, bool autocad)
 {
     try
     {
         this.fromDataBaseWideSveraCl = fromDataBaseWideSveraCl;
         colList = GetColumns();
         rowList = SveraParam.GetRows(false, autocad);
         fromDataBaseWideForSvera = new FromDataBaseWide();
     }
     catch (Exception ex)
     {
         throw new Exception("FindAndChangeCl", ex);
     }
 }
Example #7
0
 private void ChangeSpec()
 {
     if (ComboDate.Items.Count > 0 && ComboDate.DataSource != null)
     {
         FromDataBase newDataBase = ComboDate.SelectedItem as FromDataBase;
         SveraParam.ChangeSpec(sverPDataGrid, newDataBase);
     }
     else
     {
         for (int i = 0; i <= sverPDataGrid.Rows.Count - 1; i++)
         {
             sverPDataGrid.Rows[i].Cells[sverPDataGrid.Columns[SveraParam.ColDatagridNames.Value].Index].Value = "";
         }
     }
 }
Example #8
0
 private void toolStripButton1_Click(object sender, EventArgs e)
 {
     try
     {
         BaseChoose BaseC = new BaseChoose(SveraP);
         if (BaseC.ShowDialog(this) == DialogResult.OK)
         {
             SveraP.FromDataBaseWideForSvera.ChangeDataBaseWide(BaseC.ComboDate.SelectedItem as FromDataBase);
             SveraParam.detailCHangeFromGroup(sveraP.FromDataBaseWideForSvera, sverPDataGrid);
             ChangeSpec();
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
         MessageBox.Show(ex.StackTrace);
         if (ex.InnerException != null)
         {
             MessageBox.Show(ex.InnerException.ToString());
         }
     }
 }
Example #9
0
        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());
                }
            }
        }
Example #10
0
        public SverParamForm(List <FromDataBaseWide> fromDataBaseWide, Form Owner)
        {
            InitializeComponent();

            try
            {
                if (Svera.Properties.Settings.Default.SverParamSize != new Size(0, 0))
                {
                    this.Size = Svera.Properties.Settings.Default.SverParamSize;
                }
                //if (Svera.Properties.Settings.Default.SverParamLocation != new Point(0, 0))
                //{
                //    this.Location = Svera.Properties.Settings.Default.SverParamLocation;
                //}

                sveraP = new SveraParam(FromDataBaseWide.CompleteFromList(fromDataBaseWide), false);

                if (SveraP.ColList.Count > 0)
                {
                    DataGridViewColumn[] dataGridColSver = new DataGridViewColumn[SveraP.ColList.Count];
                    ColumnNames          colName;

                    for (int i = 0; i <= SveraP.ColList.Count - 1; i++)
                    {
                        colName                       = SveraP.ColList[i];
                        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 = colName.readOnly;
                        //}
                    }

                    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.RowList.Count];
                    RowsNames         rowName;

                    for (int i = 0; i <= SveraP.RowList.Count - 1; i++)
                    {
                        rowName            = SveraP.RowList[i];
                        dataGridRowSver[i] = new DataGridViewRow();
                        dataGridRowSver[i].CreateCells(sverPDataGrid);

                        if (SveraP.RowList[i].dataCellType == typeof(DataGridViewComboBoxCell))
                        {
                            DataGridViewComboBoxCell cc = new DataGridViewComboBoxCell();
                            cc.FlatStyle = FlatStyle.Flat;
                            if (SveraP.RowList[i].ArrayValue != null)
                            {
                                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.RowList[i].textRow;
                        dataGridRowSver[i].Tag = SveraP.RowList[i].nameRow;

                        if (SveraP.RowList[i].readonlyT == true)
                        {
                            dataGridRowSver[i].ReadOnly = true;
                        }

                        if (SveraP.RowList[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());
                }
            }
        }
Example #11
0
 private void sverPDataGrid_CellClick(object sender, DataGridViewCellEventArgs e)
 {
     if (e.ColumnIndex > -1 && e.RowIndex > -1)
     {
         if (e.ColumnIndex == sverPDataGrid.Columns[SveraParam.ColDatagridNames.Redact].Index)
         {
             if (sveraP.RowList[e.RowIndex].redact == true)
             {
                 if (sverPDataGrid.Rows[e.RowIndex].Tag.ToString() == SveraParam.RowsDatagridNames.vedRabotTable)
                 {
                     PodKlassFrom pod = sveraP.FromDataBaseWideForSvera.PodklassUseR;
                     if (sveraP.FromDataBaseWideForSvera.PodklassL.Count > 1 && pod.Equals(sveraP.FromDataBaseWideForSvera.PodklassL[0]))
                     {
                     }
                     else
                     {
                         VedTableRevisionForm ved = new VedTableRevisionForm(pod.VedTableRevision);
                         if (ved.ShowDialog(this) == DialogResult.OK)
                         {
                             pod.VedTableRevision = ved.VedTableExp;
                             sveraP.FromDataBaseWideForSvera.VedRabotDifferent = false;
                         }
                     }
                 }
                 else if (sverPDataGrid.Rows[e.RowIndex].Tag.ToString() == SveraParam.RowsDatagridNames.Revision || sverPDataGrid.Rows[e.RowIndex].Tag.ToString() == SveraParam.RowsDatagridNames.etap || sverPDataGrid.Rows[e.RowIndex].Tag.ToString() == SveraParam.RowsDatagridNames.kolic)
                 {
                     PodKlassFrom pod = sveraP.FromDataBaseWideForSvera.PodklassUseR;
                     if (sveraP.FromDataBaseWideForSvera.PodklassL.Count > 1 && pod.Equals(sveraP.FromDataBaseWideForSvera.PodklassL[0]))
                     {
                     }
                     else
                     {
                         RevisionForm rev = new RevisionForm(pod.Revision);
                         if (rev.ShowDialog(this) == DialogResult.OK)
                         {
                             pod.Revision = rev.RevisionExp.ToList();
                             sveraP.FromDataBaseWideForSvera.MakeVedTableCorrectToRevision();
                             sveraP.FromDataBaseWideForSvera.RevisionDifferent = false;
                             sverPDataGrid.Rows[sveraP.RowList.FirstOrDefault(r => r.nameRow == SveraParam.RowsDatagridNames.Revision).numberRow].Cells[SveraParam.ColDatagridNames.Value].Value = sveraP.FromDataBaseWideForSvera.RevisionTxt;
                             sverPDataGrid.Rows[sveraP.RowList.FirstOrDefault(r => r.nameRow == SveraParam.RowsDatagridNames.etap).numberRow].Cells[SveraParam.ColDatagridNames.Value].Value     = sveraP.FromDataBaseWideForSvera.EtapTxt;
                             sverPDataGrid.Rows[sveraP.RowList.FirstOrDefault(r => r.nameRow == SveraParam.RowsDatagridNames.kolic).numberRow].Cells[SveraParam.ColDatagridNames.Value].Value    = sveraP.FromDataBaseWideForSvera.Kolic;
                         }
                     }
                 }
                 else if (sverPDataGrid.Rows[e.RowIndex].Tag.ToString() == SveraParam.RowsDatagridNames.Podklass)
                 {
                     PodKlassForm rev = new PodKlassForm(sveraP.FromDataBaseWideForSvera);
                     if (rev.ShowDialog(this) == DialogResult.OK)
                     {
                         ChangeSpec();
                     }
                 }
                 else
                 {
                     string ved = sverPDataGrid.Rows[e.RowIndex].Cells[SveraParam.ColDatagridNames.Value].Value.ToString();
                     if (sverPDataGrid.Rows[e.RowIndex].Tag.ToString() == SveraParam.RowsDatagridNames.vedRabot)
                     {
                         ved = sveraP.FromDataBaseWideForSvera.VedRabot;
                     }
                     RedactText red = new RedactText(ved);
                     if (red.ShowDialog(this) == DialogResult.OK)
                     {
                         sverPDataGrid.Rows[e.RowIndex].Cells[SveraParam.ColDatagridNames.Value].Value = red.RedactRichBox.Text;
                         SveraParam.ChangeData(sverPDataGrid, sveraP.FromDataBaseWideForSvera, objectEditDataGrid, load, e.RowIndex, sverPDataGrid.Columns[SveraParam.ColDatagridNames.Value].Index);
                     }
                 }
             }
         }
     }
 }
Example #12
0
 private void sverPDataGrid_CellEndEdit(object sender, DataGridViewCellEventArgs e)
 {
     SveraParam.ChangeData(sverPDataGrid, SveraB.FromDataBaseWideForSvera, objectEditDataGrid, load, e.RowIndex, e.ColumnIndex);
 }