/// <summary>
/// 添加订单数据到本地数据库
/// </summary>
/// <param name="order"></param>
/// <returns></returns>
public bool AddOrder(List <TBrebateOrders> order)
{
var datalist = new List <TBrebateOrders>();
foreach (var temp in order)
{
var data = new TBrebateOrders
{
TradeId = temp.TradeId,
NumIid = temp.NumIid,
ItemText = temp.ItemText,
ItemNum = temp.ItemNum,
Price = temp.Price,
PayPrice = temp.PayPrice,
SellerNick = temp.SellerNick,
SellerShopTitle = temp.SellerShopTitle,
TkStatus = temp.TkStatus,
IncomeRate = temp.IncomeRate,
Proportions = temp.Proportions,
OrderType = temp.OrderType,
PubSharePreFee = temp.PubSharePreFee,
StatementPrice = temp.StatementPrice,
PrePay = temp.PrePay,
Commission = temp.Commission,
CommissionRate = temp.CommissionRate,
SubsidyRate = temp.SubsidyRate,
SubsidyFee = temp.SubsidyFee,
SubsidyType = temp.SubsidyType,
TerminalType = temp.TerminalType,
Tk3rdType = temp.Tk3rdType,
Category = temp.Category,
Tk3rdPubId = temp.Tk3rdPubId,
Tk3rdPubName = temp.Tk3rdPubName,
AdzoneId = temp.AdzoneId,
AdzoneName = temp.AdzoneName,
ClickTime = temp.ClickTime,
CreateTime = temp.CreateTime,
EarningTime = temp.EarningTime
};
//判断该订单是否在数据库中存在,不存在添加，存在则更新
var isExist = _platformOrdersDal.IsOrderExist(data.TradeId);
if (!isExist)
{
datalist.Add(data);
}
else
{
_platformOrdersDal.PlatformOrderUpdate(data.TradeId);
}
}
var isSuccess = _platformOrdersDal.PlatformOrderAdd(datalist);
return(isSuccess);
}
/// <summary>
/// 把excel数据变成model数据
/// </summary>
/// <param name="filePath"></param>
/// <returns></returns>
public bool ExcelToData(string filePath)
{
List <TBrebateOrders> orderses = new List <TBrebateOrders>();
ExcelHelper excelHelper = new ExcelHelper(filePath);
var data = excelHelper.ExcelToDataTable("", true);
for (int i = 0; i < data.Rows.Count; i++)
{
TBrebateOrders brebateOrders = new TBrebateOrders
{
CreateTime = string.IsNullOrEmpty(data.Rows[i][0].ToString()) ? DateTime.Parse("1900-01-01") : DateTime.Parse(data.Rows[i][0].ToString()),
ClickTime = string.IsNullOrEmpty(data.Rows[i][1].ToString()) ? DateTime.Parse("1900-01-01") : DateTime.Parse(data.Rows[i][1].ToString()),
ItemText = data.Rows[i][2].ToString(),
NumIid = string.IsNullOrEmpty(data.Rows[i][3].ToString()) ? -1 : long.Parse(data.Rows[i][3].ToString()),
SellerNick = data.Rows[i][4].ToString(),
SellerShopTitle = data.Rows[i][5].ToString(),
ItemNum = string.IsNullOrEmpty(data.Rows[i][6].ToString()) ? -1 : long.Parse(data.Rows[i][6].ToString()),
Price = string.IsNullOrEmpty(data.Rows[i][7].ToString()) ? -1 : double.Parse(data.Rows[i][7].ToString()),
TkStatus = data.Rows[i][8].ToString(),
OrderType = data.Rows[i][9].ToString(),
IncomeRate = data.Rows[i][10].ToString(),
Proportions = data.Rows[i][11].ToString(),
PayPrice = string.IsNullOrEmpty(data.Rows[i][12].ToString()) ? -1 : double.Parse(data.Rows[i][12].ToString()),
PubSharePreFee = string.IsNullOrEmpty(data.Rows[i][13].ToString()) ? -1 : double.Parse(data.Rows[i][13].ToString()),
StatementPrice = string.IsNullOrEmpty(data.Rows[i][14].ToString()) ? -1 : double.Parse(data.Rows[i][14].ToString()),
PrePay = string.IsNullOrEmpty(data.Rows[i][15].ToString()) ? -1 : double.Parse(data.Rows[i][15].ToString()),
EarningTime = string.IsNullOrEmpty(data.Rows[i][16].ToString()) ? DateTime.Parse("1900-01-01") : DateTime.Parse(data.Rows[i][16].ToString()),
CommissionRate = data.Rows[i][17].ToString(),
Commission = string.IsNullOrEmpty(data.Rows[i][18].ToString()) ? -1 : double.Parse(data.Rows[i][18].ToString()),
SubsidyRate = data.Rows[i][19].ToString(),
SubsidyFee = string.IsNullOrEmpty(data.Rows[i][20].ToString()) ? -1 : double.Parse(data.Rows[i][20].ToString()),
SubsidyType = data.Rows[i][21].ToString(),
TerminalType = data.Rows[i][22].ToString(),
Tk3rdType = data.Rows[i][23].ToString(),
TradeId = string.IsNullOrEmpty(data.Rows[i][24].ToString()) ? -1 : long.Parse(data.Rows[i][24].ToString()),
Category = data.Rows[i][25].ToString(),
Tk3rdPubId = string.IsNullOrEmpty(data.Rows[i][26].ToString()) ? -1 : long.Parse(data.Rows[i][26].ToString()),
Tk3rdPubName = data.Rows[i][27].ToString(),
AdzoneId = string.IsNullOrEmpty(data.Rows[i][28].ToString()) ? -1 : long.Parse(data.Rows[i][28].ToString()),
AdzoneName = data.Rows[i][29].ToString()
};
orderses.Add(brebateOrders);
}
return(AddOrder(orderses));
}
