RUS_-_Karejev_-_Razrabotka_Windows-prilozhenij
.pdftotalTableStyle.GridColumnStyles.AddRange(new DataGridTextBoxColumn[] { totalIDStyle, currentDateStyle, amountYesterdayStyle, amountTodayStyle, incomeTodayStyle, expanseTodayStyle, totalNoteStyle});
dgWorkTable.TableStyles.Add(totalTableStyle);
// Стиль таблицы groups на странице "Основные таблицы"
DataGridTableStyle dgWorkTableGroupsTableStyle = new DataGridTableStyle(); dgWorkTableGroupsTableStyle.MappingName = "groups";
DataGridTextBoxColumn dgWorkTableGroupIDStyle = new DataGridTextBoxColumn(); dgWorkTableGroupIDStyle.MappingName = "groupID"; dgWorkTableGroupIDStyle.Width = 100;
dgWorkTableGroupIDStyle.HeaderText = "Номер группы";
DataGridTextBoxColumn dgWorkTableBeginDateStyle = new DataGridTextBoxColumn(); dgWorkTableBeginDateStyle.MappingName = "beginDate"; dgWorkTableBeginDateStyle.Width = 100;
dgWorkTableBeginDateStyle.Format = "dd MMMM yyyy"; dgWorkTableBeginDateStyle.HeaderText = "Дата начала";
DataGridTextBoxColumn dgWorkTableEndDateStyle = new DataGridTextBoxColumn(); dgWorkTableEndDateStyle.MappingName = "endDate"; dgWorkTableEndDateStyle.Width = 100;
dgWorkTableEndDateStyle.Format = "dd MMMM yyyy"; dgWorkTableEndDateStyle.HeaderText = "Дата окончания";
DataGridTextBoxColumn dgWorkTableBeginTimeStyle = new DataGridTextBoxColumn(); dgWorkTableBeginTimeStyle.MappingName = "beginTime"; dgWorkTableBeginTimeStyle.Width = 100;
dgWorkTableBeginTimeStyle.Format = "HH:mm"; dgWorkTableBeginTimeStyle.HeaderText = "Время начала";
DataGridTextBoxColumn dgWorkTableEndTimeStyle = new DataGridTextBoxColumn(); dgWorkTableEndTimeStyle.MappingName = "endTime"; dgWorkTableEndTimeStyle.Width = 100;
dgWorkTableEndTimeStyle.Format = "HH:mm"; dgWorkTableEndTimeStyle.HeaderText = "Время окончания";
DataGridTextBoxColumn dgWorkTableClassNumberStyle = new DataGridTextBoxColumn(); dgWorkTableClassNumberStyle.MappingName = "classNumber"; dgWorkTableClassNumberStyle.Width = 100;
dgWorkTableClassNumberStyle.HeaderText = "Номер класса";
DataGridTextBoxColumn dgWorkTableCourseIDStyle = new DataGridTextBoxColumn(); dgWorkTableCourseIDStyle.MappingName = "courseID"; dgWorkTableCourseIDStyle.Width = 100;
dgWorkTableCourseIDStyle.HeaderText = "Номер курса";
DataGridTextBoxColumn dgWorkTableEmployeeIDStyle = new DataGridTextBoxColumn(); dgWorkTableEmployeeIDStyle.MappingName = "employeeID"; dgWorkTableEmployeeIDStyle.Width = 100;
dgWorkTableEmployeeIDStyle.HeaderText = "Номер сотрудника";
DataGridTextBoxColumn dgWorkTableGroupNoteStyle = new DataGridTextBoxColumn(); dgWorkTableGroupNoteStyle.MappingName = "note"; dgWorkTableGroupNoteStyle.Width = 100;
dgWorkTableGroupNoteStyle.HeaderText = "Заметки";
DataGridTextBoxColumn dgWorkTableStatusIDStyle = new DataGridTextBoxColumn(); dgWorkTableStatusIDStyle.MappingName = "StatusID"; dgWorkTableStatusIDStyle.Width = 100;
dgWorkTableStatusIDStyle.HeaderText = "Номер статуса группы";
dgWorkTableGroupsTableStyle.GridColumnStyles.AddRange(new DataGridTextBoxColumn[] { dgWorkTableGroupIDStyle, dgWorkTableClassNumberStyle, dgWorkTableBeginDateStyle, dgWorkTableEndDateStyle, dgWorkTableBeginTimeStyle, dgWorkTableEndTimeStyle, dgWorkTableCourseIDStyle, dgWorkTableEmployeeIDStyle,
dgWorkTableGroupNoteStyle, dgWorkTableStatusIDStyle
});
dgWorkTable.TableStyles.Add(dgWorkTableGroupsTableStyle);
// Стиль таблицы clients на странице "Основные таблицы"
DataGridTableStyle dgWorkTableСlientsTableStyle = new DataGridTableStyle(); dgWorkTableСlientsTableStyle.MappingName = "clients";
DataGridTextBoxColumn dgWorkTableClientIDStyle = new DataGridTextBoxColumn();
dgWorkTableClientIDStyle.MappingName = "clientID"; dgWorkTableClientIDStyle.Width = 100; dgWorkTableClientIDStyle.HeaderText = "Номер клиента";
DataGridTextBoxColumn dgWorkTableFirstNameStyle = new DataGridTextBoxColumn(); dgWorkTableFirstNameStyle.MappingName = "fname"; dgWorkTableFirstNameStyle.Width = 100;
dgWorkTableFirstNameStyle.HeaderText = "Имя";
DataGridTextBoxColumn dgWorkTableLastNameStyle = new DataGridTextBoxColumn(); dgWorkTableLastNameStyle.MappingName = "lname"; dgWorkTableLastNameStyle.Width = 100;
dgWorkTableLastNameStyle.HeaderText = "Фамилия";
DataGridTextBoxColumn dgWorkTableFatherNameStyle = new DataGridTextBoxColumn(); dgWorkTableFatherNameStyle.MappingName = "fathName"; dgWorkTableFatherNameStyle.Width = 100;
dgWorkTableFatherNameStyle.HeaderText = "Отчество";
DataGridTextBoxColumn dgWorkTableLinkDataStyle = new DataGridTextBoxColumn(); dgWorkTableLinkDataStyle.MappingName = "linkData"; dgWorkTableLinkDataStyle.Width = 100;
dgWorkTableLinkDataStyle.HeaderText = "Контакты";
DataGridTextBoxColumn dgWorkTableRecordDateStyle = new DataGridTextBoxColumn(); dgWorkTableRecordDateStyle.MappingName = "recorddate"; dgWorkTableRecordDateStyle.Width = 100;
dgWorkTableRecordDateStyle.Format = "dd-MMMM-yyyy"; dgWorkTableRecordDateStyle.HeaderText = "Дата записи";
DataGridTextBoxColumn dgWorkTableClientNoteStyle = new DataGridTextBoxColumn(); dgWorkTableClientNoteStyle.MappingName = "note"; dgWorkTableClientNoteStyle.Width = 100;
dgWorkTableClientNoteStyle.HeaderText = "Заметки";
DataGridTextBoxColumn dgWorkTablePaymentTypeStyle = new DataGridTextBoxColumn(); dgWorkTablePaymentTypeStyle.MappingName = "paymentType"; dgWorkTablePaymentTypeStyle.Width = 100;
dgWorkTablePaymentTypeStyle.HeaderText = "Тип оплаты";
dgWorkTableСlientsTableStyle.GridColumnStyles.AddRange(new DataGridTextBoxColumn[] { dgWorkTableClientIDStyle, dgWorkTableLastNameStyle, dgWorkTableFirstNameStyle,
dgWorkTableFatherNameStyle,
dgWorkTableLinkDataStyle,
dgWorkTableRecordDateStyle,
dgWorkTableClientNoteStyle,
dgWorkTablePaymentTypeStyle});
dgWorkTable.TableStyles.Add(dgWorkTableСlientsTableStyle);
// Стиль таблицы income на странице "Основные таблицы"
DataGridTableStyle dgWorkTableIncomeTableStyle = new DataGridTableStyle(); dgWorkTableIncomeTableStyle.MappingName = "income";
DataGridTextBoxColumn dgWorkTableIncomeIDStyle = new DataGridTextBoxColumn(); dgWorkTableIncomeIDStyle.MappingName = "incomeID"; dgWorkTableIncomeIDStyle.Width = 100;
dgWorkTableIncomeIDStyle.HeaderText = "ID прихода";
DataGridTextBoxColumn dgWorkTableIncomeClientIDStyle = new DataGridTextBoxColumn(); dgWorkTableIncomeClientIDStyle.MappingName = "clientID"; dgWorkTableIncomeClientIDStyle.Width = 100; dgWorkTableIncomeClientIDStyle.HeaderText = "ID клиента";
DataGridTextBoxColumn dgWorkTableIncomeSummaStyle = new DataGridTextBoxColumn(); dgWorkTableIncomeSummaStyle.MappingName = "summa"; dgWorkTableIncomeSummaStyle.Width = 100;
dgWorkTableIncomeSummaStyle.Format = "#.0"; dgWorkTableIncomeSummaStyle.HeaderText = "Сумма";
DataGridTextBoxColumn dgWorkTableIncomePaymentTypeIDStyle = new DataGridTextBoxColumn(); dgWorkTableIncomePaymentTypeIDStyle.MappingName = "payment_typeID"; dgWorkTableIncomePaymentTypeIDStyle.Width = 100; dgWorkTableIncomePaymentTypeIDStyle.HeaderText = "Код вида оплаты";
DataGridTextBoxColumn dgWorkTableIncomeNoteStyle = new DataGridTextBoxColumn(); dgWorkTableIncomeNoteStyle.MappingName = "note"; dgWorkTableIncomeNoteStyle.Width = 100;
dgWorkTableIncomeNoteStyle.HeaderText = "Заметки";
DataGridBoolColumn dgWorkTableRealizedStyle = new DataGridBoolColumn(); dgWorkTableRealizedStyle.MappingName = "IsRealized"; dgWorkTableRealizedStyle.Width = 100; dgWorkTableRealizedStyle.HeaderText = "Реализовано";
DataGridTextBoxColumn dgWorkTableDataIDStyle = new DataGridTextBoxColumn();
dgWorkTableDataIDStyle.MappingName = "dataID"; dgWorkTableDataIDStyle.Width = 100; dgWorkTableDataIDStyle.HeaderText = "ID data";
dgWorkTableIncomeTableStyle.GridColumnStyles.AddRange(new DataGridColumnStyle[] { dgWorkTableIncomeIDStyle, dgWorkTableIncomeClientIDStyle, dgWorkTableIncomeSummaStyle, dgWorkTableIncomePaymentTypeIDStyle, dgWorkTableIncomeNoteStyle, dgWorkTableRealizedStyle, dgWorkTableDataIDStyle});
dgWorkTableIncomeTableStyle.HeaderBackColor = dgWorkTable.HeaderBackColor; dgWorkTableIncomeTableStyle.BackColor = dgWorkTable.BackColor; dgWorkTableIncomeTableStyle.ForeColor = dgWorkTable.ForeColor; dgWorkTableIncomeTableStyle.GridLineColor = dgWorkTable.GridLineColor; dgWorkTableIncomeTableStyle.HeaderForeColor = dgWorkTable.HeaderForeColor; dgWorkTableIncomeTableStyle.SelectionBackColor = dgWorkTable.SelectionBackColor; dgWorkTableIncomeTableStyle.SelectionForeColor = dgWorkTable.SelectionForeColor; dgWorkTable.TableStyles.Add(dgWorkTableIncomeTableStyle);
// Стиль таблицы expenses на странице "Основные таблицы"
DataGridTableStyle dgWorkTableExpensesTableStyle = new DataGridTableStyle(); dgWorkTableExpensesTableStyle.MappingName = "expenses";
DataGridTextBoxColumn dgWorkTableExpensesExpenseIDStyle = new DataGridTextBoxColumn(); dgWorkTableExpensesExpenseIDStyle.MappingName = "expenseID"; dgWorkTableExpensesExpenseIDStyle.Width = 100; dgWorkTableExpensesExpenseIDStyle.HeaderText = "ID расхода";
DataGridTextBoxColumn dgWorkTableExpensesDataIDStyle = new DataGridTextBoxColumn(); dgWorkTableExpensesDataIDStyle.MappingName = "dataID"; dgWorkTableExpensesDataIDStyle.Width = 100; dgWorkTableExpensesDataIDStyle.HeaderText = "ID data";
DataGridTextBoxColumn dgWorkTableExpensesClientIDStyle = new DataGridTextBoxColumn(); dgWorkTableExpensesClientIDStyle.MappingName = "clientID"; dgWorkTableExpensesClientIDStyle.Width = 100; dgWorkTableExpensesClientIDStyle.HeaderText = "ID клиента";
DataGridTextBoxColumn dgWorkTableExpensesEmployeeIDStyle = new DataGridTextBoxColumn(); dgWorkTableExpensesEmployeeIDStyle.MappingName = "employeeID"; dgWorkTableExpensesEmployeeIDStyle.Width = 100; dgWorkTableExpensesEmployeeIDStyle.HeaderText = "ID сотрудника";
DataGridTextBoxColumn dgWorkTableExpensesSummaStyle = new DataGridTextBoxColumn(); dgWorkTableExpensesSummaStyle.MappingName = "summa"; dgWorkTableExpensesSummaStyle.Width = 100;
dgWorkTableExpensesSummaStyle.Format = "#.0"; dgWorkTableExpensesSummaStyle.HeaderText = "Сумма";
DataGridTextBoxColumn dgWorkTableExpensesPaymentTypeIDStyle = new DataGridTextBoxColumn(); dgWorkTableExpensesPaymentTypeIDStyle.MappingName = "payment_typeID"; dgWorkTableExpensesPaymentTypeIDStyle.Width = 100; dgWorkTableExpensesPaymentTypeIDStyle.HeaderText = "Код вида оплаты";
DataGridTextBoxColumn dgWorkTableExpensesNoteStyle = new DataGridTextBoxColumn(); dgWorkTableExpensesNoteStyle.MappingName = "note"; dgWorkTableExpensesNoteStyle.Width = 100;
dgWorkTableExpensesNoteStyle.HeaderText = "Заметки";
dgWorkTableExpensesTableStyle.GridColumnStyles.AddRange(new DataGridColumnStyle[] {
dgWorkTableExpensesExpenseIDStyle,
dgWorkTableExpensesDataIDStyle,
dgWorkTableExpensesClientIDStyle,
dgWorkTableExpensesEmployeeIDStyle,
dgWorkTableExpensesSummaStyle,
dgWorkTableExpensesPaymentTypeIDStyle,
dgWorkTableExpensesNoteStyle});
dgWorkTableExpensesTableStyle.HeaderBackColor = dgWorkTable.HeaderBackColor; dgWorkTableExpensesTableStyle.BackColor = dgWorkTable.BackColor; dgWorkTableExpensesTableStyle.ForeColor = dgWorkTable.ForeColor; dgWorkTableExpensesTableStyle.GridLineColor = dgWorkTable.GridLineColor; dgWorkTableExpensesTableStyle.HeaderForeColor = dgWorkTable.HeaderForeColor; dgWorkTableExpensesTableStyle.SelectionBackColor = dgWorkTable.SelectionBackColor; dgWorkTableExpensesTableStyle.SelectionForeColor = dgWorkTable.SelectionForeColor; dgWorkTable.TableStyles.Add(dgWorkTableExpensesTableStyle);
// Стиль таблицы employees на странице "Основные таблицы"
DataGridTableStyle dgWorkTableEmployeesTableStyle = new DataGridTableStyle(); dgWorkTableEmployeesTableStyle.MappingName = "employees";
DataGridTextBoxColumn dgWorkTableEmployeesEmployeeIDStyle = new DataGridTextBoxColumn(); dgWorkTableEmployeesEmployeeIDStyle.MappingName = "employeeID"; dgWorkTableEmployeesEmployeeIDStyle.Width = 100; dgWorkTableEmployeesEmployeeIDStyle.HeaderText = "Номер сотрудника";
DataGridTextBoxColumn dgWorkTableEmployeesFirstNameStyle = new DataGridTextBoxColumn(); dgWorkTableEmployeesFirstNameStyle.MappingName = "FirstName"; dgWorkTableEmployeesFirstNameStyle.Width = 100; dgWorkTableEmployeesFirstNameStyle.HeaderText = "Имя";
DataGridTextBoxColumn dgWorkTableEmployeesLastNameStyle = new DataGridTextBoxColumn(); dgWorkTableEmployeesLastNameStyle.MappingName = "LastName"; dgWorkTableEmployeesLastNameStyle.Width = 100; dgWorkTableEmployeesLastNameStyle.HeaderText = "Фамилия";
DataGridTextBoxColumn dgWorkTableEmployeesFatherNameStyle = new DataGridTextBoxColumn(); dgWorkTableEmployeesFatherNameStyle.MappingName = "FatherName"; dgWorkTableEmployeesFatherNameStyle.Width = 100; dgWorkTableEmployeesFatherNameStyle.HeaderText = "Отчество";
DataGridTextBoxColumn dgWorkTableEmployeesLinkDataStyle = new DataGridTextBoxColumn(); dgWorkTableEmployeesLinkDataStyle.MappingName = "linkData"; dgWorkTableEmployeesLinkDataStyle.Width = 100; dgWorkTableEmployeesLinkDataStyle.HeaderText = "Контакты";
DataGridTextBoxColumn dgWorkTableEmployeesBirthdayStyle = new DataGridTextBoxColumn(); dgWorkTableEmployeesBirthdayStyle.MappingName = "birthday"; dgWorkTableEmployeesBirthdayStyle.Width = 100; dgWorkTableEmployeesBirthdayStyle.Format = "dd-MMMM-yyyy"; dgWorkTableEmployeesBirthdayStyle.HeaderText = "День рождения";
DataGridTextBoxColumn dgWorkTableEmployeesDirectionIDStyle = new DataGridTextBoxColumn(); dgWorkTableEmployeesDirectionIDStyle.MappingName = "directionID"; dgWorkTableEmployeesDirectionIDStyle.Width = 100; dgWorkTableEmployeesDirectionIDStyle.HeaderText = "Номер направления";
dgWorkTableEmployeesTableStyle.GridColumnStyles.AddRange(new DataGridTextBoxColumn[] { dgWorkTableEmployeesEmployeeIDStyle, dgWorkTableEmployeesLastNameStyle,
dgWorkTableEmployeesFirstNameStyle,
dgWorkTableEmployeesFatherNameStyle,
dgWorkTableEmployeesLinkDataStyle,
dgWorkTableEmployeesBirthdayStyle,
dgWorkTableEmployeesDirectionIDStyle}
);
dgWorkTable.TableStyles.Add(dgWorkTableEmployeesTableStyle);
// Стиль таблицы GroupStatus на странице "Основные таблицы"
DataGridTableStyle dgWorkTableGroupStatusTableStyle = new DataGridTableStyle(); dgWorkTableGroupStatusTableStyle.MappingName = "GroupStatus";
DataGridTextBoxColumn dgWorkTableGroupStatusStatusIDStyle = new DataGridTextBoxColumn(); dgWorkTableGroupStatusStatusIDStyle.MappingName = "StatusID"; dgWorkTableGroupStatusStatusIDStyle.Width = 100; dgWorkTableGroupStatusStatusIDStyle.HeaderText = "Номер статуса";
DataGridTextBoxColumn dgWorkTableStatusNameStyle = new DataGridTextBoxColumn(); dgWorkTableStatusNameStyle.MappingName = "StatusName"; dgWorkTableStatusNameStyle.Width = 100;
dgWorkTableStatusNameStyle.HeaderText = "Имя";
dgWorkTableGroupStatusTableStyle.GridColumnStyles.AddRange(new DataGridTextBoxColumn[] {
dgWorkTableGroupStatusStatusIDStyle,
dgWorkTableStatusNameStyle});
dgWorkTable.TableStyles.Add(dgWorkTableGroupStatusTableStyle);
// Стиль таблицы payment_type на странице "Основные таблицы" DataGridTableStyle dgWorkTablePaymentTypeTableStyle = new DataGridTableStyle(); dgWorkTablePaymentTypeTableStyle.MappingName = "payment_type";
DataGridTextBoxColumn dgWorkTablePaymentTypeIDStyle = new DataGridTextBoxColumn(); dgWorkTablePaymentTypeIDStyle.MappingName = "payment_typeID"; dgWorkTablePaymentTypeIDStyle.Width = 100; dgWorkTablePaymentTypeIDStyle.HeaderText = "Номер вида оплаты";
DataGridTextBoxColumn dgWorkTablePaymentTypeNameStyle = new DataGridTextBoxColumn(); dgWorkTablePaymentTypeNameStyle.MappingName = "payment_typeName"; dgWorkTablePaymentTypeNameStyle.Width = 100; dgWorkTablePaymentTypeNameStyle.HeaderText = "Наименование оплаты";
DataGridTextBoxColumn dgWorkTablePaymentNotesStyle = new DataGridTextBoxColumn(); dgWorkTablePaymentNotesStyle.MappingName = "note"; dgWorkTablePaymentNotesStyle.Width = 100;
dgWorkTablePaymentNotesStyle.HeaderText = "Заметки";
dgWorkTablePaymentTypeTableStyle.GridColumnStyles.AddRange(new DataGridTextBoxColumn[] { dgWorkTablePaymentTypeIDStyle, dgWorkTablePaymentTypeNameStyle, dgWorkTablePaymentNotesStyle});
dgWorkTable.TableStyles.Add(dgWorkTablePaymentTypeTableStyle);
// Стиль таблицы RealizedTable на странице "Основные таблицы" DataGridTableStyle dgWorkTableRealizedTableStyle = new DataGridTableStyle(); dgWorkTableRealizedTableStyle.MappingName = "RealizedTable";
DataGridTextBoxColumn dgWorkTableRealizedTableIDStyle = new DataGridTextBoxColumn(); dgWorkTableRealizedTableIDStyle.MappingName = "ID"; dgWorkTableRealizedTableIDStyle.Width = 100; dgWorkTableRealizedTableIDStyle.HeaderText = "Номер реализации";
DataGridTextBoxColumn dgWorkTableRealizedSummStyle = new DataGridTextBoxColumn(); dgWorkTableRealizedSummStyle.MappingName = "realizedSumm"; dgWorkTableRealizedSummStyle.Width = 100;
dgWorkTableRealizedSummStyle.HeaderText = "Реализованная сумма";
DataGridTextBoxColumn dgWorkTableRealizingDateStyle = new DataGridTextBoxColumn(); dgWorkTableRealizingDateStyle.MappingName = "realizingDate"; dgWorkTableRealizingDateStyle.Width = 100;
dgWorkTableRealizingDateStyle.Format = "dd-MMMM-yyyy"; dgWorkTableRealizingDateStyle.HeaderText = "Дата реализации";
DataGridTextBoxColumn dgWorkTableRealizedTableNotesStyle = new DataGridTextBoxColumn(); dgWorkTableRealizedTableNotesStyle.MappingName = "note"; dgWorkTableRealizedTableNotesStyle.Width = 100; dgWorkTableRealizedTableNotesStyle.HeaderText = "Заметки";
DataGridTextBoxColumn dgWorkTableRealizedTableClientIDStyle = new DataGridTextBoxColumn(); dgWorkTableRealizedTableClientIDStyle.MappingName = "clientID"; dgWorkTableRealizedTableClientIDStyle.Width = 100; dgWorkTableRealizedTableClientIDStyle.HeaderText = "Номер клиента";
dgWorkTableRealizedTableStyle.GridColumnStyles.AddRange(new DataGridTextBoxColumn[] { dgWorkTableRealizedTableIDStyle, dgWorkTableRealizedSummStyle, dgWorkTableRealizingDateStyle,
dgWorkTableRealizedTableNotesStyle,
dgWorkTableRealizedTableClientIDStyle}
);
dgWorkTable.TableStyles.Add(dgWorkTableRealizedTableStyle);
// Стиль таблицы group_clients на странице "Основные таблицы" DataGridTableStyle dgWorkTableGroupClientsStyle = new DataGridTableStyle(); dgWorkTableGroupClientsStyle.MappingName = "group_clients";
DataGridTextBoxColumn dgWorkTableGroupClientIDStyle = new DataGridTextBoxColumn(); dgWorkTableGroupClientIDStyle.MappingName = "GroupClientID"; dgWorkTableGroupClientIDStyle.Width = 100; dgWorkTableGroupClientIDStyle.HeaderText = "ID";
DataGridTextBoxColumn dgWorkTableGroupClientsGroupIDStyle = new DataGridTextBoxColumn(); dgWorkTableGroupClientsGroupIDStyle.MappingName = "groupID"; dgWorkTableGroupClientsGroupIDStyle.Width = 100; dgWorkTableGroupClientsGroupIDStyle.HeaderText = "Номер группы";
DataGridTextBoxColumn dgWorkTableGroupClientsClientIDStyle = new DataGridTextBoxColumn(); dgWorkTableGroupClientsClientIDStyle.MappingName = "clientID"; dgWorkTableGroupClientsClientIDStyle.Width = 100; dgWorkTableGroupClientsClientIDStyle.HeaderText = "Номер клиента";
DataGridBoolColumn dgWorkTableGroupClientsIsPaidStyle = new DataGridBoolColumn(); dgWorkTableGroupClientsIsPaidStyle.MappingName = "IsPaid"; dgWorkTableGroupClientsIsPaidStyle.Width = 50; dgWorkTableGroupClientsIsPaidStyle.HeaderText = "Оплачено";
DataGridTextBoxColumn dgWorkTableGroupClientsNotesStyle = new DataGridTextBoxColumn(); dgWorkTableGroupClientsNotesStyle.MappingName = "Notes"; dgWorkTableGroupClientsNotesStyle.Width = 100; dgWorkTableGroupClientsNotesStyle.HeaderText = "Заметки";
dgWorkTableGroupClientsStyle.GridColumnStyles.AddRange( new DataGridColumnStyle[] { dgWorkTableGroupClientIDStyle, dgWorkTableGroupClientsGroupIDStyle,
dgWorkTableGroupClientsClientIDStyle,
dgWorkTableGroupClientsIsPaidStyle,
dgWorkTableGroupClientsNotesStyle});
dgWorkTable.TableStyles.Add(dgWorkTableGroupClientsStyle);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.Source);
}
}
// Сумма прихода клиента
private double ClientIncomeSumm(int clientID)
{
DataView dvIncome = new DataView(mainDataSet.income); dvIncome.RowFilter = "clientID = " + clientID.ToString();
double clientIncomeSumm = 0;
foreach (DataRowView drvIncomeClient in dvIncome)
{
if (drvIncomeClient.Row["summa"] != null)
clientIncomeSumm += (double)drvIncomeClient.Row["summa"];
}
return clientIncomeSumm;
}
// Реализованная сумма клиента
private double ClientRealizedSumm(int clientID)
{
DataView dvRealized = new DataView(mainDataSet.RealizedTable); dvRealized.RowFilter = "clientID = " + clientID.ToString();
double clientRealizedSumm = 0;
foreach (DataRowView drvRealized in dvRealized)
{
clientRealizedSumm += (double)drvRealized.Row["realizedSumm"];
}
return clientRealizedSumm;
}
// Вычисление должников — метод нужен для страницы 'Статистика' private void GetOweStatistic()
{
try
{
int directionID = cmbFilteringDirection.SelectedIndex + 1;
DataView dvCourses = new DataView(mainDataSet.course); dvCourses.RowFilter = "directionID = " + directionID.ToString();
double summOweEdCenter = 0; double summOweToEdCenter = 0;
foreach (DataRowView drvCourse in dvCourses)
{
DataRow course = drvCourse.Row;
DataRow[] groups = course.GetChildRows("coursegroups");
foreach (DataRow group in groups)
{
DataRow[] groupclients = group.GetChildRows("groupsgroup_clients");
foreach (DataRow groupclient in groupclients)
{
DataRow client = groupclient.GetParentRow("clientsgroup_clients");
int clientID = (int)client["clientID"];
double clientIncomeSumm = ClientIncomeSumm(clientID);
double clientRealizedSumm = ClientRealizedSumm(clientID);
// Ищем должников учебного центра
double balance = clientRealizedSumm - clientIncomeSumm; if (balance > 0)
summOweToEdCenter += balance; // Должен учебный центр
else if (balance < 0) summOweEdCenter += balance;
}
}
}
txtEdCenterOwe.Text = summOweEdCenter.ToString("C"); txtOweToEdCenter.Text = summOweToEdCenter.ToString("C");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.Source);
}
}
// Удаление временных контролов поиска со страницы 'Приемная' private void RemoveTempFindControl()
{
try
{
ArrayList tempControls = new ArrayList();
foreach (Control control in this.tcManager.TabPages[2].Controls)
if ((control.Tag != null) && (control.Tag.ToString() == "Temp")) tempControls.Add(control);
foreach (object ob in tempControls) this.tcManager.TabPages[2].Controls.Remove((Control)ob);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.Source);
}
}
// Метод возвращает новую или существующую запись таблицы на вкладке 'Приемная'
private DataRow GetTablesRow(DataTable table, int rowIndex, CurrencyManager currManager)
{
try
{
DataRow row = null;
string tableName = table.TableName; bool isNew = true;
isNew = (rowIndex != currManager.Position) ? true : false;
if (isNew)
{
row = table.NewRow(); row["dataID"] = DataID; currManager.Position = rowIndex; return row;
}
else
{
if (tableName == "income")
{
DataView dvIncome = (DataView)currManagerIncome.List; row = dvIncome[rowIndex].Row;
}
else if (tableName == "expenses")
{
DataView dvOut = (DataView)currManagerOut.List; row = dvOut[rowIndex].Row;
}
}
return row;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.Source); return null;
}
}
#endregion
#region Обработчики событий
// Обновление ListView
private void miRefreshListView_Click(object sender, System.EventArgs e)
{
FillListView(treeNodeType, selectedNode);
}
// Отображаем в ListView данные для выделенного элемента в TreeView
private void tvManager_AfterSelect(object sender, System.Windows.Forms.TreeViewEventArgs e)
{
try
{
selectedNode = e.Node;
selectedNodeName = e.Node.Text; // Имя выбранного узла
// Заполняем ListView
if (e.Node == MainTreeNode) // Выбрана вершина TreeView
{
this.FillListView(TreeNodeType.Top, e.Node);
SelectingClient = false; // Нельзя выбирать клиентов this.pnlGroups.Hide();
miNewClient.Enabled = false; miNewGroup.Enabled = false; miNewCourse.Enabled = false; miNewDirection.Enabled = true; cmiStatus.Enabled = false;
treeNodeType = TreeNodeType.Top; lvManager.View = View.List;
}
else if (e.Node is DirectionTreeNode) // Выбрано направление
{
this.FillListView(TreeNodeType.Direction, e.Node);
SelectingClient = false; // Нельзя выбирать клиентов pnlGroups.Hide();
miNewClient.Enabled = false; miNewGroup.Enabled = false; miNewCourse.Enabled = true; miNewDirection.Enabled = false; cmiStatus.Enabled = false;
treeNodeType = TreeNodeType.Direction; lvManager.View = View.List;
}
else if (e.Node is CourseTreeNode) // Выбран курс
{
this.FillListView(TreeNodeType.Course, e.Node);
SelectingClient = false; // Нельзя выбирать клиентов pnlGroups.Show();
miNewClient.Enabled = false; miNewGroup.Enabled = true; miNewCourse.Enabled = false; miNewDirection.Enabled = false; cmiStatus.Enabled = true;
treeNodeType = TreeNodeType.Course; lvManager.View = View.Details;
}
else if (e.Node is GroupTreeNode) // Выбрана группа
{
this.FillListView(TreeNodeType.Group, e.Node);
SelectingClient = true; // Можно выбирать клиентов pnlGroups.Hide();
miNewClient.Enabled = true; miNewGroup.Enabled = false; miNewCourse.Enabled = false; miNewDirection.Enabled = false; cmiStatus.Enabled = false;
treeNodeType = TreeNodeType.Group; lvManager.View = View.List;
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message, ex.Source);
}
}
//-----------------------------------------------------------------------
private void rbClients_CheckedChanged(object sender, System.EventArgs e)
{
RadioButton rb = (RadioButton)sender; this.InsertToDataGrid(mainDataSet.Tables[(string)rb.Tag]);
}
//-----------------------------------------------------------------------
private void miLargeIcons_Click(object sender, System.EventArgs e)
{
lvManager.View = View.LargeIcon;
miLargeIcons.Checked = true; miDetails.Checked = false; miSmallIcon.Checked = false; miList.Checked = false;
}
//-----------------------------------------------------------------------
private void miDetails_Click(object sender, System.EventArgs e)
{
lvManager.View = View.Details;
miLargeIcons.Checked = false; miDetails.Checked = true; miSmallIcon.Checked = false; miList.Checked = false;
}
//-----------------------------------------------------------------------
private void miSmallIcon_Click(object sender, System.EventArgs e)
{
lvManager.View = View.SmallIcon; miLargeIcons.Checked = false;
miDetails.Checked = false; miSmallIcon.Checked = true; miList.Checked = false;
}
//-----------------------------------------------------------------------
private void miList_Click(object sender, System.EventArgs e)
{
lvManager.View = View.List;
miLargeIcons.Checked = false; miDetails.Checked = false; miSmallIcon.Checked = false; miList.Checked = true;
}
// Добавляем нового клиента
private void miNewClient_Click(object sender, System.EventArgs e)
{
this.AddNewClient();
tvManager_AfterSelect(tvManager, new TreeViewEventArgs(selectedNode));
}
// Добавляем новую группу
private void miNewGroup_Click(object sender, System.EventArgs e)
{
this.AddNewGroup();
tvManager_AfterSelect(tvManager, new TreeViewEventArgs(selectedNode));
}
//-----------------------------------------------------------------------
private void cmiHide_Click(object sender, System.EventArgs e)
{
this.Hide();
}
//-----------------------------------------------------------------------
private void cmiShow_Click(object sender, System.EventArgs e)
{
this.Show();
}
//-----------------------------------------------------------------------
private void cmiExit_Click(object sender, System.EventArgs e)
{
this.Close();
}
//-----------------------------------------------------------------------
private void lvManager_Click(object sender, System.EventArgs e)
{
if (lvManager.SelectedItems.Count != 0)
{
selectedItem = (CustomListItem)lvManager.SelectedItems[0]; lvManager.ForeColor = selectedItem.ForeColor;
miCopy.Enabled = true;
}
}
// Главная панель кнопок
private void tbMain_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
{
if (e.Button.Equals(tbnFind))
{
this.SearchClient();
}
if (e.Button.Equals(tbnEmployees))
{
this.OpenEmployees();
}
if (e.Button.Equals(tbnRefreshMainDB))
{
this.UpdateMainData();
}
}
//-----------------------------------------------------------------------
private void miExit_Click(object sender, System.EventArgs e)
{
this.Close();
}
//-----------------------------------------------------------------------
private void cmiFilling_Click(object sender, System.EventArgs e)
{
cmiFilling.Checked = true; cmiStuding.Checked = false; cmiFinished.Checked = false;
ChangeStatus(lvManager.SelectedItems, StatusType.Filling);
}
//-----------------------------------------------------------------------
private void cmiStuding_Click(object sender, System.EventArgs e)
{
cmiFilling.Checked = false; cmiStuding.Checked = true; cmiFinished.Checked = false;
ChangeStatus(lvManager.SelectedItems, StatusType.Learning);
}
//-----------------------------------------------------------------------
private void cmiFinished_Click(object sender, System.EventArgs e)
{
cmiFilling.Checked = false; cmiStuding.Checked = false; cmiFinished.Checked = true;
ChangeStatus(lvManager.SelectedItems, StatusType.Finished);
}
//-----------------------------------------------------------------------
private void btnCalculate_Click(object sender, System.EventArgs e)
{
DataRowView drvData = (DataRowView)currManagerTotal.Current; CalculateTotalPage(drvData.Row);
}
//-----------------------------------------------------------------------
private void lvManager_DoubleClick(object sender, System.EventArgs e)
{
OpenItemInForm(treeNodeType);
}
//-----------------------------------------------------------------------
private void frmManager_Resize(object sender, System.EventArgs e)
{
Form f = (Form)sender;
double x = (double)f.Width / 2; dgOut.Width = (int)x; panel3.AutoScroll = true;
int step = panel10.Width / 3;
Point pt1 = new Point(step, splitter3.Location.Y); splitter3.Location = pt1;
Point pt2 = new Point(2 * step, splitter3.Location.Y); splitter3.Location = pt2;
this.SetWitdhForDataGrids();
}
//-----------------------------------------------------------------------
private void miNewCourse_Click(object sender, System.EventArgs e)
{
this.AddNewCourse();
tvManager_AfterSelect(tvManager, new TreeViewEventArgs(selectedNode));
}
//-----------------------------------------------------------------------
private void miNewDirection_Click(object sender, System.EventArgs e)
{
this.AddNewDirection();
tvManager_AfterSelect(tvManager, new TreeViewEventArgs(selectedNode));
}
//-----------------------------------------------------------------------
private void dgIncome_DoubleClick(object sender, System.EventArgs e)
{
MessageBox.Show("OK");
}
private void miCopy_Click(object sender, System.EventArgs e)
{
try
{
if (SelectingClient)
{
oldGroupNode = selectedNode; miPaste.Enabled = true; miCopy.Enabled = false;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.Source);
}
}