public static List <ThongKeDTO.TK_SP> ThongKeDTSPTheoThang(int ngay, int thang, int nam) { List <ThongKeDTO.TK_SP> tk = new List <ThongKeDTO.TK_SP>(); try { SqlDataReader reader = DataProvider.ThongKe("ThongKeDTSPTheoThang", ngay, thang, nam); while (reader.Read()) { ThongKeDTO.TK_SP t = new ThongKeDTO.TK_SP(); t.tensp = reader.GetString(0); t.soluong = (int)reader.GetDecimal(1); tk.Add(t); } } catch { } return(tk); }
public static List <ThongKeDTO.TK_KH> ThongKeDSKHTheoNam(int ngay, int thang, int nam) { List <ThongKeDTO.TK_KH> tk = new List <ThongKeDTO.TK_KH>(); try { SqlDataReader reader = DataProvider.ThongKe("ThongKeDSKHTheoNam", ngay, thang, nam); while (reader.Read()) { ThongKeDTO.TK_KH t = new ThongKeDTO.TK_KH(); t.makh = reader.GetString(0); t.hoten = reader.GetString(1); t.soluong = (int)reader.GetDecimal(2); tk.Add(t); } } catch { } return(tk); }
public static List <ThongKeDTO.TK_HD> ThongKeTGHDTheoNam(int ngay, int thang, int nam) { List <ThongKeDTO.TK_HD> tk = new List <ThongKeDTO.TK_HD>(); try { SqlDataReader reader = DataProvider.ThongKe("ThongKeTGHDTheoNam", ngay, thang, nam); while (reader.Read()) { ThongKeDTO.TK_HD t = new ThongKeDTO.TK_HD(); t.sohd = reader.GetInt32(0); t.ngayhd = reader.GetDateTime(1); t.trigia = (int)reader.GetDecimal(2); tk.Add(t); } } catch { } return(tk); }
public static List <ThongKeDTO.TK_NV> ThongKeNVTheoNam(int ngay, int thang, int nam) { List <ThongKeDTO.TK_NV> tk = new List <ThongKeDTO.TK_NV>(); try { SqlDataReader reader = DataProvider.ThongKe("ThongKeNVTheoNam", ngay, thang, nam); while (reader.Read()) { ThongKeDTO.TK_NV t = new ThongKeDTO.TK_NV(); t.manv = reader.GetString(0); t.hoten = reader.GetString(1); t.soluong = (int)reader.GetSqlInt32(2); tk.Add(t); } } catch { } return(tk); }