public ActionResult List(FormCollection collection, int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null)
{
//查詢參數
var qm = new EoUserEventLogQryModel();
var isOK = this.TryUpdateModel(qm);
var token = collection["__RequestVerificationToken"];
var dt = EoDataService.Instance.EoUserEventLog_getList(qm);
//排序
var dtSorted = dt.sort(jtSorting);
if (Request.IsAjaxRequest())
{
return(converToJTableSource(dtSorted, jtStartIndex, jtPageSize));
}
else
{
return(View(dt));
}
}
public EO_UserEventLogDataTable EoUserEventLog_getList(EoUserEventLogQryModel qm)
{
DateTime?dateFrom = null;
DateTime?dateTo = null;
if (qm.Q_EventDateFrom.HasValue)
{
dateFrom = qm.Q_EventDateFrom.Value.Date;
}
else
{
dateFrom = DateTime.Today;
}
if (qm.Q_EventDateTo.HasValue)
{
dateTo = qm.Q_EventDateTo.Value.Date.AddDays(1);
}
else
{
dateTo = DateTime.Today.AddDays(1);
}
var dt = NsDmHelper.EO_UserEventLog
.selectAll(t => t.AllExt)
.where (t =>
t.EOUEL_EventDate >= dateFrom.toConstReq1()
& t.EOUEL_EventDate < dateTo.toConstReq1()
& t.EOUEL_UserEventCode_XX == qm.Q_UserEventCode_XX.toConstOpt1()
& t.EOUEL_UserEventName_XX.contains(qm.Q_UserEventName_XX.toConstOpt1())
& t.EOUEL_UserName_XX.contains(qm.Q_UserName_XX.toConstOpt1())
)
.query();
return(dt);
}
