Пример #1
0
        private void barButtonItem13_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            Init();  //刷新元件树
            resulttb = new DataTable();
            resulttb.Columns.Add("fhname", typeof(string));
            resulttb.Columns.Add("zbname", typeof(string));
            resulttb.Columns.Add("result", typeof(double));
            resulttb.Columns.Add("pdfs", typeof(string));
            resulttb.Columns.Add("A", typeof(string));
            resulttb.Columns.Add("B", typeof(string));
            order = 0;
            resultzbtb = new DataTable();
            resultzbtb.Columns.Add("fhname", typeof(string));
            resultzbtb.Columns.Add("zbname", typeof(string));
            resultzbtb.Columns.Add("result", typeof(double));
            resultzbtb.Columns.Add("pdfs", typeof(string));
            resultzbtb.Columns.Add("A", typeof(string));
            resultzbtb.Columns.Add("B", typeof(string));

             ExcelAccess ex = new ExcelAccess();
            try
            {

                SaveFileDialog saveFileDialog1 = new SaveFileDialog();
                string fname = Application.StartupPath + "\\xls\\tempt.xls";
                ex.Open(fname);
                //ex.ActiveSheet(1);
                ex.SetCellValue("指标", 1, 1);
                ex.SetCellValue("不同的配点方式", 1, 3);
                ex.AlignmentCells(1, 1, 1, 1, ExcelStyle.ExcelHAlign.居中, ExcelStyle.ExcelVAlign.居中);
                ex.SetFontStyle(1, 1, 1, 1, true, false, ExcelStyle.UnderlineStyle.无下划线);
                ex.CellsBackColor(1, 1, 1, 1, ExcelStyle.ColorIndex.黄色);
                ex.UnitCells(1, 1, 2, 2);
                DataTable dt = new DataTable();
                frmfxlx fm = new frmfxlx();
                if (fm.ShowDialog() == DialogResult.OK)
                {
                    dt = fm.DT1;
                    int columnscount = 0;
                    foreach (DataRow dr in dt.Rows)
                    {
                        if (Convert.ToInt32(dr["B"]) == 1)
                        {

                            TreeListNode tln = treeList1.FindNodeByKeyID(pdreltypeid);
                            bool flag = relanalsy(tln, Convert.ToInt32(dr["D"]), columnscount, ex);
                            columnscount++;
                            if (!flag)
                            {
                                ex.DisPoseExcel();
                                return;
                            }
                        }
                    }
                    //FrmResult FR = new FrmResult();
                    //FR.DT = resulttb;
                    //FR.DT1 = resultzbtb;
                    //FR.ShowDialog();
                    if (columnscount==0)
                    {
                        return;
                    }
                    ex.UnitCells(1, 3, 1, 2 + columnscount);
                    ex.AlignmentCells(1, 3, 1, 2 + columnscount, ExcelStyle.ExcelHAlign.居中, ExcelStyle.ExcelVAlign.居中);
                    ex.SetFontStyle(1, 3, 1, 2 + columnscount, true, false, ExcelStyle.UnderlineStyle.无下划线);
                    ex.CellsBackColor(1, 3, 1, 2 + columnscount, ExcelStyle.ColorIndex.黄色);
                    ex.ShowExcel();
                }
                else
                {
                    ex.DisPoseExcel();
                }

            }
            catch (System.Exception exe)
            {
                ex.DisPoseExcel();
                MessageBox.Show("存在问题!请检查数据后再计算");
            }
        }
