private void button1_Copy1_Click(object sender, RoutedEventArgs e)
{
conn.Open();
StaffManagement staM = new BookStore.StaffManagement();
DataSet ds = staM.InquireAttendance2(textBox16.Text, textBox15.Text, conn);
if (ds != null)
{
dataGrid.ItemsSource = ds.Tables[0].DefaultView;
}
else
{
MessageBox.Show("无出勤记录！");
}
DataSet ds2 = staM.InquireMonthStatistics2(textBox16.Text, conn);
if (ds2 != null)
{
dataGrid1.ItemsSource = ds2.Tables[0].DefaultView;
}
else
{
MessageBox.Show("无月统计记录！");
}
}
private void button_Copy3_Click(object sender, RoutedEventArgs e)
{
conn.Open();
Staff staInstance = new BookStore.Staff();
StaffManagement staM = new BookStore.StaffManagement();
//查询结果：true--查询到，false--未查询到
bool iRes = staM.InquireStaffInfo(textBox_Copy11.Text, staInstance, conn);
if (iRes == true)
{
DateTime dt = Convert.ToDateTime(staInstance.Sta_birth);
DateTime dt2 = Convert.ToDateTime(staInstance.Sta_sign_date);
textBox2.Text = staInstance.Sta_name;
textBox3.Text = staInstance.Sta_gender;
textBox6.Text = staInstance.Sta_address;
textBox4.Text = staInstance.Sta_tele;
textBox5.Text = Convert.ToString(dt.Year) + "/" + Convert.ToString(dt.Month) + "/" + Convert.ToString(dt.Day);
textBox7.Text = Convert.ToString(dt2.Year) + "/" + Convert.ToString(dt2.Month) + "/" + Convert.ToString(dt2.Day);
string st = "";
if (staInstance.Sta_on_job == "Yes")
{
st = "在职";
}
if (staInstance.Sta_on_job == "No")
{
st = "离职";
}
textBox7_Copy3.Text = st;
string str = "";
if (staInstance.Po_title == "Cashier")
{
str = "销售管理";
}
if (staInstance.Po_title == "Clerk")
{
str = "库存管理";
}
if (staInstance.Po_title == "Manager")
{
str = "管理员";
}
textBox7_Copy2.Text = str;
}
else
{
//*****************************未查询到，弹框！
}
}
private void button2_Copy_Click(object sender, RoutedEventArgs e)
{
conn.Open();
StaffManagement staM = new BookStore.StaffManagement();
DataSet ds = staM.InquireLeave2(textBox9.Text, conn);
if (ds != null)
{
dataGrid2.ItemsSource = ds.Tables[0].DefaultView;
}
else
{
MessageBox.Show("无请假记录");
}
}
private void button_Copy2_Click(object sender, RoutedEventArgs e)
{
//***************************************输入数据格式检查
conn.Open();
StaffManagement staM = new BookStore.StaffManagement();
bool iRes = staM.CreateLeaveInfo(textBox11.Text, textBox12.Text, textBox13.Text, Convert.ToInt16(textBox14.Text), conn);
if (iRes == true)
{
MessageBox.Show("请假记录创建成功！");
}
else
{
MessageBox.Show("已有此条请假记录，请假记录创建失败");
}
}
private void button1_Click(object sender, RoutedEventArgs e)
{
//**********************************************************此处应有数据格式检测！
conn.Open();
StaffManagement staM = new BookStore.StaffManagement();
string str1 = "";
string str2 = "";
if (textBox7_Copy4.Text == "销售管理")
{
str1 = "Clerk";
}
else if (textBox7_Copy4.Text == "库存管理")
{
str1 = "Cashier";
}
else if (textBox7_Copy4.Text == "管理员")
{
str1 = "Manager";
}
else
{
MessageBox.Show("岗位信息错误！"); return;
}
if (textBox7_Copy5.Text == "在职")
{
str2 = "Yes";
}
else if (textBox7_Copy5.Text == "离职")
{
str2 = "No";
}
staM.UpdateStaffInfo(textBox_Copy.Text, textBox2_Copy.Text, textBox3_Copy.Text, textBox6_Copy.Text,
textBox5_Copy.Text, textBox4_Copy.Text, textBox7_Copy.Text, str1, str2, conn);
MessageBox.Show("插入成功！");
}
private void button2_Click(object sender, RoutedEventArgs e)
{
//日期格式检查：yyyy-mm-dd
conn.Open();
StaffManagement staM = new BookStore.StaffManagement();
if (checkBox1.IsChecked == true && checkBox2.IsChecked == true && checkBox3.IsChecked == false)
{
staM.CreateAttendInfo(textBox10.Text, textBox.Text, '1', '1', '0', conn);
}
else if (checkBox1.IsChecked == true && checkBox2.IsChecked == false && checkBox3.IsChecked == false)
{
staM.CreateAttendInfo(textBox10.Text, textBox.Text, '1', '0', '0', conn);
}
else if (checkBox1.IsChecked == false && checkBox2.IsChecked == true && checkBox3.IsChecked == false)
{
staM.CreateAttendInfo(textBox10.Text, textBox.Text, '0', '1', '0', conn);
}
else
{
MessageBox.Show("请仔细检查出勤信息--缺勤时无迟到、早退");
Console.WriteLine("check again!");
}
}
