/// <summary>
/// 获取订单列表。Add by Alex Tian 2014-04-16
/// </summary>
/// <param name="pIsIncludeOrderDetails">是否获取订单商品详细</param>
/// <param name="pOrderStatuses">订单状态</param>
/// <param name="pOrderID">订单ID</param>
/// <param name="pVIPID">会员ID</param>
/// <param name="pPageSize">每页记录数，默认15</param>
/// <param name="pPageIndex">当前页，默认为0</param>
/// <returns></returns>
public GetOrderListRD GetOrderList(bool pIsIncludeOrderDetails, int[] pOrderStatuses, string pOrderID,
int pPageSize, int pPageIndex)
{
GetOrderListRD RD = new GetOrderListRD();
DataSet ds = new DataSet();
List <T_InoutEntity> list = new List <T_InoutEntity> {
};
var Orderlist = new List <JIT.CPOS.DTO.Module.Order.Order.Response.OrderInfo> {
};
ds = _currentDAO.GetOrderList(pOrderStatuses, pOrderID, pPageSize, pPageIndex);
using (var rd = ds.Tables[0].CreateDataReader())
{
while (rd.Read())
{
T_InoutEntity m;
this._currentDAO.NewLoad(rd, out m);
list.Add(m);
}
}
if (pIsIncludeOrderDetails == false)
{
foreach (var item in list)
{
JIT.CPOS.DTO.Module.Order.Order.Response.OrderInfo orderinfo =
new DTO.Module.Order.Order.Response.OrderInfo();
orderinfo.OrderID = item.order_id;
orderinfo.OrderNO = item.order_no;
orderinfo.DeliveryTypeID = Convert.ToInt32(string.IsNullOrEmpty(item.Field8) ? "0" : item.Field8);
orderinfo.OrderDate = Convert.ToDateTime(item.create_time);
//下单时间，由于下单表中的OrderDate没有时分秒。所以取得时间为create_time
orderinfo.OrderStatusDesc = item.status_desc; //订单状态描述
orderinfo.OrderStatus = Convert.ToInt32(item.status); //订单状态
orderinfo.TotalQty = Convert.ToInt32(item.total_qty); //订单数量
orderinfo.TotalAmount = Convert.ToDecimal(item.actual_amount); //订单总金额之前用的是item.total_amount
orderinfo.OrderDetails = null;
Orderlist.Add(orderinfo);
}
RD.OrderList = Orderlist.ToArray();
}
if (pIsIncludeOrderDetails == true) //查询订单详细信息。
{
var ids = list.Select(t => t.order_id).ToArray();
var detailBLL = new T_Inout_DetailBLL(this.CurrentUserInfo as LoggingSessionInfo);
var detailEntitys = detailBLL.GetByIDS(ids);
foreach (var item in list)
{
JIT.CPOS.DTO.Module.Order.Order.Response.OrderInfo orderinfo =
new DTO.Module.Order.Order.Response.OrderInfo();
orderinfo.OrderID = item.order_id;
orderinfo.OrderNO = item.order_no;
orderinfo.DeliveryTypeID = Convert.ToInt32(string.IsNullOrEmpty(item.Field8) ? "0" : item.Field8);
orderinfo.OrderDate = Convert.ToDateTime(item.create_time);
//下单时间，由于下单表中的OrderDate没有时分秒。所以取得时间为create_time
orderinfo.OrderStatusDesc = item.status_desc; //订单状态描述
orderinfo.OrderStatus = Convert.ToInt32(item.status); //订单状态
orderinfo.TotalQty = Convert.ToInt32(item.total_qty); //订单数量
orderinfo.TotalAmount = Convert.ToDecimal(item.actual_amount); //订单总金额//订单总金额之前用的是item.total_amount
var templist = detailEntitys.Where(t => t.order_id == item.order_id).ToArray();
var tempDetailInfos = new List <JIT.CPOS.DTO.Module.Order.Order.Response.OrderDetailInfo> {
};
foreach (var it in templist)
{
var detailInfo = new JIT.CPOS.DTO.Module.Order.Order.Response.OrderDetailInfo();
detailInfo.ItemID = it.ItemID; //商品ID
detailInfo.ItemName = it.ItemName; //商品名称
detailInfo.SKUID = it.SKUID; //SKUID
detailInfo.Qty = it.Qty; //购买数量
detailInfo.SpecificationDesc = it.SpecificationDesc; //规格描述
detailInfo.SalesPrice = it.SalesPrice; //实际单价
detailInfo.ImageUrl = it.ImageUrl; //Url图片
#region 新增规格
var GGds = _currentDAO.GetInoutDetailGgByOrderId(pOrderID);
if (GGds != null && GGds.Tables.Count > 0)
{
detailInfo.GG =
GGds.Tables[0].AsEnumerable()
.Where(t => t["sku_id"].ToString() == it.SKUID.ToString())
.Select(t => new JIT.CPOS.DTO.Module.Order.Order.Response.GuiGeInfo
{
PropName1 = t["prop_1_name"].ToString(),
PropDetailName1 = t["prop_1_detail_name"].ToString(),
PropName2 = t["prop_2_name"].ToString(),
PropDetailName2 = t["prop_2_detail_name"].ToString(),
PropName3 = t["prop_3_name"].ToString(),
PropDetailName3 = t["prop_3_detail_name"].ToString(),
PropName4 = t["prop_4_name"].ToString(),
PropDetailName4 = t["prop_4_detail_name"].ToString(),
PropName5 = t["prop_5_name"].ToString(),
PropDetailName5 = t["prop_5_detail_name"].ToString()
}).FirstOrDefault();
}
#endregion
tempDetailInfos.Add(detailInfo);
}
orderinfo.OrderDetails = tempDetailInfos.ToArray();
Orderlist.Add(orderinfo);
}
RD.OrderList = Orderlist.ToArray();
}
return(RD);
}
/// <summary>
/// 获取订单状态 Add by Alex Tian 2014-04-16
/// </summary>
/// <returns></returns>
public GetOrdersRD GetOrder(string vipno, int PageIndex, int PageSize, string customer_id, int GroupingType, string ChannelId, string UserId, bool isShowUnitName = false)
{
var loggingSessionInfo = this.CurrentUserInfo as LoggingSessionInfo;
var unitbll = new UnitBLL(loggingSessionInfo);
GetOrdersRD rdata = new GetOrdersRD();
DataSet ds = null;
//switch (GroupingType)
//{
// case 1:
// ds = this._currentDAO.GetOrderByObligation(vipno, PageIndex, PageSize, customer_id); //查询订单状态为待付款
// break;
// case 2:
// ds = this._currentDAO.GetOrderByNodelivery(vipno, PageIndex, PageSize, customer_id); //查询订单状态为待收货/提货
// break;
// case 3:
// ds = this._currentDAO.GetOrderBydonedeal(vipno, PageIndex, PageSize, customer_id); //订单状态为已完成
// break;
// default:
// break;
//}
//如果是人人销售渠道取新的存储过程 add by donal 2014-9-26 17:41:10
if (ChannelId == "6")
{
ds = this._currentDAO.GetOrderByGroupingTypeEvery(UserId, PageIndex, PageSize, customer_id, GroupingType);
}
else
{
ds = this._currentDAO.GetOrderByGroupingType(vipno, PageIndex, PageSize, customer_id, GroupingType);
}
if (ds != null && ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
{
List <T_InoutEntity> list = new List <T_InoutEntity> {
};
int count = Convert.ToInt32(ds.Tables[1].Rows[0][0]);
if (count <= 0)
{
return(rdata);
}
using (var rd = ds.Tables[1].CreateDataReader())
{
while (rd.Read())
{
T_InoutEntity m;
this._currentDAO.NewLoad(rd, out m);
list.Add(m);
}
}
var ids = list.Select(t => t.order_id).ToArray();
var detailBLL = new T_Inout_DetailBLL(this.CurrentUserInfo as LoggingSessionInfo);
var detailEntitys = detailBLL.GetByIDS(ids);
var Orderlist = new List <JIT.CPOS.DTO.Module.VIP.Order.Response.OrderInfo> {
};
#region [ 组织orderInfo ]
foreach (var item in list)
{
JIT.CPOS.DTO.Module.VIP.Order.Response.OrderInfo orderinfo =
new DTO.Module.VIP.Order.Response.OrderInfo();
orderinfo.OrderID = item.order_id; //订单ID
orderinfo.OrderNO = item.order_no; //订单编码
orderinfo.DeliveryTypeID = Convert.ToInt32(string.IsNullOrEmpty(item.Field8) ? "0" : item.Field8);
//配送方式类别ID，1.送货上门。2.到店自取
orderinfo.purchase_unit_id = item.purchase_unit_id; //提货门店
orderinfo.OrderDate = item.create_time; //在订单表中的下单时间没有时分秒。所以取create_time
orderinfo.OrderStatusDesc = item.status_desc; //订单状态描述
orderinfo.OrderStatus = Convert.ToInt32(item.status); //订单状态
orderinfo.TotalQty = Convert.ToInt32(item.total_qty); //商品购买数量
if (string.IsNullOrEmpty(item.Field3))
{
item.Field3 = "0";
}
orderinfo.TotalAmount = Convert.ToDecimal(item.actual_amount) - Convert.ToDecimal(item.Field3); //总金额
orderinfo.PaymentTypeCode = item.Payment_Type_Code; //支付方式
orderinfo.ReturnCash = item.ReturnCash == null ? 0.00m : Convert.ToDecimal(item.ReturnCash); //佣金
orderinfo.IsEvaluation = item.IsEvaluation == null ? 0 : item.IsEvaluation.Value; //是否评论
orderinfo.IsPayed = item.Field1 == null ? "0" : item.Field1;
#region 根据OrderInfo组织detail
var templist = detailEntitys.Where(t => t.order_id == item.order_id).ToArray();
var tempDetailInfos = new List <JIT.CPOS.DTO.Module.VIP.Order.Response.OrderDetailInfo> {
};
foreach (var it in templist)
{
var detailInfo = new JIT.CPOS.DTO.Module.VIP.Order.Response.OrderDetailInfo();
detailInfo.ItemID = it.ItemID; //商品ID
detailInfo.ItemName = it.ItemName; //商品名称
detailInfo.SKUID = it.SKUID; //SKUID
detailInfo.Qty = it.Qty; //购买数量
detailInfo.SpecificationDesc = it.SpecificationDesc; //规格描述
detailInfo.SalesPrice = it.SalesPrice; //实际单价
detailInfo.ImageUrl = ImagePathUtil.GetImagePathStr(it.ImageUrl, "240"); //Url图片 update by Henry 2014-12-8
detailInfo.ReturnCash = it.ReturnCash;
detailInfo.isGB = it.isGB;
if (it.isGB == 0)
{
orderinfo.IsIncludeGB = 1;
}
#region 新增规格
var GGds = _currentDAO.GetInoutDetailGgByOrderId(orderinfo.OrderID);
if (GGds != null && GGds.Tables.Count > 0)
{
detailInfo.GG =
GGds.Tables[0].AsEnumerable()
.Where(t => t["sku_id"].ToString() == it.SKUID.ToString())
.Select(t => new JIT.CPOS.DTO.Module.VIP.Order.Response.GuiGeInfo
{
PropName1 = t["prop_1_name"].ToString(),
PropDetailName1 = t["prop_1_detail_name"].ToString(),
PropName2 = t["prop_2_name"].ToString(),
PropDetailName2 = t["prop_2_detail_name"].ToString(),
PropName3 = t["prop_3_name"].ToString(),
PropDetailName3 = t["prop_3_detail_name"].ToString(),
PropName4 = t["prop_4_name"].ToString(),
PropDetailName4 = t["prop_4_detail_name"].ToString(),
PropName5 = t["prop_5_name"].ToString(),
PropDetailName5 = t["prop_5_detail_name"].ToString()
}).FirstOrDefault();
}
#endregion
tempDetailInfos.Add(detailInfo);
}
#endregion
if (isShowUnitName)
{
var unit = unitbll.GetUnitDetail(item.sales_unit_id);
orderinfo.Unit = unit.unit_name;
}
orderinfo.OrderDetails = tempDetailInfos.ToArray();
Orderlist.Add(orderinfo);
}
#endregion
rdata.PageIndex = PageIndex;
rdata.TotalPageCount = count;
rdata.Orders = Orderlist.ToArray();
}
//获得不同分组下的订单数量
if (ds != null && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
var Grouplist = new List <JIT.CPOS.DTO.Module.VIP.Order.Response.GroupingOrderCount> {
};
if (ds.Tables[0].Rows.Count > 0)
{
//待付款
var grouporder1 = new JIT.CPOS.DTO.Module.VIP.Order.Response.GroupingOrderCount();
grouporder1.GroupingType = 1;
grouporder1.OrderCount = int.Parse(ds.Tables[0].Rows[0]["RowRnt1"].ToString());
Grouplist.Add(grouporder1);
if (ChannelId != "6")
{
//待服务
var grouporder10 = new JIT.CPOS.DTO.Module.VIP.Order.Response.GroupingOrderCount();
grouporder10.GroupingType = 10;
grouporder10.OrderCount = int.Parse(ds.Tables[0].Rows[0]["RowRnt10"].ToString());
Grouplist.Add(grouporder10);
//待提货
var grouporder11 = new JIT.CPOS.DTO.Module.VIP.Order.Response.GroupingOrderCount();
grouporder11.GroupingType = 11;
grouporder11.OrderCount = int.Parse(ds.Tables[0].Rows[0]["RowRnt11"].ToString());
Grouplist.Add(grouporder11);
//待发货
var grouporder12 = new JIT.CPOS.DTO.Module.VIP.Order.Response.GroupingOrderCount();
grouporder12.GroupingType = 12;
grouporder12.OrderCount = int.Parse(ds.Tables[0].Rows[0]["RowRnt12"].ToString());
Grouplist.Add(grouporder12);
//已服务
var grouporder13 = new JIT.CPOS.DTO.Module.VIP.Order.Response.GroupingOrderCount();
grouporder13.GroupingType = 13;
grouporder13.OrderCount = int.Parse(ds.Tables[0].Rows[0]["RowRnt13"].ToString());
Grouplist.Add(grouporder13);
//已提货
var grouporder14 = new JIT.CPOS.DTO.Module.VIP.Order.Response.GroupingOrderCount();
grouporder14.GroupingType = 14;
grouporder14.OrderCount = int.Parse(ds.Tables[0].Rows[0]["RowRnt14"].ToString());
Grouplist.Add(grouporder14);
//退换货
var grouporder5 = new JIT.CPOS.DTO.Module.VIP.Order.Response.GroupingOrderCount();
grouporder5.GroupingType = 5;
grouporder5.OrderCount = int.Parse(ds.Tables[0].Rows[0]["RowRnt5"].ToString());
Grouplist.Add(grouporder5);
}
//已发货
var grouporder2 = new JIT.CPOS.DTO.Module.VIP.Order.Response.GroupingOrderCount();
grouporder2.GroupingType = 2;
grouporder2.OrderCount = int.Parse(ds.Tables[0].Rows[0]["RowRnt2"].ToString());
Grouplist.Add(grouporder2);
//已完成
var grouporder3 = new JIT.CPOS.DTO.Module.VIP.Order.Response.GroupingOrderCount();
grouporder3.GroupingType = 3;
grouporder3.OrderCount = int.Parse(ds.Tables[0].Rows[0]["RowRnt3"].ToString());
Grouplist.Add(grouporder3);
//已付款且门店自提 Add by Henry 2014-12-18
if (ChannelId == "6")
{
var grouporder4 = new JIT.CPOS.DTO.Module.VIP.Order.Response.GroupingOrderCount();
grouporder4.GroupingType = 4;
grouporder4.OrderCount = int.Parse(ds.Tables[0].Rows[0]["RowRnt4"].ToString());
Grouplist.Add(grouporder4);
}
else
{
//未评论订单个数
var noEvaluationCount = new JIT.CPOS.DTO.Module.VIP.Order.Response.GroupingOrderCount();
noEvaluationCount.GroupingType = 6;
noEvaluationCount.OrderCount = int.Parse(ds.Tables[0].Rows[0]["NoEvaluationCount"].ToString());
Grouplist.Add(noEvaluationCount);
}
}
rdata.GroupingOrderCounts = Grouplist.ToArray();
}
return(rdata);
}
