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