/// <summary> /// 点击查询按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Button1_Click(object sender, EventArgs e) { string condition = ""; string value = textBox1.Text; if (comboBox1.Text == "员工姓名") { condition = "name"; } if (comboBox1.Text == "性别") { condition = "gender"; } //模糊查询关键字 string sql = string.Format("SELECT [Id],[name],[gender],[date] FROM [Attendance] WHERE [{0}] LIKE '%{1}%'", condition, value); DataTable dt = AttendanceDAL.FindDataTable(sql); dataGridView1.DataSource = null; dataGridView1.Columns.Clear(); dataGridView1.DataSource = dt; dataGridView1.Columns["name"].HeaderText = "员工姓名"; dataGridView1.Columns["gender"].HeaderText = "性别"; dataGridView1.Columns["date"].HeaderText = "考勤日期"; dataGridView1.Columns["Id"].HeaderText = "考勤ID"; }
/// <summary> /// 填充数据网格 /// </summary> void LoadDataGridView() { //清理数据源、清理列(防止列按钮不断增加) dataGridView1.DataSource = null; dataGridView1.Columns.Clear(); dataGridView1.DataSource = AttendanceDAL.FindList(null); dataGridView1.Columns["name"].HeaderText = "员工姓名"; dataGridView1.Columns["gender"].HeaderText = "性别"; dataGridView1.Columns["date"].HeaderText = "考勤日期"; dataGridView1.Columns["Id"].HeaderText = "考勤ID"; }
/// <summary> /// 点击添加考勤信息按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Buttonadd_Click(object sender, EventArgs e) { Attendance model = new Attendance(); model.name = textBox2.Text; model.gender = comboBox2.Text; model.date = dateTimePicker1.Text; // if (AttendanceDAL.Add(model)) { LoadDataGridView(); MessageBox.Show("添加成功"); } }
/// <summary> /// 点击加载数据按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Button2_Click(object sender, EventArgs e) { Attendance model = new Attendance(); try { model.Id = Convert.ToInt32(textBox17.Text); model = AttendanceDAL.FindModel(model, "id"); textBox11.Text = model.name; textBox3.Text = model.gender; textBox10.Text = model.date; } catch (Exception ex) { MessageBox.Show("请输入数字"); } }
/// <summary> /// 点击删除按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Button4_Click(object sender, EventArgs e) { Attendance model = new Attendance(); try { model.Id = Convert.ToInt32(textBox18.Text); if (AttendanceDAL.Drop(model, "id")) { LoadDataGridView(); } } catch (Exception ex) { MessageBox.Show("ID必须是数字"); } }
/// <summary> /// 点击提交修改按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Button3_Click(object sender, EventArgs e) { Attendance model = new Attendance(); try { model.Id = Convert.ToInt32(textBox17.Text); model.name = textBox11.Text; model.gender = textBox3.Text; model.date = textBox10.Text; if (AttendanceDAL.AlterByPK(model, "id")) { LoadDataGridView(); MessageBox.Show("修改成功"); } } catch (Exception ex) { MessageBox.Show("ID必须是数字"); } }
private void frmAttendanceDetails_Load(object sender, EventArgs e) { this.Top = 15; this.Left = 0; lblLoginName.Text = "Login Name : " + frmMainForm.UserName; studentId = frmSearchStudentByTagId.studentID; Student std = new Student(); std = stddalobj.ShowDataOnTextBox(studentId); lblName1.Text = std.Name; lblRollNo1.Text = std.RollNo; lblClass1.Text = std.Class; lblClassTeacher1.Text = std.ClassTeacher; lblClassTeacherContactNo1.Text = std.ClassTeacherContactNo; lblGuardianName1.Text = std.GuardianName; lblGuardianContactNo1.Text = std.GuardianContactNo; AttendanceDAL attdalobj = new AttendanceDAL(); dataGridView1.DataSource = attdalobj.ShowStudentAttendanceDetails("E280110C200078C9BAA208C1"); }
public List <AttendanceDTO> GetDataForAc(string term) { AttendanceDAL dal = new AttendanceDAL(); return(dal.GetDataForAc(term)); }
public string DeleteAttendance(int id) { AttendanceDAL dal = new AttendanceDAL(); return(dal.Delete(id)); }
public AttendanceDTO GetAttendanceById(int id) { AttendanceDAL dal = new AttendanceDAL(); return(dal.GetAttendanceById(id)); }
public AttendanceDTO SaveAttendance(AttendanceDTO dto) { AttendanceDAL dal = new AttendanceDAL(); return(dal.Save(dto)); }