赖素文
authored
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
using Hh.Mes.POJO.Entity;
using Hh.Mes.Service.Repository;
namespace Hh.Mes.Service.QuartzJobService
{
public class ClearLogJobService : RepositorySqlSugar<sys_job>
{
public void Execute()
{
string sql = Context.Queryable<sys_job>().First(x => x.methodName == "ClearLogJob").jobSql;
//示例SQL
//"declare @deleteTime datetime;
//set @deleteTime=dateadd(month,-2,getdate());
// select @deleteTime
//delete from sys_job_log where createTime <= @deleteTime
//delete from sys_interface_log where createTime <= @deleteTime
//delete from sys_oper_log where createTime <= @deleteTime
//delete from sys_login_log where createTime <= @deleteTime";
Context.Ado.ExecuteCommand(sql);
}
}
}
|
