public ActionResult Index()
{
var model = new ModelDocumentItem
{
ListDrawerItems = _dnDrawerApi.GetListSimple(),
};
return(View(model));
}
public ActionResult ListItems()
{
var model = new ModelDocumentItem
{
ListItem = _da.GetListSimpleByRequest(Request),
PageHtml = _da.GridHtmlPage
};
ViewData.Model = model;
return(View());
}
public virtual void ExportProductsExcel(string filePath, ModelDocumentItem modelDocument)
{
var newFile = new FileInfo(filePath);
// ok, we can run the real code of the sample now
int dem = 0;
using (var xlPackage = new ExcelPackage(newFile))
{
// uncomment this line if you want the XML written out to the outputDir
//xlPackage.DebugMode = true;
// get handle to the existing worksheet
var worksheet = xlPackage.Workbook.Worksheets.Add("Document");
xlPackage.Workbook.CalcMode = ExcelCalcMode.Manual;
//Create Headers and format them
var properties = new string[]
{
"STT",
"Thuộc tầng",
"Phòng",
"Tủ đựng tài liệu",
"Ngăn đựng tài liệu",
"Tên tài liệu",
"Số/Kí hiệu",
//"Loại tài liệu",
"Nơi ban hành",
//"Ngày ban hành",
"Người ký"
};
for (var i = 0; i < properties.Length; i++)
{
worksheet.Cells[1, i + 1].Value = properties[i];
worksheet.Cells[1, i + 1].Style.Fill.PatternType = ExcelFillStyle.Solid;
worksheet.Cells[1, i + 1].Style.Fill.BackgroundColor.SetColor(Color.FromArgb(184, 204, 228));
worksheet.Cells[1, i + 1].Style.Font.Bold = true;
}
var row = 2;
foreach (var item in modelDocument.ListItem)
{
dem++;
int col = 1;
worksheet.Cells[row, col].Value = dem;
col++;
// tầng
worksheet.Cells[row, col].Value = item.LevelName;
col++;
// phòng
worksheet.Cells[row, col].Value = item.RoomName;
col++;
// tủ tài liệu
worksheet.Cells[row, col].Value = item.CabinetName;
col++;
// ngăn tài liệu
worksheet.Cells[row, col].Value = item.DrawerName;
col++;
// tên tài liệu
worksheet.Cells[row, col].Value = item.Name;
col++;
// số/kí hiệu
worksheet.Cells[row, col].Value = item.Numberbill;
col++;
// loại tài liệu
//worksheet.Cells[row, col].Value = item.ListCategoryItem != null ? string.Join(",", item.ListCategoryItem.Select(m=> m.Name)) : string.Empty;
//col++;
// Nơi ban hành
worksheet.Cells[row, col].Value = item.NoiBanHanh;
col++;
// ngày ban hành
//worksheet.Cells[row, col].Value = ConvertDate.DecimalToDate(item.PublishedDate).ToString("dd/MM/yyyy");
//col++;
// người ký
worksheet.Cells[row, col].Value = item.NguoiKy;
row++;
}
// we had better add some document properties to the spreadsheet
// set some core property values
var nameexcel = "Tài liệu văn bản " + DateTime.Now.ToString("yyyy-MM-ddTHH:mm:ss.fff");
xlPackage.Workbook.Properties.Title = string.Format("{0} reports", nameexcel);
xlPackage.Workbook.Properties.Author = "FDI-IT";
xlPackage.Workbook.Properties.Subject = string.Format("{0} reports", "");
//xlPackage.Workbook.Properties.Keywords = string.Format("{0} orders", _storeInformationSettings.StoreName);
xlPackage.Workbook.Properties.Category = "Report";
//xlPackage.Workbook.Properties.Comments = string.Format("{0} orders", _storeInformationSettings.StoreName);
// set some extended property values
xlPackage.Workbook.Properties.Company = "FDI ";
//xlPackage.Workbook.Properties.HyperlinkBase = new Uri(_storeInformationSettings.StoreUrl);
// save the new spreadsheet
xlPackage.Save();
}
}
