private void btnCreate_Click(object sender, EventArgs e)
{
config.PieLabelStyle = picLabelStyles[cmbLabelStyle.Text];
try
{
st = StatFactury.CreateStata(this.lib_Name.Text, config, chart1, showdata);
}
catch (Exception ex)
{
MessageBox.Show("请在左侧选择统计指标后，点击【生成表图】", "提示");
return;
}
pnlChart.Visible = true;
btnExport.Visible = true;
resizeMiddlePanel();
List<string> cols;
List<string> rows;
List<int> colindexs;
this.chart1.Titles[0].Text = this.lib_Name.Text;
chart1.ChartAreas[0].AxisX.Interval = 1;
chart1.ChartAreas[0].AxisX.IntervalOffset = 1;
chart1.ChartAreas[0].AxisX.LabelStyle.IsStaggered = false;
switch (this.lib_Name.Text)
{
#region 趋势
case "专利趋势分析":
st.Stat();
st.Dt = DataTableHelper.ReadDateTable(st.Dt);
st.DrawingLineChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "技术生命周期分析":
st.Stat();
st.Dt = DataTableHelper.ReadDateTable(st.Dt);
this.chart1.ChartAreas[0].AxisY.Minimum = 0;
chart1.ChartAreas[0].AxisX.IntervalAutoMode = IntervalAutoMode.VariableCount;
chart1.ChartAreas[0].AxisX.LabelStyle.IsStaggered = true;
chart1.ChartAreas[0].AxisX.Interval = 0;
chart1.ChartAreas[0].AxisX.IntervalOffset = 0;
st.DrawingLineChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.ShowDataGridView();
//dt = st.Dt;
//showLine1(st.Dt);
break;
case "发明人增速趋势分析":
st.Stat();
st.Dt = DataTableHelper.ReadDateTable(st.Dt);
st.DrawingLineChart();
st.Dt = DataTableHelper.AddZengSu(st.Dt, new List<int>() { 1 });
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "专利类型分布趋势分析":
st.Stat();
cols = config.TopType.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt, cols);
st.Dt = DataTableHelper.ReadDateTable(st.Dt);
st.DrawingLineChart();
colindexs = new List<int>();
for (int i = 1; i <= cols.Count; i++)
{
colindexs.Add(i);
}
this.showdata.Columns.Clear();
st.Dt = DataTableHelper.AddZengSu(st.Dt, colindexs);
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
#endregion
#region 区域
case "区域专利申请比重分析":
st.Stat();
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
grpPic.Visible = true;
break;
case "区域专利申请趋势分析":
st.Stat();
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt);
st.Dt = DataTableHelper.ReadDateTable(st.Dt);
st.DrawingLineChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "区域专利申请人分析":
st.Stat();
cols = config.TopPA.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt, cols);
st.DrawingColumnChart();
rows = config.TopQY.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.FillColumn(st.Dt, rows);
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "区域专利发明人分析":
st.Stat();
cols = config.TopIN.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt, cols);
st.DrawingColumnChart();
rows = config.TopQY.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.FillColumn(st.Dt, rows);
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "区域专利技术构成分析":
st.Stat();
cols = config.TopIPC.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt, cols);
st.DrawingColumnChart();
rows = config.TopQY.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.FillColumn(st.Dt, rows);
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "区域首次专利申请分析":
st.Stat();
st.DrawingPointChart();
rows = config.TopQY.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.FillColumn(st.Dt, rows);
st.ShowDataGridView();
break;
#endregion
#region 申请人
//申请人专利排名分析
case "申请人专利排名分析":
st.Stat();
grpPic.Visible = true;
rows = config.TopPA.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.FillColumn(st.Dt, rows);
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "申请人类型分析":
st.Stat();
cols = config.TopPAType.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.FillColumn(st.Dt, cols);
st.DrawingColumnChart();
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "申请人趋势分析":
st.Stat();
cols = config.TopPA.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt, cols);
st.DrawingLineChart();
rows = config.TopYear.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.FillColumn1(st.Dt, rows);
st.Dt = DataTableHelper.ReadDateTable(st.Dt);
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "申请人首次专利申请分析":
st.Stat();
st.DrawingPointChart();
rows = config.TopPA.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.FillColumn(st.Dt, rows);
st.ShowDataGridView();
break;
case "申请人专利类型分析":
st.Stat();
cols = config.TopType.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt, cols);
st.DrawingColumnChart();
rows = config.TopPA.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.FillColumn(st.Dt, rows);
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
//申请人专利布局动向分析
case "申请人专利布局动向分析":
st.Stat();
cols = config.TopQY.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt, cols);
st.DrawingColumnChart();
rows = config.TopPA.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.FillColumn(st.Dt, rows);
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "申请人专利技术构成分析":
st.Stat();
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt);
st.DrawingStackedColumnChart();
rows = config.TopPA.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.FillColumn(st.Dt, rows);
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "申请人研发阵容分析":
st.Stat();
rows = config.TopPA.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.FillColumn(st.Dt, rows);
st.ShowDataGridView();
pnlChart.Visible = false;
break;
case "申请人专利合作分析":
st.Stat();
rows = config.TopPA.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.FillColumn(st.Dt, rows);
st.ShowDataGridView();
pnlChart.Visible = false;
break;
case "发明人专利排名分析":
st.Stat();
grpPic.Visible = true;
rows = config.TopIN.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.FillColumn(st.Dt, rows);
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "发明人专利技术构成分析":
st.Stat();
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt);
st.DrawingStackedColumnChart();
rows = config.TopIN.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.FillColumn(st.Dt, rows);
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
#endregion
#region 技术
case "专利技术构成分析":
st.Stat();
grpPic.Visible = true;
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "专利技术趋势分析":
st.Stat();
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt);
st.Dt = DataTableHelper.ReadDateTable(st.Dt);
st.DrawingLineChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "专利技术区域分析":
st.Stat();
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt);
st.DrawingStackedColumnChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "专利技术申请人分析":
st.Stat();
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt);
st.DrawingStackedColumnChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
#endregion
#region 法律状态
case "专利法律状态分析":
st.Stat();
cols = config.TopLG.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.FillColumn(st.Dt, cols);
grpPic.Visible = true;
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "专利存活期分析":
st.Stat();
grpPic.Visible = true;
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "有效专利维持期分析":
st.Stat();
grpPic.Visible = true;
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "申请人法律状态分析":
st.Stat();
cols = config.TopLG.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt, cols);
st.DrawingStackedColumnChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "区域法律状态分析":
st.Stat();
grpPic.Visible = true;
cols = config.TopLG.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt, cols);
st.DrawingStackedColumnChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "技术领域法律状态分析":
st.Stat();
grpPic.Visible = true;
cols = config.TopLG.Replace("'", "").Split(',').ToList<string>();
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt, cols);
st.DrawingStackedColumnChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "公知技术统计分析":
st.Stat();
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "专利审查周期分析":
st.Stat();
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "法律状态自定义分析":
break;
case "中国本土专利趋势":
st.Stat();
grpPic.Visible = true;
st.Dt = DataTableHelper.ReadDateTable(st.Dt);
st.DrawingLineChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "中美市场专利趋势":
st.Stat();
grpPic.Visible = true;
cols = new List<string>() { "中国", "美国" };
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt, cols);
st.Dt = DataTableHelper.ReadDateTable(st.Dt);
st.DrawingLineChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "中欧市场专利趋势":
st.Stat();
cols = new List<string>() { "中国", "欧洲专利局" };
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt, cols);
st.Dt = DataTableHelper.ReadDateTable(st.Dt);
st.DrawingLineChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "中国市场重点技术排行榜":
st.Stat();
grpPic.Visible = true;
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "中国市场专利申请人排行榜":
st.Stat();
grpPic.Visible = true;
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "中国市场布局国家排行榜":
st.Stat();
grpPic.Visible = true;
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "美国本土专利趋势":
st.Stat();
grpPic.Visible = true;
st.Dt = DataTableHelper.ReadDateTable(st.Dt);
st.DrawingLineChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "美欧市场专利趋势":
st.Stat();
cols = new List<string>() { "美国", "欧洲专利局" };
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt, cols);
st.Dt = DataTableHelper.ReadDateTable(st.Dt);
st.DrawingLineChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "美国市场重点技术排行榜":
st.Stat();
grpPic.Visible = true;
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "美国市场专利申请人排行榜":
st.Stat();
grpPic.Visible = true;
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "美国市场布局国家排行榜":
st.Stat();
grpPic.Visible = true;
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "欧洲本土专利趋势":
st.Stat();
grpPic.Visible = true;
st.Dt = DataTableHelper.ReadDateTable(st.Dt);
st.DrawingLineChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "德国市场专利趋势":
st.Stat();
cols = new List<string>() { "德国" };
st.Dt = DataTableHelper.ExchangeRowColumn(st.Dt, cols);
st.Dt = DataTableHelper.ReadDateTable(st.Dt);
st.DrawingLineChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "欧洲市场重点技术排行榜":
st.Stat();
grpPic.Visible = true;
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "欧洲市场专利申请人排行榜":
st.Stat();
grpPic.Visible = true;
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "欧洲市场布局国家排行榜":
st.Stat();
grpPic.Visible = true;
st.Dt = DataTableHelper.AddPercentColumn(st.Dt, new List<int>() { 1 });
st.DrawingPicChart();
st.Dt = DataTableHelper.AddSumRow(st.Dt);
st.Dt = DataTableHelper.AddSumColumn(st.Dt);
st.ShowDataGridView();
break;
case "国内专利储备不足预警":
case "国内专利数量泡沫预警":
case "国内专利创新增速预警":
case "国内领军者专利创新力预警":
case "国内专利组合集中度预警":
case "美国市场专利壁垒预警":
case "欧洲市场专利壁垒预警":
case "日本市场专利壁垒预警":
pnlChart.Visible = false;
st.Stat();
st.ShowDataGridView();
break;
case "国内专利技术差距预警":
case "国外重点国家布局预警":
st.Stat();
grpPic.Visible = true;
st.DrawingColumnChart();
st.ShowDataGridView();
break;
#endregion
}
}
