SqlSugar中查看生成的SQL语句

1、SQL常用事件

注意：Aop一定要设置在你操作语句之前，不然不会生效，还有必须是同一个SqlSuagrClient才会有效

public async Task<dynamic> GetNoPagingList([FromQuery] YkzptSafecompanypromiseListQueryInput input)
{
//每次Sql执行前事件
_db.Aop.OnLogExecuting = (sql, data) =>
{
var n1 = sql;
};

var data = await _db.Queryable<YkzptSafecompanypromiseEntity>()
.WhereIF(!string.IsNullOrEmpty(input.warehouseId), p => p.WarehouseId.Equals(input.warehouseId))
.Select(it=> new YkzptSafecompanypromiseListOutput
{
id = it.Id,
warehouseId=it.WarehouseId,
promiseDate=it.PromiseDate,
mainPerson=it.MainPerson,
promiseContent=it.PromiseContent,
companyStateInfor=it.CompanyStateInfor,
}).MergeTable().OrderBy(sidx+" "+input.sort).ToListAsync();

return data;
}