private void InitializeFormControls() { InitializeComponent(); button1.Visible = UserSession.IsAuthorized; wasDbUpdated = false; deletingFilesList = new List <UploadedFile>(); relatedFiles = new BindingList <UploadedFile>(); contactsList = new BindingList <ContactPerson>(); deletingContacts = new List <ContactPerson>(); contactsTable.RowsAdded += (sender, e) => DataGridViewHelper.CalculateNewRowNumber(contactsTable, 0, e.RowIndex, e.RowCount); DataGridViewHelper.ConfigureFileTable(filesTable, relatedFiles, deletingFilesList, linkLabel5, linkLabel4, linkLabel3); contactsTable.AutoGenerateColumns = false; contactsTable.DataSource = contactsList; filesTable.DataSource = relatedFiles; }
private void InitializeControls() { InitializeComponent(); filesTable.AutoGenerateColumns = false; dbWasChanged = false; moneyRemainLabel.Text = string.Empty; LoadProcedureTypesCBList(); button1.Visible = UserSession.IsAuthorized; tenderBeginDate.Value = protocolDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0).AddYears(Convert.ToInt32(year.Year) - DateTime.Now.Year); tenderBeginDate.MinDate = new DateTime(Convert.ToInt32(year.Year), 1, 1, 0, 0, 0); protocolDate.MinDate = new DateTime(Convert.ToInt32(year.Year - 1), 1, 1, 0, 0, 0); tenderBeginDate.MaxDate = protocolDate.MaxDate = new DateTime(Convert.ToInt32(year.Year), 12, 31, 0, 0, 0); deletingFiles = new List <UploadedFile>(); relatedFiles = new BindingList <UploadedFile>(); filesTable.DataSource = relatedFiles; DataGridViewHelper.ConfigureFileTable(filesTable, relatedFiles, deletingFiles, linkLabel1, linkLabel2, linkLabel3); using (TenderContext tc = new TenderContext()) { estimateList = tc.Estimates.Where(p => p.TenderYearId == this.year.Id).ToList(); controlWasChangedByUser = false; estimatesCBList.DataSource = estimateList; controlWasChangedByUser = true; estimatesCBList.DisplayMember = "Name"; estimatesCBList.ValueMember = "Id"; altKekvList = tc.KekvCodes.OrderBy(p => p.Code).Select(p => new KekvRemain { Kekv = p }).ToList(); altKekv.DataSource = altKekvList; mainKekv.DisplayMember = altKekv.DisplayMember = "Kekv"; mainKekv.ValueMember = altKekv.ValueMember = "Id"; } LoadKekvsOnEstimate(); }
public ContractsOnDkCodeForm(TenderPlanRecord record, bool isNewSystemSelected) { InitializeComponent(); contractsTable.AutoGenerateColumns = false; contractsTable.RowsAdded += (sender, e) => DataGridViewHelper.CalculateNewRowNumber(contractsTable, 0, e.RowIndex, e.RowCount); using (TenderContext tc = new TenderContext()) { tc.TenderPlanRecords.Attach(record); estimateNameLabel.Text = record.Estimate.Name; dkCodeLabel.Text = record.Dk.FullName; List <ContractsTableEntry> tableEntries = new List <ContractsTableEntry>(); if (isNewSystemSelected) { kekvLabel.Text = record.PrimaryKekv.Code; } else { kekvLabel.Text = record.SecondaryKekv.Code + "(по старой системе)"; } tableEntries = (from rec in tc.Contracts.ToList() where (rec.TenderPlanRecordId == record.Id) orderby rec.SignDate descending select new ContractsTableEntry { ContractDate = rec.SignDate, ContractNum = rec.Number, Contractor = rec.Contractor, Description = rec.Description, FullSum = rec.Sum, RelatedContract = rec, UsedSum = rec.UsedMoney }).ToList(); contractsTable.DataSource = tableEntries; } }
private void estimateTotalsTable_CellValueChanged(object sender, DataGridViewCellEventArgs e) { DataGridView changedTable = sender as DataGridView; DataGridViewHelper.RecalculateMoneyTotals(changedTable, e.RowIndex, e.ColumnIndex); // Если изменения не в итоговой таблице ... if ((changedTable.Name != "estimateTotalsTable") && (e.RowIndex < kekvsList.Count && e.ColumnIndex < monthes.Length)) { // ... вычисляем новую сумму и записываем в итоговую таблицу decimal cellSum = 0; for (int i = 1; i < tabControl1.TabCount; i++) { DataGridView dgv = tabControl1.TabPages[i].Controls.OfType <DataGridView>().First(); cellSum += (dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value == null) ? 0 : decimal.Parse(dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()); } estimateTotalsTable.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = cellSum; // ... и сохраняем их if (tableDataWasChangedByUser) { if (newSystemRButton.Checked) { estimateMoneyList[tabControl1.SelectedIndex - 1].PrimarySumValues[e.RowIndex, e.ColumnIndex] = decimal.Parse(changedTable.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()); } else { estimateMoneyList[tabControl1.SelectedIndex - 1].SecondarySumValues[e.RowIndex, e.ColumnIndex] = decimal.Parse(changedTable.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString()); } } } }
private DataGridView CopyDataGridView(DataGridView dgv_orn) { DataGridView dgv_copy = new DataGridView(); dgv_copy.Dock = dgv_orn.Dock; dgv_copy.RowHeadersWidth = dgv_orn.RowHeadersWidth; dgv_copy.AllowUserToAddRows = dgv_orn.AllowUserToAddRows; dgv_copy.AllowUserToDeleteRows = dgv_orn.AllowUserToDeleteRows; dgv_copy.AllowUserToOrderColumns = dgv_orn.AllowUserToOrderColumns; dgv_copy.AllowUserToResizeRows = dgv_orn.AllowUserToResizeRows; dgv_copy.AllowUserToResizeColumns = dgv_orn.AllowUserToResizeColumns; dgv_copy.RowHeadersWidthSizeMode = dgv_orn.RowHeadersWidthSizeMode; dgv_copy.SelectionMode = dgv_orn.SelectionMode; dgv_copy.MultiSelect = dgv_orn.MultiSelect; dgv_copy.RowHeadersDefaultCellStyle = dgv_orn.RowHeadersDefaultCellStyle; dgv_copy.ColumnHeadersDefaultCellStyle = dgv_orn.ColumnHeadersDefaultCellStyle; dgv_copy.ColumnHeadersHeightSizeMode = dgv_orn.ColumnHeadersHeightSizeMode; dgv_copy.CellValueChanged += estimateTotalsTable_CellValueChanged; dgv_copy.CellValidating += estimateTotalsTable_CellValidating; dgv_copy.SortCompare += (sender, e) => DataGridViewHelper.SortCompareForMoneyTable(dgv_copy, e); for (int i = 0; i < dgv_orn.ColumnCount; i++) { DataGridViewColumn col = dgv_orn.Columns[i].Clone() as DataGridViewColumn; col.ValueType = typeof(decimal); col.DefaultCellStyle = dgv_orn.Columns[i].DefaultCellStyle; dgv_copy.Columns.Add(col); } for (int i = 0; i < dgv_orn.RowCount; i++) { dgv_copy.Rows.Add(dgv_orn.Rows[i].Clone() as DataGridViewRow); } return(dgv_copy); }
public DkCodesListForm() { InitializeComponent(); if (UserSession.IsAuthorized) { dkCodesTable.CellDoubleClick += dkCodesTable_CellDoubleClick; } else { linkLabel1.Visible = linkLabel2.Visible = false; } wasDbUpdated = false; dkCodesTable.RowsAdded += (sender, e) => DataGridViewHelper.CalculateNewRowNumber(dkCodesTable, 0, e.RowIndex, e.RowCount); using (TenderContext tc = new TenderContext()) { dkCodesTable.AutoGenerateColumns = false; codesList = new BindingList <DkCode>(tc.DkCodes.OrderBy(p => p.Code).ToList()); dkCodesTable.DataSource = codesList; } }
private void InitializeFormControls(TenderYear year) { InitializeComponent(); button1.Visible = UserSession.IsAuthorized; label6.Text = string.Empty; this.year = year; controlValueWasChangedByUser = false; locker = new object(); kekvRemains = new List <decimal>(); moneysOnSources = new List <decimal>(); relatedFiles = new BindingList <UploadedFile>(); deletingFiles = new BindingList <UploadedFile>(); DataGridViewHelper.ConfigureFileTable(filesTable, relatedFiles, deletingFiles, linkLabel1, linkLabel2, linkLabel3); filesTable.DataSource = relatedFiles; spendingDescription.Text = spendingRecord.Description; spendingFullSum.Value = spendingRecord.Sum; if (spendingRecord.Id == 0) { dateTimePicker1.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0).AddYears(Convert.ToInt32(year.Year) - DateTime.Now.Year); } else { dateTimePicker1.Value = spendingRecord.CreationDate; } dateTimePicker1.MinDate = new DateTime(Convert.ToInt32(year.Year), 1, 1, 0, 0, 0); dateTimePicker1.MaxDate = new DateTime(Convert.ToInt32(year.Year), 12, 31, 0, 0, 0); switch (spendingRecord.Status) { case PaymentStatus.New: newStatusRButton.Checked = true; break; case PaymentStatus.OnPayment: onPayStatusRButton.Checked = true; break; case PaymentStatus.Payed: paidStatusRButton.Checked = true; break; } using (TenderContext tc = new TenderContext()) { sourcesList = tc.MoneySources.OrderBy(p => p.ViewPriority).ToList(); estimateCBList.DataSource = tc.Estimates .Where(t => (t.TenderYearId == year.Id) && (t.Changes.Sum(p => p.PrimaryKekvSum) > 0)) .OrderBy(t => t.Id) .ToList(); Estimate selectedEstimate = estimateCBList.SelectedItem as Estimate; altKekvCBList.DataSource = tc.KekvCodes.OrderBy(p => p.Code).ToList(); } for (int i = 0; i <= sourcesList.Count; i++) { DataGridViewRow newRow = new DataGridViewRow(); newRow.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; newRow.DefaultCellStyle.WrapMode = DataGridViewTriState.True; if (i < sourcesList.Count) { newRow.HeaderCell.Value = sourcesList[i].Name.ToString(); } else { newRow.HeaderCell.Value = "ВСЬОГО"; newRow.DefaultCellStyle.Font = FormStyles.MoneyTotalsFont; newRow.ReadOnly = true; } balanceChangesTable.Rows.Add(newRow); } for (int i = 0; i < balanceChangesTable.ColumnCount; i++) { balanceChangesTable.Columns[i].ValueType = typeof(decimal); balanceChangesTable.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable; } for (int i = 0; i < (balanceChangesTable.RowCount - 1); i++) { balanceChangesTable.Rows[i].Cells[0].Value = 0; balanceChangesTable.Rows[i].Cells[1].Value = 0; moneysOnSources.Add(0); } controlValueWasChangedByUser = true; }
private void InitializeFormControls(TenderYear year) { InitializeComponent(); button1.Visible = UserSession.IsAuthorized; label6.Text = estimateNameLabel.Text = string.Empty; this.year = year; controlValueWasChangedByUser = false; locker = new object(); contractsRemains = new List <decimal>(); moneysOnSources = new List <decimal>(); relatedFiles = new BindingList <UploadedFile>(); deletingFiles = new BindingList <UploadedFile>(); DataGridViewHelper.ConfigureFileTable(filesTable, relatedFiles, deletingFiles, linkLabel1, linkLabel2, linkLabel3); filesTable.DataSource = relatedFiles; numberTextBox.Text = invoiceRecord.Number; descriptionTextBox.Text = invoiceRecord.Description; invoiceFullSum.Value = invoiceRecord.Sum; IsCreditCheckBox.Checked = invoiceRecord.IsCredit; switch (invoiceRecord.Status) { case PaymentStatus.New: newStatusRButton.Checked = true; break; case PaymentStatus.OnPayment: onPayStatusRButton.Checked = true; break; case PaymentStatus.Payed: paidStatusRButton.Checked = true; break; } if (invoiceRecord.Id == 0) { invoiceDate.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0).AddYears(Convert.ToInt32(year.Year) - DateTime.Now.Year); } else { invoiceDate.Value = invoiceRecord.Date; } invoiceDate.MaxDate = new DateTime(Convert.ToInt32(year.Year), 12, 31, 0, 0, 0); invoiceDate.MinDate = new DateTime(Convert.ToInt32(year.Year), 1, 1, 0, 0, 0); using (TenderContext tc = new TenderContext()) { sourcesList = tc.MoneySources.OrderBy(p => p.ViewPriority).ToList(); contractorsCBList.DataSource = tc.Contracts.ToList() .Where(p => (p.RecordInPlan.Estimate.TenderYearId == year.Id) && (p.Status == ContractStatus.Active)) .Select(p => p.Contractor).Distinct().OrderBy(p => p.ShortName) .ToList(); contractorsCBList.ValueMember = "Id"; contractorsCBList.DisplayMember = "ShortName"; contractsCBList.ValueMember = "Id"; contractsCBList.DisplayMember = "FullName"; } for (int i = 0; i <= sourcesList.Count; i++) { DataGridViewRow newRow = new DataGridViewRow(); newRow.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; newRow.DefaultCellStyle.WrapMode = DataGridViewTriState.True; if (i < sourcesList.Count) { newRow.HeaderCell.Value = sourcesList[i].Name.ToString(); } else { newRow.HeaderCell.Value = "ВСЬОГО"; newRow.DefaultCellStyle.Font = FormStyles.MoneyTotalsFont; newRow.ReadOnly = true; } balanceChangesTable.Rows.Add(newRow); } for (int i = 0; i < balanceChangesTable.ColumnCount; i++) { balanceChangesTable.Columns[i].ValueType = typeof(decimal); balanceChangesTable.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable; } controlValueWasChangedByUser = false; for (int i = 0; i < (balanceChangesTable.RowCount - 1); i++) { balanceChangesTable.Rows[i].Cells[0].Value = 0; balanceChangesTable.Rows[i].Cells[1].Value = 0; moneysOnSources.Add(0); } controlValueWasChangedByUser = true; }
private void estimateTable_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e) { DataGridViewHelper.CalculateNewRowNumber(sender as DataGridView, 0, e.RowIndex, e.RowCount); }
private void estimateTotalsTable_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { DataGridViewHelper.MoneyCellValidating(sender as DataGridView, e.FormattedValue.ToString()); }