public ActionResult QueryCompany() { QF_Company filter = BuildQueryFilterEntity <QF_Company>(); var result = CompanyService.QueryCompanyList2(filter); return(AjaxGridJson(result)); }
/// <summary> /// 分页查询Company信息 /// </summary> public static QueryResult <Company> QueryCompanyList(QF_Company filter) { DataCommand cmd = new DataCommand("QueryCompanyList"); cmd.QuerySetCondition("c.SysNo", ConditionOperation.Equal, DbType.Int32, filter.SysNo); cmd.QuerySetCondition("c.Name", ConditionOperation.Like, DbType.String, filter.Name); cmd.QuerySetCondition("c.CompanyStatus", ConditionOperation.Equal, DbType.Int32, filter.CompanyStatus); QueryResult <Company> result = cmd.Query <Company>(filter, " SysNo DESC"); return(result); }
/// <summary> /// 分页查询Company信息 /// </summary> public static QueryResult <Company> QueryCompanyList2(QF_Company filter) { DataCommand cmd = new DataCommand("QueryCompanyList"); cmd.QuerySetCondition("c.SysNo", ConditionOperation.Equal, DbType.Int32, filter.SysNo); if (!string.IsNullOrEmpty(filter.Name)) { filter.Name = cmd.SetSafeParameter(filter.Name); cmd.QuerySetCondition($"And (c.Name like '%{ filter.Name}%' Or c.ContactName like '%{ filter.Name}%' Or c.ContactCellPhone like '%{ filter.Name}%')"); } cmd.QuerySetCondition("c.CompanyStatus", ConditionOperation.Equal, DbType.Int32, filter.CompanyStatus); QueryResult <Company> result = cmd.Query <Company>(filter, " SysNo DESC"); return(result); }
/// <summary> /// 分页查询Company信息 /// </summary> public static QueryResult <Company> QueryCompanyList(QF_Company filter) { return(CompanyDA.QueryCompanyList(filter)); }