public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string unitListCode = Request.QueryString["unitListCode"]; string unitListName = Request.QueryString["unitListName"]; string uniformCode = Request.QueryString["uniformCode"]; string unitCode1 = Request.QueryString["unitCode1"]; string unitCode2 = Request.QueryString["unitCode2"]; string unitCode3 = Request.QueryString["unitCode3"]; string unitCode4 = Request.QueryString["unitCode4"]; string isActive = Request.QueryString["isActive"]; UnitList unitlist = new UnitList(); unitlist.UnitListCode = unitListCode; unitlist.UnitListName = unitListName; unitlist.UniformCode = uniformCode; unitlist.UnitCode01 = unitCode1; unitlist.UnitCode02 = unitCode2; unitlist.UnitCode03 = unitCode3; unitlist.UnitCode04 = unitCode4; unitlist.IsActive = isActive; ExportParam ep = new ExportParam(); ep.DT1 = UnitListService.GetUnitList(page, rows, unitlist); ep.HeadTitle1 = "单位系列"; return PrintService.Print(ep); }
// // GET: /UnitList/Details/ public ActionResult Details(int page, int rows, FormCollection collection) { UnitList ul = new UnitList(); ul.UnitListCode = collection["UnitListCode"] ?? ""; ul.UnitListName = collection["UnitListName"] ?? ""; ul.UniformCode = collection["UniformCode"] ?? ""; ul.UnitCode01 = collection["UnitCode01"] ?? ""; ul.UnitName01 = collection["UnitName01"] ?? ""; ul.UnitCode02 = collection["UnitCode02"] ?? ""; ul.UnitName02 = collection["UnitName02"] ?? ""; ul.UnitCode03 = collection["UnitCode03"] ?? ""; ul.UnitName03 = collection["UnitName03"] ?? ""; ul.UnitCode04 = collection["UnitCode04"] ?? ""; ul.UnitName04 = collection["UnitName04"] ?? ""; ul.IsActive = collection["IsActive"] ?? ""; var users = UnitListService.GetDetails(page, rows, ul); return Json(users, "text", JsonRequestBehavior.AllowGet); }
public FileStreamResult CreateExcelToClient() { int page = 0, rows = 0; string unitListCode = Request.QueryString["unitListCode"]; string unitListName = Request.QueryString["unitListName"]; string uniformCode = Request.QueryString["uniformCode"]; string unitCode1 = Request.QueryString["unitCode1"]; string unitCode2 = Request.QueryString["unitCode2"]; string unitCode3 = Request.QueryString["unitCode3"]; string unitCode4 = Request.QueryString["unitCode4"]; string isActive = Request.QueryString["isActive"]; UnitList unitlist = new UnitList(); unitlist.UnitListCode = unitListCode; unitlist.UnitListName = unitListName; unitlist.UniformCode = uniformCode; unitlist.UnitCode01 = unitCode1; unitlist.UnitCode02 = unitCode2; unitlist.UnitCode03 = unitCode3; unitlist.UnitCode04 = unitCode4; unitlist.IsActive = isActive; System.Data.DataTable dt = UnitListService.GetUnitList(page, rows, unitlist); string headText = "单位系列"; string headFont = "微软雅黑"; Int16 headSize = 20; string colHeadFont = "Arial"; Int16 colHeadSize = 10; string[] HeaderFooder = { "……" //眉左 ,"……" //眉中 ,"……" //眉右 ,"&D" //脚左 日期 ,"……" //脚中 ,"&P" //脚右 页码 }; System.IO.MemoryStream ms = THOK.Common.ExportExcel.ExportDT(dt, null, headText, null, headFont, headSize , 0, true, colHeadFont, colHeadSize, 0, true, 0, HeaderFooder, null, 0); return new FileStreamResult(ms, "application/ms-excel"); }
public ActionResult Create(UnitList unitList) { bool bResult = UnitListService.Add(unitList); string msg = bResult ? "新增成功" : "新增失败"; return Json(JsonMessageHelper.getJsonMessage(bResult, msg, null), "text", JsonRequestBehavior.AllowGet); }
// // POST: /UnitList/Edit/ public ActionResult Edit(UnitList unitList) { string strResult = string.Empty; bool bResult = UnitListService.Save(unitList,out strResult); string msg = bResult ? "修改成功" : "修改失败"; return Json(JsonMessageHelper.getJsonMessage(bResult, msg, null), "text", JsonRequestBehavior.AllowGet); }