public JsonResult GetUserListBySearch(v_Business_PersonnelDepartment_Information searchParam)
{
var model = _dl.GetUserList(searchParam);
return(new ConfigurableJsonResult {
Data = model, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public List <v_Business_PersonnelDepartment_Information> GetUserList(v_Business_PersonnelDepartment_Information searchParam)
{
using (SqlSugarClient _dbMySql = SugarDao_MsSql.GetInstance())
{
var query = _dbMySql.Queryable <v_Business_PersonnelDepartment_Information>();
if (!string.IsNullOrEmpty(searchParam.name))
{
query.Where(i => i.name.Contains(searchParam.name)); //人员姓名
}
if (!string.IsNullOrEmpty(searchParam.PhoneNumber))
{
query.Where(i => i.PhoneNumber.Contains(searchParam.PhoneNumber)); //手机号
}
if (!string.IsNullOrEmpty(searchParam.TranslationOwnedFleet))
{
query.Where(i => i.TranslationOwnedFleet.Contains(searchParam.TranslationOwnedFleet)); //部门
}
return(query.OrderBy(i => i.OwnedFleet).ToList());
}
}
