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 }); } }