全九州版 / 北部九州版 / 南部九州版
https://www.jrkyushu.co.jp/chinese/railpass/railpass.html
https://www.klook.com/zh-TW/activity/2371-jr-kyushu-jr-pass/
https://viviantravel.tw/jr-kyushu-rail-pass/
https://kyushu.letsgojp.com/archives/26584
全九州版 7日25000,5日22500,3日20000
北部九州版 5日15000,3日12000
南部九州版 3日10000
景點：
太宰府天滿宮
熊本城
由布院
豪斯登堡
門司港
阿蘇火山
別府地獄溫泉
佐世保九十九島
高千穗峽
稻佐山夜景
軍艦島
(名古屋)高山北陸地區周遊券JR Pass
https://www.klook.com/zh-TW/activity/2969-5-day-jr-takayama-hokuriku-area-tourist-pass-jr-pass
https://viviantravel.tw/takayama-hokuriku-area-tourist-pass/
景點
白川鄉合掌村
高山飛驒
兼六園
東茶屋街
下呂溫泉
加賀溫泉
吉卜力公園(名古屋)
.Net Framework 4.0, VS2010, C# 4.0 (2010/4)
.Net Framework 4.5, VS2012, C# 5.0 (2012/08)
.Net Framework 4.5.1, VS2013, C#5.0 (2012/08)
.Net Framework 4.6, VS2015, C# 6.0 (2015/07)
.Net Framework 4.7, VS2017, C# 7.0 (2012/08)
.Net Framework 4.7.2, VS2019, C# 8.0 (2019/09)
.Net Framework 4.8, Net Framework不再更新, 除了安全性更新, C# 8.0
.Net Framework 4.8.1 安全新更新, C# 8.0
.Net Core 3.1 (LTS), VS2019, C# 8.0
.NET 5, VS2019, C# 9.0 (2020/09)
.NET 6 (LTS), VS2022, C# 10.0 (2021/11), C# 11.0 (2022/08)
.NET 7, VS2022
.NET 8, 2023/11預計
.NET 每年11月更新
奇數年份發表LTS版本(3 年支援)(.NET 6/8)
偶數年份發表STS版本(1.5 年支援)(.NET 5/7)
Download .NET SDKs for Visual Studio
Wiki：
最後一筆
SELECT * FROM
(SELECT *,
ROW_NUMBER() OVER (PARTITION BY OrderID ORDER BY CDate DESC) Sort
FROM OrderDetail) R
WHERE R.Sort = 1
1 nuget 安裝 LinqToExcel
2 安裝AccessDatabaseEngine.exe (32位元版本)
3 IIS>應用程式集區>啓用32位元應用程式=True
若無設定32位元, 會出現錯誤: 'Microsoft.ACE.OLEDB.12.0' 提供者並未登錄於本機電腦上的問題
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using System;
using System.Collections.Generic;
using System.Data;
using System.Web;
using TTCom.Common;
namespace Rpt
{
public partial class RptSalePrint : PrintBase
{
const string strRptCode = "RptSale";
DateTime qBaseDate;// => Request.QueryString["basedate"].ToDateTime();
protected void Page_Init(object sender, EventArgs e)
{
qBaseDate = new DateTime(2020, 12, 11);
UF_Preinit(strRptCode);
//UF_GetQueryString();
//lblMsg.Text = ReportPath;
try
{
DS_Report = new DataSet();
DS_Report.ReadXmlSchema(xsdPath);
if (!IsPostBack)
{
Cache.Clear(DSTableTB);
UF_SetMainData();
UF_Rpt();
}
else
{
DS_Report = GetListI(DSTableTB);
}
//預覽報表
rd.Load(Server.MapPath(ReportPath));
rd.SetDataSource(DS_Report);
//CRV1.DisplayGroupTree = false;
CRV1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;
CRV1.ReportSource = rd;
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
}
private void Page_Unload(object sender, System.EventArgs E)
{
rd.Dispose();
CRV1.Dispose();
}
/// <summary>
/// 將查詢資料存放至HttpContext.Current
/// </summary>
/// <param name="ItemName"></param>
/// <returns></returns>
public DataSet GetListI(string ItemName)
{
DataSet dsData = new DataSet();
HttpContext context = HttpContext.Current;
//當查詢的區塊編號的編號cache不存在
if (context.Cache[ItemName.ToString()] == null)
{
//與資料庫相連取資料的程式
UF_Rpt();
dsData = (DataSet)context.Cache[ItemName.ToString()];
}
else
{
//將目前已經查詢過的區塊號碼 Cache 轉為 DataTable
dsData = (DataSet)context.Cache[ItemName.ToString()];
}
return dsData;
}
protected void UF_GetQueryString()
{
}
private void UF_Rpt()
{
//SetCompany();
//SetPartner(qPartnerSn);
ReportProvider reportProvider = new ReportProvider();
//var m = reportProvider.GetRptSal01M(qEnumSysClosingItem, qClosingDate);
DataRow drM = DS_Report.Tables[DSTableM].NewRow();
drM["BaseDate"] = qBaseDate.ToString("yyyy/MM/dd");
DS_Report.Tables[DSTableM].Rows.Add(drM);
List<DTORptSaleTB> listTB = reportProvider.GetRptSaleTB(qBaseDate);
foreach (var item in listTB)
{
DataRow dr = DS_Report.Tables[DSTableTB].NewRow();
dr["BaseDate"] = item.BaseDate.ToString("yyyy/MM/dd");
dr["PartnerNameS"] = EnumHelper.GetEnumString<EnumPartner>(item.PartnerSn);
dr["CaseNumAll"] = item.CaseNumAll;
dr["PayAmtAll"] = item.PayAmtAll;
dr["LoanBalance"] = item.LoanBalance;
dr["CaseNumD"] = item.CaseNumD;
dr["PayAmtD"] = item.PayAmtD;
dr["CaseNumM"] = item.CaseNumM;
dr["PayAmtM"] = item.PayAmtM;
dr["RPayAmtM"] = item.RPayAmtM;
dr["RatePayAmtM"] = item.PayAmtM == 0 ? 0 : item.RPayAmtM / item.PayAmtM * 100;
dr["CaseNumMP"] = item.CaseNumMP;
dr["PayAmtMP"] = item.PayAmtMP;
dr["RPayAmtMP"] = item.RPayAmtMP;
dr["RatePayAmtMP"] = item.PayAmtMP == 0 ? 0 : item.RPayAmtMP / item.PayAmtMP * 100;
dr["CaseNumY"] = item.CaseNumY;
dr["PayAmtY"] = item.PayAmtY;
dr["RPayAmtY"] = item.RPayAmtY;
dr["RatePayAmtY"] = item.PayAmtY == 0 ? 0 : item.RPayAmtY / item.PayAmtY * 100;
dr["CaseNumYP"] = item.CaseNumYP;
dr["PayAmtYP"] = item.PayAmtYP;
dr["LoanBalance30"] = item.LoanBalance30;
dr["LoanBalance60"] = item.LoanBalance60;
dr["LoanBalanceRate30"] = item.DelayRate30 * 100;
dr["LoanBalanceRate60"] = item.DelayRate60 * 100;
DS_Report.Tables[DSTableTB].Rows.Add(dr);
}
Cache.CreateCache(DSTableTB, DS_Report, 5);
}
protected void btnPrint_Click(object sender, EventArgs e)
{
ReportDocument cry = new ReportDocument();
try
{
cry.Load(Server.MapPath(ReportPath));
cry.SetDataSource(DS_Report);
cry.PrintToPrinter(1, false, 0, 0);
}
catch (Exception ex)
{
}
}
}
}
