/// <summary>
/// 插入一条订单状态跟踪信息
/// </summary>
/// <param name="orderStatusTracking">
/// 订单状态跟踪对象
/// </param>
/// <param name="transaction">
/// 数据库事务对象
/// </param>
/// <returns>
/// 新增的记录编码
/// </returns>
public int Insert(Order_Status_Tracking orderStatusTracking, SqlTransaction transaction)
{
var paras = new List<SqlParameter>
{
this.SqlServer.CreateSqlParameter(
"EmployeeID",
SqlDbType.Int,
orderStatusTracking.EmployeeID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"UserID",
SqlDbType.Int,
orderStatusTracking.UserID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"OrderID",
SqlDbType.Int,
orderStatusTracking.OrderID,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Remark",
SqlDbType.NVarChar,
orderStatusTracking.Remark,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ExpressNumber",
SqlDbType.NVarChar,
orderStatusTracking.ExpressNumber,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"MailNo",
SqlDbType.NVarChar,
orderStatusTracking.MailNo,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"Status",
SqlDbType.Int,
orderStatusTracking.Status,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"CreateTime",
SqlDbType.DateTime,
DateTime.Now,
ParameterDirection.Input),
this.SqlServer.CreateSqlParameter(
"ReferenceID",
SqlDbType.Int,
null,
ParameterDirection.Output)
};
this.SqlServer.ExecuteNonQuery(
CommandType.StoredProcedure,
"sp_Order_Status_Tracking_Insert",
paras,
transaction);
return (int)paras.Find(parameter => parameter.ParameterName == "ReferenceID").Value;
}
/// <summary>
/// 新增一条订单状态跟踪信息
/// </summary>
/// <param name="orderStatusTracking">
/// 订单状态跟踪对象
/// </param>
/// <param name="transaction">
/// 数据库事务对象
/// </param>
/// <returns>
/// 新增的记录编码
/// </returns>
public int Add(Order_Status_Tracking orderStatusTracking, SqlTransaction transaction)
{
return this.orderStatusTrackingDA.Insert(orderStatusTracking, transaction);
}
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);
}
}