asp.net中FlexCell实现的一些报表统计应用

Dictionary dict = GetAgeCondition();
 if (dict.Keys.Count > 0)
 {
     grid1.Cell(startRow++, 1).Text = "年龄段情况：";

     foreach (string key in dict.Keys)
     {
         CListItem item = dict[key];
         grid1.Cell(startRow, 2).Text = key;
         grid1.Cell(startRow, 3).Text = string.Format("有{0}人，占比例{1} ", item.Text, item.Value);
         grid1.Cell(startRow, 4).Text = string.Format("Age:{0}", key);

         startRow++;
     }
 }

private void grid1_HyperLinkClick(object Sender, FlexCell.Grid.HyperLinkClickEventArgs e)
        {
            FlexCell.Cell cell = grid1.Cell(e.Row, 4);
            if (cell != null && !string.IsNullOrEmpty(cell.Text))
            {
                FrmStatisticDetail dlg = new FrmStatisticDetail();
                dlg.KeyCondition = cell.Text;
                dlg.ShowDialog();
            }
            e.URL = "";
            e.Changed = true;
        }

private void DealAge(string condition, ref int startRow)
        {
            grid1.Cell(1, 1).Text += string.Format("(条件：年龄{0})", condition);

            startRow++;
            // 设置单元格文字
            grid1.Cell(startRow, 1).Text = "年龄";
            grid1.Cell(startRow, 2).Text = "编号";
            grid1.Cell(startRow, 3).Text = "姓名";
            grid1.Cell(startRow, 4).Text = "性别";
            grid1.Cell(startRow, 5).Text = "生日";
            grid1.Cell(startRow, 6).Text = "职别";
            grid1.Cell(startRow, 7).Text = "部别";
            grid1.Range(startRow, 1, startRow, 7).BackColor = Color.Yellow;
            int start = startRow++;

            string where = "Age " + condition;
            if(condition.Contains("~"))
            {
                string[] conArray = condition.Split('~');
                where = string.Format("Age >={0} and Age<={1}", conArray[0], conArray[1]);
            }

            DataTable dt = BLLFactory.Instance.FindByView("PilotAgeView", where, "Age", true);
            foreach (DataRow row in dt.Rows)
            {
                grid1.Cell(startRow, 1).Text = row["Age"].ToString();
                grid1.Cell(startRow, 2).Text = row["PilotNo"].ToString();
                grid1.Cell(startRow, 3).Text = row["Name"].ToString();
                grid1.Cell(startRow, 4).Text = row["Sex"].ToString();
                DateTime birthday;
                if (DateTime.TryParse(row["Birthday"].ToString(), out birthday))
                {
                    grid1.Cell(startRow, 5).Text = birthday.ToString("yyyy-MM-dd");
                }
                grid1.Cell(startRow, 6).Text = row["OfficialRank"].ToString();
                grid1.Cell(startRow, 7).Text = row["DeptCode"].ToString();

                startRow++;
            }
            FlexCell.Range range = grid1.Range(start, 1, startRow, 7);
            range.set_Borders(FlexCell.EdgeEnum.Outside | FlexCell.EdgeEnum.Inside, FlexCell.LineStyleEnum.Thin);

            startRow++;
            startRow++;
        }

private void menu_Preview_Click(object sender, EventArgs e)
        {
            try
            {
                grid1.PrintPreview();
            }
            catch (Exception err)
            {
                MessageDxUtil.ShowError(err.Message);
            }
        }

        private void menu_PageSetting_Click(object sender, EventArgs e)
        {
            try
            {
                grid1.ShowPageSetupDialog();
            }
            catch (Exception err)
            {
                MessageDxUtil.ShowError(err.Message);
            }
        }

        private void menu_ExportExcel_Click(object sender, EventArgs e)
        {
            try
            {
                #region 保存Excel文件
                SpecialDirectories sp = new SpecialDirectories();
                SaveFileDialog dialog = new SaveFileDialog();
                dialog.Filter = "Excel(*.xls)|*.xls|All File(*.*)|*.*";
                dialog.Title = "保存Excel";
                try
                {
                    dialog.InitialDirectory = sp.Desktop;
                }
                catch
                {
                    dialog.InitialDirectory = "C:";
                }
                dialog.RestoreDirectory = true;
                if (dialog.ShowDialog() == DialogResult.OK)
                {
                    string fileToSave = dialog.FileName;
                    if (string.IsNullOrEmpty(fileToSave))
                    {
                        return;
                    }

                    bool success = grid1.ExportToExcel(fileToSave, true, true);
                    if (success)
                    {
                        Process.Start(fileToSave);
                    }
                }
                #endregion
            }
            catch (Exception err)
            {
                MessageDxUtil.ShowError(err.Message);
            }
        }

        ///

        private void menu_ExportPDF_Click(object sender, EventArgs e)
        {
            try
            {
                grid1.PageSetup.DocumentName = "统计报表";
                bool success = grid1.ExportToPDF("");
            }
            catch (Exception err)
            {
                MessageDxUtil.ShowError(err.Message);
            }
        }