/// <summary>
/// 查询属性
/// </summary>
/// <param name="queryCriteria"></param>
/// <param name="totalCount"></param>
/// <returns></returns>
public DataTable QueryPropertyList(PropertyQueryFilter queryCriteria, out int totalCount)
{
DataCommand dc = DataCommandManager.GetDataCommand("QueryPropertyList");
if (string.IsNullOrEmpty(queryCriteria.PropertyName))
{
dc.SetParameterValue("@PropertyDescription", "");
}
else
{
dc.SetParameterValue("@PropertyDescription", "%" + queryCriteria.PropertyName.Trim() + "%");
}
dc.SetParameterValue("@IsActive", queryCriteria.Status == null ? -999 : (int)queryCriteria.Status);
dc.SetParameterValue("@CompanyCode", "8601");
dc.SetParameterValue("@SortField", queryCriteria.PagingInfo.SortBy);
dc.SetParameterValue("@PageSize", queryCriteria.PagingInfo.PageSize);
dc.SetParameterValue("@PageCurrent", queryCriteria.PagingInfo.PageIndex);
var source = dc.ExecuteDataTable();
totalCount = (int)dc.GetParameterValue("@TotalCount");
return(source);
}
public QueryResult QueryProperty(PropertyQueryFilter request)
{
if (request == null)
{
throw new BizException(ResouceManager.GetMessageString("IM.Property", "RequestIsNull"));
}
int totalCount;
var data = ObjectFactory <IPropertyQueryDA> .Instance.QueryPropertyList(request, out totalCount);
var source = new QueryResult {
Data = data, TotalCount = totalCount
};
return(source);
}
