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