public async Task <List <LogOperateEntity> > GetList(LogOperateListParam param)
{
// var strSql = new StringBuilder();
// List<DbParameter> filter = ListFilter(param, strSql);
// var list = await _logOperateEntityDB.Find<LogOperateEntity>(strSql.ToString(), filter.ToArray());
return(new List <LogOperateEntity>());
}
public async Task <List <LogOperateEntity> > GetPageList(LogOperateListParam param, Pagination pagination)
{
var strSql = new StringBuilder();
List <DbParameter> filter = ListFilter(param, strSql);
var list = await this.BaseRepository().FindList <LogOperateEntity>(strSql.ToString(), filter.ToArray(), pagination);
return(list.ToList());
}
public async Task<TData<List<LogOperateEntity>>> GetPageList(LogOperateListParam param, Pagination pagination)
{
TData<List<LogOperateEntity>> obj = new TData<List<LogOperateEntity>>();
obj.Result = await logOperateService.GetPageList(param, pagination);
obj.TotalCount = pagination.TotalCount;
obj.Tag = 1;
return obj;
}
public async Task <TData <List <LogOperateEntity> > > GetList(LogOperateListParam param)
{
TData <List <LogOperateEntity> > obj = new TData <List <LogOperateEntity> >();
obj.Data = await logOperateService.GetList(param);
obj.Tag = 1;
return(obj);
}
private List <DbParameter> ListFilter(LogOperateListParam param, StringBuilder strSql)
{
strSql.Append(@"SELECT a.Id,
a.BaseCreateTime,
a.BaseCreatorId,
a.LogStatus,
a.IpAddress,
a.IpLocation,
a.Remark,
a.ExecuteUrl,
a.ExecuteParam,
a.ExecuteResult,
a.ExecuteTime,
b.UserName,
c.DepartmentName
FROM SysLogOperate a
LEFT JOIN SysUser b ON a.BaseCreatorId = b.Id
LEFT JOIN SysDepartment c ON b.DepartmentId = c.Id
WHERE 1 = 1");
var parameter = new List <DbParameter>();
if (param != null)
{
if (!string.IsNullOrEmpty(param.UserName))
{
strSql.Append(" AND b.UserName like @UserName");
parameter.Add(DbParameterExtension.CreateDbParameter("@UserName", '%' + param.UserName + '%'));
}
if (param.LogStatus > -1)
{
strSql.Append(" AND a.LogStatus = @LogStatus");
parameter.Add(DbParameterExtension.CreateDbParameter("@LogStatus", param.LogStatus));
}
if (!string.IsNullOrEmpty(param.ExecuteUrl))
{
strSql.Append(" AND a.ExecuteUrl like @ExecuteUrl");
parameter.Add(DbParameterExtension.CreateDbParameter("@ExecuteUrl", '%' + param.ExecuteUrl + '%'));
}
if (!string.IsNullOrEmpty(param.StartTime.ParseToString()))
{
strSql.Append(" AND a.BaseCreateTime >= @StartTime");
parameter.Add(DbParameterExtension.CreateDbParameter("@StartTime", param.StartTime));
}
if (!string.IsNullOrEmpty(param.EndTime.ParseToString()))
{
param.EndTime = (param.EndTime.Value.ToString("yyyy-MM-dd") + " 23:59:59").ParseToDateTime();
strSql.Append(" AND a.BaseCreateTime <= @EndTime");
parameter.Add(DbParameterExtension.CreateDbParameter("@EndTime", param.EndTime));
}
}
return(parameter);
}
private List <DbParameter> ListFilter(LogOperateListParam param, StringBuilder strSql)
{
strSql.Append(@"SELECT a.id as Id,
a.base_create_time as BaseCreateTime,
a.base_creator_id as BaseCreatorId,
a.log_status as LogStatus,
a.ip_address as IpAddress,
a.ip_location as IpLocation,
a.remark as Remark,
a.execute_url as ExecuteUrl,
a.execute_param as ExecuteParam,
a.execute_result as ExecuteResult,
a.execute_time as ExecuteTime,
b.user_name as UserName,
c.department_name as DepartmentName
FROM sys_log_operate a
LEFT JOIN sys_user b ON a.base_creator_id = b.id
LEFT JOIN sys_department c ON b.department_id = c.id
WHERE 1 = 1");
var parameter = new List <DbParameter>();
if (param != null)
{
if (!string.IsNullOrEmpty(param.UserName))
{
strSql.Append(" AND b.user_name like @UserName");
parameter.Add(DbParameterExtension.CreateDbParameter("@UserName", '%' + param.UserName + '%'));
}
if (param.LogStatus > -1)
{
strSql.Append(" AND a.log_status = @LogStatus");
parameter.Add(DbParameterExtension.CreateDbParameter("@LogStatus", param.LogStatus));
}
if (!string.IsNullOrEmpty(param.ExecuteUrl))
{
strSql.Append(" AND a.execute_url like @ExecuteUrl");
parameter.Add(DbParameterExtension.CreateDbParameter("@ExecuteUrl", '%' + param.ExecuteUrl + '%'));
}
if (!string.IsNullOrEmpty(param.StartTime.ParseToString()))
{
strSql.Append(" AND a.base_modify_time >= @StartTime");
parameter.Add(DbParameterExtension.CreateDbParameter("@StartTime", param.StartTime));
}
if (!string.IsNullOrEmpty(param.EndTime.ParseToString()))
{
param.EndTime = (param.EndTime.Value.ToString("yyyy-MM-dd") + " 23:59:59").ParseToDateTime();
strSql.Append(" AND a.base_modify_time <= @EndTime");
parameter.Add(DbParameterExtension.CreateDbParameter("@EndTime", param.EndTime));
}
}
return(parameter);
}
public async Task <IActionResult> GetPageListJson(LogOperateListParam param, Pagination pagination)
{
TData <List <LogOperateEntity> > obj = await sysLogOperateBLL.GetPageList(param, pagination);
return(Json(obj));
}
public async Task <IActionResult> GetListJson(LogOperateListParam param)
{
TData <List <LogOperateEntity> > obj = await logOperateBLL.GetList(param);
return(Json(obj));
}
