diff --git a/FrmAllPipelineStatis.cs b/FrmAllPipelineStatis.cs index 6a93188..e9a4ae7 100644 --- a/FrmAllPipelineStatis.cs +++ b/FrmAllPipelineStatis.cs @@ -116,11 +116,19 @@ if (total > 0) { string strLable = "共有：" + Convert.ToString(total) + "条记录" - + " 管线里程：" + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") - + " 米"; - PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, m_InitDataGridViewX1, strLable, pipetype,fs,fields); + + " 管线里程：" + + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") + + " 米"; + PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, + m_InitDataGridViewX1, strLable, pipetype, fs, fields); pagination.FillDataGridView(); } + else + { + + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查到符合条件的数据"); + } } private void chartAllAreaPipeline_MouseMove(object sender, MouseEventArgs e) diff --git a/FrmAllPipelineStatis.cs b/FrmAllPipelineStatis.cs index 6a93188..e9a4ae7 100644 --- a/FrmAllPipelineStatis.cs +++ b/FrmAllPipelineStatis.cs @@ -116,11 +116,19 @@ if (total > 0) { string strLable = "共有：" + Convert.ToString(total) + "条记录" - + " 管线里程：" + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") - + " 米"; - PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, m_InitDataGridViewX1, strLable, pipetype,fs,fields); + + " 管线里程：" + + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") + + " 米"; + PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, + m_InitDataGridViewX1, strLable, pipetype, fs, fields); pagination.FillDataGridView(); } + else + { + + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查到符合条件的数据"); + } } private void chartAllAreaPipeline_MouseMove(object sender, MouseEventArgs e) diff --git a/FrmAllWorkWellStatis.cs b/FrmAllWorkWellStatis.cs index 25dce60..f253369 100644 --- a/FrmAllWorkWellStatis.cs +++ b/FrmAllWorkWellStatis.cs @@ -128,9 +128,15 @@ { string strLable = " 井盖类型：" + pipetype + "||共有：" + Convert.ToString(total) + "条记录"; string sql = PaginationUtil.GetQuerySql(globeControl1, layername, "编号", list); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, strLable, layername); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, + strLable, layername); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查询到符合条件的数据"); + } } diff --git a/FrmAllPipelineStatis.cs b/FrmAllPipelineStatis.cs index 6a93188..e9a4ae7 100644 --- a/FrmAllPipelineStatis.cs +++ b/FrmAllPipelineStatis.cs @@ -116,11 +116,19 @@ if (total > 0) { string strLable = "共有：" + Convert.ToString(total) + "条记录" - + " 管线里程：" + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") - + " 米"; - PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, m_InitDataGridViewX1, strLable, pipetype,fs,fields); + + " 管线里程：" + + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") + + " 米"; + PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, + m_InitDataGridViewX1, strLable, pipetype, fs, fields); pagination.FillDataGridView(); } + else + { + + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查到符合条件的数据"); + } } private void chartAllAreaPipeline_MouseMove(object sender, MouseEventArgs e) diff --git a/FrmAllWorkWellStatis.cs b/FrmAllWorkWellStatis.cs index 25dce60..f253369 100644 --- a/FrmAllWorkWellStatis.cs +++ b/FrmAllWorkWellStatis.cs @@ -128,9 +128,15 @@ { string strLable = " 井盖类型：" + pipetype + "||共有：" + Convert.ToString(total) + "条记录"; string sql = PaginationUtil.GetQuerySql(globeControl1, layername, "编号", list); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, strLable, layername); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, + strLable, layername); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查询到符合条件的数据"); + } } diff --git a/FrmBasicQuery.cs b/FrmBasicQuery.cs index cb07576..3fe748e 100644 --- a/FrmBasicQuery.cs +++ b/FrmBasicQuery.cs @@ -230,6 +230,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查找到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmAllPipelineStatis.cs b/FrmAllPipelineStatis.cs index 6a93188..e9a4ae7 100644 --- a/FrmAllPipelineStatis.cs +++ b/FrmAllPipelineStatis.cs @@ -116,11 +116,19 @@ if (total > 0) { string strLable = "共有：" + Convert.ToString(total) + "条记录" - + " 管线里程：" + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") - + " 米"; - PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, m_InitDataGridViewX1, strLable, pipetype,fs,fields); + + " 管线里程：" + + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") + + " 米"; + PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, + m_InitDataGridViewX1, strLable, pipetype, fs, fields); pagination.FillDataGridView(); } + else + { + + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查到符合条件的数据"); + } } private void chartAllAreaPipeline_MouseMove(object sender, MouseEventArgs e) diff --git a/FrmAllWorkWellStatis.cs b/FrmAllWorkWellStatis.cs index 25dce60..f253369 100644 --- a/FrmAllWorkWellStatis.cs +++ b/FrmAllWorkWellStatis.cs @@ -128,9 +128,15 @@ { string strLable = " 井盖类型：" + pipetype + "||共有：" + Convert.ToString(total) + "条记录"; string sql = PaginationUtil.GetQuerySql(globeControl1, layername, "编号", list); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, strLable, layername); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, + strLable, layername); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查询到符合条件的数据"); + } } diff --git a/FrmBasicQuery.cs b/FrmBasicQuery.cs index cb07576..3fe748e 100644 --- a/FrmBasicQuery.cs +++ b/FrmBasicQuery.cs @@ -230,6 +230,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查找到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmCodingQuery.cs b/FrmCodingQuery.cs index 9d6cc0c..9987842 100644 --- a/FrmCodingQuery.cs +++ b/FrmCodingQuery.cs @@ -86,11 +86,17 @@ int total = PaginationUtil.CountSql(comboBoxEx1.Text.Trim(), "编号", textBoxX1.Text); if (total > 0) { - string strLable = comboBoxEx1.Text + "共有:" + total + "条"; + string strLable = comboBoxEx1.Text + "共有:" + total + "条"; string sql = PaginationUtil.GetQuerySql(globeControl1, comboBoxEx1.Text.Trim(), "编号", textBoxX1.Text); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1,strLable, comboBoxEx1.Text); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, + m_InitDataGridViewX1, strLable, comboBoxEx1.Text); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有符合条件的数据"); + } } catch (Exception ex) diff --git a/FrmAllPipelineStatis.cs b/FrmAllPipelineStatis.cs index 6a93188..e9a4ae7 100644 --- a/FrmAllPipelineStatis.cs +++ b/FrmAllPipelineStatis.cs @@ -116,11 +116,19 @@ if (total > 0) { string strLable = "共有：" + Convert.ToString(total) + "条记录" - + " 管线里程：" + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") - + " 米"; - PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, m_InitDataGridViewX1, strLable, pipetype,fs,fields); + + " 管线里程：" + + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") + + " 米"; + PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, + m_InitDataGridViewX1, strLable, pipetype, fs, fields); pagination.FillDataGridView(); } + else + { + + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查到符合条件的数据"); + } } private void chartAllAreaPipeline_MouseMove(object sender, MouseEventArgs e) diff --git a/FrmAllWorkWellStatis.cs b/FrmAllWorkWellStatis.cs index 25dce60..f253369 100644 --- a/FrmAllWorkWellStatis.cs +++ b/FrmAllWorkWellStatis.cs @@ -128,9 +128,15 @@ { string strLable = " 井盖类型：" + pipetype + "||共有：" + Convert.ToString(total) + "条记录"; string sql = PaginationUtil.GetQuerySql(globeControl1, layername, "编号", list); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, strLable, layername); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, + strLable, layername); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查询到符合条件的数据"); + } } diff --git a/FrmBasicQuery.cs b/FrmBasicQuery.cs index cb07576..3fe748e 100644 --- a/FrmBasicQuery.cs +++ b/FrmBasicQuery.cs @@ -230,6 +230,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查找到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmCodingQuery.cs b/FrmCodingQuery.cs index 9d6cc0c..9987842 100644 --- a/FrmCodingQuery.cs +++ b/FrmCodingQuery.cs @@ -86,11 +86,17 @@ int total = PaginationUtil.CountSql(comboBoxEx1.Text.Trim(), "编号", textBoxX1.Text); if (total > 0) { - string strLable = comboBoxEx1.Text + "共有:" + total + "条"; + string strLable = comboBoxEx1.Text + "共有:" + total + "条"; string sql = PaginationUtil.GetQuerySql(globeControl1, comboBoxEx1.Text.Trim(), "编号", textBoxX1.Text); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1,strLable, comboBoxEx1.Text); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, + m_InitDataGridViewX1, strLable, comboBoxEx1.Text); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有符合条件的数据"); + } } catch (Exception ex) diff --git a/FrmDiameterQuery.cs b/FrmDiameterQuery.cs index 5a092fc..6595ee9 100644 --- a/FrmDiameterQuery.cs +++ b/FrmDiameterQuery.cs @@ -179,6 +179,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmAllPipelineStatis.cs b/FrmAllPipelineStatis.cs index 6a93188..e9a4ae7 100644 --- a/FrmAllPipelineStatis.cs +++ b/FrmAllPipelineStatis.cs @@ -116,11 +116,19 @@ if (total > 0) { string strLable = "共有：" + Convert.ToString(total) + "条记录" - + " 管线里程：" + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") - + " 米"; - PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, m_InitDataGridViewX1, strLable, pipetype,fs,fields); + + " 管线里程：" + + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") + + " 米"; + PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, + m_InitDataGridViewX1, strLable, pipetype, fs, fields); pagination.FillDataGridView(); } + else + { + + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查到符合条件的数据"); + } } private void chartAllAreaPipeline_MouseMove(object sender, MouseEventArgs e) diff --git a/FrmAllWorkWellStatis.cs b/FrmAllWorkWellStatis.cs index 25dce60..f253369 100644 --- a/FrmAllWorkWellStatis.cs +++ b/FrmAllWorkWellStatis.cs @@ -128,9 +128,15 @@ { string strLable = " 井盖类型：" + pipetype + "||共有：" + Convert.ToString(total) + "条记录"; string sql = PaginationUtil.GetQuerySql(globeControl1, layername, "编号", list); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, strLable, layername); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, + strLable, layername); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查询到符合条件的数据"); + } } diff --git a/FrmBasicQuery.cs b/FrmBasicQuery.cs index cb07576..3fe748e 100644 --- a/FrmBasicQuery.cs +++ b/FrmBasicQuery.cs @@ -230,6 +230,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查找到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmCodingQuery.cs b/FrmCodingQuery.cs index 9d6cc0c..9987842 100644 --- a/FrmCodingQuery.cs +++ b/FrmCodingQuery.cs @@ -86,11 +86,17 @@ int total = PaginationUtil.CountSql(comboBoxEx1.Text.Trim(), "编号", textBoxX1.Text); if (total > 0) { - string strLable = comboBoxEx1.Text + "共有:" + total + "条"; + string strLable = comboBoxEx1.Text + "共有:" + total + "条"; string sql = PaginationUtil.GetQuerySql(globeControl1, comboBoxEx1.Text.Trim(), "编号", textBoxX1.Text); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1,strLable, comboBoxEx1.Text); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, + m_InitDataGridViewX1, strLable, comboBoxEx1.Text); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有符合条件的数据"); + } } catch (Exception ex) diff --git a/FrmDiameterQuery.cs b/FrmDiameterQuery.cs index 5a092fc..6595ee9 100644 --- a/FrmDiameterQuery.cs +++ b/FrmDiameterQuery.cs @@ -179,6 +179,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmFittingQuery.cs b/FrmFittingQuery.cs index f836f84..3063dab 100644 --- a/FrmFittingQuery.cs +++ b/FrmFittingQuery.cs @@ -76,6 +76,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmAllPipelineStatis.cs b/FrmAllPipelineStatis.cs index 6a93188..e9a4ae7 100644 --- a/FrmAllPipelineStatis.cs +++ b/FrmAllPipelineStatis.cs @@ -116,11 +116,19 @@ if (total > 0) { string strLable = "共有：" + Convert.ToString(total) + "条记录" - + " 管线里程：" + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") - + " 米"; - PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, m_InitDataGridViewX1, strLable, pipetype,fs,fields); + + " 管线里程：" + + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") + + " 米"; + PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, + m_InitDataGridViewX1, strLable, pipetype, fs, fields); pagination.FillDataGridView(); } + else + { + + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查到符合条件的数据"); + } } private void chartAllAreaPipeline_MouseMove(object sender, MouseEventArgs e) diff --git a/FrmAllWorkWellStatis.cs b/FrmAllWorkWellStatis.cs index 25dce60..f253369 100644 --- a/FrmAllWorkWellStatis.cs +++ b/FrmAllWorkWellStatis.cs @@ -128,9 +128,15 @@ { string strLable = " 井盖类型：" + pipetype + "||共有：" + Convert.ToString(total) + "条记录"; string sql = PaginationUtil.GetQuerySql(globeControl1, layername, "编号", list); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, strLable, layername); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, + strLable, layername); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查询到符合条件的数据"); + } } diff --git a/FrmBasicQuery.cs b/FrmBasicQuery.cs index cb07576..3fe748e 100644 --- a/FrmBasicQuery.cs +++ b/FrmBasicQuery.cs @@ -230,6 +230,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查找到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmCodingQuery.cs b/FrmCodingQuery.cs index 9d6cc0c..9987842 100644 --- a/FrmCodingQuery.cs +++ b/FrmCodingQuery.cs @@ -86,11 +86,17 @@ int total = PaginationUtil.CountSql(comboBoxEx1.Text.Trim(), "编号", textBoxX1.Text); if (total > 0) { - string strLable = comboBoxEx1.Text + "共有:" + total + "条"; + string strLable = comboBoxEx1.Text + "共有:" + total + "条"; string sql = PaginationUtil.GetQuerySql(globeControl1, comboBoxEx1.Text.Trim(), "编号", textBoxX1.Text); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1,strLable, comboBoxEx1.Text); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, + m_InitDataGridViewX1, strLable, comboBoxEx1.Text); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有符合条件的数据"); + } } catch (Exception ex) diff --git a/FrmDiameterQuery.cs b/FrmDiameterQuery.cs index 5a092fc..6595ee9 100644 --- a/FrmDiameterQuery.cs +++ b/FrmDiameterQuery.cs @@ -179,6 +179,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmFittingQuery.cs b/FrmFittingQuery.cs index f836f84..3063dab 100644 --- a/FrmFittingQuery.cs +++ b/FrmFittingQuery.cs @@ -76,6 +76,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmMaterialSel.cs b/FrmMaterialSel.cs index c5af730..f658a8b 100644 --- a/FrmMaterialSel.cs +++ b/FrmMaterialSel.cs @@ -163,6 +163,8 @@ } else { + + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmAllPipelineStatis.cs b/FrmAllPipelineStatis.cs index 6a93188..e9a4ae7 100644 --- a/FrmAllPipelineStatis.cs +++ b/FrmAllPipelineStatis.cs @@ -116,11 +116,19 @@ if (total > 0) { string strLable = "共有：" + Convert.ToString(total) + "条记录" - + " 管线里程：" + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") - + " 米"; - PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, m_InitDataGridViewX1, strLable, pipetype,fs,fields); + + " 管线里程：" + + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") + + " 米"; + PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, + m_InitDataGridViewX1, strLable, pipetype, fs, fields); pagination.FillDataGridView(); } + else + { + + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查到符合条件的数据"); + } } private void chartAllAreaPipeline_MouseMove(object sender, MouseEventArgs e) diff --git a/FrmAllWorkWellStatis.cs b/FrmAllWorkWellStatis.cs index 25dce60..f253369 100644 --- a/FrmAllWorkWellStatis.cs +++ b/FrmAllWorkWellStatis.cs @@ -128,9 +128,15 @@ { string strLable = " 井盖类型：" + pipetype + "||共有：" + Convert.ToString(total) + "条记录"; string sql = PaginationUtil.GetQuerySql(globeControl1, layername, "编号", list); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, strLable, layername); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, + strLable, layername); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查询到符合条件的数据"); + } } diff --git a/FrmBasicQuery.cs b/FrmBasicQuery.cs index cb07576..3fe748e 100644 --- a/FrmBasicQuery.cs +++ b/FrmBasicQuery.cs @@ -230,6 +230,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查找到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmCodingQuery.cs b/FrmCodingQuery.cs index 9d6cc0c..9987842 100644 --- a/FrmCodingQuery.cs +++ b/FrmCodingQuery.cs @@ -86,11 +86,17 @@ int total = PaginationUtil.CountSql(comboBoxEx1.Text.Trim(), "编号", textBoxX1.Text); if (total > 0) { - string strLable = comboBoxEx1.Text + "共有:" + total + "条"; + string strLable = comboBoxEx1.Text + "共有:" + total + "条"; string sql = PaginationUtil.GetQuerySql(globeControl1, comboBoxEx1.Text.Trim(), "编号", textBoxX1.Text); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1,strLable, comboBoxEx1.Text); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, + m_InitDataGridViewX1, strLable, comboBoxEx1.Text); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有符合条件的数据"); + } } catch (Exception ex) diff --git a/FrmDiameterQuery.cs b/FrmDiameterQuery.cs index 5a092fc..6595ee9 100644 --- a/FrmDiameterQuery.cs +++ b/FrmDiameterQuery.cs @@ -179,6 +179,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmFittingQuery.cs b/FrmFittingQuery.cs index f836f84..3063dab 100644 --- a/FrmFittingQuery.cs +++ b/FrmFittingQuery.cs @@ -76,6 +76,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmMaterialSel.cs b/FrmMaterialSel.cs index c5af730..f658a8b 100644 --- a/FrmMaterialSel.cs +++ b/FrmMaterialSel.cs @@ -163,6 +163,8 @@ } else { + + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmQuerySQL.cs b/FrmQuerySQL.cs index 591e731..8dd23df 100644 --- a/FrmQuerySQL.cs +++ b/FrmQuerySQL.cs @@ -246,6 +246,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查询到复合条件的数据！","提示",MessageBoxButtons.OK,MessageBoxIcon.Information); } } diff --git a/FrmAllPipelineStatis.cs b/FrmAllPipelineStatis.cs index 6a93188..e9a4ae7 100644 --- a/FrmAllPipelineStatis.cs +++ b/FrmAllPipelineStatis.cs @@ -116,11 +116,19 @@ if (total > 0) { string strLable = "共有：" + Convert.ToString(total) + "条记录" - + " 管线里程：" + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") - + " 米"; - PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, m_InitDataGridViewX1, strLable, pipetype,fs,fields); + + " 管线里程：" + + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") + + " 米"; + PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, + m_InitDataGridViewX1, strLable, pipetype, fs, fields); pagination.FillDataGridView(); } + else + { + + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查到符合条件的数据"); + } } private void chartAllAreaPipeline_MouseMove(object sender, MouseEventArgs e) diff --git a/FrmAllWorkWellStatis.cs b/FrmAllWorkWellStatis.cs index 25dce60..f253369 100644 --- a/FrmAllWorkWellStatis.cs +++ b/FrmAllWorkWellStatis.cs @@ -128,9 +128,15 @@ { string strLable = " 井盖类型：" + pipetype + "||共有：" + Convert.ToString(total) + "条记录"; string sql = PaginationUtil.GetQuerySql(globeControl1, layername, "编号", list); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, strLable, layername); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, + strLable, layername); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查询到符合条件的数据"); + } } diff --git a/FrmBasicQuery.cs b/FrmBasicQuery.cs index cb07576..3fe748e 100644 --- a/FrmBasicQuery.cs +++ b/FrmBasicQuery.cs @@ -230,6 +230,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查找到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmCodingQuery.cs b/FrmCodingQuery.cs index 9d6cc0c..9987842 100644 --- a/FrmCodingQuery.cs +++ b/FrmCodingQuery.cs @@ -86,11 +86,17 @@ int total = PaginationUtil.CountSql(comboBoxEx1.Text.Trim(), "编号", textBoxX1.Text); if (total > 0) { - string strLable = comboBoxEx1.Text + "共有:" + total + "条"; + string strLable = comboBoxEx1.Text + "共有:" + total + "条"; string sql = PaginationUtil.GetQuerySql(globeControl1, comboBoxEx1.Text.Trim(), "编号", textBoxX1.Text); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1,strLable, comboBoxEx1.Text); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, + m_InitDataGridViewX1, strLable, comboBoxEx1.Text); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有符合条件的数据"); + } } catch (Exception ex) diff --git a/FrmDiameterQuery.cs b/FrmDiameterQuery.cs index 5a092fc..6595ee9 100644 --- a/FrmDiameterQuery.cs +++ b/FrmDiameterQuery.cs @@ -179,6 +179,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmFittingQuery.cs b/FrmFittingQuery.cs index f836f84..3063dab 100644 --- a/FrmFittingQuery.cs +++ b/FrmFittingQuery.cs @@ -76,6 +76,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmMaterialSel.cs b/FrmMaterialSel.cs index c5af730..f658a8b 100644 --- a/FrmMaterialSel.cs +++ b/FrmMaterialSel.cs @@ -163,6 +163,8 @@ } else { + + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmQuerySQL.cs b/FrmQuerySQL.cs index 591e731..8dd23df 100644 --- a/FrmQuerySQL.cs +++ b/FrmQuerySQL.cs @@ -246,6 +246,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查询到复合条件的数据！","提示",MessageBoxButtons.OK,MessageBoxIcon.Information); } } diff --git a/FrmValveStatistics.cs b/FrmValveStatistics.cs index 369a7ee..b6ede1c 100644 --- a/FrmValveStatistics.cs +++ b/FrmValveStatistics.cs @@ -124,10 +124,16 @@ if (total > 0) { string strLable = " 阀门类型：" + pipetype + "||共有：" + Convert.ToString(total) + "条记录"; - string sql = PaginationUtil.GetQuerySql(globeControl1, layername, "编号",list); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, strLable, layername); + string sql = PaginationUtil.GetQuerySql(globeControl1, layername, "编号", list); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, + m_InitDataGridViewX1, strLable, layername); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查到符合条件的数据"); + } } } /// diff --git a/FrmAllPipelineStatis.cs b/FrmAllPipelineStatis.cs index 6a93188..e9a4ae7 100644 --- a/FrmAllPipelineStatis.cs +++ b/FrmAllPipelineStatis.cs @@ -116,11 +116,19 @@ if (total > 0) { string strLable = "共有：" + Convert.ToString(total) + "条记录" - + " 管线里程：" + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") - + " 米"; - PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, m_InitDataGridViewX1, strLable, pipetype,fs,fields); + + " 管线里程：" + + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") + + " 米"; + PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, + m_InitDataGridViewX1, strLable, pipetype, fs, fields); pagination.FillDataGridView(); } + else + { + + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查到符合条件的数据"); + } } private void chartAllAreaPipeline_MouseMove(object sender, MouseEventArgs e) diff --git a/FrmAllWorkWellStatis.cs b/FrmAllWorkWellStatis.cs index 25dce60..f253369 100644 --- a/FrmAllWorkWellStatis.cs +++ b/FrmAllWorkWellStatis.cs @@ -128,9 +128,15 @@ { string strLable = " 井盖类型：" + pipetype + "||共有：" + Convert.ToString(total) + "条记录"; string sql = PaginationUtil.GetQuerySql(globeControl1, layername, "编号", list); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, strLable, layername); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, + strLable, layername); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查询到符合条件的数据"); + } } diff --git a/FrmBasicQuery.cs b/FrmBasicQuery.cs index cb07576..3fe748e 100644 --- a/FrmBasicQuery.cs +++ b/FrmBasicQuery.cs @@ -230,6 +230,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查找到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmCodingQuery.cs b/FrmCodingQuery.cs index 9d6cc0c..9987842 100644 --- a/FrmCodingQuery.cs +++ b/FrmCodingQuery.cs @@ -86,11 +86,17 @@ int total = PaginationUtil.CountSql(comboBoxEx1.Text.Trim(), "编号", textBoxX1.Text); if (total > 0) { - string strLable = comboBoxEx1.Text + "共有:" + total + "条"; + string strLable = comboBoxEx1.Text + "共有:" + total + "条"; string sql = PaginationUtil.GetQuerySql(globeControl1, comboBoxEx1.Text.Trim(), "编号", textBoxX1.Text); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1,strLable, comboBoxEx1.Text); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, + m_InitDataGridViewX1, strLable, comboBoxEx1.Text); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有符合条件的数据"); + } } catch (Exception ex) diff --git a/FrmDiameterQuery.cs b/FrmDiameterQuery.cs index 5a092fc..6595ee9 100644 --- a/FrmDiameterQuery.cs +++ b/FrmDiameterQuery.cs @@ -179,6 +179,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmFittingQuery.cs b/FrmFittingQuery.cs index f836f84..3063dab 100644 --- a/FrmFittingQuery.cs +++ b/FrmFittingQuery.cs @@ -76,6 +76,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmMaterialSel.cs b/FrmMaterialSel.cs index c5af730..f658a8b 100644 --- a/FrmMaterialSel.cs +++ b/FrmMaterialSel.cs @@ -163,6 +163,8 @@ } else { + + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmQuerySQL.cs b/FrmQuerySQL.cs index 591e731..8dd23df 100644 --- a/FrmQuerySQL.cs +++ b/FrmQuerySQL.cs @@ -246,6 +246,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查询到复合条件的数据！","提示",MessageBoxButtons.OK,MessageBoxIcon.Information); } } diff --git a/FrmValveStatistics.cs b/FrmValveStatistics.cs index 369a7ee..b6ede1c 100644 --- a/FrmValveStatistics.cs +++ b/FrmValveStatistics.cs @@ -124,10 +124,16 @@ if (total > 0) { string strLable = " 阀门类型：" + pipetype + "||共有：" + Convert.ToString(total) + "条记录"; - string sql = PaginationUtil.GetQuerySql(globeControl1, layername, "编号",list); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, strLable, layername); + string sql = PaginationUtil.GetQuerySql(globeControl1, layername, "编号", list); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, + m_InitDataGridViewX1, strLable, layername); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查到符合条件的数据"); + } } } /// diff --git a/MainFrm.cs b/MainFrm.cs index 5d18e03..71d52e2 100644 --- a/MainFrm.cs +++ b/MainFrm.cs @@ -7983,6 +7983,7 @@ newlayer.AddFeature(feature); } newlayer.Save(); + newlayer.SaveAs(dlg.FileName); newlayer.Dataset.DataSource.RemoveDataset(newlayer.Dataset); globeControl1.Globe.Layers.Remove(newlayer); MessageBox.Show("导出CAD完成！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); diff --git a/FrmAllPipelineStatis.cs b/FrmAllPipelineStatis.cs index 6a93188..e9a4ae7 100644 --- a/FrmAllPipelineStatis.cs +++ b/FrmAllPipelineStatis.cs @@ -116,11 +116,19 @@ if (total > 0) { string strLable = "共有：" + Convert.ToString(total) + "条记录" - + " 管线里程：" + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") - + " 米"; - PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, m_InitDataGridViewX1, strLable, pipetype,fs,fields); + + " 管线里程：" + + chartAllAreaPipeline.Series["管线"].Points[indexHit].YValues[0].ToString("0.00") + + " 米"; + PaginationFeaturesUtil pagination = PaginationFeaturesUtil.InitPagination(total, _pageControl, + m_InitDataGridViewX1, strLable, pipetype, fs, fields); pagination.FillDataGridView(); } + else + { + + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查到符合条件的数据"); + } } private void chartAllAreaPipeline_MouseMove(object sender, MouseEventArgs e) diff --git a/FrmAllWorkWellStatis.cs b/FrmAllWorkWellStatis.cs index 25dce60..f253369 100644 --- a/FrmAllWorkWellStatis.cs +++ b/FrmAllWorkWellStatis.cs @@ -128,9 +128,15 @@ { string strLable = " 井盖类型：" + pipetype + "||共有：" + Convert.ToString(total) + "条记录"; string sql = PaginationUtil.GetQuerySql(globeControl1, layername, "编号", list); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, strLable, layername); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, + strLable, layername); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查询到符合条件的数据"); + } } diff --git a/FrmBasicQuery.cs b/FrmBasicQuery.cs index cb07576..3fe748e 100644 --- a/FrmBasicQuery.cs +++ b/FrmBasicQuery.cs @@ -230,6 +230,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查找到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmCodingQuery.cs b/FrmCodingQuery.cs index 9d6cc0c..9987842 100644 --- a/FrmCodingQuery.cs +++ b/FrmCodingQuery.cs @@ -86,11 +86,17 @@ int total = PaginationUtil.CountSql(comboBoxEx1.Text.Trim(), "编号", textBoxX1.Text); if (total > 0) { - string strLable = comboBoxEx1.Text + "共有:" + total + "条"; + string strLable = comboBoxEx1.Text + "共有:" + total + "条"; string sql = PaginationUtil.GetQuerySql(globeControl1, comboBoxEx1.Text.Trim(), "编号", textBoxX1.Text); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1,strLable, comboBoxEx1.Text); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, + m_InitDataGridViewX1, strLable, comboBoxEx1.Text); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有符合条件的数据"); + } } catch (Exception ex) diff --git a/FrmDiameterQuery.cs b/FrmDiameterQuery.cs index 5a092fc..6595ee9 100644 --- a/FrmDiameterQuery.cs +++ b/FrmDiameterQuery.cs @@ -179,6 +179,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmFittingQuery.cs b/FrmFittingQuery.cs index f836f84..3063dab 100644 --- a/FrmFittingQuery.cs +++ b/FrmFittingQuery.cs @@ -76,6 +76,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmMaterialSel.cs b/FrmMaterialSel.cs index c5af730..f658a8b 100644 --- a/FrmMaterialSel.cs +++ b/FrmMaterialSel.cs @@ -163,6 +163,8 @@ } else { + + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查到符合条件的数据！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } } diff --git a/FrmQuerySQL.cs b/FrmQuerySQL.cs index 591e731..8dd23df 100644 --- a/FrmQuerySQL.cs +++ b/FrmQuerySQL.cs @@ -246,6 +246,7 @@ } else { + m_InitDataGridViewX1(null, "", "", false); MessageBox.Show("没有查询到复合条件的数据！","提示",MessageBoxButtons.OK,MessageBoxIcon.Information); } } diff --git a/FrmValveStatistics.cs b/FrmValveStatistics.cs index 369a7ee..b6ede1c 100644 --- a/FrmValveStatistics.cs +++ b/FrmValveStatistics.cs @@ -124,10 +124,16 @@ if (total > 0) { string strLable = " 阀门类型：" + pipetype + "||共有：" + Convert.ToString(total) + "条记录"; - string sql = PaginationUtil.GetQuerySql(globeControl1, layername, "编号",list); - PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, m_InitDataGridViewX1, strLable, layername); + string sql = PaginationUtil.GetQuerySql(globeControl1, layername, "编号", list); + PaginationUtil pagination = PaginationUtil.InitPagination(sql, total, _pageControl, + m_InitDataGridViewX1, strLable, layername); pagination.FillDataGridView(); } + else + { + m_InitDataGridViewX1(null, "", "", false); + MessageBox.Show("没有查到符合条件的数据"); + } } } /// diff --git a/MainFrm.cs b/MainFrm.cs index 5d18e03..71d52e2 100644 --- a/MainFrm.cs +++ b/MainFrm.cs @@ -7983,6 +7983,7 @@ newlayer.AddFeature(feature); } newlayer.Save(); + newlayer.SaveAs(dlg.FileName); newlayer.Dataset.DataSource.RemoveDataset(newlayer.Dataset); globeControl1.Globe.Layers.Remove(newlayer); MessageBox.Show("导出CAD完成！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); diff --git a/PaginationUtil.cs b/PaginationUtil.cs index e1a85ed..dba4dc5 100644 --- a/PaginationUtil.cs +++ b/PaginationUtil.cs @@ -84,7 +84,7 @@ private static string PageQuerySql(string sql, int begin, int pageSize) { int end = begin + pageSize - 1; - string result = "select * from (select rownum rn,A.* from (" + sql + ") A) B where rn between " + begin + " and " + end; + string result = "select * from (select rownum 序号,A.* from (" + sql + ") A) B where 序号 between " + begin + " and " + end; return result; }