Exemplo n.º 1
0
        private void autofillButton_Click(object sender, EventArgs e)
        {
            SvodVedomostGetPacketsForm tmpForm = new SvodVedomostGetPacketsForm(_org, RepYear, _connection);
            DialogResult dRes = tmpForm.ShowDialog(this);

            if (dRes == DialogResult.OK)
            {
                long[]    markedPacked        = tmpForm.MarckedPackets;
                long[]    doctypes            = { 21, 22, 24 };
                DataTable salaryInfoTranspose = SalaryInfoTranspose.CreateTableWithRows();
                if (markedPacked.Length > 0)
                {
                    DataTable         salaryInfoTable = SalaryInfo.CreateTable();
                    SQLiteDataAdapter adapter         = new SQLiteDataAdapter(SalaryInfo.GetSelectText(markedPacked, doctypes),
                                                                              _connection);
                    adapter.Fill(salaryInfoTable);
                    SalaryInfoTranspose.ConvertFromSalaryInfo(salaryInfoTranspose, salaryInfoTable);
                    packetcountBox.Value   = markedPacked.Length;
                    documentcountBox.Value = Docs.Count(markedPacked, _connection);
                    // (long)salaryInfoTable.Rows[0][SalaryInfo.docId];
                }
                else
                {
                    packetcountBox.Value   = 0;
                    documentcountBox.Value = 0;
                }
                int i;
                for (i = 0; i < 12; i++)
                {
                    _svodTable.Rows[i][SalaryGroups.Column1] = salaryInfoTranspose.Rows[i][SalaryGroups.Column1];
                    _svodTable.Rows[i][SalaryGroups.Column2] = salaryInfoTranspose.Rows[i][SalaryGroups.Column2];
                    _svodTable.Rows[i][SalaryGroups.Column3] = salaryInfoTranspose.Rows[i][SalaryGroups.Column3];
                    _svodTable.Rows[i][SalaryGroups.Column4] = salaryInfoTranspose.Rows[i][SalaryGroups.Column4];
                    _svodTable.Rows[i][SalaryGroups.Column5] = salaryInfoTranspose.Rows[i][SalaryGroups.Column5];
                    _svodTable.Rows[i].EndEdit();
                    _svodTable.AcceptChanges();
                }
            }
        }