public void insertErrLog(s_log_fence model)
{
using (conn = ConnectionFactory.CreateConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string sql = SqlFactory.GetInsertSql(model);
conn.Execute(sql, model);
s_task_exception task = conn.Query <s_task_exception>(" select * from s_task_exception where rwbh=@rwbh and type=@type", model).FirstOrDefault();
if (task == null)//新增
{
string sql1 = SqlFactory.GetInsertSql(model, "s_task_exception");
conn.Execute(sql1, model);
}
else
{
task.des = model.des;
task.dz_xx = model.dz_xx;
task.fw = model.fw;
task.cjsj = model.cjsj;
task.state = model.state;
task.wd = model.wd;
task.jd = model.jd;
task.wlxh = model.wlxh;
task.status = 0;
string sql1 = SqlFactory.GetUpdateSql(task, "s_task_exception", "id");
conn.Execute(sql1, task);
}
}
}
public void errorLog(HttpContext context)
{
try
{
authorityCheck(context);
string taskNo = context.Request.Params["taskNo"];
string des = context.Request.Params["desc"];
string type = context.Request.Params["type"];
string json = context.Request.Params["json"];
//writeLog("接收到异常请求，参数taskNo=" + taskNo + "\t desc=" + des + "\t type=" + type + "\t json=" + json);
writeLog(string.Format("任务编号为{0}的数据监听异常，说明：{1},json:{2}", taskNo, des, json), "errorlog");
s_log_fence log = new s_log_fence();
log.id = Guid.NewGuid().ToString();
log.cjsj = DateTime.Now;
log.des = des;
log.rwbh = taskNo;
log.type = type;
if (type == "0" && !string.IsNullOrEmpty(json))
{
TaskRequest param = JsonConvert.DeserializeObject <TaskRequest>(json);
log.jd = param.lng;
log.wd = param.lat;
log.fw = param.radius;
log.cph = param.vno;
log.dz_xx = param.address;
log.wlxh = param.no;
log.state = param.listenStatus;
if (log.wlxh == 1)// 只有第一个节点的异常才会结束任务
{
yw_hddz_wlgzEntity wlgz = new Interfaces.Service.FenceService().getWlgzByDzwlbh(taskNo);
if (wlgz.rwkssj.GetValueOrDefault().AddDays(1) < DateTime.Now)// 如果是第一个节点 且任务已开始1天 则关闭任务
{
string strerr = "";
this.stopTask(taskNo, out strerr);
}
}
}
new Interfaces.Service.FenceService().insertErrLog(log);
res.result = true;
}
catch (Exception ex)
{
res.result = false;
res.msg = ex.Message;
writeLog("errorLog出现异常：" + ex.Message);
}
}
