116
ПРИЛОЖЕНИЕ 1 Листинг программного кода
usingSystem;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Threading.Tasks;
usingSystem.Windows.Forms;
namespaceWorkflowTehtorg
{
publicpartialclassForm1 : Form
{
public Form1()
{
InitializeComponent();
DBWorkflow DB = newDBWorkflow();
}
privatevoid button1_Click(object sender, EventArgs e)
{
DBWorkflow DB = newDBWorkflow();
var login = DB.Administrators.ToList();
foreach (var email in login)
{
if (email.email==textBox1.Text&&email.Password==textBox2.Text)
{
GlobalVars.KeyAvtor = 1;
GlobalVars.AdminID = email.AdministratorId;
}
}
if (GlobalVars.KeyAvtor == 1)
{
Form2 f2 = newForm2();
f2.Show();
//MessageBox.Show("Admin ID = " + GlobalVars.AdminID);
}
elseMessageBox.Show("Нет такого пользователя");
}
privatevoid checkBox1_CheckedChanged(object sender, EventArgs e)
{
if (checkBox1.Checked == true)
117
{
textBox2.UseSystemPasswordChar = true;
}
else
{
textBox2.UseSystemPasswordChar = false;
}
}
}
}
using System;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Threading.Tasks;
usingSystem.Windows.Forms;
namespaceWorkflowTehtorg
{
publicpartialclassForm2 : Form
{
public Form2()
{
InitializeComponent();
DBWorkflow DB = newDBWorkflow();
varselectAdmin = from user inDB.Administrators
whereuser.AdministratorId == GlobalVars.AdminID
selectuser.Name;
label3.Text = "Вывошликакпользователь: " + selectAdmin.First();
}
privatevoid timer1_Tick(object sender, EventArgs e)
{
label1.Text = DateTime.Now.ToString("T");
label2.Text = DateTime.Now.ToString("dd MMMM yyyy");
if(label3.Left > -label3.Width)
{
label3.Left -= 15;
}
else
{
label3.Left = panel1.Width;
}
}
privatevoid Form2_Load(object sender, EventArgs e)
{
timer1.Start();
}
privatevoid button1_Click(object sender, EventArgs e)
{
Form3 f3 = newForm3();
f3.Show();
}
118
privatevoid button2_Click(object sender, EventArgs e)
{
Form4 f4 = newForm4();
f4.Show();
}
privatevoid button3_Click(object sender, EventArgs e)
{
Form5 f5 = newForm5();
f5.Show();
}
privatevoid button4_Click(object sender, EventArgs e)
{
Form6 f6 = newForm6();
f6.Show();
}
}
}
using System;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Threading.Tasks;
usingSystem.Windows.Forms;
usingMicrosoft.Office.Interop.Excel;
namespaceWorkflowTehtorg
{
publicpartialclassForm3 : Form
{
DBWorkflow DB = newDBWorkflow();
public Form3()
{
InitializeComponent();
//Топсотрудники
varselectSellerOrd = from s inDB.Sellers
join o inDB.Ordersons.SellerIdequalso.SellerId
whereo.DateOrders.Value.Year == DateTime.Today.Year&&o.DateOrders.Value.Month ==
DateTime.Today.Month
selectnew {
Код_продавца =s.SellerId,
Имя = s.Name,
Фамилия = s.Surname,
Ставка =s.Salary,
Дата_заказа = o.DateOrders,
Сумма_заказа = o.OrderPrice,
Код_заказа =o.OrderId };
varplayersPerTeam = from admin inselectSellerOrd
group admin byadmin.Код_продавцаintoadminGroup
selectnew
{
Код_продовца = adminGroup.Key,
119
Количество_заказов = adminGroup.Count(),
};
/*//vardist=playersPerTeam.Distinct();*/
var sort = fromsortyinplayersPerTeam
//join o in selectSellerOrd on sorty.Код_продовца equals o.Код_продавца
orderbysorty.Количество_заказовdescending
selectnew {
Код_продавца = sorty.Код_продовца,
Количество_заказов = sorty.Количество_заказов,
};
var p = sort.ToList();
int p1 = p[0].Код_продавца;
intp2 = p[2].Код_продавца;
intp3 = p[3].Код_продавца;
intp4 = p[4].Код_продавца;
intp5 = p[5].Код_продавца;
varselectSeller = from s inDB.Sellers
join o inDB.Ordersons.SellerIdequalso.SellerId
wheres.SellerId==p1 || s.SellerId==p2 || s.SellerId == p3 || s.SellerId == p4 ||
s.SellerId == p5
selectnew
{
Имя = s.Name,
Фамилия = s.Surname,
Ставка = s.Salary,
};
vardisti = selectSeller.Distinct();
var pr1Q = disti.Take(300).ToList();
dataGridView1.DataSource = pr1Q;
}
privatevoid button1_Click(object sender, EventArgs e)//Суммазаказовзамесяц
{
varslectSumSelers = (
from s inDB.Sellers
join o inDB.Ordersons.SellerIdequalso.SellerId
whereo.DateOrders.Value.Year == DateTime.Today.Year&&o.DateOrders.Value.Month ==
DateTime.Today.Month
groupsbynew
{
s.SellerId,
s.Name,
s.Surname,
o.DateOrders,
o.OrderPrice
} intoselerGroup
selectnew
{
Код_продавца = selerGroup.Key.SellerId,
120
Имя = selerGroup.Key.Name,
Фамилия = selerGroup.Key.Surname,
Дата_заказа = selerGroup.Key.DateOrders,
Сумма = selerGroup.Key.OrderPrice
}
);
var pr1Q1 = slectSumSelers.Take(300).ToList();
dataGridView1.DataSource = pr1Q1;
}
privatevoid button6_Click(object sender, EventArgs e)//excel
{
try
{
Microsoft.Office.Interop.Excel.Application excel = newMi-
crosoft.Office.Interop.Excel.Application();
excel.Visible = true;
Microsoft.Office.Interop.Excel.Workbook workbook = ex-
cel.Workbooks.Add(System.Reflection.Missing.Value);
Microsoft.Office.Interop.Excel.Worksheet sheet1 = (Mi-
crosoft.Office.Interop.Excel.Worksheet)workbook.Sheets[1];
intStartCol = 1;
intStartRow = 1;
int j = 0, i = 0;
//Write Headers
for (j = 0; j <dataGridView1.Columns.Count; j++)
{
Microsoft.Office.Interop.Excel.RangemyRange = (Mi-
crosoft.Office.Interop.Excel.Range)sheet1.Cells[StartRow, StartCol + j];
myRange.Value2 = dataGridView1.Columns[j].HeaderText;
}
StartRow++;
//Write datagridview content
for (i = 0; i<dataGridView1.Rows.Count; i++)
{
for (j = 0; j <dataGridView1.Columns.Count; j++)
{
try
{
Microsoft.Office.Interop.Excel.RangemyRange = (Mi-
crosoft.Office.Interop.Excel.Range)sheet1.Cells[StartRow + i, StartCol + j];
myRange.Value2 = dataGridView1[j, i].Value == null ? "" :
dataGridView1[j, i].Value;
}
catch
{
;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
privatevoid button2_Click(object sender, EventArgs e)//Количествозаказовзамесяц
121
{
varselectSellerOrd = from s inDB.Sellers
join o inDB.Ordersons.SellerIdequalso.SellerId
whereo.DateOrders.Value.Year == DateTime.Today.Year&&o.DateOrders.Value.Month ==
DateTime.Today.Month
selectnew
{
Код_продавца = s.SellerId,
Имя = s.Name,
Фамилия = s.Surname,
Ставка = s.Salary,
Дата_заказа = o.DateOrders,
Код_заказа = o.OrderId
};
varplayersPerTeam = from admin inselectSellerOrd
group admin byadmin.ИмяintoadminGroup
selectnew
{
Имя_продавца = adminGroup.Key,
Количество_заказов = adminGroup.Count(),
};
var pr1Q1 = playersPerTeam.Take(300).ToList();
dataGridView1.DataSource = pr1Q1;
}
privatevoid button5_Click(object sender, EventArgs e)//новыеработники в этоммесяце
{
varselectSelers = from s inDB.Sellers
wheres.HiringDate.Value.Year == DateTime.Today.Year&&s.HiringDate.Value.Month ==
DateTime.Today.Month
selectnew
{
Имя = s.HiringDate,
Отчество = s.Patronymic,
Номер_телефона = s.Phone,
//Ставка = s.Salary
};
var pr1Q1 = selectSelers.Take(300).ToList();
dataGridView1.DataSource = pr1Q1;
}
privatevoid button4_Click(object sender, EventArgs e)//Ставкаработника
{
varselectSelers = from s inDB.Sellers
selectnew
{
Имя = s.HiringDate,
Отчество = s.Patronymic,
Номер_телефона = s.Phone,
Ставка = s.Salary
};
var pr1Q1 = selectSelers.Take(300).ToList();
dataGridView1.DataSource = pr1Q1;
}
privatevoid button3_Click(object sender, EventArgs e)//ставка и процент
{
varselectSelers = from s inDB.Sellers
selectnew
{
122
Имя = s.HiringDate,
Отчество = s.Patronymic,
Номер_телефона = s.Phone,
Ставка = s.Salary+(s.Salary*(decimal)0.1)
};
var pr1Q1 = selectSelers.Take(300).ToList();
dataGridView1.DataSource = pr1Q1;
}
}
}
usingMicrosoft.Office.Interop.Word;
using System;
usingSystem.Collections.Generic;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
usingSystem.Linq;
usingSystem.Text;
usingSystem.Threading.Tasks;
usingSystem.Windows.Forms;
using Word = Microsoft.Office.Interop.Word;
usingSystem.Reflection;
namespaceWorkflowTehtorg
{
publicpartialclassForm4 : Form
{
DBWorkflow DB = newDBWorkflow();
public Form4()
{
InitializeComponent();
}
privatevoid Form4_Load(object sender, EventArgs e)
{
varsumCash= DB.Orders.Where(a=>a.DateOrders.Value.Year ==
DateTime.Today.Year&&a.DateOrders.Value.Month == DateTime.Today.Month).Sum(a
=>a.OrderPrice );//замесяц
//MessageBox.Show(sumCash.ToString());
label6.Text = (sumCash.Value * (decimal)0.2).ToString();
varsumSalary = DB.Sellers.Sum(a =>a.Salary);
label7.Text = (sumSalary).ToString();
label9.Text = (sumCash - (decimal)(float.Parse(label6.Text) +
float.Parse(label7.Text))).ToString();
label4.Text = sumCash.ToString();
varsumCashYear = DB.Orders.Where(a =>a.DateOrders.Value.Year == DateTime.Today.Year
).Sum(a =>a.OrderPrice);//Загод
label5.Text = sumCashYear.ToString();
}
privatevoid button6_Click(object sender, EventArgs e)
{
try
{
Microsoft.Office.Interop.Excel.Application excel = newMi-
crosoft.Office.Interop.Excel.Application();
123
excel.Visible = true;
Microsoft.Office.Interop.Excel.Workbook workbook = ex-
cel.Workbooks.Add(System.Reflection.Missing.Value);
Microsoft.Office.Interop.Excel.Worksheet sheet1 = (Mi-
crosoft.Office.Interop.Excel.Worksheet)workbook.Sheets[1];
//Write Headers
Microsoft.Office.Interop.Excel.RangemyRange = (Mi-
crosoft.Office.Interop.Excel.Range)sheet1.Cells[1, 1];
myRange.Value2 = label1.Text;
myRange = (Microsoft.Office.Interop.Excel.Range)sheet1.Cells[1, 2];
myRange.Value2 = label8.Text;
myRange = (Microsoft.Office.Interop.Excel.Range)sheet1.Cells[1, 3];
myRange.Value2 = label10.Text;
myRange = (Microsoft.Office.Interop.Excel.Range)sheet1.Cells[1, 4];
myRange.Value2 = label2.Text;
myRange = (Microsoft.Office.Interop.Excel.Range)sheet1.Cells[1, 5];
myRange.Value2 = label3.Text;
//Write datagridview content
myRange = (Microsoft.Office.Interop.Excel.Range)sheet1.Cells[2, 1];
myRange.Value2 = label6.Text;
myRange = (Microsoft.Office.Interop.Excel.Range)sheet1.Cells[2, 2];
myRange.Value2 = label7.Text;
myRange = (Microsoft.Office.Interop.Excel.Range)sheet1.Cells[2, 3];
myRange.Value2 = label9.Text;
myRange = (Microsoft.Office.Interop.Excel.Range)sheet1.Cells[2, 4];
myRange.Value2 = label4.Text;
myRange = (Microsoft.Office.Interop.Excel.Range)sheet1.Cells[2, 5];
myRange.Value2 = label5.Text;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
124
ПРИЛОЖЕНИЕ 2 Формы
125