kyle'sBlog: 6月 2017

2017年6月25日星期日

報表繫結與下載

	#region 報表繫結(下載)
	/// <summary>
	/// 報表繫結
	/// </summary>
	/// <param name="rpt">報表檢視器</param>
	/// <param name="dsName">資料集名稱</param>
	/// <param name="RptPath">報表路徑</param>
	/// <param name="dt">繫結之資料表</param>
	/// <param name="PType">PDF,Excel,Word,Image</param>
	public static void ReportExport(ReportViewer rpt, string dsName, string RptPath, DataTable dt, string PType)
	{
	ReportBind(rpt, dsName, RptPath, dt);
	Microsoft.Reporting.WebForms.Warning[] tWarnings;
	string[] tStreamids;
	string tMimeType;
	string tEncoding;
	string tExtension;
	//呼叫ReportViewer.LoadReport的Render function，將資料轉成想要轉換的格式，並產生成Byte資料
	byte[] tBytes = rpt.LocalReport.Render(PType, null, out tMimeType, out tEncoding, out tExtension, out tStreamids, out tWarnings);
	//將Byte內容寫到Client
	string DisplayName = rpt.LocalReport.DisplayName == "" ? "report" : rpt.LocalReport.DisplayName;
	if (HttpContext.Current.Request.Browser.Browser == "IE")
	{
	DisplayName = HttpContext.Current.Server.UrlPathEncode(DisplayName);
	}
	HttpContext.Current.Response.Clear();
	HttpContext.Current.Response.ContentType = tMimeType;
	HttpContext.Current.Response.AppendHeader("Content-Disposition", String.Format("attachment; filename={0}.{1}", DisplayName, tExtension));
	HttpContext.Current.Response.BinaryWrite(tBytes);
	HttpContext.Current.Response.End();
	}
	#endregion

	#region 報表繫結
	/// <summary>
	/// 報表繫結
	/// </summary>
	/// <param name="rpt">報表檢視器</param>
	/// <param name="dsName">資料集名稱</param>
	/// <param name="RptPath">報表路徑</param>
	/// <param name="dt">繫結之資料表</param>
	public static void ReportBind(ReportViewer rpt, string dsName, string RptPath, DataTable dt)
	{
	string Path = ConfigurationManager.AppSettings["RptPath"].ToStr();
	Path = (Path == "") ? "~/bin/Report" : Path;//預設值
	rpt.LocalReport.DataSources.Clear();
	rpt.ProcessingMode = ProcessingMode.Local;
	rpt.LocalReport.ReportPath = HttpContext.Current.Server.MapPath(string.Format("{0}\\{1}", Path, RptPath));
	rpt.LocalReport.DataSources.Add(new ReportDataSource(dsName, dt));
	rpt.LocalReport.Refresh();
	}
	#endregion

view raw reportbinding hosted with ❤ by GitHub

2017年6月7日星期三

[筆記]JSLINQ

讓javascript使用類似linq語法篩選json(array)物件。
有jQuery與Javascript版本。
參考網站：

CDN:

本範例使用:2.2.0.2版本。
新版3.X.X版本以上不適用。

Ex：

2017年6月6日星期二

[筆記]關閉Controller SessionState

參考：

http://blog.darkthread.net/post-2017-06-07-mvc-slow-magic.aspx

[SessionState(System.Web.SessionState.SessionStateBehavior.Disabled)]

public class HomeController : Controller

2017年6月1日星期四

[測試]Gist

	<!DOCTYPE html>
	<html>
	<head>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width">
	<title>20170601demo</title>
	<script src="https://code.jquery.com/jquery-1.10.2.js"></script>
	<script>
	$(function(){
	$('input').click(function(){
	alert('123');
	});
	});
	</script>
	</head>
	<body>
	<input type='button' value='show' />

	</body>
	</html>