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 { } }