private void LoadReportTable(string strCode, string industryCode)
{
DataTable dtReports = DataService.GetInstance().GetReportList(strCode); //公司研究报告
DataTable dtReports2 = DataService.GetInstance().GetReportList(industryCode); //行业研究报告
if (dtReports2 != null)
{
foreach (DataRow oRow in dtReports2.Rows)
{
DataRow newRow = dtReports.NewRow();
//Add Industry reports
foreach (DataColumn oCol in dtReports.Columns)
{
newRow[oCol.ColumnName] = oRow[oCol.ColumnName];
}
dtReports.Rows.Add(newRow);
}
}
//Provide report URL
string reportURL = DataService.GetInstance().GetReportServerURL() + "?ReportId=";
foreach (DataRow oRow in dtReports.Rows)
{
oRow["URL"] = reportURL + oRow["reportid"].ToString();
//oRow["fileURL"] = reportURL + oRow["reportid"].ToString();
}
GridViewReports.DataSource = dtReports;
GridViewReports.DataBind();
}
// check all legacy reports
protected void CheckButton_Click(object sender, EventArgs e)
{
//Response.Write("<SCRIPT LANGUAGE=\"JavaScript\">alert(\"Submit report failed! Window's account: " + Environment.UserName + "\")</SCRIPT>");
// create style
GridViewReports.Visible = true;
GridViewReports.Columns.Clear();
GridViewReports.CaptionAlign = TableCaptionAlign.Top;
GridViewReports.Caption = "<font size=\"5\" color=\"red\">Legacy Sales Call Report for " + CustomerList.Text + " </font>";
// create grid view table
DataTable report = new DataTable();
report.Columns.Add("ID");
report.Columns.Add("Visit Date");
report.Columns.Add("Follow Up Date");
report.Columns.Add("Sales");
string query = "select [ID], [Date], [FollowUpDate], [Sales] from [tiger].[dbo].[Sales_Call_Report] where [CustomerName]='" + CustomerList.Text.Replace("'", "''") + "'";
ExcoODBC database = ExcoODBC.Instance;
database.Open(Database.DECADE_MARKHAM);
OdbcDataReader reader = database.RunQuery(query);
while (reader.Read())
{
DataRow row = report.NewRow();
row[0] = reader[0].ToString();
row[1] = reader[1].ToString();
row[2] = reader[2].ToString();
row[3] = reader[3].ToString();
report.Rows.Add(row);
}
reader.Close();
// bind data
report.AcceptChanges();
GridViewReports.AutoGenerateSelectButton = true;
GridViewReports.DataSource = report;
GridViewReports.DataBind();
}
