private void Report3Initialize()//生成图形报表
{
chart = Report3.ControlByName("Chart1").AsChart;
chart.Title = "订单地区统计";
chart.TitleFont.Name = "楷体";
chart.TitleFont.Bold = true;
chart.TitleFont.Point = 17;
chart.Font.Name = "楷体";
//chart.Font.Bold = true;
chart.SeriesCount = 1;
chart.Font.Point = 13;
chart.GroupCount = Convert.ToInt16(table2.Rows.Count);
chart.YAxisSpace = 5;
chart.YAxisMaximum = 30;
chart.YAxisMinimum = 0;
//坐标可见性(CoordLineVisible)等属性已在.grf文件设定
//chart.PrepareSnapShot();
for (int count = 0; count < table2.Rows.Count; count++)
{ //添加数据
chart.set_GroupLabel((short)count, table2.Rows[count][0].ToString()); //各项名称
//object aaa = table.Rows[count][1];
chart.set_Value(0, (short)count, Convert.ToDouble(table2.Rows[count][1])); //各项数据
}
//chart.SnapShot();
//=======================================以上是条形图
//=======================================
//=======================================以下是饼图
chart2 = Report3.ControlByName("Chart2").AsChart;
chart2.Title = "订单地区统计2";
chart2.TitleFont.Name = "楷体";
chart2.TitleFont.Bold = true;
chart2.TitleFont.Point = 17;
chart2.Font.Name = "楷体";
//chart2.Font.Bold = true;
chart2.SeriesCount = Convert.ToInt16(table2.Rows.Count);
chart2.Font.Point = 13;
chart2.GroupCount = 1;
//坐标可见性(CoordLineVisible)等属性已在.grf文件设定
//chart.PrepareSnapShot();
for (int count = 0; count < table2.Rows.Count; count++)
{ //添加数据
chart2.set_SeriesLabel((short)count, table2.Rows[count][0].ToString()); //各项名称
chart2.set_Value((short)count, 0, Convert.ToDouble(table2.Rows[count][1])); //各项数据
}
chart2.set_GroupLabel(0, "订单地区统计");
//chart.SnapShot();
}
private void Report_Initialize()
{
ItemExport.Enabled = false;
ItemPrint.Enabled = false;
string sql = "";
if (rbSex.Checked)
{
sql = Pub.GetSQL(DBCode.DB_001003, new string[] { "401", OprtInfo.DepartPower });
}
else if (rbDepart.Checked)
{
sql = Pub.GetSQL(DBCode.DB_001003, new string[] { "402", OprtInfo.DepartPower });
}
else if (rbCardType.Checked)
{
sql = Pub.GetSQL(DBCode.DB_001003, new string[] { "403", OprtInfo.DepartPower });
}
else if (rbCardStatus.Checked)
{
sql = Pub.GetSQL(DBCode.DB_001003, new string[] { "404", OprtInfo.DepartPower });
}
if (sql == "")
{
return;
}
DataTable dt = null;
string fn;
int v = 0;
DetailChart = Report.ControlByName("DetailChart").AsChart;
DetailChart.YAxisMaximum = 0;
try
{
if (!db.IsOpen)
{
db.Open(SystemInfo.ConnStr);
}
dt = db.GetDataTable(sql);
if (dt.Rows.Count > 0)
{
if (rbBar.Checked)
{
DetailChart.SeriesCount = 1;
DetailChart.GroupCount = Convert.ToInt16(dt.Rows.Count);
}
else
{
DetailChart.SeriesCount = Convert.ToInt16(dt.Rows.Count);
DetailChart.GroupCount = 1;
}
for (short i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i].IsNull(0))
{
fn = "[NULL]";
}
else
{
fn = dt.Rows[i][0].ToString();
}
v = Convert.ToInt32(dt.Rows[i][1]);
if (rbBar.Checked)
{
DetailChart.set_GroupLabel(i, fn);
DetailChart.set_SeriesLabel(i, "");
DetailChart.set_Value(0, i, v);
}
else
{
DetailChart.set_GroupLabel(i, "");
DetailChart.set_SeriesLabel(i, fn);
DetailChart.set_Value(i, 0, v);
}
DetailChart.YAxisMaximum = DetailChart.YAxisMaximum + v;
}
}
ItemExport.Enabled = true;
ItemPrint.Enabled = true;
}
catch (Exception E)
{
Pub.ShowErrorMsg(E);
}
finally
{
if (dt != null)
{
dt.Clear();
dt.Reset();
}
}
DetailChart.SnapShot();
}
