/// <summary>
/// 新增稽核軌跡
/// </summary>
/// <param name="codeUserDao"></param>
/// <param name="codeUser"></param>
/// <param name="conn"></param>
/// <param name="transaction"></param>
public void procTrackLog(string type, CodeUserDao codeUserDao, CODE_USER codeUser, SqlConnection conn, SqlTransaction transaction)
{
PIA_LOG_MAIN piaLog = new PIA_LOG_MAIN();
piaLog.TRACKING_TYPE = "A";
piaLog.ACCESS_ACCOUNT = Session["UserID"].ToString();
piaLog.ACCOUNT_NAME = Session["UserName"].ToString();
piaLog.PROGFUN_NAME = "UserReview";
piaLog.ACCESSOBJ_NAME = "CodeUser";
piaLog.EXECUTION_TYPE = type;
piaLog.EXECUTION_CONTENT = codeUserDao.userLogContent(codeUser);
piaLog.AFFECT_ROWS = 1;
piaLog.PIA_OWNER1 = codeUser.USER_ID;
piaLog.PIA_OWNER2 = "";
piaLog.PIA_TYPE = "0100000000";
PiaLogMainDao piaLogMainDao = new PiaLogMainDao();
piaLogMainDao.Insert(piaLog, conn, transaction);
}
/// <summary>
/// 主頁面查詢紀錄至稽核軌跡
/// </summary>
/// <param name="userMgrModel"></param>
/// <param name="codeUserDao"></param>
/// <param name="cnt"></param>
public void procTrackLog(UserMgrModel userMgrModel, CodeUserDao codeUserDao, int cnt)
{
string strConn = DbUtil.GetDBTreasuryConnStr();
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
SqlTransaction transaction = conn.BeginTransaction("Transaction");
try
{
PIA_LOG_MAIN piaLog = new PIA_LOG_MAIN();
piaLog.TRACKING_TYPE = "A";
piaLog.ACCESS_ACCOUNT = Session["UserID"].ToString();
//piaLog.ACCOUNT_NAME = Session["UserName"].ToString();
piaLog.PROGFUN_NAME = "UserMgrController";
piaLog.ACCESSOBJ_NAME = "CodeUser";
piaLog.EXECUTION_TYPE = "Q";
piaLog.EXECUTION_CONTENT = codeUserDao.trackLogContent(userMgrModel);
piaLog.AFFECT_ROWS = cnt;
piaLog.PIA_OWNER1 = "";
piaLog.PIA_OWNER2 = "";
piaLog.PIA_TYPE = "0100000000";
PiaLogMainDao piaLogMainDao = new PiaLogMainDao();
piaLogMainDao.Insert(piaLog, conn, transaction);
transaction.Commit();
}
catch (Exception e)
{
transaction.Rollback();
logger.Error("[procTrackLog]其它錯誤：" + e.ToString());
}
}
}
private void writeLog(String type, bool bSuccess, String userId, CODE_USER codeUser)
{
CommonUtil commonUtil = new CommonUtil();
//logModel
Log log = new Log();
log.CFUNCTION = "I".Equals(type) ? "登入作業" : "登出作業";
log.CACTION = "L";
log.CCONTENT = "UserId：" + userId + "| UserName：" + commonUtil.GetIPAddress() + "|" + ("I".Equals(type) ? "登入成功" : "登出成功");
//PiaLogMainModel
PIA_LOG_MAIN piaLogMain = new PIA_LOG_MAIN();
piaLogMain.TRACKING_TYPE = "B";
piaLogMain.ACCESS_ACCOUNT = userId;
piaLogMain.ACCOUNT_NAME = "";
piaLogMain.PROGFUN_NAME = "AccountController";
piaLogMain.EXECUTION_CONTENT = userId;
piaLogMain.AFFECT_ROWS = 0;
piaLogMain.PIA_TYPE = "0000000000";
if (bSuccess)
{
CodeUserDao codeUserDao = new CodeUserDao();
//更新login/logout日期時間
if ("I".Equals(type))
{
codeUserDao.updateLogInOut(userId, "I");
}
//codeUser.cLoginDateTime = DateTime.Now;
else
{
codeUserDao.updateLogInOut(userId, "O");
}
//codeUser.cLogoutDateTime = DateTime.Now;
//寫入系統LOG
LogDao.Insert(log, userId);
//寫入稽核軌跡
//piaLogMain.ACCOUNT_NAME = codeUser.CUSERNAME;
piaLogMain.EXECUTION_TYPE = "I".Equals(type) ? "LS" : "LO";
piaLogMain.ACCESSOBJ_NAME = "CodeUser";
PiaLogMainDao piaLogMainDao = new PiaLogMainDao();
piaLogMainDao.Insert(piaLogMain);
}
else
{
//寫入系統LOG
log.CCONTENT = "UserId：" + userId + "| UserName：" + commonUtil.GetIPAddress() + "|" + "登入失敗";
LogDao.Insert(log, userId);
//寫入稽核軌跡
piaLogMain.EXECUTION_TYPE = "LF";
piaLogMain.ACCESSOBJ_NAME = "AD";
PiaLogMainDao piaLogMainDao = new PiaLogMainDao();
piaLogMainDao.Insert(piaLogMain);
}
}