public ActionResult AjaxRefundOrderQuery()
{
RMARefundQueryFilter filter = BuildQueryFilterEntity <RMARefundQueryFilter>();
filter.SellerSysNo = UserAuthHelper.GetCurrentUser().SellerSysNo;
var result = RMARefundService.RMARefundOrderQuery(filter);
return(AjaxGridJson(result));
}
public static QueryResult <RMARefundQueryResultInfo> QueryList(RMARefundQueryFilter filter)
{
QueryResult <RMARefundQueryResultInfo> result = new QueryResult <RMARefundQueryResultInfo>();
CustomDataCommand command = DataCommandManager.CreateCustomDataCommandFromConfig("QueryRMARefundList");
using (DynamicQuerySqlBuilder builder = new DynamicQuerySqlBuilder(command.CommandText, command, filter, !string.IsNullOrWhiteSpace(filter.SortFields) ? filter.SortFields : "SysNo DESC"))
{
//订单编号
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "so.SysNo", DbType.Int32
, "@SOSysNo", QueryConditionOperatorType.Equal, filter.SOSysNo);
//订单日期
DateTime orderDateFrom, orderDateTo;
if (!string.IsNullOrWhiteSpace(filter.CreateDateFrom) && DateTime.TryParse(filter.CreateDateFrom, out orderDateFrom))
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "R.CreateTime", DbType.DateTime
, "@CreateDateFrom", QueryConditionOperatorType.MoreThanOrEqual, orderDateFrom);
}
if (!string.IsNullOrWhiteSpace(filter.CreateDateTo) && DateTime.TryParse(filter.CreateDateTo, out orderDateTo))
{
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "R.CreateTime", DbType.DateTime
, "@CreateDateTo", QueryConditionOperatorType.LessThan, orderDateTo.Date.AddDays(1));
}
//顾客帐号
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "CustomerID", DbType.String
, "@CustomerID", QueryConditionOperatorType.Like, filter.CustomerID);
//退款单号
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "RefundID", DbType.String
, "@RefundID", QueryConditionOperatorType.Equal, filter.RefundID);
//退款单状态
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "r.Status", DbType.Int32
, "@Status", QueryConditionOperatorType.Equal, filter.Status);
//商家编号
builder.ConditionConstructor.AddCondition(QueryConditionRelationType.AND, "sc.MerchantSysNo", DbType.Int32
, "@MerchantSysNo", QueryConditionOperatorType.Equal, filter.SellerSysNo);
command.CommandText = builder.BuildQuerySql();
StringBuilder sb = new StringBuilder();
List <RMARefundQueryResultInfo> resultList = command.ExecuteEntityList <RMARefundQueryResultInfo>((s, t) =>
{
t.Status = EnumHelper.GetDescription((RMARefundStatus)Enum.Parse(typeof(RMARefundStatus), s["Status"].ToString()));
});
int totalCount = Convert.ToInt32(command.GetParameterValue("@TotalCount"));
result.PageInfo = new PageInfo()
{
PageIndex = filter.PageIndex,
PageSize = filter.PageSize,
TotalCount = totalCount,
SortBy = filter.SortFields
};
result.ResultList = resultList;
}
return(result);
}
public static QueryResult <RMARefundQueryResultInfo> RMARefundOrderQuery(RMARefundQueryFilter filter)
{
return(RMARefundDA.QueryList(filter));
}
