private void rdbtimkiem3_CheckedChanged(object sender, EventArgs e) { if (rdbtimkiem3.Checked) { if (hienthi != null) { ///////////////////////////////MRK FIX List <Entities.BCXuatNhapTonTheoNhomHang> tem0 = new List <Entities.BCXuatNhapTonTheoNhomHang>(); double tong0 = 0; double tong1 = 0; double tong2 = 0; double tong3 = 0; foreach (Entities.BCXuatNhapTonTheoNhomHang item in hienthi) { tong0 += double.Parse(item.SoDuDauKy); tong1 += double.Parse(item.TongNhap); tong2 += double.Parse(item.TongXuat); tong3 += double.Parse(item.SoDuCuoiKy); tem0.Add(item); } Entities.BCXuatNhapTonTheoNhomHang tem1 = new Entities.BCXuatNhapTonTheoNhomHang(); tem1.TenNhomHang = "Tổng: "; tem1.SoDuDauKy = tong0.ToString(); tem1.TongNhap = tong1.ToString(); tem1.TongXuat = tong2.ToString(); tem1.SoDuCuoiKy = tong3.ToString(); tem0.Add(tem1); ////////////////////////////////////// //dtgvhienthi.DataSource = hienthi; dtgvhienthi.DataSource = tem0.ToArray(); dtgvhienthi.DataSource = hienthi; } else { dtgvhienthi.DataSource = new Entities.BCNhapHangTheoMatHang[0]; } dtgvhienthi.Refresh(); fix(); } }
private void txttimkiem_TextChanged(object sender, EventArgs e) { if (rdbtimkiem3.Checked || hienthi == null) return; else if (hienthi.Length == 0) return; if (txttimkiem.Text.Equals("")) { dtgvhienthi.DataSource = new Entities.BCXuatNhapTonTheoNhomHang[0]; return; } ArrayList arr = new ArrayList(); if (rdbtimkiem1.Checked) { foreach (Entities.BCXuatNhapTonTheoNhomHang item in hienthi) { if (item.MaNhomHang.ToLower().IndexOf(txttimkiem.Text.ToLower()) > -1) { arr.Add(item); } } } else if (rdbtimkiem2.Checked) { foreach (Entities.BCXuatNhapTonTheoNhomHang item in hienthi) { if (item.TenNhomHang.ToLower().IndexOf(txttimkiem.Text.ToLower()) > -1) { arr.Add(item); } } } if (arr.Count > 0) { Entities.BCXuatNhapTonTheoNhomHang[] temp = new Entities.BCXuatNhapTonTheoNhomHang[arr.Count]; for (int i = 0; i < temp.Length; i++) { temp[i] = (Entities.BCXuatNhapTonTheoNhomHang)arr[i]; temp[i].HanhDong = (i + 1).ToString(); } ///////////////////////////////MRK FIX List<Entities.BCXuatNhapTonTheoNhomHang> tem0 = new List<Entities.BCXuatNhapTonTheoNhomHang>(); double tong0 = 0; double tong1 = 0; double tong2 = 0; double tong3 = 0; foreach (Entities.BCXuatNhapTonTheoNhomHang item in temp) { tong0 += double.Parse(item.SoDuDauKy); tong1 += double.Parse(item.TongNhap); tong2 += double.Parse(item.TongXuat); tong3 += double.Parse(item.SoDuCuoiKy); tem0.Add(item); } Entities.BCXuatNhapTonTheoNhomHang tem1 = new Entities.BCXuatNhapTonTheoNhomHang(); tem1.TenNhomHang = "Tổng: "; tem1.SoDuDauKy = tong0.ToString(); tem1.TongNhap = tong1.ToString(); tem1.TongXuat = tong2.ToString(); tem1.SoDuCuoiKy = tong3.ToString(); tem0.Add(tem1); ////////////////////////////////////// //dtgvhienthi.DataSource = temp; dtgvhienthi.DataSource = tem0.ToArray(); } else { dtgvhienthi.DataSource = new Entities.BCXuatNhapTonTheoNhomHang[0]; } }
private void rdbtimkiem3_CheckedChanged(object sender, EventArgs e) { if (rdbtimkiem3.Checked) { if (hienthi != null) { ///////////////////////////////MRK FIX List<Entities.BCXuatNhapTonTheoNhomHang> tem0 = new List<Entities.BCXuatNhapTonTheoNhomHang>(); double tong0 = 0; double tong1 = 0; double tong2 = 0; double tong3 = 0; foreach (Entities.BCXuatNhapTonTheoNhomHang item in hienthi) { tong0 += double.Parse(item.SoDuDauKy); tong1 += double.Parse(item.TongNhap); tong2 += double.Parse(item.TongXuat); tong3 += double.Parse(item.SoDuCuoiKy); tem0.Add(item); } Entities.BCXuatNhapTonTheoNhomHang tem1 = new Entities.BCXuatNhapTonTheoNhomHang(); tem1.TenNhomHang = "Tổng: "; tem1.SoDuDauKy = tong0.ToString(); tem1.TongNhap = tong1.ToString(); tem1.TongXuat = tong2.ToString(); tem1.SoDuCuoiKy = tong3.ToString(); tem0.Add(tem1); ////////////////////////////////////// //dtgvhienthi.DataSource = hienthi; dtgvhienthi.DataSource = tem0.ToArray(); dtgvhienthi.DataSource = hienthi; } else { dtgvhienthi.DataSource = new Entities.BCNhapHangTheoMatHang[0]; } dtgvhienthi.Refresh(); fix(); } }
public void TongTienNhanVien() { try { int i = 0; ArrayList arr = new ArrayList(); ArrayList arrbaocao = new ArrayList(); Entities.HangHoa[] hh = Common.Utilities.CheckGoiHang(hanghoa, goihang, chitietgoihang); foreach (Entities.NhomHang item in nhomhang) { int dudauky = 0, ducuoiky = 0, tongxuat = 0, tongnhap = 0; // lay hang hoa theo nhom var queryhh = from h in hanghoa where h.MaNhomHangHoa.Equals(item.MaNhomHang) select h; Entities.HangHoa[] hanghoaArr = queryhh.ToArray(); foreach (Entities.HangHoa item1 in hanghoaArr) { int nhapmua = 0, nhaptralai = 0, nhapkhac = 0, xuatban = 0, xuattralai = 0, xuatkhac = 0, sodudauky = 0, soducuoiky = 0; //// so kho foreach (Entities.SoDuKho item2 in sodukho) { if (item2.MaHangHoa == item1.MaHangHoa && item2.NgayKetChuyen.Month == thang && item2.NgayKetChuyen.Year == nam) { dudauky += item2.SoDuDauKy; sodudauky += item2.SoDuDauKy; } } // lay cac phieu xuat huy trong thang var querypxh = from pxh in phieuxuathuy where nam.Equals(pxh.NgayLap.Year) && thang.Equals(pxh.NgayLap.Month) && pxh.TrangThai.Equals(true) select pxh; Entities.PhieuXuatHuy[] phieuxuathuyArr = querypxh.ToArray(); // lay chitietphieuxuathuy var queryctpxh = from s1 in phieuxuathuyArr join s2 in chitietxuathuy on s1.MaPhieuXuatHuy equals s2.MaPhieuXuatHuy select s2; Entities.ChiTietXuatHuy[] chitietxuathuyArr = queryctpxh.ToArray(); foreach (Entities.ChiTietXuatHuy item3 in chitietxuathuyArr) { if (item1.MaHangHoa.Equals(item3.MaHangHoa)) { tongxuat += item3.SoLuong; xuatkhac += item3.SoLuong; } } // xuất hàng - hóa đơn bán hàng var querybanhang = from bh in hdbanhang where bh.NgayBan.Month.Equals(thang) && bh.NgayBan.Year.Equals(nam) select bh; Entities.HDBanHang[] hdbanhangArr = querybanhang.ToArray(); // lay ct hoa don ban hang var queryctbanhang = from s1 in hdbanhangArr join s2 in chitiethdbanhang on s1.MaHDBanHang equals s2.MaHDBanHang select s2; Entities.ChiTietHDBanHang[] chitiethdbanhangArr = queryctbanhang.ToArray(); foreach (Entities.ChiTietHDBanHang item3 in chitiethdbanhangArr) { if (item1.MaHangHoa.Equals(item3.MaHangHoa)) { tongxuat += item3.SoLuong; xuatban += item3.SoLuong; } else { foreach (Entities.ChiTietGoiHang item5 in chitietgoihang) { if (item5.MaGoiHang.Equals(item3.MaHangHoa)) { if (item1.MaHangHoa.Equals(item5.MaHangHoa)) { tongxuat += (item5.SoLuong * item3.SoLuong); xuatban += (item5.SoLuong * item3.SoLuong); } } } } } // Tra lai ncc var querytralaincc = from tl in tralaincc where tl.Ngaytra.Month.Equals(thang) && tl.Ngaytra.Year.Equals(nam) select tl; Entities.TraLaiNCC[] tralainccArr = querytralaincc.ToArray(); // lay chitiet tra lai ncc var querycttralaincc = from s1 in tralainccArr join s2 in chitiettralaincc on s1.MaHDTraLaiNCC equals s2.MaHDTraLaiNCC select s2; Entities.ChiTietTraLaiNhaCungCap[] cttralainccArr = querycttralaincc.ToArray(); foreach (Entities.ChiTietTraLaiNhaCungCap item3 in cttralainccArr) { if (item1.MaHangHoa.Equals(item3.MaHangHoa)) { tongxuat += item3.SoLuong; xuattralai += item3.SoLuong; } } // nhập hàng - hóa đơn nhập var queryhoadonnhap = from nh in hoadonnhap where nh.NgayNhap.Month.Equals(thang) && nh.NgayNhap.Year.Equals(nam) select nh; Entities.HoaDonNhap[] hoadonnhapArr = queryhoadonnhap.ToArray(); // lay chitiet hoa don nhap var querycthoadonnhap = from s1 in hoadonnhap join s2 in chitiethoadonnhap on s1.MaHoaDonNhap equals s2.MaHoaDonNhap select s2; Entities.ChiTietHoaDonNhap[] cthoadonnhapArr = querycthoadonnhap.ToArray(); foreach (Entities.ChiTietHoaDonNhap item3 in cthoadonnhapArr) { if (item3.MaHangHoa == item1.MaHangHoa) { tongnhap += item3.SoLuong; nhapmua += item3.SoLuong; } } // nhập hàng - khách hàng trả lại var querykhachhangtralai = from tl in khachhangtralai where tl.NgayNhap.Month.Equals(thang) && tl.NgayNhap.Year.Equals(nam) select tl; Entities.KhachHangTraLai[] khachhangtralaiArr = querykhachhangtralai.ToArray(); // lay chi tiet khach hang tra lai var queryctkhtralai = from s1 in khachhangtralaiArr join s2 in chitietkhachhangtralai on s1.MaKhachHangTraLai equals s2.MaKhachHangTraLai select s2; Entities.ChiTietKhachHangTraLai[] ctkhtralaiArr = queryctkhtralai.ToArray(); foreach (Entities.ChiTietKhachHangTraLai item3 in ctkhtralaiArr) { if (item1.MaHangHoa.Equals(item3.MaHangHoa)) { tongnhap += item3.SoLuong; nhaptralai += item3.SoLuong; } else { foreach (Entities.ChiTietGoiHang item5 in chitietgoihang) { if (item5.MaGoiHang.Equals(item3.MaHangHoa)) { if (item1.MaHangHoa.Equals(item5.MaHangHoa)) { tongnhap += (item5.SoLuong * item3.SoLuong); nhaptralai += (item5.SoLuong * item3.SoLuong); } } } } } soducuoiky = sodudauky + nhapmua + nhaptralai + nhapkhac - xuatban - xuatkhac - xuattralai; if (!(soducuoiky == 0 && sodudauky == 0 && nhapmua == 0 && nhaptralai == 0 && nhapkhac == 0 && xuatban == 0 && xuattralai == 0 && xuatkhac == 0)) arrbaocao.Add(new Entities.ChiTietBCXuatNhapTonTheoNhomHang(item.MaNhomHang, item.TenNhomHang, item1.MaHangHoa, item1.TenHangHoa, sodudauky, nhapmua, nhaptralai, nhapkhac, xuatban, xuattralai, xuatkhac, soducuoiky)); } ducuoiky = dudauky + tongnhap - tongxuat; if (!(dudauky == 0 && ducuoiky == 0 && tongnhap == 0 && tongxuat == 0)) { arr.Add(new Entities.BCXuatNhapTonTheoNhomHang(i.ToString(), item.MaNhomHang, item.TenNhomHang, dudauky.ToString(), tongnhap.ToString(), tongxuat.ToString(), ducuoiky.ToString())); i++; } } hienthi = (Entities.BCXuatNhapTonTheoNhomHang[])arr.ToArray(typeof(Entities.BCXuatNhapTonTheoNhomHang)); hienthibaocao = (Entities.ChiTietBCXuatNhapTonTheoNhomHang[])arrbaocao.ToArray(typeof(Entities.ChiTietBCXuatNhapTonTheoNhomHang)); ///////////////////////////////MRK FIX List<Entities.BCXuatNhapTonTheoNhomHang> tem0 = new List<Entities.BCXuatNhapTonTheoNhomHang>(); double tong0 = 0; double tong1 = 0; double tong2 = 0; double tong3 = 0; foreach (Entities.BCXuatNhapTonTheoNhomHang item in hienthi) { if (item == null) { continue; } tong0 += double.Parse(item.SoDuDauKy); tong1 += double.Parse(item.TongNhap); tong2 += double.Parse(item.TongXuat); tong3 += double.Parse(item.SoDuCuoiKy); tem0.Add(item); } Entities.BCXuatNhapTonTheoNhomHang tem1 = new Entities.BCXuatNhapTonTheoNhomHang(); tem1.TenNhomHang = "Tổng: "; tem1.SoDuDauKy = tong0.ToString(); tem1.TongNhap = tong1.ToString(); tem1.TongXuat = tong2.ToString(); tem1.SoDuCuoiKy = tong3.ToString(); tem0.Add(tem1); ////////////////////////////////////// //dtgvhienthi.DataSource = hienthi; dtgvhienthi.DataSource = tem0.ToArray(); if (hienthi.Length > 0) { enable(); } else { disable(); } } catch { } finally { fix(); } }
public void TongTienNhanVien() { try { int i = 0; ArrayList arr = new ArrayList(); ArrayList arrbaocao = new ArrayList(); Entities.HangHoa[] hh = Common.Utilities.CheckGoiHang(hanghoa, goihang, chitietgoihang); foreach (Entities.NhomHang item in nhomhang) { int dudauky = 0, ducuoiky = 0, tongxuat = 0, tongnhap = 0; // lay hang hoa theo nhom var queryhh = from h in hanghoa where h.MaNhomHangHoa.Equals(item.MaNhomHang) select h; Entities.HangHoa[] hanghoaArr = queryhh.ToArray(); foreach (Entities.HangHoa item1 in hanghoaArr) { int nhapmua = 0, nhaptralai = 0, nhapkhac = 0, xuatban = 0, xuattralai = 0, xuatkhac = 0, sodudauky = 0, soducuoiky = 0; //// so kho foreach (Entities.SoDuKho item2 in sodukho) { if (item2.MaHangHoa == item1.MaHangHoa && item2.NgayKetChuyen.Month == thang && item2.NgayKetChuyen.Year == nam) { dudauky += item2.SoDuDauKy; sodudauky += item2.SoDuDauKy; } } // lay cac phieu xuat huy trong thang var querypxh = from pxh in phieuxuathuy where nam.Equals(pxh.NgayLap.Year) && thang.Equals(pxh.NgayLap.Month) && pxh.TrangThai.Equals(true) select pxh; Entities.PhieuXuatHuy[] phieuxuathuyArr = querypxh.ToArray(); // lay chitietphieuxuathuy var queryctpxh = from s1 in phieuxuathuyArr join s2 in chitietxuathuy on s1.MaPhieuXuatHuy equals s2.MaPhieuXuatHuy select s2; Entities.ChiTietXuatHuy[] chitietxuathuyArr = queryctpxh.ToArray(); foreach (Entities.ChiTietXuatHuy item3 in chitietxuathuyArr) { if (item1.MaHangHoa.Equals(item3.MaHangHoa)) { tongxuat += item3.SoLuong; xuatkhac += item3.SoLuong; } } // xuất hàng - hóa đơn bán hàng var querybanhang = from bh in hdbanhang where bh.NgayBan.Month.Equals(thang) && bh.NgayBan.Year.Equals(nam) select bh; Entities.HDBanHang[] hdbanhangArr = querybanhang.ToArray(); // lay ct hoa don ban hang var queryctbanhang = from s1 in hdbanhangArr join s2 in chitiethdbanhang on s1.MaHDBanHang equals s2.MaHDBanHang select s2; Entities.ChiTietHDBanHang[] chitiethdbanhangArr = queryctbanhang.ToArray(); foreach (Entities.ChiTietHDBanHang item3 in chitiethdbanhangArr) { if (item1.MaHangHoa.Equals(item3.MaHangHoa)) { tongxuat += item3.SoLuong; xuatban += item3.SoLuong; } else { foreach (Entities.ChiTietGoiHang item5 in chitietgoihang) { if (item5.MaGoiHang.Equals(item3.MaHangHoa)) { if (item1.MaHangHoa.Equals(item5.MaHangHoa)) { tongxuat += (item5.SoLuong * item3.SoLuong); xuatban += (item5.SoLuong * item3.SoLuong); } } } } } // Tra lai ncc var querytralaincc = from tl in tralaincc where tl.Ngaytra.Month.Equals(thang) && tl.Ngaytra.Year.Equals(nam) select tl; Entities.TraLaiNCC[] tralainccArr = querytralaincc.ToArray(); // lay chitiet tra lai ncc var querycttralaincc = from s1 in tralainccArr join s2 in chitiettralaincc on s1.MaHDTraLaiNCC equals s2.MaHDTraLaiNCC select s2; Entities.ChiTietTraLaiNhaCungCap[] cttralainccArr = querycttralaincc.ToArray(); foreach (Entities.ChiTietTraLaiNhaCungCap item3 in cttralainccArr) { if (item1.MaHangHoa.Equals(item3.MaHangHoa)) { tongxuat += item3.SoLuong; xuattralai += item3.SoLuong; } } // nhập hàng - hóa đơn nhập var queryhoadonnhap = from nh in hoadonnhap where nh.NgayNhap.Month.Equals(thang) && nh.NgayNhap.Year.Equals(nam) select nh; Entities.HoaDonNhap[] hoadonnhapArr = queryhoadonnhap.ToArray(); // lay chitiet hoa don nhap var querycthoadonnhap = from s1 in hoadonnhap join s2 in chitiethoadonnhap on s1.MaHoaDonNhap equals s2.MaHoaDonNhap select s2; Entities.ChiTietHoaDonNhap[] cthoadonnhapArr = querycthoadonnhap.ToArray(); foreach (Entities.ChiTietHoaDonNhap item3 in cthoadonnhapArr) { if (item3.MaHangHoa == item1.MaHangHoa) { tongnhap += item3.SoLuong; nhapmua += item3.SoLuong; } } // nhập hàng - khách hàng trả lại var querykhachhangtralai = from tl in khachhangtralai where tl.NgayNhap.Month.Equals(thang) && tl.NgayNhap.Year.Equals(nam) select tl; Entities.KhachHangTraLai[] khachhangtralaiArr = querykhachhangtralai.ToArray(); // lay chi tiet khach hang tra lai var queryctkhtralai = from s1 in khachhangtralaiArr join s2 in chitietkhachhangtralai on s1.MaKhachHangTraLai equals s2.MaKhachHangTraLai select s2; Entities.ChiTietKhachHangTraLai[] ctkhtralaiArr = queryctkhtralai.ToArray(); foreach (Entities.ChiTietKhachHangTraLai item3 in ctkhtralaiArr) { if (item1.MaHangHoa.Equals(item3.MaHangHoa)) { tongnhap += item3.SoLuong; nhaptralai += item3.SoLuong; } else { foreach (Entities.ChiTietGoiHang item5 in chitietgoihang) { if (item5.MaGoiHang.Equals(item3.MaHangHoa)) { if (item1.MaHangHoa.Equals(item5.MaHangHoa)) { tongnhap += (item5.SoLuong * item3.SoLuong); nhaptralai += (item5.SoLuong * item3.SoLuong); } } } } } soducuoiky = sodudauky + nhapmua + nhaptralai + nhapkhac - xuatban - xuatkhac - xuattralai; if (!(soducuoiky == 0 && sodudauky == 0 && nhapmua == 0 && nhaptralai == 0 && nhapkhac == 0 && xuatban == 0 && xuattralai == 0 && xuatkhac == 0)) { arrbaocao.Add(new Entities.ChiTietBCXuatNhapTonTheoNhomHang(item.MaNhomHang, item.TenNhomHang, item1.MaHangHoa, item1.TenHangHoa, sodudauky, nhapmua, nhaptralai, nhapkhac, xuatban, xuattralai, xuatkhac, soducuoiky)); } } ducuoiky = dudauky + tongnhap - tongxuat; if (!(dudauky == 0 && ducuoiky == 0 && tongnhap == 0 && tongxuat == 0)) { arr.Add(new Entities.BCXuatNhapTonTheoNhomHang(i.ToString(), item.MaNhomHang, item.TenNhomHang, dudauky.ToString(), tongnhap.ToString(), tongxuat.ToString(), ducuoiky.ToString())); i++; } } hienthi = (Entities.BCXuatNhapTonTheoNhomHang[])arr.ToArray(typeof(Entities.BCXuatNhapTonTheoNhomHang)); hienthibaocao = (Entities.ChiTietBCXuatNhapTonTheoNhomHang[])arrbaocao.ToArray(typeof(Entities.ChiTietBCXuatNhapTonTheoNhomHang)); ///////////////////////////////MRK FIX List <Entities.BCXuatNhapTonTheoNhomHang> tem0 = new List <Entities.BCXuatNhapTonTheoNhomHang>(); double tong0 = 0; double tong1 = 0; double tong2 = 0; double tong3 = 0; foreach (Entities.BCXuatNhapTonTheoNhomHang item in hienthi) { if (item == null) { continue; } tong0 += double.Parse(item.SoDuDauKy); tong1 += double.Parse(item.TongNhap); tong2 += double.Parse(item.TongXuat); tong3 += double.Parse(item.SoDuCuoiKy); tem0.Add(item); } Entities.BCXuatNhapTonTheoNhomHang tem1 = new Entities.BCXuatNhapTonTheoNhomHang(); tem1.TenNhomHang = "Tổng: "; tem1.SoDuDauKy = tong0.ToString(); tem1.TongNhap = tong1.ToString(); tem1.TongXuat = tong2.ToString(); tem1.SoDuCuoiKy = tong3.ToString(); tem0.Add(tem1); ////////////////////////////////////// //dtgvhienthi.DataSource = hienthi; dtgvhienthi.DataSource = tem0.ToArray(); if (hienthi.Length > 0) { enable(); } else { disable(); } } catch { } finally { fix(); } }
private void txttimkiem_TextChanged(object sender, EventArgs e) { if (rdbtimkiem3.Checked || hienthi == null) { return; } else if (hienthi.Length == 0) { return; } if (txttimkiem.Text.Equals("")) { dtgvhienthi.DataSource = new Entities.BCXuatNhapTonTheoNhomHang[0]; return; } ArrayList arr = new ArrayList(); if (rdbtimkiem1.Checked) { foreach (Entities.BCXuatNhapTonTheoNhomHang item in hienthi) { if (item.MaNhomHang.ToLower().IndexOf(txttimkiem.Text.ToLower()) > -1) { arr.Add(item); } } } else if (rdbtimkiem2.Checked) { foreach (Entities.BCXuatNhapTonTheoNhomHang item in hienthi) { if (item.TenNhomHang.ToLower().IndexOf(txttimkiem.Text.ToLower()) > -1) { arr.Add(item); } } } if (arr.Count > 0) { Entities.BCXuatNhapTonTheoNhomHang[] temp = new Entities.BCXuatNhapTonTheoNhomHang[arr.Count]; for (int i = 0; i < temp.Length; i++) { temp[i] = (Entities.BCXuatNhapTonTheoNhomHang)arr[i]; temp[i].HanhDong = (i + 1).ToString(); } ///////////////////////////////MRK FIX List <Entities.BCXuatNhapTonTheoNhomHang> tem0 = new List <Entities.BCXuatNhapTonTheoNhomHang>(); double tong0 = 0; double tong1 = 0; double tong2 = 0; double tong3 = 0; foreach (Entities.BCXuatNhapTonTheoNhomHang item in temp) { tong0 += double.Parse(item.SoDuDauKy); tong1 += double.Parse(item.TongNhap); tong2 += double.Parse(item.TongXuat); tong3 += double.Parse(item.SoDuCuoiKy); tem0.Add(item); } Entities.BCXuatNhapTonTheoNhomHang tem1 = new Entities.BCXuatNhapTonTheoNhomHang(); tem1.TenNhomHang = "Tổng: "; tem1.SoDuDauKy = tong0.ToString(); tem1.TongNhap = tong1.ToString(); tem1.TongXuat = tong2.ToString(); tem1.SoDuCuoiKy = tong3.ToString(); tem0.Add(tem1); ////////////////////////////////////// //dtgvhienthi.DataSource = temp; dtgvhienthi.DataSource = tem0.ToArray(); } else { dtgvhienthi.DataSource = new Entities.BCXuatNhapTonTheoNhomHang[0]; } }