/// <summary>
/// 查询订单详情
/// </summary>
/// <param name="orderID">
/// 订单编码
/// </param>
/// <returns>
/// The <see cref="ActionResult"/>.
/// </returns>
public ActionResult QueryOrderDetails(int orderID)
{
var orderDetailModel = new OrderDetailModel();
if (orderID > 0)
{
var order = new OrderService().QueryById(orderID);
orderDetailModel.OrderInfo = DataTransfer.Transfer<OrderModel>(order, typeof(Order));
var orderStatusTrackings = new OrderStatusTrackingService().QueryByOrderID(orderID);
#region 订单状态信息
var orderState = new OrderState { PaymentMethod = order.PaymentMethodID };
switch (order.Status)
{
case 0:
case 1:
orderState.Status = order.PaymentMethodID == 0 ? 1 : 0;
break;
case 2:
orderState.Status = 2;
break;
case 3:
orderState.Status = 4;
break;
case 100:
if (order.PaymentMethodID == 0)
{
orderState.Status = 0;
}
break;
}
if (orderStatusTrackings != null)
{
orderState.ProcessDatetimes = new List<string>();
foreach (var orderStatusTracking in orderStatusTrackings)
{
if (orderState.Status == 0 && orderStatusTracking.Status == 0)
{
orderState.ProcessDatetimes.Add(
orderStatusTracking.CreateTime.ToString("yyyy-MM-dd hh:mm:ss"));
}
if (order.PaymentMethodID == 0 && orderState.Status == 1
&& (orderStatusTracking.Status == 0 || orderStatusTracking.Status == 1))
{
orderState.ProcessDatetimes.Add(
orderStatusTracking.CreateTime.ToString("yyyy-MM-dd hh:mm:ss"));
}
if (orderState.Status == 2
&& (orderStatusTracking.Status == 0 || orderStatusTracking.Status == 1
|| orderStatusTracking.Status == 2))
{
orderState.ProcessDatetimes.Add(
orderStatusTracking.CreateTime.ToString("yyyy-MM-dd hh:mm:ss"));
}
if (orderState.Status == 4
&& (orderStatusTracking.Status == 0 || orderStatusTracking.Status == 1
|| orderStatusTracking.Status == 2 || orderStatusTracking.Status == 3))
{
orderState.ProcessDatetimes.Add(
orderStatusTracking.CreateTime.ToString("yyyy-MM-dd hh:mm:ss"));
}
}
}
orderDetailModel.CurrentOrderState = orderState;
#endregion
#region 订单发票信息
if (order.IsRequireInvoice)
{
orderDetailModel.InvoiceInfo =
DataTransfer.Transfer<OrderInvoiceModel>(
new OrderInvoiceService().SelectByOrderID(orderID),
typeof(Order_Invoice));
}
#endregion
#region 订单变化追踪记录
orderDetailModel.OrderTrackDetails = new List<OrderTrackDetailModel>();
if (orderStatusTrackings != null)
{
foreach (var orderStatusTracking in orderStatusTrackings)
{
System_Employee systemUser = null;
if (orderStatusTracking.EmployeeID > 0) systemUser = new SystemEmployeeService().QueryByID(orderStatusTracking.EmployeeID);
orderDetailModel.OrderTrackDetails.Add(
new OrderTrackDetailModel()
{
Operator =
orderStatusTracking.EmployeeID > 0
? systemUser==null?"客服":"客服:"+systemUser.Name
: (orderStatusTracking.UserID > 0) ? "客户" : "系统",
OperateSummary = orderStatusTracking.Remark,
OperateTime = orderStatusTracking.CreateTime
});
if (orderStatusTracking.Status == 2)
{
// 若产品已发货，则获取快递跟踪信息
var orderDeliverTrackDetail =
new OrderDeliveryTrackDetailService().QueryOrderDeliveryTrackDetailsByOrderID(orderID);
if (orderDeliverTrackDetail != null && !string.IsNullOrWhiteSpace(orderDeliverTrackDetail.Steps))
{
var details = orderDeliverTrackDetail.Steps.Split(';');
foreach (var orderDeliveryTrackingDetail in details)
{
if (!string.IsNullOrWhiteSpace(orderDeliveryTrackingDetail))
{
var di = orderDeliveryTrackingDetail.Split('|');
if (di.Length >= 2)
{
var tracking = new OrderTrackDetailModel { OperateSummary = di[1], Operator = "快递公司" };
DateTime dt;
if (DateTime.TryParse(di[0], out dt))
{
tracking.OperateTime = dt;
}
orderDetailModel.OrderTrackDetails.Add(tracking);
}
}
}
}
}
}
}
#region 老的方法
/*
string summary = string.Empty;
if (order.PaymentMethodID == 0)
{
summary = order.PaymentStatus == 0 ? "您提交了订单，等待付款。" : "您提交了订单，商品准备出库。";
}
else if (order.PaymentMethodID == 1)
{
summary = "您提交了订单，请等待确认。";
}
orderDetailModel.OrderDeliveryTrackDetails.Add(
new OrderDeliveryTrackDetailModel
{
OperateSummary = summary,
Operator = "客户",
OperateTime = order.CreateTime
});
if (order.Status == 6)
{
orderDetailModel.OrderDeliveryTrackDetails.Add(
new OrderDeliveryTrackDetailModel
{
OperateSummary = "订单已取消",
Operator = "客户",
OperateTime = order.CreateTime
});
}
else if (order.Status == 4 || order.Status == 8)
{
orderDetailModel.OrderDeliveryTrackDetails.Add(
new OrderDeliveryTrackDetailModel
{
OperateSummary = "订单已作废",
Operator = "系统",
OperateTime = order.CreateTime
});
}
else
{
if (orderStatusLogs != null)
{
foreach (var orderStatusLog in orderStatusLogs)
{
if (orderStatusLog.Status == 1)
{
summary = "您的订单已确认，准备出库";
}
if (orderStatusLog.Status == 2)
{
summary = "您的订单已出库"; // todo: 添加快递单号,快递公司名称
}
orderDetailModel.OrderDeliveryTrackDetails.Add(
new OrderDeliveryTrackDetailModel
{
OperateSummary = summary,
Operator = new SystemEmployeeService().QueryByID(orderStatusLog.EmployeeID).Name, // todo: 添加操作员工名称
OperateTime = order.CreateTime
});
}
}
}
// 若订单已发货或已签收，则有物流流转信息
if (order.Status == 3 || order.Status == 2)
{
var orderDeliverTrackDetails =
new OrderDeliveryTrackDetailService().QueryOrderDeliveryTrackDetailsByOrderID(orderID);
foreach (var orderDeliveryTrackingDetail in orderDeliverTrackDetails)
{
orderDetailModel.OrderDeliveryTrackDetails.Add(
DataTransfer.Transfer<OrderDeliveryTrackDetailModel>(
orderDeliveryTrackingDetail,
typeof(Order_Delivery_Tracking_Details)));
}
}
*/
#endregion
#endregion
#region 订单收货信息
orderDetailModel.ReceiverInfo =
DataTransfer.Transfer<UserReceiveAddressModel>(
new UserReceiveAddressService().QueryByID(order.RecieveAddressID),
typeof(User_RecieveAddress));
#endregion
#region 订单商品信息
orderDetailModel.OrderProducts = new List<OrderProductModel>();
var orderProducts = new OrderProductService().QueryByOrderId(orderID);
if (orderProducts != null)
{
foreach (var orderProduct in orderProducts)
{
orderDetailModel.OrderProducts.Add(
DataTransfer.Transfer<OrderProductModel>(orderProduct, typeof(Order_Product)));
}
}
#endregion
#region 订单支付信息
orderDetailModel.PaymentInfo = new PaymentInfoModel
{
OrderID = orderID,
PaymentMethodID = order.PaymentMethodID,
TotalMoney = order.TotalMoney,
DeliveryCost = order.DeliveryCost,
ActualPaid =
order.PaymentStatus == 1
? order.TotalMoney + order.DeliveryCost
: 0,
ActualMoney =
order.TotalMoney + order.DeliveryCost
};
#endregion
}
return this.View("Order/OrderDetail", orderDetailModel);
}
public ActionResult API()
{
string orderCode = Server.UrlDecode(Request.QueryString["orderid"]);//订单编号
string strMsg = "";
SqlTransaction transaction = null;
try
{
string username = Server.UrlDecode(Request.QueryString["username"]);//ERP昵称
string password = Server.UrlDecode(Request.QueryString["password"]);//ERP密码
string key = Server.UrlDecode(Request.QueryString["key"]);//公钥
string sign = Server.UrlDecode(Request.QueryString["sign"]);//检验码
string method = Server.UrlDecode(Request.QueryString["method"]);//调用接口
#region 访问日志
try
{
new OrderERPLogService().AddHwLog(new Hw_Log { Content = Request.Url.ToString(), Number = orderCode }, null);
LogUtils.Log(string.Format("成功写入ERP系统访问日志，订单编号：{0}，日志信息：{1}", orderCode, Request.Url.ToString()), "ERP订单回写", Category.Error);
}
catch (Exception exception)
{
LogUtils.Log(string.Format("写入ERP系统访问日志失败，订单编号：{0}，日志信息：{1},错误信息：{2}", orderCode, Request.Url.ToString(), exception.Message + "/" + exception.InnerException), "ERP订单回写", Category.Error);
}
#endregion
#region 基本参数验证
if (string.IsNullOrEmpty(username))
{
strMsg = SetMsg("0", "昵称不能为空", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
if (string.IsNullOrEmpty(orderCode))
{
strMsg = SetMsg("0", "订单不正确", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
if (username != "hongware")
{
strMsg = SetMsg("0", "昵称不正确", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
if (string.IsNullOrEmpty(password))
{
strMsg = SetMsg("0", "密码不能为空", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
if (password != "bir19ming19ham")
{
strMsg = SetMsg("0", "密码不正确", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
if (string.IsNullOrEmpty(key))
{
strMsg = SetMsg("0", "公钥不能为空", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
if (key != "g1w9j1r9w")
{
strMsg = SetMsg("0", "公钥不正确", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
if (string.IsNullOrEmpty(sign))
{
strMsg = SetMsg("0", "检验码不能为空", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
if (string.IsNullOrEmpty(orderCode))
{
strMsg = SetMsg("0", "订单编号不能为空", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
string sign_Md5 = Encrypt.HwErpMd5(username + password + orderCode + key);
if (sign != sign_Md5)
{
strMsg = SetMsg("0", "检验码不正确", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
if (string.IsNullOrEmpty(method))
{
strMsg = SetMsg("0", "调用方法名不能为空", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
method = method.ToLower();
#endregion
#region 订单当前状态
var orderService = new OrderService();
var orderTracking = new OrderStatusTrackingService();
var order = orderService.QueryByOrderCode(orderCode);
if (order == null || order.ID < 1)
{
strMsg = SetMsg("0", "未查到此订单号,请核实", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
int OrderID = order.ID;
int State = order.Status;
#endregion
if (method == "api.order.send")
{
#region 订单发货
if (State == 0)
{
strMsg = SetMsg("0", "订单还未确认", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
else if (State == 2)
{
strMsg = SetMsg("0", "订单已发货", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
else if (State == 3)
{
strMsg = SetMsg("0", "订单已签收", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
else if (State == 4 || State == 5 || State == 8)
{
strMsg = SetMsg("0", "订单已取消", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
string expressno = string.Empty;
expressno = Server.UrlDecode(Request.QueryString["expressno"]);//快递代码
string expressnum = Server.UrlDecode(Request.QueryString["expressnum"]);//快递单号
string deliverydate = Server.UrlDecode(Request.QueryString["deliverydate"]);//发货日期
#region 参数验证
if (string.IsNullOrEmpty(expressno))
{
strMsg = SetMsg("0", "快递代码不能为空", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
if (string.IsNullOrEmpty(expressnum))
{
strMsg = SetMsg("0", "快递单号不能为空", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
if (string.IsNullOrEmpty(deliverydate))
{
strMsg = SetMsg("0", "发货日期不能为空", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
#endregion
Config_Delivery_Corporation deliveryCorporation = null;
#region 更新订单发货状态
/*
订单发货：
* 1.更改订单状态，
* 2.更改订单跟踪状态
*/
try
{
var deliveryCorporations = new ConfigDeliveryCorporationService().QueryAllConfigDeliveryCorporations();
if (deliveryCorporations != null && deliveryCorporations.Count > 1)
{
deliveryCorporation =
deliveryCorporations.Find(dc => expressno.Equals(dc.Number, StringComparison.OrdinalIgnoreCase));
}
if (deliveryCorporation == null)
{
deliveryCorporation = new Config_Delivery_Corporation();
LogUtils.Log("没有获取到代号为:" + expressno.ToUpper() + "的配送公司", "API", Category.Warn);
}
var tracking = new Order_Status_Tracking();
tracking.MailNo = expressnum;
tracking.ExpressNumber = expressno.ToUpper();
tracking.OrderID = OrderID;
tracking.Status = 2;
tracking.EmployeeID = 0;
tracking.UserID = 0;
tracking.Remark = string.Format(
"订单已发货，配送单位：{0} {1}； 快递单号：{2}",
deliveryCorporation.Name,
deliveryCorporation.URL,
expressnum);
tracking.CreateTime = Convert.ToDateTime(deliverydate);
orderService.SqlServer.BeginTransaction();
transaction = orderService.SqlServer.Transaction;
orderTracking.Add(tracking, transaction);
order.Status = 2;
order.DeliveryCorporationID = deliveryCorporation.ID;
orderService.Edit(order, transaction);
transaction.Commit();
}
catch (Exception exception)
{
if (transaction != null)
{
transaction.Rollback();
}
LogUtils.Log(
string.Format(
"[Order_ERP]ERP回写发货订单时发生错误，订单编号:{0}，错误消息:{1}",
orderCode,
exception.Message + "/" + exception.InnerException),
"[Order_ERP]ERP订单发货回写官网",
Category.Error);
strMsg = SetMsg("0", "更新订单发货状态发生异常", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
finally
{
if (transaction != null && transaction.Connection != null
&& transaction.Connection.State != ConnectionState.Closed)
{
transaction.Connection.Close();
}
}
#endregion
#region 短信发送
try
{
var orderReceiver = new UserReceiveAddressService().QueryByID(order.UserID);
if (orderReceiver != null && orderReceiver.Mobile != null)
{
var moList = new List<string>();
moList.Add(orderReceiver.Mobile);
var sm = new ShortMessage
{
ReceiveMobiles = moList,
Content =
string.Format(
"亲爱的购酒网会员，您的订单（订单号：{0}）支付方式为：{1}，已经发货，配送公司:{2}， 单号：{3}。请注意保持手机畅通。",
orderCode,
order.PaymentMethodName,
deliveryCorporation.Name,
deliveryCorporation.Number)
};
sm.Send();
LogUtils.Log(
"用户:" + orderReceiver.Consignee + "电话：" + orderReceiver.Mobile + "成功发送短信",
"SendSms",
Category.Info,
Session.SessionID);
}
else
{
LogUtils.Log("[Order_ERP]由于没有获取到订单收货人或收货人的手机号不存在，因此订单（" + order.OrderCode + "）发货，未发送通知短信", "[Order_ERP]订单发货回写发送短信SendSms", Category.Error);
}
}
catch (Exception ex)
{
LogUtils.Log("[Order_ERP]ERP订单发货发送短信发生错误，错误消息:" + ex.Message + "/" + ex.InnerException, "[Order_ERP]订单发货回写发送短信SendSms", Category.Error);
}
#endregion
strMsg = SetMsg("1", "订单状态更新成功", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
#endregion
}
else if (method == "api.order.cancel")
{
#region 订单取
if (State == 0)
{
strMsg = SetMsg("0", "订单还未确认", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
else if (State == 2)
{
strMsg = SetMsg("0", "订单已发货", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
else if (State == 3)
{
strMsg = SetMsg("0", "订单已确认收货", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
else if (State == 4 || State == 5 || State == 8)
{
strMsg = SetMsg("0", "订单已取消", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
try
{
orderService.SetInvalidByERP(order.ID, "订单作废");
}
catch (Exception exception)
{
LogUtils.Log(
string.Format(
"[Order_ERP]ERP订单取消回写发生错误，订单号:{0},错误消息:{1}",
orderCode,
exception.Message + "/" + exception.InnerException),
"[Order_ERP]ERP订单取消回写",
Category.Error);
strMsg = SetMsg("0", "订单作废发生错误", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
strMsg = SetMsg("1", "订单作废成功", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
#endregion
}
strMsg = SetMsg("0", "调用方法名不正确", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
catch (Exception)
{
strMsg = SetMsg("0", "订单回写发生异常", orderCode);
//Response.Write(strMsg);
return this.Content(strMsg);
}
}
