/// <summary>
/// Consultar nota
/// </summary>
/// <param name="Codigo"></param>
/// <returns></returns>
public ActionResult DetalharNota(int Codigo)
{
NotaFiscal nota = NotaFiscalNeg.Buscar(Codigo);
List <ListaProdutoAux> itens = new List <ListaProdutoAux>();
foreach (Item item in nota.Itens)
{
itens.Add(new ListaProdutoAux()
{
Nome = item.Produto.Nome, Quantidade = item.Quantidade, Preco = item.Produto.Preco
});
}
System.Web.UI.WebControls.GridView gView = new System.Web.UI.WebControls.GridView();
gView.DataSource = itens;
gView.DataBind();
using (System.IO.StringWriter sw = new System.IO.StringWriter())
{
using (System.Web.UI.HtmlTextWriter htw = new System.Web.UI.HtmlTextWriter(sw))
{
gView.RenderControl(htw);
ViewBag.GridViewString = sw.ToString();
}
}
return(View(nota));
}
public ActionResult ExportToExcel()
{
List <Employee_Master> emplist = new List <Employee_Master>();
emplist = db.Employee_Master.ToList();
var grid = new System.Web.UI.WebControls.GridView();
grid.DataSource = from p in emplist
select new
{
Name = p.Name.ToString(),
Dob = p.Date_Of_Birth.ToString(),
Country = p.Country_Info.Country_name.ToString(),
City = p.City_Info.City_Name.ToString(),
State = p.State_info.State_Name.ToString(),
EmailId = p.EmailId.ToString(),
Phone = p.Phone.ToString()
};
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=MyFile.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter tw = new HtmlTextWriter(sw);
grid.RenderControl(tw);
Response.Write(sw.ToString());
Response.End();
return(Json("Success"));
}
public void CommonExcuteTest_Return_SchoolAllRequestPostingList()
{
//Arrange
string action = "Positions";
var myGridview = new System.Web.UI.WebControls.GridView();
parameter.Operate = action;
string expect = "334";
//Act
string SP = CommonExcute.SPNameAndParameters(SPFile, cPage, action);
var postingList = CommonExcute <PositionListRequesting> .GeneralList(SP, parameter);
myGridview.AutoGenerateColumns = true;
myGridview.DataSource = postingList;
myGridview.DataBind();
var result = myGridview.Rows.Count.ToString();
//Assert
// Assert.AreEqual(expect, result, $" Posting position List { result}");
Assert.IsNotNull(result, $" Posting position List { result}");
}
public void PositionsTest_PostingRequestList_ReturnAllbySchool()
{
//Arrange
var myGridview = new System.Web.UI.WebControls.GridView();
// var parameters = CommonParameter.GetParameters("Request", User.Identity.Name, Me.ddlSchoolYear.SelectedValue, Me.ddlschoolcode.SelectedValue)
var parameter = new ParametersForPositionList()
{
Operate = "Retrieve",
UserID = "mif",
SchoolYear = schoolyear,
SchoolCode = "0320"
};
string expect = "334";
//Act
var postingList = PostingPublishExe.Positions(parameter);
myGridview.AutoGenerateColumns = true;
myGridview.DataSource = postingList;
myGridview.DataBind();
var result = myGridview.Rows.Count.ToString();
//Assert
Assert.IsNotNull(result, $" Posting position List { result}");
}
/// <summary>
/// Autor: jlucero
/// Fecha: 2015-06-16
/// </summary>
/// <param name="__a"></param>
/// <returns></returns>
//[HttpPost]
//public JsonResult Descarga(string __a)
//{
// Int32 _fila = 2;
// String _servidor;
// String _ruta;
// //if (__a.Length == 0)
// //{
// // return View();
// //}
// List<Observacion> _lista = MvcApplication._Deserialize<List<Observacion>>(__a);
// _servidor = String.Format("{0:ddMMyyyy_hhmmss}.xlsx", DateTime.Now);
// _ruta = Path.Combine(Server.MapPath("/Temp"), _servidor);
// FileInfo _file = new FileInfo(_ruta);
// if (_file.Exists)
// {
// _file.Delete();
// _file = new FileInfo(_ruta);
// }
// using (Excel.ExcelPackage oEx = new Excel.ExcelPackage(_file))
// {
// Excel.ExcelWorksheet oWs = oEx.Workbook.Worksheets.Add("Observacion");
// oWs.Cells[1, 1].Value = "ID";
// oWs.Cells[1, 2].Value = "ABREVIATURA";
// oWs.Cells[1, 3].Value = "DESCRIPCION";
// oWs.Cells[1, 4].Value = "GRUPO";
// oWs.Cells[1, 5].Value = "";
// foreach (Observacion oBj in _lista)
// {
// oWs.Cells[_fila, 1].Value = oBj.obs_id;
// oWs.Cells[_fila, 2].Value = oBj.obs_abreviatura;
// oWs.Cells[_fila, 3].Value = oBj.obs_descripcion;
// oWs.Cells[_fila, 4].Value = oBj.gde_descripcion;
// oWs.Cells[_fila, 5].Value = (oBj.obs_estado == 2 ? "Inactivo" : "Activo");
// _fila++;
// }
// oWs.Row(1).Style.WrapText = true;
// oWs.Row(1).Style.Font.Bold = true;
// oWs.Row(1).Style.HorizontalAlignment = Style.ExcelHorizontalAlignment.Center;
// oWs.Row(1).Style.VerticalAlignment = Style.ExcelVerticalAlignment.Center;
// oWs.Column(1).Style.Font.Bold = true;
// oWs.Column(1).AutoFit();
// oWs.Column(2).AutoFit();
// oWs.Column(3).AutoFit();
// oWs.Column(4).AutoFit();
// oWs.Column(5).AutoFit();
// oEx.Save();
// }
// Response.ClearContent();
// Response.AddHeader("content-disposition", "attachment; filename=Cuenta_corriente.xls");
// Response.ContentType = "application/json";
// return Json(new { Archivo = _servidor });
// //return new ContentResult
// //{
// // Content = "{ \"__a\": \"" + _servidor + "\" }",
// // ContentType = "application/x-ms-excel"
// //};
//}
public ActionResult Descarga(string __a)
{
var grid = new System.Web.UI.WebControls.GridView();
//var collection = List<Observacion>(__a);
var collection = new NObservacion().NLista();
//var collection = CuentaCorrienteAD.Instancia.ListarAll("", 10);
grid.DataSource = from d in collection
select new
{
ID = d.obs_id,
ABREVIATURA = d.obs_abreviatura,
DESCRIPCION = d.obs_descripcion,
GRUPO = d.gde_descripcion,
ESTADO = (d.obs_estado == 2 ? "Inactivo" : "Activo"),
PIDE_FOTO = (d.obs_pideFoto == "2" ? "Inactivo" : "Activo"),
NO_PIDE_FOTO = (d.obs_noPideFoto == "2" ? "Inactivo" : "Activo")
};
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Observacion_Listado.xls");
Response.ContentType = "application/x-ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
return(null);
}
public ActionResult Index_Post(String lang, String excelCall)
{
if (!string.IsNullOrEmpty(lang))
{
if (HomeController.Language == "1")
{
HomeController.Language = "2";
Session["Lang"] = "Arabic";
}
else
{
if (HomeController.Language == "2")
{
HomeController.Language = "1";
Session["Lang"] = "English";
}
}
}
if (!string.IsNullOrEmpty(excelCall))
{
var natTable = new System.Data.DataTable("teste");
natTable.Columns.Add("المرجع", typeof(string));
natTable.Columns.Add("الحالة", typeof(string));
//natTable.Columns.Add("المجموعة", typeof(string));
natTable.Columns.Add("التصنيف", typeof(string));
//natTable.Columns.Add("رقم العداد", typeof(string));
natTable.Columns.Add("الجنسية", typeof(string));
natTable.Columns.Add("الرمز", typeof(string));
var Lrecord = db.CR_Mas_Sup_Nationalities.ToList();
if (Lrecord != null)
{
foreach (var i in Lrecord)
{
natTable.Rows.Add(i.CR_Mas_Sup_Nationalities_Reasons, i.CR_Mas_Sup_Nationalities_Status,
i.CR_Mas_Sup_Nationalities_Country_Code, i.CR_Mas_Sup_Nationalities_Ar_Name, i.CR_Mas_Sup_Nationalities_Code);
}
}
var grid = new System.Web.UI.WebControls.GridView();
grid.DataSource = natTable;
grid.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=MyExcelFile.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Output.Write(sw.ToString());
Response.Flush();
Response.End();
}
return(View(db.CR_Mas_Sup_Nationalities.ToList()));
}
public void PositionsTest_return_allRequestList()
{
//Arrange
var myGridview = new System.Web.UI.WebControls.GridView();
var parameter = new ParametersForPositionList()
{
Operate = "Page",
UserID = "mif",
SchoolYear = schoolyear,
PositionType = "LTO",
};
int expect = 1;
//Act
var postingList = PostingApproveRequestExe.Positions(parameter);
myGridview.AutoGenerateColumns = true;
myGridview.DataSource = postingList;
myGridview.DataBind();
int result = myGridview.Rows.Count;
//Assert
// Assert.AreEqual(expect, result, $" Posting position List { result}");
//int gCount
Assert.IsTrue(result >= 0, $" Posting approve position List { result}");
}
public void ExportXls(String strPesquisa)
{
if (String.IsNullOrEmpty(strPesquisa))
{
strPesquisa = String.Empty;
}
ViewData["termo"] = strPesquisa;
var departamento = db.DEPARTAMENTOes.ToList();
//Codigo Gerou na Index desta Controller (Final da Página)
var grid = new System.Web.UI.WebControls.GridView();
grid.DataSource = from _data in departamento select _data;
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=departamento.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
public void CommonExcuteTest_Return_ApprovePostionList_Searchby_School_0290()
{
//Arrange
string action = "Positions";
var myGridview = new System.Web.UI.WebControls.GridView();
var parameter = new ParametersForPositionList()
{
Operate = action,
UserID = "mif",
SchoolYear = "20192020",
PositionType = "LTO",
Panel = "All",
Status = "Open",
SearchBy = "School",
SearchValue1 = "0290",
SearchValue2 = ""
};
string expect = "3";
//Act
string SP = CommonExcute.SPNameAndParameters(SPFile, cPage, action);
var postingList = CommonExcute <PositionApprove> .GeneralList(SP, parameter);
myGridview.AutoGenerateColumns = true;
myGridview.DataSource = postingList;
myGridview.DataBind();
var result = myGridview.Rows.Count.ToString();
//Assert
// Assert.AreEqual(expect, result, $" Posting position List { result}");
Assert.IsNotNull(result, $" Approve position List by {parameter.SearchBy} { parameter.SchoolCode} { result}");
}
public ActionResult downloadweekly(DateTime DeliverTime, string restcode)
{
if (DeliverTime != null)
{
ViewBag.Message = "Your application description page.";
Ankapurservices objCrd = new Ankapurservices();
var modelCust1 = objCrd.Weeklyreports(DeliverTime, restcode);
var gv = new System.Web.UI.WebControls.GridView();
gv.DataSource = modelCust1;
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=ankapurchickenweekly.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter objStringWriter = new StringWriter();
HtmlTextWriter objHtmlTextWriter = new HtmlTextWriter(objStringWriter);
gv.RenderControl(objHtmlTextWriter);
Response.Output.Write(objStringWriter.ToString());
Response.Flush();
Response.End();
return(RedirectToAction("Index", "dailyReport"));
}
return(Content("<script> alert('please select date')</script>"));
}
public void ExportBookedSeatsToExcel()
{
var seats = new System.Data.DataTable("bookers");
seats.Columns.Add("Area", typeof(string));
seats.Columns.Add("Name", typeof(string));
seats.Columns.Add("Number", typeof(string));
seats.Columns.Add("Seat", typeof(string));
seats.Columns.Add("Price", typeof(string));
seats.Columns.Add("Booked by", typeof(string));
seats.Columns.Add("Booked at", typeof(DateTime));
db.Seats.Where(s => s.Status == SeatStatus.Booked).ToList().ForEach(s =>
{
seats.Rows.Add(s.AreaDescriptionEn, s.RowNameEn, s.RowNumber, s.SeatNumber, s.Price,
s.BookedBy.LastName + " " + s.BookedBy.FirstName, s.BookedAt);
});
var grid = new System.Web.UI.WebControls.GridView();
grid.DataSource = seats;
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Seats.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
public ActionResult Exports(string username, string time, string content, int?page)
{
var grid = new System.Web.UI.WebControls.GridView();
int i = 1;
grid.DataSource = from item in GetCoaches(username, time, content, page)
select new
{
序号 = i++,
记录人 = item.UserName,
内容 = item.NoteContent,
评论 = item.CommentContent,
发布时间 = item.ReleaseTime
};
grid.DataBind();
Response.ClearContent();
string name = "记与思统计表" + DateTime.Now.ToString("yyyyMMddHHmmssffff");
Response.AddHeader("content-disposition", "attachment; filename='" + name + "'.xls");
Response.Buffer = true;
Response.Charset = "UTF-8";
Response.ContentEncoding = Encoding.UTF8;
Response.ContentType = "application/ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
return(null);
}
public static void ExportExcelFile(string fileName, DataTable dataSource)
{
System.Web.UI.WebControls.GridView dgExport = null;
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
//IO is used to export and return Excel
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;
if (dataSource != null)
{
//Set encoding and attachment format
curContext.Response.Clear();
curContext.Response.Buffer = true;
//System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8)
//Note: The above code line is used to avoid unreadable code to appearing in file.
curContext.Response.AddHeader("content-disposition", "attachment; filename=" + System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8) + ".xls");
curContext.Response.ContentType = "application/vnd.ms-excel";
//Avoid unreadable code to appearing in contents exported.
curContext.Response.Write("<meta http-equiv=Content-Type content=text/html;charset=UTF-8>");
//Export to Excel
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
//Redefine one GridView without paging to solve the problem that there is paging in daData.
dgExport = new System.Web.UI.WebControls.GridView();
dgExport.DataSource = dataSource;
dgExport.AllowPaging = false;
dgExport.DataBind();
//Download to server.
dgExport.RenderControl(htmlWriter);
curContext.Response.Write(strWriter.ToString());
curContext.Response.End();
}
}
//public JsonResult UploadMedia(AcademicProfileVM academic)
//{
// var file = academic.ImageFile;
// if (file != null)
// {
// var fileName = Path.GetFileName(file.FileName);
// var extension = Path.GetExtension(file.FileName);
// var FileNameWithourExt = Path.GetFileNameWithoutExtension(file.FileName);
// file.SaveAs(Server.MapPath("/Uploads/" + file.FileName));
// }
// return Json(file.FileName, JsonRequestBehavior.AllowGet);
//}
public void ExportClientsListToExcel()
{
var grid = new System.Web.UI.WebControls.GridView();
grid.DataSource = /*from d in dbContext.diners
* where d.user_diners.All(m => m.user_id == userID) && d.active == true */
from d in EmpRep.GetAll()
select new
{
Name = d.Name,
Age = d.Age,
Department = d.Department,
Designation = d.Designation
};
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Exported_Diners.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
public void PositionsTest_Return_All_Published_PositionList()
{ //Arrange
ParametersForPositionList parameter = new ParametersForPositionList()
{
Operate = "Position",
UserID = "mif",
SchoolYear = "20192020",
PositionType = "LTO",
Panel = "All",
Status = "Open",
SearchBy = "All",
SearchValue1 = "",
SearchValue2 = ""
};
string action = "Position";
// parameter.Operate = action;
string expect = "334";
//Act
// var myList = new PostingPosition<PositionListPublish>(new PostingPublish<PositionListPublish>());
var myList = new Posting(new PostingPublish());
// IPostingPosition<PositionListPublish> myList = new PostingPublish<PositionListPublish>();
var testList = myList.Positions <PositionListPublish>(parameter);
var myGridview = new System.Web.UI.WebControls.GridView();
myGridview.AutoGenerateColumns = true;
myGridview.DataSource = testList;
myGridview.DataBind();
var result = myGridview.Rows.Count.ToString();
//Assert
// Assert.AreEqual(expect, result, $" Posting position List { result}");
Assert.IsNotNull(result, $" Request Posting position List { result}");
}
public void ExportTrackBookingReportToExcel()
{
var grid = new System.Web.UI.WebControls.GridView();
if (Session["TRACKBOOKINGS"] != null)
{
var resp = (List <BookingReporting>)Session["TRACKBOOKINGS"];
grid.DataSource = from r in resp
select new
{
QuotationNo = r.QuotationNumber,
InvoiceNo = r.InvoiceNumber,
Organiser = r.OrganiserName,
Company = r.CompanyName,
QuotationDate = r.QuotationDate.Value.ToString("dd-MMMM-yyyy"),
InvoicedDate = r.InvoiceDate.Value.ToString("dd-MMMM-yyyy"),
InvoiceTotal = r.InvoiceTotal,
BusType = r.BusType,
FleetNo = r.FleetNumber
};
}
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=TrackBooking_" + DateTime.Now.ToString("dd_MM_yyyy_HH_mm_ss") + ".xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
public void PositionsTest_ReturnPublishPostionList_SearchbyPostingCycle_3()
{
//Arrange
var myGridview = new System.Web.UI.WebControls.GridView();
var parameter = new ParametersForPositionList()
{
Operate = "Page",
UserID = "mif",
SchoolYear = schoolyear,
PositionType = "LTO",
Panel = "All",
Status = "",
SearchBy = "PostingCycle",
SearchValue1 = "3",
SearchValue2 = ""
};
string expect = "426";
//Act
var postingList = PostingPublishExe.Positions(parameter);
myGridview.AutoGenerateColumns = true;
myGridview.DataSource = postingList;
myGridview.DataBind();
var result = myGridview.Rows.Count.ToString();
//Assert
// Assert.AreEqual(expect, result, $" Posting position List { result}");
Assert.IsNotNull(result, $" Posting position List { result}");
}
/// <summary>
/// Cria uma linha para a grid.
/// </summary>
/// <param name="gridView"></param>
/// <param name="rowIndex"></param>
/// <param name="dataSourceIndex"></param>
/// <param name="rowType"></param>
/// <param name="rowState"></param>
/// <returns></returns>
public static System.Web.UI.WebControls.GridViewRow CreateRow(
this System.Web.UI.WebControls.GridView gridView,
int rowIndex, int dataSourceIndex,
System.Web.UI.WebControls.DataControlRowType rowType,
System.Web.UI.WebControls.DataControlRowState rowState)
{
var createRowMethod = typeof(System.Web.UI.WebControls.GridView).GetMethod("CreateRow",
System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance,
null, new Type[]
{
typeof(int),
typeof(int),
typeof(System.Web.UI.WebControls.DataControlRowType),
typeof(System.Web.UI.WebControls.DataControlRowState)
}, null);
try
{
return((System.Web.UI.WebControls.GridViewRow)createRowMethod.Invoke(gridView, new object[]
{
rowIndex, dataSourceIndex, rowType, rowState
}));
}
catch (System.Reflection.TargetInvocationException ex)
{
throw ex.InnerException;
}
}
public void Export()
{
var data = from a in this.customerData
select new
{
FirstName = a.FirstName,
LastName = a.LastName,
Email = a.Email,
CustNo = a.CustNo,
CompanyName = a.CompanyName,
CreatedDate = a.CreatedDate,
CreatedBy = a.CreatedBy
};
System.Web.UI.WebControls.GridView gv = new System.Web.UI.WebControls.GridView();
Dictionary <string, string> fields = new Dictionary <string, string>();
fields.Add("FirstName", "FirstName");
fields.Add("LastName", "LastName");
fields.Add("Email", "Email");
fields.Add("CustNo", "CustNo");
fields.Add("CompanyName", "CompanyName");
fields.Add("CreatedDate", "CreatedDate");
fields.Add("CreatedBy", "CreatedBy");
HtmlToExcelDashboardHelper.ExportFromGridView(this.httpResponse, fields, data, TargetFileName);
}
public void ExportCSV(System.Web.UI.WebControls.GridView exportGV, System.Web.HttpResponse Response)
{
string strFileName = "Report" + System.DateTime.Now.Date.ToString("dd") + System.DateTime.Now.AddMonths(0).ToString("MM") + System.DateTime.Now.AddYears(0).ToString("yyyy") + System.DateTime.Now.Millisecond.ToString("0000");
StringBuilder sb = new StringBuilder();
System.Web.UI.WebControls.GridViewRow grHeader = exportGV.HeaderRow;
int counter = 0;
foreach (System.Web.UI.WebControls.TableCell tc in grHeader.Cells)
{
sb.Append("\"" + exportGV.Columns[counter].HeaderText.Trim() + "\",");
counter++;
}
sb.AppendLine();
foreach (System.Web.UI.WebControls.GridViewRow gr in exportGV.Rows)
{
foreach (System.Web.UI.WebControls.TableCell tc in gr.Cells)
{
sb.Append("\"" + getGridCellText(tc) + "\",");
}
sb.AppendLine();
}
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Export.csv");
Response.ContentType = "text/csv";
Response.AddHeader("Pragma", "public");
Response.Write(sb.ToString());
Response.End();
}
/// <summary>
/// 将DataTable数据导出到EXCEL，调用该方法后自动返回可下载的文件流
/// </summary>
/// <param name="dtData">要导出的数据源</param>
public static void DataTable1Excel(System.Data.DataTable dtData)
{
System.Web.UI.WebControls.GridView gvExport = null;
// 当前对话
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
// IO用于导出并返回excel文件
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;
if (dtData != null)
{
// 设置编码和附件格式
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
curContext.Response.Charset = "utf-8";
// 导出excel文件
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
// 为了解决gvData中可能进行了分页的情况，需要重新定义一个无分页的GridView
gvExport = new System.Web.UI.WebControls.GridView();
gvExport.DataSource = dtData.DefaultView;
gvExport.AllowPaging = false;
gvExport.DataBind();
// 返回客户端
gvExport.RenderControl(htmlWriter);
curContext.Response.Write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\" />" + strWriter.ToString());
curContext.Response.End();
}
}
/// <summary>
/// Cria uma linha na grid informada.
/// </summary>
/// <param name="gridView"></param>
/// <param name="rowIndex"></param>
/// <param name="dataSourceIndex"></param>
/// <param name="rowType"></param>
/// <param name="rowState"></param>
/// <param name="dataBind"></param>
/// <param name="dataItem"></param>
/// <param name="fields"></param>
/// <param name="rows"></param>
/// <param name="pagedDataSource"></param>
/// <returns></returns>
public static System.Web.UI.WebControls.GridViewRow CreateRow(
this System.Web.UI.WebControls.GridView gridView,
int rowIndex, int dataSourceIndex, System.Web.UI.WebControls.DataControlRowType rowType,
System.Web.UI.WebControls.DataControlRowState rowState, bool dataBind, object dataItem,
System.Web.UI.WebControls.DataControlField[] fields, System.Web.UI.WebControls.TableRowCollection rows,
System.Web.UI.WebControls.PagedDataSource pagedDataSource)
{
var createRowMethod2 = typeof(System.Web.UI.WebControls.GridView).GetMethod("CreateRow",
System.Reflection.BindingFlags.NonPublic | System.Reflection.BindingFlags.Instance,
null, new Type[]
{
typeof(int), // rowIndex
typeof(int), // dataSourceIndex
typeof(System.Web.UI.WebControls.DataControlRowType), // rowType
typeof(System.Web.UI.WebControls.DataControlRowState), // rowState
typeof(bool), // dataBind
typeof(object), // dataItem,
typeof(System.Web.UI.WebControls.DataControlField[]), // fields
typeof(System.Web.UI.WebControls.TableRowCollection), // rows
typeof(System.Web.UI.WebControls.PagedDataSource) // pagedDataSource
}, null);
try
{
return((System.Web.UI.WebControls.GridViewRow)createRowMethod2.Invoke(gridView, new object[]
{
rowIndex, dataSourceIndex, rowType, rowState, dataBind, dataItem, fields, rows, pagedDataSource
}));
}
catch (System.Reflection.TargetInvocationException ex)
{
throw ex.InnerException;
}
}
public ActionResult DescargarGastosMensuales(DateTime mesano)
{
if (!((SUM.Models.Usuario)Session["Usuario"]).fl_administrador)
{
return(RedirectToAction("Index", "Home"));
}
var gv = new System.Web.UI.WebControls.GridView();
var gastosMensuales = db.sp_GastosMensuales(mesano, GetUsuario().cd_consorcio).OrderBy(x => x.cd_usuario).ToList();
gv.DataSource = gastosMensuales;
gv.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=GastosMensuales" + mesano.ToString("MM-yyyy") + ".xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
System.IO.StringWriter objStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter objHtmlTextWriter = new System.Web.UI.HtmlTextWriter(objStringWriter);
Response.Output.WriteLine("<b>Gastos Mensuales del consorcio " + GetUsuario().Consorcio.tx_descripcion + "</b>");
Response.Output.WriteLine("<br>");
Response.Output.WriteLine("<u>Periodo " + mesano.ToString("MM-yyyy") + "</u>");
Response.Output.WriteLine("<br>");
gv.RenderControl(objHtmlTextWriter);
Response.Output.WriteLine(objStringWriter.ToString());
Response.Output.WriteLine("<br>");
Response.Flush();
Response.End();
return(Redirect("GastosMensuales"));
}
public void PositionTest_Return_a_RequestPositionbyRequesID()
{
//Arrange
string action = "Position";
var myGridview = new System.Web.UI.WebControls.GridView();
request.Operate = action;
request.PositionID = getNewRequestID("LTO").ToString();
//Act
var testList = RequestPostingExe.Position(parameter);
myGridview.AutoGenerateColumns = true;
myGridview.DataSource = testList;
myGridview.DataBind();
var result = myGridview.Rows.Count.ToString();
//Assert
// Assert.AreEqual(expect, result, $" Posting position List { result}");
Assert.IsNotNull(result, $" Request Posting position List { result}");
}
/// <summary>
/// dtData是要导出为Excel的DataTable,FileName是要导出的Excel文件名(不加.xls)
/// </summary>
/// <param name="dtData"></param>
/// <param name="FileName"></param>
public static void DataTable3Excel(System.Data.DataTable dtData, String FileName)
{
System.Web.UI.WebControls.GridView dgExport = null;
//当前对话
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
//IO用于导出并返回excel文件
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;
if (dtData != null)
{
//设置编码和附件格式
//System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8)作用是方式中文文件名乱码
curContext.Response.AddHeader("content-disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8) + ".xls");
curContext.Response.ContentType = "application nd.ms-excel";
curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;
curContext.Response.Charset = "GB2312";
//导出Excel文件
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
//为了解决dgData中可能进行了分页的情况,需要重新定义一个无分页的GridView
dgExport = new System.Web.UI.WebControls.GridView();
dgExport.DataSource = dtData.DefaultView;
dgExport.AllowPaging = false;
dgExport.DataBind();
//下载到客户端
dgExport.RenderControl(htmlWriter);
curContext.Response.Write(strWriter.ToString());
curContext.Response.End();
}
}
public void DownloadExcelForSupplierLedger()
{
DataTable emps = TempData["Data"] as DataTable;
var grid = new System.Web.UI.WebControls.GridView();
grid.DataSource = emps;
grid.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
string filePath = Server.MapPath("~/SupplierLedgerXLSheet/" + 1 + "/generated/");
bool isExists = System.IO.Directory.Exists(filePath);
if (!isExists)
{
System.IO.Directory.CreateDirectory(filePath);
}
string fileName = "SupplierLedgerReport" + ".xls";
// Write the rendered content to a file.
string renderedGridView = sw.ToString();
System.IO.File.WriteAllText(filePath + fileName, renderedGridView);
}
/// <summary>
/// Autor: jlucero
/// Fecha: 2015-06-16
/// </summary>
/// <param name="__a"></param>
/// <returns></returns>
public ActionResult Descarga()
{
var grid = new System.Web.UI.WebControls.GridView();
var collection = new NServicio().NLista();
grid.DataSource = from d in collection
select new
{
ID = d.ser_id,
DESCRIPCION = d.ser_descripcion,
ESTADO = (d.ser_estado == 2 ? "Inactivo" : "Activo")
};
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Servicio_Listado.xls");
Response.ContentType = "application/x-ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
return(null);
}
public void ExportToExcel()
{
using (var mycontext = new xyzEntities())
{
var grid = new System.Web.UI.WebControls.GridView();
grid.DataSource = from d in mycontext.Customers
select new
{
Address = d.Address,
CompanyName = d.CompanyName,
Country = d.Country,
ContactName = d.ContactName
};
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Exported_Diners.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
}
public void ExportBookersToExcel()
{
var bookers = new System.Data.DataTable("bookers");
bookers.Columns.Add("LastName", typeof(string));
bookers.Columns.Add("FirstName", typeof(string));
bookers.Columns.Add("Email", typeof(string));
bookers.Columns.Add("Phone", typeof(string));
bookers.Columns.Add("Booked seats", typeof(string));
bookers.Columns.Add("Inviting company", typeof(string));
bookers.Columns.Add("After party", typeof(string));
var bookerList = GetBookersAndSeats();
bookerList.ForEach(b =>
{
bookers.Rows.Add(b.LastName, b.FirstName, b.Email, b.PhoneNumber, String.Join(" ", b.Seats), b.Face, (b.Party ?? false) ? "After party" : "");
});
var grid = new System.Web.UI.WebControls.GridView();
grid.DataSource = bookers;
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Bookers.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
public void ExportPdf(System.Web.UI.WebControls.GridView exportGV, System.Web.HttpResponse Response, System.Web.UI.HtmlControls.HtmlForm htmlForm)
{
string strFileName = "PDFReport-" + System.DateTime.Now.Date.ToString("dd") + System.DateTime.Now.AddMonths(0).ToString("MM") + System.DateTime.Now.AddYears(0).ToString("yyyy");
Response.ContentType = "application/pdf";
Response.AddHeader("content-disposition", "attachment;filename=" + strFileName + ".pdf");
Response.Cache.SetCacheability(HttpCacheability.NoCache);
StringWriter sw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(sw);
HtmlForm frm = new HtmlForm();
exportGV.Parent.Controls.Add(frm);
frm.Attributes["runat"] = "server";
frm.Controls.Add(exportGV);
frm.RenderControl(hw);
StringReader sr = new StringReader(Regex.Replace(sw.ToString(), "<script.*?</script>", "", RegexOptions.Singleline | RegexOptions.IgnoreCase));
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
HTMLWorker htmlparser = new HTMLWorker(pdfDoc);
PdfWriter.GetInstance(pdfDoc, Response.OutputStream);
pdfDoc.Open();
htmlparser.Parse(sr);
pdfDoc.Close();
Response.Write(pdfDoc);
Response.End();
}
public ActionResult ExportToExcel()
{
GridSettings grid = new GridSettings();
grid.SortColumn = "Id";
grid.SortOrder = "asc";
if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false")
{ grid.IsSearch = false; }
else
{
grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]);
}
string fil = Request.QueryString["myFilters"];
grid.Where = MvcJqGrid.Filter.Create(fil, "", "", "");
var query = db.Labour as IQueryable<Labour>;
//工艺所可以查看所有工厂的数据
if (User.IsInRole("Factory"))
{
query = query.Where(u => u.FactoryCode.Equals(User.Identity.Name));
}
List<Labour> data;
if (grid.IsSearch == false)//如果是自定义查询
{
string matnumber = Request.QueryString["matnumber"];
string workcentercode = Request.QueryString["workcentercode"];
if (!string.IsNullOrEmpty(matnumber)) { query = query.Where(w => w.MatNumber.Contains(matnumber)); }
if (!string.IsNullOrEmpty(workcentercode)) { query = query.Where(w => w.WorkCenterCode.Contains(workcentercode)); }
}
GridSearchHelper.ForExcel<Labour>(grid, query, out data);
var returnData = data;
var myGrid = new System.Web.UI.WebControls.GridView();
myGrid.DataSource = from p in returnData
select new
{
Id = p.Id,
图号 = p.MatNumber,
工作中心 = p.WorkCenterCode,
工作中心描述 = p.WorkCenter.WorkCenterName,//viewmodel传来
工时 = (decimal)p.LabourHour,
版本 = (int)p.Version,
备注 = p.Remark,
工厂 = p.FactoryCode
};
myGrid.DataBind();
ImportExportData.ExportToExcel(myGrid, "工时");
return View();
}
public ActionResult ExportToExcel()
{
GridSettings grid = new GridSettings();
grid.SortColumn = "Id";
grid.SortOrder = "asc";
if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false")
{ grid.IsSearch = false; }
else
{
grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]);
}
string fil = Request.QueryString["myFilters"];
grid.Where = MvcJqGrid.Filter.Create(fil, "", "", "");
var query = db.RawStockQty as IQueryable<RawStockQty>;
//工艺所可以查看所有工厂的数据
if (User.IsInRole("Factory"))
{
query = query.Where(u => u.FactoryCode.Equals(User.Identity.Name));
}
List<RawStockQty> data;
if (grid.IsSearch == false)//如果是自定义查询
{
string matnumber = Request.QueryString["matnumber"];
string matnr = Request.QueryString["matnr"];
if (!string.IsNullOrEmpty(matnumber)) { query = query.Where(w => w.MatNumber.Contains(matnumber)); }
if (!string.IsNullOrEmpty(matnr)) { query = query.Where(w => w.MatNR.Contains(matnr)); }
}
GridSearchHelper.ForExcel<RawStockQty>(grid, query, out data);
var returnData = data;
var myGrid = new System.Web.UI.WebControls.GridView();
myGrid.DataSource = from p in returnData
select new
{
Id = p.Id,
图号 = p.MatNumber,
材料代码 = p.MatNR,
材料描述 = p.RawStock.MatDB,
数量 = p.Qty,
单位 = p.Unit,
版本 = p.Version,
工厂 = p.FactoryCode
};
myGrid.DataBind();
ImportExportData.ExportToExcel(myGrid, "材料消耗");
return View();
}
public ActionResult ExportToExcel()
{
GridSettings grid = new GridSettings();
grid.SortColumn = "Id";
grid.SortOrder = "asc";
if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false")
{ grid.IsSearch = false; }
else
{
grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]);
}
string fil = Request.QueryString["myFilters"];
grid.Where = MvcJqGrid.Filter.Create(fil, "", "", "");
var query = db.WorkCenter as IQueryable<WorkCenter>;
List<WorkCenter> data;
if (grid.IsSearch == false)//如果是自定义查询
{
string workCenterCode = Request.QueryString["workCenterCode1"];
string workCenterName = Request.QueryString["workCenterName1"];
string costCenter = Request.QueryString["costCenter"];
if (!string.IsNullOrEmpty(workCenterCode)) { query = query.Where(w => w.WorkCenterCode.Contains(workCenterCode)); }
if (!string.IsNullOrEmpty(workCenterName)) { query = query.Where(w => w.WorkCenterName.Contains(workCenterName)); }
if (!string.IsNullOrEmpty(costCenter)) { query = query.Where(w => w.CostCenter.Contains(costCenter)); }
}
GridSearchHelper.ForExcel<WorkCenter>(grid, query, out data);
var returnData = data;
var myGrid = new System.Web.UI.WebControls.GridView();
myGrid.DataSource = from p in returnData
select new
{
生产厂=p.FactoryCode,
生产厂描述=p.Factory.FactoryName,
工作中心=p.WorkCenterCode,
工作中心描述=p.WorkCenterName,
成本中心 =p.CostCenter,
工费率=p.WorkRate
};
myGrid.DataBind();
ImportExportData.ExportToExcel(myGrid, "工作中心");
return View();
}
public ActionResult ExportToExcel()
{
GridSettings grid = new GridSettings();
grid.SortColumn = "Id";
grid.SortOrder = "asc";
if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false")
{ grid.IsSearch = false; }
else
{
grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]);
}
string fil = Request.QueryString["myFilters"];
grid.Where = MvcJqGrid.Filter.Create(fil, "", "", "");
var query = db.VersionManagement as IQueryable<VersionManagement>;
List<VersionManagement> data;
if (grid.IsSearch == false)//如果是自定义查询
{
string parentNum = Request.QueryString["pn1"];
string childNum = Request.QueryString["cn1"];
//string parentNum = Request.QueryString["pn"];
//string childNum = Request.QueryString["cn"];
if (!string.IsNullOrEmpty(parentNum)) { query = query.Where(w => w.PNumber.Contains(parentNum)); }
if (!string.IsNullOrEmpty(childNum)) { query = query.Where(w => w.CNumber.Contains(childNum)); }
}
GridSearchHelper.ForExcel<VersionManagement>(grid, query, out data);
var returnData = data;
var myGrid = new System.Web.UI.WebControls.GridView();
myGrid.DataSource = from p in returnData
select new
{
Id = p.Id,
产品版本 = p.ProductVersion,
产品图号 = p.PNumber,
子项图号 = p.CNumber,
工时版本 = p.LabourVersion,
材料版本 = p.RawStockVersion
};
myGrid.DataBind();
ImportExportData.ExportToExcel(myGrid, "版本");
return View();
}
public override void ExecuteResult(ControllerContext context)
{
HttpContext curContext = HttpContext.Current;
curContext.Response.Clear();
curContext.Response.AddHeader("content-disposition", "attachment;filename=" + this.FileName);
curContext.Response.Charset = "";
curContext.Response.Cache.SetCacheability(HttpCacheability.NoCache);
curContext.Response.ContentType = "application/ms-word";
HttpWebRequest wreq = (HttpWebRequest)HttpWebRequest.Create(this.Url);
HttpWebResponse wres = (HttpWebResponse)wreq.GetResponse();
Stream s = wres.GetResponseStream();
StreamReader sr = new StreamReader(s, Encoding.ASCII);
curContext.Response.Write(sr.ReadToEnd());
curContext.Response.End();
//Bind the Data to Asp.Net DataGrid - you can still use this in Asp.Net MVC though it
//cannot be used in the .aspx View
System.Web.UI.WebControls.GridView grd = new System.Web.UI.WebControls.GridView();
grd.DataSource = this.Data;
grd.DataBind();
HttpContext.Current.Response.ClearContent();
bool exportReady = false;
switch (ExportType) {
case Models.Admin.Enums.ExportType.Word:
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=DealReport.doc");
HttpContext.Current.Response.ContentType = "application/ms-word";
exportReady = true;
break;
case Models.Admin.Enums.ExportType.Excel:
HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=DealReport.xls");
HttpContext.Current.Response.ContentType = "application/excel";
exportReady = true;
break;
}
if (exportReady) {
StringWriter swr = new StringWriter();
HtmlTextWriter tw = new HtmlTextWriter(swr);
grd.RenderControl(tw);
HttpContext.Current.Response.Write(swr.ToString());
HttpContext.Current.Response.End();
}
}
public ActionResult ExportToExcel()
{
GridSettings grid = new GridSettings();
grid.SortColumn = "Id";
grid.SortOrder = "asc";
if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false")
{ grid.IsSearch = false; }
else
{
grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]);
}
string fil = Request.QueryString["myFilters"];
grid.Where = MvcJqGrid.Filter.Create(fil, "", "", "");
var query = db.RawStock as IQueryable<RawStock>;
List<RawStock> data;
if (grid.IsSearch == false)//如果是自定义查询
{
string matnr = Request.QueryString["matnr1"];
string matdb = Request.QueryString["matdb1"];
if (!string.IsNullOrEmpty(matnr)) { query = query.Where(w => w.MatNR.Contains(matnr)); }
if (!string.IsNullOrEmpty(matdb)) { query = query.Where(w => w.MatDB.Contains(matdb)); }
}
GridSearchHelper.ForExcel<RawStock>(grid, query, out data);
var returnData = data;
var myGrid = new System.Web.UI.WebControls.GridView();
myGrid.DataSource = from p in returnData
select new
{
物料代码 = p.MatNR,
物料描述 = p.MatDB,
计量单位 = p.BUn,
单价 = p.UnitPrice
};
myGrid.DataBind();
ImportExportData.ExportToExcel(myGrid, "原材料");
return View();
}
public ActionResult ExportToExcel()
{
GridSettings grid = new GridSettings();
grid.SortColumn = "Id";
grid.SortOrder = "asc";
if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false")
{ grid.IsSearch = false; }
else
{
grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]);
}
string fil = Request.QueryString["myFilters"];
grid.Where = MvcJqGrid.Filter.Create(fil, "", "", "");
var query = db.AssignFactory as IQueryable<AssignFactory>;
List<AssignFactory> data;
if (grid.IsSearch == false)//如果是自定义查询
{
string matnumber = Request.QueryString["matnumber"];
string factorycode = Request.QueryString["factorycode"];
if (!string.IsNullOrEmpty(matnumber)) { query = query.Where(w => w.MatNumber.Contains(matnumber)); }
if (!string.IsNullOrEmpty(factorycode)) { query = query.Where(w => w.FactoryCode.Contains(factorycode)); }
}
GridSearchHelper.ForExcel<AssignFactory>(grid, query, out data);
var returnData = data;
var myGrid = new System.Web.UI.WebControls.GridView();
myGrid.DataSource = from p in returnData
select new
{
Id = p.Id,
图号 = p.MatNumber,
生产厂 = p.FactoryCode,
版本 = p.Version
};
myGrid.DataBind();
ImportExportData.ExportToExcel(myGrid, "分配工厂");
return View();
}
public void ExportarExcel()
{
var visitas = (from v in db.Local_Visitas_Agentes
select v).ToList();
//transformando
foreach (var v in visitas)
{
v.banner = (v.BannerVisible == 1) ? v.banner = "SI" : (v.BannerVisible == 0) ? v.banner = "NO" : v.banner = "N/A";
v.saliente = (v.SalienteVisible == 1) ? v.saliente = "SI" : (v.SalienteVisible == 0) ? v.saliente = "NO" : v.saliente = "N/A";
v.totem = (v.TotemVisible == 1) ? v.totem = "SI" : (v.TotemVisible == 0) ? v.totem = "NO" : v.totem = "N/A";
v.cover = (v.CoverVisible == 1) ? v.cover = "SI" : (v.CoverVisible == 0) ? v.cover = "NO" : v.cover = "N/A";
v.portaafiche = (v.PortaAficheVisible == 1) ? v.portaafiche = "SI" : (v.PortaAficheVisible == 0) ? v.portaafiche = "NO" : v.portaafiche = "N/A";
v.colgante = (v.ColganteVisible == 1) ? v.colgante = "SI" : (v.ColganteVisible == 0) ? v.colgante = "NO" : v.colgante = "N/A";
v.flyers = (v.FlyersVisibles == 1) ? v.flyers = "SI" : (v.FlyersVisibles == 0) ? v.flyers = "NO" : v.flyers = "N/A";
v.fechaCorta = v.Fecha.ToShortDateString();
}
//filtrando
var visits = from v in visitas
join a in db.Agencias on v.Numero_Agencia equals a.NUMERO_AGENCIA
join ag in db.VAgencias on v.Numero_Agencia equals ag.NUMERO_AGENCIA
select new { v.id, v.Numero_Agencia, ag.RAZON_SOCIAL, v.Local_FMR.nombre, v.fechaCorta, v.Hora, v.banner, v.saliente, v.totem, v.cover, v.portaafiche, v.colgante, v.flyers, v.comentarios };
var grid = new System.Web.UI.WebControls.GridView();
grid.DataSource = visits;
grid.DataBind();
Response.ClearContent();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment; filename=visitas.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.Flush();
Response.End();
}
//待处理-导出excel
public ActionResult ExportToExcel1()
{
GridSettings grid = new GridSettings();
grid.SortColumn = "Id";
grid.SortOrder = "asc";
if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false")
{
grid.IsSearch = false;
}
else
{
grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]);
}
string fil = Request.QueryString["myFilters"];
grid.Where = MvcJqGrid.Filter.Create(fil, "", "", "");
var query = db.UnfinishedRawStock as IQueryable<UnfinishedRawStock>;
//加入当前用户
query = query.Where(u => u.FactoryCode.Equals(User.Identity.Name));
List<UnfinishedRawStock> data;
GridSearchHelper.ForExcel<UnfinishedRawStock>(grid, query, out data);
var returnData = data;
var myGrid = new System.Web.UI.WebControls.GridView();
myGrid.DataSource = from p in returnData
select new
{
Id = p.Id,
图号 = p.MatNumber,
版本 = p.Version,
工厂 = p.FactoryCode
};
myGrid.DataBind();
ImportExportData.ExportToExcel(myGrid, "待处理");
return View();
}
public ActionResult xls()
{
using (ESKAPEDEContext db = new ESKAPEDEContext())
{
IQueryable<vwRequest> results = db.vwRequests;
System.Web.UI.WebControls.GridView grd = new System.Web.UI.WebControls.GridView();
grd.DataSource = db.vwRequests.ToList();
grd.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=ReportSKPD.xls");
Response.ContentType = "application/ms-excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
// Render the grid contents => the writer objects => Response object
grd.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
return View("Index");
}
}
/// <summary>
/// Submit the Request to Fetch Data For Excel.
/// </summary>
public ActionResult ExportToExcel()
{
dynamic objAcccount;
using (var db = new CSN.DAL.CSNDBEntities())
{
objAcccount = (from x in db.TblAccountLists.OrderBy(e => e.Company)
join y in db.TblCSNLists on x.CSNDirID equals y.CSNID
select new
{
Company = x.Company,
Address = x.Address1 + " " + x.Address2 + " " + x.City,
CompanyPhone = x.CompanyPhone,
CompanyFax = x.CompanyFax,
State = x.State,
Zip = x.Zip,
Country = x.Country,
ShippingAddress = x.ShipToAddress1 + " " + x.ShipToAddress2 + " " + x.ShipToCity,
CSNRef = y.FullName,
AccountType = x.CustType1,
NumberOfStore = x.NumStores
}).ToList();
}
var grid = new System.Web.UI.WebControls.GridView();
grid.AutoGenerateColumns = true;
grid.AllowPaging = false;
grid.DataSource = objAcccount;
grid.DataBind();
grid.HeaderStyle.BackColor = System.Drawing.Color.FromName("#fff8cf");
grid.HeaderStyle.Font.Bold = true;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
grid.RenderControl(oHtmlTextWriter);
ShowXLS(oStringWriter.ToString(), "AccountList");
return null;
}
public void ExportSubjectListToExcel(int id)
{
StudentIndexVM model = new StudentIndexVM();
GradeRepository gradeRepo = new GradeRepository();
UserRepository<Student> studentRepo = new UserRepository<Student>();
Student student = studentRepo.GetByID(id);
model.Grades = gradeRepo.GetAll(filter: s => s.StudentID == id);
var grid = new System.Web.UI.WebControls.GridView();
var products = new System.Data.DataTable(student.FirstName);
products.Columns.Add("Subject", typeof(string));
products.Columns.Add("Grade", typeof(string));
foreach (var item in model.Grades)
{
products.Rows.Add(item.Subject.Name, item.GradeValue);
}
grid.DataSource = products;
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=" + student.FacultiNumber + ".xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
/// <summary>
/// 将Datatable转换为Excel
/// </summary>
/// <param name="dtData"></param>
/// <param name="FileName"></param>
public static void DataTableToExcel(System.Data.DataTable dtData, String FileName)
{
if (dtData == null || dtData.Rows.Count == 0)
{
return;
}
System.Web.UI.WebControls.GridView dgExport = null;
//当前对话
System.Web.HttpContext curContext = System.Web.HttpContext.Current;
//IO用于导出并返回excel文件
System.IO.StringWriter strWriter = null;
System.Web.UI.HtmlTextWriter htmlWriter = null;
if (dtData != null)
{
//设置编码和附件格式
//System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8)作用是方式中文文件名乱码
curContext.Response.AddHeader("content-disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8) + ".xls");
curContext.Response.ContentType = "application nd.ms-excel";
curContext.Response.ContentEncoding = System.Text.Encoding.UTF8;//.GetEncoding("GB2312");
curContext.Response.Charset = "UTF-8";// "GB2312";
//导出Excel文件
strWriter = new System.IO.StringWriter();
htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);
//为了解决dgData中可能进行了分页的情况,需要重新定义一个无分页的GridView
dgExport = new System.Web.UI.WebControls.GridView();
dgExport.DataSource = dtData.DefaultView;
dgExport.AllowPaging = false;
dgExport.DataBind();
//下载到客户端
dgExport.RenderControl(htmlWriter);
curContext.Response.Write(strWriter.ToString());
curContext.Response.End();
}
}
public ActionResult Export()
{
var grid = new System.Web.UI.WebControls.GridView
{
DataSource = this.volunteerRepository.All.ToList()
};
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=KiyvSmartCity_Volunteers.xls");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
return null;
}
public ActionResult LabourDetailExportToExcel()
{
GridSettings grid = new GridSettings();
grid.SortColumn = "Id";
grid.SortOrder = "asc";
if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false")
{ grid.IsSearch = false; }
else
{
grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]);
}
string fil = Request.QueryString["myFilters"];
grid.Where = MvcJqGrid.Filter.Create(fil, "", "", "");
var query = db.DetailLabour as IQueryable<DetailLabour>;
List<DetailLabour> data;
//从上一页面获得值
string productVersion = HttpUtility.ParseQueryString(Request.UrlReferrer.Query)["ProductVersion"];
string pNumber = HttpUtility.ParseQueryString(Request.UrlReferrer.Query)["PNumber"];
if (!string.IsNullOrEmpty(productVersion)) { query = query.Where(w => w.ProductVersion.Equals(productVersion)); }
if (!string.IsNullOrEmpty(pNumber)) { query = query.Where(w => w.PNumber.Equals(pNumber)); }
if (grid.IsSearch == false)//如果是自定义查询
{
//获得本页的查询条件
string workCenterCode = Request.QueryString["pn"];
string childNum = Request.QueryString["cn"];
if (!string.IsNullOrEmpty(workCenterCode)) { query = query.Where(w => w.WorkCenterCode.Contains(workCenterCode)); }
if (!string.IsNullOrEmpty(childNum)) { query = query.Where(w => w.CNumber.Contains(childNum)); }
}
GridSearchHelper.ForExcel<DetailLabour>(grid, query, out data);
var returnData = data;
var myGrid = new System.Web.UI.WebControls.GridView();
myGrid.DataSource = from p in returnData
select new
{
Id = p.Id,
产品版本 = p.ProductVersion,
产品图号 = p.PNumber,
零件图号 = p.CNumber,
工作中心 = p.WorkCenterCode,
工作中心描述 = p.WorkCenterName,
工时版本 = p.LabourVersion,
工时 = p.LabourHour,
配套数 = p.CQty,
总工时 = p.LabourTotal,
工时成本 = p.LabourCost,
备注 = p.Remark
};
myGrid.DataBind();
ImportExportData.ExportToExcel(myGrid, "工时明细");
return View();
}
// POST: GetCasesInExcel
public CsvActionResult<FluCaseExportViewModel> GetExcelCases(int CountryID, int? HospitalID, int? Year, int? Month, int? SE, DateTime? StartDate, DateTime? EndDate)
{
var grid = new System.Web.UI.WebControls.GridView();
IQueryable<FluCase> query = GetQuery( CountryID, HospitalID, Year, Month, SE, StartDate, EndDate);
List<FluCaseExportViewModel> result = query.Select( f => new FluCaseExportViewModel(){
ID = f.ID ,
HospitalID = f.Hospital.FullName,
HospitalDate = f.HospitalDate ,
RegDate = f.RegDate ,
FName1 = f.FName1 ,
FName2 = f.FName2 ,
LName1 = f.LName1 ,
LName2 = f.LName2 ,
NoExpediente = f.NoExpediente ,
NationalId = f.NationalId ,
DOB = f.DOB ,
Age = f.Age ,
AMeasure = f.AMeasure.ToString() ,
AgeGroup = f.AgeGroup.ToString() ,
Gender = f.Gender.ToString() ,
Country = f.Country.Code ,
Area = f.Area.Name ,
State = f.State.Name ,
Local = f.Local.Code.ToString() ,
Neighborhood = f.Neighborhood.Code.ToString() ,
UrbanRural = f.UrbanRural.ToString() ,
Address = f.Address ,
Vaccin = f.Vaccin.ToString() ,
RiskFactors = f.RiskFactors.ToString() ,
HDisease = f.HDisease ,
Diabetes = f.Diabetes ,
Neuro = f.Neuro ,
Asthma = f.Asthma ,
Pulmonary = f.Pulmonary ,
Liver = f.Liver ,
Renal = f.Renal ,
Immunsupp = f.Immunsupp ,
Pregnant = f.Pregnant.ToString() ,
Pperium = f.Pperium ,
Trimester = f.Trimester.ToString() ,
Smoking = f.Smoking ,
Alcohol = f.Alcohol ,
DownSyn = f.DownSyn ,
Obesity = f.Obesity.ToString() ,
OtherRisk = f.OtherRisk ,
CHNum = f.CHNum ,
FeverDate = f.FeverDate ,
FeverEW = f.FeverEW ,
Antiviral = f.Antiviral ,
AStartDate = f.AStartDate ,
HospAmDate = f.HospAmDate ,
HospEW = f.HospEW ,
HospExDate = f.HospExDate ,
ICUAmDate = f.ICUAmDate ,
ICUEW = f.ICUEW ,
ICUExDate = f.ICUExDate ,
Destin = f.Destin ,
IsSample = f.IsSample ,
SampleDate = f.SampleDate ,
SampleType = f.SampleType ,
ShipDate = f.ShipDate ,
Lab = f.Lab.Name ,
Processed = f.Processed ,
NoProRen = f.NoProRen ,
EndLabDate = f.EndLabDate ,
FResult = f.FResult ,
Comments = f.Comments
}).ToList();
//We return the XML from the memory as a .xls file
//grid.DataSource = result;
//grid.DataBind();
//StringWriter sw = new StringWriter();
//HtmlTextWriter htw = new HtmlTextWriter(sw);
//grid.RenderControl(htw);
//return File(Encoding.GetBytes(sw.ToString), "application/ms-excel", "Marklist.xls");
return new CsvActionResult<FluCaseExportViewModel> (result, "FluCases.csv");
}
public ActionResult RawStockDetailExportToExcel()
{
GridSettings grid = new GridSettings();
grid.SortColumn = "Id";
grid.SortOrder = "asc";
if (Request.QueryString["mySearch"] == "" || Request.QueryString["mySearch"] == "false")
{ grid.IsSearch = false; }
else
{
grid.IsSearch = Convert.ToBoolean(Request.QueryString["mySearch"]);
}
string fil = Request.QueryString["myFilters"];
grid.Where = MvcJqGrid.Filter.Create(fil, "", "", "");
var query = db.DetailRawStock as IQueryable<DetailRawStock>;
List<DetailRawStock> data;
//从上一页面获得值
string productVersion = HttpUtility.ParseQueryString(Request.UrlReferrer.Query)["ProductVersion"];
string pNumber = HttpUtility.ParseQueryString(Request.UrlReferrer.Query)["PNumber"];
if (!string.IsNullOrEmpty(productVersion)) { query = query.Where(w => w.ProductVersion.Equals(productVersion)); }
if (!string.IsNullOrEmpty(pNumber)) { query = query.Where(w => w.PNumber.Equals(pNumber)); }
if (grid.IsSearch == false)//如果是自定义查询
{
//获得本页的查询条件
string MatNR = Request.QueryString["pn"];
string childNum = Request.QueryString["cn"];
if (!string.IsNullOrEmpty(MatNR)) { query = query.Where(w => w.MatNR.Contains(MatNR)); }
if (!string.IsNullOrEmpty(childNum)) { query = query.Where(w => w.CNumber.Contains(childNum)); }
}
GridSearchHelper.ForExcel<DetailRawStock>(grid, query, out data);
var returnData = data;
var myGrid = new System.Web.UI.WebControls.GridView();
myGrid.DataSource = from p in returnData
select new
{
Id = p.Id,
产品版本 = p.ProductVersion,
产品图号 = p.PNumber,
零件图号 = p.CNumber,
材料代码 = p.MatNR,
材料描述 = p.MatDB,
材料版本 = p.RawStockVersion,
数量=p.Qty,
配套数 = p.CQty,
总用量 = p.RawStockTotal,
材料成本 = p.RawStockCost,
单位 = p.Unit
};
myGrid.DataBind();
ImportExportData.ExportToExcel(myGrid, "材料明细");
return View();
}
public void ExportSubjectListToExcel(int id)
{
GradeStudentsGradesVM model = new GradeStudentsGradesVM();
GradeRepository gradeRepo = new GradeRepository();
SubjectRepository subjRepo = new SubjectRepository();
UserRepository<Student> studentRepo = new UserRepository<Student>();
List<Student> students = studentRepo.GetAll(filter: s => s.Course.CourseSubject.Any(t => t.SubjectID == id));
List<Grade> grades = gradeRepo.GetAll(filter: s => s.SubjectID == id);
Subject subject = subjRepo.GetByID(id);
var grid = new System.Web.UI.WebControls.GridView();
var products = new System.Data.DataTable(subject.Name);
products.Columns.Add("FacultiNumber", typeof(string));
products.Columns.Add("FirstName", typeof(string));
products.Columns.Add("LastName", typeof(string));
products.Columns.Add("Grade", typeof(string));
foreach (var student in students)
{
string grade = student.Grades.Select(x => x.GradeValue).FirstOrDefault().ToString();
grade = grade == "0" ? "" : grade;
products.Rows.Add(student.FacultiNumber, student.FirstName, student.LastName, grade);
}
grid.DataSource = products;
// grid.DataSource = model.Students;
grid.DataBind();
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=" + subject.Name + ".xlsx");
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
grid.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}
public ActionResult ExportToExcel()
{
string _retVal = string.Empty;
string _fileName = string.Empty;
var _model = _repository.GetAllEmployeeDataNoPhoto();
var _grid = new System.Web.UI.WebControls.GridView();
_fileName = "Employees_Exported_Data_" + DateTime.Now.ToString("MM_dd_yyyy_HH_mm") + ".xls";
_grid.DataSource = _model;
_grid.DataBind();
return new DownloadExcelFileActionResult(_grid, _fileName);
}
