protected void Page_PreRender(object sender, EventArgs e) { filters.Visible = true; Master.PageTitle = SupplierEventStrings.GetText(@"ServiceSuppliersReportPageTitle"); Master.ActiveMenu = "ServiceSuppliersReport"; Master.AddClientScriptInclude(@"dgDateManager.js"); }
protected void btnExport_Click(object sender, EventArgs e) { System.Data.DataTable dt = new System.Data.DataTable(); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"SupplierId"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"BusinessName"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"Phone"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"ContactName"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"ContactPhone"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SuppliersStrings.GetText(@"CityName"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SupplierEventStrings.GetText(@"ClickNum"), typeof(string))); dt.Columns.Add(new System.Data.DataColumn(SupplierEventStrings.GetText(@"ClickToCallNum"), typeof(string))); List <SupplierServiceUI> suppliers = new List <SupplierServiceUI>(); string searchName = txtSearchName.Text.Trim(); string searchPhone = txtSearchPhone.Text.Trim(); string searchId = txtSearchSupplierId.Text.Trim(); string searchCity = txtSearchCity.Text.Trim(); DateTime from, to = new DateTime(); DateTime.TryParse(datepickerFrom.Text.ToString(), out from); DateTime.TryParse(datepickerTo.Text.ToString(), out to); suppliers = ServiceController.GetServiceSuppliersAndNumEvents(searchName, searchPhone, searchId, searchCity, from, to, true); foreach (SupplierServiceUI supplier in suppliers) { System.Data.DataRow row = dt.NewRow(); row[0] = supplier.SupplierId; row[1] = supplier.BusinessName; row[2] = "\"" + supplier.Phone + "\""; row[3] = supplier.ContactName; row[4] = "\"" + supplier.ContactPhone + "\""; row[5] = supplier.CityName; row[6] = supplier.ClickNum; row[7] = supplier.ClickToCallNum; dt.Rows.Add(row); } //System.Data.DataRow sumRow = dt.NewRow(); //sumRow[0] = SuppliersStrings.GetText(@"SumSumPerMonth") + " " + suppliers.Sum(o => o.SumPerMonth); //dt.Rows.Add(sumRow); SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, false, true); Response.Clear(); Response.AddHeader(@"content-disposition", @"attachment;filename=ServiceSuppliersReport_" + DateTime.UtcNow.ToString(@"yyyy_MM_dd_HH_mm_ss") + "." + ex.FileExtension); Response.Charset = @"UTF-8"; Response.ContentEncoding = System.Text.Encoding.UTF8; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.ContentType = ex.FileContentType; Response.BinaryWrite(System.Text.Encoding.UTF8.GetPreamble()); Response.Write(ex.ToString()); Response.End(); }