private void btnExport_Click(object sender, EventArgs e)
{
SaveFileDialog saveFileDlg = new SaveFileDialog();
saveFileDlg.Filter = "Excel files (*.xlsx)|*.xlsx";
saveFileDlg.FilterIndex = 1;
saveFileDlg.RestoreDirectory = true;
if (saveFileDlg.ShowDialog() == DialogResult.OK)
{
var bys = VegetPriceDB.GetExcelBytes(mData);
if (null != bys && bys.Length > 0)
{
Stream myStream;
if ((myStream = saveFileDlg.OpenFile()) != null)
{
myStream.Write(bys, 0, bys.Length);
myStream.Close();
var str = string.Format("成功导出到: {0}", saveFileDlg.FileName);
MessageBox.Show(str, "导出", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("导出失败", "导出", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public void TestGetByDateRange1()
{
var collector = new VegetPriceCollector(MARKET_URL);
var dtBegin = new DateTime(2018, 7, 23);
var dtEnd = new DateTime(2018, 7, 28);
var dt = collector.GetByDateRange(dtBegin, dtEnd);
Assert.IsNotNull(dt);
var nGet = dt.Rows.Count;
Assert.IsTrue(nGet > 0);
//Assert.AreEqual(exp2, s2);
var nWrite = VegetPriceDB.SaveToDB(dt);
Assert.IsTrue(nGet == (int)nWrite);
}
