public PageModel <Model.TaskWorkLog> PageWorkLog(DateTime date, int?taskid, int?nodeid, int?logtype, string runguid, string keywords, DateTime?begintime, DateTime?endtime, int pno) { int pagesize = 20; using (RLib.DB.DbConn dbconn = Pub.GetConn()) { int totalcount = 0; if (!Pub.ExistTableInDB(dbconn, Pub.BuildWTbName(date))) { return(new PageModel <Model.TaskWorkLog>() { List = new List <Model.TaskWorkLog>(), PageNo = pno, PageSize = pagesize, TotalCount = 0 }); } var model = tasklogdal.GetWorkLogPage(dbconn, date, taskid, nodeid, logtype, false, null, runguid, keywords, begintime, endtime, pno, pagesize, out totalcount); return(new PageModel <Model.TaskWorkLog>() { List = model, PageNo = pno, PageSize = pagesize, TotalCount = totalcount }); } }
public PageModel <Model.TaskWorkLog> PageWorkLogErrorMode(DateTime date, List <string> notContainText, DateTime?begintime, DateTime?endtime, int pno) { int pagesize = 20; using (RLib.DB.DbConn dbconn = Pub.GetConn()) { int totalcount = 0; if (!Pub.ExistTableInDB(dbconn, Pub.BuildWTbName(date))) { return(new PageModel <Model.TaskWorkLog>() { List = new List <Model.TaskWorkLog>(), PageNo = pno, PageSize = pagesize, TotalCount = 0 }); } var model = tasklogdal.GetWorkLogPage(dbconn, date, null, null, 1, false, notContainText, null, null, begintime, endtime, pno, pagesize, out totalcount); return(new PageModel <Model.TaskWorkLog>() { List = model, PageNo = pno, PageSize = pagesize, TotalCount = totalcount }); } }
public int DeleteWorkLog(RLib.DB.DbConn dbconn, DateTime endtime) { if ((DateTime.Now - endtime).TotalDays <= 2) { throw new MException("最近两天的日志不能删除"); } int max = 100; string tbname = string.Empty; int c = 0; while (Pub.ExistTableInDB(dbconn, tbname = "taskWorkLog" + endtime.ToString("yyMMdd")) && max > 0) { string sql = "drop table " + tbname; dbconn.ExecuteSql(sql); max--; endtime = endtime.AddDays(-1); c++; } return(c); }
public override void RunOnce() { try { DateTime btime = DateTime.Now.AddDays(-TBPreDay); DateTime etime = btime.AddDays(TBPreDay + TBNextDay); List <string> tbpartnames = new List <string>(); int max = 100; while (btime <= etime && max > 0) { max--; tbpartnames.Add(btime.ToString("yyMMdd")); btime = btime.AddDays(1); } var filename = System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceNames().FirstOrDefault(z => z.EndsWith("createWorkLog.sql")); if (string.IsNullOrWhiteSpace(filename)) { return; } var stream = System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream(filename); var createSql = string.Empty; using (var sr = new System.IO.StreamReader(stream, System.Text.Encoding.Default)) { createSql = sr.ReadToEnd(); } using (var dbconn = Pub.GetConn()) { foreach (var tbpartname in tbpartnames) { if (Pub.ExistTableInDB(dbconn, "taskWorkLog" + tbpartname)) { continue; } string sql1 = createSql.Replace("{parttablename}", tbpartname); dbconn.ExecuteSql(sql1); } } } catch (Exception) { } }