//THỐNG KÊ THEO NHÂN VIÊN CHI TIẾT
public static List <ThongKeTheoHoaDonPublic> ThongKeTheoNhanVienChiTiet(string _MaNV, DateTime _dtTuNgay, DateTime _dtDenNgay)
{
List <ThongKeTheoHoaDonPublic> _lstKqThongKeTheoNhanVien = new List <ThongKeTheoHoaDonPublic>();
DateTime _dtNgayBatDau = new DateTime(_dtTuNgay.Year, _dtTuNgay.Month, _dtTuNgay.Day, 0, 0, 0);
DateTime _dtNgayKetThuc = new DateTime(_dtDenNgay.Year, _dtDenNgay.Month, _dtDenNgay.Day, 23, 59, 59);
//Lấy danh sách hóa đơn theo nhân viên
SqlCommand _cmd = new SqlCommand();
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.CommandText = "[Lấy danh sách hóa đơn theo nhân viên]";
_cmd.Parameters.AddWithValue("@Ma_NV", _MaNV);
_cmd.Parameters.AddWithValue("@TuNgay", _dtNgayBatDau);
_cmd.Parameters.AddWithValue("@DenNgay", _dtNgayKetThuc);
DataTable _dtHoaDon = conn.GetDataSet2(_cmd).Tables[0];
ThongKeTheoHoaDonPublic _thongKeTheoHoaDon;
//Tính chi tiết hóa đơn
if (_dtHoaDon.Rows.Count > 0)
{
for (int i = 0; i < _dtHoaDon.Rows.Count; i++)
{
int _TongThu = 0;
int _TongLoiNhuan = 0;
int _TongTienNhap = 0;
_thongKeTheoHoaDon = new ThongKeTheoHoaDonPublic();
HoaDonPublic _hd = new HoaDonPublic();
_hd = TinhTien1HoaDon(_dtHoaDon.Rows[i]["SoHD_HD"].ToString());
_TongThu += _hd.ThanhTien;
_TongTienNhap += _hd.TongTienNhap;
_TongLoiNhuan = _TongThu - _TongTienNhap;
_thongKeTheoHoaDon.HoaDon = _hd;
_thongKeTheoHoaDon.TongThu = UntilitiesDataAccess.ThemDauPhay(_TongThu.ToString());
_thongKeTheoHoaDon.TongLoiNhuan = UntilitiesDataAccess.ThemDauPhay(_TongLoiNhuan.ToString());
_lstKqThongKeTheoNhanVien.Add(_thongKeTheoHoaDon);
}
}
return(_lstKqThongKeTheoNhanVien);
}
//THỐNG KÊ THEO HÓA ĐƠN
public static List <ThongKeTheoHoaDonPublic> ThongKeTheoHoaDon(DateTime _dtTuNgay, DateTime _dtDenNgay)
{
List <ThongKeTheoHoaDonPublic> _lstKqThongKeTheoHoaDon = new List <ThongKeTheoHoaDonPublic>();
#region 1.Lấy hóa đơn, hàng mua trong khoảng thời gian
DateTime _dtNgayBatDau = new DateTime(_dtTuNgay.Year, _dtTuNgay.Month, _dtTuNgay.Day, 0, 0, 0);
DateTime _dtNgayKetThuc = new DateTime(_dtDenNgay.Year, _dtDenNgay.Month, _dtDenNgay.Day, 23, 59, 59);
SqlCommand _cmd = new SqlCommand();
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.CommandText = "[Thống kê theo hóa đơn]";
_cmd.Parameters.AddWithValue("@TuNgay", _dtNgayBatDau);
_cmd.Parameters.AddWithValue("@DenNgay", _dtNgayKetThuc);
DataSet _dsThongKeTheoHoaDon = conn.GetDataSet2(_cmd);
_cmd.Dispose();
DataTable _dtHoaDon = _dsThongKeTheoHoaDon.Tables[0];
DataTable _dtHangMua = _dsThongKeTheoHoaDon.Tables[1];
#endregion
#region 2.Tính thống kê tổng thu, tổng lợi nhuận từng hóa đơn
if (_dtHoaDon.Rows.Count > 0)
{
for (int i = 0; i < _dtHoaDon.Rows.Count; i++)
{
ThongKeTheoHoaDonPublic _thongKeTheoHoaDon = new ThongKeTheoHoaDonPublic();
////Lấy thông tin hóa đơn
//HoaDonPublic _hoaDon = new HoaDonPublic();
//_hoaDon.SoHD_HD = _dtHoaDon.Rows[i]["SoHD_HD"].ToString();
//_hoaDon.NgayLap_HD = Convert.ToDateTime(_dtHoaDon.Rows[i]["NgayLap_HD"].ToString());
//_hoaDon.NguoiLap_HD.MaNV_NV = _dtHoaDon.Rows[i]["NguoiLap_HD"].ToString();
//_hoaDon.KhachHang_HD.MaKH_KH = _dtHoaDon.Rows[i]["MaKH_HD"].ToString();
//_hoaDon.BanLe_HD = (bool)_dtHoaDon.Rows[i]["BanLe_HD"];
//_hoaDon.TongCKHoaDon = Convert.ToInt32(UntilitiesDataAccess.BoDauPhay(_dtHoaDon.Rows[i]["ChietKhauTienMat_HD"].ToString()));
//_hoaDon.TienKhachTra_HD = Convert.ToInt32(UntilitiesDataAccess.BoDauPhay(_dtHoaDon.Rows[i]["TienKhachTra_HD"].ToString()));
//_hoaDon.VouCher_HD = Convert.ToInt32(UntilitiesDataAccess.BoDauPhay(_dtHoaDon.Rows[i]["VouCher_HD"].ToString()));
//_hoaDon.MaGiamGia.MaThe_MGG = _dtHoaDon.Rows[i]["MaGiamGia_HD"].ToString();
//_hoaDon.CKPhanTram_HD = float.Parse(_dtHoaDon.Rows[i]["CKPhanTram_HD"].ToString());
//_hoaDon.TraHang_HD = (bool)_dtHoaDon.Rows[i]["TraHang_HD"];
//_hoaDon.DangDung_HD = (bool)_dtHoaDon.Rows[i]["DangDung_HD"];
//_thongKeTheoHoaDon.HoaDon = _hoaDon;
////Tính tiền cho từng hóa đơn
//int _TongThu = 0;
//int _TongLai = 0;
//int _TongSoLuongBan = 0;
//int _TongTienNhap = 0;
//string _strFilterHangMua = "SoHD_HM = '" + _thongKeTheoHoaDon.HoaDon.SoHD_HD + "'";
//DataView _dvHangMua = new DataView(_dtHangMua, _strFilterHangMua, "SoHD_HM", DataViewRowState.CurrentRows);
//if (_dvHangMua.Count > 0)
//{
// for (int j = 0; j < _dvHangMua.Count; j++)
// {
// int _soLuong = Convert.ToInt32(_dvHangMua[j]["SoLuong_HM"].ToString());
// int _giaBan = Convert.ToInt32(UntilitiesDataAccess.BoDauPhay(_dvHangMua[j]["GiaBan_HM"].ToString()));
// int _giaNhap = Convert.ToInt32(UntilitiesDataAccess.BoDauPhay(_dvHangMua[j]["GiaNhap_HM"].ToString()));
// int _TienCKSP = Convert.ToInt32(UntilitiesDataAccess.BoDauPhay(_dvHangMua[j]["CKTienMat_HM"].ToString()));
// _TongTienNhap = _TongTienNhap + _giaNhap;
// _TongSoLuongBan = _TongSoLuongBan + _soLuong;
// _TongThu = _TongThu + (_soLuong * _giaBan - _TienCKSP);
// }
// _TongLai = _TongThu - _TongTienNhap;
//}
HoaDonPublic _hd = TinhTien1HoaDon(_dtHoaDon.Rows[i]["SoHD_HD"].ToString());
_thongKeTheoHoaDon.HoaDon = _hd;
int _TongLoiNhuan = _hd.ThanhTien - _hd.TongTienNhap;
_thongKeTheoHoaDon.TongThu = UntilitiesDataAccess.ThemDauPhay(_hd.ThanhTien.ToString());
_thongKeTheoHoaDon.TongLoiNhuan = UntilitiesDataAccess.ThemDauPhay(_TongLoiNhuan.ToString());
_lstKqThongKeTheoHoaDon.Add(_thongKeTheoHoaDon);
}
}
#endregion
return(_lstKqThongKeTheoHoaDon);
}