C# WaitDialogForm类代码示例

        /// <summary>
        /// 加载数据同时保存数据到指定位置
        /// </summary>
        /// <param name="obj"></param>
        private void AddData(FarPoint.Win.Spread.FpSpread obj)
        {
            wait = new WaitDialogForm("", "正在加载数据, 请稍候...");
            try
            {
                //打开Excel表格
                //清空工作表
                fpSpread1.Sheets.Clear();
                obj.OpenExcel(System.Windows.Forms.Application.StartupPath + "\\xls\\中压配电网分析.xls");
                PF.SpreadRemoveEmptyCells(obj);
                //this.AddCellChanged();
                //this.barEditItem2.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
                //S4_2_1.AddBarEditItems(this.barEditItem2, this.barEditItem1, this);
            }
            catch (System.Exception e)
            {
                //如果打开出错则重新生成并保存
                LoadData();
                //判断文件夹是否存在，不存在则创建
                if (!Directory.Exists(System.Windows.Forms.Application.StartupPath + "\\xls"))
                {
                    Directory.CreateDirectory(System.Windows.Forms.Application.StartupPath + "\\xls");
                }
                //保存EXcel文件
                obj.SaveExcel(System.Windows.Forms.Application.StartupPath + "\\xls\\中压配电网分析.xls", FarPoint.Excel.ExcelSaveFlags.NoFlagsSet);
                // 定义要使用的Excel 组件接口
                // 定义Application 对象,此对象表示整个Excel 程序
                Microsoft.Office.Interop.Excel.Application excelApp = null;
                // 定义Workbook对象,此对象代表工作薄
                Microsoft.Office.Interop.Excel.Workbook workBook;
                // 定义Worksheet 对象,此对象表示Execel 中的一张工作表
                Microsoft.Office.Interop.Excel.Worksheet ws = null;
                Microsoft.Office.Interop.Excel.Range range = null;
                excelApp = new Microsoft.Office.Interop.Excel.Application();
                string filename = System.Windows.Forms.Application.StartupPath + "\\xls\\中压配电网分析.xls";
                workBook = excelApp.Workbooks.Open(filename, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
                for (int i = 1; i <= workBook.Worksheets.Count; i++)
                {

                    ws = (Microsoft.Office.Interop.Excel.Worksheet)workBook.Worksheets[i];
                    //取消保护工作表
                    ws.Unprotect(Missing.Value);
                    //有数据的行数
                    int row = ws.UsedRange.Rows.Count;
                    //有数据的列数
                    int col = ws.UsedRange.Columns.Count;
                    //创建一个区域
                    range = ws.get_Range(ws.Cells[1, 1], ws.Cells[row, col]);
                    //设区域内的单元格自动换行
                    range.WrapText = true;
                    //保护工作表
                    ws.Protect(Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);
                }
                //保存工作簿
                workBook.Save();
                //关闭工作簿
                excelApp.Workbooks.Close();
            }
            wait.Close();
        }

        /// <summary>
        /// 下载文件
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public static bool SaveFile(byte[] byt,string type)
        {
            bool result = false;
            SaveFileDialog sfd = new SaveFileDialog();
            sfd.Filter = "文件类型|*" + type;
            if (sfd.ShowDialog() == DialogResult.OK)
            {

                WaitDialogForm wait = new WaitDialogForm("", "正在下载数据, 请稍候...");
                try
                {
                    GetFile(byt, sfd.FileName);
                    wait.Close();
                    if (MsgBox.ShowAskMessageBox("下载已完成，是否打开文件？") == DialogResult.OK)
                    {
                        try
                        {
                            System.Diagnostics.Process.Start(sfd.FileName);
                        }
                        catch { System.Diagnostics.Process.Start(sfd.FileName); }
                    }

                }
                catch
                {
                    wait.Close();
                }
            }
            return result;
        }

 public FileReadDV(string projectSUID, string projectid, int dulutype, double ratecaplity, WaitDialogForm wf, string con, StringBuilder dianYaResult)
 {
     this.projectSUID = projectSUID;
     this.projectid = projectid;
     this.dulutype = dulutype;
     this.ratecaplity = ratecaplity;
     this.wf = wf;
     this.con = con;
     this.dianYaResult = dianYaResult;
 }

 public FileReadV(string projectSUID, string projectid, int dulutype, double ratecaplity, WaitDialogForm wf, bool shortiflag, StringBuilder duanResult)
 {
     this.projectSUID = projectSUID;
     this.projectid = projectid;
     this.dulutype = dulutype;
     this.ratecaplity = ratecaplity;
     this.wf = wf;
     this.shortiflag = shortiflag;
     this.duanResult = duanResult;
 }

 public bool showLoading(string message)
 {
     try
     {
         dlg = new DevExpress.Utils.WaitDialogForm(message, "โปรแกรมกำลังทำงาน");
         dlg.Show();
         return true;
     }
     catch
     {
         return false;
     }
 }

 public bool ValidateConnection(XlsFileConnection conn, string fileNamePath, WaitDialogForm wait)
 {
     if (conn.Open() == null)
     {
         if (wait != null) wait.Close();
         if (conn.ConnectionError == XlsFileErrorCode.NOT_EXCEL_FORMATED)
         {
             HelpMsgBox.ShowNotificationMessage("Tập tin \"" + fileNamePath + "\" không phải định dạng excel!");
         }
         else if (conn.ConnectionError == XlsFileErrorCode.PASSWORD_PROTECTED)
         {
             HelpMsgBox.ShowNotificationMessage("Tập tin \"" + new FileInfo(fileNamePath).Name + "\" đã được bảo vệ bằng mật khẩu!");
         }
         else
         {
             HelpMsgBox.ShowNotificationMessage("Truy cập vào tập tin \"" + fileNamePath + "\" không thành công!");
         }
         return false;
     }
     return true;
 }

        public bool DataCheck(string projectSUID)
        {
            string strCon1 = ",PSP_ELCDEVICE WHERE PSPDEV.SUID = PSP_ELCDEVICE.DeviceSUID AND PSP_ELCDEVICE.ProjectSUID = '" + projectSUID + "'";
            string strCon2 = null;
            string strCon = null;
            {
                WaitDialogForm wait = new WaitDialogForm("", "正在处理数据, 请稍候...");
                strCon2 = " AND Type = '01'";
                strCon = strCon1 + strCon2;
                IList listMX = Services.BaseService.GetList("SelectPSPDEVByCondition", strCon);
                strCon2 = " AND Type = '05'";
                strCon = strCon1 + strCon2;
                IList listXL = Services.BaseService.GetList("SelectPSPDEVByCondition", strCon);
                strCon2 = " AND Type = '02'";
                strCon = strCon1 + strCon2;
                IList listBYQ2 = Services.BaseService.GetList("SelectPSPDEVByCondition", strCon);
                strCon2 = " AND Type = '03'";
                strCon = strCon1 + strCon2;
                IList listBYQ3 = Services.BaseService.GetList("SelectPSPDEVByCondition", strCon);
                Hashtable ht = new Hashtable();

                foreach (PSPDEV dev in listMX)
                {
                    if (dev.Number <= 0)
                    {
                        wait.Close();
                        MessageBox.Show("母线" + dev.Name + "编号不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        return false;
                    }
                    else
                    {
                        if (ht.Contains(dev.Number))
                        {
                            wait.Close();
                            MessageBox.Show("母线" + dev.Name + "," + ((PSPDEV)ht[dev.Number]).Name + "编号重复", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            return false;
                        }
                        else
                        {
                            ht.Add(dev.Number, dev);
                        }
                    }
                    if (dev.KSwitchStatus=="投入运行"||dev.KSwitchStatus=="退出运行")
                    {
                        wait.Close();
                        MessageBox.Show("母线" + dev.Name + "运行方式重新点击一次", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        return false;
                    }
                }
                ht.Clear();
                foreach (PSPDEV dev in listXL)
                {
                    if (dev.Number <= 0)
                    {
                        //wait.Close();
                        //MessageBox.Show("线路" + dev.Name + "编号不能为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        //return false;
                    }
                    else
                    {
                        if (dev.FirstNode <= 0)
                        {
                            wait.Close();
                            MessageBox.Show("线路" + dev.Name + "没有i侧母线", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            return false;
                        }
                        if (dev.LastNode <= 0)
                        {
                            wait.Close();
                            MessageBox.Show("线路" + dev.Name + "没有j侧母线", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            return false;
                        }
                        if (ht.Contains(dev.Number))
                        {
                            wait.Close();
                            MessageBox.Show("线路" + dev.Name + "," + ((PSPDEV)ht[dev.Number]).Name + "编号重复", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            return false;
                        }
                        else
                        {
                            ht.Add(dev.Number, dev);
                        }
                    }
                    if (dev.KSwitchStatus == "投入运行" || dev.KSwitchStatus == "退出运行")
                    {
                        wait.Close();
                        MessageBox.Show("线路" + dev.Name + "运行方式重新点击一次", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        return false;
                    }
                }
                foreach (PSPDEV dev in listBYQ2)
                {
                    if (dev.FirstNode <= 0)
                    {
                        wait.Close();
                        MessageBox.Show("两绕组变压器" + dev.Name + "没有i侧母线", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        return false;
                    }
                    if (dev.LastNode <= 0)
                    {
//.........这里部分代码省略.........

        private void barSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            if (treeList1.FocusedNode == null)
                return;
            string uid = treeList1.FocusedNode["UID"].ToString();
            EconomyAnalysis obj = Services.BaseService.GetOneByKey<EconomyAnalysis>(uid);
            System.IO.MemoryStream ms=new System.IO.MemoryStream();
            WaitDialogForm wait = null;
            try
            {
                wait = new WaitDialogForm("", "���ڱ�������, ���Ժ�...");
                textBox1.Focus();
                fpSpread1.Update();
                fpSpread1.Save(ms, false);

                obj.Contents = ms.GetBuffer();
                Services.BaseService.Update("UpdateEconomyAnalysisByContents", obj);
                excelstate = false;
                wait.Close();
                MsgBox.Show("����ɹ�");

            }
            catch (Exception ex) { wait.Close();
                MsgBox.Show("����ʧ��");}
        }

        private void IsSave()
        {
            if (!editrights)
                return;

            if (MsgBox.ShowYesNo("�����Ѿ������ı䣬�Ƿ񱣴棿") != DialogResult.Yes)
            {
                return;
            }

            WaitDialogForm wait = null;
            EconomyAnalysis obj = Services.BaseService.GetOneByKey<EconomyAnalysis>(uid1);
            System.IO.MemoryStream ms = new System.IO.MemoryStream();

            try
            {
                wait = new WaitDialogForm("", "���ڱ�������, ���Ժ�...");
                fpSpread1.Save(ms, false);

                obj.Contents = ms.GetBuffer();
                Services.BaseService.Update("UpdateEconomyAnalysisByContents", obj);
                wait.Close();
                MsgBox.Show("����ɹ�");
                excelstate = false;
            }
            catch
            {
                wait.Close();
                MsgBox.Show("����ʧ��");

            }
        }

        private void InitData1()
        {
            if (excelstate)
            {
                IsSave();
            }

            if (treeList1.FocusedNode == null)
                return;

            if (treeList1.FocusedNode.ParentNode == null)
            {
                barEdititem.Enabled=false;
                barDelitem.Enabled = false;
                barCS.Enabled = false;
                barButtonItem5.Enabled = false;
                barSave.Enabled = false;
            }
            else
            {
                barEdititem.Enabled = true ;
                barDelitem.Enabled = true;
                barCS.Enabled = true;
                barButtonItem5.Enabled = true;
                barSave.Enabled = true;
            }

            excelstate = false;

            if (!isloadstate)
                return;

            string uid = treeList1.FocusedNode["UID"].ToString();
            uid1 = uid;
            EconomyAnalysis obj = Services.BaseService.GetOneByKey<EconomyAnalysis>(uid);

            WaitDialogForm wait = null;
            try
            {
                wait = new WaitDialogForm("", "���ڼ�������, ���Ժ�...");
                System.IO.MemoryStream ms = new System.IO.MemoryStream(obj.Contents);
                by1 = obj.Contents;
                fpSpread1.Open(ms);

                try
                {
                    fpSpread1.Sheets[0].Cells[0, 0].Text = "����1 " + treeList1.FocusedNode["Title"].ToString() + "��������";
                }
                catch { }

                wait.Close();

                try
                {
                    nianshu1 = int.Parse(fpSpread1.Sheets[8].GetValue(10, 3).ToString());
                }
                catch { }

                try
                {
                    kaishinian = int.Parse(fpSpread1.Sheets[8].GetValue(9, 3).ToString());
                    xiangmunian1 = int.Parse(fpSpread1.Sheets[8].GetValue(13, 3).ToString());
                    lixinian1 = int.Parse(fpSpread1.Sheets[8].GetValue(2, 1).ToString());
                }
                catch { }

            }
            catch { wait.Close(); }
        }

        private void barButtonItem13_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            if (treeList1.FocusedNode == null)
            {
                return;
            }

            //if (treeList1.FocusedNode.ParentNode == null)
            //{
            //    MsgBox.Show("一级项目名称不能修改！");
            //    return;
            //}
            if (treeList1.FocusedNode.HasChildren)
            {
                MsgBox.Show("此项目下有子项目，不允许修改此记录！");
                return;
            }
            FormAddInfo_LangFang frm = new FormAddInfo_LangFang();
            frm.FlagId = typeFlag2;
            frm.PowerUId =this.treeList1.FocusedNode.GetValue("ID").ToString();
            frm.Text = "修改项目";
            frm.Isupdate = true;
            if (frm.ShowDialog() == DialogResult.OK)
            {
                int i = this.treeList1.FocusedNode.Id;

                WaitDialogForm wait = null;

                try
                {
                    wait = new WaitDialogForm("", "正在计算数据, 请稍候...");
                    LoadDatadata();
                    wait.Close();
                    //MsgBox.Show("计算成功");

                }
                catch
                {
                    wait.Close();
                }

                //obj = frm.OBJ;
                TreeListColumn column = treeList1.Columns["L10"];
                CalculateSum(treeList1.FindNodeByID(i).ParentNode, column, 0,true);

                ////try
                ////{
                ////    string id = treeList1.FocusedNode["ID"].ToString();
                ////    string flag22 = typeFlag2;

                ////    PSP_PowerProValues_LangFang pptss = new PSP_PowerProValues_LangFang();
                ////    pptss.ID = id;
                ////    pptss.Flag2 = flag22;

                ////    PSP_PowerProValues_LangFang psp_Type = Services.BaseService.GetOneByKey<PSP_PowerProValues_LangFang>(pptss);
                ////    psp_Type.L3 = frm.TypeTitle;
                ////psp_Type.Flag = frm.PowerType;
                ////Common.Services.BaseService.Update<PSP_PowerProValues_LangFang>(psp_Type);

                ////    if (psp_Type.Code != "")
                ////    {
                ////        LineInfo li3 = Services.BaseService.GetOneByKey<LineInfo>(psp_Type.Code);
                ////        if (li3 != null)
                ////        {
                ////            li3.LineName = psp_Type.L3;
                ////            Common.Services.BaseService.Update<LineInfo>(li3);
                ////        }

                ////        substation sb3 = Services.BaseService.GetOneByKey<substation>(psp_Type.Code);
                ////        if (sb3 != null)
                ////        {
                ////            sb3.EleName = psp_Type.L3;
                ////            Common.Services.BaseService.Update<substation>(sb3);
                ////        }
                ////    }

                ////    treeList1.FocusedNode.SetValue("L3", frm.TypeTitle);
                ////    FoucsLocation(id, treeList1.Nodes);
                ////}
                ////catch (Exception ex)
                ////{
                ////    //MsgBox.Show("修改出错：" + ex.Message);
                ////}
            }
        }

        private void treeList1_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
        {
            if (treeList1.FocusedNode == null)
                return;

            string uid = treeList1.FocusedNode["UID"].ToString();
            LayoutContent obj = Services.BaseService.GetOneByKey<LayoutContent>(uid);
            WaitDialogForm wait=null;

            WordBuilder wb = new WordBuilder();
            //if (fb != null)
            //    wb.InsertFromStreamGzip(fb);

            try
            {
                wait = new WaitDialogForm("", "������������, ���Ժ�...");

                if (obj.Contents != null && obj.Contents.Length > 0)
                {
                    if (fb != null)
                    {
                        wb.InsertFromStreamGzip(obj.Contents);
                        dsoFramerWordControl1.FileData = wb.FileData;
                    }
                    else
                    {
                        dsoFramerWordControl1.FileDataGzip = obj.Contents;
                    }
                }
                else
                {
                    dsoFramerWordControl1.FileNew();
                }
                dsoFramerWordControl1.AxFramerControl.Menubar = true;
                wait.Close();
            }
            catch (Exception ex)
            {
                wait.Close();
            MessageBox.Show(ex.Message);

            }
        }

        private void barBtnRefreshData_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            WaitDialogForm newwait = new WaitDialogForm("", "正在更新数据, 请稍候...");
            //生成一个空表用来保存当前表
            FarPoint.Win.Spread.SheetView obj_sheet = null;
            //生成一个空表，行列值都设为0用来做为程序处理时的当前表，这样可以提高处理速度
            FarPoint.Win.Spread.SheetView activesheet = new FarPoint.Win.Spread.SheetView();
            activesheet.RowCount = 0;
            activesheet.ColumnCount = 0;
            //添加空表
            fpSpread1.Sheets.Add(activesheet);
            //保留当前表，以备程序结束后还原当前表
            obj_sheet = fpSpread1.ActiveSheet;
            //将空表设为当前表
            fpSpread1.ActiveSheet = activesheet;

            //更新表3-1
            sh31.Sheet_AddData(fpSpread1.Sheets[0], year, ProjID, SxXjName);
            sh31.CellType(fpSpread1.Sheets[0]);

            //移除空表
            fpSpread1.Sheets.Remove(activesheet);
            //还原当前表
            fpSpread1.ActiveSheet = obj_sheet;
            //设文本自动换行
            fc.Sheet_Colautoenter(fpSpread1);
            newwait.Close();
            MessageBox.Show("更新数据完成！");
        }

        private void btJSDJ_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) {
            //计算列表中所有台区下的低压线路
            int ncount = 0;
            WaitDialogForm dlg = new WaitDialogForm("", "正计算档距，请稍候。。。");
            string info = "(第{0}共" + gridView1.RowCount + "个){1}";
            try {
                foreach (var item in gridViewOperation.BindingList) {
                    ncount++;

                    dlg.Caption = string.Format(info, ncount, item.tqName);
                    SbFuns.CountTQLen(item.tqCode);

                }
            } catch (Exception err) {
                dlg.Close();
                throw err;
            }
            dlg.Close();
            MsgBox.ShowTipMessageBox("计算完毕,共计算了" + ncount + "个台区。");
        }

        //���仯�����¸ı�word����
        private void treeList1_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
        {
            killAllProcess();
            //���㷢���仯ʱ�����ݿ�����ȡ�µ�word�ļ�
            if (treeList1.FocusedNode == null)
                return;
            string uid = treeList1.FocusedNode["UID"].ToString();
            LayoutContentANTL obj = Services.BaseService.GetOneByKey<LayoutContentANTL>(uid);
            WaitDialogForm wait=null;
            WordBuilder wb = new WordBuilder();

            // public static Word.Bookmarks W_Bkm =

            //if (fb != null)
            //    wb.InsertFromStreamGzip(fb);

            //��һ�µ�ǰword�еı�ǩ
            //�ı�һ�µ�ǰ��¼��word��UID���Ա����±�ǩʱʹ��
            LayoutID = treeList1.FocusedNode["UID"].ToString();

            try
            {
                wait = new WaitDialogForm("", "������������, ���Ժ�...");

                if (obj.Contents != null && obj.Contents.Length > 0)
                {
                    if (fb != null)
                    {
                        wb.InsertFromStreamGzip(obj.Contents);
                        dsoFramerWordControl1.FileData = wb.FileData;
                        Staword = wb;

                    }
                    else
                    {
                        dsoFramerWordControl1.FileDataGzip = obj.Contents;
                    }
                }
                else
                {
                    dsoFramerWordControl1.FileNew();
                }
                dsoFramerWordControl1.AxFramerControl.Menubar = true;
                if(dsoFramerWordControl1.AxFramerControl.DocumentFullName!=null)
                {
                 W_Doc = (Word.Document)dsoFramerWordControl1.AxFramerControl.ActiveDocument;
                }

                wait.Close();

            }

            catch (Exception ex)
            {
                wait.Close();
            MessageBox.Show(ex.Message);

            }
        }