public ActionResult XuliBaoCaoSanLuongDoanhThu(FormCollection form, int type)
{
int month = String.IsNullOrEmpty(form["m1"]) ? DateTime.Now.Month : Convert.ToInt32(form["m1"]);
int year = String.IsNullOrEmpty(form["y1"]) ? DateTime.Now.Year : Convert.ToInt32(form["y1"]);
ControllerBase <BaoCaoSanLuongDoanhThu> cB = new ControllerBase <BaoCaoSanLuongDoanhThu>();
//type = 0 => quận
if (type == 0)
{
int quanHuyenID = String.IsNullOrEmpty(form["quan"]) ? 0 : Convert.ToInt32(form["quan"]);
if (quanHuyenID == 0)
{
BaoCaoSanLuongDoanhThu bc = cB.Query("BaoCaoSanLuongKinhDoanhTaiVu",
new SqlParameter("@thang", month),
new SqlParameter("@nam", year)).First();
ViewData["baoCaoSanLuongDoanhThu"] = bc;
}
else
{
BaoCaoSanLuongDoanhThu bc = cB.Query("BaoCaoSanLuongKinhDoanhTaiVuTheoQuan",
new SqlParameter("@thang", month),
new SqlParameter("@nam", year),
new SqlParameter("@quan", quanHuyenID),
new SqlParameter("@d2", 0.05)).First();
ViewData["baoCaoSanLuongDoanhThu"] = bc;
}
ViewBag.tenQuanHuyen = baoCaoSanLuongDoanhThu.getTieuDeSanLuongDoanhThu(quanHuyenID);
}
//type = 1 => tuyến
if (type == 1)
{
String dsTuyen = !String.IsNullOrEmpty(form["tuyen"]) ? form["tuyen"] : "";
BaoCaoSanLuongDoanhThu bc = cB.Query("BaoCaoSanLuongKinhDoanhTaiVuTheoTuyen",
new SqlParameter("@thang", month),
new SqlParameter("@nam", year),
new SqlParameter("@d2", 0.05),
new SqlParameter("@list", dsTuyen)).FirstOrDefault();
ViewData["baoCaoSanLuongDoanhThu"] = bc;
ViewBag.tenQuanHuyen = baoCaoSanLuongDoanhThu.getTieuDeSanLuongDoanhThu(0);
if (String.IsNullOrEmpty(dsTuyen))
{
ViewBag.selectedTuyens = "Tất cả các tuyến";
}
else
{
ViewBag.selectedTuyens = "Tuyến " + tuyenHelper.translateTuyenIDToMaTuyen(dsTuyen);
}
}
ViewBag.selectedMonth = month.ToString();
ViewBag.selectedYear = year.ToString();
return(View());
}
