public string CreateCharts() { HyOperationlog HyOperationlog = new HyOperationlog(); DataTable dt = new DataTable(); string test = ""; int artTotal = 0; dt = HyOperationlog.phoneGetDataTableSystem(this.operateTime_s.Value, this.operateTime_e.Value); string strXML = ""; strXML += "<graph caption='系统情况分析' showNames='1' showValues='1' baseFontSize='12' xAxisName='统计类型' yAxisName='完成数' decimalPrecision='0' formatNumberScale='0'>"; string[] strArrayColors = new string[3] { "AFD8F8", "F6BD0F", "8BBA00" }; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { strXML += "<set name='" + dt.Rows[i]["hyOperationType"].ToString() + "记录数' value='" + dt.Rows[i]["totalCount"].ToString() + "' color='" + strArrayColors[i] + "' showValues='0' />"; artTotal += Convert.ToInt32(dt.Rows[i]["totalCount"].ToString()); strXML += "<set name='总记录数' value='" + artTotal + "' color='AFD8F8' showValues='0' />"; } } else { strXML += "<set name='新增记录数' value='" + "" + "' color='AFD8F8' />"; strXML += "<set name='修改记录数' value='" + "" + "' color='F6BD0F' />"; strXML += "<set name='删除记录数' value='" + "" + "' color='8BBA00' />"; } strXML += "</graph>"; return FusionCharts.RenderChartHTML("../FusionCharts/FCF_Column3D.swf", "ChartId", strXML, "myNext", "600", "400", false); }
private void getData() { this.lb_show.Text = " <tr height=\"22\" onmouseover=\"this.className='tr_over'\" onmouseout=\"this.className='tr_out'\" class=\"tr_out\">"; HyOperationlog HyOperationlog = new HyOperationlog(); DataTable dt = new DataTable(); int artTotal = 0; dt = HyOperationlog.phoneGetDataTableSystem(this.operateTime_s.Value, this.operateTime_e.Value); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { this.lb_show.Text += "<td align=\"center\" >" + dt.Rows[i]["totalCount"].ToString() + "</td> "; artTotal += Convert.ToInt32(dt.Rows[i]["totalCount"].ToString()); } this.lb_show.Text += "<td align=\"center\" >" + artTotal + "</td> "; } else { this.lb_show.Text += "<td align=\"center\" colspan=\"4\" >暂无记录</td> "; } this.lb_show.Text += "</tr>"; }