示例#1
0
        public ActionResult Index()
        {
            //Khai báo biến
            SearchHoaDonBanHang    model             = new SearchHoaDonBanHang();
            CriterialHoaDonBanHang critHoaDonBanHang = new CriterialHoaDonBanHang();
            SumHoaDonBanHang       sumHoaDonBanHang  = new SumHoaDonBanHang();

            var hoadonBanHangs = db.HoaDonBanHang.OrderBy(p => p.thoigian).ToList();

            if (hoadonBanHangs.Count >= 1)
            {
                foreach (var value in hoadonBanHangs)
                {
                    value.thoigian = value.thoigian.Value.AddHours(7);
                }
            }

            //Default View
            ViewBag.nguoiban  = new SelectList(db.User.OrderBy(p => p.Name), "UserId", "Name");
            ViewBag.khachhang = new SelectList(db.KhachHang.OrderBy(p => p.ten), "id", "ten");

            //Footer
            sumHoaDonBanHang.tongTongTien  = hoadonBanHangs.Sum(p => p.tongTien);
            sumHoaDonBanHang.tongGiamGia   = hoadonBanHangs.Sum(p => p.giamgia);
            sumHoaDonBanHang.tongThanhToan = hoadonBanHangs.Sum(p => p.thanhtoan);

            //Model
            model.hoadonBanHangs   = hoadonBanHangs.ToList();
            model.sumHoaDonBanHang = sumHoaDonBanHang;

            //Export
            _hoadonBanHangs   = model.hoadonBanHangs.ToList();
            _sumHoaDonBanHang = model.sumHoaDonBanHang;

            return(View(model));
        }
示例#2
0
        public ActionResult Index([Bind(Include = "tuNgay,denNgay,nguoiban,khachhang")] CriterialHoaDonBanHang critHoaDonBanHang, FormCollection fc)
        {
            //Khai báo biến
            SearchHoaDonBanHang model            = new SearchHoaDonBanHang();
            SumHoaDonBanHang    sumHoaDonBanHang = new SumHoaDonBanHang();

            //Lấy giá trị từ form
            string khachhang = fc["khachhang"].ToString();
            string nguoiban  = fc["nguoiban"].ToString();

            DateTime?tuNgay;

            if (critHoaDonBanHang.tuNgay != null)
            {
                tuNgay = DateTime.Parse(critHoaDonBanHang.tuNgay.ToString());
            }
            else
            {
                tuNgay = db.HoaDonBanHang.OrderBy(p => p.thoigian).Select(p => p.thoigian).FirstOrDefault();
            }
            DateTime?denNgay;

            if (critHoaDonBanHang.denNgay != null)
            {
                denNgay = DateTime.Parse(critHoaDonBanHang.denNgay.ToString());
            }
            else
            {
                denNgay = DateTime.Now;
            }

            //Truy vấn
            var hoadonBanHangs = from c in db.HoaDonBanHang select c;

            {
                //Lọc theo Từ ngày
                if (!string.IsNullOrEmpty(tuNgay.ToString()))
                {
                    tuNgay = tuNgay.Value.AddHours(-7);

                    hoadonBanHangs = hoadonBanHangs.Where(p => p.thoigian >= tuNgay);
                }

                //Lọc theo Đến ngày
                if (!string.IsNullOrEmpty(denNgay.ToString()))
                {
                    denNgay        = denNgay.Value.AddHours(-7);
                    hoadonBanHangs = hoadonBanHangs.Where(p => p.thoigian <= denNgay);
                }

                //Lọc theo khách hàng
                if (!string.IsNullOrEmpty(khachhang.ToString()))
                {
                    int?temp = int.Parse(khachhang.ToString());
                    hoadonBanHangs = hoadonBanHangs.Where(p => p.idKhachHang == temp);
                }

                //Lọc theo người bán
                if (!string.IsNullOrEmpty(nguoiban.ToString()))
                {
                    int?temp = int.Parse(nguoiban.ToString());
                    hoadonBanHangs = hoadonBanHangs.Where(p => p.idNhanVien == temp);
                }
            }

            if (hoadonBanHangs.ToList().Count >= 1)
            {
                foreach (var value in hoadonBanHangs)
                {
                    value.thoigian = value.thoigian.Value.AddHours(7);
                }
            }

            //Default View
            ViewBag.nguoiban  = new SelectList(db.User.OrderBy(p => p.Name), "UserId", "Name", nguoiban);
            ViewBag.khachhang = new SelectList(db.KhachHang.OrderBy(p => p.ten), "id", "ten", khachhang);

            //Foottable
            sumHoaDonBanHang.tongTongTien  = hoadonBanHangs.Sum(p => p.tongTien);
            sumHoaDonBanHang.tongGiamGia   = hoadonBanHangs.Sum(p => p.giamgia);
            sumHoaDonBanHang.tongThanhToan = hoadonBanHangs.Sum(p => p.thanhtoan);

            //Model
            model.hoadonBanHangs    = hoadonBanHangs;
            model.critHoaDonBanHang = critHoaDonBanHang;
            model.sumHoaDonBanHang  = sumHoaDonBanHang;

            //Export
            _hoadonBanHangs   = model.hoadonBanHangs.ToList();
            _sumHoaDonBanHang = model.sumHoaDonBanHang;

            return(View(model));
        }