Материал: Автоматизация учета рабочего времени сотрудников компании ОАО "РЖД"

Скачать

Заказать новую работу

Внимание! Если размещение файла нарушает Ваши авторские права, то обязательно сообщите нам
83
Приложение Б. Листинг программы
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace Salary_Control
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
btnAddPenalty.Visible = false;
btnGetSalary.Visible = false;
btnWorkflow.Visible = false;
btn_AddEmployer.Visible = false;
btn_AddPost.Visible = false;
}
private void Form1_Load(object sender, EventArgs e)
{
}
private void btnAuth_Click(object sender, EventArgs e)
{
if (txtLogin.Text == "User" && txtPassword.Text == "User")
{
btnAddPenalty.Visible = true;
btnGetSalary.Visible = true;
btnWorkflow.Visible = true;
btn_AddEmployer.Visible = false;
btn_AddPost.Visible = false;
}
else if (txtLogin.Text == "Admin" && txtPassword.Text == "Admin")
{
btnAddPenalty.Visible = true;
btnGetSalary.Visible = true;
btnWorkflow.Visible = true;
btn_AddEmployer.Visible = true;
btn_AddPost.Visible = true;
}
}
84
private void btn_AddEmployer_Click(object sender, EventArgs e)
{
Form Emp = new AddEmployer();
Emp.Show();
}
private void btn_AddPost_Click(object sender, EventArgs e)
{
Form Post = new AddPost();
Post.Show();
}
private void btnAddPenalty_Click(object sender, EventArgs e)
{
Form Penalty = new AddPenalty();
Penalty.Show();
}
private void btnWorkflow_Click(object sender, EventArgs e)
{
Form Salary = new SalControl();
Salary.Show();
}
private void btnGetSalary_Click(object sender, EventArgs e)
{
Form Report = new Report();
Report.Show();
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Salary_Control
{
public partial class AddEmployer : Form
{
SqlConnection con = new SqlConnection(@"Data
Source=SERENITY\SQLEXPRESS;Initial Catalog=Salary;Integrated Security=True");
public AddEmployer()
85
{
InitializeComponent();
con.Open();
SqlCommand cmdRead = new SqlCommand();
cmdRead.Connection = con;
cmdRead.CommandText = "SELECT p_Name FROM Post";
SqlDataReader reader = cmdRead.ExecuteReader();
while (reader.Read())
{
cmbPost.Items.Add(reader[0].ToString());
}
reader.Close();
con.Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (txtSecondName.Text == "" || txtFirstName.Text == ""
|| txtMidName.Text == "" || txtID.Text == ""
|| txtBurthday.Text == "" || txtAccount.Text == "")
{
MessageBox.Show("Не задано значение");
}
else
{
con.Open();
SqlCommand cmdWrite = new SqlCommand();
cmdWrite.Connection = con;
cmdWrite.CommandText = "INSERT INTO [Employer] (emp_LastName,
emp_FirstName, emp_MidName, emp_Birthday, emp_ID, emp_Account, id_Post) VALUES
(@LastName, @FirstName, @MidName, @Birthday, @ID, @Account, @Post)";
cmdWrite.Parameters.AddWithValue("LastName", txtSecondName.Text);
cmdWrite.Parameters.AddWithValue("FirstName", txtFirstName.Text);
cmdWrite.Parameters.AddWithValue("MidName", txtMidName.Text);
cmdWrite.Parameters.AddWithValue("Birthday", txtBurthday.Text);
cmdWrite.Parameters.AddWithValue("ID", txtID.Text);
cmdWrite.Parameters.AddWithValue("Account", txtAccount.Text);
cmdWrite.Parameters.AddWithValue("Post", cmbPost.SelectedIndex+1);
cmdWrite.ExecuteNonQuery();
con.Close();
}
}
}
}
using System;
86
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Salary_Control
{
public partial class AddPost : Form
{
SqlConnection con = new SqlConnection(@"Data
Source=SERENITY\SQLEXPRESS;Initial Catalog=Salary;Integrated Security=True");
public AddPost()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
if (txtPost.Text == "" || txtSalary.Text == "")
{
MessageBox.Show("Не введены значения");
}
else
{
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = "INSERT INTO [Post] (p_Name, p_Salary) VALUES (@Name,
@Salary)";
cmd.Parameters.AddWithValue("Name", txtPost.Text);
cmd.Parameters.AddWithValue("Salary", txtSalary.Text);
cmd.ExecuteNonQuery();
con.Close();
}
}
}
}
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
87
using System.Windows.Forms;
using System.Data.SqlClient;
namespace Salary_Control
{
public partial class SalControl : Form
{
SqlConnection con = new SqlConnection(@"Data
Source=SERENITY\SQLEXPRESS;Initial Catalog=Salary;Integrated Security=True");
public SalControl()
{
InitializeComponent();
con.Open();
SqlCommand cmdRead = new SqlCommand();
cmdRead.Connection = con;
cmdRead.CommandText = "SELECT emp_LastName FROM Employer";
SqlDataReader reader = cmdRead.ExecuteReader();
while (reader.Read())
{
cmbEmployer.Items.Add(reader[0].ToString());
}
reader.Close();
con.Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (/*mtxtDate.Text == "" || mtxtWorkStart.Text == "" || mtxtWorkStop.Text == ""*/
false)
{
MessageBox.Show("Значения не введены");
}
else
{
Int32 Empindex = 0;
Int32 TSindex = 0;
Double duration = 0;
DateTime time1 = new DateTime();
DateTime time2 = new DateTime();
time1 = Convert.ToDateTime(mtxtWorkStart.Text);
time2 = Convert.ToDateTime(mtxtWorkStop.Text);
TimeSpan ts = time2.Subtract(time1);
duration = ts.TotalHours;
con.Open();
// находим имя в Employer
SqlCommand cmdRead1 = new SqlCommand();
Источник: https://baza.diplomsite.ru/previewfile/2429

Смотрите также:

17. Введение 18. Линейные программы 19. Ветвления 20. Программирование циклических алгоритмов
Анализ эффективности инвестиций предприятия на примере ООО «СпецПримСтрой»
Сборные железобетонные ребристые плиты перекрытия
_-___-~1
_3 тема - Диффузия
_Роджерс Карл, Брак и его альтернативы
_Штерн Вильям, Дифференциальная психология и ее методические основы
- Описание типа СЭТ7009