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