[C#][DevPress]省市县乡嵌套查询

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);
            }
        }

/// <summary>
        /// 初始化参数
        /// </summary>
        /// <param name="degree"></param>
        /// <param name="beginTime"></param>
        /// <param name="endTime"></param>
        /// <param name="townCode"></param>
        /// <returns></returns>
        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;
        }

/// <summary>
        /// 初始化参数
        /// </summary>
        /// <param name="beginTime"></param>
        /// <param name="endTime"></param>
        /// <param name="townCode"></param>
        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();
        }

/// <summary>
        /// 给degree赋值
        /// </summary>
        /// <param name="degree"></param>
        /// <returns></returns>
        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;
        }

/// <summary>
        /// 初始化柱状图
        /// </summary>
        /// <param name="dt"></param>
        private void InitDetailsView(DataTable dt)
        {
            StringBuilder frist = new StringBuilder();

            StringBuilder strXml = new StringBuilder();
            strXml.Append("<categories>");
            frist.Append("<dataset seriesname=''>");

            for (int i = 0; i < dt.Rows.Count; i  )
            {
                strXml.Append("<category name='"   dt.Rows[i]["Corp_Town_Name"].ToString()   "'/>");
                frist.AppendFormat("<set value='{0}' />", dt.Rows[i]["Count"].ToString());

            }

            strXml.Append("</categories>");
            frist.Append("</dataset>");

            strXml.Append(frist);

            string data = string.Format("<script type='text/javascript' src='javascript/jquery-1.4.2.min.js'></script><script type='text/javascript' src='javascript/lib.js'></script><script type='text/javascript' src='javascript/FusionCharts.js'></script><object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" codebase=\"http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0\" width=\"680\" height=\"440\" name=\"我来试试\"><param name=\"allowScriptAccess\" value=\"always\" /><param name=\"movie\" value=\"swf/MSColumn3D.swf\"/><param name=\"FlashVars\" value=\"&chartWidth=680&chartHeight=440&debugMode=0&dataXML=<chart caption='隐患数量柱形图示' decimalPrecision='0' chartLeftMargin='0' outCnvBaseFontSize='12'baseFontSize='12' yAxisName='隐患数量' numberPrefix='' ecimalPrecision='1' >{0}</chart>\" /><param name=\"quality\" value=\"high\" /><embed src=\"swf/MSColumn3D.swf\" FlashVars=\"&chartWidth=680&chartHeight=440&debugMode=0&dataXML=<chart caption='隐患数量柱形图示' decimalPrecision='0'chartLeftMargin='0 outCnvBaseFontSize='12'baseFontSize='12' yAxisName='隐患数量' numberPrefix='' decimalPrecision='1'>{1}</chart>\" quality=\"high\" width=\"680\" height=\"440\" name=\"我来试试\"  allowScriptAccess=\"always\" type=\"application/x-shockwave-flash\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" /></object>", strXml, strXml);
            WriteData(data);
            SetContext(webBrowser1);
        }

/// <summary>
        /// 获取一个乡的详细情况
        /// </summary>
        /// <param name="beginTime"></param>
        /// <param name="endTime"></param>
        /// <param name="townCode">乡代码(xxxxxx-xxx)</param>
        /// <param name="degree"></param>
        /// <param name="state"></param>
        /// <param name="count">已废弃参数,返回常量"0"</param>
        /// <returns>一个县的每个乡的详细情况</returns>
        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;
        }

/// <summary>
        /// 获取一个市的详细信息
        /// </summary>
        /// <param name="beginTime"></param>
        /// <param name="endTime"></param>
        /// <param name="cityCode">市代码(xxxx)</param>
        /// <param name="degree"></param>
        /// <param name="state"></param>
        /// <param name="count">已废弃参数,返回常量"0"</param>
        /// <returns>一个市的每一个县详细情况</returns>
        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;
        }

/// <summary>
        /// 获取一个省的详细信息
        /// </summary>
        /// <param name="beginTime"></param>
        /// <param name="endTime"></param>
        /// <param name="ProvinceCode">省代码(xx)</param>
        /// <param name="degree"></param>
        /// <param name="state"></param>
        /// <param name="count">已废弃参数,返回常量"0"</param>
        /// <returns>一个省的每一个市详细情况</returns>
        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;
        }