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));
}
