public CMS_ReportModels Export(ref IXLWorksheet wsMarketing /*, ref IXLWorksheet wsTime*/)
{
var result = new CMS_ReportModels();
try
{
string[] lstHeaders = new string[] { "Phone", "Message" };
int row = 1;
//add header to excel file
for (int i = 1; i <= lstHeaders.Length; i++)
{
wsMarketing.Cell(row, i).Value = lstHeaders[i - 1];
}
wsMarketing.Cell(2, 1).Value = "0987654321";
wsMarketing.Cell(2, 2).Value = "Content your mesage at here!";
//format
wsMarketing.Range(1, 1, 2, 2).Style.Border.SetTopBorder(XLBorderStyleValues.Thin);
wsMarketing.Range(1, 1, 2, 2).Style.Border.SetLeftBorder(XLBorderStyleValues.Thin);
wsMarketing.Range(1, 1, 2, 2).Style.Border.SetRightBorder(XLBorderStyleValues.Thin);
wsMarketing.Range(1, 1, 2, 2).Style.Border.SetBottomBorder(XLBorderStyleValues.Thin);
int cols = lstHeaders.Length;
row = 2;
BaseFactory.FormatExcelExport(wsMarketing, row, cols);
//Sheet 2
//wsTime.Cell(1, 1).Value = "Runing time";
//wsTime.Cell(2, 1).Value = "60s";
////format
//wsTime.Range(1, 1, 2, 1).Style.Border.SetTopBorder(XLBorderStyleValues.Thin);
//wsTime.Range(1, 1, 2, 1).Style.Border.SetLeftBorder(XLBorderStyleValues.Thin);
//wsTime.Range(1, 1, 2, 1).Style.Border.SetRightBorder(XLBorderStyleValues.Thin);
//wsTime.Range(1, 1, 2, 1).Style.Border.SetBottomBorder(XLBorderStyleValues.Thin);
//BaseFactory.FormatExcelExport(wsTime, row, 1);
//============
result.IsOk = true;
}
catch (Exception ex)
{
result.IsOk = false;
result.Message = ex.Message;
NSLog.Logger.Error(ex);
}
return(result);
}
public ResultModels Export(ref IXLWorksheet wsexcel, UsageManagementRequest request)
{
var result = new ResultModels();
try
{
using (var cxt = new NuWebContext())
{
wsexcel.Cell("A" + 1).Value = "Usage Management";
wsexcel.Row(1).Style.Font.SetBold(true);
wsexcel.Row(1).Height = 25;
wsexcel.Range(1, 1, 1, 5).Merge();
//Date
string date = string.Format("Date: {0}", request.DateFrom.ToString("MM/dd/yyyy"));
if (request.DateFrom.Date != request.DateTo.Date)
{
date = string.Format("Date from {0} to {1}", request.DateFrom.ToString("MM/dd/yyyy"), request.DateTo.ToString("MM/dd/yyyy"));
}
wsexcel.Cell("A" + 2).Value = date;
wsexcel.Row(2).Style.Font.SetBold(true);
wsexcel.Row(2).Height = 16;
wsexcel.Range(2, 1, 2, 5).Merge();
string[] lstHeaders = new string[] {
"Index", "Ingredient Code", "Ingredient Name", "Base UOMs", "Usage"
};
int row = 3;
//Add header to excel
for (int i = 1; i <= lstHeaders.Length; i++)
{
wsexcel.Cell(row, i).Value = lstHeaders[i - 1];
wsexcel.Row(row).Style.Font.SetBold(true);
}
int cols = lstHeaders.Length;
row = 4;
//Get list data
var lstData = _usageManagementFactory.GetUsageManagement(request); //CalUsageManagementwithoutDetail(request);
if (lstData != null && lstData.Count > 0)
{
foreach (var item in lstData)
{
wsexcel.Cell("A" + row).Value = item.Index;
wsexcel.Cell("B" + row).Value = item.Code;
wsexcel.Cell("C" + row).Value = item.Name;
wsexcel.Cell("D" + row).Value = item.UOMName;
wsexcel.Cell("E" + row).Value = item.Usage;
row++;
}
}
wsexcel.Range("E2", "E" + row).Style.NumberFormat.Format = "#,##0.0000";
BaseFactory.FormatExcelExport(wsexcel, row, cols);
result.IsOk = true;
}
}
catch (Exception ex)
{
result.IsOk = false;
result.Message = ex.Message;
_logger.Error(ex);
}
return(result);
}
