private static Logger logger = NLog.LogManager.GetCurrentClassLogger(); //使用NLog功能 /// <summary> /// 取得 Member Access Sys Log /// </summary> public static Log_MemberAccessSysModel GetLogMemberAccessSys(String strCookieID) { Log_MemberAccessSysModel accessLog = new Log_MemberAccessSysModel(); List <SqlParameter> param = new List <SqlParameter>(); DataAccess da = new DataAccess(sqlXmlFileName, true); param.Add(new SqlParameter("@strCookieID", strCookieID)); try { DataTable dt = da.RunQuery("GetLogMemberAccessSys", param.ToArray()); if (dt.Rows.Count > 0) { accessLog = (from p in dt.Select() select new Log_MemberAccessSysModel() { strMemberID = p["strMemberID"].ToString(), strCookieID = p["strCookieID"].ToString(), dtmLogin = DateTime.Parse(p["dtmLogin"].ToString()), strType = p["strType"].ToString(), strIP = p["strIP"].ToString(), ysnSuccess = Convert.ToBoolean(p["ysnSuccess"].ToString()) }).First(); } // if has data } // try catch (Exception e) { logger.Error("GetLogMemberAccessSys " + e.Message); // Error log } // catch: all exception return(accessLog); }//End GetLogMemberAccessSys
}//End GetLogMemberAccessSys /// <summary> /// 新增 Member Access Sys Log /// </summary> public static Boolean InsertLogMemberAccessSys(Log_MemberAccessSysModel accessLog) { int insert_checker = 0; List <SqlParameter> param = new List <SqlParameter>(); DataAccess da = new DataAccess(sqlXmlFileName, true); param.Add(new SqlParameter("@strMemberID", accessLog.strMemberID)); param.Add(new SqlParameter("@strType", accessLog.strType)); param.Add(new SqlParameter("@ysnSuccess", accessLog.ysnSuccess)); param.Add(new SqlParameter("@strIP", accessLog.strIP)); param.Add(new SqlParameter("@strCookieID", accessLog.strCookieID)); try { insert_checker = da.RunNonQuery("InsertLogMemberAccessSys", param.ToArray()); } catch (Exception e) { logger.Error("InsertLogMemberAccessSys " + e.Message); // Error log } // catch: all exception return(insert_checker > 0); }//End InsertLogMemberAccessSys