Пример #2
0
        private void Extbdzreport(ArrayList extsublist1)
        {
            ExcelAccess ex = new ExcelAccess();
            try
            {

                string fname = Application.StartupPath + "\\xls\\tempt.xls";
                ex.Open(fname);
                //ex.ActiveSheet(1);
                ex.SetCellValue("变电站名称", 1, 1);
                ex.SetCellValue("容量", 1, 2);
                ex.SetCellValue("容载比", 1, 3);

                ex.AlignmentCells(1, 1, 1, 3, ExcelStyle.ExcelHAlign.居中, ExcelStyle.ExcelVAlign.居中);
                ex.SetFontStyle(1, 1, 1, 3, true, false, ExcelStyle.UnderlineStyle.无下划线);
                ex.CellsBackColor(1, 1, 1, 3, ExcelStyle.ColorIndex.黄色);

                //输出地块负荷情况
                ex.SetCellValue("变电站供应负荷情况", 3 + extsublist1.Count, 1);
                ex.UnitCells(3 + extsublist.Count, 1, 3 + extsublist1.Count, 3);
                ex.SetCellValue("变电站名称", 4 + extsublist1.Count, 1);
                ex.SetCellValue("地块编号", 4 + extsublist1.Count, 2);
                ex.SetCellValue("供应负荷", 4 + extsublist1.Count, 3);
                ex.AlignmentCells(3 + extsublist1.Count, 1, 4 + extsublist.Count, 3, ExcelStyle.ExcelHAlign.居中, ExcelStyle.ExcelVAlign.居中);
                ex.SetFontStyle(3 + extsublist1.Count, 1, 4 + extsublist.Count, 3, true, false, ExcelStyle.UnderlineStyle.无下划线);
                ex.CellsBackColor(3 + extsublist1.Count, 1, 4 + extsublist.Count, 3, ExcelStyle.ColorIndex.黄色);

                int rowcount = 0;
                for (int i = 0; i < extsublist1.Count; i++)
                {
                    XmlElement xe = extsublist1[i] as XmlElement;
                    if (!string.IsNullOrEmpty(xe.GetAttribute("subname")))
                    {
                        ex.SetCellValue(xe.GetAttribute("subname"), 2 + i, 1);
                        ex.AlignmentCells(2 + i, 1, 2 + i, 1, ExcelStyle.ExcelHAlign.居中, ExcelStyle.ExcelVAlign.居中);
                        ex.SetFontStyle(2 + i, 1, 2 + i, 1, true, false, ExcelStyle.UnderlineStyle.无下划线);
                        ex.CellsBackColor(2 + i, 1, 2 + i, 1, ExcelStyle.ColorIndex.绿色);
                    }
                    if (!string.IsNullOrEmpty(xe.GetAttribute("rl")))
                    {
                        ex.SetCellValue(xe.GetAttribute("rl"), 2 + i, 2);
                        ex.AlignmentCells(2 + i, 2, 2 + i, 2, ExcelStyle.ExcelHAlign.居中, ExcelStyle.ExcelVAlign.居中);
                        ex.SetFontStyle(2 + i, 2, 2 + i, 2, true, false, ExcelStyle.UnderlineStyle.无下划线);

                    }
                    if (!string.IsNullOrEmpty(xe.GetAttribute("yfcrzb")))
                    {
                        ex.SetCellValue(xe.GetAttribute("yfcrzb"), 2 + i, 3);
                        ex.AlignmentCells(2 + i, 3, 2 + i, 3, ExcelStyle.ExcelHAlign.居中, ExcelStyle.ExcelVAlign.居中);
                        ex.SetFontStyle(2 + i, 3, 2 + i, 3, true, false, ExcelStyle.UnderlineStyle.无下划线);

                    }
                    //地块负荷供应情况
                    string fhdk = xe.GetAttribute("fhdk");
                    if (!string.IsNullOrEmpty(fhdk))
                    {
                        string[] dkqk = (fhdk.Substring(0, fhdk.LastIndexOf(";"))).Split(';');

                        for (int j = 0; j < dkqk.Length; j++)
                        {
                            string[] dk = dkqk[j].Split(',');
                            if (!string.IsNullOrEmpty(xe.GetAttribute("subname")))
                            {
                                ex.SetCellValue(xe.GetAttribute("subname"), 5 + extsublist1.Count + rowcount, 1);
                                ex.AlignmentCells(5 + extsublist1.Count + rowcount, 1, 5 + extsublist1.Count + rowcount, 1, ExcelStyle.ExcelHAlign.居中, ExcelStyle.ExcelVAlign.居中);
                                ex.SetFontStyle(5 + extsublist1.Count + rowcount, 1, 5 + extsublist1.Count + rowcount, 1, true, false, ExcelStyle.UnderlineStyle.无下划线);
                                ex.CellsBackColor(5 + extsublist1.Count + rowcount, 1, 5 + extsublist1.Count + rowcount, 1, ExcelStyle.ColorIndex.绿色);

                            }

                            if (dk.Length > 0)
                            {
                                glebeProperty pl = new glebeProperty();
                                pl.EleID = dk[0];
                                pl.SvgUID = tlVectorControl1.SVGDocument.SvgdataUid;
                                pl = (glebeProperty)Services.BaseService.GetObject("SelectglebePropertyByEleID", pl);

                                ex.SetCellValue(pl.UseID, 5 + extsublist1.Count + rowcount, 2);
                                ex.SetCellValue((Convert.ToDouble(dk[1]) / dbl_rzb).ToString("N2"), 5 + extsublist1.Count + rowcount, 3);
                                ex.AlignmentCells(5 + extsublist1.Count + rowcount, 2, 5 + extsublist1.Count + rowcount, 3, ExcelStyle.ExcelHAlign.居中, ExcelStyle.ExcelVAlign.居中);
                                ex.SetFontStyle(5 + extsublist1.Count + rowcount, 2, 5 + extsublist1.Count + rowcount, 3, true, false, ExcelStyle.UnderlineStyle.无下划线);
                            }
                            rowcount++;
                        }
                    }

                }

                ex.ShowExcel();
            }
            catch (System.Exception e)
            {
                ex.DisPoseExcel();
            }
        }