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;
}
}
