//// GET: /WtScheduleTask/
//public ActionResult Index()
//{
// return View();
//}
// GET: /WtScheduleTask/CodeQuery
public ActionResult CodeQuery(FormCollection collection)
{
var qm = new WtScheduleTaskQryModel();
var bln = this.TryUpdateModel(qm);
ViewBag.RequestKey = qm.RequestKey;
return(View());
}
public WT_ScheduleDateDataTable WtScheduleDate_getList(WtScheduleTaskQryModel qm)
{
var dt = NsDmHelper.WT_ScheduleDate
.selectAll(t => t.AllExt)
.where (t =>
t.WTSD_ScheduleTaskId == qm.Q_ScheduleTaskId.toConstReq1()
& t.WTSD_IsEnable == qm.Q_IsEnable.toConstOpt1()
)
.query();
return(dt);
}
public WT_ScheduleTaskDataTable WtScheduleTask_getList(WtScheduleTaskQryModel qm)
{
var dt = NsDmHelper.WT_ScheduleTask
.selectAll(t => t.AllExt)
.where (t =>
t.WTST_IsEnable == qm.Q_IsEnable.toConstOpt1()
& t.WTST_ExecuteState == qm.Q_ExecuteState.toConstOpt1()
& t.WTST_TaskName.contains(qm.Q_TaskName.toConstOpt1())
)
.query();
return(dt);
}
public ActionResult List(FormCollection collection, int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null)
{
//查詢參數
var qm = new WtScheduleTaskQryModel();
var isOK = this.TryUpdateModel(qm);
var token = collection["__RequestVerificationToken"];
var dt = WtDataService.Instance.WtScheduleTask_getList(qm);
//排序
var dtSorted = dt.sort(jtSorting);
if (Request.IsAjaxRequest())
{
return(converToJTableSource(dtSorted, jtStartIndex, jtPageSize));
}
else
{
return(View(dt));
}
}
