public void Query(int refundSysNo, int PageSize, int PageIndex, string SortField, EventHandler <RestClientEventArgs <dynamic> > callback)
{
RefundBalanceQueryFilter queryFilter = new RefundBalanceQueryFilter();
queryFilter.RefundSysNo = refundSysNo;
queryFilter.PagingInfo = new PagingInfo
{
PageSize = PageSize,
PageIndex = PageIndex,
SortBy = SortField
};
string relativeUrl = string.Format("/RMAService/RefundBalance/Query");
restClient.QueryDynamicData(relativeUrl, queryFilter, callback);
}
public QueryResult QueryRefundBalanceListByRefundSysNo(RefundBalanceQueryFilter queryFilter)
{
int _refundSysNo;
if (!int.TryParse(queryFilter.RefundSysNo.ToString(), out _refundSysNo))
{
throw new ArgumentException("Invalid refundSysNo");
}
int totalCount;
var dataTable = ObjectFactory <IRefundBalanceQueryDA> .Instance.Query(queryFilter, out totalCount);
return(new QueryResult()
{
Data = dataTable,
TotalCount = totalCount
});
}
public DataTable Query(RefundBalanceQueryFilter queryFilter, out int totalCount)
{
PagingInfoEntity pagingEntity = new PagingInfoEntity();
pagingEntity.SortField = queryFilter.PagingInfo.SortBy;
pagingEntity.MaximumRows = queryFilter.PagingInfo.PageSize;
pagingEntity.StartRowIndex = queryFilter.PagingInfo.PageIndex * queryFilter.PagingInfo.PageSize;
var cmd = DataCommandManager.CreateCustomDataCommandFromConfig("QueryRefundBalance");
using (var sqlBuilder = new DynamicQuerySqlBuilder(cmd.CommandText, cmd, null, "RB.[SysNo] DESC"))
{
sqlBuilder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "RB.[OrgRefundSysNo]", DbType.Int32, "@RefundSysNo", QueryConditionOperatorType.Equal, queryFilter.RefundSysNo);
cmd.CommandText = sqlBuilder.BuildQuerySql();
cmd.ReplaceParameterValue("#OrderType#", SOIncomeOrderType.RO_Balance);
EnumColumnList enumList = new EnumColumnList();
enumList.Add("Status", typeof(RefundBalanceStatus));
enumList.Add("AuditStatus", typeof(RefundStatus));
DataTable dt = cmd.ExecuteDataTable(enumList);
totalCount = Convert.ToInt32(cmd.GetParameterValue("@TotalCount"));
return(dt);
}
}
