private void btnLoad_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; // Get folder for google downloads. string documents = Environment.GetFolderPath(Environment.SpecialFolder.Personal); string user = Directory.GetParent(documents).FullName; string downloads = Path.Combine(user, "downloads"); OpenFileDialog ofd = new OpenFileDialog(); ofd.Filter = "Taobao exported file (*.csv)|*.csv|Parsed orders file (*.xml)|*.xml"; ofd.FilterIndex = 0; ofd.Multiselect = false; ofd.ShowReadOnly = false; if (Directory.Exists(downloads)) { ofd.InitialDirectory = downloads; } if (DialogResult.OK == ofd.ShowDialog(this)) { if (Path.GetExtension(ofd.FileName).ToLower().Equals(".xml")) { _orders = Order.LoadXmlFile(ofd.FileName, false); } else if (Path.GetExtension(ofd.FileName).ToLower().Equals(".csv")) { _orders = AnalyseCsv(ofd.FileName); } } if (null == _orders) { return; } foreach (Order o in _orders) { if (o.ShipmentNumber.StartsWith("DE") || o.ShipmentNumber.StartsWith("4008") || o.ShipmentNumber.StartsWith("3STIFD")) { continue; } if (o.ShipmentCompany.Contains("POSTNL")) { continue; } OrderListViewItem lvi = new OrderListViewItem(lvwOrders.Items.Count + 1, o, chkBuyerRated.Checked); lvwOrders.Items.Add(lvi); lvi.EnsureVisible(); } MessageBox.Show(this, "Done.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); Cursor.Current = Cursors.Default; }
private static void QueueItem(OrderListViewItem item) { if (null == _queue) { _queue = new Queue <OrderListViewItem>(); } _queue.Enqueue(item); item.SubItems[INDEX_STATUS].Text = "Waiting..."; }
protected override void OnShown(EventArgs e) { Cursor.Current = Cursors.WaitCursor; base.OnShown(e); if (null == _orders) { // Get folder for google downloads. string documents = Environment.GetFolderPath(Environment.SpecialFolder.Personal); string user = Directory.GetParent(documents).FullName; string downloads = Path.Combine(user, "downloads"); OpenFileDialog ofd = new OpenFileDialog(); ofd.Filter = "Taobao exported file (*.csv)|*.csv|Parsed orders file (*.xml)|*.xml"; ofd.FilterIndex = 0; ofd.Multiselect = false; ofd.ShowReadOnly = false; if (Directory.Exists(downloads)) { ofd.InitialDirectory = downloads; } if (DialogResult.OK == ofd.ShowDialog(this)) { if (Path.GetExtension(ofd.FileName).ToLower().Equals(".xml")) { _orders = Order.LoadXmlFile(ofd.FileName, false); } else if (Path.GetExtension(ofd.FileName).ToLower().Equals(".csv")) { _orders = AnalyseCsv(ofd.FileName); } } } if (null == _orders) { return; } foreach (Order o in _orders) { OrderListViewItem lvi = new OrderListViewItem(lvwOrders.Items.Count + 1, o); lvwOrders.Items.Add(lvi); lvi.EnsureVisible(); } MessageBox.Show(this, "Done.", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); Cursor.Current = Cursors.Default; }
private static void Next() { if (null == _queue || _queue.Count <= 0) { return; } OrderListViewItem item = _queue.Dequeue(); if (null == item) { return; } item.StartGetRecentStatus(); }
protected override void OnShown(EventArgs e) { Cursor.Current = Cursors.WaitCursor; base.OnShown(e); foreach (Order o in _orders) { OrderListViewItem lvi = new OrderListViewItem(lvwOrders.Items.Count + 1, o); lvwOrders.Items.Add(lvi); lvi.EnsureVisible(); } Cursor.Current = Cursors.Default; }
private void lvwOrders_DoubleClick(object sender, EventArgs e) { if (lvwOrders.SelectedItems.Count <= 0) { return; } Cursor.Current = Cursors.WaitCursor; OrderListViewItem item = lvwOrders.SelectedItems[0] as OrderListViewItem; OuterOrderDetailsForm oodf = new OuterOrderDetailsForm(item.Order); if (DialogResult.OK == oodf.ShowDialog(this)) { item.Order.BillNumber = oodf.BillNumber; item.Update(); } Cursor.Current = Cursors.Default; }
private void btnLoad_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; // Get folder for google downloads. string documents = Environment.GetFolderPath(Environment.SpecialFolder.Personal); string user = Directory.GetParent(documents).FullName; string downloads = Path.Combine(user, "downloads"); OpenFileDialog ofd = new OpenFileDialog(); ofd.Filter = "Taobao exported file (*.csv)|*.csv|Parsed orders file (*.xml)|*.xml"; ofd.FilterIndex = 0; ofd.Multiselect = false; ofd.ShowReadOnly = false; if (Directory.Exists(downloads)) { ofd.InitialDirectory = downloads; } if (DialogResult.OK == ofd.ShowDialog(this)) { if (Path.GetExtension(ofd.FileName).ToLower().Equals(".xml")) { _orders = Order.LoadXmlFile(ofd.FileName, false); } else if (Path.GetExtension(ofd.FileName).ToLower().Equals(".csv")) { _orders = AnalyseCsv(ofd.FileName); } } if (null == _orders) { return; } int total = 0; foreach (Order o in _orders) { if (!o.ShipmentCompany.Equals("其他")) { continue; } if (!o.ShipmentNumber.StartsWith("297808") && !o.ShipmentNumber.StartsWith("960")) { continue; } DhlOrder dhlorder = DhlOrder.GetItem(o.OrderId); if (null != dhlorder && dhlorder.Pickedup) { continue; } total++; } lblInfo.Text = string.Format("{0}/{1}", 0 + 1, total); foreach (Order o in _orders) { if (!o.ShipmentCompany.Equals("其他")) { continue; } if (!o.ShipmentNumber.StartsWith("297808") && !o.ShipmentNumber.StartsWith("960")) { continue; } DhlOrder dhlorder = DhlOrder.GetItem(o.OrderId); if (null != dhlorder && dhlorder.Pickedup) { continue; } OrderListViewItem lvi = new OrderListViewItem(lvwOrders.Items.Count + 1, o, lvwOrders); lvwOrders.Items.Add(lvi); } Cursor.Current = Cursors.Default; }
private void tsbtnImportOrders_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; try { if (lvwOrders.Items.Count > 0) { DialogResult dr = MessageBox.Show(this, "当前列表中的订单信息将会被清除.\n是否加载订单文件?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); if (DialogResult.No == dr) { return; } } Cursor.Current = Cursors.WaitCursor; OpenFileDialog ofd = new OpenFileDialog(); ofd.Filter = "Excel Files(*.xlsx)|*.xlsx|Excel Files 97-2003(*.xls)|*.xls|All Files(*.*)|*.*"; if (DialogResult.OK == ofd.ShowDialog(this)) { Egode.Excel excel = null; excel = new Egode.Excel(ofd.FileName, Excel.OledbVersions.OLEDB12); DataSet ds = excel.Get("Sheet1", string.Empty); // get column index of total money and demand. int indexTaobaoId = -1; int indexProduct = -1; int indexCount = -1; int indexTotalMoney = -1; int indexAddress = -1; int indexExpress = -1; int indexBillNumber = -1; int indexDemand = -1; for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { if (null == ds.Tables[0].Rows[0][i]) { continue; } System.Diagnostics.Trace.WriteLine(i.ToString()); System.Diagnostics.Trace.WriteLine(ds.Tables[0].Rows[0][i].ToString()); if (ds.Tables[0].Rows[0][i].ToString().Trim().ToLower().Equals("旺旺id")) { indexTaobaoId = i; } if (ds.Tables[0].Rows[0][i].ToString().Trim().Contains("产品")) { indexProduct = i; } if (ds.Tables[0].Rows[0][i].ToString().Trim().Equals("数量")) { indexCount = i; } if (ds.Tables[0].Rows[0][i].ToString().Trim().Contains("金额")) { indexTotalMoney = i; } if (ds.Tables[0].Rows[0][i].ToString().Trim().Equals("地址")) { indexAddress = i; } if (ds.Tables[0].Rows[0][i].ToString().Trim().Equals("快递")) { indexExpress = i; } if (ds.Tables[0].Rows[0][i].ToString().Trim().Equals("快递单号")) { indexBillNumber = i; } if (ds.Tables[0].Rows[0][i].ToString().Trim().Equals("特殊要求")) { indexDemand = i; } } lvwOrders.Items.Clear(); for (int i = 1; i < ds.Tables[0].Rows.Count; i++) { DataRow r = ds.Tables[0].Rows[i]; EgodeSimpleOrder o = new EgodeSimpleOrder( r[indexTaobaoId].ToString().Trim(), r[indexProduct].ToString().Trim(), r[indexCount].ToString().Trim(), r[indexTotalMoney].ToString().Trim(), r[indexExpress].ToString().Trim(), r[indexAddress].ToString().Trim(), r[indexDemand].ToString().Trim()); if (-1 != indexBillNumber) { o.BillNumber = r[indexBillNumber].ToString().Trim(); } OrderListViewItem item = new OrderListViewItem(o); lvwOrders.Items.Add(item); } _loadedFilename = ofd.FileName; } } catch (Exception ex) { MessageBox.Show(this, ex.ToString(), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } finally { Cursor.Current = Cursors.Default; } }