<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> 搜索</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;
}