public FileContentResult SubscriptionStatementExportToExcel(DateTime?FromDate, DateTime?ToDate, int?subsid, string substext = "")
{
int pageNo = 1;
int pageSize = 0;
MainViewModel.SubscriptionReport subscriptionViewModel = new MainViewModel.SubscriptionReport();
var suscriberList = reportService.getSubscriberStatementList(subsid, FromDate, ToDate, pageNo, pageSize);
var subscriptionExcelList = suscriberList.Select(x => new ExcelViewModel.SubscriptionReportExcel()
{
custNo = x.CustNo,
SubsNo = x.SubsNo,
Custname = x.Custname,
Debit = x.Debit,
Credit = x.Credit,
Balance = x.Balance,
PostedOnAd = x.PostedOnAd,
PostedOnBs = x.PostedOnBs,
Sources = x.Sources
}).ToList();
string[] columns = { "Customer No", "Subscription No.", "Customer Name", "Debit", "Credit", "Balance", "Posted On Ad", "Posted On Bst", "Sources" };
string[] parameterSearch = { "From Date.: " + FromDate, "To Date.: " + ToDate, "Customer Name: " + substext };
byte[] fileContent = ExcelExportHelper.ExportExcel(subscriptionExcelList, parameterSearch, null, "Subscription Report", columns);
return(File(fileContent, ExcelExportHelper.ExcelContentType, "Subscription Report.xlsx"));
}
public FileContentResult SubscriptionExportToExcel(int?customerId, int?custtype, DateTime?effectivedate, string cTypetext = "", string statustext = "", string Location = "", int status = 1, int pageNo = 1, int pageSize = 0)
{
MainViewModel.SubscriptionViewModel customerViewModel = new MainViewModel.SubscriptionViewModel();
var suscriberList = suscription.getSuscriberList(customerId, custtype, effectivedate, pageNo, pageSize, Location, status);
var subscriptionExcelList = suscriberList.Select(x => new ExcelViewModel.SubscriptionExcelViewModel()
{
custno = x.CustNo,
SubsNo = x.SubsNo,
CustomerName = x.CustomerName,
LocationName = x.LocationName,
EffectiveDate = x.EffectiveDate,
LedgerName = x.LedgerName,
MonthlyAmount = x.MonthlyAmount,
Status = x.Status
}).ToList();
if (cTypetext == "--Select Event--")
{
cTypetext = "";
}
string[] columns = { "Customer No", "Subscription No.", "Customer Name", "LocationName", "Effective Date", "Ledger Name", "Monthly Amount", "Status" };
string[] parameterSearch = { "Location.:" + Location, "Effective Date:" + effectivedate, "Customer Type:" + cTypetext, "Status:" + statustext };
byte[] fileContent = ExcelExportHelper.ExportExcel(subscriptionExcelList, parameterSearch, null, "Subscription Report", columns);
return(File(fileContent, ExcelExportHelper.ExcelContentType, "Subscription Report.xlsx"));
}
public HttpResponseMessage ExportarXLS(int codOficina, string dia)
{
DateTime elDia = Convert.ToDateTime(dia);
var ingLc = IngresolicenciaDataAccess.ObtenerEntidadesByOficinaXLS(codOficina, elDia);
Columna[] columns =
{
new Columna("FolioLicencia", "Folio LM"),
new Columna("RutAfiliado", "Rut Afiliado"),
new Columna("NombreAfiliado", "Nombre Afiliado"),
new Columna("FechaIngreso", "Fecha Ingreso"),
new Columna("RutEjecutivo", "Rut Ejecutivo"),
new Columna("NombreEjecutivo", "Nombre Ejecutivo"),
new Columna("SinDatosEnSistema", "Sin datos en sistema"),
new Columna("SucursalDestino", "Sucursal Destino")
};
byte[] filecontent = ExcelExportHelper.ExportExcel(ingLc, "LM Ingresadas al " + dia, true, columns);
HttpResponseMessage response = new HttpResponseMessage();
Stream stri = new MemoryStream(filecontent);
response.Content = new StreamContent(stri);
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment");
response.Content.Headers.ContentDisposition.FileName = "LM_Ingresadas_" + dia.Replace("-", "_").Replace("/", "_") + ".xls";
response.Content.Headers.ContentType = new MediaTypeHeaderValue(ExcelExportHelper.ExcelContentType);
response.Content.Headers.ContentLength = stri.Length;
return(response);
}
static void Main(string[] args)
{
OffresExcel excelDoc = new OffresExcel(@"C:\test\Copie - BX - Offres-cmd-2012.xlsx");
DataTable myTable = excelDoc.ReadWorkSheet("JAN");
int counter = 0;
for (int i = 0; i < myTable.Rows.Count; i++)
{
if (!string.IsNullOrEmpty(myTable.Rows[i][0].ToString()))
{
counter++;
}
else
{
break;
}
}
ExcelExportHelper myWriteExcel = new ExcelExportHelper(@"C:\test\BX - Offres-cmd-2012 - Copie.xlsx");
myWriteExcel.ChangeSheet("JAN");
myWriteExcel.SetCell(79, 3, "ValueAdded");
myWriteExcel.Save(@"C:\test\BX - Offres-cmd-2012 - Copie.xlsx");
myWriteExcel.Dispose();
Console.ReadLine();
}
public ActionResult ExportMonthCountToExcel(YearwiseLeaveSummaryQueryModel data, string RequestLevelPerson)
{
IList <MonthwiseLeavesCountModel> LeaveRequests = null;
using (var client = new LeaveClient())
{
LeaveRequests = client.GetMonthwiseLeavesCount(data.Year, UserId, data.OnlyReportedToMe, data.SearchUserID, RequestLevelPerson);
}
List <MonthwiseLeavesCountModel> excelData = new List <MonthwiseLeavesCountModel>();
excelData = LeaveRequests.ToList();
if (excelData.Count > 0)
{
string[] columns = { "EmpId", "Name", "CL1", "PL1", "DL1", "LWP1", "CO1", "CL2", "PL2", "DL2", "LWP2", "CO2", "CL3", "PL3", "DL3", "LWP3", "CO3", "CL4", "PL4", "DL4", "LWP4", "CO4", "CL5", "PL5", "DL5", "LWP5", "CO5", "CL6", "PL6", "DL6", "LWP6", "CO6", "CL7", "PL7", "DL7", "LWP7", "CO7", "CL8", "PL8", "DL8", "LWP8", "CO8", "CL9", "PL9", "DL9", "LWP9", "CO9", "CL10", "PL10", "DL10", "LWP10", "CO10", "CL11", "PL11", "DL11", "LWP11", "CO11", "CL12", "PL12", "DL12", "LWP12", "CO12" };
byte[] filecontent = ExcelExportHelper.ExportExcelMonthSummary(excelData, data.Year, "", false, columns);
return(File(filecontent, ExcelExportHelper.ExcelContentType, "MonthwiseReport_" + System.DateTime.Now + ".xlsx"));
}
else
{
using (var Client = new LeaveClient())
{
var result = Client.GetYearsFromLeaveBalance();
ViewBag.YearsInLeaveBal = result;
}
ViewBag.RequestLevelPerson = RequestLevelPerson;
data.ErrorMsg = "Excel file is not generated as no data returned.";
return(View("MonthwiseLeaveCount", data));
}
}
public ActionResult ExportAccessCardAttendanceToExcel(EmployeeAttendanceQueryModel EmployeeAttendanceQueryModelObj, string RequestLevelPerson)
{
List <EmployeeAttendanceModel> excelData = GetAccessCardEmployeeAttendanceList(EmployeeAttendanceQueryModelObj.CardID.ToString(), (EmployeeAttendanceQueryModelObj.FromDate == DateTime.MinValue ? "" : EmployeeAttendanceQueryModelObj.FromDate.ToString()),
(EmployeeAttendanceQueryModelObj.ToDate == DateTime.MinValue ? "" : EmployeeAttendanceQueryModelObj.ToDate.ToString()), RequestLevelPerson).ToList();
if (excelData.Count > 0)
{
List <string> columns = new List <string>()
{
"Card Id", "Date", "In Out Time", "In Out", "Name"
};
string fileName = string.Format("AccessCardReport_{0}{1}", DateTime.Now.ToString("ddMMyyyyHHmmss"), ".xlsx");
if (EmployeeAttendanceQueryModelObj.RequestLevelPerson == "My")
{
columns = new List <string>()
{
"Card Id", "Date", "In Out Time", "In Out", "Name"
};
}
byte[] filecontent = ExcelExportHelper.ExportExcelAccessCardAttendance(excelData, "", false, columns.ToArray());
return(File(filecontent, ExcelExportHelper.ExcelContentType, fileName));
}
else
{
ViewBag.RequestLevelPerson = RequestLevelPerson;
EmployeeAttendanceQueryModel data = new EmployeeAttendanceQueryModel
{
ErrorMsg = "Excel file is not generated as no data returned."
};
return(View("~/Views/Attendance/AccessCardAttendance.cshtml", data));
}
}
public void GenerarExcel(int mes, int anio, int idIndicador, List <MedicionResultDTO> mediciones)
{
string archivo = ObtenerPathArchivoCompleto(anio, mes, idIndicador);
if (!File.Exists(archivo))
{
if (mediciones == null)
{
mediciones = (List <MedicionResultDTO>)ObtenerDetallesMediciones(mes, anio);
}
List <MedicionExportarDTO> medicionesExportar = (List <MedicionExportarDTO>)AutoMapper.Mapper.Map <IList <MedicionExportarDTO> >(mediciones);
try
{
string mesStr = EnumHelper <Enums.Enum.Mes> .Parse(mes.ToString()).ToString();
string[] columnas = GetColumnasExportacion();
string titulo = GetTituloExportacion(mesStr, anio.ToString());
FileStream fs = File.Create(archivo);
byte[] filecontent = ExcelExportHelper.ExportExcel(medicionesExportar, titulo, false, columnas);
fs.Write(filecontent, 0, filecontent.Length);
fs.Close();
}
catch (Exception ex)
{
LogHelper.LogException(ex);
}
}
}
public async Task <IActionResult> ExportVBSToExcel()
{
var applicationDbContext = _context.Classes.Include(c => c.Session)
.Include(c => c.Children)
.Where(c => c.VBSId == this.CurrentVBSId && c.VBS.TenantId == this.TenantId)
.OrderBy(c => c.SessionId)
.ThenBy(c => c.Grade)
.ThenBy(c => c.Name);
List <Classroom> dbClassrooms = await applicationDbContext.ToListAsync();
var applicationDbContext2 = _context.Children.Include(c => c.Classroom)
.Include(c => c.Classroom.Session)
.Include(c => c.Session)
.Where(c => c.VBSId == this.CurrentVBSId && c.VBS.TenantId == this.TenantId)
.OrderBy(c => c.SessionId)
.ThenBy(c => c.LastName)
.ThenBy(c => c.FirstName);
List <Child> dbChildren = await applicationDbContext2.ToListAsync();
string tenantName = _context.Tenants
.Where(t => t.Id == this.TenantId).First().Name;
string theme = _context.VBS
.Where(v => v.Id == this.CurrentVBSId).First().ThemeName;
string fileName = tenantName + " - " + theme + " - " + "Full Data Export.xlsx";
byte[] filecontent = ExcelExportHelper.ExportVBSExcel(dbClassrooms, dbChildren);
return(File(filecontent, ExcelExportHelper.ExcelContentType, fileName));
}
public async Task <FileContentResult> ExportToExcel(char tabIndex)
{
var filter = new FilterModel {
CompId = CurrentUser.CompanyId, tabIndex = tabIndex, IsExport = true
};
var response = await _centerRepo.GetCallDetails(filter);
byte[] filecontent;
string[] columns;
if (tabIndex == 'P')
{
columns = new string[] { "CRN", "ClientName", "CreatedOn", "ServiceTypeName", "CustomerName", "CustomerContactNumber",
"CustomerEmail", "CustomerAddress", "CustomerCity", "CustomerPincode", "DeviceCategory", "DeviceBrand",
"DeviceModel", "DOP", "PurchaseFrom", "ServiceCenterName" };
filecontent = ExcelExportHelper.ExportExcel(response.PendingCalls, "", true, columns);
}
else if (tabIndex == 'A')
{
columns = new string[] { "CRN", "ClientName", "CreatedOn", "ServiceTypeName", "CustomerName", "CustomerContactNumber",
"CustomerEmail", "CustomerAddress", "CustomerCity", "CustomerPincode", "DeviceCategory", "DeviceBrand",
"DeviceModel", "DOP", "PurchaseFrom", "ServiceCenterName" };
filecontent = ExcelExportHelper.ExportExcel(response.AcceptedCalls, "", true, columns);
}
else
{
columns = new string[] { "CRN", "ClientName", "CreatedOn", "ServiceTypeName", "CustomerName", "CustomerContactNumber",
"CustomerEmail", "CustomerAddress", "CustomerCity", "CustomerPincode", "DeviceCategory", "DeviceBrand",
"DeviceModel", "DOP", "PurchaseFrom", "ProviderName", "ServiceCenterName" };
filecontent = ExcelExportHelper.ExportExcel(response.AssignedCalls, "", true, columns);
}
return(File(filecontent, ExcelExportHelper.ExcelContentType, "Excel.xlsx"));
}
public ActionResult ExportYearSummaryToExcel(YearwiseLeaveSummaryQueryModel data, string RequestLevelPerson)
{
IList <EmployeeWiseLeaveSummaryModel> LeaveRequests = null;
using (var client = new LeaveClient())
{
LeaveRequests = client.GetEmployeeWiseLeaveSumary(UserId, data.Year, RequestLevelPerson, data.SearchUserID, data.OnlyReportedToMe);
}
List <EmployeeWiseLeaveSummaryModel> excelData = new List <EmployeeWiseLeaveSummaryModel>();
excelData = LeaveRequests.ToList();
if (excelData.Count > 0)
{
string[] columns = { "Emp Id", "Name", "Request Type", "Total Leaves", "Used Leaves", "Pending Approval", "Balance Leaves" };
byte[] filecontent = ExcelExportHelper.ExportExcelYearSummary(excelData, "", false, columns);
return(File(filecontent, ExcelExportHelper.ExcelContentType, "LeaveBalanceReport_" + System.DateTime.Now + ".xlsx"));
}
else
{
using (var Client = new LeaveClient())
{
var result = Client.GetYearsFromLeaveBalance();
ViewBag.YearsInLeaveBal = result;
}
ViewBag.RequestLevelPerson = RequestLevelPerson;
data.ErrorMsg = "Excel file is not generated as no data returned.";
return(View("ViewEmployeeWiseLeaveSummary", data));
}
}
public ActionResult Search(string submit, string bankName)
{
var data = custBankRepo.Search(bankName);
if (submit.Equals("Search"))
{
return(View("Index", data));
}
else
{
int timeStamp = Convert.ToInt32(DateTime.UtcNow.AddHours(8).Subtract(new DateTime(1970, 1, 1)).TotalSeconds);
ExcelExportHelper hepler = new ExcelExportHelper();
var exportData =
data.Select(s => new 客戶銀行資訊ViewModel()
{
Id = s.Id,
銀行名稱 = s.銀行名稱,
銀行代碼 = s.銀行代碼,
分行代碼 = s.分行代碼,
帳戶名稱 = s.帳戶名稱,
帳戶號碼 = s.帳戶號碼,
客戶名稱 = s.客戶資料.客戶名稱
})
.ToList();
var memoryStream = hepler.Stream(exportData);
return(File(
memoryStream.ToArray(),
"application/vnd.ms-excel",
$"Export_客戶銀行資訊_{timeStamp}.xlsx"));
}
}
public FileContentResult SubmitFormReportExport()
{
AccruedService service = new AccruedService();
//DataTable dt = service.ExportReport();
//string g = "";
var dt = new System.Data.DataTable("test");
dt.Columns.Add("col1", typeof(int));
dt.Columns.Add("col2", typeof(string));
dt.Rows.Add(1, "product 1");
dt.Rows.Add(2, "product 2");
dt.Rows.Add(3, "product 3");
dt.Rows.Add(4, "product 4");
dt.Rows.Add(5, "product 5");
dt.Rows.Add(6, "product 6");
dt.Rows.Add(7, "product 7");
string[] columns = dt.Columns.Cast <DataColumn>()
.Select(x => x.ColumnName)
.ToArray();
byte[] filecontent = ExcelExportHelper.ExportExcel(dt, "Technology", false, columns);
return(File(filecontent, ExcelExportHelper.ExcelContentType, "Technologies.xlsx"));
}
public HttpResponseMessage descargarExcel5disponiblesAPago(int re, int of)
{
var dataExp = GeneralesData.ListarObjetosDisponibleApago(re, of);
Columna[] columns =
{
new Columna("Afiliado_Rut", "Rut Afiliado"),
new Columna("Afiliado_Dv", "Dv Afiliado"),
new Columna("Afiliado_Nombre", "Nombre Afiliado"),
new Columna("Licencia_Folio", "Folio LM"),
new Columna("Fecha_Inicio", "Fecha Inicio"),
new Columna("Fecha_Termino", "Fecha Término"),
new Columna("Licencia_Dias", "Dias LM"),
new Columna("Dias_Pago", "Dias a Pago"),
new Columna("Monto_Pago", "Monto a Pago"),
new Columna("Mes_Prescripcion", "Periodo Expira"),
};
byte[] filecontent = ExcelExportHelper.ExportExcel(dataExp, "Disponibles a Pago.", false, columns);
HttpResponseMessage response = new HttpResponseMessage();
Stream stri = new MemoryStream(filecontent);
response.Content = new StreamContent(stri);
response.Content.Headers.ContentDisposition = new ContentDispositionHeaderValue("attachment");
response.Content.Headers.ContentDisposition.FileName = "Disponibles_a_pago_SIL_" + re + ".xlsx";
response.Content.Headers.ContentType = new MediaTypeHeaderValue(ExcelExportHelper.ExcelContentType);
response.Content.Headers.ContentLength = stri.Length;
return(response);
}
private byte[] ReporteObjetivo(List <M_ObjetivoExcel> reporte)
{
try
{
M_Excel excelNew = new M_Excel();
M_Worksheet workSheet = new M_Worksheet
{
Header = "Reporte de Objetivos",
Data = DTHelper.ToDataTable(reporte),
};
workSheet.Columns.Add(new M_Column(0, "Motivo", "Motivo"));
workSheet.Columns.Add(new M_Column(1, "EstadoObjetivo", "Estado"));
workSheet.Columns.Add(new M_Column(4, "Moneda", "Moneda"));
workSheet.Columns.Add(new M_Column(5, "Importe", "Importe"));
workSheet.Columns.Add(new M_Column(6, "FechaVencimiento", "Fecha de Vencimiento", typeof(DateTime)));
workSheet.Columns.Add(new M_Column(7, "Descripcion", "Descripción"));
excelNew.WorksheetList.Add(workSheet);
return(ExcelExportHelper.ExportExcel(excelNew));
}
catch (Exception ex)
{
throw ex;
}
}
private byte[] ReporteRegistro(List <M_RegistroExcel> reporte)
{
try
{
M_Excel excelNew = new M_Excel();
M_Worksheet workSheet = new M_Worksheet
{
Header = "Reporte de Registros",
Data = DTHelper.ToDataTable(reporte),
};
workSheet.Columns.Add(new M_Column(0, "TipoRegistro", "Tipo de Registro"));
workSheet.Columns.Add(new M_Column(1, "Categoria", "Categoría"));
workSheet.Columns.Add(new M_Column(2, "SubCategoria", "Subcategoría"));
workSheet.Columns.Add(new M_Column(3, "Moneda", "Moneda"));
workSheet.Columns.Add(new M_Column(4, "Importe", "Importe"));
workSheet.Columns.Add(new M_Column(5, "Fecha", "Fecha", typeof(DateTime)));
workSheet.Columns.Add(new M_Column(6, "Descripcion", "Descripción"));
excelNew.WorksheetList.Add(workSheet);
return(ExcelExportHelper.ExportExcel(excelNew));
}
catch (Exception ex)
{
throw ex;
}
}
protected void ExportToExcelButtonOnClick(object sender, EventArgs e)
{
string[] columns = { "MonthName", "Inventory", "Utilization",
"TicketsSold", "TicketsRedeemed", "TicketsExpired","TicketsRefunded",
"GrossSales", "NetSales", "NetRevenue", "AvgIncrementalRevenue",
"PercentSold", "PercentRedeemed", "PercentExpired","PercentRefunded" };
_result = _bookingRepository.GetSalesReportByHotelId(PublicHotel.HotelId, PublicHotel.TimeZoneId, int.Parse(YearDdl.SelectedValue));
byte[] filecontent = ExcelExportHelper.ExportExcel(_result, columns);
var fileName = string.Format("SalesReport_{2}_{0}_{1:yyyyMMdd}.xlsx",
PublicHotel.HotelName.Replace(" ", "_"), DateTime.Now, YearDdl.SelectedValue);
using (var writer = new BinaryWriter(File.OpenWrite(Server.MapPath(string.Format("/Helper/{0}", fileName)))))
{
writer.Write(filecontent);
writer.Flush();
writer.Close();
}
Response.ContentType = ExcelExportHelper.ExcelContentType;
Response.AppendHeader("Content-Disposition", "attachment; filename=" + fileName);
Response.TransmitFile(Server.MapPath("~/Helper/" + fileName));
Response.End();
}
public async Task <JsonResult> Export(TFilter filter, long[] removed, TEntity[] addedOrEdited)
{
return(await RunWithResult(async() =>
{
var items = await GetFilteredItems(filter, true);
var afterEdits = new List <TEntity>();
var editedList = addedOrEdited == null ? new List <TEntity>() : addedOrEdited.Where(p => p.Id > 0);
foreach (var item in items)
{
if (removed == null || !removed.Contains(item.Id))
{
var edited = editedList.FirstOrDefault(p => p.Id == item.Id);
if (edited != null)
{
afterEdits.Add(edited);
}
else
{
afterEdits.Add(item);
}
}
}
if (addedOrEdited != null)
{
afterEdits.InsertRange(0, addedOrEdited.Where(p => p.Id == 0).ToList());
}
return afterEdits.Any() ? ExcelExportHelper.SaveToExcel(afterEdits, _fileStoragePath) : null;
}, $"Failed to export {EntityName} items to Excel file"));
}
/// <summary>
/// Reporte 2. Devuelve los datos de los bancos y agencias
/// </summary>
/// <returns></returns>
public FileContentResult R2zJ2UHV()
{
try
{
string TituloWorksheet = "Cuentas por Mision";
string NombreFileExcel = "CuentasPorMision.xlsx";
List <BancoCuentaMisionXls> Bancos = new List <BancoCuentaMisionXls>();
Bancos = new BLBanco().ExpBancoAgenciaCuentaMision().ToList();
string[] columns = { "OrganoServicio", "Cuenta", "Banco", "Agencia", "Domicilio1", "Domicilio2", "Tipo", "Pais", "Situacion" };
if (Bancos.Count > 0)
{
byte[] filecontent = ExcelExportHelper.ExportExcel(
Bancos, TituloWorksheet,
String.Format("Exportado por {0} el {1} a las {2}.", User.Usuario, DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString()),
true,
columns);
return(File(filecontent, ExcelExportHelper.ExcelContentType, NombreFileExcel));
}
else
{
return(File(Encoding.UTF8.GetBytes("No hay datos"), "text/plain", string.Format("Reporte.txt")));
}
}
catch (Exception ex)
{
AddToastMessage("Sesion registrada", "Ha intentado acceder a una ubicación no permitida para su perfil.", BootstrapAlertType.danger);
throw ex;
}
}
public ActionResult ExportToExcel()
{
//Get the data from database into datatable
var leads = from s in db.Leads
where s.isDeleted == false
select new
{
Email_Sent_Date = s.EmailDate,
Source = s.Source,
Date_of_Request = s.RequestDate,
Case_Attended_By = s.CaseAttendedBy,
Client_Name = s.ClientName,
Company_Name = s.CompanyName,
Email_Address = s.Email,
Contact_Number_1 = s.ContactNumber1,
Contact_Number_2 = s.ContactNumber2,
Service_Request = s.ServiceRequester.ServiceName,
Country_License_Type = s.CountryLicense.CountryLicenseTypeName,
Follow_Up_Date = s.FollowUpDate,
Follow_Up_Date2 = s.FollowUpDate2,
Remarks = s.Remarks
};
var list_leads = leads.ToList();
byte[] filecontent = ExcelExportHelper.ExportExcel(list_leads, "Leads");
return(File(filecontent, ExcelExportHelper.ExcelContentType, "Leads.xlsx"));
}
public ActionResult ExcelImport(HttpPostedFileBase file)
{
var list = ExcelExportHelper.ImportExcel <FoodMap>(file.InputStream);
string msg = "";
foreach (var item in list)
{
string res = DoMap(item.Token, item.ItemId, item.SpecId, item.ProdNo);
if (!string.IsNullOrEmpty(res))
{
msg += res;
}
}
if (string.IsNullOrEmpty(msg))
{
return(Json(new AjaxResult()
{
state = "ok"
}));
}
else
{
return(Json(new AjaxResult()
{
state = "no", msg = msg
}));
}
}
public async Task <FileContentResult> ExportToExcel(char tabIndex)
{
var filter = new FilterModel
{
CompId = CurrentUser.CompanyId
,
tabIndex = tabIndex,
UserId = CurrentUser.UserId,
Type = tabIndex
};
var response = await _customerSupport.GetASPCalls(filter);
var OtherRes = new List <UploadedExcelModel>();
filter.Type = tabIndex;
if (tabIndex != 'P')
{
OtherRes = await _RepoCallLog.GetExclatedCalls(filter);
}
byte[] filecontent;
string[] columns;
if (tabIndex == 'P')
{
columns = new string[] { "CRN", "ClientName", "CreatedOn", "ServiceTypeName", "CustomerName", "CustomerContactNuber", "CustomerEmail",
"CustomerAddress", "CustomerCity", "CustomerPinCode", "DeviceCategory",
"DeviceBrand", "DeviceModel", "DOP", "DevicePurchaseFrom" };
filecontent = ExcelExportHelper.ExportExcel(response.PendingCalls, "", true, columns);
}
else if (tabIndex == 'A')
{
columns = new string[] { "CRN", "ClientName", "CreatedOn", "ServiceTypeName", "CustomerName", "CustomerContactNuber", "CustomerEmail",
"CustomerAddress", "CustomerCity", "CustomerPinCode", "DeviceCategory",
"DeviceBrand", "DeviceModel", "DOP", "DevicePurchaseFrom" };
filecontent = ExcelExportHelper.ExportExcel(OtherRes, "", true, columns);
}
else if (tabIndex == 'E')
{
columns = new string[] { "CRN", "ClientName", "CreatedOn", "ServiceTypeName", "CustomerName", "CustomerContactNuber", "CustomerEmail",
"CustomerAddress", "CustomerCity", "CustomerPinCode", "DeviceCategory",
"DeviceBrand", "DeviceModel", "DOP", "DevicePurchaseFrom" };
filecontent = ExcelExportHelper.ExportExcel(OtherRes, "", true, columns);
}
else if (tabIndex == 'C')
{
columns = new string[] { "CRN", "ClientName", "CreatedOn", "ServiceTypeName", "CustomerName", "CustomerContactNuber", "CustomerEmail",
"CustomerAddress", "CustomerCity", "CustomerPinCode", "DeviceCategory",
"DeviceBrand", "DeviceModel", "DOP", "DevicePurchaseFrom" };
filecontent = ExcelExportHelper.ExportExcel(OtherRes, "", true, columns);
}
else
{
columns = new string[] { "CRN", "ClientName", "CreatedOn", "ServiceTypeName", "CustomerName", "CustomerContactNuber", "CustomerEmail",
"CustomerAddress", "CustomerCity", "CustomerPinCode", "DeviceCategory",
"DeviceBrand", "DeviceModel", "DOP", "DevicePurchaseFrom", "ProviderName" };
filecontent = ExcelExportHelper.ExportExcel(response.AllocatedCalls, "", true, columns);
}
return(File(filecontent, ExcelExportHelper.ExcelContentType, "Excel.xlsx"));
}
/// <summary>
/// 导出excel
/// </summary>
/// <returns></returns>
public FileContentResult ExportToExcel()
{
List <Student> news = db.Student.ToList();
string[] columns = { "编号", "学号", "姓名", "性别", "照片", "密码", "身份证", "民族", "籍贯", "政治面貌", "手机号", "入学年份", "学籍状态" };
byte[] filecontent = ExcelExportHelper.ExportExcel(news, "", false, columns);
return(File(filecontent, ExcelExportHelper.ExcelContentType, "MyStudent.xlsx"));
}
public FileContentResult ExportToExcel()
{
List <Technology> technologies = StaticData.Technologies;
string[] columns = { "Name", "Project", "Developer" };
byte[] filecontent = ExcelExportHelper.ExportExcel(technologies, "Technology", true, columns);
return(File(filecontent, ExcelExportHelper.ExcelContentType, "Technologies.xlsx"));
}
public FileContentResult ExportToExcel()
{
string[] columns = { "Name", "Location", "Type", "State", "KWh", "DateTime" };
byte[] filecontent = ExcelExportHelper.ExportExcel(apiController.logList, "Device Log", true, columns);
String date = DateTime.Now.ToString("dd-MM-yyyy");
return(File(filecontent, ExcelExportHelper.ExcelContentType, "DeviceLog-" + date + ".xlsx"));
}
public FileContentResult ExportToExcel()
{
List <Newsletter> savedUserNewsletters = EpPlusExcelStaticList.SavedUserNewsletters;
string[] columns = { "Email", "UnscribeCode", "UnscribeLink" };
byte[] filecontent = ExcelExportHelper.ExportExcel(savedUserNewsletters, "Newsletter", true, columns);
return(File(filecontent, ExcelExportHelper.ExcelContentType, "NewsletterListEmail.xlsx"));
}
public FileContentResult ExportToExcelOOXML()
{
var data = db.Employee.ToList();
string[] columns = { "Name", "Project", "Developer" };
byte[] filecontent = ExcelExportHelper.ExportExcel(data, "Technology", true, columns);
return(File(filecontent, ExcelExportHelper.ExcelContentType, "Technologies.xlsx"));
}
public FileResult ExcelExport(string token, long shopId)
{
var list = GetFoodMapList(token, shopId);
string[] columns = { "Token", "CateId", "CateName", "ItemId", "ItemName", "SpecId", "SpecName", "Price", "Price", "ProdNo", "ProdName", "ProdUnit", "SalePrice" };
byte[] filecontent = ExcelExportHelper.ExportExcel(list, "", false, columns);
return(File(filecontent, ExcelExportHelper.ExcelContentType, "商品映射信息.xlsx"));
}
//导出
public FileContentResult ExportToExcel()
{
List <Student> lstStudent = StaticDataOfStudent.ListStudent;
string[] columns = { "ID", "Name", "Age" };
byte[] filecontent = ExcelExportHelper.ExportExcel(lstStudent, "", false, columns);
return(File(filecontent, ExcelExportHelper.ExcelContentType, "MyStudent.xlsx"));
}
public FileContentResult ExportToExcel()
{
List <Ent_Inventario_Consulta> list = (List <Ent_Inventario_Consulta>)Session[_session_tabla_inventCons_private];
string[] columns = { "des_entid", "articulo", "calidad", "talla", "teorico", "fisico", "diferencia", "nombres_venta", "fecha_inv" };
byte[] filecontent = ExcelExportHelper.ExportExcel(list, "Inventario_Consulta", true, columns);
return(File(filecontent, ExcelExportHelper.ExcelContentType, "Inventario_Consulta.xlsx"));
}
public ActionResult Get()
{
List <Student> lstStudent = StaticDataOfStudent.ListStudent;
string[] columns = { "ID", "Name", "Age", "Gender" };
byte[] filecontent = ExcelExportHelper.ExportExcel(lstStudent, "Sheet1", columns);
return(File(filecontent, ExcelExportHelper.ExcelContentType, "MyStudent.xlsx"));
}
/// <summary>
/// 匯出相關事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ExportButton_Click(object sender, EventArgs e)
{
#region
try
{
ErrorMsgLabel.Text = "";
if (ExportFileTextBox.Text.Trim() == "")
{
ExportFileTextBox.Text = "到貨配本記錄查詢.xls";
}
ALOModel.QueryDisRecordReport BCO = new ALOModel.QueryDisRecordReport(ConnectionDB);
ArrayList ParameterList = new ArrayList();//20091113
ParameterList.Clear();
#region 加入變數
//門市進貨日起迄
ParameterList.Add(SLP_ST_AcceptDateRange.StartDate);
ParameterList.Add(SLP_ST_AcceptDateRange.EndDate);
//配本日期起迄
ParameterList.Add(SLP_DISDateRange.StartDate);
ParameterList.Add(SLP_DISDateRange.EndDate);
//群分類起迄
ParameterList.Add(SLP_RootNo_S.Text);
ParameterList.Add(SLP_RootNo_E.Text);
//大分類起迄
ParameterList.Add(SLP_PMA_S.Text);
ParameterList.Add(SLP_PMA_E.Text);
//Pattern起迄
ParameterList.Add(SLP_Pattern_S.Text);
ParameterList.Add(SLP_Pattern_E.Text);
//品號/品名起迄
ParameterList.Add(SLP_SKU_S.Text);
ParameterList.Add(SLP_SKU_E.Text);
//期別起迄
ParameterList.Add(SLP_ItemPeriod_S.Text);
ParameterList.Add(SLP_ItemPeriod_E.Text);
//通路起迄
ParameterList.Add(SLP_StoreChain_S.Text);
ParameterList.Add(SLP_StoreChain_E.Text);
//門市起迄
ParameterList.Add(SLP_Store_S.Text);
ParameterList.Add(SLP_Store_E.Text);
//路線起迄
ParameterList.Add(SLP_Route_S.Text);
ParameterList.Add(SLP_Route_E.Text);
//配本序號1起迄
ParameterList.Add(DIS_NO_1_S_TxtBox.Text);
ParameterList.Add(DIS_NO_1_E_TxtBox.Text);
//配本序號2起迄
ParameterList.Add(DIS_NO_2_S_TxtBox.Text);
ParameterList.Add(DIS_NO_2_E_TxtBox.Text);
//配本序號3起迄
ParameterList.Add(DIS_NO_3_S_TxtBox.Text);
ParameterList.Add(DIS_NO_3_E_TxtBox.Text);
//配本序號4起迄
ParameterList.Add(DIS_NO_4_S_TxtBox.Text);
ParameterList.Add(DIS_NO_4_E_TxtBox.Text);
//配本序號5起迄
ParameterList.Add(DIS_NO_5_S_TxtBox.Text);
ParameterList.Add(DIS_NO_5_E_TxtBox.Text);
//傳入筆數
ParameterList.Add("");
//需要Group By的欄位
//ParameterList.Add("t.ROOT_NO,t.ROOT_Name");
ALOModelDBO.DisRecordGroupByCloumnStruct GStruct = new ALOModelDBO.DisRecordGroupByCloumnStruct();
#region 組合T-SQL 需要的UI元件
GStruct.RootNo = RootCheckbox.Checked;
GStruct.PMA = PMACheckbox.Checked;
GStruct.PatternNo = PatternNOCheckbox.Checked;
GStruct.Item = ItemCheckbox.Checked;
GStruct.Period = PeriodCheckbox.Checked;
GStruct.DisType = DISTypeCheckbox.Checked;
GStruct.DisDate = DISDateCheckbox.Checked;
GStruct.DisNo = DISNOCheckbox.Checked;
GStruct.ApproveDate = ApproveDateCheckbox.Checked;
GStruct.StoreQty = StoreQtyCheckbox.Checked;
GStruct.ZO = ZOCheckbox.Checked;
GStruct.Route = RouteCheckbox.Checked;
GStruct.TransNo = TransNoCheckbox.Checked;
GStruct.AreaCode = AreaCodeCheckbox.Checked;
GStruct.DO = DOCheckbox.Checked;
GStruct.BusinessNo = BusinessNoCheckbox.Checked;
GStruct.ChanNo = ChanNoCheckbox.Checked;
GStruct.Store = StoreCheckbox.Checked;
GStruct.PoSourceNo = chk_POSourceNo.Checked;
#endregion
ParameterList.Add(GStruct);
//包含配量=0的門市 2010/01/13
ParameterList.Add(chk_DisQtyEqualZero.Checked ? 1 : 0);
#endregion
DataTable Dt = BCO.QueryDisRecordReportData(ParameterList);
if (Dt.Rows.Count > 0)
{
if (Dt.Rows.Count < 60000)//20091014 新增資料匯出筆數限制
{
ExcelExportHelper ExcelEH = new ExcelExportHelper();
string FileCode = ExportFileTextBox.Text;
if (FileCode == "")
{
FileCode = "ALO16_" + Session["UID"].ToString() + ".xls";
}
//NEW3:
ExportExcelUsingMemoryStream(Dt, FileCode);
//NEW2:
//Export_Excel(Dt, FileCode);
//20091016 解決匯出時發生夾雜UI控制象的情況
//NEW:
//WriteToXls(Dt, FileCode);
//OLD:
//ExcelEH.OutputExcel(Page,
// Dt,
// FileCode
// );
}
else
{
ErrorMsgLabel.Text = "資料筆數超過60000筆";
}
}
}
catch (Exception ex)
{
ErrorMsgLabel.Text = ex.Message;
}
#endregion
}
