private void cmbFilter_SelectedIndexChanged(object sender, EventArgs e) { string type = cmbFilter.SelectedItem.ToString(); var re = new DoctorTestRepo(); if (type == "Male" || type == "Female") { re.SexFilter(type, mgvTest); } else if (type == "Child") { re.ChildFilter(mgvTest); } else if (type == "Youth") { re.YouthFilter(mgvTest); } else if (type == "Adult") { re.AdultFilter(mgvTest); } else if (type == "Senior") { re.SeniorFilter(mgvTest); } }
private void btnSearch_Click(object sender, EventArgs e) { //var sql = "select id,name,age,sex,tests,date,time from test where id "; var en = new DoctorTestEntity(); var re = new DoctorTestRepo(); en.Id = txtId.Text; en.Name = txtName.Text; en.Date = dtpDate.Value.ToString("yyyy-MM-dd"); re.Search(en, mgvTest); }