Пример #1
0
        /// <summary>
        /// 分页列表
        /// </summary>
        public PagedList <BsSMS> GetPaging(SMSQueryRequeest requeest)
        {
            requeest.Tables      = "bssms bs";
            requeest.Tablefields = "bs.*";
            requeest.OrderBy     = "bs.SysNo desc";

            var row   = DBContext.Select <BsSMS>(requeest.Tablefields).From(requeest.Tables);
            var count = DBContext.Select <int>("count(0)").From(requeest.Tables);

            //条件查询委托
            Action <string, string, object> setWhere = (@where, name, value) =>
            {
                row.AndWhere(where).Parameter(name, value);
                count.AndWhere(where).Parameter(name, value);
            };

            if (requeest.Status.HasValue)
            {
                setWhere("bs.Status=@Status", "Status", requeest.Status);
            }

            var list = new PagedList <BsSMS>
            {
                TData            = row.Paging(requeest.CurrentPageIndex.GetHashCode(), requeest.PageSize.GetHashCode()).OrderBy(requeest.OrderBy).QueryMany(),
                CurrentPageIndex = requeest.CurrentPageIndex.GetHashCode(),
                TotalCount       = count.QuerySingle(),
            };

            return(list);
        }
Пример #2
0
        /// <summary>
        /// 查询某个时间段发送短信数量
        /// </summary>
        /// <param name="requeest">参数</param>
        public List <BsSMS> GetSendingTimes(SMSQueryRequeest requeest)
        {
            //测试SQL:SELECT * FROM bssms WHERE PhoneNumber='15008228718' AND CreatedDate>='2017-11-22 00:00:00' AND CreatedDate<='2017-11-22 23:59:59'
            var strSql = "SELECT * FROM bssms WHERE PhoneNumber=@PhoneNumber AND CreatedDate>='@StartTime' AND CreatedDate<='@EndTime'";

            var result = DBContext.Sql(strSql)
                         .Parameter("PhoneNumber", requeest.PhoneNumber)
                         .Parameter("StartTime", requeest.StartTime)
                         .Parameter("EndTime", requeest.EndTime)
                         .QueryMany <BsSMS>();

            return(result);
        }
Пример #3
0
 /// <summary>
 /// 分页列表
 /// </summary>
 public PagedList <BsSMS> GetPaging(SMSQueryRequeest requeest)
 {
     return(Using <ISMS>().GetPaging(requeest));
 }
Пример #4
0
 /// <summary>
 /// 查询某个时间段发送短信数量
 /// </summary>
 /// <param name="requeest">参数</param>
 public List <BsSMS> GetSendingTimes(SMSQueryRequeest requeest)
 {
     return(Using <ISMS>().GetSendingTimes(requeest));
 }