/* * public IList<Items> SearchCommon(Items o, ViewDataDictionary v, string pageModelViewData, string listViewData) * { * Type t = o.GetType(); * * int pDot = t.Namespace.LastIndexOf("."); * int pLen = t.Namespace.Length; * * string dir = (pDot > 1 && (pDot < (pLen - 1))) ? (t.Namespace.Substring(pDot + 1, pLen - pDot - 1) + "/") : ""; * * string qCount = dir + t.Name + "_Count"; * string qList = dir + t.Name + "_List"; * * IDBContext db = BaseRepo.Db; * * long count = db.SingleOrDefault<int>(qCount, o); * * BaseModel m = o as BaseModel; * PagingModel pmodel = null; * if (m.RowsPerPage <= 0) * { * pmodel = new PagingModel(count, 1, PagingModel.DEFAULT_RECORD_PER_PAGE); * } * else * { * pmodel = new PagingModel(count, m.CurrentPage, m.RowsPerPage); * } * * v[pageModelViewData] = pmodel; * * IList<Items> l = db.Fetch<Items>(qList, o); * * return l; * } */ #endregion #region DownloadTemplate public void DownloadTemplate() { string fileName = "DownloadTemplateItemToUpload.xls"; string filesTMp = HttpContext.Request.MapPath("~" + CommonConstant.TEMPLATE_EXCEL_DIR + "/" + fileName); FileStream ftmp = new FileStream(filesTMp, FileMode.Open, FileAccess.Read); byte[] result = null; HSSFWorkbook workbook = new HSSFWorkbook(ftmp); ICellStyle cellStyleData = NPOIWriter.createCellStyleData(workbook); //ICellStyle cellStyleHeader = NPOIWriter.createCellStyleColumnHeader(workbook); HSSFSheet sheet = (HSSFSheet)workbook.GetSheetAt(0); int row = DATA_ROW_INDEX_START; IRow Hrow; for (int i = 1; i <= 100; i++) { Hrow = sheet.CreateRow(row); for (int x = 0; x <= 2; x++) { Hrow.CreateCell(x); Hrow.GetCell(x).CellStyle = cellStyleData; } row++; } int rowMin = row - 1; ftmp.Close(); using (MemoryStream ms = new MemoryStream()) { workbook.Write(ms); result = ms.GetBuffer(); } this.SendDataAsAttachment(fileName, result); }
private byte[] CreateFile(IList <Approval> PoList) { Dictionary <string, string> headers = null; ISheet sheet1 = null; HSSFWorkbook workBook = null; byte[] result; int startRow = 0; workBook = new HSSFWorkbook(); IDataFormat dataFormat = workBook.CreateDataFormat(); short dateTimeFormat = dataFormat.GetFormat("dd/MM/yyy HH:mm:ss"); ICellStyle cellStyleData = NPOIWriter.createCellStyleData(workBook); ICellStyle cellStyleHeader = NPOIWriter.createCellStyleColumnHeader(workBook); ICellStyle cellStyleDateTime = NPOIWriter.createCellStyleDataDate(workBook, dateTimeFormat); sheet1 = workBook.CreateSheet( NPOIWriter.EscapeSheetName(SHEET_NAME_EMPLOYEE_MASTER)); sheet1.FitToPage = false; //Write Header manually headers = new Dictionary <string, string>(); WriteDetail(workBook, sheet1, startRow, cellStyleHeader, cellStyleData, PoList); using (MemoryStream buffer = new MemoryStream()) { workBook.Write(buffer); result = buffer.GetBuffer(); } workBook = null; return(result); }