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