Exemple #1
0
        private void IsSave()
        {
            if (!editrights)
            {
                return;
            }

            if (MsgBox.ShowYesNo("数据已经发生改变,是否保存?") != DialogResult.Yes)
            {
                return;
            }


            WaitDialogForm wait = null;
            PspType        obj  = Services.BaseService.GetOneByKey <PspType>(uid1);

            System.IO.MemoryStream ms = new System.IO.MemoryStream();
            try
            {
                wait = new WaitDialogForm("", "正在保存数据, 请稍候...");

                obj.Contents = ms.GetBuffer();
                Services.BaseService.Update("UpdatePspTypeBy", obj);
                wait.Close();
                MsgBox.Show("保存成功");
                excelstate = false;
            }
            catch
            {
                wait.Close();
                MsgBox.Show("保存失败");
            }
        }
Exemple #2
0
        private void barEdititem_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            if (treeList1.FocusedNode == null)
            {
                return;
            }
            string  uid = treeList1.FocusedNode["UID"].ToString();
            PspType obj = Services.BaseService.GetOneByKey <PspType>(uid);

            PspType objCopy = new PspType();

            DataConverter.CopyTo <PspType>(obj, objCopy);

            FrmPspTypeDialog dlg = new FrmPspTypeDialog();

            dlg.Text   = progName;
            dlg.Object = objCopy;

            if (dlg.ShowDialog() != DialogResult.OK)
            {
                return;
            }

            DataConverter.CopyTo <PspType>(objCopy, obj);
            treeList1.FocusedNode.SetValue("Title", obj.Title);
        }
Exemple #3
0
        private void barAdd1item_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            if (treeList1.FocusedNode == null)
            {
                return;
            }
            string uid = treeList1.FocusedNode["UID"].ToString();


            PspType obj = new PspType();

            obj.UID        = obj.UID + "|" + ProjectUID;
            obj.Contents   = bts;
            obj.ParentID   = uid;
            obj.CreateDate = DateTime.Now;
            obj.Col1       = progName;
            FrmPspTypeDialog dlg = new FrmPspTypeDialog();

            dlg.Text     = progName;
            dlg.Object   = obj;
            dlg.IsCreate = true;

            if (dlg.ShowDialog() != DialogResult.OK)
            {
                return;
            }

            dataTable.Rows.Add(DataConverter.ObjectToRow(obj, dataTable.NewRow()));
        }
Exemple #4
0
        private void treeList1_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
        {
            if (excelstate)
            {
                IsSave();
            }


            if (treeList1.FocusedNode == null)
            {
                return;
            }

            excelstate = false;
            string uid = treeList1.FocusedNode["UID"].ToString();

            uid1 = uid;
            PspType obj = Services.BaseService.GetOneByKey <PspType>(uid);

            WaitDialogForm wait = null;

            try
            {
                wait = new WaitDialogForm("", "正在加载数据, 请稍候...");
                System.IO.MemoryStream ms = new System.IO.MemoryStream(obj.Contents);
                //by1 = obj.Contents;
                fpSpread1.Open(ms);
                wait.Close();

                fpSpread1.ActiveSheet.Columns[0, fpSpread1.ActiveSheet.Columns.Count - 1].AllowAutoFilter = true; //查询
                fpSpread1.Sheets[0].SetColumnAllowAutoSort(-1, true);                                             //排序
            }
            catch { wait.Close(); }
        }
Exemple #5
0
        private void IsSave()
        {
            if (!editrights)
            {
                return;
            }

            if (MsgBox.ShowYesNo("数据已经发生改变,是否保存?") != DialogResult.Yes)
            {
                return;
            }
            WaitDialogForm wait = null;
            PspType        obj  = Services.BaseService.GetOneByKey <PspType>(uid1);

            try
            {
                wait = new WaitDialogForm("", "正在保存数据, 请稍候...");
                dsoExcelControl1.AxFramerControl.Save(filename, true, null, null);
                obj.Contents = dsoExcelControl1.FileData1(filename);
                Services.BaseService.Update("UpdatePspTypeBy", obj);
                wait.Close();
                MsgBox.Show("保存成功");
                excelstate = false;
            }
            catch
            {
                wait.Close();
                MsgBox.Show("保存失败");
            }
        }
