/// <summary>
/// 记载系统和数据库管理员系统管理日志
/// </summary>
/// <param name="szUserCode">用户代码</param>
/// <param name="IP">用户ip地址</param>
/// <param name="MAC">用户物理网卡地址</param>
public static bool AddSysLogManagement(string szUserCode, string IP, string MAC, string OBJECT, string OPERATION, string SQL)
{
string strSql = string.Format("Insert Into SysLogManagement(UserCode,IP,MAC,OPERATIONDATE,OBJECT,OPERATION,SQL) values('{0}','{1}','{2}',sysdate,'{3}','{4}','{5}')", szUserCode, IP, MAC, OBJECT, OPERATION, SQL);
DataService.DataService dCurService = new DataService.DataService();
return(dCurService.ExecOraSql(strSql));
}
/// <summary>
/// 记载用户登陆日志
/// </summary>
/// <param name="szUserCode">用户代码</param>
/// <param name="IP">用户ip地址</param>
/// <param name="MAC">用户物理网卡地址</param>
public static bool AddLogUserLogin(string szUserCode, string IP, string MAC)
{
string strSql = string.Format("Insert Into sysloguserlogin(UserCode,IP,MAC,LOGINTIME) values('{0}','{1}','{2}',sysdate)", szUserCode, IP, MAC);
DataService.DataService dCurService = new DataService.DataService();
return(dCurService.ExecOraSql(strSql));
}
/// <summary>
/// 记载模块日志启动运行时间
/// </summary>
/// <param name="szUserCode">用户代码</param>
/// <param name="IP">用户ip地址</param>
/// <param name="MAC">用户物理网卡地址</param>
public static bool AddSysLogModule(string szUserCode, string IP, string MAC, string ModuleFunName)
{
string strSql = string.Format("Insert Into SysLogModule(UserCode,IP,MAC,RUNTIME,MODULE) values('{0}','{1}','{2}',sysdate,'{3}')", szUserCode, IP, MAC, ModuleFunName);
DataService.DataService dCurService = new DataService.DataService();
return(dCurService.ExecOraSql(strSql));
}
/// <summary>
/// 记载用户使用数据日志
/// </summary>
/// <param name="szUserCode">用户代码</param>
/// <param name="IP">用户ip地址</param>
/// <param name="MAC">用户物理网卡地址</param>
/// <param name="DATATYPE">数据类型</param>
/// <param name="DATA">数据内容</param>
/// <param name="OPERATION">0:浏览; 1:修改;2:下载;</param>
/// <param name="SQL">操作语句</param>
public static bool AddLogDataLog(string szUserCode, string IP, string MAC, string DATATYPE, string DATA, string OPERATION, string SQL)
{
string strSql = string.Format("Insert Into syslogdatalog(UserCode,IP,MAC,OPERATIONDATE,DATATYPE,DATA,OPERATION,SQL) values('{0}','{1}','{2}',sysdate,'{3}','{4}','{5}','{6}')", szUserCode, IP, MAC, DATATYPE, DATA, OPERATION, SQL);
DataService.DataService dCurService = new DataService.DataService();
return(dCurService.ExecOraSql(strSql));
}
