//報表查詢呼叫ajax用
public ActionResult ATMApplySQLOperation(string SDate, string EDate, Models.ATMApply atmsapply, int?page)
{
int pagesize = 25;
AfiscIVREntities db = new AfiscIVREntities();
String format = "yyyy-MM-dd";
DateTime SDay = DateTime.ParseExact(SDate, format, null);
DateTime EDay = DateTime.ParseExact(EDate, format, null);
var atmapplyObj = from s in db.ATMApply where s.CreateTime >= SDay && s.CreateTime <= EDay select s;
int pageNumber = page ?? 1;
atmapplyObj = atmapplyObj.OrderBy(x => x.SN);
IPagedList <ATMApply> PagedList = atmapplyObj.ToPagedList(1, pagesize);
ViewBag.Page = page;
return(Json(PagedList));
}
//系統參數設定 SystemParameters
public ActionResult SystemParameters()
{
AfiscIVREntities db = new AfiscIVREntities();
return(View(db.SMSSystemParameters.First()));
}
