private void btnOpenReportFolder_Click(object sender, EventArgs e)
{
var path = this.txtReportPath.Text;
if (string.IsNullOrWhiteSpace(path) || !Directory.Exists(path))
{
ShowInfo("此目录尚不存在，请您导出报表后再打开此目录");
return;
}
DateTime asOfDate, asOfDate2;
if (IsValidToExport(out asOfDate, out asOfDate2, true))
{
if (asOfDate2 > asOfDate)
{
asOfDate = asOfDate2;
}
var path2 = BaseReport.GetReportFolder(asOfDate);
if (Directory.Exists(path2))
{
path = path2;
}
}
Process process = new Process();
process.StartInfo.FileName = "explorer";
process.StartInfo.Arguments = path;
process.Start();
process.WaitForExit();
process.Close();
}
private void InitReportPanel()
{
var report = this.Reports.Single(x => x.Id == (int)currentReport);
if (report == null)
{
ShowStop("Failed to get entity of current report.");
return;
}
this.lblReportTitle.Text = report.Name;
this.SelectedColumns.Clear();
this.SelectedColumns1.Clear();
this.SelectedColumns2.Clear();
ShowAsOfDate2();
ShowExportDate();
ShowSelectColumnButton();
var dao = new SqlDbHelper();
var lastSelectValue = "";
var lastSelectValue2 = "";
if (IsMonthly())
{
this.lblExportDate.Text = "数据月份：";
if (this.cmbReportMonth.SelectedIndex >= 0)
{
lastSelectValue = this.cmbReportMonth.Text;
}
this.cmbReportMonth.Items.Clear();
DataTable table;
if (currentReport == XEnum.ReportType.C_DQDKQK_M)
{
table = dao.ExecuteDataTable("SELECT * FROM dbo.sfGetMonthsInFuture()");
}
else
{
table = dao.ExecuteDataTable("SELECT ImportDate, dbo.sfGetImportStatus(ImportDate) AS status FROM Import WHERE DAY(ImportDate + 1) = 1 ORDER BY ImportDate DESC");
}
if (table != null)
{
foreach (DataRow row in table.Rows)
{
var value = ((DateTime)row[0]).ToString("yyyy-MM");
if (row.ItemArray.Length > 1 && !((string)row[1]).StartsWith("1111111"))
{
value += " *";
}
this.cmbReportMonth.Items.Add(value);
if (!string.IsNullOrEmpty(lastSelectValue) && value.Equals(lastSelectValue))
{
this.cmbReportMonth.Text = value;
}
}
// Select the latest one by default
if (this.cmbReportMonth.Items.Count > 0)
{
if (this.cmbReportMonth.SelectedIndex < 0)
{
this.cmbReportMonth.SelectedIndex = 0;
}
}
}
}
else
{
this.lblExportDate.Text = "数据日期：";
var table = dao.ExecuteDataTable("SELECT ImportDate FROM Import ORDER BY ImportDate DESC");
if (this.cmbReportMonth.SelectedIndex >= 0)
{
lastSelectValue = this.cmbReportMonth.Text;
}
if (this.cmbReportMonth2.SelectedIndex >= 0)
{
lastSelectValue2 = this.cmbReportMonth2.Text;
}
this.cmbReportMonth.Items.Clear();
this.cmbReportMonth2.Items.Clear();
if (table != null)
{
foreach (DataRow row in table.Rows)
{
var value = ((DateTime)row[0]).ToString("yyyy-MM-dd");
this.cmbReportMonth.Items.Add(value);
this.cmbReportMonth2.Items.Add(value);
if (!string.IsNullOrEmpty(lastSelectValue) && value.Equals(lastSelectValue))
{
this.cmbReportMonth.Text = value;
}
if (!string.IsNullOrEmpty(lastSelectValue2) && value.Equals(lastSelectValue2))
{
this.cmbReportMonth2.Text = value;
}
}
// Select the latest one by default
if (this.cmbReportMonth.Items.Count > 0)
{
if (this.cmbReportMonth.SelectedIndex < 0)
{
this.cmbReportMonth.SelectedIndex = 0;
}
}
if (this.cmbReportMonth2.Items.Count > 0)
{
if (this.cmbReportMonth2.SelectedIndex < 0)
{
this.cmbReportMonth2.SelectedIndex = 0;
}
}
}
}
this.txtReportPath.Text = BaseReport.GetReportFolder();
}