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