private void m_mainTimer_Tick(object sender, System.EventArgs e)
{
// Shift values
m_chartSample3.ShiftLeft();
m_chartSample3.Invalidate();
// Add a new value with random
if (m_chartSample3.ChartDescription.Columns.Count != 0)
{
Random RandomClass = new Random();
ChartColumn LastColumn = (ChartColumn)m_chartSample3.ChartDescription.Columns [m_chartSample3.ChartDescription.Columns.Count - 1];
int [] newValuesArray = new int [LastColumn.Length];
for (int i = 0; i < newValuesArray.Length; i++)
{
newValuesArray [i] = RandomClass.Next(50);
}
LastColumn.AssignValues(newValuesArray);
}
else
{
// All has been cleared, recreate columns
m_chartSample3.AddColumn(90, 5);
m_chartSample3.AddColumn(50, 30);
m_chartSample3.AddColumn(5, 5);
m_chartSample3.AddColumn(20, 10);
m_chartSample3.AddColumn(85, 10);
m_chartSample3.AddColumn(0, 30);
m_chartSample3.AddColumn(40, 20);
m_chartSample3.ChartDescription.RenderingMode = ChartRenderingMode.BarWith3dGradient;
m_chartSample3.CumulativeMode = ChartCumulativeMode.StartFromLastValue;
m_chartSample3.AdjustVerticalAxis();
}
}
ChartBase RunChartBuild(Report rpt, Row row)
{
// Get the matrix that defines the data;
_ChartMatrix.SetMyData(rpt, GetMyData(rpt)); // set the data in the matrix
int maxColumns;
int maxRows;
MatrixCellEntry[,] matrix = _ChartMatrix.RunBuild(rpt, out maxRows, out maxColumns);
// Build the Chart bitmap, along with data regions
ChartBase cb = null;
switch (_Type)
{
case ChartTypeEnum.Column:
cb = new ChartColumn(rpt, row, this, matrix, _showTooltips, _showTooltipsX, _ToolTipYFormat, _ToolTipXFormat);
break;
case ChartTypeEnum.Line:
case ChartTypeEnum.Area: // handled by line
cb = new ChartLine(rpt, row, this, matrix, _showTooltips, _showTooltipsX, _ToolTipYFormat, _ToolTipXFormat);
break;
case ChartTypeEnum.Bar:
cb = new ChartBar(rpt, row, this, matrix, _showTooltips, _showTooltipsX, _ToolTipYFormat, _ToolTipXFormat);
break;
case ChartTypeEnum.Pie:
case ChartTypeEnum.Doughnut: // handled by pie
cb = new ChartPie(rpt, row, this, matrix, _showTooltips, _showTooltipsX, _ToolTipYFormat, _ToolTipXFormat);
break;
case ChartTypeEnum.Bubble:
case ChartTypeEnum.Scatter:
cb = new ChartBubble(rpt, row, this, matrix, _showTooltips, _showTooltipsX, _ToolTipYFormat, _ToolTipXFormat);
break;
case ChartTypeEnum.Map:
cb = new ChartMap(rpt, row, this, matrix, _showTooltips, _showTooltipsX, _ToolTipYFormat, _ToolTipXFormat);
break;
case ChartTypeEnum.Stock:
default:
cb = new ChartColumn(rpt, row, this, matrix, _showTooltips, _showTooltipsX, _ToolTipYFormat, _ToolTipXFormat);
break;
}
return(cb);
}
public static bool ShowRightDataGridView(DataGridView rightgrid, ChartColumn col, string zid, string zhibiao)
{
string sql = "";
DataTable dt = null;
switch (zhibiao)
{
case "专利存活期":
sql = string.Format("select {0}.{1} as '{2}',count(distinct {0}.sid) as 专利数 from {0} where ztid={3} group by {0}.{1} order by {0}.{1} desc", col.TableName, col.ColName, col.ShowName, zid);
break;
case "审查周期":
sql = string.Format("select {0}.{1} as '{2}',count(distinct {0}.sid) as 专利数 from {0} where ztid={3} and type='发明专利' group by {0}.{1} order by {0}.{1} desc", col.TableName, col.ColName, col.ShowName, zid);
break;
case "有效专利维持期":
sql = string.Format("select {0}.{1} as '{2}',count(distinct {0}.sid) as 专利数 from {0} where ztid={3} and lg='授权有效' group by {0}.{1} order by {0}.{1} desc", col.TableName, col.ColName, col.ShowName, zid);
break;
case "公知技术":
if (col.TableName == "st_dt")
{
sql = string.Format("select {0}.{1} as '{2}',count(distinct {0}.sid) as 专利数 from {0} where ztid={3} and st_dt.isgongzhi=1 group by {0}.{1} order by count(distinct sid) desc", col.TableName, col.ColName, col.ShowName, zid);
}
else
{
sql = string.Format("select {0}.{1} as '{2}',count(distinct {0}.sid) as 专利数 from {0},st_dt where {0}.sid=st_dt.sid and st_dt.ztid={3} and st_dt.isgongzhi=1 group by {0}.{1} order by count(distinct {0}.sid) desc", col.TableName, col.ColName, col.ShowName, zid);
}
break;
case "":
break;
default:
break;
}
dt = DBA.MySqlDbAccess.GetDataTable(CommandType.Text, sql);
rightgrid.DataSource = dt;
rightgrid.Columns[rightgrid.Columns.Count - 1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
return(true);
}
public override bool ShowRightDataGridView(DataGridView rightgrid, ChartColumn col, string zid)
{
string sql = "";
DataTable dt = null;
if (col.TableName == "st_dt")
{
sql = string.Format("select {0}.{1} as '{2}',count(distinct {0}.sid) as 专利数 from {0} where and ztid={3} and {0}.gj in ('中国') group by {0}.{1} order by count(distinct {0}.sid) desc", col.TableName, col.ColName, col.ShowName, zid);
}
else
{
sql = string.Format("select {0}.{1} as '{2}',count(distinct {0}.sid) as 专利数 from {0},st_dt where {0}.sid=st_dt.sid and st_dt.ztid={3} and st_dt.gj in ('中国') group by {0}.{1} order by count(distinct {0}.sid) desc", col.TableName, col.ColName, col.ShowName, zid);
}
dt = DBA.MySqlDbAccess.GetDataTable(CommandType.Text, sql);
rightgrid.DataSource = dt;
rightgrid.Columns[rightgrid.Columns.Count - 1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
return(true);
}
private static DeclarationList CreateCurrentDeclarations()
{
DeclarationList declarationList = new DeclarationList();
int num = 1;
declarationList[num++] = IDOwner.GetDeclaration();
declarationList[num++] = ReportItem.GetDeclaration();
num++;
declarationList[num++] = Report.GetDeclaration();
declarationList[num++] = PageSection.GetDeclaration();
declarationList[num++] = Line.GetDeclaration();
declarationList[num++] = Rectangle.GetDeclaration();
declarationList[num++] = Image.GetDeclaration();
num++;
declarationList[num++] = CheckBox.GetDeclaration();
declarationList[num++] = TextBox.GetDeclaration();
declarationList[num++] = SubReport.GetDeclaration();
declarationList[num++] = ActiveXControl.GetDeclaration();
declarationList[num++] = DataRegion.GetDeclaration();
num++;
declarationList[num++] = ReportHierarchyNode.GetDeclaration();
declarationList[num++] = Grouping.GetDeclaration();
declarationList[num++] = Sorting.GetDeclaration();
declarationList[num++] = List.GetDeclaration();
declarationList[num++] = Pivot.GetDeclaration();
declarationList[num++] = Matrix.GetDeclaration();
declarationList[num++] = PivotHeading.GetDeclaration();
declarationList[num++] = MatrixHeading.GetDeclaration();
declarationList[num++] = MatrixColumn.GetDeclaration();
num++;
declarationList[num++] = MatrixRow.GetDeclaration();
num++;
declarationList[num++] = Subtotal.GetDeclaration();
declarationList[num++] = Table.GetDeclaration();
declarationList[num++] = TableColumn.GetDeclaration();
num++;
declarationList[num++] = TableGroup.GetDeclaration();
declarationList[num++] = TableRow.GetDeclaration();
num++;
declarationList[num++] = OWCChart.GetDeclaration();
declarationList[num++] = ChartColumn.GetDeclaration();
num++;
declarationList[num++] = ReportItemCollection.GetDeclaration();
declarationList[num++] = ReportItemIndexer.GetDeclaration();
num++;
declarationList[num++] = Style.GetDeclaration();
num++;
declarationList[num++] = AttributeInfo.GetDeclaration();
declarationList[num++] = Visibility.GetDeclaration();
declarationList[num++] = ExpressionInfo.GetDeclaration();
num++;
declarationList[num++] = DataAggregateInfo.GetDeclaration();
num++;
declarationList[num++] = RunningValueInfo.GetDeclaration();
num++;
num++;
declarationList[num++] = Filter.GetDeclaration();
num++;
declarationList[num++] = DataSource.GetDeclaration();
num++;
declarationList[num++] = DataSet.GetDeclaration();
num++;
declarationList[num++] = ReportQuery.GetDeclaration();
declarationList[num++] = Field.GetDeclaration();
num++;
declarationList[num++] = ParameterValue.GetDeclaration();
num++;
num++;
num++;
num++;
declarationList[num++] = ReportSnapshot.GetDeclaration();
declarationList[num++] = SenderInformation.GetDeclaration();
declarationList[num++] = InstanceInfo.GetDeclaration();
declarationList[num++] = ReceiverInformation.GetDeclaration();
declarationList[num++] = InstanceInfo.GetDeclaration();
declarationList[num++] = DocumentMapNode.GetDeclaration();
declarationList[num++] = InfoBase.GetDeclaration();
declarationList[num++] = OffsetInfo.GetDeclaration();
declarationList[num++] = InstanceInfo.GetDeclaration();
declarationList[num++] = ReportItemInstanceInfo.GetDeclaration();
declarationList[num++] = ReportInstanceInfo.GetDeclaration();
declarationList[num++] = ReportItemColInstanceInfo.GetDeclaration();
declarationList[num++] = LineInstanceInfo.GetDeclaration();
declarationList[num++] = TextBoxInstanceInfo.GetDeclaration();
declarationList[num++] = RectangleInstanceInfo.GetDeclaration();
declarationList[num++] = CheckBoxInstanceInfo.GetDeclaration();
declarationList[num++] = ImageInstanceInfo.GetDeclaration();
declarationList[num++] = SubReportInstanceInfo.GetDeclaration();
declarationList[num++] = ActiveXControlInstanceInfo.GetDeclaration();
declarationList[num++] = ListInstanceInfo.GetDeclaration();
declarationList[num++] = ListContentInstanceInfo.GetDeclaration();
declarationList[num++] = MatrixInstanceInfo.GetDeclaration();
declarationList[num++] = MatrixHeadingInstanceInfo.GetDeclaration();
declarationList[num++] = MatrixCellInstanceInfo.GetDeclaration();
declarationList[num++] = TableInstanceInfo.GetDeclaration();
declarationList[num++] = TableGroupInstanceInfo.GetDeclaration();
declarationList[num++] = TableRowInstanceInfo.GetDeclaration();
declarationList[num++] = OWCChartInstanceInfo.GetDeclaration();
declarationList[num++] = ChartInstanceInfo.GetDeclaration();
declarationList[num++] = NonComputedUniqueNames.GetDeclaration();
declarationList[num++] = InstanceInfoOwner.GetDeclaration();
declarationList[num++] = ReportItemInstance.GetDeclaration();
num++;
declarationList[num++] = ReportInstance.GetDeclaration();
declarationList[num++] = ReportItemColInstance.GetDeclaration();
declarationList[num++] = LineInstance.GetDeclaration();
declarationList[num++] = TextBoxInstance.GetDeclaration();
declarationList[num++] = RectangleInstance.GetDeclaration();
declarationList[num++] = CheckBoxInstance.GetDeclaration();
declarationList[num++] = ImageInstance.GetDeclaration();
declarationList[num++] = SubReportInstance.GetDeclaration();
declarationList[num++] = ActiveXControlInstance.GetDeclaration();
declarationList[num++] = ListInstance.GetDeclaration();
declarationList[num++] = ListContentInstance.GetDeclaration();
num++;
declarationList[num++] = MatrixInstance.GetDeclaration();
declarationList[num++] = MatrixHeadingInstance.GetDeclaration();
num++;
declarationList[num++] = MatrixCellInstance.GetDeclaration();
num++;
num++;
declarationList[num++] = TableInstance.GetDeclaration();
declarationList[num++] = TableRowInstance.GetDeclaration();
declarationList[num++] = TableColumnInstance.GetDeclaration();
declarationList[num++] = TableGroupInstance.GetDeclaration();
num++;
declarationList[num++] = OWCChartInstance.GetDeclaration();
declarationList[num++] = ParameterInfo.GetDeclaration();
num++;
num++;
num++;
declarationList[num++] = InstanceInfo.GetDeclaration();
num++;
declarationList[num++] = RecordSetInfo.GetDeclaration();
declarationList[num++] = RecordRow.GetDeclaration();
declarationList[num++] = RecordField.GetDeclaration();
declarationList[num++] = ValidValue.GetDeclaration();
num++;
declarationList[num++] = ParameterDataSource.GetDeclaration();
declarationList[num++] = ParameterDef.GetDeclaration();
num++;
declarationList[num++] = ParameterBase.GetDeclaration();
num++;
declarationList[num++] = ProcessingMessage.GetDeclaration();
declarationList[num++] = MatrixSubtotalHeadingInstanceInfo.GetDeclaration();
declarationList[num++] = MatrixSubtotalCellInstance.GetDeclaration();
declarationList[num++] = CodeClass.GetDeclaration();
num++;
declarationList[num++] = TableDetail.GetDeclaration();
declarationList[num++] = TableDetailInstance.GetDeclaration();
num++;
declarationList[num++] = TableDetailInstanceInfo.GetDeclaration();
num++;
declarationList[num++] = Action.GetDeclaration();
declarationList[num++] = ActionInstance.GetDeclaration();
declarationList[num++] = Chart.GetDeclaration();
declarationList[num++] = ChartHeading.GetDeclaration();
declarationList[num++] = ChartDataPoint.GetDeclaration();
num++;
declarationList[num++] = MultiChart.GetDeclaration();
declarationList[num++] = MultiChartInstance.GetDeclaration();
num++;
declarationList[num++] = Axis.GetDeclaration();
declarationList[num++] = AxisInstance.GetDeclaration();
declarationList[num++] = ChartTitle.GetDeclaration();
declarationList[num++] = ChartTitleInstance.GetDeclaration();
declarationList[num++] = ThreeDProperties.GetDeclaration();
declarationList[num++] = PlotArea.GetDeclaration();
declarationList[num++] = Legend.GetDeclaration();
declarationList[num++] = GridLines.GetDeclaration();
declarationList[num++] = ChartDataLabel.GetDeclaration();
declarationList[num++] = ChartInstance.GetDeclaration();
declarationList[num++] = ChartHeadingInstance.GetDeclaration();
declarationList[num++] = ChartHeadingInstanceInfo.GetDeclaration();
num++;
declarationList[num++] = ChartDataPointInstance.GetDeclaration();
declarationList[num++] = ChartDataPointInstanceInfo.GetDeclaration();
num++;
num++;
declarationList[num++] = RenderingPagesRanges.GetDeclaration();
num++;
declarationList[num++] = IntermediateFormatVersion.GetDeclaration();
declarationList[num++] = ImageInfo.GetDeclaration();
declarationList[num++] = ActionItem.GetDeclaration();
declarationList[num++] = ActionItemInstance.GetDeclaration();
num++;
num++;
declarationList[num++] = DataValue.GetDeclaration();
declarationList[num++] = DataValueInstance.GetDeclaration();
num++;
num++;
declarationList[num++] = Tablix.GetDeclaration();
declarationList[num++] = TablixHeading.GetDeclaration();
declarationList[num++] = CustomReportItem.GetDeclaration();
declarationList[num++] = CustomReportItemInstance.GetDeclaration();
declarationList[num++] = CustomReportItemHeading.GetDeclaration();
declarationList[num++] = CustomReportItemHeadingInstance.GetDeclaration();
num++;
num++;
num++;
num++;
declarationList[num++] = CustomReportItemCellInstance.GetDeclaration();
num++;
num++;
declarationList[num++] = DataValueCRIList.GetDeclaration();
declarationList[num++] = BookmarkInformation.GetDeclaration();
declarationList[num++] = InstanceInfo.GetDeclaration();
declarationList[num++] = DrillthroughInformation.GetDeclaration();
declarationList[num++] = InstanceInfo.GetDeclaration();
num++;
declarationList[num++] = CustomReportItemInstanceInfo.GetDeclaration();
declarationList[num++] = ImageMapAreaInstanceList.GetDeclaration();
declarationList[num++] = ImageMapAreaInstance.GetDeclaration();
num++;
declarationList[num++] = InstanceInfo.GetDeclaration();
declarationList[num++] = SortFilterEventInfo.GetDeclaration();
declarationList[num++] = EndUserSort.GetDeclaration();
num++;
num++;
declarationList[num++] = RecordSetPropertyNames.GetDeclaration();
num++;
num++;
num++;
declarationList[num++] = PageSectionInstance.GetDeclaration();
num++;
declarationList[num++] = PageSectionInstanceInfo.GetDeclaration();
declarationList[num++] = SimpleTextBoxInstanceInfo.GetDeclaration();
declarationList[num++] = ScopeLookupTable.GetDeclaration();
num++;
declarationList[num++] = ReportDrillthroughInfo.GetDeclaration();
declarationList[num++] = InstanceInfo.GetDeclaration();
Global.Tracer.Assert(declarationList.Count == num, "(current.Count == index)");
return(declarationList);
}
public static bool ShowRightDataGridView(DataGridView rightgrid, ChartColumn col, string zid)
{
string sql = "";
DataTable dt = null;
if (col.ShowName.IndexOf("年") >= 0)
{
if (col.TableName == "st_dt")
{
sql = string.Format("select {0}.{1} as '{2}',count(distinct {0}.sid) as 专利数 from {0} where {0}.ztid={3} group by {0}.{1} order by {0}.{1} asc", col.TableName, col.ColName, col.ShowName, zid);
}
else
{
sql = string.Format("select {0}.{1} as '{2}',count(distinct {0}.sid) as 专利数 from {0},st_dt where {0}.sid=st_dt.sid and st_dt.ztid={3} group by {0}.{1} order by {0}.{1} asc", col.TableName, col.ColName, col.ShowName, zid);
}
dt = DBA.MySqlDbAccess.GetDataTable(CommandType.Text, sql);
dt = DataTableHelper.ReadDateTable(dt);
}
else
{
if (col.TableName == "st_dt")
{
sql = string.Format("select {0}.{1} as '{2}',count(distinct {0}.sid) as 专利数 from {0} where ztid={3} group by {0}.{1} order by count(distinct {0}.sid) desc", col.TableName, col.ColName, col.ShowName, zid);
}
else
{
sql = string.Format("select {0}.{1} as '{2}',count(distinct {0}.sid) as 专利数 from {0},st_dt where {0}.sid=st_dt.sid and st_dt.ztid={3} group by {0}.{1} order by count(distinct {0}.sid) desc", col.TableName, col.ColName, col.ShowName, zid);
}
dt = DBA.MySqlDbAccess.GetDataTable(CommandType.Text, sql);
}
string[] types = null;
switch (col.ShowName)
{
case "专利类型(含PCT)":
types = new string[] { "发明专利", "实用新型", "外观专利", "发明专利PCT", "实用新型PCT" };
break;
case "专利类型":
types = new string[] { "发明专利", "实用新型", "外观专利" };
break;
case "申请人类型":
case "第一申请人类型":
types = new string[] { "企业", "科研院所", "高校", "事业单位", "个人" };
break;
case "法律状态":
types = new string[] { "在审", "授权有效", "授权失效", "无效" };
break;
}
if (types != null)
{
DataTable tmpdt = new DataTable();
tmpdt.Columns.Add(col.ShowName);
tmpdt.Columns.Add("专利数");
foreach (var type in types)
{
DataRow tmprow = tmpdt.NewRow();
var x = from y in dt.AsEnumerable()
where y[0].ToString() == type
select y;
if (x.Count() == 0)
{
tmprow[0] = type;
tmprow[1] = 0;
}
else
{
tmprow[0] = type;
tmprow[1] = x.First()[1].ToString();
}
tmpdt.Rows.Add(tmprow);
}
rightgrid.DataSource = tmpdt;
}
else
{
rightgrid.DataSource = dt;
}
rightgrid.Columns[rightgrid.Columns.Count - 1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
return(true);
}
public static string GetStatSQL(string zid, CheckedListBox cklistzhibiao, ComboBox cmbgroupcolumn, DataGridView dgwhere, ComboBox cmbStartDate, ComboBox cmbEndDate)
{
string strzhibiao = "";
string columns = "";
string join = "";
string groupby = "";
string wherezt = "st_dt.ztid =" + zid;
string where = "";
string tables = "";
string sql = "select {0},{1} from {2} where {3} {4} {5} group by {6}";
List <string> tablenames = new List <string>();
//for (int i = 0; i <= cklistzhibiao.CheckedItems.Count - 1; i++)
//{
// ChartZHIbiAO x = (ChartZHIbiAO)cklistzhibiao.CheckedItems[i];
// string tmpzhibiao = string.Format("{0}(distinct {1}.{2} ) as '{3}',", x.FunCType, x.TableName, x.ZHiBIAO, x.ShowName);
// tablenames.Add(x.TableName);
// strzhibiao += tmpzhibiao;
//}
//strzhibiao = strzhibiao.Trim(',');
strzhibiao = " count(distinct st_dt.sid) as '申请量' ";
ChartColumn group = (ChartColumn)cmbgroupcolumn.SelectedItem;
columns = string.Format("{0}.{1} as '{2}'", group.TableName, group.ColName, group.ShowName);
groupby = string.Format("{0}.{1}", group.TableName, group.ColName, group.ShowName);
tablenames.Add(group.TableName);
if (cmbStartDate.Enabled && cmbEndDate.Enabled)
{
where += string.Format(" and {0}.{1} between {2} and {3}", group.TableName, group.ColName, cmbStartDate.Text, cmbEndDate.Text);
}
tablenames = tablenames.Distinct().ToList <string>();
tablenames.Remove("st_dt");
tablenames.Add("st_dt");
foreach (var tb in tablenames)
{
tables += tb + ",";
}
tables = tables.Trim(',');
if (tablenames.Count > 1)
{
for (int i = 1; i < tablenames.Count; i++)
{
if (join == "")
{
join += string.Format("{0}.sid={1}.sid", tablenames[0], tablenames[i]);
}
else
{
join += string.Format(" and {0}.sid={1}.sid", tablenames[0], tablenames[i]);
}
}
}
if (join == "")
{
wherezt = string.Format("st_dt.ztid={0}", zid);
}
else
{
wherezt = string.Format(" and st_dt.ztid={0}", zid);
}
string tmpsql = string.Format(sql, columns, strzhibiao, tables, join, wherezt, where, groupby);
return(tmpsql);
}
public void updateChartModel(VsChartModel model)
{
//MessageBox.Show(System.IO.Directory.GetCurrentDirectory());
try
{
m_chartSample1.ChartDescription.Columns.Clear();
m_panelChartLegend.ChartLegendDescription.Items.Clear();
if (model.dataModel.Count > 0)
{
//MessageBox.Show("this" +model.dataModel.Count );
//list<colum<value>>
List <List <int> > data = new List <List <int> >();
List <string> cams = new List <string>();
foreach (string head in model.headerNsme)
{
data.Add(new List <int>());
}
foreach (KeyValuePair <string, List <int> > kvp in model.dataModel)
{
//ChartColumn column = m_chartSample1.AddColumn(kvp);
int sum = 0;
int c = 0;
bool zeroValue = true;
foreach (int v in kvp.Value)
{
if (v > 0)
{
zeroValue = false;
break;
}
}
if (zeroValue)//debuggg
{
//c = 0;
foreach (int v in kvp.Value)
{
data[c].Add(v + 1);
sum = 0;
c++;
}
//MessageBox.Show("rero");
}
else
{
foreach (int v in kvp.Value)
{
data[c].Add(v);
//MessageBox.Show(">0");
sum += v;
c++;
}
}
cams.Add(kvp.Key);
}
int cc = 0;
foreach (string head in model.headerNsme)
{
ChartColumn column = m_chartSample1.AddColumn(data[cc].ToArray());
cc++;
column.Title = head;
}
Color[] predefinedColors = m_chartSample1.ChartDescription.PredefinedColors;
for (int i = 0; i < m_chartSample1.ChartDescription.NumberOfItemsPerColumn; i++)
{
m_panelChartLegend.AddItem(predefinedColors[i], cams[i]);
}
this.m_chartSample1.ChartDescription.VerticalAxisStep = 10000;//for auto set when step over
m_chartSample1.ChartDescription.BottomMargin = 80;
m_chartSample1.ChartDescription.MainTitle = model.mainTitle;
//m_chartSample1.ChartDescription.RenderingMode = ChartRenderingMode.Linear3d;
m_chartSample1.ChartDescription.DisplayHiddenSides = false;
m_chartSample1.CumulativeMode = ChartCumulativeMode.StartFrom0;
this.m_chartSample1.ChartDescription.VerticalAxisMinValue = 1;//for buggggggggggg?????????
}
m_panelChartLegend.Invalidate();
m_chartSample1.Invalidate();
}
catch (Exception err)
{
logger.Log(LogLevel.Error, err.Message + " " + err.Source + " " + err.StackTrace);;
}
}
public static string GetStatSQL(string zid, stcfg cfg, CheckedListBox cklistzhibiao, ComboBox cmbgroupcolumn)
{
string strzhibiao = "";
string columns = "";
string join = "";
string groupby = "";
string wherezt = "st_dt.ztid =" + zid;
string where = "";
string tables = "";
string sql = "select {0},{1} from {2} where {3} {4} {5} group by {6}";
List <string> tablenames = new List <string>();
tablenames.Add("st_iv");
strzhibiao = " count(distinct st_iv.iv) as '发明人数量' ";
ChartColumn group = (ChartColumn)cmbgroupcolumn.SelectedItem;
columns = string.Format("{0}.{1} as '{2}'", group.TableName, group.ColName, group.ShowName);
groupby = string.Format("{0}.{1}", group.TableName, group.ColName, group.ShowName);
tablenames.Add(group.TableName);
if (cfg.StartYear != 0 && cfg.EndYear != 0)
{
where += string.Format(" and {0}.{1} between {2} and {3}", group.TableName, group.ColName, cfg.StartYear, cfg.EndYear);
}
tablenames = tablenames.Distinct().ToList <string>();
tablenames.Remove("st_dt");
tablenames.Add("st_dt");
foreach (var tb in tablenames)
{
tables += tb + ",";
}
tables = tables.Trim(',');
if (tablenames.Count > 1)
{
for (int i = 1; i < tablenames.Count; i++)
{
if (join == "")
{
join += string.Format("{0}.sid={1}.sid", tablenames[0], tablenames[i]);
}
else
{
join += string.Format(" and {0}.sid={1}.sid", tablenames[0], tablenames[i]);
}
}
}
if (join == "")
{
wherezt = string.Format("st_dt.ztid={0}", zid);
}
else
{
wherezt = string.Format(" and st_dt.ztid={0}", zid);
}
string tmpsql = string.Format(sql, columns, strzhibiao, tables, join, wherezt, where, groupby);
return(tmpsql);
}
public void ShouldThrowExceptionIfNameIsNull()
{
Assert.Throws<ArgumentNullException>(delegate { ChartColumn test = new ChartColumn(null, ColumnType.String); });
}
public void ShouldThrowExceptionIfNameIsEmpty()
{
Assert.Throws<ArgumentException>(delegate { ChartColumn test = new ChartColumn(String.Empty, ColumnType.String); });
}
public void ShouldInstantiateColumnClass()
{
ChartColumn test = new ChartColumn("Test",ColumnType.String);
Assert.IsInstanceOf<ChartColumn>(test);
}
void FillInterface()
{
//
// Chart 1
//
ChartColumn column1 = m_chartSample1.AddColumn(-5000, 0, 0, 2500);
ChartColumn column2 = m_chartSample1.AddColumn(0, 0, 2000, 0);
ChartColumn column3 = m_chartSample1.AddColumn(0, -3000, 0, 0);
ChartColumn column4 = m_chartSample1.AddColumn(-500, -1000, -2508, -500);
ChartColumn column5 = m_chartSample1.AddColumn(100, 250, 45, 800);
ChartColumn column6 = m_chartSample1.AddColumn(0, 0, 0, 0);
ChartColumn column7 = m_chartSample1.AddColumn(753, 200, 120, 475);
ChartColumn column8 = m_chartSample1.AddColumn(753, 200, 120, 475);
column1.Title = "January";
column2.Title = "February";
column3.Title = "March";
column4.Title = "April";
column5.Title = "May";
column6.Title = "June";
column7.Title = "July";
column8.Title = "August";
m_chartSample1.ChartDescription.BottomMargin = 80;
m_chartSample1.ChartDescription.MainTitle = "One year evolution";
m_chartSample1.ChartDescription.RenderingMode = ChartRenderingMode.Linear3d;
m_chartSample1.ChartDescription.DisplayHiddenSides = false;
m_chartSample1.CumulativeMode = ChartCumulativeMode.StartFrom0;
//
// Chart 2
//
m_chartSample2.AddColumn(-5000, 210, 0, 500);
m_chartSample2.AddColumn(500, 210, -2000, 150);
m_chartSample2.AddColumn(3000, 220, 150, 275);
m_chartSample2.AddColumn(-500, -1000, -2508, -500);
m_chartSample2.AddColumn(100, 250, 45, 800);
m_chartSample2.AddColumn(0, -1000, 0, 0);
m_chartSample2.AddColumn(0, 0, 3860, 0);
m_chartSample2.ChartDescription.RenderingMode = ChartRenderingMode.BarWith3dGradient;
m_chartSample2.CumulativeMode = ChartCumulativeMode.StartFromLastValue;
//
// Chart 3
//
m_chartSample3.AddColumn(90, 5);
m_chartSample3.AddColumn(50, 30);
m_chartSample3.AddColumn(5, 5);
m_chartSample3.AddColumn(20, 10);
m_chartSample3.AddColumn(85, 10);
m_chartSample3.AddColumn(0, 30);
m_chartSample3.AddColumn(40, 20);
m_chartSample3.ChartDescription.RenderingMode = ChartRenderingMode.BarWith3dGradient;
m_chartSample3.CumulativeMode = ChartCumulativeMode.StartFromLastValue;
//
// Legend
//
m_panelChartLegend.ChartLegendDescription.MainTitle = "Who's who";
Color[] predefinedColors = m_chartSample1.ChartDescription.PredefinedColors;
string[] legend = { "Man", "Woman", "Boy", "Girl" };
for (int i = 0; i < m_chartSample1.ChartDescription.NumberOfItemsPerColumn; i++)
{
m_panelChartLegend.AddItem(predefinedColors[i], legend [i]);
}
}
public OWCChartColumn(ChartColumn chartColumnDef, ArrayList columnData)
{
this.m_chartColumnDef = chartColumnDef;
this.m_data = columnData;
}
internal OWCChartColumn(ChartColumn chartColumnDef, ArrayList columnData)
{
m_chartColumnDef = chartColumnDef;
m_data = columnData;
}
