public static string getReportTableString(DateTime startDate, DateTime endDate, string selectedProjectsStr)
{
DBL db = new DBL();
DataSet dataSet;
string strFlag = string.Format("{0}_{1}_{2}", startDate, endDate, selectedProjectsStr);
dataSet = db.GetGlobalReportsInfo(MyReportID, strFlag);
DataTable dt = dataSet.Tables["ReportTable105"];
if (dt == null)
{
return(string.Empty);
}
//写报表头部
StringBuilder sbReportHTML = new StringBuilder();
sbReportHTML.Append("<tr><th>项目名称</th><th>任务编号</th><th>任务名称</th><th>任务状态</th></tr>");
sbReportHTML.Append("<tbody>");
foreach (DataRow dr in dt.Rows)
{
sbReportHTML.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td>", dr["ProjectName"].ToString(), dr["BugID"].ToString(), dr["BugTitle"].ToString(), dr["ProgressStatusName"].ToString());
}
sbReportHTML.AppendFormat("</tbody></table>");
return(sbReportHTML.ToString());
}
public static string getReportTableString()
{
DBL db = new DBL();
DataSet dataSet;
dataSet = db.GetGlobalReportsInfo(MyReportID);
DataTable dt = dataSet.Tables["ReportTable101"];
if (dt == null)
{
return(string.Empty);
}
StringBuilder sbReportHTML = new StringBuilder();
sbReportHTML.Append("<thead>");
sbReportHTML.Append("<tr><th>项目名称</th><th>任务编号</th><th>任务名称</th><th>任务状态</th></tr>");
sbReportHTML.Append("</thead><tbody>");
foreach (DataRow dr in dt.Rows)
{
sbReportHTML.AppendFormat("<tr><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td>", dr["ProjectName"].ToString(), dr["BugID"].ToString(), dr["BugTitle"].ToString(), dr["ProgressStatusName"].ToString());
}
sbReportHTML.Append("</tbody>");
return(sbReportHTML.ToString());
}
public static string getReportTableString()
{
DBL db = new DBL();
DataSet dataSet;
dataSet = db.GetGlobalReportsInfo(MyReportID);
DataTable dt = dataSet.Tables["ReportTable121"];
if (dt == null)
{
return(string.Empty);
}
StringBuilder sbReportHTML = new StringBuilder();
sbReportHTML.Append("<thead>");
sbReportHTML.Append("<tr><th>项目名称</th><th>负责人</th></tr>");
sbReportHTML.Append("</thead><tbody>");
foreach (DataRow dr in dt.Rows)
{
sbReportHTML.AppendFormat("<tr><td>{0}</td><td>{1}</td>", dr["标题"].ToString(), dr["负责人"].ToString());
}
sbReportHTML.Append("</tbody>");
return(sbReportHTML.ToString());
}
public static string RefreshGlobalReport103(string selectedProjectsStr)
{
DBL db = new DBL();
DataSet dataSet;
dataSet = db.GetGlobalReportsInfo(MyReportID, selectedProjectsStr);
return(GetReportByHTML(dataSet.Tables["ReportTable103"]));
}
public static string RefreshGlobalReport114(string selectedProjectsStr)
{
DBL db = new DBL();
DataSet dataSet;
dataSet = db.GetGlobalReportsInfo(MyReportID, selectedProjectsStr);
return(getChartReport(dataSet.Tables["ReportTable114"]));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DBL db = new DBL();
DataSet dataSet = new DataSet();
dataSet = db.GetGlobalReportsInfo(MyReportID);
htmlGlobalReportTable101 = GetReportByHTML(dataSet.Tables["ReportTable101"]);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DBL db = new DBL();
DataSet dataSet = new DataSet();
dataSet = db.GetGlobalReportsInfo(MyReportID);
getChartReport(dataSet.Tables["ReportTable110"]);
}
}
public static string RefreshGlobalReport104(string startDateStr, string endDateStr)
{
DBL db = new DBL();
DataSet dataSet;
DateTime startDate = Convert.ToDateTime(startDateStr);
DateTime endDate = Convert.ToDateTime(endDateStr);
string strFlag = string.Format("{0}_{1}", startDate, endDate);
dataSet = db.GetGlobalReportsInfo(MyReportID, strFlag);
return(GetReportByHTML(dataSet.Tables["ReportTable104"]));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DBL db = new DBL();
DataSet dataSet = new DataSet();
db.GetDropDownField(dataSet);
selProjectOptions103 = BindChoices(dataSet.Tables["DropDownFieldsChoice"]); // 绑定下拉框字段值
dataSet = db.GetGlobalReportsInfo(MyReportID, hidprojectIDs.Value.ToString());
htmlGlobalReportTable103 = GetReportByHTML(dataSet.Tables["ReportTable103"]);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DBL db = new DBL();
DataSet dataSet = new DataSet();
DateTime startDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
DateTime endDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
dateTimePicker.Value = startDate.ToShortDateString();
dateTimePicker2.Value = endDate.ToShortDateString();
string strFlag = string.Format("{0}_{1}", startDate, endDate);
dataSet = db.GetGlobalReportsInfo(MyReportID, strFlag);
htmlGlobalReportTable104 = GetReportByHTML(dataSet.Tables["ReportTable104"]);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DBL db = new DBL();
DataSet dataSet = new DataSet();
DateTime startDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1);
DateTime endDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
dateTimePicker.Value = startDate.ToShortDateString();
dateTimePicker2.Value = endDate.ToShortDateString();
db.GetDropDownField(dataSet);
selProjectOptions106 = BindChoices(dataSet.Tables["DropDownFieldsChoice"]);
string strFlag = string.Format("{0}_{1}_{2}", startDate, endDate, hidprojectIDs.Value.ToString());
dataSet = db.GetGlobalReportsInfo(MyReportID, strFlag);
htmlGlobalReportTable106 = GetReportByHTML(dataSet.Tables["ReportTable106"]);
}
}