/// <summary>
/// Get Object List
/// </summary>
/// <param name="query">query model</param>
/// <returns>object list</returns>
public sealed override async Task <List <DT> > GetListAsync(IQuery query)
{
IEnumerable <DT> datas = await GetDataListAsync(query).ConfigureAwait(false);
if (QueryEvent == null)
{
return(datas.ToList());
}
QueryEvent?.Invoke(ref datas);
return(datas.ToList());
}
/// <summary>
/// 获取对象列表
/// </summary>
/// <param name="query">查询对象</param>
/// <returns>对象列表</returns>
public sealed override List <DT> GetList(IQuery query)
{
IEnumerable <DT> datas = GetDataList(query);
if (QueryEvent == null)
{
return(datas.ToList());
}
QueryEvent?.Invoke(ref datas);
return(datas.ToList());
}
/// <summary>
/// 获取对象分页
/// </summary>
/// <param name="query">查询对象</param>
/// <returns>对象列表</returns>
public sealed override IPaging <DT> GetPaging(IQuery query)
{
var paging = GetDataPaging(query);
if (QueryEvent == null)
{
return(paging);
}
IEnumerable <DT> datas = paging;
QueryEvent?.Invoke(ref datas);
return(new Paging <DT>(paging.Page, paging.PageSize, paging.TotalCount, datas));
}
/// <summary>
/// Get Object
/// </summary>
/// <param name="query">query model</param>
/// <returns>Object</returns>
public sealed override async Task <DT> GetAsync(IQuery query)
{
var data = await GetDataAsync(query).ConfigureAwait(false);
if (QueryEvent == null)
{
return(data);
}
IEnumerable <DT> dataList = new List <DT>()
{
data
};
QueryEvent?.Invoke(ref dataList);
return(dataList.FirstOrDefault());
}
/// <summary>
/// 获取对象
/// </summary>
/// <param name="query">查询对象</param>
/// <returns>对象</returns>
public sealed override DT Get(IQuery query)
{
var data = GetData(query);
if (QueryEvent == null)
{
return(data);
}
IEnumerable <DT> dataList = new List <DT>()
{
data
};
QueryEvent?.Invoke(ref dataList);
return(dataList.FirstOrDefault());
}
private void DoSearch()
{
string strSQL = "";
var dataTable = GetAllFields(flp_SearchField);
foreach (var field in dataTable.GetTableFields().Where(f => f.IsSearched).ToArray())
{
if (field.Value != "" && field.Type.Contains("varchar"))
{
strSQL += field.Name + " like N'%" + field.Value + "%' and ";
}
}
if (strSQL.Contains("and"))
{
strSQL = strSQL.Remove(strSQL.LastIndexOf("and"));
}
if (QueryEvent != null)
{
QueryEvent.Invoke(strSQL);
}
}
