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");
}