public async Task <int> CountAsync <F>(Expression <Func <F> > propertyFunc)
{
DC.Action = ActionEnum.Select;
DC.Compare = CompareXEnum.None;
DC.Func = FuncEnum.Count;
var dic = DC.XE.FuncTExpression(propertyFunc);
DC.DPH.AddParameter(dic);
PreExecuteHandle(UiMethodEnum.Count);
return(await DSA.ExecuteScalarAsync <int>());
}
public async Task <int> CountAsync()
{
DC.Action = ActionEnum.Select;
DC.Option = OptionEnum.Column;
DC.Compare = CompareXEnum.None;
DC.Func = FuncEnum.Count;
DC.DPH.AddParameter(DC.DPH.SelectColumnDic(new List <DicParam> {
DC.DPH.CountDic(default(Type), "*", string.Empty)
}));
PreExecuteHandle(UiMethodEnum.Count);
return(await DSA.ExecuteScalarAsync <int>());
}
public async Task <F?> SumAsync <F>(Expression <Func <F?> > propertyFunc)
where F : struct
{
DC.Action = ActionEnum.Select;
DC.Option = OptionEnum.Column;
DC.Compare = CompareXEnum.None;
DC.Func = FuncEnum.SumNullable;
var dic = DC.XE.FuncTExpression(propertyFunc);
DC.DPH.AddParameter(dic);
PreExecuteHandle(UiMethodEnum.Sum);
return(await DSA.ExecuteScalarAsync <F>());
}
public async Task <bool> IsExistAsync()
{
DC.Action = ActionEnum.Select;
DC.Option = OptionEnum.Column;
DC.Compare = CompareXEnum.None;
DC.Func = FuncEnum.Count;
DC.DPH.AddParameter(DC.DPH.SelectColumnDic(new List <DicParam> {
DC.DPH.CountDic(typeof(M), "*")
}));
PreExecuteHandle(UiMethodEnum.IsExist);
var count = await DSA.ExecuteScalarAsync <long>();
return(count > 0);
}
public async Task <bool> IsExistAsync()
{
DC.Action = ActionEnum.Select;
DC.Option = OptionEnum.Column;
DC.Compare = CompareXEnum.None;
DC.Func = FuncEnum.Count;
var dic = DC.Parameters.FirstOrDefault(it => it.Action == ActionEnum.From);
DC.DPH.AddParameter(DC.DPH.SelectColumnDic(new List <DicParam> {
DC.DPH.CountDic(dic.TbMType, "*")
}));
PreExecuteHandle(UiMethodEnum.IsExist);
var count = await DSA.ExecuteScalarAsync <long>();
return(count > 0);
}
