public List <BillOne> Search1(BillParamter parameter)
{
using (var db = GetDbContext())
{
var query = db.BillOnes.Where(e => e.Budget == Budget.Income).AsQueryable();
if (parameter.MinMoney.HasValue)
{
query = query.Where(e => e.Money >= parameter.MinMoney.Value);
}
if (parameter.MaxMoney.HasValue)
{
query = query.Where(e => e.Money <= parameter.MaxMoney.Value);
}
if (parameter.StartTime.HasValue)
{
query = query.Where(e => e.Time >= parameter.StartTime.Value);
}
if (parameter.EndTime.HasValue)
{
query = query.Where(e => e.Time <= parameter.EndTime.Value);
}
if (!string.IsNullOrEmpty(parameter.OtherSide))
{
query = query.Where(e => e.Account.Contains(parameter.OtherSide));
}
if (!string.IsNullOrEmpty(parameter.Remark))
{
query = query.Where(e => e.Remark.Contains(parameter.Remark));
}
query = query.OrderBy(e => e.ID).SetPage(parameter.Page);
return(query.ToList());
}
}
/// <summary>
/// 作用：查询
/// 作者：汪建龙
/// 编写时间：2017年1月11日10:06:02
/// </summary>
/// <param name="parameter"></param>
/// <returns></returns>
public List <BillView> Search(BillParamter parameter)
{
using (var db = GetDbContext())
{
var query = db.Bill_views.AsQueryable();
if (parameter.Company.HasValue)
{
query = query.Where(e => e.Company == parameter.Company.Value);
}
if (parameter.MinMoney.HasValue)
{
query = query.Where(e => e.Money >= parameter.MinMoney.Value);
}
if (parameter.MaxMoney.HasValue)
{
query = query.Where(e => e.Money <= parameter.MaxMoney.Value);
}
if (parameter.StartTime.HasValue)
{
query = query.Where(e => e.Time >= parameter.StartTime.Value);
}
if (parameter.EndTime.HasValue)
{
query = query.Where(e => e.Time <= parameter.EndTime.Value);
}
if (!string.IsNullOrEmpty(parameter.OtherSide))
{
query = query.Where(e => e.Account.Contains(parameter.OtherSide));
}
if (parameter.Association.HasValue)
{
query = query.Where(e => e.Association == parameter.Association.Value);
}
if (!string.IsNullOrEmpty(parameter.Remark))
{
query = query.Where(e => e.Remark.Contains(parameter.Remark));
}
if (parameter.Cost.HasValue)
{
query = query.Where(e => e.Cost == parameter.Cost.Value);
}
else
{
query = query.Where(e => e.Cost != Cost.RealIncome);
}
query = query.OrderBy(e => e.ID).SetPage(parameter.Page);
return(query.ToList());
}
}
public ActionResult GetJsonBill(string company = null, DateTime?startTime = null, DateTime?endTime = null, double?minMoney = null, double?maxMoney = null, string otherside = null, string remark = null, string association = null)
{
var parameter = new BillParamter()
{
StartTime = startTime,
EndTime = endTime,
MinMoney = minMoney,
MaxMoney = maxMoney,
OtherSide = otherside,
Remark = remark
};
var list = Core.BillManager.Search(parameter).Where(e => e.Association != Association.Full);
return(Json(list, JsonRequestBehavior.AllowGet));
}
public ActionResult LoadBill(
DateTime?startTime = null, DateTime?endTime = null,
double?minMoney = null, double?maxMoney = null,
string otherside = null, string remark = null,
string association = null, int page = 1)
{
var parameter = new BillParamter
{
StartTime = startTime,
EndTime = endTime,
MinMoney = minMoney,
MaxMoney = maxMoney,
OtherSide = otherside,
Remark = remark,
Page = new PageParameter(page, 20)
};
parameter.Association = Association.None;
return(View());
}
/// <summary>
/// 作用：基础搜索
/// 作者：汪建龙
/// 编写时间：2017年1月11日09:51:39
/// </summary>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <param name="minMoney"></param>
/// <param name="maxMoney"></param>
/// <param name="otherside"></param>
/// <param name="remark"></param>
/// <param name="association"></param>
/// <param name="cost"></param>
/// <param name="company"></param>
/// <param name="page"></param>
private void BillSearchBase(
DateTime?startTime = null, DateTime?endTime = null,
double?minMoney = null, double?maxMoney = null,
string otherside = null, string remark = null,
string association = null, string cost = "实际收入", string company = null, PageParameter page = null)
{
var parameter = new BillParamter()
{
StartTime = startTime,
EndTime = endTime,
MinMoney = minMoney,
MaxMoney = maxMoney,
OtherSide = otherside,
Remark = remark,
Page = page
};
if (!string.IsNullOrEmpty(company))
{
parameter.Company = EnumHelper.GetEnum <Company>(company);
}
if (!string.IsNullOrEmpty(association))
{
parameter.Association = EnumHelper.GetEnum <Association>(association);
}
else
{
parameter.Association = Association.None;
}
if (!string.IsNullOrEmpty(cost))
{
parameter.Cost = EnumHelper.GetEnum <Cost>(cost);
}
var blist = Core.Bill_ViewManager.Search(parameter);
ViewBag.BResult = blist;
ViewBag.Parameter = parameter;
ViewBag.Page = parameter.Page;
}
