RUS_-_Karejev_-_Razrabotka_Windows-prilozhenij

// В ListView добавляем группы

if (tempTreeNode is CourseTreeNode)

{

// Добавляем в ListView колонки из таблицы groups

for (int i = 0; i < mainDataSet.groups.Columns.Count; i++)

{

ColumnHeader ch = new ColumnHeader();

ch.Text = mainDataSet.groups.Columns[i].Caption; ch.Width = 100;

lvManager.Columns.Add(ch);

}

MainDataSet.courseRow course = (MainDataSet.courseRow)tempTreeNode.Tag; DataRow[] groups = course.GetChildRows("coursegroups");

for(int i = 0; i < groups.Length; i++)

{

// В ListViewItem добавляем массив строк данной записи из табл. groups string[] subitems = new string[groups[i].ItemArray.Length];

for (int j = 0; j < subitems.Length; j++)

{

subitems[j] = groups[i][j].ToString();

}

if ( groups[i]["beginDate"] != null)

{

DateTime beginDate = (DateTime)groups[i]["beginDate"]; subitems[1] = beginDate.Date.ToString("dd MMMM yyyy");

}

if ( groups[i]["endDate"] != null)

{

DateTime endDate = (DateTime)groups[i]["endDate"]; subitems[2] = endDate.Date.ToString("dd MMMM yyyy");

}

if (groups[i]["beginTime"] != null)

{

DateTime beginTime = (DateTime)groups[i]["beginTime"]; subitems[3] = beginTime.ToString("HH:mm");

}

if (groups[i]["endTime"] != null)

{

DateTime endTime = (DateTime)groups[i]["endTime"]; subitems[4] = endTime.ToString("HH:mm");

}

CustomListItem cli = new CustomListItem(subitems, imageIndexListView);

int statusID = (int)groups[i][10];

if (statusID == 1) // Группа набирается

{

cli.ForeColor = Color.Red;

}

else if (statusID == 2) // Группа обучается

{

cli.ForeColor = Color.Green;

}

else if (statusID == 3) // Группа закончила обучение

{

cli.ForeColor = Color.Blue;

}

cli.BindedRow = groups[i]; lvManager.Items.Add(cli); str = "";

}

}

// В ListView добавляем курсы

else if (tempTreeNode is DirectionTreeNode)

{

DataRow[] courses = selectedDirection.GetChildRows("directionscourse"); foreach(DataRow course in courses)

{

CustomListItem cli = new CustomListItem();

str = course.ItemArray[1].ToString();

cli.Text = str; cli.BindedRow = course;

cli.ImageIndex = imageIndexListView;

lvManager.Items.Add(cli);

str = "";

}

}

// В ListView добавляем клиентов

else if (tempTreeNode is GroupTreeNode)

{

for(int i = 0; i < tempTreeNode.Nodes.Count; i++)

{

DataRow client = (DataRow)tempTreeNode.Nodes[i].Tag;

CustomListItem cli = new CustomListItem();

str = client["lname"].ToString() + " " + client["fname"].ToString() + " " + client ["fathName"].ToString();

cli.Text = str;

cli.BindedRow = (DataRow)tempTreeNode.Nodes[i].Tag; cli.ImageIndex = imageIndexListView;

lvManager.Items.Add(cli);

str = "";

}

}

else // Добавляем направления в ListView

{

for(int i = 0; i < mainDataSet.directions.Rows.Count; i++)

{

CustomListItem cli = new CustomListItem(); if(mainDataSet.directions.Rows[i].RowState != DataRowState.Deleted)

{

str = mainDataSet.directions.Rows[i][1].ToString(); cli.Text = str;

cli.BindedRow = mainDataSet.directions.Rows[i]; cli.ImageIndex = imageIndexListView;

lvManager.Items.Add(cli);

}

str = "";

}

}

spCount.Text = "Количество записей: " + lvManager.Items.Count.ToString(); for (int i = 0; i < lvManager.Items.Count; i++)

{

lvManager.Items[i].ForeColor = tempTreeNode.Nodes[i].ForeColor; lvManager.Items[i].ImageIndex = imageIndexListView;

itemColor = lvManager.Items[i].ForeColor; // Цвет текста передвигаемой item

}

}

catch(Exception ex)

