protected override GetSalesReturnListRD ProcessRequest(DTO.Base.APIRequest <GetSalesReturnListRP> pRequest)
{
var rd = new GetSalesReturnListRD();
var para = pRequest.Parameters;
var salesReturnBLL = new T_SalesReturnBLL(CurrentUserInfo);
var inoutService = new InoutService(CurrentUserInfo);
var tInoutDetailBll = new TInoutDetailBLL(CurrentUserInfo);
//查询参数
List <IWhereCondition> complexCondition = new List <IWhereCondition> {
};
complexCondition.Add(new EqualsCondition()
{
FieldName = "r.VipID", Value = CurrentUserInfo.UserID
});
//排序参数
List <OrderBy> lstOrder = new List <OrderBy> {
};
lstOrder.Add(new OrderBy()
{
FieldName = "r.CreateTime", Direction = OrderByDirections.Desc
});
var tempList = salesReturnBLL.PagedQuery(complexCondition.ToArray(), lstOrder.ToArray(), para.PageSize, para.PageIndex + 1);//没有当前用户，就传空
rd.TotalPageCount = tempList.PageCount;
rd.TotalCount = tempList.RowCount;
List <SalesReturnInfo> salesReturnList = new List <SalesReturnInfo> {
};
SalesReturnInfo salesReturnInfo = null;
SkuDetailInfo skuDetail = null;
foreach (var item in tempList.Entities)
{
salesReturnInfo = new SalesReturnInfo();
//根据订单ID获取订单明细[复用]
DataRow drItem = inoutService.GetOrderDetailByOrderId(item.OrderID).Tables[0].Select(" item_id= '" + item.ItemID + "'").FirstOrDefault();
//获取商品的图片[复用]
string itemImage = tInoutDetailBll.GetOrderDetailImageList("'" + item.ItemID + "'").Tables[0].Rows[0]["imageUrl"].ToString();
//获取订单详细列表中的商品规格[复用]
DataRow[] drSku = inoutService.GetInoutDetailGgByOrderId(item.OrderID).Tables[0].Select(" sku_id='" + item.SkuID + "'");
salesReturnInfo.SalesReturnID = item.SalesReturnID.ToString();
salesReturnInfo.SalesReturnNo = item.SalesReturnNo;
salesReturnInfo.ItemName = drItem["item_name"].ToString();
salesReturnInfo.SalesPrice = Convert.ToDecimal(drItem["enter_price"]);
salesReturnInfo.Qty = item.Qty;
salesReturnInfo.Status = item.Status;
salesReturnInfo.ImageUrl = ImagePathUtil.GetImagePathStr(itemImage, "240");
salesReturnInfo.ServicesType = item.ServicesType;
if (drSku.Count() > 0)
{
skuDetail = new SkuDetailInfo();
skuDetail.PropName1 = drSku[0]["prop_1_name"].ToString();
skuDetail.PropDetailName1 = drSku[0]["prop_1_detail_name"].ToString();
skuDetail.PropName2 = drSku[0]["prop_2_name"].ToString();
skuDetail.PropDetailName2 = drSku[0]["prop_2_detail_name"].ToString();
skuDetail.PropName3 = drSku[0]["prop_3_name"].ToString();
skuDetail.PropDetailName3 = drSku[0]["prop_3_detail_name"].ToString();
salesReturnInfo.SkuDetail = skuDetail;
}
salesReturnList.Add(salesReturnInfo);
}
rd.SalesReturnList = salesReturnList.ToArray();
rd.TotalCount = tempList.RowCount;
rd.TotalPageCount = tempList.PageCount;
return(rd);
}
protected override GetSalesReturnListRD ProcessRequest(DTO.Base.APIRequest <GetSalesReturnListRP> pRequest)
{
var rd = new GetSalesReturnListRD();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var salesReturnBLL = new T_SalesReturnBLL(loggingSessionInfo);
var T_InoutBLL = new T_InoutBLL(loggingSessionInfo);
var inoutService = new InoutService(loggingSessionInfo);
var tInoutDetailBll = new TInoutDetailBLL(loggingSessionInfo);
//查询参数
List <IWhereCondition> complexCondition = new List <IWhereCondition> {
};
complexCondition.Add(new EqualsCondition()
{
FieldName = "r.CustomerID", Value = loggingSessionInfo.ClientID
});
if (!string.IsNullOrEmpty(para.SalesReturnNo))
{
complexCondition.Add(new LikeCondition()
{
FieldName = "r.SalesReturnNo", Value = "%" + para.SalesReturnNo + "%"
});
}
if (para.DeliveryType > 0)
{
complexCondition.Add(new EqualsCondition()
{
FieldName = "r.DeliveryType", Value = para.DeliveryType
});
}
if (para.Status > 0 && para.Status < 8)
{
complexCondition.Add(new EqualsCondition()
{
FieldName = "r.Status", Value = para.Status
});
}
else if (para.Status == 8)//包含待退款和已退款
{
string[] statusArr = new string[] { "6", "7" };
complexCondition.Add(new InCondition <string>()
{
FieldName = "r.Status", Values = statusArr
});
}
if (!string.IsNullOrEmpty(para.paymentcenterId))
{
complexCondition.Add(new EqualsCondition()
{
FieldName = "t.paymentcenter_id", Value = para.paymentcenterId
});
}
if (!string.IsNullOrEmpty(para.payId))
{
complexCondition.Add(new EqualsCondition()
{
FieldName = "p.Payment_Type_Id", Value = para.payId
});
}
//门店过滤处理
//排序参数
List <OrderBy> lstOrder = new List <OrderBy> {
};
lstOrder.Add(new OrderBy()
{
FieldName = "r.CreateTime", Direction = OrderByDirections.Desc
});
var tempList = salesReturnBLL.PagedQuery(complexCondition.ToArray(), lstOrder.ToArray(), para.PageSize, para.PageIndex);
rd.TotalPageCount = tempList.PageCount;
rd.TotalCount = tempList.RowCount;
List <SalesReturnInfo> salesReturnList = new List <SalesReturnInfo> {
};
SalesReturnInfo salesReturnInfo = null;
//SkuDetailInfo skuDetail = null;
foreach (var item in tempList.Entities)
{
salesReturnInfo = new SalesReturnInfo();
//根据订单ID获取订单明细[复用]
DataRow drItem = inoutService.GetOrderDetailByOrderId(item.OrderID).Tables[0].Select(" item_id= '" + item.ItemID + "'").FirstOrDefault();
if (drItem != null)
{
//获取商品的图片[复用]
string itemImage = string.Empty;
DataSet ds = tInoutDetailBll.GetOrderDetailImageList("'" + item.ItemID + "'");
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
itemImage = ds.Tables[0].Rows[0]["imageUrl"].ToString();
}
//获取订单详细列表中的商品规格[复用]
//DataRow[] drSku = inoutService.GetInoutDetailGgByOrderId(item.OrderID).Tables[0].Select(" sku_id='" + item.SkuID + "'");
salesReturnInfo.SalesReturnID = item.SalesReturnID.ToString();
salesReturnInfo.SalesReturnNo = item.SalesReturnNo;
salesReturnInfo.ItemName = drItem["item_name"].ToString();
salesReturnInfo.SalesPrice = Convert.ToDecimal(drItem["enter_price"]);
salesReturnInfo.Qty = item.Qty;
salesReturnInfo.Status = item.Status;
if (!string.IsNullOrEmpty(itemImage))
{
salesReturnInfo.ImageUrl = ImagePathUtil.GetImagePathStr(itemImage, "240");
}
salesReturnInfo.VipName = item.VipName;
salesReturnInfo.DeliveryType = item.DeliveryType;
salesReturnInfo.CreateTime = item.CreateTime.Value.ToString("yyyy-MM-dd HH:mm");
//商户单号，支付方式
salesReturnInfo.paymentcenterId = item.paymentcenterId;
salesReturnInfo.paymentName = item.PayTypeName;
salesReturnInfo.ServicesType = item.ServicesType;
//if (drSku.Count() > 0)
//{
// skuDetail = new SkuDetailInfo();
// skuDetail.PropName1 = drSku[0]["prop_1_name"].ToString();
// skuDetail.PropDetailName1 = drSku[0]["prop_1_detail_name"].ToString();
// skuDetail.PropName2 = drSku[0]["prop_2_name"].ToString();
// skuDetail.PropDetailName2 = drSku[0]["prop_2_detail_name"].ToString();
// skuDetail.PropName3 = drSku[0]["prop_3_name"].ToString();
// skuDetail.PropDetailName3 = drSku[0]["prop_3_detail_name"].ToString();
// salesReturnInfo.SkuDetail = skuDetail;
//
//}
salesReturnList.Add(salesReturnInfo);
}
}
rd.SalesReturnList = salesReturnList.ToArray();
rd.TotalCount = tempList.RowCount;
rd.TotalPageCount = tempList.PageCount;
return(rd);
}
