/// <summary> /// 获取资金消费统计(天)(按条件) /// </summary> /// <param name="whereExpression">where条件,为空或空字符串,将直接返回null。</param> /// <param name="params">参数列表</param> public static FundsConsumeTypeDay getFundsConsumeTypeDayByWhere( #if !CSharp20 this #endif Symbol.Data.DataContext dataContext, string whereExpression, params object[] @params) { if (string.IsNullOrEmpty(whereExpression)) { return(null); } return(dataContext.CreateQuery <FundsConsumeTypeDay>("select top 1 * from [FundsConsumeTypeDay] where " + whereExpression, @params).FirstOrDefault()); }
/// <summary> /// 获取资金消费统计(天)(按Id) /// </summary> /// <param name="id">资金消费统计(天) Id,为null将直接返回null。</param> public static FundsConsumeTypeDay getFundsConsumeTypeDayById( #if !CSharp20 this #endif Symbol.Data.DataContext dataContext, long?id) { if (id == null) { return(null); } return(dataContext.CreateQuery <FundsConsumeTypeDay>("select top 1 * from [FundsConsumeTypeDay] where [Id]=@p1", id).FirstOrDefault()); }
/// <summary> /// 获取用户(按条件) /// </summary> /// <param name="whereExpression">where条件,为空或空字符串,将直接返回null。</param> /// <param name="params">参数列表</param> public static User getUserByWhere( #if !CSharp20 this #endif Symbol.Data.DataContext dataContext, string whereExpression, params object[] @params) { if (string.IsNullOrEmpty(whereExpression)) { return(null); } return(dataContext.CreateQuery <User>("select top 1 * from [User] where " + whereExpression, @params).FirstOrDefault()); }
/// <summary> /// 获取消费选项(按Id) /// </summary> /// <param name="id">消费选项 Id,为null将直接返回null。</param> public static ConsumeType getConsumeTypeById( #if !CSharp20 this #endif Symbol.Data.DataContext dataContext, int?id) { if (id == null) { return(null); } return(dataContext.CreateQuery <ConsumeType>("select top 1 * from [ConsumeType] where [Id]=@p1", id).FirstOrDefault()); }
/// <summary> /// 获取用户(按Id) /// </summary> /// <param name="id">用户 Id,为null将直接返回null。</param> public static User getUserById( #if !CSharp20 this #endif Symbol.Data.DataContext dataContext, int?id) { if (id == null) { return(null); } return(dataContext.CreateQuery <User>("select top 1 * from [User] where [Id]=@p1", id).FirstOrDefault()); }