{

MessageBox.Show(ex.Message, ex.Source);

}

}

// Перевод выбранных клиентов из одной группы в другую

private void TransferClients(TreeNode oldGroup, TreeNode newGroup)

{

CourseTreeNode newCourse = (CourseTreeNode)newGroup.Parent; // Определяем курс для новой группы CourseTreeNode oldCourse = (CourseTreeNode)oldGroup.Parent; // Определяем курс старой группы

double CoursePrice = (double)newCourse.CoursePrice; // Стоимость нового курса

// Определяем все оплаты клиента

DataRow oldGroupRow = (DataRow)oldGroup.Tag; DataRow newGroupRow = (DataRow)newGroup.Tag;

DataRow[] groupClientsRows = oldGroupRow.GetChildRows("groupsgroup_clients");

DataView dvIncome = new DataView(mainDataSet.income);

int clientID = (int)selectedItem.BindedRow["clientID"]; // ID клиента dvIncome.RowFilter = "(ClientID = " + clientID.ToString() + ") AND (IsRealized <> 1)";

// Определяем сумму клиента на счету double incomeSumm = 0;

double clientSumm = 0; double realizedSumm = 0;

foreach (DataRowView drv in dvIncome)

{

DataRow[] planRows = drv.Row.GetChildRows("incomePlanRealization");

foreach(DataRow planRow in planRows)

if ((bool)planRow["IsRealized"]) // Проверка реализации суммы в PlanRealization

{

realizedSumm += (double)planRow["SummaRealization"];

}

incomeSumm += (double)drv.Row["Summa"];

}

clientSumm = incomeSumm - realizedSumm; frmClientTransfer fct = new frmClientTransfer();

fct.dgClientPayments.DataSource = dvIncome;

fct.txtClientName.Text = selectedItem.BindedRow["lname"].ToString() + " " + selectedItem.BindedRow ["fname"].ToString() + " " + selectedItem.BindedRow["fathName"].ToString();

fct.txtAccountSumm.Text = clientSumm.ToString();

fct.lblOldGroupNumber.Text = oldGroupRow["groupID"].ToString(); fct.lblNewGroupNumber.Text = newGroupRow["groupID"].ToString();

fct.lblOldCourseName.Text = oldCourse.Text;

DataRow courseRow = (DataRow)newCourse.Tag;

double newCoursePrice = Convert.ToDouble(courseRow["priceNumber"]); fct.lblNewCourseName.Text = newCourse.CourseName.ToString(); fct.txtNewCoursePrice.Text = newCoursePrice.ToString();

// Расчет разницы

fct.txtDefferenceCount.Text = Convert.ToString(clientSumm - newCoursePrice);

if (fct.ShowDialog() == DialogResult.OK)

{

lvManager.Items.Add(selectedItem);

DataRow row = mainDataSet.group_clients.NewRow();

row["clientID"] = (int)selectedItem.BindedRow["clientID"]; row["groupID"] = int.Parse(selectedNode.Text); row["IsPaid"] = true;

mainDataSet.group_clients.Rows.Add(row);

this.FillListView(treeNodeType, selectedNode);

}

}

// Поиск клиентов

private void SearchClient()

{

frmSearchClient f = new frmSearchClient(this.mainDataSet);

f.ShowDialog();

}

// Форма сотрудников private void OpenEmployees()

{

frmEmployee f = new frmEmployee(this.mainDataSet);

f.ShowDialog();

}

// Загрузка главной БД

internal void LoadMainDataBase()