Exemple #6
0
        private void barAdditem_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            PspType obj = new PspType();

            obj.Contents   = bts;
            obj.ParentID   = "";
            obj.CreateDate = DateTime.Now;
            obj.Col1       = progName;
            FrmPspTypeDialog dlg = new FrmPspTypeDialog();

            dlg.Text     = progName;
            dlg.Object   = obj;
            dlg.IsCreate = true;

            if (dlg.ShowDialog() != DialogResult.OK)
            {
                return;
            }

            string uid = treeList1.FocusedNode["UID"].ToString();

            uid1 = uid;
            PspType obj1 = Services.BaseService.GetOneByKey <PspType>(uid);

            WaitDialogForm wait = null;

            try
            {
                wait = new WaitDialogForm("", "正在加载数据, 请稍候...");
                System.IO.MemoryStream ms = new System.IO.MemoryStream(obj1.Contents);
                //  by1 = obj.Contents;
                string str = "";
                str = filename;
                string fname = filepath + Guid.NewGuid().ToString() + ".xls";
                filename = fname;
                dsoExcelControl1.saveStreamFile(fname, ms.ToArray());
                dsoExcelControl1.FileOpen(fname);
                //  dsoExcelControl1.FileNew();
                dsoExcelControl1.AxFramerControl.Titlebar = false;
                dsoExcelControl1.Onisdispalymenubar(false);
                dsoExcelControl1.Onisdispalytoolbar(false);
                if (File.Exists(str))
                {
                    File.Delete(str);
                }
                //  fpSpread1.Open(ms);
                wait.Close();

                //fpSpread1.ActiveSheet.Columns[0, fpSpread1.ActiveSheet.Columns.Count - 1].AllowAutoFilter = true;//查询
                //fpSpread1.Sheets[0].SetColumnAllowAutoSort(-1, true);//排序
            }
            catch { wait.Close(); }


            dataTable.Rows.Add(DataConverter.ObjectToRow(obj, dataTable.NewRow()));
        }
Exemple #7
0
        private void barAdd1item_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            if (treeList1.FocusedNode == null)
            {
                return;
            }
            string uid = treeList1.FocusedNode["UID"].ToString();

            PspType obj = new PspType();

            obj.UID        = obj.UID + "|" + ProjectUID;
            obj.Contents   = bts;
            obj.ParentID   = uid;
            obj.CreateDate = DateTime.Now;
            obj.Col1       = ProjectUID;
            FrmPspTypeDialog dlg = new FrmPspTypeDialog();

            dlg.Text     = progName;
            dlg.Object   = obj;
            dlg.IsCreate = true;

            if (dlg.ShowDialog() != DialogResult.OK)
            {
                return;
            }
            WaitDialogForm wait = null;

            try
            {
                wait = new WaitDialogForm("", "正在加载数据, 请稍候...");
                //System.IO.MemoryStream ms = new System.IO.MemoryStream(obj1.Contents);
                ////  by1 = obj.Contents;
                string str = "";
                str = filename;
                string fname = filepath + Guid.NewGuid().ToString() + ".xls";
                filename = fname;
                dsoExcelControl1.AxFramerControl.Save(fname, false, null, null);
                //dsoExcelControl1.FileOpen(fname);

                //dsoExcelControl1.AxFramerControl.Titlebar = false;
                //dsoExcelControl1.Onisdispalymenubar(false);
                //dsoExcelControl1.Onisdispalytoolbar(false);

                wait.Close();
            }
            catch { wait.Close(); }
            dataTable.Rows.Add(DataConverter.ObjectToRow(obj, dataTable.NewRow()));
        }
Exemple #8
0
        private void treeList1_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
        {
            if (excelstate)
            {
                IsSave();
            }


            if (treeList1.FocusedNode == null)
            {
                return;
            }

            excelstate = false;
            string uid = treeList1.FocusedNode["UID"].ToString();

            uid1 = uid;
            PspType obj = Services.BaseService.GetOneByKey <PspType>(uid);

            WaitDialogForm wait = null;

            try
            {
                wait = new WaitDialogForm("", "正在加载数据, 请稍候...");
                System.IO.MemoryStream ms = new System.IO.MemoryStream(obj.Contents);
                //by1 = obj.Contents;
                string str = "";
                str = filename;
                string fname = filepath + Guid.NewGuid().ToString() + ".xls";
                filename = fname;
                dsoExcelControl1.saveStreamFile(fname, ms.ToArray());
                dsoExcelControl1.FileOpen(fname);
                dsoExcelControl1.AxFramerControl.Titlebar = false;
                dsoExcelControl1.Onisdispalymenubar(false);
                dsoExcelControl1.Onisdispalytoolbar(false);
                if (File.Exists(str))
                {
                    File.Delete(str);
                }
                //  fpSpread1.Open(ms);
                wait.Close();

                //fpSpread1.ActiveSheet.Columns[0, fpSpread1.ActiveSheet.Columns.Count - 1].AllowAutoFilter = true;//查询
                //fpSpread1.Sheets[0].SetColumnAllowAutoSort(-1, true);//排序
            }
            catch { wait.Close(); }
        }
