public DataTable GetRmaPolicyLog(RmaPolicyLogQueryFilter filter, out int totalCount)
{
DataCommand cmd = DataCommandManager.GetDataCommand("GetRmaPolicyLog");
cmd.SetParameterValue("@RmaPolicySysNo", filter.RmaPolicySysNO);
cmd.SetParameterValue("@RmaPolicy", filter.RmaPolicy);
cmd.SetParameterValue("@UpdateDateTo", filter.UpdateDateTo);
cmd.SetParameterValue("@UpdateDateFrom", filter.UpdateDateFrom);
cmd.SetParameterValue("@EditUserName", filter.EidtUserName);
cmd.SetParameterValue("@pageIndex", filter.PagingInfo.PageIndex);
cmd.SetParameterValue("@pageSize", filter.PagingInfo.PageSize);
cmd.SetParameterValue("@sortField", filter.PagingInfo.SortBy);
EnumColumnList enumList = new EnumColumnList
{
{ "Status", typeof(RmaPolicyStatus) },
{ "Type", typeof(RmaPolicyType) },
{ "IsOnlineRequst", typeof(IsOnlineRequst) },
{ "OperationType", typeof(RmaLogActionType) },
};
DataTable dt = new DataTable();
dt = cmd.ExecuteDataTable(enumList);
totalCount = (int)cmd.GetParameterValue("@totalCount");
return(dt);
}
public QueryResult QueryRmaPolicyLog(RmaPolicyLogQueryFilter query)
{
int totalCount;
var data = ObjectFactory <IRmaPolicyLogQueryDA> .Instance.GetRmaPolicyLog(query, out totalCount);
var source = new QueryResult {
Data = data, TotalCount = totalCount
};
return(source);
}