/// <summary>
/// 获取基础数据代码值列表
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public BasePageList<BaseCodeSelectModel> GetCodeList(BaseCodeQueryModel query)
{
const string spName = "sp_common_pager";
const string tableName = @"base_code as a left join base_code_type as b on a.typekey=b.typekey ";
const string fields = "a.innerid,codevalue,codename,sort,a.typekey,a.isenabled,ifnull(remark,'') remark,b.typename";
var oldField = string.IsNullOrWhiteSpace(query.Order) ? " sort asc,b.typename asc " : query.Order;
var sqlWhere = new StringBuilder("1=1");
if (!string.IsNullOrWhiteSpace(query.Typekey))
{
sqlWhere.Append($" and a.typekey = '{query.Typekey}'");
}
if (!string.IsNullOrWhiteSpace(query.CodeName))
{
sqlWhere.Append($" and codename like '%{query.CodeName}%'");
}
var model = new PagingModel(spName, tableName, fields, oldField, sqlWhere.ToString(), query.PageSize, query.PageIndex);
var list = Helper.ExecutePaging<BaseCodeSelectModel>(model, query.Echo);
return list;
}
