// tìm kiếm chi tiết phiếu giao ca public List <chitietphieugiaoca> SearchCtGiaoCa(string magiaoca, string mamathang) { List <chitietphieugiaoca> list = new List <chitietphieugiaoca>(); string query = string.Format("select * from chitietphieugiaoca where magiaoca like N'%{0}%' and mamathang like N'%{1}%'", magiaoca, mamathang); DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow i in data.Rows) { chitietphieugiaoca ct = new chitietphieugiaoca(i); list.Add(ct); } return(list); }
// xem chi tiết phiếu giao ca public List <chitietphieugiaoca> XemCtGiaoCa() { List <chitietphieugiaoca> list = new List <chitietphieugiaoca>(); string query = "select stt, magiaoca,mamathang,soluong from chitietphieugiaoca"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { chitietphieugiaoca hd = new chitietphieugiaoca(item); list.Add(hd); } return(list); }