// 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;
}