{

mainOleDbConnection.ConnectionString = MainConnectionString;

try

{

mainDataSet.EnforceConstraints = false;

directionsOleDbDataAdapter.Fill(mainDataSet.directions);

coursesOleDbDataAdapter.Fill(mainDataSet.course);

employeesOleDbDataAdapter.Fill(mainDataSet.employees);

groupStatusOleDbDataAdapter.Fill(mainDataSet.GroupStatus);

groupsOleDbDataAdapter.Fill(mainDataSet.groups);

clientsOleDbDataAdapter.Fill(mainDataSet.clients); groupClientsOleDbDataAdapter.Fill(mainDataSet.group_clients); realizedTableOleDbDataAdapter.Fill(mainDataSet.RealizedTable);

dataOleDbDataAdapter.Fill(mainDataSet.data); paymentTypeOleDbDataAdapter.Fill(mainDataSet.payment_type); incomeOleDbDataAdapter.Fill(mainDataSet.income); planRealizationOleDbDataAdapter.Fill(mainDataSet.PlanRealization); outOleDbDataAdapter.Fill(mainDataSet.expenses);

mainDataSet.EnforceConstraints = true;

foreach (DataRow dr in mainDataSet.directions.Rows)

{

ListItem directionItem = new ListItem(dr); directionItem.Text = dr[1].ToString(); cmbDirections.Items.Add(directionItem.Text); cmbFilteringDirection.Items.Add(directionItem.Text);

}

foreach (DataRow dr in mainDataSet.GroupStatus.Rows)

{

ListItem groupStatusItem = new ListItem(dr); groupStatusItem.Text = dr[1].ToString(); cmbGroupStatus.Items.Add(groupStatusItem.Text);

}

}

catch(Exception ex)

{

MessageBox.Show(ex.Message, ex.Source); System.Environment.Exit(1);

}

}

// Обновление главной БД private void UpdateMainData()

{

mainOleDbConnection.ConnectionString = MainConnectionString;

try

{

MainDataSet ds = (MainDataSet)mainDataSet.GetChanges(); if (ds != null)

{

ds.EnforceConstraints = false;

dataOleDbDataAdapter.Update(ds);

paymentTypeOleDbDataAdapter.Update(ds);

directionsOleDbDataAdapter.Update(ds);

coursesOleDbDataAdapter.Update(ds);

employeesOleDbDataAdapter.Update(ds.employees);

clientsOleDbDataAdapter.Update(ds);

groupStatusOleDbDataAdapter.Update(ds);

groupsOleDbDataAdapter.Update(ds);

groupClientsOleDbDataAdapter.Update(ds);

realizedTableOleDbDataAdapter.Update(ds);

incomeOleDbDataAdapter.Update(ds);

planRealizationOleDbDataAdapter.Update(ds);

outOleDbDataAdapter.Update(ds);

ds.EnforceConstraints = true; mainDataSet.AcceptChanges();

}

}

catch(SqlException ex)

{

StringBuilder msg = new StringBuilder(); foreach(SqlError err in ex.Errors)

{

msg.AppendFormat("{0}\n",err.Message);

}

MessageBox.Show(msg.ToString(), ex.Source);

}

catch(Exception ex)

{

MessageBox.Show(ex.Message, ex.Source);

}

}

// Изменение статуса группы из проводника

private void ChangeStatus(ListView.SelectedListViewItemCollection items, StatusType status)

{

int statusID = 0;

Color color = Color.Black; switch (status)

{

//Группа набирается case StatusType.Filling:

statusID = 1; color = Color.Red; break;

//Группа обучается case StatusType.Learning:

statusID = 2;

color = Color.Green; break;

//Группа закончила обучение case StatusType.Finished:

statusID = 3;

color = Color.Blue; break;

}

foreach(ListViewItem lvi in items)

{

CustomListItem item = (CustomListItem)lvi;

item.BindedRow["StatusID"] = statusID; item.ForeColor = color;

selectedNode.Nodes[item.Index].ForeColor = color;

}

}

// Итоговые расчеты на текущую запись в таблице data private void CalculateTotalPage(DataRow currentTotalRow)

{

double resultIncome = 0; double resultOut = 0; double balance = 0;

int dataID = (int)currentTotalRow[0];

DataRow[] incomeRows = currentTotalRow.GetChildRows("dataincome");

DataRow[] outRows = currentTotalRow.GetChildRows("dataexpenses");

// Определение прихода

foreach (DataRow dr in incomeRows)

{

if (dr[3] == null) continue;

resultIncome += (double)dr[3];

}

txtResultIncome.Text = resultIncome.ToString("c");

// Определение расхода

foreach (DataRow dr in outRows)

{

if (dr[3] == null) continue;

resultOut += (double)dr[3];

}

txtResultOut.Text = resultOut.ToString("c");

// Баланс

balance = resultIncome - resultOut; txtBalance.Text = balance.ToString("c");

// Итоговые расчеты

double yesterdaySumm = Convert.ToDouble(currentTotalRow[2]); txtYesterdaySumm.Text = yesterdaySumm.ToString("c");

double total = yesterdaySumm + balance; txtResultCount.Text = total.ToString("c");

currentTotalRow["incomeToday"] = (double)resultIncome; // Приход на сегодня currentTotalRow["expanseToday"] = (double)resultOut; // Расход на сегодня

currentTotalRow["amountToday"] = yesterdaySumm + balance; // Итог на сегодня. К сумме, полученной вчера,

прибавляем баланс на сегодня

}

