private void ToolStripMenuItemLeaveFeedback_Click(object sender, EventArgs e)
{
DataGridViewSelectedRowCollection selectedRows = this.dataGridViewAllOrders.SelectedRows;
foreach (DataGridViewRow row in selectedRows)
{
String orderLineItemId = row.Cells[OrderDgv_OrderLineItemIndex].Value.ToString();
EbayTransactionType trans = EbayTransactionDAL.GetOneTransaction(orderLineItemId);
if (trans == null)
{
continue;
}
AccountType account = AccountUtil.GetAccount(trans.SellerName);
if (account == null)
{
continue;
}
EbayTransactionBiz.LeaveFeedback(account, trans.OrderId, trans.BuyerId, trans.ItemId, trans.EbayTransactionId);
EbayTransactionDAL.UpdateTransactionSellerLeftFeedback(trans.TransactionId, true);
row.Cells[OrderDgv_SellerLeftFeedbackIndex].Value = 1;
}
MessageBox.Show("留好评成功", "恭喜", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void ToolStripMenuItemAddRelationToItem_Click(object sender, EventArgs e)
{
FrmSelectItemSKU frmSelectSKU = new FrmSelectItemSKU();
frmSelectSKU.ShowDialog();
string itemSKU = frmSelectSKU.SKU;
if (itemSKU == null || itemSKU == "")
{
return;
}
DataGridViewSelectedRowCollection selectedRows = this.dataGridViewAllOrders.SelectedRows;
foreach (DataGridViewRow row in selectedRows)
{
String orderLineItemId = row.Cells[OrderDgv_OrderLineItemIndex].Value.ToString();
EbayTransactionType trans = EbayTransactionDAL.GetOneTransaction(orderLineItemId);
if (trans == null)
{
return;
}
EbayTransactionDAL.UpdateTransactionItemSKU(trans.TransactionId, itemSKU);
row.Cells[OrderDgv_ItemSKUIndex].Value = itemSKU;
}
MessageBox.Show("订单关联商品sku成功", "恭喜", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void ToolStripMenuItemViewMessage_Click(object sender, EventArgs e)
{
int rowIdx = this.dataGridViewPostSale.CurrentRow.Index;
String orderLineItemId = this.dataGridViewPostSale.Rows[rowIdx].Cells[PostSaleDgv_OrderLineItemIdIdx].Value.ToString();
EbayTransactionType trans = EbayTransactionDAL.GetOneTransaction(orderLineItemId);
if (trans == null)
{
return;
}
AccountType account = AccountUtil.GetAccount(trans.SellerName);
if (account == null)
{
MessageBox.Show(String.Format("此账号{0}未绑定到系统", trans.SellerName),
"抱歉", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
FrmUserMessage frmUserMessage = new FrmUserMessage();
frmUserMessage.EbayTransaction = trans;
frmUserMessage.Account = account;
frmUserMessage.ShowDialog();
if (frmUserMessage.SentMessage || frmUserMessage.MarkMsgAsReplied)
{
LoadPostSaleData();
}
}
// Upload tracking number to ebay.
// While uploading tracking number, ebay requires two fields:
// - tracking number
// - carrier
// Use Ebay API CompleteSale to fulfill this task, see page:
// https://developer.ebay.com/DevZone/XML/docs/Reference/ebay/CompleteSale.html
private void ToolStripMenuItemUploadTrackingNum_Click(object sender, EventArgs e)
{
DataGridViewSelectedRowCollection selectedRows = this.dataGridViewAllOrders.SelectedRows;
if (selectedRows.Count != 1)
{
return;
}
String orderLineItemId = selectedRows[0].Cells[OrderDgv_OrderLineItemIndex].Value.ToString();
EbayTransactionType trans = EbayTransactionDAL.GetOneTransaction(orderLineItemId);
if (trans == null)
{
return;
}
if (trans.ShippingTrackingNo != "")
{
MessageBox.Show("该订单已经上传跟踪号", "抱歉", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
FrmUploadTrackingNumber frmUploadTrackingNumber = new FrmUploadTrackingNumber();
frmUploadTrackingNumber.account = AccountUtil.GetAccount(trans.SellerName);
frmUploadTrackingNumber.ebayTrans = trans;
frmUploadTrackingNumber.Show();
trans = EbayTransactionDAL.GetOneTransaction(orderLineItemId);
selectedRows[0].Cells[OrderDgv_TrackingNoIndex].Value = trans.ShippingTrackingNo;
}
public static bool InsertOrUpdateOneTransaction(EbayTransactionType trans)
{
if (trans.IsValid() == false)
{
return(false);
}
bool result = true;
EbayTransactionType transLoc = EbayTransactionDAL.GetOneTransaction(trans.OrderLineItemId);
if (transLoc != null)
{
result = UpdateOneTransaction(trans);
}
else
{
result = InsertOneTransaction(trans);
}
return(true);
}
private List <EbayTransactionType> GetAllSelectedTransactions(bool check)
{
// Check if every paid-but-un-shipped item has a sku.
List <EbayTransactionType> allSelectedTrans = new List <EbayTransactionType>();
DataGridViewSelectedRowCollection selectedRows = this.dataGridViewAllOrders.SelectedRows;
foreach (DataGridViewRow row in selectedRows)
{
String orderLineItemId = row.Cells[OrderDgv_OrderLineItemIndex].Value.ToString();
EbayTransactionType trans = EbayTransactionDAL.GetOneTransaction(orderLineItemId);
if (trans == null)
{
return(null);
}
if (!trans.IsPaid)
{
return(null);
}
if (check && (trans.ItemSKU == null || trans.ItemSKU.Trim() == ""))
{
MessageBox.Show("订单没有关联的商品SKU！", "失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(null);
}
// Is shipping service specified?
if (check && (trans.ShippingService == "" || trans.ShippingServiceCode == ""))
{
MessageBox.Show("没有为订单选择物流运输方式！", "失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(allSelectedTrans);
}
allSelectedTrans.Add(trans);
}
return(allSelectedTrans);
}
//
// User selected transactions and clicked "mark as shipped".
//
private void ToolStripMenuItemMarkAsShipped_Click(object sender, EventArgs e)
{
if (MessageBox.Show("你确认发货么?\r\n发货后，ebay会标记成已发货状态。",
"确认发货?",
MessageBoxButtons.YesNo,
MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
DataGridViewSelectedRowCollection selectedRows = this.dataGridViewAllOrders.SelectedRows;
// First check if every transaction item has a related sku.
foreach (DataGridViewRow row in selectedRows)
{
String orderLineItemId = row.Cells[OrderDgv_OrderLineItemIndex].Value.ToString();
EbayTransactionType trans = EbayTransactionDAL.GetOneTransaction(orderLineItemId);
if (trans == null)
{
return;
}
if (trans.IsPaid == false)
{
MessageBox.Show("有些商品没有付款，不能发货!", "失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (trans.IsShipped == true)
{
MessageBox.Show("有些商品已经发货，不能重新发货!", "失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (trans.ItemSKU == null || trans.ItemSKU.Trim() == "")
{
MessageBox.Show("有些商品没有指定SKU!", "失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
List <String> handledOrderIds = new List <String>();
foreach (DataGridViewRow row in selectedRows)
{
String orderLineItemId = row.Cells[OrderDgv_OrderLineItemIndex].Value.ToString();
EbayTransactionType trans = EbayTransactionDAL.GetOneTransaction(orderLineItemId);
if (trans == null)
{
return;
}
if (trans.IsPaid == false || trans.IsShipped == true)
{
MessageBox.Show("商品未付款或者已经发货!", "失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
continue;
}
String orderId = trans.OrderId;
if (handledOrderIds.Contains(orderId))
{
continue;
}
AccountType account = null;
List <AccountType> allAccounts = AccountUtil.GetAllAccounts();
foreach (AccountType accountType in allAccounts)
{
if (accountType.ebayAccount == trans.SellerName)
{
account = accountType;
break;
}
}
if (account == null || account.SellerApiContext == null)
{
MessageBox.Show("账号没有初始化!", "失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
EbayTransactionBiz.CompleteSale(account, trans.OrderId, trans.BuyerId, trans.ItemId, trans.EbayTransactionId,
false, true, true, true /*isShipped*/);
handledOrderIds.Add(orderId);
StringCollection orderIds = new StringCollection();
orderIds.Add(trans.OrderId);
TimeFilter timeFilter = new TimeFilter();
timeFilter.TimeFrom = this.dateTimePickerStartTime.Value;
timeFilter.TimeTo = this.dateTimePickerEndTime.Value;
List <EbayTransactionType> transList = EbayTransactionBiz.GetAllOrders(account, timeFilter, orderIds);
if (transList.Count != 1)
{
MessageBox.Show("交易在ebay系统中不存在!", "失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
continue;
}
if (transList[0].IsShipped == false)
{
MessageBox.Show(string.Format("该交易没有在ebay系统中标记成功! 用户id={0}", trans.BuyerId), "失败", MessageBoxButtons.OK, MessageBoxIcon.Error);
continue;
}
// ZHI_TODO
//ItemDAL.ShipItem(trans.ItemSKU, trans.SaleQuantity);
// Update transaction shipped date.
EbayTransactionDAL.UpdateTransactionShippedStatus(trans.TransactionId, true /*shipped*/, transList[0].ShippedDate);
Logger.WriteSystemUserLog(string.Format("标记交易已发货成功: userId={0}, 商品名={1}", trans.BuyerId, trans.ItemTitle));
row.DefaultCellStyle.BackColor = ColorTranslator.FromHtml("#90EE90");
}
MessageBox.Show("标记成发货成功!", "成功", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private void contextMenuStripTransaction_Opening(object sender, CancelEventArgs e)
{
ContextMenuStrip cmnu = (ContextMenuStrip)sender;
bool enableViewOrderDetail = true;
bool enableViewOrderMessage = true;
bool enableSendMessageToBuyer = true;
bool enableSetSKUForOrderItem = true;
bool enableViewItem = true;
bool enableSelectShippingService = true;
bool enableMarkAsShipped = true;
bool enableCreateDeliveryNote = true;
bool enableUploadTrackingNo = true;
bool enableLeaveFeedback = true;
bool enableMergeOrders = true;
DataGridViewSelectedRowCollection selectedRows = this.dataGridViewAllOrders.SelectedRows;
if (selectedRows.Count != 1)
{
enableViewOrderDetail = false;
enableViewOrderMessage = false;
enableSendMessageToBuyer = false;
enableViewItem = false;
enableUploadTrackingNo = false;
}
// First check if every transaction item has a related sku.
String lastBuyerId = null;
foreach (DataGridViewRow row in selectedRows)
{
String orderLineItemId = row.Cells[OrderDgv_OrderLineItemIndex].Value.ToString();
EbayTransactionType trans = EbayTransactionDAL.GetOneTransaction(orderLineItemId);
if (trans == null)
{
continue;
}
if (lastBuyerId == null)
{
lastBuyerId = trans.BuyerId;
}
else if (enableMergeOrders && lastBuyerId != trans.BuyerId)
{
enableMergeOrders = false;
}
if (enableMergeOrders && trans.OrderId.IndexOf("-") < 0)
{
enableMergeOrders = false;
}
if (trans.IsShipped || !trans.IsPaid)
{
//enableSelectShippingService = false;
enableMarkAsShipped = false;
}
if (!trans.IsPaid)
{
enableSelectShippingService = false;
}
if (enableViewOrderDetail && !trans.IsPaid)
{
enableViewOrderDetail = false;
}
if (enableViewOrderMessage && !trans.IsPaid)
{
enableViewOrderMessage = false;
}
if (enableSendMessageToBuyer && !trans.IsPaid)
{
enableSendMessageToBuyer = false;
}
if (enableSetSKUForOrderItem && !trans.IsPaid)
{
enableSetSKUForOrderItem = false;
}
if (enableViewItem && !trans.IsPaid)
{
enableViewItem = false;
}
if (enableCreateDeliveryNote && (!trans.IsPaid || trans.IsDelivered))
{
enableCreateDeliveryNote = false;
}
if (enableUploadTrackingNo && trans.ShippingTrackingNo != "")
{
enableUploadTrackingNo = false;
}
if (enableLeaveFeedback && trans.IsSellerLeftFeedback)
{
enableLeaveFeedback = false;
}
}
cmnu.Items[ViewOrderDetailMenuItemIndex].Enabled = enableViewOrderDetail;
cmnu.Items[ViewOrderMessageMenuItemIndex].Enabled = enableViewOrderMessage;
cmnu.Items[SendMessageToBuyerMenuItemIndex].Enabled = enableSendMessageToBuyer;
cmnu.Items[SetSKUForOrderItemMenuItemIndex].Enabled = enableSetSKUForOrderItem;
cmnu.Items[ViewItemMenuItemIndex].Enabled = enableViewItem;
cmnu.Items[SelectShippingServiceMenuItemIndex].Enabled = enableSelectShippingService;
cmnu.Items[MarkAsShippedMenuItemIndex].Enabled = enableMarkAsShipped;
cmnu.Items[UploadTrackingNoMenuItemIndex].Enabled = enableUploadTrackingNo;
cmnu.Items[LeaveFeedbackMenuItemIndex].Enabled = enableLeaveFeedback;
cmnu.Items[CreateDeliveryNoteMenuItemIndex].Enabled = enableCreateDeliveryNote;
cmnu.Items[MergeOrdersMenuItemIndex].Enabled = enableMergeOrders;
}
// Private to prevent misuse, use public InsertOrUpdateOneTransaction instead!!!!!!!
private static bool InsertOneTransaction(EbayTransactionType trans)
{
if (trans.IsValid() == false)
{
return(false);
}
EbayTransactionType transLoc = EbayTransactionDAL.GetOneTransaction(trans.OrderLineItemId);
if (transLoc != null)
{
Logger.WriteSystemLog(string.Format("Transaction already existed in database: userId={0}, itemTitle={1}",
trans.BuyerId, trans.ItemTitle));
return(false);
}
IDbCommand cmd = DataFactory.CreateCommand(null);
cmd.CommandText = @"insert into [Transaction] (SellerName, OrderId, OrderLineItemId, EbayTransactionId, EbayRecordId, BuyerId, BuyerRating,"
+ "BuyerCountryEbayCode, BuyerCountry4PXCode,"
+ "BuyerCountry, BuyerCompanyName, BuyerName, BuyerStateOrProvince, BuyerCity,"
+ "BuyerTel, BuyerMail, BuyerPostalCode, BuyerAddress, BuyerAddressCompact, BuyerAddressLine1, BuyerAddressLine2,"
+ "BuyerPayPal,ItemId, ItemTitle, ItemSKU, ItemPrice, SaleQuantity, SalePrice, TotalPrice, CurrencyId,"
+ "SaleDate, SaleDateCN, IsPaid, PaidDate, IsShipped, ShippedDate, ShippingServiceCode, ShippingService, ShippingTrackingNo, ShippingCost, FinalValueFee, PayPalFee,"
+ "IsReceived, IsBuyerLeftFeedback, IsSellerLeftFeedback, IsNeedAttention, MessageStatus, IsContactedBuyer,"
+ "LastContactedBuyerDate, IsResendReplacement, UserComment) values ("
+ "@SellerName, @OrderId, @OrderLineItemId, @EbayTransactionId, @EbayRecordId, @BuyerId, @BuyerRating,"
+ "@BuyerCountryEbayCode, @BuyerCountry4PXCode,"
+ "@BuyerCountry, @BuyerCompanyName, @BuyerName, @BuyerStateOrProvince, @BuyerCity,"
+ "@BuyerTel, @BuyerMail, @BuyerPostalCode, @BuyerAddress, @BuyerAddressCompact, @BuyerAddressLine1, @BuyerAddressLine2,"
+ "@BuyerPayPal, @ItemId, @ItemTitle, @ItemSKU, @ItemPrice, @SaleQuantity, @SalePrice, @TotalPrice, @CurrencyId,"
+ "@SaleDate, @SaleDateCN, @IsPaid, @PaidDate, @IsShipped, @ShippedDate, @ShippingServiceCode, @ShippingService, @ShippingTrackingNo, @ShippingCost, @FinalValueFee, @PayPalFee,"
+ "@IsReceived, @IsBuyerLeftFeedback, @IsSellerLeftFeedback, @IsNeedAttention, @MessageStatus, @IsContactedBuyer,"
+ "@LastContactedBuyerDate, @IsResendReplacement, @UserComment)";
DataFactory.AddCommandParam(cmd, "@SellerName", DbType.String, trans.SellerName);
DataFactory.AddCommandParam(cmd, "@OrderId", DbType.String, trans.OrderId);
DataFactory.AddCommandParam(cmd, "@OrderLineItemId", DbType.String, trans.OrderLineItemId);
DataFactory.AddCommandParam(cmd, "@EbayTransactionId", DbType.String, trans.EbayTransactionId);
DataFactory.AddCommandParam(cmd, "@EbayRecordId", DbType.Int32, trans.EbayRecordId);
DataFactory.AddCommandParam(cmd, "@BuyerId", DbType.String, trans.BuyerId);
DataFactory.AddCommandParam(cmd, "@BuyerRating", DbType.Int32, trans.BuyerRating);
DataFactory.AddCommandParam(cmd, "@BuyerCountryEbayCode", DbType.String, StringUtil.GetSafeString(trans.BuyerCountryEbayCode));
DataFactory.AddCommandParam(cmd, "@BuyerCountry4PXCode", DbType.String, StringUtil.GetSafeString(trans.BuyerCountry4PXCode));
DataFactory.AddCommandParam(cmd, "@BuyerCountry", DbType.String, StringUtil.GetSafeString(trans.BuyerCountry));
DataFactory.AddCommandParam(cmd, "@BuyerCompanyName", DbType.String, StringUtil.GetSafeString(trans.BuyerCompanyName));
DataFactory.AddCommandParam(cmd, "@BuyerName", DbType.String, trans.BuyerName);
DataFactory.AddCommandParam(cmd, "@BuyerStateOrProvince", DbType.String, trans.BuyerStateOrProvince);
DataFactory.AddCommandParam(cmd, "@BuyerCity", DbType.String, trans.BuyerCity);
DataFactory.AddCommandParam(cmd, "@BuyerTel", DbType.String, StringUtil.GetSafeString(trans.BuyerTel));
DataFactory.AddCommandParam(cmd, "@BuyerMail", DbType.String, StringUtil.GetSafeString(trans.BuyerMail));
DataFactory.AddCommandParam(cmd, "@BuyerPostalCode", DbType.String, StringUtil.GetSafeString(trans.BuyerPostalCode));
DataFactory.AddCommandParam(cmd, "@BuyerAddress", DbType.String, StringUtil.GetSafeString(trans.BuyerAddress));
DataFactory.AddCommandParam(cmd, "@BuyerAddressCompact", DbType.String, StringUtil.GetSafeString(trans.BuyerAddressCompact));
DataFactory.AddCommandParam(cmd, "@BuyerAddressLine1", DbType.String, StringUtil.GetSafeString(trans.BuyerAddressLine1));
DataFactory.AddCommandParam(cmd, "@BuyerAddressLine2", DbType.String, StringUtil.GetSafeString(trans.BuyerAddressLine2));
DataFactory.AddCommandParam(cmd, "@BuyerPayPal", DbType.String, StringUtil.GetSafeString(trans.BuyerPayPal));
DataFactory.AddCommandParam(cmd, "@ItemId", DbType.String, StringUtil.GetSafeString(trans.ItemId));
DataFactory.AddCommandParam(cmd, "@ItemTitle", DbType.String, StringUtil.GetSafeString(trans.ItemTitle));
DataFactory.AddCommandParam(cmd, "@ItemSKU", DbType.String, StringUtil.GetSafeString(trans.ItemSKU));
DataFactory.AddCommandParam(cmd, "@ItemPrice", DbType.Double, trans.ItemPrice);
DataFactory.AddCommandParam(cmd, "@SaleQuantity", DbType.Int32, trans.SaleQuantity);
DataFactory.AddCommandParam(cmd, "@SalePrice", DbType.Double, trans.SalePrice);
DataFactory.AddCommandParam(cmd, "@TotalPrice", DbType.Double, trans.TotalPrice);
DataFactory.AddCommandParam(cmd, "@CurrencyId", DbType.String, StringUtil.GetSafeString(trans.CurrencyId));
DataFactory.AddCommandParam(cmd, "@SaleDate", DbType.Date, StringUtil.GetSafeDateTime(trans.SaleDate).ToString());
DataFactory.AddCommandParam(cmd, "@SaleDateCN", DbType.Date, StringUtil.GetSafeDateTime(trans.SaleDateCN).ToString());
DataFactory.AddCommandParam(cmd, "@IsPaid", DbType.Boolean, trans.IsPaid);
DataFactory.AddCommandParam(cmd, "@PaidDate", DbType.Date, StringUtil.GetSafeDateTime(trans.PaidDate).ToString());
DataFactory.AddCommandParam(cmd, "@IsShipped", DbType.Boolean, trans.IsShipped);
DataFactory.AddCommandParam(cmd, "@ShippedDate", DbType.Date, StringUtil.GetSafeDateTime(trans.ShippedDate).ToString());
DataFactory.AddCommandParam(cmd, "@ShippingServiceCode", DbType.String, trans.ShippingServiceCode);
DataFactory.AddCommandParam(cmd, "@ShippingService", DbType.String, trans.ShippingService);
DataFactory.AddCommandParam(cmd, "@ShippingTrackingNo", DbType.String, trans.ShippingTrackingNo);
DataFactory.AddCommandParam(cmd, "@ShippingCost", DbType.Double, trans.ShippingCost);
DataFactory.AddCommandParam(cmd, "@FinalValueFee", DbType.Double, trans.FinalValueFee);
DataFactory.AddCommandParam(cmd, "@PayPalFee", DbType.Double, trans.PayPalFee);
DataFactory.AddCommandParam(cmd, "@IsReceived", DbType.Boolean, trans.IsReceived);
DataFactory.AddCommandParam(cmd, "@IsBuyerLeftFeedback", DbType.Boolean, trans.IsBuyerLeftFeedback);
DataFactory.AddCommandParam(cmd, "@IsSellerLeftFeedback", DbType.Boolean, trans.IsSellerLeftFeedback);
DataFactory.AddCommandParam(cmd, "@IsNeedAttention", DbType.Boolean, trans.IsNeedAttention);
DataFactory.AddCommandParam(cmd, "@MessageStatus", DbType.Int32, trans.MessageStatus);
DataFactory.AddCommandParam(cmd, "@IsContactedBuyer", DbType.Boolean, trans.IsContactedBuyer);
DataFactory.AddCommandParam(cmd, "@LastContactedBuyerDate", DbType.Date, StringUtil.GetSafeDateTime(trans.LastContactedBuyerDate).ToString());
DataFactory.AddCommandParam(cmd, "@IsResendReplacement", DbType.Boolean, trans.IsResendReplacement);
DataFactory.AddCommandParam(cmd, "@UserComment", DbType.String, StringUtil.GetSafeString(trans.UserComment));
bool result = false;
int newItemId = 0;
try
{
if (DataFactory.DbConnection.State == ConnectionState.Closed)
{
DataFactory.DbConnection.Open();
}
cmd.ExecuteNonQuery();
IDbCommand cmdNewID = DataFactory.CreateCommand("SELECT @@IDENTITY");
// Retrieve the Autonumber and store it in the CategoryID column.
object obj = cmdNewID.ExecuteScalar();
Int32.TryParse(obj.ToString(), out newItemId);
result = newItemId > 0;
}
catch (DataException ex)
{
// Write to log here.
Logger.WriteSystemLog(string.Format("Error : {0}", ex.Message));
trans.dump();
result = false;
}
finally
{
if (DataFactory.DbConnection.State == ConnectionState.Open)
{
DataFactory.DbConnection.Close();
}
}
return(result);
} // InsertOneTransaction
public static bool UpdateOneTransaction(EbayTransactionType trans)
{
if (trans.IsValid() == false)
{
return(false);
}
EbayTransactionType transLoc = EbayTransactionDAL.GetOneTransaction(trans.OrderLineItemId);
if (transLoc == null)
{
Logger.WriteSystemLog(string.Format("No transaction with EbayTransactionId={0}", trans.EbayTransactionId));
return(false);
}
bool needUpdateIsPaid = false;
if (trans.IsPaid != transLoc.IsPaid)
{
Logger.WriteSystemLog(string.Format("Update one transaction with id={0}, set isPaid={1}", trans.EbayTransactionId, trans.IsPaid));
needUpdateIsPaid = true;
}
bool needUpdateShipped = false;
if (trans.IsShipped != transLoc.IsShipped)
{
Logger.WriteSystemLog(string.Format("Update one transaction with id={0}, set IsShipped={1}", trans.EbayTransactionId, trans.IsShipped));
needUpdateShipped = true;
}
bool needUpdateBuyerFeedbackLeft = false;
if (trans.IsBuyerLeftFeedback != transLoc.IsBuyerLeftFeedback)
{
Logger.WriteSystemLog(string.Format("Update one transaction with id={0}, set BuyerFeedbackLeft={1}", trans.EbayTransactionId, trans.IsBuyerLeftFeedback));
needUpdateBuyerFeedbackLeft = true;
}
bool needUpdateSellerFeedbackLeft = false;
if (trans.IsSellerLeftFeedback != transLoc.IsSellerLeftFeedback)
{
Logger.WriteSystemLog(string.Format("Update one transaction with id={0}, set SellerFeedbackLeft={1}", trans.EbayTransactionId, trans.IsSellerLeftFeedback));
needUpdateSellerFeedbackLeft = true;
}
bool needUpdateSellerName = false;
if (trans.SellerName == "")
{
needUpdateSellerName = true;
}
bool needUpdateTotalPrice = false;
if (trans.TotalPrice != transLoc.TotalPrice)
{
needUpdateTotalPrice = true;
}
bool needUpdateSaleRecordId = false;
if (trans.EbayRecordId != -1 && trans.EbayRecordId != transLoc.EbayRecordId)
{
needUpdateSaleRecordId = true;
}
bool needUpdateSaleDateCN = false;
if (trans.SaleDateCN != null && 0 != trans.SaleDateCN.CompareTo(transLoc.SaleDateCN))
{
needUpdateSaleDateCN = true;
}
bool needUpdateTrackingNumber = false;
if (trans.ShippingTrackingNo != null && trans.ShippingTrackingNo != transLoc.ShippingTrackingNo)
{
needUpdateTrackingNumber = true;
}
bool needUpdateShippingDate = false;
if (trans.ShippedDate != transLoc.ShippedDate)
{
needUpdateShipped = true;
}
if (!needUpdateIsPaid && !needUpdateShipped && !needUpdateBuyerFeedbackLeft &&
!needUpdateSellerFeedbackLeft && !needUpdateSellerName && !needUpdateTotalPrice &&
!needUpdateSaleRecordId && !needUpdateSaleDateCN && !needUpdateTrackingNumber && !needUpdateShippingDate)
{
return(true);
}
if (transLoc.TransactionId <= 0)
{
Logger.WriteSystemLog("Invalid transaction id.");
return(false);
}
// CAUTION: we need to retain some column values in the old entry,
// such as the message status we calculated last time.
if (transLoc.ItemSKU != null && transLoc.ItemSKU != "")
{
trans.ItemSKU = transLoc.ItemSKU;
}
if (transLoc.ShippingService != null && transLoc.ShippingService != "")
{
trans.ShippingService = transLoc.ShippingService;
}
if (transLoc.ShippingServiceCode != null && transLoc.ShippingServiceCode != "")
{
trans.ShippingServiceCode = transLoc.ShippingServiceCode;
}
trans.MessageStatus = transLoc.MessageStatus;
bool result = UpdateOneTransactionInternal(transLoc.TransactionId, trans);
return(result);
}
private void SendMessageAsync(object sender, DoWorkEventArgs e)
{
object[] paramArr = e.Argument as object[];
DataTable dtOrders = (DataTable)paramArr[0];
String messageToSend = (String)paramArr[1];
int curIdx = 0;
foreach (DataRow row in dtOrders.Rows)
{
curIdx++;
String sellerName = StringUtil.GetSafeString(row["SellerName"]);
String buyerId = StringUtil.GetSafeString(row["BuyerId"]);
String itemId = StringUtil.GetSafeString(row["ItemId"]);
String orderLineItemId = StringUtil.GetSafeString(row["OrderLineItemId"]);
EbayTransactionType transLoc = EbayTransactionDAL.GetOneTransaction(orderLineItemId);
if (transLoc == null)
{
continue;
}
String subject = String.Format("{0} sent a message on item {1} with itemId {2}",
sellerName,
buyerId,
itemId);
AccountType account = AccountUtil.GetAccount(sellerName);
if (account == null)
{
continue;
}
String labelHintStr = String.Format("正在向买家 {0} 发送消息.... 进度 {1} / {2}",
buyerId, curIdx, dtOrders.Rows.Count);
int progressBarValue = (int)((double)(curIdx) / dtOrders.Rows.Count * 100);
frmProgress.SetLabelHintAndProgressBarValue(labelHintStr, progressBarValue);
if (frmProgress.Cancel)
{
e.Cancel = true;
e.Result = curIdx;
return;
}
messageToSend = replaceMessageMacros(messageToSend, transLoc);
bool result = EbayMessageBiz.SendMessageToBuyer(account,
buyerId,
itemId,
subject,
messageToSend,
true /*emailCopyToSender*/,
eBay.Service.Core.Soap.QuestionTypeCodeType.General);
if (result)
{
DateTime startTime = DateTime.Now;
DateTime endTime = startTime;
startTime = startTime.Subtract(new TimeSpan(0, 5, 0));
startTime = startTime.ToUniversalTime();
endTime = endTime.ToUniversalTime();
// Get all message ids within this five minutes.
StringCollection msgIds = EbayMessageBiz.GetAllMessageIds(account, startTime, endTime);
// Skip the messages we have retrieved.
StringCollection newMsgIds = new StringCollection();
{
foreach (String msgId in msgIds)
{
EbayMessageType existedMessage = EbayMessageDAL.GetOneMessage(msgId);
if (existedMessage != null)
{
continue;
}
newMsgIds.Add(msgId);
}
}
List <EbayMessageType> newMessages = EbayMessageBiz.GetAllMessageByIds(account, newMsgIds);
Logger.WriteSystemLog(String.Format("Retrieved new messages count={0}", newMsgIds.Count));
foreach (EbayMessageType messageType in newMessages)
{
// We are pretty sure the message didn't exist.
EbayMessageDAL.InsertOneMessage(messageType);
// Update the transaction message status.
String recipientUserId = messageType.RecipientUserId;
String senderName = messageType.Sender;
String sellerNameLoc = messageType.SellerName;
String buyerIdLoc = sellerNameLoc == senderName ? recipientUserId : senderName;
// [ZHI_TODO]
TransactionMessageStatus messageStatus = EbayMessageDAL.GetTransactionMessageStatus(buyerIdLoc, sellerNameLoc, messageType.ItemID);
List <EbayTransactionType> transList = EbayTransactionDAL.GetTransactionsBySellerBuyerItem(sellerNameLoc, buyerIdLoc, messageType.ItemID);
foreach (EbayTransactionType trans in transList)
{
EbayTransactionDAL.UpdateTransactionMessageStatus(trans.TransactionId, messageStatus);
}
}
}
else
{
Logger.WriteSystemUserLog("发送消息失败！");
}
}
e.Result = OrdersDataTable.Rows.Count;
} // SendMessageAsync
