private void Button_Click(object sender, RoutedEventArgs e) //刷新所有员工信息
{
string connString = @"Data Source=(local);Initial Catalog=Employeedb;Integrated Security=True";
SqlConnection sqlConnection = new SqlConnection(connString);
sqlConnection.Open();
string sqlStr = "select * from HourlyEmployee";
DataSet dataSet = new DataSet();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlStr, connString);
sqlDataAdapter.Fill(dataSet, "HourlyEmployee");
DataView dataView = new DataView(dataSet.Tables["HourlyEmployee"]);
DataGrid1.ItemsSource = dataView;
string sqlStr1 = "select * from CommissionedEmployee";
DataSet dataSet1 = new DataSet();
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(sqlStr1, connString);
sqlDataAdapter1.Fill(dataSet1, "CommissionedEmployee");
DataView dataView1 = new DataView(dataSet1.Tables["CommissionedEmployee"]);
DataGrid2.ItemsSource = dataView1;
string sqlStr2 = "select * from SalariedEmployee";
DataSet dataSet2 = new DataSet();
SqlDataAdapter sqlDataAdapter2 = new SqlDataAdapter(sqlStr2, connString);
sqlDataAdapter2.Fill(dataSet2, "SalariedEmployee");
DataView dataView2 = new DataView(dataSet2.Tables["SalariedEmployee"]);
DataGrid3.ItemsSource = dataView2;
string sqlStr3 = "select * from TimeCard";
DataSet dataSet3 = new DataSet();
SqlDataAdapter sqlDataAdapter3 = new SqlDataAdapter(sqlStr3, connString);
sqlDataAdapter3.Fill(dataSet3, "TimeCard");
DataView dataView3 = new DataView(dataSet3.Tables["TimeCard"]);
DataGrid4.ItemsSource = dataView3;
string sqlStr4 = "select * from SalesReceipt";
DataSet dataSet4 = new DataSet();
SqlDataAdapter sqlDataAdapter4 = new SqlDataAdapter(sqlStr4, connString);
sqlDataAdapter4.Fill(dataSet4, "SalesReceipt");
DataView dataView4 = new DataView(dataSet4.Tables["SalesReceipt"]);
DataGrid5.ItemsSource = dataView4;
sqlConnection.Close();
PayrollDatabase database = new FunctionPayrollDatabase();
Lable1.Content = database.ShowEmployeeCount1();
Lable2.Content = database.ShowEmployeeCount2();
Lable3.Content = database.ShowEmployeeCount3();
Lable4.Content = database.ShowEmployeeCount4();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
DateTime startdate = Convert.ToDateTime(TextBox1.Text);
DateTime enddate = Convert.ToDateTime(TextBox2.Text);
int id = int.Parse(TextBox3.Text);
PayrollDatabase database = new FunctionPayrollDatabase();
Employee ee = database.GetEmployee(id);
Paycheck st = new Paycheck(startdate, enddate);
double pay = ee.Classification.CalculatePay(st);
PaydayTransaction pt = new PaydayTransaction(enddate, database);
pt.Execute();
Paycheck pc = pt.GetPaycheck(id);
DateTime date = Convert.ToDateTime(TextBox4.Text);
if (pc != null && date >= enddate)
{
string payMethod = TextBox5.Text;
database.pay(id, pay, date, payMethod);
MessageBox.Show("共付 " + pay + " 元", "通知");
}
else
{
MessageBox.Show("未到支付日期");
}
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
int id = int.Parse(TextBox1.Text);
PayrollDatabase database = new FunctionPayrollDatabase();
DeleteEmployeeTransaction deleteEmployee = new DeleteEmployeeTransaction(id, database);
deleteEmployee.Execute();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
int id = int.Parse(TextBox1.Text);
int amount = int.Parse(TextBox2.Text);
DateTime time = DateTime.Now;
PayrollDatabase database = new FunctionPayrollDatabase();
SalesReceiptTransaction salesReceipt = new SalesReceiptTransaction(time, amount, id, database);
salesReceipt.Execute();
}
private void Button_Click(object sender, RoutedEventArgs e) //添加
{
int id = int.Parse(TextBox1.Text);
string name = TextBox2.Text;
string address = TextBox3.Text;
double hourlyRate = float.Parse(TextBox4.Text);
PayrollDatabase database = new FunctionPayrollDatabase();
AddHourlyEmployee addHourlyEmployee = new AddHourlyEmployee(id, name, address, hourlyRate, database);
addHourlyEmployee.Execute();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
int id = int.Parse(TextBox1.Text);
string name = TextBox2.Text;
DateTime dateTime = DateTime.Now;
double hours = float.Parse(TextBox3.Text);
PayrollDatabase database = new FunctionPayrollDatabase();
TimeCardTransaction timeCard = new TimeCardTransaction(dateTime, hours, id, database);
timeCard.Execute();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
int id = int.Parse(TextBox1.Text);
string name = TextBox2.Text;
string address = TextBox3.Text;
double baseRate = float.Parse(TextBox4.Text);
double commissionRate = float.Parse(TextBox5.Text);
PayrollDatabase database = new FunctionPayrollDatabase();
AddCommissionedEmployee addCommissionedEmployee = new AddCommissionedEmployee(id, name, address, baseRate, commissionRate, database);
addCommissionedEmployee.Execute();
}
public MainWindow()
{
WindowStartupLocation = WindowStartupLocation.CenterScreen;
InitializeComponent();
PayrollDatabase database = new FunctionPayrollDatabase();
Lable1.Content = database.ShowEmployeeCount1();
Lable2.Content = database.ShowEmployeeCount2();
Lable3.Content = database.ShowEmployeeCount3();
Lable4.Content = database.ShowEmployeeCount4();
this.DataGrid1.LoadingRow += new EventHandler <DataGridRowEventArgs>(this.DataGrid1_LoadingRow); //datagrid1中自动标号
this.DataGrid2.LoadingRow += new EventHandler <DataGridRowEventArgs>(this.DataGrid2_LoadingRow); //datagrid2中自动标号
this.DataGrid3.LoadingRow += new EventHandler <DataGridRowEventArgs>(this.DataGrid3_LoadingRow); //datagrid3中自动标号
this.DataGrid4.LoadingRow += new EventHandler <DataGridRowEventArgs>(this.DataGrid4_LoadingRow); //datagrid4中自动标号
this.DataGrid5.LoadingRow += new EventHandler <DataGridRowEventArgs>(this.DataGrid5_LoadingRow); //datagrid5中自动标号
}