// Открываем заголовок item в ListView

private void OpenItemInForm(TreeNodeType treeNodeType)

{

// Выбранный элемент в ListView

CustomListItem cli = (CustomListItem)lvManager.SelectedItems[0];

try

{

switch (treeNodeType)

{

case TreeNodeType.Group:

frmClient client = new frmClient(cli.BindedRow, this.mainDataSet);

int clientID = (int)cli.BindedRow[0];

DataView dvClientGroups = new DataView(mainDataSet.group_clients); dvClientGroups.RowFilter = "clientID = " + clientID.ToString();

DataGridItem[] items = new DataGridItem[dvClientGroups.Count];

int i = 0;

foreach(DataRowView drv in dvClientGroups)

{

DataGridItem dgi = new DataGridItem(drv.Row[1].ToString()); items[i++]= dgi;

}

client.dgClientGroups.SetDataBinding(items, null);

client.Text += selectedNode.Text; client.ShowDialog();

break;

case TreeNodeType.Course:

frmGroup group = new frmGroup(mainDataSet, cli.BindedRow);

group.Text += selectedNodeName; group.ShowDialog();

break;

case TreeNodeType.Direction:

frmCourse course = new frmCourse(cli.BindedRow);

course.Text += selectedNodeName; course.ShowDialog() ;

break;

case TreeNodeType.Top:

frmDirection direction = new frmDirection(cli.BindedRow);

direction.ShowDialog() ; break;

default: return;

}

}

catch (Exception ex)

{

MessageBox.Show(ex.Message, ex.Source);

}

}

// Добавляем нового клиента со страницы 'Приемная' private void AddNewClientWaitingRoom()

{

frmClient f = new frmClient(this.mainDataSet); DataRow newClientRow = mainDataSet.clients.NewRow(); mainDataSet.clients.Rows.Add(newClientRow);

f.ClientID = (int)newClientRow["clientID"]; f.lblClientID.Text = "Новый клиент";

int groupRowID = dgGroups.CurrentRowIndex; DataView dvGroups = (DataView)dgGroups.DataSource; DataRow group = dvGroups[groupRowID].Row;

f.Text += group["groupID"].ToString();

f.GroupID = (int)group["groupID"]; f.MainForm = this;

if (f.ShowDialog() == DialogResult.OK)

{

try

{

//Добавляем данные в табл. clients newClientRow["fname"] = f.txtFirstName.Text; newClientRow["lname"] = f.txtLastName.Text; newClientRow["fathName"] = f.txtFatherName.Text; newClientRow["linkData"] = f.txtPhones.Text; newClientRow["recorddate"] = f.dtpRecordDate.Value; newClientRow["note"] = f.txtNotes.Text; newClientRow["isRinged"] = false;

//Добавляем данные в табл. Group_Clients

DataRow newGroupClientRow = mainDataSet.group_clients.NewRow();

int clientID = (int)newClientRow["clientID"];

newGroupClientRow["clientID"] = clientID; newGroupClientRow["groupID"] = (int)group["groupID"]; mainDataSet.group_clients.Rows.Add(newGroupClientRow);

}

catch(Exception ex)

{

MessageBox.Show(ex.Message, ex.Source);

}

dgGroups_Click(this.dgGroups, new EventArgs());

}

}

//Устанавливаем размеры окон — используется при изменении размера окон private void SetWitdhForDataGrids()

{

dgCourses.Size = new Size(this.Width / 4, dgCourses.Size.Height); panel17.Size = new Size(dgGroups.Width, dgCourses.Height / 2); panel16.Size = new Size(this.Width / 2, panel16.Height);

}

//Устанавливаем дизайн элементов DataGrid.

private void DesigneDataGrids()

