Пример #1
0
        public void HienThi()
        {
            try
            {
                hienthi       = new List <Entities.BCNhapHangTheoThoiGian>();
                hienthibaocao = new List <Entities.BCNhapHangTheoThoiGianChiTiet>();
                int sotangbaocao  = 0;
                int sotanghienthi = 0;
                // hóa đơn nhập
                for (int i = 0; i < hoadonnhap.Length; i++)
                {
                    int      soluong   = 0;
                    DateTime ngayphieu = hoadonnhap[i].NgayNhap;
                    if (ngayphieu >= truoc && ngayphieu <= sau)
                    {
                        for (int j = 0; j < chitiethoadonnhap.Length; j++)
                        {
                            if (hoadonnhap[i].MaHoaDonNhap == chitiethoadonnhap[j].MaHoaDonNhap)
                            {
                                for (int k = 0; k < hanghoa.Length; k++)
                                {
                                    if (chitiethoadonnhap[j].MaHangHoa == hanghoa[k].MaHangHoa)
                                    {
                                        int sl = chitiethoadonnhap[j].SoLuong;
                                        soluong += sl;
                                        Entities.BCNhapHangTheoThoiGianChiTiet ct = new Entities.BCNhapHangTheoThoiGianChiTiet(hoadonnhap[i].MaHoaDonNhap, "Hóa Đơn Nhập", hoadonnhap[i].NgayNhap, hanghoa[k].MaHangHoa, hanghoa[k].TenHangHoa, sl);
                                        hienthibaocao.Add(ct);
                                    }
                                }
                            }
                        }
                        Entities.BCNhapHangTheoThoiGian tg = new Entities.BCNhapHangTheoThoiGian(hoadonnhap[i].MaHoaDonNhap, "Hóa Đơn Nhập", hoadonnhap[i].NgayNhap, soluong);
                        hienthi.Add(tg);
                    }
                }
                // khách hàng trả lại
                for (int i = 0; i < khachhangtralai.Length; i++)
                {
                    int      soluong   = 0;
                    DateTime ngayphieu = khachhangtralai[i].NgayNhap;
                    if (ngayphieu >= truoc && ngayphieu <= sau)
                    {
                        for (int j = 0; j < chitietkhachhangtralai.Length; j++)
                        {
                            if (khachhangtralai[i].MaKhachHangTraLai == chitietkhachhangtralai[j].MaKhachHangTraLai)
                            {
                                for (int k = 0; k < hanghoa.Length; k++)
                                {
                                    if (!GoiHangOrHangHoa(chitietkhachhangtralai[j].MaHangHoa))
                                    {
                                        if (chitietkhachhangtralai[j].MaHangHoa == hanghoa[k].MaHangHoa)
                                        {
                                            int sl = chitietkhachhangtralai[j].SoLuong;
                                            soluong += sl;
                                            Entities.BCNhapHangTheoThoiGianChiTiet ct = new Entities.BCNhapHangTheoThoiGianChiTiet(khachhangtralai[i].MaKhachHangTraLai, "Khách Hàng Trả Lại", khachhangtralai[i].NgayNhap, hanghoa[k].MaHangHoa, hanghoa[k].TenHangHoa, sl);
                                            hienthibaocao.Add(ct);
                                        }
                                    }
                                    ////////////////////////////////////////////////MRK FIX
                                    else
                                    {//là gói hàng
                                        foreach (Entities.GoiHang gh in goihang)
                                        {
                                            foreach (Entities.ChiTietGoiHang ctgh in chitietgoihang)
                                            {
                                                if (gh.MaGoiHang.Equals(ctgh.MaGoiHang) && ctgh.MaGoiHang.Equals(chitietkhachhangtralai[j].MaHangHoa) && ctgh.MaHangHoa.Equals(hanghoa[k].MaHangHoa))
                                                {
                                                    int sl = chitietkhachhangtralai[j].SoLuong * ctgh.SoLuong;
                                                    soluong += sl;
                                                    Entities.BCNhapHangTheoThoiGianChiTiet ct = new Entities.BCNhapHangTheoThoiGianChiTiet(khachhangtralai[i].MaKhachHangTraLai, "Khách Hàng Trả Lại", khachhangtralai[i].NgayNhap, hanghoa[k].MaHangHoa + " (" + ctgh.MaGoiHang + ")", hanghoa[k].TenHangHoa, sl);
                                                    hienthibaocao.Add(ct);
                                                }
                                            }
                                        }
                                    }
                                    ////////////////////////////////////////////////MRK FIX
                                }
                            }
                        }
                        Entities.BCNhapHangTheoThoiGian tg = new Entities.BCNhapHangTheoThoiGian(khachhangtralai[i].MaKhachHangTraLai, "Khách Hàng Trả Lại", khachhangtralai[i].NgayNhap, soluong);
                        hienthi.Add(tg);
                    }
                }


                ///////////////////////////////MRK FIX
                List <Entities.BCNhapHangTheoThoiGian> tem0 = new List <Entities.BCNhapHangTheoThoiGian>();
                int tong0 = 0;
                foreach (Entities.BCNhapHangTheoThoiGian item in hienthi.ToArray())
                {
                    tong0 += item.SoLuong;
                    tem0.Add(item);
                }
                Entities.BCNhapHangTheoThoiGian tem1 = new Entities.BCNhapHangTheoThoiGian();
                tem1.TenChungTu = "Tổng: ";
                tem1.SoLuong    = tong0;
                tem0.Add(tem1);
                //////////////////////////////////////
                //dtgvhienthi.DataSource = hienthi;
                dtgvHienThi.DataSource = tem0.ToArray();

                if (hienthi.ToArray().Length > 0)
                {
                    tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = true;
                }
                else
                {
                    tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = false;
                }
                fix();
            }
            catch
            {
            }
        }
        public void HienThi()
        {
            try
            {
                hienthi = new List<Entities.BCNhapHangTheoThoiGian>();
                hienthibaocao = new List<Entities.BCNhapHangTheoThoiGianChiTiet>();
                int sotangbaocao = 0;
                int sotanghienthi = 0;
                // hóa đơn nhập
                for (int i = 0; i < hoadonnhap.Length; i++)
                {
                    int soluong = 0;
                    DateTime ngayphieu = hoadonnhap[i].NgayNhap;
                    if (ngayphieu >= truoc && ngayphieu <= sau)
                    {
                        for (int j = 0; j < chitiethoadonnhap.Length; j++)
                        {
                            if (hoadonnhap[i].MaHoaDonNhap == chitiethoadonnhap[j].MaHoaDonNhap)
                            {
                                for (int k = 0; k < hanghoa.Length; k++)
                                {
                                    if (chitiethoadonnhap[j].MaHangHoa == hanghoa[k].MaHangHoa)
                                    {
                                        int sl = chitiethoadonnhap[j].SoLuong;
                                        soluong += sl;
                                        Entities.BCNhapHangTheoThoiGianChiTiet ct = new Entities.BCNhapHangTheoThoiGianChiTiet(hoadonnhap[i].MaHoaDonNhap, "Hóa Đơn Nhập", hoadonnhap[i].NgayNhap, hanghoa[k].MaHangHoa, hanghoa[k].TenHangHoa, sl);
                                        hienthibaocao.Add(ct);
                                    }
                                }
                            }
                        }
                        Entities.BCNhapHangTheoThoiGian tg = new Entities.BCNhapHangTheoThoiGian(hoadonnhap[i].MaHoaDonNhap, "Hóa Đơn Nhập", hoadonnhap[i].NgayNhap, soluong);
                        hienthi.Add(tg);
                    }
                }
                // khách hàng trả lại
                for (int i = 0; i < khachhangtralai.Length; i++)
                {
                    int soluong = 0;
                    DateTime ngayphieu = khachhangtralai[i].NgayNhap;
                    if (ngayphieu >= truoc && ngayphieu <= sau)
                    {
                        for (int j = 0; j < chitietkhachhangtralai.Length; j++)
                        {
                            if (khachhangtralai[i].MaKhachHangTraLai == chitietkhachhangtralai[j].MaKhachHangTraLai)
                            {
                                for (int k = 0; k < hanghoa.Length; k++)
                                {
                                    if (!GoiHangOrHangHoa(chitietkhachhangtralai[j].MaHangHoa))
                                    {
                                        if (chitietkhachhangtralai[j].MaHangHoa == hanghoa[k].MaHangHoa)
                                        {
                                            int sl = chitietkhachhangtralai[j].SoLuong;
                                            soluong += sl;
                                            Entities.BCNhapHangTheoThoiGianChiTiet ct = new Entities.BCNhapHangTheoThoiGianChiTiet(khachhangtralai[i].MaKhachHangTraLai, "Khách Hàng Trả Lại", khachhangtralai[i].NgayNhap, hanghoa[k].MaHangHoa, hanghoa[k].TenHangHoa, sl);
                                            hienthibaocao.Add(ct);
                                        }
                                    }
                                    ////////////////////////////////////////////////MRK FIX
                                    else
                                    {//là gói hàng
                                        foreach (Entities.GoiHang gh in goihang)
                                        {
                                            foreach (Entities.ChiTietGoiHang ctgh in chitietgoihang)
                                            {
                                                if (gh.MaGoiHang.Equals(ctgh.MaGoiHang) && ctgh.MaGoiHang.Equals(chitietkhachhangtralai[j].MaHangHoa) && ctgh.MaHangHoa.Equals(hanghoa[k].MaHangHoa))
                                                {
                                                    int sl = chitietkhachhangtralai[j].SoLuong * ctgh.SoLuong;
                                                    soluong += sl;
                                                    Entities.BCNhapHangTheoThoiGianChiTiet ct = new Entities.BCNhapHangTheoThoiGianChiTiet(khachhangtralai[i].MaKhachHangTraLai, "Khách Hàng Trả Lại", khachhangtralai[i].NgayNhap, hanghoa[k].MaHangHoa + " (" + ctgh.MaGoiHang + ")", hanghoa[k].TenHangHoa, sl);
                                                    hienthibaocao.Add(ct);
                                                }
                                            }
                                        }
                                    }
                                    ////////////////////////////////////////////////MRK FIX
                                }
                            }
                        }
                        Entities.BCNhapHangTheoThoiGian tg = new Entities.BCNhapHangTheoThoiGian(khachhangtralai[i].MaKhachHangTraLai, "Khách Hàng Trả Lại", khachhangtralai[i].NgayNhap, soluong);
                        hienthi.Add(tg);
                    }
                }

                ///////////////////////////////MRK FIX
                List<Entities.BCNhapHangTheoThoiGian> tem0 = new List<Entities.BCNhapHangTheoThoiGian>();
                int tong0 = 0;
                foreach (Entities.BCNhapHangTheoThoiGian item in hienthi.ToArray())
                {
                    tong0 += item.SoLuong;
                    tem0.Add(item);
                }
                Entities.BCNhapHangTheoThoiGian tem1 = new Entities.BCNhapHangTheoThoiGian();
                tem1.TenChungTu = "Tổng: ";
                tem1.SoLuong = tong0;
                tem0.Add(tem1);
                //////////////////////////////////////
                //dtgvhienthi.DataSource = hienthi;
                dtgvHienThi.DataSource = tem0.ToArray();

                if (hienthi.ToArray().Length > 0)
                {
                    tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = true;
                }
                else
                {
                    tsslexcel.Enabled = tsslPdf.Enabled = tsslWord.Enabled = tsslchitiet.Enabled = false;
                }
                fix();
            }
            catch
            {
            }
        }