Exemple #9
0
        private void InitData()
        {
            //if (!isSelect)
            //{
            //    switch (smmprog.ProgId)
            //    {
            //        case "64c9efcb-e6cc-402f-b2fc-f5f6f7d296f7":
            //            progName = "负荷特性分析";
            //            type = "fhtxfx";
            //            break;

            //        case "a50e1781-e470-4721-a6ee-c4b1294d6bd4":
            //            progName = "电网基础数据";
            //            type = "dwjcsj";
            //            break;

            //        case "3630adcc-9d4b-4059-b44e-4f88ccf76b43":
            //            progName = "电网规划基础表";
            //            type = "dwghjc";
            //            break;
            //    }


            //}

            PspType pt = new PspType();

            pt.Col1 = ProjectUID;
            ilist   = Services.BaseService.GetList("SelectPspTypeList", pt);
            //ilist = Services.BaseService.GetList<PspType>();
            dataTable            = DataConverter.ToDataTable(ilist, typeof(PspType));
            treeList1.DataSource = dataTable;

            Econ ed = new Econ();

            ed.UID = "Excel";
            try
            {
                bts = Services.BaseService.GetOneByKey <Econ>(ed).ExcelData;
            }
            catch { }
        }
Exemple #10
0
        private void barSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            if (treeList1.FocusedNode == null)
            {
                return;
            }
            string  uid = treeList1.FocusedNode["UID"].ToString();
            PspType obj = Services.BaseService.GetOneByKey <PspType>(uid);

            try
            {
                textBox1.Focus();
                dsoExcelControl1.AxFramerControl.Save(filename, true, null, null);
                obj.Contents = dsoExcelControl1.FileData1(filename);
                Services.BaseService.Update("UpdatePspTypeBy", obj);
                excelstate = false;
                MsgBox.Show("保存成功");
            }
            catch (Exception ex) { MsgBox.Show(ex.Message); }
        }
Exemple #11
0
        private void barSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            if (treeList1.FocusedNode == null)
            {
                return;
            }
            string  uid = treeList1.FocusedNode["UID"].ToString();
            PspType obj = Services.BaseService.GetOneByKey <PspType>(uid);

            System.IO.MemoryStream ms = new System.IO.MemoryStream();
            try
            {
                textBox1.Focus();
                fpSpread1.Update();
                fpSpread1.Save(ms, false);

                obj.Contents = ms.GetBuffer();
                Services.BaseService.Update("UpdatePspTypeBy", obj);
                excelstate = false;
                MsgBox.Show("保存成功");
            }
            catch (Exception ex) { MsgBox.Show(ex.Message); }
        }
Exemple #12
0
        private void treeList1_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
        {
            if (excelstate)
            {
                IsSave();
            }

            if (treeList1.FocusedNode == null)
            {
                return;
            }

            //barCheckItem1.Checked = false;
            //barCheckItem1.Caption = "显示标题栏";
            //barCheckItem2.Checked = false;
            //barCheckItem2.Caption = "显示菜单栏";
            //barCheckItem3.Checked = false;
            //barCheckItem3.Caption = "显示工具栏";
            //barCheckItem4.Checked = false;
            //barCheckItem4.Caption = "显示公式栏";
            excelstate = false;
            string uid = treeList1.FocusedNode["UID"].ToString();

            uid1 = uid;
            PspType obj = Services.BaseService.GetOneByKey <PspType>(uid);

            this.ctrlRtfAttachFiles1.Category = uid;
            this.ctrlRtfAttachFiles1.RefreshData();

            // WaitDialogForm wait = null;
            try
            {
                //wait = new WaitDialogForm("", "正在加载数据, 请稍候...");
                System.IO.MemoryStream ms = new System.IO.MemoryStream(obj.Contents);
                //by1 = obj.Contents;
                string str = "";
                str = filename;
                string fname = filepath + Guid.NewGuid().ToString() + ".xls";
                //string fname = filepath + "aaabbb.xls";
                filename = fname;
                dsoExcelControl1.saveStreamFile(fname, ms.ToArray());
                dsoExcelControl1.FileOpen(fname);
                //dsoExcelControl1.AxFramerControl.Titlebar = false;
                //dsoExcelControl1.Onisdispalymenubar(true);
                //dsoExcelControl1.Onisdispalytoolbar(true);
                //dsoExcelControl1.OnisdislayFormulaBar(true);
                try
                {
                    //dsoExcelControl2.FileNew();
                }
                catch { }

                if (i == 0)
                {
                    //Microsoft.Office.Interop.Excel.Workbook book = exc.Application.Workbooks.Add(fname); //引用Excel工作簿
                    //exc.Visible = false; //使Excel不可视
                    //i++;
                }


                //doc.Application.DisplayFormulaBar = false;
                if (File.Exists(str))
                {
                    File.Delete(str);
                }

                //wait.Close();
            }
            catch (Exception ex)
            {
                System.Console.WriteLine(ex.Message);//wait.Close();
            }
        }