public EO_EmployeeTitleDataTable EoEmployeeTitle_getList(EoEmployeeTitleQryModel qm) { var dt = NsDmHelper.EO_EmployeeTitle .selectAll(t => t.AllExt) .where (t => t.EOET_TitleCode == qm.Q_TitleCode.toConstOpt1() & t.EOET_TitleName.contains(qm.Q_TitleName.toConstOpt1()) ) .query(); return(dt); }
public ActionResult List(FormCollection collection, int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null) { //查詢參數 var para = new EoEmployeeTitleQryModel(); var isOK = this.TryUpdateModel(para); var token = collection["__RequestVerificationToken"]; var dt = EoDataService.Instance.EoEmployeeTitle_getList(para); //排序 var dtSorted = dt.sort(jtSorting); if (Request.IsAjaxRequest()) { return(converToJTableSource(dtSorted, jtStartIndex, jtPageSize)); } else { return(View(dt)); } }