public void FindBaseByCode() { string startTime = Context.Request.Form["startTime"]; string endTime = Context.Request.Form["endTime"]; string baseCode = Context.Request.Form["baseName"]; string rows = Context.Request.Form["rows"]; string page = Context.Request.Form["page"]; IList <BasBase> baseInfo = _bal.FindBaseByCode(startTime, endTime, baseCode); List <BasBase> bs = new List <BasBase>(); int istart = (Convert.ToInt32(page) - 1) * Convert.ToInt32(rows); int iend = Convert.ToInt32(page) * Convert.ToInt32(rows) + 1; int j = 1; foreach (BasBase bb in baseInfo) { if (j > istart && j < iend) { BasBase bbtemp = new BasBase(); bbtemp = bb; bbtemp.UpdatedBy = FindUserNameByCode(bbtemp.UpdatedBy); bs.Add(bbtemp); } j++; } Dictionary <String, Object> map = new Dictionary <String, Object>(); if (baseInfo != null & baseInfo.Count > 0) { map.Add("total", baseInfo.Count); } map.Add("rows", bs); Context.Response.Write(JsonConvert.SerializeObject(map)); }
protected void Page_Load(object sender, EventArgs e) { string startTime = Request.QueryString["startTime"]; string endTime = Request.QueryString["endTime"]; string baseCode = Request.QueryString["baseName"]; BasicBO _bal = BLLFactory.GetBal <BasicBO>(userInfo); IList <BasBase> baseInfo = _bal.FindBaseByCode(startTime, endTime, baseCode); WsSystem ws = new WsSystem(); if (baseInfo == null || baseInfo.Count == 0) { Response.Write("no data"); return; } HSSFWorkbook hssfWorkbook = new HSSFWorkbook(); Row row = null; Cell cell = null; Sheet hssfSheet = hssfWorkbook.CreateSheet("BaseInfo"); row = hssfSheet.CreateRow(0); //填充头 string objs = "信息编号,信息名称,子信息编码,子信息名称,操作人,时间"; for (int i = 0; i < objs.Split(',').Length; i++) { cell = row.CreateCell(i); cell.SetCellValue(objs.Split(',')[i]); } if (baseInfo != null) { for (int i = 2; i <= baseInfo.Count + 1; i++) { row = hssfSheet.CreateRow(i); cell = row.CreateCell(0); cell.SetCellValue(baseInfo[i - 2].CODE); cell = row.CreateCell(1); cell.SetCellValue(baseInfo[i - 2].NAME); cell = row.CreateCell(2); cell.SetCellValue(baseInfo[i - 2].SubCode); cell = row.CreateCell(3); cell.SetCellValue(baseInfo[i - 2].SubName); cell = row.CreateCell(4); cell.SetCellValue(ws.FindUserNameByCode(baseInfo[i - 2].UpdatedBy)); cell = row.CreateCell(5); cell.SetCellValue(baseInfo[i - 2].UpdatedDate == null ? baseInfo[i - 2].CreatedDate.ToString() : baseInfo[i - 2].UpdatedDate.ToString()); } } MemoryStream file = new MemoryStream(); hssfWorkbook.Write(file); String fileName = "BaseInfo" + DateTime.Now.ToString("yyyyMMddHHmmss"); Response.Clear(); Response.ClearContent(); Response.ClearHeaders(); Response.AddHeader("Content-Disposition", string.Format("attachment;filename={0}.xls", fileName)); Response.AddHeader("Content-Length", file.Length.ToString()); Response.AddHeader("Content-Transfer-Encoding", "binary"); Response.ContentType = "application/octet-stream"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8"); Response.BinaryWrite(file.GetBuffer()); Response.Flush(); Response.End(); }