/// <summary>
/// 映射数据
/// </summary>
/// <param name="taobaoOrderModel"></param>
/// <param name="logisticsInterface"></param>
/// <returns></returns>
private T_MySql_Order CreateMap(TaobaoOrderModel taobaoOrderModel)
{
try
{
var msgContent = taobaoOrderModel.ToJson();
var mySqlOrder = new T_MySql_Order();
mySqlOrder.OUTSYS_BILL_CODE = string.IsNullOrEmpty(taobaoOrderModel.mailNo) ? " " : taobaoOrderModel.mailNo;
mySqlOrder.OUTSYS_ORDER_NO = string.IsNullOrEmpty(taobaoOrderModel.txLogisticID) ? " " : taobaoOrderModel.txLogisticID;
mySqlOrder.ORDER_SOURCE = "TAOBAO";
mySqlOrder.MSG_TYPE = "JSON";
//mySqlOrder.CREATE_BY = "";
mySqlOrder.MSG_CONTENT = string.IsNullOrEmpty(msgContent) ? "" : msgContent;
mySqlOrder.IS_SYNC_SUCCESS = 0;
mySqlOrder.CREATE_TIME = DateTime.Now;
mySqlOrder.CREATE_BY = mySqlOrder.ORDER_SOURCE;
mySqlOrder.C1 = "";
mySqlOrder.C2 = "";
mySqlOrder.C3 = "";
mySqlOrder.REMARK = "";
return(mySqlOrder);
}
catch (Exception e)
{
var message = new StringBuilder();
message.Append("TAOBAO订单映射过程发生错误：" + taobaoOrderModel.ToJson());
message.Append(e.Message + e.StackTrace);
message.ToString().WriteToLog(LogerType.Error);
return(null);
}
}
/// <summary>
/// 映射数据
/// </summary>
/// <param name="taobaoOrderModel"></param>
/// <param name="logisticsInterface"></param>
/// <returns></returns>
private T_MySql_Order CreateMap(TmsOrderModel taobaoOrderModel, string logisticsInterface)
{
try
{
var mySqlOrder = new T_MySql_Order
{
OUTSYS_BILL_CODE = string.IsNullOrEmpty(taobaoOrderModel.mailNo) ? " " : taobaoOrderModel.mailNo,
OUTSYS_ORDER_NO = string.IsNullOrEmpty(taobaoOrderModel.logisticsId)
? " "
: taobaoOrderModel.logisticsId,
ORDER_SOURCE = "TAOBAO_ONLINE",
MSG_TYPE = "JSON",
//mySqlOrder.CREATE_BY = "",
MSG_CONTENT = string.IsNullOrEmpty(logisticsInterface) ? "" : logisticsInterface,
IS_SYNC_SUCCESS = 0,
CREATE_TIME = DateTime.Now,
CREATE_BY = "TAOBAO_ONLINE",
C1 = "",
C2 = "",
C3 = "",
REMARK = ""
};
return(mySqlOrder);
}
catch (Exception e)
{
var message = new StringBuilder();
message.Append("TAOBAO订单映射过程发生错误：" + logisticsInterface);
message.Append(e.Message + e.StackTrace);
message.ToString().WriteToLog(LogerType.Error);
return(null);
}
}
/// <summary>
/// 映射关系
/// </summary>
/// <param name="taobaoOrderModel"></param>
/// <param name="logisticsInterface"></param>
/// <returns></returns>
public T_MySql_Order CreateMap(AddOrder_HC addOrder_HC, string logisticsInterface)
{
try
{
var mysql_order = new T_MySql_Order
{
OUTSYS_ORDER_NO = string.IsNullOrEmpty(addOrder_HC.logisticCode)
? " "
: addOrder_HC.logisticCode,
OUTSYS_BILL_CODE = addOrder_HC.logisticCode,
ORDER_SOURCE = "HUICHONG",
MSG_TYPE = "JSON",
//mySqlOrder.CREATE_BY = "",
MSG_CONTENT = string.IsNullOrEmpty(logisticsInterface) ? "" : logisticsInterface,
IS_SYNC_SUCCESS = 0,
CREATE_TIME = DateTime.Now,
CREATE_BY = "HUICHONG",
C1 = "",
C2 = "",
C3 = "",
REMARK = ""
};
return(mysql_order);
}
catch (Exception e)
{
var message = new StringBuilder();
message.Append("TAOBAO订单映射过程发生错误：" + logisticsInterface);
message.Append(e.Message + e.StackTrace);
message.ToString().WriteToLog(LogerType.Error);
return(null);
}
}
/// <summary>
/// charu
/// </summary>
/// <param name="parameters"></param>
/// <returns></returns>
public async Task <bool> Insert(T_MySql_Order t_MySql_Order)
{
//先获取动态表名
var tableName = MysqlTableName.GetMySqlOrderTableName();
return(await base.InsertAsync(_scope, new { tableName, t_MySql_Order.OUTSYS_ORDER_NO, t_MySql_Order.OUTSYS_BILL_CODE, t_MySql_Order.ORDER_SOURCE, t_MySql_Order.MSG_CONTENT, t_MySql_Order.MSG_TYPE, t_MySql_Order.REMARK, t_MySql_Order.IS_SYNC_SUCCESS, t_MySql_Order.CREATE_BY, t_MySql_Order.CREATE_TIME, C1 = "", C2 = "", C3 = "" }) > 0);
}
/// <summary>
/// 映射数据
/// </summary>
/// <param name="order"></param>
/// <param name="logisticsInterface"></param>
/// <returns></returns>
public static T_MySql_Order CreateMap(Aorder order, string logisticsInterface)
{
try
{
var mySqlOrder = new T_MySql_Order();
mySqlOrder.OUTSYS_BILL_CODE = string.IsNullOrEmpty(order.mailNo) ? "" : order.mailNo;
mySqlOrder.OUTSYS_ORDER_NO = string.IsNullOrEmpty(order.logisticID) ? "" : order.logisticID;
mySqlOrder.ORDER_SOURCE = ENUM_ORDER_SOURCE.ALI.ToString();
mySqlOrder.MSG_TYPE = "JSON";
//mySqlOrder.CREATE_BY = "";
mySqlOrder.MSG_CONTENT = string.IsNullOrEmpty(logisticsInterface) ? "" : logisticsInterface;
mySqlOrder.IS_SYNC_SUCCESS = 0;
mySqlOrder.CREATE_TIME = DateTime.Now;
mySqlOrder.CREATE_BY = mySqlOrder.ORDER_SOURCE;
mySqlOrder.C1 = "";
mySqlOrder.C2 = "";
mySqlOrder.C3 = "";
mySqlOrder.REMARK = "";
return(mySqlOrder);
}
catch (Exception e)
{
var message = new StringBuilder();
message.Append("TAOBAO订单映射过程发生错误：" + logisticsInterface);
message.Append(e.Message + e.StackTrace);
return(null);
}
}
protected virtual object CreateMysqlOrderParams(T_MySql_Order mysqlOrder)
{
#region 拼接动态类型的对象作为参数传递
////获取动态表名
//var tableName = MysqlTableName.GetMySqlOrderTableName();
////声明动态对象
//dynamic dyObj = new System.Dynamic.ExpandoObject();
//var jObj = JObject.FromObject(mySqlOrder);
//var jTokenPair = jObj.Children().ToArray();
//foreach (var jToken in jTokenPair)
//{
// var pair = (JProperty)jToken;
// ((IDictionary<string, object>)dyObj).Add(pair.Name, pair.Value);
//}
//((IDictionary<string, object>)dyObj).Add("tableName", tableName);
//var json = JsonConvert.SerializeObject((object)dyObj);
//var parameters = JsonConvert.DeserializeObject(json);
#endregion
var tableName = MysqlTableName.GetMySqlOrderTableName();
var parameters = new
{
tableName,
mysqlOrder.OUTSYS_ORDER_NO,
mysqlOrder.OUTSYS_BILL_CODE,
mysqlOrder.ORDER_SOURCE,
mysqlOrder.MSG_CONTENT,
mysqlOrder.MSG_TYPE,
mysqlOrder.REMARK,
mysqlOrder.IS_SYNC_SUCCESS,
mysqlOrder.CREATE_BY,
mysqlOrder.CREATE_TIME,
C1 = "",
C2 = "",
C3 = ""
};
return(parameters);
}
/// <summary>
/// 写入到数据库Order-插入前检查是否重复，重复数据不插入，按天分表，表名动态传入
/// </summary>
/// <param name="mySqlOrder"></param>
/// <returns></returns>
public async Task <bool> AddOrder(T_MySql_Order mySqlOrder)
{
try
{
var parameters = CreateMysqlOrderParams(mySqlOrder);
var eftRows = await MysqlScope.Repository.InsertAsync <T_MySql_Order>("T_MySql_Order.Insert", parameters);
return(eftRows > 0);
}
catch (Exception ex)
{
var msg = ex.Message;
var message = new StringBuilder();
message.Append("新增订单写入时数据库发生错误:\n" + "订单号：" + mySqlOrder.OUTSYS_BILL_CODE + "运单号：" + mySqlOrder.OUTSYS_ORDER_NO);
message.Append(msg);
msg = message.ToString();
msg += string.Format("\n JSON:\n<MySqlOrderData>{0}</MySqlOrderData>\n", mySqlOrder.MSG_CONTENT);
msg.WriteToLog(LogerType.Error);
return(false);
}
}
