/// <summary>
/// 寫入 Txt Log
/// </summary>
/// <param name="tableName">table名</param>
/// <param name="falg">成功或失敗</param>
/// <param name="start">開始時間</param>
/// <param name="folderPath">檔案路徑</param>
public static void txtLog(Table_Type tableName, bool falg, DateTime start, string folderPath)
{
try
{
string txtData = string.Empty;
try //試著抓取舊資料
{
txtData = File.ReadAllText(folderPath, System.Text.Encoding.Default);
}
catch { }
string txt = string.Format("{0}({1})_{2}_{3}",
tableName.GetDescription(),
tableName.ToString(),
start.ToString("yyyyMMddHHmmss"),
falg ? "Y" : "N");
if (!string.IsNullOrWhiteSpace(txtData)) //有舊資料就換行寫入下一筆
{
txtData += string.Format("\r\n{0}", txt);
}
else //沒有就直接寫入
{
txtData = txt;
}
FileStream fs = new FileStream(folderPath, FileMode.Create, FileAccess.Write);
StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.Default);
sw.Write(txtData); //存檔
sw.Close();
}
catch (Exception ex)
{
}
}
/// <summary>
/// Log資料存到Sql(IFRS9_Log)
/// </summary>
/// <param name="tableType">table簡寫</param>
/// <param name="tableName">table名</param>
/// <param name="fileName">檔案名</param>
/// <param name="programName">專案名</param>
/// <param name="falg">成功失敗</param>
/// <param name="deptType">B:債券 M:房貸 (共用同一table時做區分)</param>
/// <param name="start">開始時間</param>
/// <param name="end">結束時間</param>
/// <returns>回傳成功或失敗</returns>
public bool saveLog(
Table_Type table,
string fileName,
string programName,
bool falg,
string deptType,
DateTime start,
DateTime end)
{
bool flag = true;
try
{
var tableName = table.GetDescription();
db.IFRS9_Log.Add(new IFRS9_Log() //寫入DB
{
Table_type = table.ToString(),
Table_name = tableName.Substring(0, (tableName.Length > 40 ? 40 : tableName.Length)),
File_name = fileName,
Program_name = programName,
Create_date = start.ToString("yyyyMMdd"),
Create_time = start.ToString("HH:mm:ss"),
End_date = end.ToString("yyyyMMdd"),
End_time = end.ToString("HH:mm:ss"),
TYPE = falg ? "Y" : "N",
Debt_Type = deptType
});
db.SaveChanges(); //DB SAVE
}
catch
{
flag = false;
}
return(flag);
}
/// <summary>
/// Log資料存到Sql(IFRS9_Log)
/// </summary>
/// <param name="tableType">table簡寫</param>
/// <param name="tableName">table名</param>
/// <param name="fileName">檔案名</param>
/// <param name="programName">專案名</param>
/// <param name="falg">成功失敗</param>
/// <param name="deptType">B:債券 M:房貸 (共用同一table時做區分)</param>
/// <param name="start">開始時間</param>
/// <param name="end">結束時間</param>
/// <param name="userAccount">執行帳號</param>
/// <param name="version">版本</param>
/// <param name="reportDate">基準日</param>
/// <returns>回傳成功或失敗</returns>
public bool saveLog(
Table_Type table,
string fileName,
string programName,
bool falg,
string deptType,
DateTime start,
DateTime end,
string userAccount,
int version = 1,
Nullable <DateTime> date = null)
{
bool flag = true;
try
{
using (IFRS9DBEntities db = new IFRS9DBEntities())
{
var tableName = table.GetDescription();
db.IFRS9_Log.Add(new IFRS9_Log() //寫入DB
{
Table_type = table.ToString(),
Table_name = tableName.Substring(0, (tableName.Length > 40 ? 40 : tableName.Length)),
File_name = fileName,
Program_name = programName,
Version = version,
Create_date = start.ToString("yyyyMMdd"),
Create_time = start.ToString("HH:mm:ss"),
End_date = end.ToString("yyyyMMdd"),
End_time = end.ToString("HH:mm:ss"),
TYPE = falg ? "Y" : "N",
Debt_Type = deptType,
User_Account = userAccount,
Report_Date = date
});
db.SaveChanges(); //DB SAVE
}
}
catch
{
flag = false;
}
return(flag);
}
