public bool Insert(MessageCache value)
{
bool result = false;
MessageCacheHibernate hibernate = new MessageCacheHibernate();
result = hibernate.Insert(value);
return result;
}
public bool Insert(MessageCache value)
{
bool result = false;
DatabaseHibernate hibernate = new DatabaseHibernate();
if (value != null)
{
string sql = string.Empty;
List<Parameter> parameters = new List<Parameter>();
DateTime refreshTime = DateTime.Now;
refreshTime = refreshTime.AddDays(-100);
sql = string.Format("delete from e_message_cache where [refresh_time] < #{0}#", refreshTime.ToString("yyyy-MM-dd HH:mm:ss"));
parameters.Clear();
result = hibernate.Write(Variable.Link, sql, parameters);
if (result)
{
sql = string.Format("insert into e_message_cache ({0}) values (:guid, :insert_user_id, :insert_time, :update_user_id, :update_time, :remark, :validity, :ip, :machine, :code, :result, :send_time, :refresh_time)", this.Asterisk(""));
parameters.Clear();
parameters.Add(new Parameter("guid", DatabaseHibernate.Parameter(DatabaseHibernate.GUID())));
parameters.Add(new Parameter("insert_user_id", DatabaseHibernate.Parameter(value.InsertUserId)));
parameters.Add(new Parameter("insert_time", DatabaseHibernate.Parameter(value.InsertTime)));
parameters.Add(new Parameter("update_user_id", DatabaseHibernate.Parameter(value.UpdateUserId)));
parameters.Add(new Parameter("update_time", DatabaseHibernate.Parameter(value.UpdateTime)));
parameters.Add(new Parameter("remark", DatabaseHibernate.Parameter(value.Remark)));
parameters.Add(new Parameter("validity", DatabaseHibernate.Parameter(value.Validity)));
parameters.Add(new Parameter("ip", DatabaseHibernate.Parameter(value.Ip)));
parameters.Add(new Parameter("machine_id", DatabaseHibernate.Parameter(value.MachineId)));
parameters.Add(new Parameter("code", DatabaseHibernate.Parameter(value.Code)));
parameters.Add(new Parameter("result", DatabaseHibernate.Parameter(value.Result)));
parameters.Add(new Parameter("send_time", DatabaseHibernate.Parameter(value.SendTime)));
parameters.Add(new Parameter("refresh_time", DatabaseHibernate.Parameter(value.RefreshTime)));
result = hibernate.Write(Variable.Link, sql, parameters);
}
}
return result;
}
public MessageCache Parse(object[] values, List<Machine> machines, List<DetectorType> detectorTypes)
{
MessageCache result = new MessageCache();
try
{
result = DatabaseHibernate.ParseModule(result, values) as MessageCache;
result.Ip = DatabaseHibernate.ParseString(values[7]);
result.MachineId = DatabaseHibernate.ParseString(values[8]);
result.Code = DatabaseHibernate.ParseByte(values[9]);
result.Result = DatabaseHibernate.ParseBoolean(values[10]);
result.SendTime = DatabaseHibernate.ParseDateTime(values[11]);
result.RefreshTime = DatabaseHibernate.ParseDateTime(values[12]);
for (int i = 0; i < machines.Count; i++)
{
if (string.Equals(result.MachineId, machines[i].Guid, StringComparison.CurrentCultureIgnoreCase))
{
result.Machine = machines[i];
break;
}
}
result.DetectorType = new DetectorType();
for (int i = 0; i < detectorTypes.Count; i++)
{
if (result.Code == detectorTypes[i].Code)
{
result.DetectorType = detectorTypes[i];
break;
}
}
}
catch (Exception exception)
{
result = null;
EnvironmentalMonitor.Support.Resource.Variable.Logger.Log(exception);
}
return result;
}
public override ProcessResult Process(string ip, InstructionTask instructionTask)
{
ProcessResult result = new ProcessResult();
result.Done = false;
result.Message = string.Empty;
if ((instructionTask != null) && (instructionTask.Instructions != null) && (instructionTask.Instructions.Count > 0))
{
for (int i = 0; i < instructionTask.Instructions.Count; i++)
{
MessageInstruction instruction = instructionTask.Instructions[i] as MessageInstruction;
if (instruction != null)
{
string userId = this.GetType().Name;
DateTime now = DateTime.Now;
MessageCache messageCache = new MessageCache();
messageCache.InsertUserId = ip;
messageCache.InsertTime = now;
messageCache.UpdateUserId = userId;
messageCache.UpdateTime = now;
messageCache.Remark = string.Empty;
messageCache.Validity = true;
messageCache.Ip = ip;
messageCache.Code = instruction.Code;
messageCache.Result = instruction.Result;
messageCache.SendTime = instruction.SendTime;
MachineBusiness machineBusiness = new MachineBusiness();
Machine machine = machineBusiness.QueryByIp(ip);
if (machine != null)
{
messageCache.MachineId = machine.Guid;
}
messageCache.RefreshTime = now;
MessageCacheBusiness messageCacheBusiness = new MessageCacheBusiness();
result.Done = messageCacheBusiness.Insert(messageCache);
}
}
}
return result;
}
