public static LoggerInfo GetLoggerInfo(string fileName, string info, string guid, int status)
{
LoggerInfo loggerInfo = GetLoggerInfo(fileName, info, status);
loggerInfo.GUID = guid;
return(loggerInfo);
}
public static LoggerInfo GetLoggerInfo(string fileName, string info, int status)
{
LoggerInfo loggerInfo = GetLoggerInfo(fileName);
loggerInfo.Info = string.Format("{0} {1}", loggerInfo.TableName, info);
loggerInfo.Status = status;
return(loggerInfo);
}
public static void Insert(LoggerInfo info)
{
ArrayList sqlList = new ArrayList();
string sql = string.Format("insert into T_JK_CLIENTUPLOADINFOS(ip,czy,info,createdate,guid,status) " +
"values('{0}','{1}','{2}','{3}','{4}',{5})", info.IP,
info.Czy, info.Info, info.CreateDate, info.GUID, info.Status);
sqlList.Add(sql);
DBOracle db = new DBOracle();
db.ExecuteNonQuery_oracle(sqlList);
}
public static LoggerInfo GetLoggerInfo(string fileName)
{
string[] infos = fileName.Split(new[] { "__" }, StringSplitOptions.None);
LoggerInfo loggerInfo = new LoggerInfo();
if (infos.Length >= 3)
{
loggerInfo.TableName = GetTableName(infos[0]);
loggerInfo.Czy = infos[1];
loggerInfo.IP = GetClientIP4(infos[2]);
}
return(loggerInfo);
}