/// <summary>
/// 根据订单ID获取订单明细和订单操作流水数据
/// </summary>
/// <param name="rParams"></param>
/// <returns></returns>
public string GetOrdersDetail(NameValueCollection rParams)
{
TInoutDetailEntity entity = new TInoutDetailEntity();
if (!string.IsNullOrEmpty(rParams["id"]))
{
entity.OrderID = rParams["id"].ToString();
DataSet ds = new DataSet();
ds = new TInoutDetailBLL(CurrentUserInfo).GetOrdersDetail(entity, rParams["isHotel"] == null ? "" : rParams["isHotel"]);
return(string.Format("{{\"orderDetail\":{0},\"orderStatus\":{1}}}", ds.Tables[0].ToJSON(), ds.Tables[1].ToJSON()));
}
else
{
return("{{\"orderDetail\":\"\",\"orderStatus\":\"\"}}");
}
}
protected override GetSalesReturnDetailRD ProcessRequest(DTO.Base.APIRequest <GetSalesReturnDetailRP> pRequest)
{
var rd = new GetSalesReturnDetailRD();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var salesReturnBLL = new T_SalesReturnBLL(loggingSessionInfo);
var historyBLL = new T_SalesReturnHistoryBLL(loggingSessionInfo);
var inoutService = new InoutService(loggingSessionInfo);
var tInoutDetailBll = new TInoutDetailBLL(loggingSessionInfo);
var inoutBLL = new T_InoutBLL(CurrentUserInfo);
var salesReturnEntity = salesReturnBLL.GetByID(para.SalesReturnID);
var PaymentTtpeBLL = new T_Payment_TypeBLL(loggingSessionInfo);
if (salesReturnEntity != null)
{
var orderInfo = inoutBLL.GetByID(salesReturnEntity.OrderID);
rd.SalesReturnID = salesReturnEntity.SalesReturnID.ToString();
rd.SalesReturnNo = salesReturnEntity.SalesReturnNo;
rd.OrderID = salesReturnEntity.OrderID;
rd.OrderNo = orderInfo.order_no;
rd.Status = salesReturnEntity.Status;
rd.DeliveryType = salesReturnEntity.DeliveryType;
rd.Reason = salesReturnEntity.Reason;
rd.Qty = salesReturnEntity.Qty;
rd.ActualQty = salesReturnEntity.ActualQty;
rd.Contacts = salesReturnEntity.Contacts;
rd.Phone = salesReturnEntity.Phone;
rd.Address = string.Empty;
if (orderInfo != null)
{
rd.Address = orderInfo.Field4;
}
rd.ServicesType = salesReturnEntity.ServicesType;
//根据订单ID获取订单明细[复用]
DataRow drItem = inoutService.GetOrderDetailByOrderId(salesReturnEntity.OrderID).Tables[0].Select(" item_id= '" + salesReturnEntity.ItemID + "'").FirstOrDefault();
//获取商品的图片[复用]
//string itemImage = tInoutDetailBll.GetOrderDetailImageList("'" + salesReturnEntity.ItemID + "'").Tables[0].Rows[0]["imageUrl"].ToString();
string itemImage = string.Empty;
DataSet ds = tInoutDetailBll.GetOrderDetailImageList("'" + salesReturnEntity.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(salesReturnEntity.OrderID).Tables[0].Select(" sku_id='" + salesReturnEntity.SkuID + "'");
//订单的商品信息
var orderDetail = new OrderInfoDetail();
orderDetail.ItemName = drItem["item_name"].ToString();
orderDetail.SalesPrice = Convert.ToDecimal(drItem["enter_price"]);
orderDetail.Qty = Convert.ToInt32(drItem["enter_qty"]);
if (!string.IsNullOrEmpty(itemImage))
{
orderDetail.ImageUrl = ImagePathUtil.GetImagePathStr(itemImage, "240");
}
orderDetail.PayTypeName = salesReturnEntity.PayTypeName;
//支付方式名称
var OrderData = inoutBLL.GetByID(salesReturnEntity.OrderID);
string m_PayTypeName = "";
if (OrderData != null)
{
var PayTypeData = PaymentTtpeBLL.GetByID(OrderData.pay_id);
if (PayTypeData != null)
{
m_PayTypeName = PayTypeData.Payment_Type_Name;
}
}
orderDetail.PayTypeName = m_PayTypeName;
orderDetail.RefundAmount = salesReturnEntity.RefundAmount == null ? 0 : salesReturnEntity.RefundAmount.Value;
orderDetail.ConfirmAmount = salesReturnEntity.ConfirmAmount == null ? 0 : salesReturnEntity.ConfirmAmount.Value;
rd.OrderDetail = orderDetail;
//订单的商品规格
if (drSku.Count() > 0)
{
SkuDetailInfo 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();
rd.OrderDetail.SkuDetail = skuDetail;
}
var history = historyBLL.QueryByEntity(new T_SalesReturnHistoryEntity()
{
SalesReturnID = salesReturnEntity.SalesReturnID
}, new[] { new OrderBy {
FieldName = "CreateTime", Direction = OrderByDirections.Desc
} });
rd.HistoryList = history.Select(t => new HistoryInfo()
{
HistoryID = t.HistoryID.ToString(), OperationDesc = t.OperationDesc, HisRemark = t.HisRemark, OperatorName = t.OperatorName, CreateTime = t.CreateTime.Value.ToString("yyyy-MM-dd HH:mm")
}).ToArray();
}
return(rd);
}
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 GetRefundOrderDetailRD ProcessRequest(DTO.Base.APIRequest <GetRefundOrderDetailRP> pRequest)
{
var rd = new GetRefundOrderDetailRD();
var para = pRequest.Parameters;
var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo;
var refundOrderBLL = new T_RefundOrderBLL(loggingSessionInfo);
var inoutService = new InoutService(loggingSessionInfo);
var tInoutDetailBll = new TInoutDetailBLL(loggingSessionInfo);
var t_InoutBLL = new T_InoutBLL(loggingSessionInfo);
var PaymentTtpeBLL = new T_Payment_TypeBLL(loggingSessionInfo);
var refundEntity = refundOrderBLL.GetByID(para.RefundID);
if (refundEntity != null)
{
rd.RefundID = refundEntity.RefundID;
rd.RefundNo = refundEntity.RefundNo;
rd.Status = refundEntity.Status;
rd.OrderNo = refundEntity.OrderNo;
rd.Contacts = refundEntity.Contacts;
rd.Phone = refundEntity.Phone;
rd.ConfirmAmount = refundEntity.ConfirmAmount;
rd.ActualRefundAmount = refundEntity.ActualRefundAmount;
rd.Points = refundEntity.Points == null ? 0 : refundEntity.Points;
rd.PointsAmount = refundEntity.PointsAmount == null ? 0 : refundEntity.PointsAmount;
rd.ReturnAmount = refundEntity.ReturnAmount == null ? 0 : refundEntity.RefundAmount;
rd.Amount = refundEntity.Amount == null ? 0 : refundEntity.Amount;
//支付方式名称
var OrderData = t_InoutBLL.GetByID(refundEntity.OrderID);
string m_PayTypeName = "";
if (OrderData != null)
{
var PayTypeData = PaymentTtpeBLL.GetByID(OrderData.pay_id);
if (PayTypeData != null)
{
m_PayTypeName = PayTypeData.Payment_Type_Name;
}
}
rd.PayTypeName = m_PayTypeName;
rd.PayOrderID = refundEntity.PayOrderID;
rd.OrderID = refundEntity.OrderID;
rd.ItemID = refundEntity.ItemID;
if (!string.IsNullOrEmpty(refundEntity.ItemID)) //取消订单时，直接跳转到订单详情
{
//根据订单ID获取订单明细[复用]
DataRow drItem = inoutService.GetOrderDetailByOrderId(refundEntity.OrderID).Tables[0].Select(" item_id= '" + refundEntity.ItemID + "'").FirstOrDefault();
//获取商品的图片[复用]
string itemImage = string.Empty;
DataSet ds = tInoutDetailBll.GetOrderDetailImageList("'" + refundEntity.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(refundEntity.OrderID).Tables[0].Select(" sku_id='" + refundEntity.SkuID + "'");
//订单的商品信息
var orderDetail = new OrderInfoDetail();
orderDetail.ItemName = drItem["item_name"].ToString();
orderDetail.SalesPrice = Convert.ToDecimal(drItem["enter_price"]);
orderDetail.Qty = Convert.ToInt32(drItem["enter_qty"]);
if (!string.IsNullOrEmpty(itemImage))
{
orderDetail.ImageUrl = ImagePathUtil.GetImagePathStr(itemImage, "240");
}
rd.OrderDetail = orderDetail;
//订单的商品规格
if (drSku.Count() > 0)
{
SkuDetailInfo 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();
rd.OrderDetail.SkuDetail = skuDetail;
}
}
}
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);
}
protected override GetOrderDetailRD ProcessRequest(DTO.Base.APIRequest <GetOrderDetailRP> pRequest)
{
GetOrderDetailRD rd = new GetOrderDetailRD();
string orderId = pRequest.Parameters.OrderId;
rd.OrderListInfo = new OrderListInfo();
#region 获取订单列表
T_InoutBLL orderBll = new T_InoutBLL(this.CurrentUserInfo);
var orderList = orderBll.QueryByEntity(new T_InoutEntity()
{
order_id = orderId
}, null);
#endregion
#region 获取会员信息
string vipNo = orderList[0].vip_no;
VipBLL vipBll = new VipBLL(this.CurrentUserInfo);
var vipList = vipBll.QueryByEntity(new VipEntity()
{
VIPID = vipNo
}, null);
#endregion
#region 获取配方式
//Bear 20160928 注释 更具商品信息获取对应配送
string deliveryId = orderList[0].Field8;
DeliveryBLL deliverBll = new DeliveryBLL(this.CurrentUserInfo);
var deliverList = deliverBll.QueryByEntity(new DeliveryEntity()
{
DeliveryId = deliveryId
}, null);
#endregion
#region 获取门店信息
string storeId = orderList[0].sales_unit_id;
if (!string.IsNullOrEmpty(orderList[0].purchase_unit_id))//如果有发货门店，则显示发货门店信息
{
storeId = orderList[0].purchase_unit_id;
}
TInoutBLL tInoutBll = new TInoutBLL(this.CurrentUserInfo);
//string storeName = tInoutBll.GetStoreName(storeId);
DataSet storeDs = tInoutBll.GetStoreInfo(storeId);
rd.OrderListInfo.StoreID = storeId;
#endregion
//配送商
string carrierId = orderList[0].carrier_id;
//DataSet carrierDs = tInoutBll.GetStoreInfo(carrierId);
//if (carrierDs.Tables[0].Rows.Count > 0)
//{
// rd.OrderListInfo.CarrierID = carrierId;
// rd.OrderListInfo.CarrierName = carrierDs.Tables[0].Rows[0]["unit_name"].ToString();
//}
if (!string.IsNullOrEmpty(carrierId))
{
//配送方式 1.送货到家;2.到店提货
if (deliveryId == "1")
{
var logisticsCompanyBLL = new T_LogisticsCompanyBLL(this.CurrentUserInfo);
Guid m_carrierId = Guid.Parse(carrierId);
var logCompInfo = logisticsCompanyBLL.GetByID(m_carrierId);
if (logCompInfo != null)
{
rd.OrderListInfo.CarrierID = carrierId;
rd.OrderListInfo.CarrierName = logCompInfo.LogisticsName;
}
}
else if (deliveryId == "2")
{
var unitBLL = new t_unitBLL(this.CurrentUserInfo);
var unitInfo = unitBLL.GetByID(carrierId);
if (unitInfo != null)
{
rd.OrderListInfo.CarrierID = carrierId;
rd.OrderListInfo.CarrierName = unitInfo.unit_name;
}
}
else if (deliveryId == "4")
{
var unitBLL = new t_unitBLL(this.CurrentUserInfo);
var unitInfo = unitBLL.GetByID(carrierId);
if (unitInfo != null)
{
rd.OrderListInfo.CarrierID = carrierId;
rd.OrderListInfo.CarrierName = unitInfo.unit_name;
}
}
}
rd.OrderListInfo.CourierNumber = orderList[0].Field2; //配送单号
rd.OrderListInfo.Invoice = orderList[0].Field19 == null ? "" : orderList[0].Field19; //发票信息
if (vipList.Count() > 0)
{
rd.OrderListInfo.VipID = vipList[0].VIPID;
rd.OrderListInfo.Phone = vipList[0].Phone;
rd.OrderListInfo.UserName = vipList[0].VipName;
rd.OrderListInfo.VipRealName = vipList[0].VipRealName;
rd.OrderListInfo.VipLevelDesc = vipList[0].VipLevelDesc;
rd.OrderListInfo.VipCode = vipList[0].VipCode;
rd.OrderListInfo.Email = vipList[0].Email;
rd.OrderListInfo.VipLevel = Convert.ToInt32(vipList[0].VipLevel);
}
if (storeDs.Tables[0].Rows.Count > 0)
{
rd.OrderListInfo.StoreName = storeDs.Tables[0].Rows[0]["unit_name"].ToString();
rd.OrderListInfo.StoreAddress = storeDs.Tables[0].Rows[0]["unit_address"].ToString();
rd.OrderListInfo.StoreTel = storeDs.Tables[0].Rows[0]["unit_tel"].ToString();
}
if (orderList.Count() > 0)
{
rd.OrderListInfo.discount_rate = orderList[0].discount_rate ?? 100;//订单折扣
rd.OrderListInfo.OrderID = orderList[0].order_id;
rd.OrderListInfo.OrderCode = orderList[0].order_no;
rd.OrderListInfo.OrderDate = orderList[0].order_date;
rd.OrderListInfo.ReceiverName = orderList[0].Field14; //收件人
rd.OrderListInfo.TotalQty = Convert.ToDecimal(orderList[0].total_qty);
string TotalAmount = String.Format("{0:F}", orderList[0].total_amount ?? 0);
rd.OrderListInfo.TotalAmount = TotalAmount;
rd.OrderListInfo.Total_Retail = Convert.ToDecimal(orderList[0].total_retail);
rd.OrderListInfo.Remark = orderList[0].remark;
rd.OrderListInfo.Status = orderList[0].status;
rd.OrderListInfo.OrderStatus = int.Parse(orderList[0].Field7);
rd.OrderListInfo.StatusDesc = orderList[0].status_desc;
rd.OrderListInfo.DeliveryAddress = orderList[0].Field4;
rd.OrderListInfo.DeliveryTime = orderList[0].Field9;
rd.OrderListInfo.ClinchTime = orderList[0].create_time;
rd.OrderListInfo.ReceiptTime = orderList[0].accpect_time;
rd.OrderListInfo.CouponsPrompt = orderList[0].Field16;
rd.OrderListInfo.DeliveryID = orderList[0].Field8;
rd.OrderListInfo.IsPayment = orderList[0].Field1;
rd.OrderListInfo.ReceivePoints = orderList[0].receive_points;
rd.OrderListInfo.PaymentTime = orderList[0].Field1 == "1" ? orderList[0].complete_date : null;
rd.OrderListInfo.OrderReasonTypeId = orderList[0].order_reason_id;
rd.OrderListInfo.ActualDecimal = orderList[0].actual_amount ?? 0;
rd.OrderListInfo.PaymentTypeCode = orderList[0].Payment_Type_Code;
rd.OrderListInfo.PaymentTypeName = orderList[0].Payment_Type_Name;
rd.OrderListInfo.ReserveTime = orderList[0].reserveDay + " " + orderList[0].reserveQuantum;
var deliveryBll = new TOrderCustomerDeliveryStrategyMappingBLL(this.CurrentUserInfo);
rd.OrderListInfo.DeliveryAmount = deliveryBll.GetDeliverAmount(orderId); //配送费 add by henry***
if (!string.IsNullOrEmpty(orderList[0].Field15) && orderList[0].Field15 != "0") //是否是团购商品 add by Henry 2014-12-22
{
rd.OrderListInfo.IsEvent = 1; //团购商品
}
else
{
rd.OrderListInfo.IsEvent = 0; //普通商品
}
#region update by changjian.tian
rd.OrderListInfo.Mobile = orderList[0].Field6; //配送联系电话
rd.OrderListInfo.DeliveryRemark = orderList[0].remark;
rd.OrderListInfo.IsEvaluation = orderList[0].IsEvaluation == null ? 0 : orderList[0].IsEvaluation.Value;//评论
#endregion
}
if (deliverList.Count() > 0)
{
rd.OrderListInfo.DeliveryName = deliverList[0].DeliveryName;
}
T_Inout_DetailBLL orderDetailBll = new T_Inout_DetailBLL(this.CurrentUserInfo);
//退换货Bll实例化
T_SalesReturnBLL salesReturnBll = new T_SalesReturnBLL(this.CurrentUserInfo);
var orderDetailList = orderDetailBll.QueryByEntity(new T_Inout_DetailEntity()
{
order_id = orderId
}, null);
var inoutService = new InoutService(this.CurrentUserInfo);
#region 根据订单ID获取订单明细
var ds = inoutService.GetOrderDetailByOrderId(orderId);
#endregion
#region 获取订单详细列表中的商品规格
var ggDs = inoutService.GetInoutDetailGgByOrderId(orderId);
#endregion
if (ds.Tables[0].Rows.Count > 0)
{
string ItemIdList =
ds.Tables[0].AsEnumerable().Aggregate("", (x, j) =>
{
x += string.Format("'{0}',", j["item_id"].ToString());
return(x);
}).Trim(',');
TInoutDetailBLL tInoutDetailBll = new TInoutDetailBLL(this.CurrentUserInfo);
//获取商品的图片
DataSet imageDs = tInoutDetailBll.GetOrderDetailImageList(ItemIdList);
var tmp = ds.Tables[0].AsEnumerable().Select(t => new OrderDetailEntity()
{
ItemID = t["item_id"].ToString(),
ItemName = t["item_name"].ToString(),
SkuID = t["sku_id"].ToString(),
SalesReturnFlag = salesReturnBll.CheckSalesReturn(orderId, t["sku_id"].ToString()),//是否可申请退换货
//GG = t["prop_1_detail_name"].ToString()+t["prop_2_detail_name"].ToString()+t["prop_3_detail_name"].ToString()
//+t["prop_4_detail_name"].ToString()+t["prop_5_detail_name"].ToString(),
Field9 = t["Field9"].ToString(),
isGB = Convert.ToInt32(t["isGB"]),
GG =
ggDs.Tables[0].AsEnumerable()
.Where(tt => tt["sku_id"].ToString() == t["sku_id"].ToString())
.Select(tt => new GuiGeInfo
{
PropName1 = tt["prop_1_name"].ToString(),
PropDetailName1 = tt["prop_1_detail_name"].ToString(),
PropName2 = tt["prop_2_name"].ToString(),
PropDetailName2 = tt["prop_2_detail_name"].ToString(),
PropName3 = tt["prop_3_name"].ToString(),
PropDetailName3 = tt["prop_3_detail_name"].ToString(),
PropName4 = tt["prop_4_name"].ToString(),
PropDetailName4 = tt["prop_4_detail_name"].ToString(),
PropName5 = tt["prop_5_name"].ToString(),
PropDetailName5 = tt["prop_5_detail_name"].ToString()
}).FirstOrDefault(),
SalesPrice = Convert.ToDecimal(t["enter_price"]),
//DiscountRate = Convert.ToDecimal(t["discount_rate"]),
DiscountRate = Convert.ToDecimal(t["order_discount_rate"]),
ItemCategoryName = t["itemCategoryName"].ToString(),
BeginDate = t["Field1"].ToString(),
EndDate = t["Field2"].ToString(),
DayCount = Convert.ToInt32(t["DayCount"]),
Qty = Convert.ToDecimal(t["enter_qty"]),
ImageInfo =
imageDs.Tables[0].AsEnumerable()
.Where(c => c["ObjectId"].ToString() == t["item_id"].ToString())
.OrderBy(c => c["displayIndex"])
.Select(c => new OrderDetailImage
{
ImageID = c["imageId"].ToString(),
ImageUrl = ImagePathUtil.GetImagePathStr(c["imageUrl"].ToString(), "240")
}).ToArray(),
IfService = Convert.ToInt32(t["IfService"])
});
int tempCount = 0;
foreach (var i in tmp)
{
if (i.IfService == 0)
{
tempCount++;
}
}
if (tempCount == 0)
{
rd.OrderListInfo.IsAllService = 3; // 3-全部为虚拟商品
}
else if (tempCount == tmp.Count())
{
rd.OrderListInfo.IsAllService = 1; // 1-全部为实物商品
}
else
{
rd.OrderListInfo.IsAllService = 2; // 2-包含实物商品和虚拟商品
}
#region 根据商品获取配送方式
var deliveryIds = new List <int?>();
if (rd.OrderListInfo.IsAllService == 3)
{
deliveryIds.Add(1);
deliveryIds.Add(2);
deliveryIds.Add(4);
rd.OrderListInfo.CanUseDeliveryIDs = deliveryIds;
}
else
{
T_Item_Delivery_MappingBLL mappingBll = new T_Item_Delivery_MappingBLL(this.CurrentUserInfo);
var complexCondition = new List <IWhereCondition> {
};
var itemIdArray = ItemIdList.Replace("'", "").Split(',');
complexCondition.Add(new InCondition <string>()
{
FieldName = "Item_Id", Values = itemIdArray
});
var itemDeliveryList = mappingBll.Query(complexCondition.ToArray(), null);
bool needAddDelivery4 = false;
bool needAddDelivery2 = false;
if (itemDeliveryList.ToList().Find(d => d.DeliveryId == 4) != null)
{
needAddDelivery4 = true;
}
else
{
if (itemDeliveryList.ToList().Find(d => d.DeliveryId == 2) != null)
{
needAddDelivery2 = true;
}
}
var itemDeliveryGroupList = itemDeliveryList.GroupBy(d => d.Item_Id);
var index = 0;
foreach (var info in itemDeliveryGroupList)
{
var tmpList = info.ToList <T_Item_Delivery_MappingEntity>(); //分组后的集合
if (index == 0)
{
deliveryIds.AddRange(tmpList.Select(d => d.DeliveryId));
index++;
continue;
}
deliveryIds = deliveryIds.Intersect(tmpList.Select(d => d.DeliveryId)).ToList();
if (deliveryIds.Count <= 0)
{
break; // 后面的不用求了
}
index++;
}
if (!deliveryIds.Contains(4) && needAddDelivery4)
{
deliveryIds.Add(4);
}
if (!deliveryIds.Contains(2) && needAddDelivery2)
{
deliveryIds.Add(2);
}
rd.OrderListInfo.CanUseDeliveryIDs = deliveryIds.OrderBy(t => t.Value).ToList();
}
#endregion
rd.OrderListInfo.OrderDetailInfo = tmp.ToArray();
}
var vipIntegralDetailBll = new VipIntegralDetailBLL(this.CurrentUserInfo);
// var integral = vipIntegralDetailBll.GetVipIntegralByOrder(orderId, pRequest.UserID);
//使用积分
rd.OrderListInfo.OrderIntegral = Math.Abs(vipIntegralDetailBll.GetVipIntegralByOrder(orderId, vipNo));
//积分抵扣金额 add by Henry 2014-10-8
//decimal integralAmountPre = vipBll.GetIntegralAmountPre(this.CurrentUserInfo.ClientID);//获取积分金额比例
//rd.OrderListInfo.UseIntegralToAmount =rd.OrderListInfo.OrderIntegral*(integralAmountPre>0?integralAmountPre:0.01M);
rd.OrderListInfo.UseIntegralToAmount = vipBll.GetAmountByIntegralPer(CurrentUserInfo.ClientID, rd.OrderListInfo.OrderIntegral);
var couponUseBll = new CouponUseBLL(this.CurrentUserInfo);
var couponParValue = couponUseBll.GetCouponParValue(orderId);
rd.OrderListInfo.CouponAmount = couponParValue;
var vipAmountDetailBll = new VipAmountDetailBLL(this.CurrentUserInfo);
//使用的账户余额
rd.OrderListInfo.VipEndAmount = Math.Abs(vipAmountDetailBll.GetVipAmountByOrderId(orderId, vipNo, 1));
//使用余额，将余额从实付款中分开
if (rd.OrderListInfo.VipEndAmount != 0)
{
rd.OrderListInfo.ActualDecimal = rd.OrderListInfo.ActualDecimal - rd.OrderListInfo.VipEndAmount;
}
//使用的返现金额
rd.OrderListInfo.ReturnAmount = Math.Abs(vipAmountDetailBll.GetVipAmountByOrderId(orderId, vipNo, 13));
//使用阿拉币和阿拉币抵扣 add by Henry 2014-10-13
if (pRequest.ChannelId == "4")//阿拉丁APP调用
{
decimal aldAmount = Math.Abs(vipAmountDetailBll.GetVipAmountByOrderId(orderId, vipNo, 11));
rd.OrderListInfo.ALDAmount = aldAmount;
rd.OrderListInfo.ALDAmountMoney = aldAmount * 0.01M;
}
#region 获取订单积分，优惠券金额，使用余额
//var vipIntegralDetailBll = new VipIntegralDetailBLL(this.CurrentUserInfo);
//var vipIntegralList = vipIntegralDetailBll.QueryByEntity(new VipIntegralDetailEntity()
//{
// VIPID = pRequest.UserID,
// ObjectId = orderId
//}, null);
//if (vipIntegralList != null && vipIntegralList.Length > 0)
//{
// rd.OrderListInfo.OrderIntegral = Math.Abs(vipIntegralList[0].Integral??0);
//}
//var tOrderCouponMappingBll = new TOrderCouponMappingBLL(this.CurrentUserInfo);
//var tOrderCouponMappingList = tOrderCouponMappingBll.QueryByEntity(new TOrderCouponMappingEntity()
//{
// OrderId = orderId
//}, null);
//if (tOrderCouponMappingList != null && tOrderCouponMappingList.Length > 0)
//{
// var couponId = tOrderCouponMappingList[0].CouponId;
// var couponBll = new CouponBLL(this.CurrentUserInfo);
// var couponEntity = couponBll.GetByID(couponId);
// if (couponEntity != null)
// {
// var couponTypeId = couponEntity.CouponTypeID;
// var couponTypeBll = new CouponTypeBLL(this.CurrentUserInfo);
// var couponTypeEntity = couponTypeBll.GetByID(couponTypeId);
// if (couponTypeEntity != null)
// {
// rd.OrderListInfo.CouponAmount = couponTypeEntity.ParValue ?? 0;
// }
// }
//}
//var vipAmountDetailBll = new VipAmountDetailBLL(this.CurrentUserInfo);
//var vipAmountDetailList = vipAmountDetailBll.QueryByEntity(new VipAmountDetailEntity()
//{
// VipId = pRequest.UserID,
// ObjectId = orderId
//}, null);
//if (vipAmountDetailList != null && vipAmountDetailList.Length > 0)
//{
// rd.OrderListInfo.VipEndAmount = Math.Abs(vipAmountDetailList[0].Amount ?? 0);
//}
#endregion
return(rd);
}
