public ActionResult ExcelPrint(string formvar) { //ListCondition condition = new ListCondition(); //condition.SortField = DataConvert.ToString(Request.Params["sidx"]); //condition.SortType = DataConvert.ToString(Request.Params["sord"]); //condition.PageIndex = DataConvert.ToInt32(Request.Params["page"]); //condition.PageRowNum = DataConvert.ToInt32(Request.Params["rows"]); //condition.ListModelString = formvar; //DataTable dt = Repository.GetReportGridDataTable(condition); //QueryEntryViewModel model = JsonHelper.Deserialize<QueryEntryViewModel>(formvar); //ExcelHelper.PrintExcel(dt, EntryGridLayout(model.FormMode), "main"); //return Content("1", "text/html"); ListCondition condition = new ListCondition(); condition.SortField = DataConvert.ToString(Request.Params["sidx"]); condition.SortType = DataConvert.ToString(Request.Params["sord"]); condition.PageIndex = DataConvert.ToInt32(Request.Params["page"]); condition.PageRowNum = DataConvert.ToInt32(Request.Params["rows"]); condition.ListModelString = formvar; DataTable dt = Repository.GetReportGridDataTable(condition, false); QueryEntryViewModel model = JsonHelper.Deserialize <QueryEntryViewModel>(formvar); model.EntryGridData = dt; model.EntryGridLayout = EntryGridLayout(model.FormMode); model.EntryGridId = "EntryGrid"; model.FormId = "PrintForm"; model.GridHeight = 375; return(View("ReportPrint", model)); }
public virtual JsonResult EntryGridData(string formVar) { ListCondition condition = new ListCondition(); condition.SortField = DataConvert.ToString(Request.Form["sidx"]); condition.SortType = DataConvert.ToString(Request.Params["sord"]); condition.PageIndex = DataConvert.ToInt32(Request.Params["page"]); condition.PageRowNum = DataConvert.ToInt32(Request.Params["rows"]); condition.ListModelString = formVar; var rows = new object[0]; int cnt = 0; if (DataConvert.ToString(formVar) != "") { cnt = Repository.GetReportGridDataTable(condition, false).Rows.Count; condition.TotalRowNum = cnt; QueryEntryViewModel model = JsonHelper.Deserialize <QueryEntryViewModel>(formVar); DataTable dt = Repository.GetReportGridDataTable(condition, true); rows = DataTable2Object.Data(dt, EntryGridLayout(model.FormMode).GridLayouts); } double aa = (double)cnt / condition.PageRowNum; double pageCnt = Math.Ceiling(aa); var result = new JsonResult(); result.JsonRequestBehavior = JsonRequestBehavior.AllowGet; result.Data = new { page = 1, records = cnt, total = pageCnt, rows = rows }; return(result); }
public ActionResult ExcelExport(string formvar) { ListCondition condition = new ListCondition(); condition.SortField = DataConvert.ToString(Request.Params["sidx"]); condition.SortType = DataConvert.ToString(Request.Params["sord"]); condition.PageIndex = DataConvert.ToInt32(Request.Params["page"]); condition.PageRowNum = DataConvert.ToInt32(Request.Params["rows"]); condition.ListModelString = formvar; DataTable dt = Repository.GetReportGridDataTable(condition, false); QueryEntryViewModel model = JsonHelper.Deserialize <QueryEntryViewModel>(formvar); StringBuilder sbHtml = ExcelHelper.CreateExcel(dt, EntryGridLayout(model.FormMode)); //string fileName = Server.MapPath("~/Content/uploads/output.xls"); //ExcelHelper.CreateExcel(dt, EntryGridLayout(), "main", "报表", fileName); //return File(fileName, "application/ms-excel", IdGenerator.GetMaxId("ExcelExport") + ".xls"); byte[] fileContents = Encoding.UTF8.GetBytes(sbHtml.ToString()); return(File(fileContents, "application/ms-excel", IdGenerator.GetMaxId(ExportFileName) + ".xls")); }
protected void SetParentEntryModel(string pageId, string viewTitle, string formMode, QueryEntryViewModel model) { model.PageId = pageId; model.ViewTitle = viewTitle; model.ExportUrl = Url.Action("ExcelExport"); model.FormId = "QueryForm"; model.GridHeight = 375; model.EntryGridLayout = EntryGridLayout(formMode); }