博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
[C#][DevPress]省市县乡嵌套查询
阅读量:7083 次
发布时间:2019-06-28

本文共 10341 字,大约阅读时间需要 34 分钟。

private void ChartZhu()        {            try            {                string beginTime, endTime, townCode;                int count = 0, degree = -1, state = 0;                bool isDegree = true;                if (radioGroup1.SelectedIndex==0)                    isDegree = true;                else                    isDegree = false;                //初始化参数                degree = InitParamS(degree, out beginTime, out endTime, out townCode);                //省级视图                if (lookUpEdit5.EditValue != null &&                    (lookUpEdit6.EditValue == null || lookUpEdit6.EditValue.ToString() == "-1") &&                    (lookUpEdit8.EditValue == null || lookUpEdit8.EditValue.ToString() == "-1") &&                    (lookUpEdit7.EditValue == null || lookUpEdit7.EditValue.ToString() == "-1"))                {                    DataTable dt = GetLocalProvinceDetails(beginTime, endTime, townCode, degree, state, out count);                    InitDetailsView(dt);                    return;                }                //市级视图                if (lookUpEdit5.EditValue != null &&                    lookUpEdit6.EditValue != null &&                    (lookUpEdit8.EditValue == null || lookUpEdit8.EditValue.ToString() == "-1") &&                    (lookUpEdit7.EditValue == null || lookUpEdit7.EditValue.ToString() == "-1"))                {                    DataTable dt = GetLocalCityDetails(beginTime, endTime, townCode, degree, state, out count);                    InitDetailsView(dt);                    return;                }                //县级视图                if (lookUpEdit5.EditValue != null &&                    lookUpEdit6.EditValue != null &&                    lookUpEdit8.EditValue != null &&                    (lookUpEdit7.EditValue == null || lookUpEdit7.EditValue.ToString() == "-1"))                {                    DataTable dt = GetLocalCountyDetails(beginTime, endTime, townCode, degree, state, out count);                    InitDetailsView(dt);                    return;                }                //乡级视图                if (lookUpEdit5.EditValue != null && lookUpEdit6.EditValue != null && lookUpEdit8.EditValue != null && lookUpEdit7.EditValue != null)                {                    DataTable dt = bllh.GetChartData1(beginTime, endTime, townCode, isDegree);                    InitDetailsView(dt);                    return;                }            }            catch (Exception ex)            {                XtraMessageBox.Show("显示视图失败:"   ex.Message, "友情提示", MessageBoxButtons.OK, MessageBoxIcon.Error);            }        }
///         /// 初始化参数        ///         ///         ///         ///         ///         /// 
private int InitParamS(int degree, out string beginTime, out string endTime, out string townCode) { Initparams(out beginTime, out endTime, out townCode); if (ischeck) degree = InitDegree(degree); ischeck = radioGroup3.Enabled; return degree; }
///         /// 初始化参数        ///         ///         ///         ///         private void Initparams(out string beginTime, out string endTime, out string townCode)        {            beginTime = this.dateEdit4.DateTime.ToString("yyyy-MM-dd")   " 00:00:00";            endTime = this.dateEdit3.DateTime.AddDays(1).ToString("yyyy-MM-dd")   " 00:00:00";            townCode = string.Empty;            if (lookUpEdit5.EditValue != null && lookUpEdit5.EditValue.ToString() != "-1")                townCode = lookUpEdit5.EditValue.ToString();            if (lookUpEdit6.EditValue != null && lookUpEdit6.EditValue.ToString() != "-1")                townCode = lookUpEdit6.EditValue.ToString();            if (lookUpEdit8.EditValue != null && lookUpEdit8.EditValue.ToString() != "-1")                townCode = lookUpEdit8.EditValue.ToString();            if (lookUpEdit7.EditValue != null && lookUpEdit7.EditValue.ToString() != "-1")                townCode = lookUpEdit7.EditValue.ToString();        }
///         /// 给degree赋值        ///         ///         /// 
private int InitDegree(int degree) { if (radioGroup3.Properties.Items.Count == 3) { if (radioGroup3.SelectedIndex == 0) degree = 0; if (radioGroup3.SelectedIndex == 1) degree = 1; if (radioGroup3.SelectedIndex == 2) degree = 2; } if (radioGroup3.Properties.Items.Count == 5) { if (radioGroup3.SelectedIndex == 2) degree = 4; if (radioGroup3.SelectedIndex == 1) degree = 3; if (radioGroup3.SelectedIndex == 0) degree = 1; if (radioGroup3.SelectedIndex == 3) degree = 2; if (radioGroup3.SelectedIndex == 4) degree = 5; } return degree; }
///         /// 初始化柱状图        ///         ///         private void InitDetailsView(DataTable dt)        {            StringBuilder frist = new StringBuilder();            StringBuilder strXml = new StringBuilder();            strXml.Append("
"); frist.Append("
"); for (int i = 0; i < dt.Rows.Count; i ) { strXml.Append("
"); frist.AppendFormat("
", dt.Rows[i]["Count"].ToString()); } strXml.Append("
"); frist.Append(""); strXml.Append(frist); string data = string.Format("{0}\" />{1}\" quality=\"high\" width=\"680\" height=\"440\" name=\"我来试试\" allowScriptAccess=\"always\" type=\"application/x-shockwave-flash\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" />", strXml, strXml); WriteData(data); SetContext(webBrowser1); }
///         /// 获取一个乡的详细情况        ///         ///         ///         /// 乡代码(xxxxxx-xxx)        ///         ///         /// 已废弃参数,返回常量"0"        /// 
一个县的每个乡的详细情况
private DataTable GetLocalCountyDetails(string beginTime, string endTime, string townCode, int degree, int state, out int count) { DataTable Xianji = new DataTable();//初始化县列表 Xianji.TableName = townCode; Xianji.Columns.AddRange(new DataColumn[]{ new DataColumn("Corp_Town_Name"), new DataColumn("Count") }); //向县列表中添加每个乡的信息 DataTable temp = bllh.GetChartDataByQY1(beginTime, endTime, townCode, degree, state, out count); if (temp != null && temp.Rows.Count > 0) { for (int i = 0; i < temp.Rows.Count; i ) { Xianji.Rows.Add(new object[] { temp.Rows[i]["Corp_Town_Name"].ToString(), temp.Rows[i]["Count"].ToString() }); } } return Xianji; }
///         /// 获取一个市的详细信息        ///         ///         ///         /// 市代码(xxxx)        ///         ///         /// 已废弃参数,返回常量"0"        /// 
一个市的每一个县详细情况
public DataTable GetLocalCityDetails(string beginTime, string endTime, string cityCode, int degree, int state, out int count) { count = 0; DataTable ShiJi = new DataTable();//初始化市级列表 ShiJi.Columns.AddRange(new DataColumn[] { new DataColumn("Corp_Town_Name"), new DataColumn("Count")}); //获取隶属于本市的所有县级代码 DataTable Countys = rbll.GetCounty1(cityCode, null); //初始化临时县级表 DataTable[] Towns = new DataTable[Countys.Rows.Count]; //在临时县级表里添加数据 for (int i = 0; i < Countys.Rows.Count; i ) { string code = Countys.Rows[i]["Corp_Town_Code"].ToString(); Towns[i] = new DataTable(); Towns[i] = GetLocalCountyDetails(beginTime, endTime, code, degree, state, out count); } string CountyValuename = ""; //初始化一个县的名称 int CountyValueNum = 0; //初始化一个县的总统计数值 for (int j = 0; j < Countys.Rows.Count; j ) { CountyValuename = Countys.Rows[j]["Corp_Town_Name"].ToString();//获取这个县的名称 for (int k = 0; k < Towns[j].Rows.Count; k ) { CountyValueNum = int.Parse(Towns[j].Rows[k]["Count"].ToString());//获取这个县的总值 } ShiJi.Rows.Add(new object[] { CountyValuename, CountyValueNum }); } return ShiJi; }
///         /// 获取一个省的详细信息        ///         ///         ///         /// 省代码(xx)        ///         ///         /// 已废弃参数,返回常量"0"        /// 
一个省的每一个市详细情况
public DataTable GetLocalProvinceDetails(string beginTime, string endTime, string ProvinceCode, int degree, int state, out int count) { count = 0; DataTable Shengji = new DataTable();//初始化省级列表 Shengji.Columns.AddRange(new DataColumn[]{ new DataColumn("Corp_Town_Name"), new DataColumn("Count")}); //获取隶属于本省的所有市级代码 DataTable Citys = rbll.GetCity1(ProvinceCode); //初始化临时市级表 DataTable[] Countys = new DataTable[Citys.Rows.Count]; //在临时市级表里添加数据 for (int i = 0; i < Citys.Rows.Count; i ) { string code = Citys.Rows[i]["Corp_Town_Code"].ToString(); Countys[i] = new DataTable(); Countys[i] = GetLocalCityDetails(beginTime, endTime, code, degree, state, out count); } string CityValuename = ""; //初始化一个市的名称 int CityValueNum = 0; //初始化一个市的总统计数值 for (int j = 0; j < Citys.Rows.Count; j ) { CityValuename = Citys.Rows[j]["Corp_Town_Name"].ToString();//获取这个市的名称 for (int k = 0; k < Countys[j].Rows.Count; k ) { CityValueNum = int.Parse(Countys[j].Rows[k]["Count"].ToString());////获取这个市的总值 } Shengji.Rows.Add(new object[] { CityValuename, CityValueNum }); } return Shengji; }

转载于:https://www.cnblogs.com/Hsppl/archive/2012/07/18/2597605.html

你可能感兴趣的文章
Dubbo 实践,演进及未来规划
查看>>
Android FrameWork学习(二)Android系统源码调试
查看>>
http状态码含义
查看>>
ABAP和Java SpringBoot的单元测试
查看>>
iOS节拍器开发
查看>>
扫描线
查看>>
有了这些你们团队的代码也很规范
查看>>
刷前端面经笔记(三)
查看>>
android: 高德地图
查看>>
基于快速GeoHash,如何实现海量商品与商圈的高效匹配?
查看>>
Java多线程编程实战:模拟大量数据同步
查看>>
告别webpack react 搭建多页面之痛
查看>>
前嗅ForeSpider教程:链接抽取
查看>>
python奇遇记:深入理解装饰器
查看>>
web-push实现原理及细节介绍
查看>>
MongoDB 分片配置
查看>>
elasticsearch概念详解
查看>>
matplotlib Basic Usage
查看>>
高性能磁盘 I/O 开发学习笔记 -- 软件手段篇
查看>>
ueditor中的问题记录
查看>>