public ActionResult Search(SystemData systemData, string key)
{
if (string.IsNullOrEmpty(key))
{
return(Json(null, JsonRequestBehavior.AllowGet));
}
List <JsonData> list = null;
if (systemData == SystemData.Enterprise)
{
var parameter = new EnterpriseParameter
{
Name = key,
Page = new PageParameter(1, 5)
};
list = Core.EnterpriseManager.Search(parameter).Select(e => new JsonData {
ID = e.ID, Name = e.Name
}).ToList();
}
else
{
var parameter = new LawyerParameter
{
Name = key,
Page = new PageParameter(1, 5)
};
list = Core.LawyerManager.Search(parameter).Select(e => new JsonData {
ID = e.ID, Name = e.Name
}).ToList();
}
return(Json(list, JsonRequestBehavior.AllowGet));
}
// GET: Enterprise
public ActionResult Index(
string name = null, string oibc = null,
string uscc = null, string address = null,
string lawyer = null, string lawnumber = null,
string number = null, string scope = null,
string type = null, double?minmoney = null, double?maxMoney = null,
string contact = null, string telphone = null, GradeDegree?degree = null,
int page = 1, int rows = 20)
{
var parameter = new EnterpriseParameter
{
Name = name,
OIBC = oibc,
USCC = uscc,
Address = address,
Lawyer = lawyer,
LawNumber = lawnumber,
Number = number,
Scope = scope,
Type = type,
Contact = contact, TelPhone = telphone,
MinMoney = minmoney,
MaxMoney = maxMoney,
Degree = degree,
Deleted = false,
Page = new PageParameter(page, rows)
};
var list = Core.EnterpriseManager.Search(parameter);
ViewBag.Types = Core.EnterpriseManager.GetEnterpriseType();
ViewBag.Parameter = parameter;
ViewBag.Page = parameter.Page;
ViewBag.List = list;
return(View());
}
public ActionResult SearchEnterprise(string key, int page = 1)
{
var parameter = new EnterpriseParameter
{
Name = key,
Page = new PageParameter(page, 20)
};
var list = Core.EnterpriseManager.Search(parameter);
parameter.SearchEndTime = DateTime.Now;
ViewBag.List = list;
ViewBag.Parameter = parameter;
return(View());
}
/// <summary>
/// 作用：查询企业
/// 作者：汪建龙
/// 编写时间：2017年3月6日11:28:14
/// </summary>
/// <param name="parameter"></param>
/// <returns></returns>
public List <Enterprise> Search(EnterpriseParameter parameter)
{
var query = Db.Enterprises.Where(e => e.Deleted == parameter.Deleted).AsQueryable();
if (parameter.Degree.HasValue)
{
query = query.Where(e => e.Degree == parameter.Degree.Value);
}
if (!string.IsNullOrEmpty(parameter.Name))
{
query = query.Where(e => e.Name.ToLower().Contains(parameter.Name.ToLower()));
}
if (!string.IsNullOrEmpty(parameter.OIBC))
{
query = query.Where(e => e.OIBC.ToLower().Contains(parameter.OIBC.ToLower()));
}
if (!string.IsNullOrEmpty(parameter.USCC))
{
query = query.Where(e => e.USCC.ToLower().Contains(parameter.USCC.ToLower()));
}
if (!string.IsNullOrEmpty(parameter.Address))
{
query = query.Where(e => e.Address.ToLower().Contains(parameter.Address.ToLower()));
}
if (!string.IsNullOrEmpty(parameter.Lawyer))
{
query = query.Where(e => e.Lawyer.ToLower().Contains(parameter.Lawyer.ToLower()));
}
if (!string.IsNullOrEmpty(parameter.LawNumber))
{
query = query.Where(e => e.LawNumber.ToLower().Contains(parameter.LawNumber.ToLower()));
}
if (!string.IsNullOrEmpty(parameter.Number))
{
query = query.Where(e => e.Number.ToLower().Contains(parameter.Number.ToLower()));
}
if (!string.IsNullOrEmpty(parameter.Scope))
{
query = query.Where(e => e.Scope.ToLower().Contains(parameter.Scope.ToLower()));
}
if (!string.IsNullOrEmpty(parameter.Type))
{
if (parameter.Type == "NULL")
{
query = query.Where(e => string.IsNullOrEmpty(e.Type));
}
else
{
query = query.Where(e => e.Type.ToLower().Contains(parameter.Type.ToLower()));
}
}
if (!string.IsNullOrEmpty(parameter.Contact))
{
query = query.Where(e => e.Contact.ToLower().Contains(parameter.Contact.ToLower()));
}
if (!string.IsNullOrEmpty(parameter.TelPhone))
{
query = query.Where(e => e.TelPhone.ToLower().Contains(parameter.TelPhone.ToLower()));
}
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);
}
query = query.OrderBy(e => e.ID).SetPage(parameter.Page);
return(query.ToList());
}
