// tim kiem phieu giao ca public List<phieugiaoca> SearchGiaoCa(string ma, string maquay, string manhanvien) { List<phieugiaoca> list = new List<phieugiaoca>(); string query = string.Format("select * from phieugiaoca where ma like N'%{0}%' and maquay like N'%{1}%' and manhanvien like N'%{2}%'", ma, maquay, manhanvien); DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow i in data.Rows) { phieugiaoca gc = new phieugiaoca(i); list.Add(gc); } return list; }
// xem phiếu giao ca public List<phieugiaoca> XemGiaoCa() { List<phieugiaoca> list = new List<phieugiaoca>(); string query = "select ma,ngay,ca,maquay,manhanvien from phieugiaoca"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { phieugiaoca hd = new phieugiaoca(item); list.Add(hd); } return list; }