private void PosFill()
{
Action action = () =>
{
Table_Class pos = new Table_Class("SELECT [ID_Position] as \'Номер\',[PositionName] as \'Название\',[Salary] as \'Оклад\' FROM [dbo].[Position]");
dgPosition.ItemsSource = pos.table.DefaultView;
};
action.Invoke();
}
private void ProductFill()
{
Action action = () =>
{
Table_Class product = new Table_Class(CurProductQuerry);
dgProduct.ItemsSource = product.table.DefaultView;
};
action.Invoke();
}
private void BtSelect_Click(object sender, RoutedEventArgs e)
{
SaveFileDialog save = new SaveFileDialog();
save.ShowDialog();
Table_Class table = new Table_Class("select [SchemeName] as \'Название\', [Basis] as \'Основание\', [Reality] as \'Реализация\' from [dbo].[MarkScheme] WHERE [LogDelete] = 0");
Document_class document = new Document_class();
document.Document_Create(Document_class.Document_Type.MarkSchemes, save.FileName, table.table);
}
private void ProductFill()
{
Action action = () =>
{
Table_Class product = new Table_Class("SELECT [ID_Product] as \'Артикул\',[Name] as \'Название\',[Storage] as \'Количество\',[Price] as \'Цена\' FROM [dbo].[Product] WHERE [ID_Product]>0 and [LogDelete] = 0 and [Storage]>0");
dgProduct.ItemsSource = product.table.DefaultView;
};
action.Invoke();
}
private void SellFill()
{
Action action = () =>
{
Table_Class sell = new Table_Class(CurSellQuerry + String.Format("AND [Staff_ID] = 0", App.intID));
dgSell.ItemsSource = sell.table.DefaultView;
};
action.Invoke();
}
private void StaffFill()
{
Action action = () =>
{
Table_Class staff = new Table_Class(CurStaffQuerry);
dgEmployee.ItemsSource = staff.table.DefaultView;
};
action.Invoke();
}
private void NamingSelect()
{
Action action = () =>
{
Table_Class name = new Table_Class(String.Format("select [Surname],[Name],[Firstname] from [dbo].[Staff] where [ID_Staff] = {0}", App.intID));
lblTitle.Content = String.Format("Интерфейс управления личными данными: {0} {1} {2}", name.table.Rows[0][0].ToString(), name.table.Rows[0][1].ToString(), name.table.Rows[0][2].ToString());
};
action.Invoke();
}
private void NamingSelect()
{
Action action = () =>
{
Table_Class name = new Table_Class(String.Format("select [Surname],[Name],[Firstname] from [dbo].[Staff] where [ID_Staff] = {0}", SelectedID));
lblCurStaff.Content = String.Format("{0} {1} {2}", name.table.Rows[0][0].ToString(), name.table.Rows[0][1].ToString(), name.table.Rows[0][2].ToString());
};
action.Invoke();
}
private void NamingSelect()
{
Action action = () =>
{
Table_Class name = new Table_Class(String.Format("select [Surname],[Name],[Firstname] from [dbo].[Staff] where [ID_Staff] = {0}", App.intID));
this.Title = String.Format("Интерфейс менеджера по работе с персоналом: {0} {1} {2}", name.table.Rows[0][0].ToString(), name.table.Rows[0][1].ToString(), name.table.Rows[0][2].ToString());
};
action.Invoke();
}
private void BtSelect_Click(object sender, RoutedEventArgs e)
{
SaveFileDialog save = new SaveFileDialog();
save.ShowDialog();
Table_Class table = new Table_Class("SELECT [Name],(select [TypeNAme] from [dbo].[ProductType] WHERE [Type_ID] = [ID_ProductType]),[Storage],[FirstDec],[Price] FROM [dbo].[Product] WHERE [ID_Product] >0 and [LogDelete] = 0");
Document_class document = new Document_class();
document.Document_Create(Document_class.Document_Type.Storage, save.FileName, table.table);
}
private void ProductFill()
{
Action action = () =>
{
Table_Class product = new Table_Class(CurProductQuerry);
product.Dependency.OnChange += ProductDependency_OnChange;
dgProduct.ItemsSource = product.table.DefaultView;
};
action.Invoke();
}
private void TypeProductFill()
{
Action action = () =>
{
Table_Class type = new Table_Class(CurTypeQuerry);
type.Dependency.OnChange += TypeProductDependency_OnChange;
dgType.ItemsSource = type.table.DefaultView;
};
action.Invoke();
}
private void SchemeFill()
{
Action action = () =>
{
Table_Class scheme = new Table_Class(CurSchemeQuerry);
scheme.Dependency.OnChange += SchemeDependency_OnChange;
dgScheme.ItemsSource = scheme.table.DefaultView;
};
action.Invoke();
}
///<summary>
///Перегрузка для процедур с параметрами.
///</summary>
///<param name = "Function_Name">Название процедуры</param>
///<param name = "Type_function">Тип функции</param>
///<param name = "Parameters">Параметры</param>
public Function_class(string Function_Name, Function_Result Type_function, ArrayList Parameters)
{
string querry = "";
try
{
switch (Type_function)
{
case Function_Result.scalar:
//Вывод данныхиз скалаярной функции
querry = string.Format(@"select [dbo].[{0}](", Function_Name);
break;
case Function_Result.table:
querry = string.Format(@"select * from [dbo].[{0}](", Function_Name);
break;
}
//Переменная списка параметров
string list_parameters = "";
//switch (Parameters.Count)
//{
// case 1:
// //Вывод данныхиз скалаярной функции
// list_parameters += Parameters[0].ToString() + ")";
// break;
// default:
// foreach (object parameter in Parameters)
// {
// list_parameters += parameter + ",";
// }
// list_parameters = list_parameters.Remove(list_parameters.Length-1, 1);
// list_parameters += ")";
// break;
//}
//Заполнение списка из листа параметров
foreach (object parameter in Parameters)
{
list_parameters += "\'" + parameter.ToString() + "\',";
}
list_parameters = list_parameters.Remove(list_parameters.Length - 1, 1);
list_parameters += ")";
//Оформление запроса
querry += list_parameters;
//Заполнение таблицы
Table_Class table = new Table_Class(querry);
Regtable = table.table;
}
catch
{
}
}
private void PosFill()
{
Action action = () =>
{
Table_Class pos = new Table_Class("SELECT [ID_Position],[PositionName] FROM [dbo].[Position] WHERE [ID_Position]>0 and [LogDelete] = 0");
cbPosition.ItemsSource = pos.table.DefaultView;
cbPosition.DisplayMemberPath = "PositionName";
cbPosition.SelectedValuePath = "ID_Position";
};
action.Invoke();
}
private void BtEnter_Click(object sender, RoutedEventArgs e)
{
Action action = () =>
{
Procedure_Class procedure = new Procedure_Class();
ArrayList array = new ArrayList();
Table_Class number = new Table_Class(String.Format("select count (*) +1 from [dbo].[Order] where [Staff_ID] = {0}", SelectedID));
switch (cbType.SelectedIndex)
{
case (0):
array.Add(String.Format("Увольнение сотрудника {0}", SelectedID));
array.Add(String.Format("Уволить сотрудника {0} по причине: {1}. Дата (местная): {2}", lblCurStaff.Content, tbText.Text, DateTime.Now.ToString()));
array.Add(SelectedID);
procedure.procedure_Execution("Order_Insert", array);
array.Clear();
array.Add(SelectedID);
array.Add("1");
procedure.procedure_Execution("Staff_LogDelete", array);
array.Clear();
break;
case (1):
Table_Class pos = new Table_Class(String.Format("select [PositionName] from [dbo].[Position] where [ID_Position] = \'{0}\'", cbPosition.SelectedValue.ToString()));
array.Add(String.Format("Перевод сотрудника {0} (№ {1})", SelectedID, number.table.Rows[0][0].ToString()));
array.Add(String.Format("Перевести сотрудника {0} на должность {1} по причине: {2}. Дата (местная): {3}", lblCurStaff.Content, pos.table.Rows[0][0].ToString(), tbText.Text, DateTime.Now.ToString()));
array.Add(SelectedID);
procedure.procedure_Execution("Order_Insert", array);
array.Clear();
array.Add(SelectedID);
array.Add(cbPosition.SelectedValue.ToString());
procedure.procedure_Execution("Staff_Reposition", array);
array.Clear();
break;
case (2):
array.Add(String.Format("Особый приказ для сотрудника {0} (№ {1})", SelectedID, number.table.Rows[0][0].ToString()));
array.Add(String.Format("{1}. Сотрудник: {0}. Дата (местная): {2}", lblCurStaff.Content, tbText.Text, DateTime.Now.ToString()));
array.Add(SelectedID);
procedure.procedure_Execution("Order_Insert", array);
break;
}
cbType.SelectedIndex = -1;
cbPosition.SelectedIndex = -1;
tbText.Clear();
};
action.Invoke();
this.Hide();
(Owner as ManagerInterface).TableRefresh();
Owner.Show();
}
private void BtSelect_Click(object sender, RoutedEventArgs e)
{
SaveFileDialog save = new SaveFileDialog();
save.ShowDialog();
Table_Class table = new Table_Class(String.Format("SELECT [Check] as \'Чек\',(select [Surname] from [dbo].[Staff] where [ID_Staff] = [Staff_ID]) as \'Фамилия\',(select [Name] from [dbo].[Staff] where [ID_Staff] = [Staff_ID]) as \'Имя\',(select [FirstName] from [dbo].[Staff] where [ID_Staff] = [Staff_ID]) as \'Отчество\', (select [Name] from [dbo].[Product] where [ID_Product] = [Product_ID]) as \'Товар\', (select [SchemeName] from [dbo].[MarkScheme] where [ID_Scheme] = (select [Scheme_ID] from [dbo].[Product] where [ID_Product] = [Product_ID])) as \'Схема\',[Amount] as \'Количество\',[SellDate] as \'Дата\',[Price] as \'Сумма\' FROM [dbo].[Sell] WHERE [Check] = \'{0}\'", tbCheck.Text));
Document_class document = new Document_class();
document.Document_Create(Document_class.Document_Type.Check, save.FileName, table.table);
ArrayList array = new ArrayList();
array.Add(tbCheck.Text);
array.Add(save.FileName);
Procedure_Class procedure = new Procedure_Class();
procedure.procedure_Execution("Sell_Doc_Create", array);
tbCheck.Clear();
}
private void BtEnter_Click(object sender, RoutedEventArgs e)
{
Action action = () =>
{
Table_Class table = new Table_Class(String.Format("select count (*) from [dbo].[Staff] where [Login] = \'{0}\'", tbLogin.Text));
if (table.table.Rows[0][0].ToString() != "0")
{
MessageBox.Show("Этот логин использовать нельзя!", "ParawosoffApp", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
ArrayList staff = new ArrayList();
staff.Add(tbFirstName.Text);
staff.Add(tbName.Text);
staff.Add(tbPatronymic.Text);
staff.Add(tbExp.Text);
DES des = DES.Create();
byte[] key = Convert.FromBase64String("WdbWuvWCHPc=");
byte[] IV = Convert.FromBase64String("RuBs2bQBW58=");
des.Key = key;
des.IV = IV;
byte[] login = Crypt_Class.SymmetricEncrypt(tbLogin.Text, des);
byte[] passwd = Crypt_Class.SymmetricEncrypt(tbPassword.Text, des);
staff.Add(Convert.ToBase64String(login));
staff.Add(Convert.ToBase64String(passwd));
staff.Add(cbPosition.SelectedValue.ToString());
Procedure_Class procedure = new Procedure_Class();
procedure.procedure_Execution("Staff_Insert", staff);
Table_Class ID = new Table_Class("select [ID_Staff],[Timestamp] from [dbo].[Staff] WHERE [Timestamp] = (select MAX([Timestamp]) from [dbo].[Staff])");
ArrayList array = new ArrayList();
array.Add(String.Format("Приём на работу ({0})", ID.table.Rows[0][0].ToString()));
Table_Class pos = new Table_Class(String.Format("select [PositionName] from [dbo].[Position] where [ID_Position] = \'{0}\'", cbPosition.SelectedValue.ToString()));
array.Add(String.Format("Принять сотрудника {0} {1} {2} на должность {3}. Дата: {4}", tbFirstName.Text, tbName.Text, tbPatronymic.Text, pos.table.Rows[0][0].ToString(), ID.table.Rows[0][1].ToString()));
array.Add(ID.table.Rows[0][0].ToString());
procedure.procedure_Execution("Order_Insert", array);
this.Hide();
(Owner as ManagerInterface).TableRefresh();
Owner.Show();
}
};
action.Invoke();
}
private void OrderFill()
{
Action action = () =>
{
string SelectedStaff = "";
if (tbStaffID.Text.Length > 0)
{
SelectedStaff = tbStaffID.Text;
}
else
{
SelectedStaff = App.intID;
}
Table_Class order = new Table_Class(CurOrderQuerry + String.Format(" [Staff_ID] = {0}", SelectedStaff));
dgOrder.ItemsSource = order.table.DefaultView;
};
action.Invoke();
}
private void BtSelect_Click(object sender, RoutedEventArgs e)
{
Action action = () =>
{
SaveFileDialog save = new SaveFileDialog();
save.ShowDialog();
Table_Class table = new Table_Class(String.Format("select [OrderName],[OrderText] from [dbo].[Order] WHERE [ID_Order] = {0}", tbOrderID.Text));
Document_class document = new Document_class();
document.Document_Create(Document_class.Document_Type.Order, save.FileName, table.table);
ArrayList array = new ArrayList();
array.Add(tbOrderID.Text);
array.Add(save.FileName);
Procedure_Class procedure = new Procedure_Class();
procedure.procedure_Execution("Order_Doc_Create", array);
tbOrderID.Clear();
};
action.Invoke();
}
private void BtUpdate_Click(object sender, RoutedEventArgs e)
{
Action action = () =>
{
ArrayList array = new ArrayList();
array.Add(tbProductID.Text);
array.Add(tbName.Text);
array.Add(tbPrice.Text);
Table_Class table = new Table_Class(String.Format("SELECT [FirstDec],[Scheme_ID]FROM [dbo].[Product] WHERE [ID_Product] = {0}", tbProductID.Text));
if (MessageBox.Show("Изменить дату первого добавления?", "ParawosoffApp", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
string Day = DateTime.Now.Day.ToString();
if (Day.Length < 2)
{
Day = "0" + Day;
}
string Month = DateTime.Now.Month.ToString();
if (Month.Length < 2)
{
Month = "0" + Month;
}
array.Add(Day + "." + Month + "." + DateTime.Now.Year.ToString());
}
else
{
array.Add(table.table.Rows[0][0].ToString());
}
array.Add(table.table.Rows[0][1].ToString());
array.Add(tbTypeID.Text);
Procedure_Class procedure = new Procedure_Class();
procedure.procedure_Execution("Product_Update", array);
tbProductID.Clear();
tbName.Clear();
tbPrice.Clear();
tbTypeID.Clear();
tbTypeName.Clear();
tbTerms.Clear();
ProductFill();
};
action.Invoke();
}
private void TbStaffID_TextChanged(object sender, TextChangedEventArgs e)
{
if (tbStaffID.Text.Length > 0)
{
Table_Class table = new Table_Class(String.Format("select [LogDelete] from [dbo].[Staff] where [ID_Staff] = {0}", tbStaffID.Text));
if (table.table.Rows[0][0].ToString() == "False")
{
btForCurEmployee.IsEnabled = true;
}
else
{
btForCurEmployee.IsEnabled = false;
}
}
else
{
btForCurEmployee.IsEnabled = false;
}
OrderFill();
}
private void BasicsSelect()
{
Action action = () =>
{
Table_Class basics = new Table_Class(String.Format("SELECT [Surname],[Name],[Firstname],[Recruitment],[Exp],[Login],[Position_ID] FROM [dbo].[Staff] WHERE [ID_Staff] = {0}", App.intID));
Surname = basics.table.Rows[0][0].ToString();
Name = basics.table.Rows[0][1].ToString();
Firstname = basics.table.Rows[0][2].ToString();
Recruitment = basics.table.Rows[0][3].ToString();
Exp = basics.table.Rows[0][4].ToString();
Pos = basics.table.Rows[0][6].ToString();
DES des = DES.Create();
byte[] key = Convert.FromBase64String("WdbWuvWCHPc=");
byte[] IV = Convert.FromBase64String("RuBs2bQBW58=");
des.Key = key;
des.IV = IV;
string login = Crypt_Class.SymmetricDecrypt(Convert.FromBase64String(basics.table.Rows[0][5].ToString()), des);
tbLogin.Text = login;
tbPassword.Clear();
};
action.Invoke();
}
private void TbCurSellID_TextChanged(object sender, TextChangedEventArgs e)
{
Action action = () =>
{
if (tbReamount.Text.Length == 0)
{
tbReamount.Text = "1";
}
else
if (Convert.ToInt32(tbReamount.Text) <= 0)
{
tbReamount.Text = "1";
}
if (tbCurSellID.Text.Length > 0)
{
btDelete.IsEnabled = true;
Table_Class table = new Table_Class(String.Format("select [Storage] from [dbo].[Product] where [ID_Product] = {0}", tbCurSellID.Text));
int Storage = Convert.ToInt32(table.table.Rows[0][0].ToString());
int Selected = Convert.ToInt32(tbReamount.Text);
if (Storage >= Selected)
{
btReamount.IsEnabled = true;
}
else
{
btReamount.IsEnabled = false;
}
}
else
{
btReamount.IsEnabled = false;
btDelete.IsEnabled = false;
}
};
action.Invoke();
}
private void Autorization()
{
Action action = () =>
{
DES des = DES.Create();
byte[] key = Convert.FromBase64String("WdbWuvWCHPc=");
byte[] IV = Convert.FromBase64String("RuBs2bQBW58=");
des.Key = key;
des.IV = IV;
byte[] login = Crypt_Class.SymmetricEncrypt(tbLogin.Text, des);
byte[] passwd = Crypt_Class.SymmetricEncrypt(tbPassword.Password, des);
ArrayList array = new ArrayList();
array.Add(Convert.ToBase64String(login));
array.Add(Convert.ToBase64String(passwd));
tbLogin.Clear();
tbPassword.Clear();
Function_class autoriz = new Function_class("Autorization", Function_class.Function_Result.scalar, array);
if (autoriz.Regtable.Rows[0][0].ToString() == "-1")
{
MessageBox.Show("Учётная запись с такими параметрами не существует или является заблокированной!", "ParawosoffApp", MessageBoxButton.OK, MessageBoxImage.Error);
}
else
{
App.intID = autoriz.Regtable.Rows[0][0].ToString();
Table_Class tablePos = new Table_Class(String.Format("select [Position_ID] from [dbo].[Staff] where [ID_Staff] = {0}", autoriz.Regtable.Rows[0][0].ToString()));
switch (tablePos.table.Rows[0][0].ToString())
{
case ("0"):
Selector selector = new Selector();
selector.Owner = this;
selector.Show();
this.Hide();
break;
case ("1"):
SaleInterface sale = new SaleInterface();
sale.Owner = this;
sale.Show();
this.Hide();
break;
case ("2"):
ManagerInterface manager = new ManagerInterface();
manager.Owner = this;
manager.Show();
this.Hide();
break;
case ("3"):
StoragerInterface storager = new StoragerInterface();
storager.Owner = this;
storager.Show();
this.Hide();
break;
case ("4"):
MarketerInterface marketer = new MarketerInterface();
marketer.Owner = this;
marketer.Show();
this.Hide();
break;
}
}
};
action.Invoke();
}
