public JsonEntity AddWorkLog(string ClientId, int taskId, string dispatchId, int logType, string logText, DateTime createTime)
{
if (Pub.PauseWorkLog)
{
return new JsonEntity()
{
code = 1
}
}
;
var sw = System.Diagnostics.Stopwatch.StartNew();
using (RLib.DB.DbConn dbconn = Pub.GetConn())
{
var nodemodel = nodedal.Detail(dbconn, ClientId);
Model.TaskWorkLog worklogmodel = new Model.TaskWorkLog()
{
NodeId = nodemodel.NodeId,
TaskId = taskId,
DispatchId = dispatchId ?? "",
LogType = logType,
LogText = logText,
ServerTime = createTime
};
tasklogdal.AddWorkLog(dbconn, createTime, worklogmodel);
}
sw.Stop();
System.Diagnostics.Trace.WriteLine("服务器写日志用时：" + sw.Elapsed.TotalMilliseconds.ToString("0.0"));
return(new JsonEntity()
{
code = 1
});
}
public Model.TaskWorkLog AddWorkLog(RLib.DB.DbConn dbconn, DateTime date, Model.TaskWorkLog model)
{
string sql = "insert into " + Pub.BuildWTbName(date) + "(taskid,nodeid,dispatchid,logtype,logtext,servertime) values " +
" (@taskid,@nodeid,@dispatchid,@logtype,@logtext,@servertime);select @@identity;";
model.LogId = dbconn.ExecuteScalar <int>(sql, new
{
taskid = model.TaskId,
nodeid = model.NodeId,
dispatchid = model.DispatchId ?? "",
logtype = model.LogType,
logtext = model.LogText ?? "",
servertime = model.ServerTime
});
// dbconn.GetIdentity();
return(model);
}
public JsonEntity AddWorkLogs(int nodeId, List <Ruanal.Core.ApiSdk.WorkLogEntity> logs)
{
if (Pub.PauseWorkLog)
{
return new JsonEntity()
{
code = 1
}
}
;
var sw = System.Diagnostics.Stopwatch.StartNew();
List <Model.TaskWorkLog> locallog = new List <Model.TaskWorkLog>();
foreach (var a in logs)
{
Model.TaskWorkLog worklogmodel = new Model.TaskWorkLog()
{
NodeId = nodeId,
TaskId = a.TaskId,
DispatchId = a.DispatchId ?? "",
LogType = a.LogType,
LogText = a.LogText,
ServerTime = DateTime.Parse(a.CreateTime)
};
locallog.Add(worklogmodel);
}
using (RLib.DB.DbConn dbconn = Pub.GetConn())
{
foreach (var a in locallog.GroupBy(x => x.ServerTime.ToString("yyyy-MM-dd")))
{
tasklogdal.AddWorkLogs(dbconn, Convert.ToDateTime(a.Key), a.ToList());
}
}
sw.Stop();
System.Diagnostics.Trace.WriteLine("服务器写日志用时：" + sw.Elapsed.TotalMilliseconds.ToString("0.0"));
return(new JsonEntity()
{
code = 1
});
}
}
