/// <summary>
/// Cache item until absolute expiration THIS YEAR / THIS MONTH / 01 @ 17h45
/// </summary>
/// <param name="day">1</param>
/// <param name="hour">17</param>
/// <param name="minute">45</param>
/// <param name="second">0</param>
public CacheOutputUntilThisMonthAttribute(int day,
int hour = 0,
int minute = 0,
int second = 0)
{
CacheTimeQuery = new ThisMonth(day, hour, minute, second);
}
/// <summary>
/// Cache item until absolute expiration THIS YEAR / THIS MONTH / 01 @ 17h45
/// </summary>
/// <param name="day">1</param>
/// <param name="hour">17</param>
/// <param name="minute">45</param>
/// <param name="second">0</param>
public CacheOutputUntilThisMonthAttribute(int day,
int hour = 0,
int minute = 0,
int second = 0)
{
CacheTimeQuery = new ThisMonth(day, hour, minute, second);
}
public ActionResult DeleteConfirmed(int id)
{
ThisMonth thisMonth = db.ThisMonths.Find(id);
db.ThisMonths.Remove(thisMonth);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Salary_Balance,Amount_Spent,ExpenseTrackerId")] ThisMonth thisMonth)
{
if (ModelState.IsValid)
{
db.Entry(thisMonth).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ExpenseTrackerId = new SelectList(db.ExpenseTrackers, "Id", "Name", thisMonth.ExpenseTrackerId);
return(View(thisMonth));
}
// GET: ThisMonths/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ThisMonth thisMonth = db.ThisMonths.Find(id);
if (thisMonth == null)
{
return(HttpNotFound());
}
return(View(thisMonth));
}
// GET: ThisMonths/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ThisMonth thisMonth = db.ThisMonths.Find(id);
if (thisMonth == null)
{
return(HttpNotFound());
}
ViewBag.ExpenseTrackerId = new SelectList(db.ExpenseTrackers, "Id", "Name", thisMonth.ExpenseTrackerId);
return(View(thisMonth));
}
protected void PageInit()
{
//昨日
Yestoday.DataSource = Query(o => o.date.Date == DateTime.Now.AddDays(-1).Date&& o.paid == true && o.price1 >= 1, out yestodyDaySales, out yestodyTotal);
Yestoday.DataBind();
//七天前
ServerDays.DataSource = Query(o => o.date.Date >= DateTime.Now.AddDays(-7).Date&& o.paid == true && o.price1 >= 1, out serverDaySales, out serverTotal);
ServerDays.DataBind();
//上月
LastMonth.DataSource = Query(o => o.date.Year == DateTime.Now.AddMonths(-1).Year&& o.date.Month == DateTime.Now.AddMonths(-1).Month&& o.paid == true && o.price1 >= 1, out lastMonthDaySales, out lastMonthTotal);
LastMonth.DataBind();
//本月
ThisMonth.DataSource = Query(o => o.date.Year == DateTime.Now.Year && o.date.Month == DateTime.Now.Month && o.date.Day >= 1 && o.paid == true && o.price1 >= 1, out thisMonthDaySales, out thisMonthTotal);
ThisMonth.DataBind();
//今年
ThisYear.DataSource = Query(o => o.date.Year == DateTime.Now.Year && o.paid == true && o.price1 >= 1, out thisYearDaySales, out thisYearTotal);
ThisYear.DataBind();
//全部
AllGoods.DataSource = Query(o => o.paid == true && o.price1 >= 1, out allDaySales, out allTotal);
AllGoods.DataBind();
}
