// GET: ReportOverview public ActionResult Index() { const int startDay = 1; int month = DateTime.Now.Month; int year = DateTime.Now.Year; DateTime thisMonthStart = new DateTime(year, month, startDay, 0, 0, 0); DateTime thisMontEnd = new DateTime(year, month + 1, startDay, 0, 0, 0); foreach (string key in Session.Keys) { if (key.Contains("dbName" + Request.QueryString["name"] + Request.QueryString["plc"])) { DB = Session[key].ToString(); } if (key.Contains("tableName" + Request.QueryString["name"] + Request.QueryString["plc"])) { table = Session[key].ToString(); } if (key.Contains("congirationNumber" + Request.QueryString["name"] + Request.QueryString["plc"])) { configrationNumber = int.Parse(Session[key].ToString()); } } ReportDBHelper db = new ReportDBHelper(DB, 2); OverviewReportModel data = db.SelectConsumption(thisMonthStart, thisMontEnd, table); ViewBag.month = month; ViewBag.year = year; return(View(data)); }
public ActionResult Month(int year, int month) { const int startDay = 1; DateTime thisMonthStart = new DateTime(year, month, startDay, 0, 0, 0); DateTime thisMontEnd = new DateTime(year, month + 1, startDay, 0, 0, 0); ReportDBHelper db = new ReportDBHelper(DB, 2); OverviewReportModel data = db.SelectConsumption(thisMonthStart, thisMontEnd, table); ViewBag.month = month; ViewBag.year = year; return(View("Index", data)); }