{

try

{

// Дизайн таблицы data

DataGridTableStyle totalTableStyle1 = new DataGridTableStyle(); totalTableStyle1.MappingName = "data";

DataGridTextBoxColumn dataIDStyle1 = new DataGridTextBoxColumn(); dataIDStyle1.MappingName = "dataID";

dataIDStyle1.Width = 50; dataIDStyle1.HeaderText = "ID";

DataGridTextBoxColumn currentDateStyle1 = new DataGridTextBoxColumn(); currentDateStyle1.MappingName = "currentDate"; currentDateStyle1.Width = 120;

currentDateStyle1.HeaderText = "Текущая дата";

DataGridTextBoxColumn amountYesterdayStyle1 = new DataGridTextBoxColumn(); amountYesterdayStyle1.MappingName = "amountYesterday"; amountYesterdayStyle1.Width = 150;

amountYesterdayStyle1.HeaderText = "Всего вчера";

DataGridTextBoxColumn amountTodayStyle1 = new DataGridTextBoxColumn(); amountTodayStyle1.MappingName = "amountToday"; amountTodayStyle1.Width = 150;

amountTodayStyle1.HeaderText = "Всего Сегодня";

DataGridTextBoxColumn incomeTodayStyle1 = new DataGridTextBoxColumn(); incomeTodayStyle1.MappingName = "incomeToday"; incomeTodayStyle1.Width = 150;

incomeTodayStyle1.HeaderText = "Приход сегодня";

DataGridTextBoxColumn expanseTodayStyle1 = new DataGridTextBoxColumn(); expanseTodayStyle1.MappingName = "expanseToday"; expanseTodayStyle1.Width = 150;

expanseTodayStyle1.HeaderText = "Расход сегодня";

DataGridTextBoxColumn totalNotesStyle1 = new DataGridTextBoxColumn(); totalNotesStyle1.MappingName = "note";

totalNotesStyle1.Width = 300; totalNotesStyle1.HeaderText = "Заметки";

totalTableStyle1.GridColumnStyles.AddRange(new DataGridTextBoxColumn[] { dataIDStyle1, currentDateStyle1, amountYesterdayStyle1, amountTodayStyle1, incomeTodayStyle1, expanseTodayStyle1, totalNotesStyle1});

dgMainTable.TableStyles.Add(totalTableStyle1);

// Дизайн dgCourses

DataGridTableStyle coursesTableStyle = new DataGridTableStyle(); coursesTableStyle.MappingName = "course";

DataGridTextBoxColumn courseNameStyle = new DataGridTextBoxColumn(); courseNameStyle.MappingName = "courseName";

courseNameStyle.Width = 225; courseNameStyle.HeaderText = "Название курса";

DataGridTextBoxColumn coursePriceStyle = new DataGridTextBoxColumn(); coursePriceStyle.MappingName = "priceNumber";

coursePriceStyle.Width = 100; coursePriceStyle.Format = "#.0"; coursePriceStyle.HeaderText = "Цена курса";

coursesTableStyle.GridColumnStyles.AddRange(new DataGridTextBoxColumn[] { courseNameStyle, coursePriceStyle});

dgCourses.TableStyles.Add(coursesTableStyle);

// Дизайн dgGroups

DataGridTableStyle groupsTableStyle = new DataGridTableStyle(); groupsTableStyle.MappingName = "groups";

DataGridTextBoxColumn groupIDStyle = new DataGridTextBoxColumn(); groupIDStyle.MappingName = "groupID";

groupIDStyle.Width = 50; groupIDStyle.HeaderText = "Номер";

DataGridTextBoxColumn beginDateStyle = new DataGridTextBoxColumn(); beginDateStyle.MappingName = "beginDate";

beginDateStyle.Width = 110; beginDateStyle.Format = "dd MMMM yyyy"; beginDateStyle.HeaderText = "Дата начала";

DataGridTextBoxColumn endDateStyle = new DataGridTextBoxColumn(); endDateStyle.MappingName = "endDate";

endDateStyle.Width = 110; endDateStyle.Format = "dd MMMM yyyy"; endDateStyle.HeaderText = "Дата окончания";

DataGridTextBoxColumn beginTimeStyle = new DataGridTextBoxColumn(); beginTimeStyle.MappingName = "beginTime";

beginTimeStyle.Width = 110;

beginTimeStyle.Format = "HH:mm"; beginTimeStyle.HeaderText = "Время начала";

DataGridTextBoxColumn endTimeStyle = new DataGridTextBoxColumn(); endTimeStyle.MappingName = "endTime";

endTimeStyle.Width = 110; endTimeStyle.Format = "HH:mm"; endTimeStyle.HeaderText = "Время окончания";

DataGridTextBoxColumn classNumberStyle = new DataGridTextBoxColumn(); classNumberStyle.MappingName = "classNumber";

classNumberStyle.Width = 110; classNumberStyle.HeaderText = "Номер класса";

groupsTableStyle.GridColumnStyles.AddRange(new DataGridTextBoxColumn[] { beginTimeStyle, endTimeStyle, classNumberStyle, beginDateStyle, endDateStyle, groupIDStyle});

dgGroups.TableStyles.Add(groupsTableStyle);

// Дизайн dgClients

DataGridTableStyle clientsTableStyle = new DataGridTableStyle(); clientsTableStyle.MappingName = "clients";

DataGridTextBoxColumn clientIDStyle = new DataGridTextBoxColumn(); clientIDStyle.MappingName = "clientID";

clientIDStyle.ReadOnly = true; clientIDStyle.Width = 50; clientIDStyle.HeaderText = "Номер";

DataGridTextBoxColumn firstNameStyle = new DataGridTextBoxColumn(); firstNameStyle.MappingName = "fname";

firstNameStyle.Width = 130; firstNameStyle.HeaderText = "Имя";

DataGridTextBoxColumn lastNameStyle = new DataGridTextBoxColumn(); lastNameStyle.MappingName = "lname";

lastNameStyle.Width = 130; lastNameStyle.HeaderText = "Фамилия";

DataGridTextBoxColumn fatherNameStyle = new DataGridTextBoxColumn(); fatherNameStyle.MappingName = "fathName";

fatherNameStyle.Width = 130; fatherNameStyle.HeaderText = "Отчество";

DataGridTextBoxColumn clientPhoneStyle = new DataGridTextBoxColumn(); clientPhoneStyle.MappingName = "linkData";

clientPhoneStyle.Width = 200; clientPhoneStyle.HeaderText = "Контакты";

DataGridBoolColumn clientIsRingedStyle = new DataGridBoolColumn(); clientIsRingedStyle.MappingName = "isRinged"; clientIsRingedStyle.Width = 100;

clientIsRingedStyle.AllowNull = false; clientIsRingedStyle.HeaderText = "Дозвонились";

clientsTableStyle.GridColumnStyles.AddRange(new DataGridColumnStyle[] { clientIDStyle, lastNameStyle, firstNameStyle,

fatherNameStyle,

clientPhoneStyle,

clientIsRingedStyle});

dgClients.TableStyles.Add(clientsTableStyle);

// Дизайн dgIncome

DataGridTableStyle incomeTableStyle = new DataGridTableStyle(); incomeTableStyle.MappingName = "income";

DataGridTextBoxColumn incomeClientIDStyle = new DataGridTextBoxColumn(); incomeClientIDStyle.MappingName = "clientID";

incomeClientIDStyle.Width = 45; incomeClientIDStyle.HeaderText = "ID клиента"; incomeClientIDStyle.Alignment = HorizontalAlignment.Center;

DataGridTextBoxColumn incomeSummaStyle = new DataGridTextBoxColumn(); incomeSummaStyle.MappingName = "summa";

incomeSummaStyle.Width = 100; incomeSummaStyle.Format = "#.0"; incomeSummaStyle.HeaderText = "Сумма";

DataGridTextBoxColumn incomePaymentTypeIDStyle = new DataGridTextBoxColumn(); incomePaymentTypeIDStyle.MappingName = "payment_typeID"; incomePaymentTypeIDStyle.Width = 45;

incomePaymentTypeIDStyle.HeaderText = "Код вида оплаты";

DataGridTextBoxColumn incomeNoteStyle = new DataGridTextBoxColumn(); incomeNoteStyle.MappingName = "note";

incomeNoteStyle.Width = 300; incomeNoteStyle.HeaderText = "Заметки";

DataGridBoolColumn realizedStyle = new DataGridBoolColumn(); realizedStyle.MappingName = "IsRealized"; realizedStyle.Width = 100;

realizedStyle.HeaderText = "Реализовано";

DataGridTextBoxColumn incomeDataIDStyle = new DataGridTextBoxColumn(); incomeDataIDStyle.MappingName = "dataID";

incomeDataIDStyle.Width = 45; incomeDataIDStyle.HeaderText = "ID data"; incomeDataIDStyle.Alignment = HorizontalAlignment.Center;

incomeTableStyle.GridColumnStyles.AddRange(new DataGridColumnStyle[] { incomeSummaStyle, incomePaymentTypeIDStyle, incomeNoteStyle, incomeClientIDStyle, incomeDataIDStyle});

incomeTableStyle.HeaderBackColor = dgIncome.HeaderBackColor; incomeTableStyle.BackColor = dgIncome.BackColor; incomeTableStyle.ForeColor = dgIncome.ForeColor; incomeTableStyle.GridLineColor = dgIncome.GridLineColor; incomeTableStyle.HeaderForeColor = dgIncome.HeaderForeColor; incomeTableStyle.SelectionBackColor = dgIncome.SelectionBackColor; incomeTableStyle.SelectionForeColor = dgIncome.SelectionForeColor; dgIncome.TableStyles.Add(incomeTableStyle);

// Дизайн dgOut

DataGridTableStyle expensesTableStyle = new DataGridTableStyle(); expensesTableStyle.MappingName = "expenses";

DataGridTextBoxColumn expensesClientIDStyle = new DataGridTextBoxColumn(); expensesClientIDStyle.MappingName = "clientID"; expensesClientIDStyle.Width = 45;

expensesClientIDStyle.HeaderText = "ID клиента";

DataGridTextBoxColumn expensesEmployeeIDStyle = new DataGridTextBoxColumn(); expensesEmployeeIDStyle.MappingName = "employeeID"; expensesEmployeeIDStyle.Width = 45;

expensesEmployeeIDStyle.HeaderText = "ID сотрудника";

DataGridTextBoxColumn expensesSummaStyle = new DataGridTextBoxColumn(); expensesSummaStyle.MappingName = "summa";

expensesSummaStyle.Width = 100; expensesSummaStyle.Format = "#.0"; expensesSummaStyle.HeaderText = "Сумма";

DataGridTextBoxColumn expensesPaymentTypeIDStyle = new DataGridTextBoxColumn(); expensesPaymentTypeIDStyle.MappingName = "payment_typeID"; expensesPaymentTypeIDStyle.Width = 45;

expensesPaymentTypeIDStyle.HeaderText = "Код вида оплаты";

DataGridTextBoxColumn expensesNoteStyle = new DataGridTextBoxColumn(); expensesNoteStyle.MappingName = "note";

expensesNoteStyle.Width = 300; expensesNoteStyle.HeaderText = "Заметки";

expensesTableStyle.GridColumnStyles.AddRange(new DataGridColumnStyle[] { expensesSummaStyle, expensesPaymentTypeIDStyle, expensesNoteStyle, expensesClientIDStyle, expensesEmployeeIDStyle});

expensesTableStyle.HeaderBackColor = dgOut.HeaderBackColor; expensesTableStyle.BackColor = dgOut.BackColor; expensesTableStyle.ForeColor = dgOut.ForeColor; expensesTableStyle.GridLineColor = dgOut.GridLineColor; expensesTableStyle.HeaderForeColor = dgOut.HeaderForeColor; expensesTableStyle.SelectionBackColor = dgOut.SelectionBackColor; expensesTableStyle.SelectionForeColor = dgOut.SelectionForeColor; dgOut.TableStyles.Add(expensesTableStyle);

//Дизайн dgWorkTable

//Стиль таблицы directions на странице "Основные таблицы" DataGridTableStyle directionsTableStyle = new DataGridTableStyle(); directionsTableStyle.MappingName = "directions";

DataGridTextBoxColumn directionIDStyle = new DataGridTextBoxColumn(); directionIDStyle.MappingName = "directionID";

directionIDStyle.Width = 100; directionIDStyle.HeaderText = "Номер направления";

DataGridTextBoxColumn directionNameStyle = new DataGridTextBoxColumn(); directionNameStyle.MappingName = "directName";

directionNameStyle.Width = 100; directionNameStyle.HeaderText = "Наименование";

DataGridTextBoxColumn directionNotesStyle = new DataGridTextBoxColumn(); directionNotesStyle.MappingName = "note";

directionNotesStyle.Width = 100; directionNotesStyle.HeaderText = "Заметки";

directionsTableStyle.GridColumnStyles.AddRange(new DataGridTextBoxColumn[] { directionIDStyle, directionNameStyle, directionNotesStyle});

dgWorkTable.TableStyles.Add(directionsTableStyle);

// Стиль таблицы course на странице "Основные таблицы"

DataGridTableStyle dgWorkTableСoursesTableStyle = new DataGridTableStyle(); dgWorkTableСoursesTableStyle.MappingName = "course";

DataGridTextBoxColumn dgWorkTableСourseNameStyle = new DataGridTextBoxColumn(); dgWorkTableСourseNameStyle.MappingName = "courseName"; dgWorkTableСourseNameStyle.Width = 150;

dgWorkTableСourseNameStyle.HeaderText = "Название курса";

DataGridTextBoxColumn dgWorkTableСoursePriceStyle = new DataGridTextBoxColumn(); dgWorkTableСoursePriceStyle.MappingName = "priceNumber"; dgWorkTableСoursePriceStyle.Width = 100;

dgWorkTableСoursePriceStyle.Format = "#.0"; dgWorkTableСoursePriceStyle.HeaderText = "Цена курса";

DataGridTextBoxColumn dgWorkTableDirectionIDStyle = new DataGridTextBoxColumn(); dgWorkTableDirectionIDStyle.MappingName = "directionID"; dgWorkTableDirectionIDStyle.Width = 50;

dgWorkTableDirectionIDStyle.HeaderText = "Номер направления";

DataGridTextBoxColumn dgWorkTableNoteStyle = new DataGridTextBoxColumn(); dgWorkTableNoteStyle.MappingName = "note";

dgWorkTableNoteStyle.Width = 150; dgWorkTableNoteStyle.HeaderText = "Заметки";

dgWorkTableСoursesTableStyle.GridColumnStyles.AddRange(new DataGridTextBoxColumn[] { dgWorkTableСourseNameStyle, dgWorkTableСoursePriceStyle, dgWorkTableDirectionIDStyle, dgWorkTableNoteStyle});

dgWorkTable.TableStyles.Add(dgWorkTableСoursesTableStyle);

// Стиль таблицы data на странице "Основные таблицы" DataGridTableStyle totalTableStyle = new DataGridTableStyle(); totalTableStyle.MappingName = "data";

DataGridTextBoxColumn totalIDStyle = new DataGridTextBoxColumn(); totalIDStyle.MappingName = "directionID";

totalIDStyle.Width = 100; totalIDStyle.HeaderText = "Номер";

DataGridTextBoxColumn currentDateStyle = new DataGridTextBoxColumn(); currentDateStyle.MappingName = "currentDate";

currentDateStyle.Width = 100; currentDateStyle.Format = "dd MMMM yyyy"; currentDateStyle.HeaderText = "Текущая дата";

DataGridTextBoxColumn amountYesterdayStyle = new DataGridTextBoxColumn(); amountYesterdayStyle.MappingName = "amountYesterday"; amountYesterdayStyle.Width = 100;

amountYesterdayStyle.HeaderText = "Всего вчера";

DataGridTextBoxColumn amountTodayStyle = new DataGridTextBoxColumn(); amountTodayStyle.MappingName = "amountToday";

amountTodayStyle.Width = 100; amountTodayStyle.HeaderText = "Всего cегодня";

DataGridTextBoxColumn incomeTodayStyle = new DataGridTextBoxColumn(); incomeTodayStyle.MappingName = "incomeToday";

incomeTodayStyle.Width = 100; incomeTodayStyle.HeaderText = "Приход сегодня";

DataGridTextBoxColumn expanseTodayStyle = new DataGridTextBoxColumn(); expanseTodayStyle.MappingName = "expanseToday"; expanseTodayStyle.Width = 100;

expanseTodayStyle.HeaderText = "Расход сегодня";

DataGridTextBoxColumn totalNoteStyle = new DataGridTextBoxColumn(); totalNoteStyle.MappingName = "note";

totalNoteStyle.Width = 100; totalNoteStyle.HeaderText = "Заметки";