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!"); } }