public ActionResult List(FormCollection collection, int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null) { //查詢參數 var qm = new CrRegistrationQryModel(); var isOK = this.TryUpdateModel(qm); var token = collection["__RequestVerificationToken"]; var classId = qm.Q_ClassId; CR_RegistrationDataTable dt = null; if (!classId.isNullOrEmpty()) { dt = CrDataService.Instance.CrRegistration_getListByClassId(classId); } else { dt = CrDataService.Instance.CrRegistration_getList(qm); } //排序 var dtSorted = dt.sort(jtSorting); if (Request.IsAjaxRequest()) { return(converToJTableSource(dtSorted, jtStartIndex, jtPageSize)); } else { return(View(dt)); } }
public ActionResult UserList(FormCollection collection, int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null) { //查詢參數 var qm = new CrRegistrationQryModel(); var isOK = this.TryUpdateModel(qm); var token = collection["__RequestVerificationToken"]; var theDate = DateTime.Today.toTwFormat("D"); var classId = qm.Q_ClassId; var dt = NsDmHelper.CR_Registration .selectAll(t => t.AllExt) .where (t => t.CRR_RegisterStartDate_XX <= theDate.toConstReq1() & t.CRR_RegisterEndDate_XX >= theDate.toConstReq1() & t.CRR_CreatorCode_XX == qm.Q_CreatorCode_XX.toConstReq1() & t.CRR_Name == qm.Q_Name.toConstReq1() ) .query(); //排序 var dtSorted = dt.sort(jtSorting); if (Request.IsAjaxRequest()) { return(converToJTableSource(dtSorted, jtStartIndex, jtPageSize)); } else { return(View(dt)); } }
public ActionResult Index() { var qm = new CrRegistrationQryModel(); qm.Q_CourseEnable = "Y"; return(View(qm)); }
public ActionResult List(FormCollection collection, int jtStartIndex = 0, int jtPageSize = 0, string jtSorting = null) { //查詢參數 var qm = new CrRegistrationQryModel(); var isOK = this.TryUpdateModel(qm); var token = collection["__RequestVerificationToken"]; var dt = CrDataService.Instance.CrCourse_getList(qm); //排序 var dtSorted = dt.sort(jtSorting); if (Request.IsAjaxRequest()) { //var data = jtPageSize > 0 ? dtSorted.Skip(jtStartIndex).Take(jtPageSize).ToList() : dtSorted.ToList(); //var list = data.toDictionaryList(); //var jsonData = new //{ // Result = jTable_SUCCESS_CODE, // Records = list, // TotalRecordCount = dtSorted.Count() //}; //return Json(jsonData); return(converToJTableSource(dtSorted, jtStartIndex, jtPageSize)); } else { return(View(dt)); } }
//[HttpPost] //[ValidateAntiForgeryToken] public ActionResult CRR020(FormCollection collection) { //查詢參數 var token = collection["__RequestVerificationToken"]; //塞入查詢參數 var qm = new CrRegistrationQryModel(); var isOK = this.TryUpdateModel(qm); qm.ReportId = "CRR020"; qm.ExportName = "CRR020_教育訓練簽到表.xlsx"; qm.ReportSourceType = 0; qm.ReportType = FtbReportTypes.Xlsx; //直接列印 string contentType = qm.ReportType.ToString(); //取得報表資訊 var rawData = CrReportService.Instance.CRR020(qm, ref contentType); if (rawData == null) { return(View("NoData")); } return(File(rawData, contentType, qm.ExportName)); }
public ActionResult CodeQuery(FormCollection collection) { var qm = new CrRegistrationQryModel(); var bln = this.TryUpdateModel(qm); ViewBag.RequestKey = qm.RequestKey; return(View(qm)); }
//學員本人的報名清單 public ActionResult UserList(FormCollection collection) { var qm = new CrRegistrationQryModel(); var bln = this.TryUpdateModel(qm); qm.Q_CreatorCode_XX = AppUserSession.User.LoginAccount; ViewBag.RequestKey = qm.RequestKey; return(View(qm)); }
//簽到表 public byte[] CRR020(CrRegistrationQryModel qm, ref string contenttype) { var dt = NsDmHelper.CR_Registration .selectAll(t => t.AllExt) .where (t => t.CRR_CourseId_XX == qm.Q_CourseId.toConstReq1() & t.CRR_ClassId == qm.Q_ClassId.toConstOpt1() ) .orderby(t => new[] { t.CRR_ClassDate_XX.Asc, t.CRR_ClassTime_XX.Asc, t.CRR_CreateDate.Asc }) .query(); //無資料 if (dt == null) { dt = new CR_RegistrationDataTable(); } ReportViewer reportViewer1 = new ReportViewer(); reportViewer1.LocalReport.DataSources.Clear(); //取得報表檔組件 var assembly = getReportAssembly(); //取得報表定義檔 var reportFile = string.Empty; reportFile = "CRR020Rpt.rdlc"; Stream fileStream = assembly.GetManifestResourceStream("ftd.report." + reportFile); reportViewer1.LocalReport.LoadReportDefinition(fileStream); dt.TableName = "CR_Registration"; reportViewer1.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dt.TableName, dt as DataTable)); #region 報表參數設定 var companyName = FtdConfigService.Instance.getAppSettingValue("CompanyName", ""); var pCompanyName = new ReportParameter("P_CompanyName", companyName); reportViewer1.LocalReport.SetParameters(new ReportParameter[] { pCompanyName }); #endregion Microsoft.Reporting.WebForms.Warning[] tWarnings; string[] tStreamids; string tMimeType; string tEncoding; string tExtension; string fileFormat = getPrintType(contenttype.ToLower()); byte[] tBytes = reportViewer1.LocalReport.Render(fileFormat, "<DeviceInfo><AutoFit>Never</AutoFit></DeviceInfo>", out tMimeType, out tEncoding, out tExtension, out tStreamids, out tWarnings); contenttype = tMimeType; return(tBytes); }
public CR_CourseDataTable CrCourse_getList(CrRegistrationQryModel qm) { var dt = NsDmHelper.CR_Course .selectAll(t => t.AllExt) .where (t => t.CRC_Code == qm.Q_CourseCode.toConstOpt1() & t.CRC_Name.contains(qm.Q_CourseName.toConstOpt1()) ) .query(); return(dt); }
public CR_RegistrationDataTable CrRegistration_getList(CrRegistrationQryModel qm) { var dt = NsDmHelper.CR_Registration .selectAll(t => t.AllExt) .where (t => t.CRR_CourseCode_XX == qm.Q_CourseCode.toConstOpt1() & t.CRR_ClassCode_XX == qm.Q_ClassCode.toConstOpt1() & t.CRR_ClassDate_XX == qm.Q_ClassDate.toConstOpt1() & t.CRR_CitizenId == qm.Q_CitizenId.toConstOpt1() & t.CRR_Email == qm.Q_Email.toConstOpt1() & t.CRR_FoodKind == qm.Q_FoodKind.toConstOpt1() & t.CRR_CourseName_XX.contains(qm.Q_CourseName.toConstOpt1()) ) .query(); return(dt); }
public byte[] CRR030(CrRegistrationQryModel qm, ref string contenttype) { return(null); }
public ActionResult CRM010() { var qm = new CrRegistrationQryModel(); return(View(qm)); }