lixiaojun
2024-12-20 357693611c60d93fb17189273d4c91dab364f0d4
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
using DevExpress.XtraEditors;
using DevExpress.XtraSpreadsheet.Model;
using HStation.Vmo;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using Yw;
 
namespace HStation.WinFrmUI
{
    public partial class ImportAssetsCompressorCurveQLByExcelDlg : DevExpress.XtraEditors.XtraForm
    {
        public ImportAssetsCompressorCurveQLByExcelDlg()
        {
            InitializeComponent();
            this.IconOptions.Icon = Yw.WinFrmUI.GlobalParas.AppIcon;
            this.layoutControl1.SetupLayoutControl();
            this.generalOkAndCancelCtrl1.OkEvent += GeneralOkAndCancelCtrl1_OkEvent;
        }
 
        /// <summary>
        /// 重载事件
        /// </summary>
        public event Action<HStation.Vmo.PhartDiagramRelationVmo> ReloadDataEvent;
 
        private AssetsCompressorMainVmo _exchanger = null;//当前换热器
        private PhartDiagramRelationVmo _vmo = null;//曲线关联
 
        /// <summary>
        /// 绑定数据
        /// </summary>
        public void SetBindingData(AssetsCompressorMainVmo exchanger)
        {
            if (exchanger == null)
            {
                return;
            }
            _exchanger = exchanger;
            _vmo = new PhartDiagramRelationVmo();
            _vmo.ObjectType = HStation.Assets.DataType.CompressorMain;
            _vmo.ObjectID = exchanger.ID;
            _vmo.Importance = 0;
            this.txtImportance.EditValue = 0;
        }
 
        //验证
        private bool Valid()
        {
            this.dxErrorProvider1.ClearErrors();
            if (string.IsNullOrEmpty(this.btnEditExcel.Text.Trim()))
            {
                this.dxErrorProvider1.SetError(this.btnEditExcel, "必选项");
                return false;
            }
            if (string.IsNullOrEmpty(this.txtName.Text.Trim()))
            {
                this.dxErrorProvider1.SetError(this.txtName, "必填项");
                return false;
            }
            return true;
 
        }
 
        //确定
        private async void GeneralOkAndCancelCtrl1_OkEvent()
        {
            if (!Valid())
            {
                return;
            }
            var diagram = this.universalChartExcelImportCtrl1.Get();
            var diagramId = await BLLFactory<Yw.BLL.PhartDiagramExtensions>.Instance.Insert(diagram);
            if (diagramId < 1)
            {
                TipFormHelper.ShowError("图表信息保存失败!");
                return;
            }
            _vmo.DiagramID = diagramId;
            _vmo.OtherName = this.txtName.Text.Trim();
            _vmo.Importance = int.Parse(this.txtImportance.EditValue.ToString());
            _vmo.ID = await BLLFactory<HStation.BLL.PhartDiagramRelation>.Instance.Insert(_vmo);
            if (_vmo.ID < 1)
            {
                TipFormHelper.ShowError("图表关联信息保存失败!");
                return;
            }
            var vmo = await BLLFactory<HStation.BLL.PhartDiagramRelation>.Instance.GetByID(_vmo.ID);
            this.ReloadDataEvent?.Invoke(vmo);
            this.DialogResult = DialogResult.OK;
            this.Close();
        }
 
        //导入Excel
        private void btnEditExcel_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            var dlg = new OpenFileDialog();
            dlg.Title = "选择Excel文件";
            dlg.Filter = "Excel文件|*.xls";
            if (dlg.ShowDialog() == DialogResult.OK)
            {
                var fileName = dlg.FileName;
                this.btnEditExcel.EditValue = fileName;
                this.universalChartExcelImportCtrl1.SetBindingData(fileName, Yw.Ahart.eCurveType.QL);
            }
        }
 
        //模板导出
        private void btnTemplate_Click(object sender, EventArgs e)
        {
            var dlg = new SaveFileDialog();
            dlg.Title = "模板导出路径";
            dlg.Filter = "Excel文件|*.xls";
            if (dlg.ShowDialog() == DialogResult.OK)
            {
                var fileName = dlg.FileName;
                Yw.WinFrmUI.PhartExcelHelper.ExportUniversalTemplate(fileName, Yw.Ahart.eCurveType.QL);
                TipFormHelper.ShowSucceed("导出成功!");
            }
        }
 
 
    }
}