public QueryResult QueryRmaPolicy(RmaPolicyQueryFilter query)
{
int totalCount;
var data = ObjectFactory <IRmaPolicyQueryDA> .Instance.QueryRmaPolicy(query, out totalCount);
var source = new QueryResult {
Data = data, TotalCount = totalCount
};
return(source);
}
public DataTable QueryRmaPolicy(RmaPolicyQueryFilter query, out int totalCount)
{
DataCommand cmd = DataCommandManager.GetDataCommand("QueryRmaPolicy");
cmd.SetParameterValue("@RmaStatus", query.Status);
cmd.SetParameterValue("@RmaType", query.Type);
cmd.SetParameterValue("@CreateUserName", query.CreateUserName);
cmd.SetParameterValue("@SysNo", query.SysNo);
cmd.SetParameterValue("@pageIndex", query.PagingInfo.PageIndex);
cmd.SetParameterValue("@pageSize", query.PagingInfo.PageSize);
cmd.SetParameterValue("@sortField", query.PagingInfo.SortBy);
EnumColumnList enumList = new EnumColumnList
{
{ "Status", typeof(RmaPolicyStatus) },
{ "Type", typeof(RmaPolicyType) },
{ "IsOnlineRequst", typeof(IsOnlineRequst) },
};
DataTable dt = new DataTable();
dt = cmd.ExecuteDataTable(enumList);
totalCount = (int)cmd.GetParameterValue("@totalCount");
return(dt);
}
