public ActionResult TongGiaTriTheoTrangThaiDonHang(string StartTime, string EndTime) { DateTime _tungay = DateTime.Now; if (!string.IsNullOrEmpty(StartTime) || !string.IsNullOrWhiteSpace(StartTime)) { _tungay = TypeHelper.ToDate(StartTime); } DateTime _denngay = DateTime.Now; if (!string.IsNullOrEmpty(EndTime) || !string.IsNullOrWhiteSpace(EndTime)) { _denngay = TypeHelper.ToDate(EndTime); } shOrderService _order = new shOrderService(); IEnumerable <shOrder> dsDonHang = _order.DanhSachOrder_TheoThoiGian(_tungay, _denngay); List <BieuDoDonHang> ds = new List <BieuDoDonHang>(); BieuDoDonHang donhang = new BieuDoDonHang(); // 1. Đang xử lý IEnumerable <shOrder> dsTheoTrangThai = _order.DanhSachOrder_ByStatus( dsDonHang, null, OrderStatus.DangXuLy.GetHashCode()); ds.Add(VeBieuDoKinhDoanh(dsTheoTrangThai, "Đang xử lý")); // 2 . Đang giao hàng dsTheoTrangThai = _order.DanhSachOrder_ByStatus( dsDonHang, null, OrderStatus.DangGiaoHang.GetHashCode()); ds.Add(VeBieuDoKinhDoanh(dsTheoTrangThai, "Đang giao hàng")); // Đã giao hàng dsTheoTrangThai = _order.DanhSachOrder_ByStatus( dsDonHang, null, OrderStatus.DaGiaoHang_ChuaXacNhan.GetHashCode()); ds.Add(VeBieuDoKinhDoanh(dsTheoTrangThai, "Đã giao hàng")); // Đã Hủy dsTheoTrangThai = _order.DanhSachOrder_ByStatus( dsDonHang, null, OrderStatus.HuyDonHang.GetHashCode()); ds.Add(VeBieuDoKinhDoanh(dsTheoTrangThai, "Đã hủy")); if (Request.IsAjaxRequest()) { return(Json(ds, JsonRequestBehavior.AllowGet)); } return(PartialView("TongGiaTriTheoTrangThaiDonHang", dsDonHang)); }
public void LoadDuLieu(string StartTime, string EndTime) { DateTime _tungay = DateTime.Now; if (!string.IsNullOrEmpty(StartTime) || !string.IsNullOrWhiteSpace(StartTime)) { _tungay = TypeHelper.ToDate(StartTime); } DateTime _denngay = DateTime.Now; if (!string.IsNullOrEmpty(EndTime) || !string.IsNullOrWhiteSpace(EndTime)) { _denngay = TypeHelper.ToDate(EndTime); } #region Tổng số đơn hàng shOrderService _order = new shOrderService(); IEnumerable <shOrder> dsDonHang = _order.DanhSachOrder_TheoThoiGian(_tungay, _denngay); @ViewBag.TongSoDonHang = dsDonHang.Count(); decimal tonggiatri = 0M; foreach (var item in dsDonHang) { tonggiatri += item.Total.GetValueOrDefault(0) - item.FeeShip.GetValueOrDefault(0); } @ViewBag.TongGiaTri = Format.FormatDecimalToString(tonggiatri); #endregion #region Doanh thu IEnumerable <shOrder> dsDonhangHoanThanh = dsDonHang.Where(x => x.OrderStatus == OrderStatus.DaGiaoHang_ChuaXacNhan.GetHashCode() || x.OrderStatus == OrderStatus.DaGiaoHang_DaXacNhan.GetHashCode()); @ViewBag.DonHoanThanh = dsDonhangHoanThanh.Count(); tonggiatri = 0M; foreach (var item in dsDonhangHoanThanh) { tonggiatri += item.Total.GetValueOrDefault(0) - item.FeeShip.GetValueOrDefault(0); } @ViewBag.DoanhThu = Format.FormatDecimalToString(tonggiatri); #endregion @ViewBag.DonHangHuy = dsDonHang.Where(x => x.OrderStatus == OrderStatus.HuyDonHang.GetHashCode()).Count(); ViewBag.StartEnd = _tungay.ToString("dd/MM/yyyy") + " - " + _denngay.ToString("dd/MM/yyyy"); ViewBag.StartTime = _tungay.ToString("dd/MM/yyyy"); ViewBag.EndTime = _denngay.ToString("dd/MM/yyyy"); }