选择时间查询

<hr class="hr_search">
                <div class="row">
                    <div class="col-sm-12">
                        <form method="get" enctype="application/x-www-form-urlencoded">
                            <div class="form-group form-inline mailbox-controls" style="overflow: hidden">
                                <input type="text" class="form-control datepicker" name="dateTime" autocomplete="off" value="@(Model.AddDateTime?.ToString("yyyy-MM-dd"))" placeholder="操作时间(起始)" data-date-format="yyyy-mm-dd">
                                <div style="display: inline-block" class="btn-group">
                                    <button class="btn btn-small btn-default" type="submit"><i class="fa fa-search"></i>&nbsp;&nbsp;搜索</button>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>
 public class SupplierCapitalLogIndexModel : ListBaseModel
    {
        public SupplierCapitalLogIndexModel(string kw, int pageIndex, int pageSize, string title = "", string subTitle = "",DateTime? addDateTime=null) :
            base(title, subTitle)
        {
            Results = new List<VM<SupplierCapitalLog>>();
            Keyword = kw;
            if (pageIndex < 0) pageIndex = 1;
            if (pageSize < 2 || pageSize > 50) pageSize = 15;
            Pager.PageIndex = pageIndex;
            Pager.PageSize = pageSize;
            AddDateTime = addDateTime;
        }
        /// <summary>
        /// 关键字
        /// </summary>
        public string Keyword { get; set; }

        /// <summary>
        /// 操作时间
        /// </summary>
        public DateTime? AddDateTime { get; set; }

        /// <summary>
        /// 数据集合
        /// </summary>
        public List<VM<SupplierCapitalLog>> Results { get; set; }
    }
  public ActionResult SupplierCapitalLogIndex(int? type = null, string kw = "", int pageIndex = 1, int pageSize = 15, DateTime? dateTime= null)
        {
            var model = new SupplierCapitalLogIndexModel(kw, pageIndex, pageSize, "资金记录");
            RenderOutputBaseModel(model, new Tuple<string, string>("资金记录", Url.Action("SupplierCapitalLogIndex")));
            var supplierCapitalLog = SupplierService.Value.PageSupplierCapitalLogEntities(model.Pager, kw, supplierId: MerchantInfo.SupplierId, dateTime: dateTime);
            if (supplierCapitalLog != null)
            {
                var supplier = new List<VM<SupplierCapitalLog>>();
                foreach (var item in supplierCapitalLog)
                {
                    var supplierLogs = new VM<SupplierCapitalLog>(item);
                    supplier.Add(supplierLogs);
                }
                ViewBag.kw = kw;
                model.Results = supplier;
                //赋值到文本框
                model.AddDateTime = dateTime;
            }
            return View(model);
        }
 public List<SupplierCapitalLog> PageSupplierCapitalLogEntities(PageInfo pager, string kw, int supplierId,DateTime ? dateTime=null)
        {
            return SupplierCapitalLogAccess.Value.PageEntities(pager, kw, supplierId,dateTime:dateTime);
        }
  public List<SupplierCapitalLog> PageEntities(PageInfo pager, string kw, int supplierId, DateTime?dateTime=null)
        {
            var expr = PredicateBuilder.True<SupplierCapitalLog>();
            if (supplierId > 0) expr = expr.And(x => x.SupplierId == supplierId);
            if (dateTime.HasValue) expr = expr.And(x => dateTime.Value.Date <= x.AddTime.Date);
            if (!string.IsNullOrWhiteSpace(kw))
            {
                expr =
                    expr.And
                    (x => x.Remark.Contains(kw) || x.Summery.Contains(kw));
            }
            var list = Query().Where(expr).OrderByDescending(p => p.AddTime).Skip(pager.Skip).Take(pager.PageSize).ToList();
            pager.Total = Query().Where(expr).Count();
            return list;
        }

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值