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);
}
