示例#1
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();
     }
 }
 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();
            }
        }
示例#5
0
        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();
            }
        }
示例#6
0
        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];
            }
        }