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); }