Example #1
0
        /// <summary>
        /// 修改焦点对象
        /// </summary>
        public void UpdateObject()
        {
            //获取焦点对象
            BurdenLine obj = FocusedObject;

            if (obj == null)
            {
                return;
            }

            //创建对象的一个副本
            BurdenLine objCopy = new BurdenLine();

            DataConverter.CopyTo <BurdenLine>(obj, objCopy);
            FrmBurdenLine v = new  FrmBurdenLine();

            //执行修改操作
            using (FrmBurdenLineDialog dlg = new FrmBurdenLineDialog())
            {
                dlg.Object = objCopy;                   //绑定副本

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

            //用副本更新焦点对象
            DataConverter.CopyTo <BurdenLine>(objCopy, obj);
            //刷新表格
            gridControl.RefreshDataSource();
            v.refeshchart();
        }
Example #2
0
        /// <summary>
        /// 添加对象
        /// </summary>
        public void AddObject()
        {
            //检查对象链表是否已经加载
            if (ObjectList == null)
            {
                return;
            }
            //新建对象
            BurdenLine obj = new BurdenLine();

            obj.UID        = Guid.NewGuid().ToString() + "|" + Itop.Client.MIS.ProgUID;
            obj.BurdenDate = DateTime.Now;

            //执行添加操作
            using (FrmBurdenLineDialog dlg = new FrmBurdenLineDialog())
            {
                dlg.IsCreate = true;                    //设置新建标志
                dlg.Object   = obj;
                if (dlg.ShowDialog() != DialogResult.OK)
                {
                    return;
                }
            }

            //将新对象加入到链表中
            ObjectList.Add(obj);

            //刷新表格,并将焦点行定位到新对象上。
            gridControl.RefreshDataSource();
            GridHelper.FocuseRow(this.gridView, obj);
        }
Example #3
0
        private void gridView_CustomDrawCell(object sender, DevExpress.XtraGrid.Views.Base.RowCellCustomDrawEventArgs e)
        {
            Brush     brush = null;
            Rectangle r     = e.Bounds;
            int       year  = 0;
            Color     c1    = Color.FromArgb(255, 121, 121);
            Color     c2    = Color.FromArgb(255, 121, 121);
            Color     c3    = Color.FromArgb(152, 122, 254);
            Color     c4    = Color.FromArgb(152, 122, 254);
            object    dr    = this.gridView.GetRow(e.RowHandle);

            if (dr == null)
            {
                return;
            }
            BurdenLine bl = (BurdenLine)dr;

            //if (e.Column.FieldName == "BurdenDate")
            //{
            double imax = 0;
            double j    = 0;

            for (int i = 1; i <= 24; i++)
            {
                j = Convert.ToDouble(bl.GetType().GetProperty("Hour" + i).GetValue(bl, null));
                if (imax < j)
                {
                    imax = j;
                }
            }
            //}

            if (bl.IsType && e.Column.FieldName.Contains("Hour"))
            {
                if (imax.ToString() == e.CellValue.ToString())
                {
                    brush = new System.Drawing.Drawing2D.LinearGradientBrush(e.Bounds, c3, c4, 180);
                    if (brush != null)
                    {
                        e.Graphics.FillRectangle(brush, r);
                    }
                }
            }
            if (bl.IsMaxDate && e.Column.FieldName.Contains("Hour"))
            {
                if (imax.ToString() == e.CellValue.ToString())
                {
                    brush = new System.Drawing.Drawing2D.LinearGradientBrush(e.Bounds, c1, c2, 180);
                    if (brush != null)
                    {
                        e.Graphics.FillRectangle(brush, r);
                    }
                }
            }
        }
Example #4
0
        /// <summary>
        /// 删除焦点对象
        /// </summary>
        public void DeleteObject()
        {
            //获取焦点对象
            BurdenLine obj = FocusedObject;

            if (obj == null)
            {
                return;
            }

            //请求确认
            if (MsgBox.ShowYesNo(Strings.SubmitDelete) != DialogResult.Yes)
            {
                return;
            }

            //执行删除操作
            try
            {
                Services.BaseService.Delete <BurdenLine>(obj);
            }
            catch (Exception exc)
            {
                Debug.Fail(exc.Message);
                HandleException.TryCatch(exc);
                return;
            }

            this.gridView.BeginUpdate();
            //记住当前焦点行索引
            int iOldHandle = this.gridView.FocusedRowHandle;

            //从链表中删除
            ObjectList.Remove(obj);

            //刷新表格
            gridControl.RefreshDataSource();
            //设置新的焦点行索引
            GridHelper.FocuseRowAfterDelete(this.gridView, iOldHandle);
            this.gridView.EndUpdate();
        }
Example #5
0
        private void ItemTextEditBurdenYear_Validating(object sender, CancelEventArgs e)
        {
            DevExpress.XtraEditors.TextEdit tx = (DevExpress.XtraEditors.TextEdit)sender;

            int yeardata = 0;

            try
            {
                yeardata = int.Parse(tx.Text);
            }
            catch { }
            double powerdata = 0;
            double t1        = 0;
            double t2        = 0;

            try
            {
                powerdata = (double)Services.BaseService.GetObject("SelectPowerData", yeardata);
            }
            catch { }

            BurdenLine bl = new BurdenLine();

            try
            {
                bl        = new BurdenLine();
                bl.UID    = yeardata.ToString();
                bl.Season = "夏季";
                IList <BurdenLine> li1 = Services.BaseService.GetList <BurdenLine>("SelectBurdenLineBySeasonandDate", bl);
                foreach (BurdenLine bl1 in li1)
                {
                    t1 = Math.Max(t1, bl1.Hour1);
                    t1 = Math.Max(t1, bl1.Hour2);
                    t1 = Math.Max(t1, bl1.Hour3);
                    t1 = Math.Max(t1, bl1.Hour4);
                    t1 = Math.Max(t1, bl1.Hour5);
                    t1 = Math.Max(t1, bl1.Hour6);
                    t1 = Math.Max(t1, bl1.Hour7);
                    t1 = Math.Max(t1, bl1.Hour8);
                    t1 = Math.Max(t1, bl1.Hour9);
                    t1 = Math.Max(t1, bl1.Hour10);
                    t1 = Math.Max(t1, bl1.Hour11);
                    t1 = Math.Max(t1, bl1.Hour12);
                    t1 = Math.Max(t1, bl1.Hour13);
                    t1 = Math.Max(t1, bl1.Hour14);
                    t1 = Math.Max(t1, bl1.Hour15);
                    t1 = Math.Max(t1, bl1.Hour16);
                    t1 = Math.Max(t1, bl1.Hour17);
                    t1 = Math.Max(t1, bl1.Hour18);
                    t1 = Math.Max(t1, bl1.Hour19);
                    t1 = Math.Max(t1, bl1.Hour20);
                    t1 = Math.Max(t1, bl1.Hour21);
                    t1 = Math.Max(t1, bl1.Hour22);
                    t1 = Math.Max(t1, bl1.Hour23);
                    t1 = Math.Max(t1, bl1.Hour24);
                }
            }
            catch { }

            try
            {
                bl        = new BurdenLine();
                bl.UID    = yeardata.ToString();
                bl.Season = "冬季";
                IList <BurdenLine> li2 = Services.BaseService.GetList <BurdenLine>("SelectBurdenLineBySeasonandDate", bl);
                foreach (BurdenLine bl2 in li2)
                {
                    t2 = Math.Max(t2, bl2.Hour1);
                    t2 = Math.Max(t2, bl2.Hour2);
                    t2 = Math.Max(t2, bl2.Hour3);
                    t2 = Math.Max(t2, bl2.Hour4);
                    t2 = Math.Max(t2, bl2.Hour5);
                    t2 = Math.Max(t2, bl2.Hour6);
                    t2 = Math.Max(t2, bl2.Hour7);
                    t2 = Math.Max(t2, bl2.Hour8);
                    t2 = Math.Max(t2, bl2.Hour9);
                    t2 = Math.Max(t2, bl2.Hour10);
                    t2 = Math.Max(t2, bl2.Hour11);
                    t2 = Math.Max(t2, bl2.Hour12);
                    t2 = Math.Max(t2, bl2.Hour13);
                    t2 = Math.Max(t2, bl2.Hour14);
                    t2 = Math.Max(t2, bl2.Hour15);
                    t2 = Math.Max(t2, bl2.Hour16);
                    t2 = Math.Max(t2, bl2.Hour17);
                    t2 = Math.Max(t2, bl2.Hour18);
                    t2 = Math.Max(t2, bl2.Hour19);
                    t2 = Math.Max(t2, bl2.Hour20);
                    t2 = Math.Max(t2, bl2.Hour21);
                    t2 = Math.Max(t2, bl2.Hour22);
                    t2 = Math.Max(t2, bl2.Hour23);
                    t2 = Math.Max(t2, bl2.Hour24);
                }
            }
            catch { }

            if (t1 != 0)
            {
                Object.SummerData = powerdata / t1;
            }
            if (t2 != 0)
            {
                Object.WinterData = powerdata / t2;
            }
        }
        protected bool SaveRecord()
        {
            //����/�޸� ����

            if (_obj.BurdenDate == null)
            {
                MsgBox.Show("��ѡ������!");
                return false;
            }

            if (_isCreate)
            {
                BurdenLine bl=new BurdenLine();
                bl.BurdenDate=_obj.BurdenDate;
                if ((int)Services.BaseService.GetObject("SelectBurdenLineByDate", bl) > 0)
                {
                    MsgBox.Show("�Ѵ�����ͬ���ڣ�������ѡ��!");
                    return false;
                }
            }

            try
            {
                double minData = 0;
                double maxData = 0;
                double sumData = 0;

                for (int i = 1; i <= 24; i++)
                {
                    PropertyInfo pi = _obj.GetType().GetProperty("Hour" + i.ToString());
                    if (i == 1)
                    {
                        minData = (double)pi.GetValue(_obj, null);
                        maxData = (double)pi.GetValue(_obj, null);
                        sumData = (double)pi.GetValue(_obj, null);
                    }
                    else
                    {
                        minData = Math.Min((double)pi.GetValue(_obj, null), minData);
                        maxData = Math.Max((double)pi.GetValue(_obj, null), maxData);
                        sumData += (double)pi.GetValue(_obj, null);
                    }
                }

                if (sumData==0)
                {

                    _obj.DayAverage = sumData;
                    _obj.MinAverage = sumData;
                }
                else
                {
                    _obj.DayAverage = sumData / (24 * maxData);
                    _obj.MinAverage = minData / maxData;

                }

                //_obj.AreaID=repositoryItemComboBox3.p

                if (IsCreate)
                {
                    Services.BaseService.Create<BurdenLine>(_obj);
                }
                else
                {
                    Services.BaseService.Update<BurdenLine>(_obj);
                }
            }
            catch (Exception exc)
            {
                Debug.Fail(exc.Message);
                HandleException.TryCatch(exc);
                return false ;
            }

            //�����ѳɹ�
            return true;
        }
        protected bool SaveRecord()
        {
            //创建/修改 对象

            if (_obj.BurdenDate == null)
            {
                MsgBox.Show("请选择日期!");
                return(false);
            }

            if (_isCreate)
            {
                BurdenLine bl = new BurdenLine();
                bl.BurdenDate = _obj.BurdenDate;
                if ((int)Services.BaseService.GetObject("SelectBurdenLineByDate", bl) > 0)
                {
                    MsgBox.Show("已存在相同日期,请重新选择!");
                    return(false);
                }
            }



            try
            {
                double minData = 0;
                double maxData = 0;
                double sumData = 0;

                for (int i = 1; i <= 24; i++)
                {
                    PropertyInfo pi = _obj.GetType().GetProperty("Hour" + i.ToString());
                    if (i == 1)
                    {
                        minData = (double)pi.GetValue(_obj, null);
                        maxData = (double)pi.GetValue(_obj, null);
                        sumData = (double)pi.GetValue(_obj, null);
                    }
                    else
                    {
                        minData  = Math.Min((double)pi.GetValue(_obj, null), minData);
                        maxData  = Math.Max((double)pi.GetValue(_obj, null), maxData);
                        sumData += (double)pi.GetValue(_obj, null);
                    }
                }

                if (sumData == 0)
                {
                    _obj.DayAverage = sumData;
                    _obj.MinAverage = sumData;
                }
                else
                {
                    _obj.DayAverage = sumData / (24 * maxData);
                    _obj.MinAverage = minData / maxData;
                }

                //_obj.AreaID=repositoryItemComboBox3.p

                if (IsCreate)
                {
                    Services.BaseService.Create <BurdenLine>(_obj);
                }
                else
                {
                    Services.BaseService.Update <BurdenLine>(_obj);
                }
            }
            catch (Exception exc)
            {
                Debug.Fail(exc.Message);
                HandleException.TryCatch(exc);
                return(false);
            }

            //操作已成功
            return(true);
        }
Example #8
0
        /// <summary>
        /// �޸Ľ������
        /// </summary>
        public void UpdateObject()
        {
            //��ȡ�������
            BurdenLine obj = FocusedObject;
            if (obj == null)
            {
                return;
            }

            //���������һ������
            BurdenLine objCopy = new BurdenLine();
            DataConverter.CopyTo<BurdenLine>(obj, objCopy);
            FrmBurdenLine v =new  FrmBurdenLine();
            //ִ���޸IJ���
            using (FrmBurdenLineDialog dlg = new FrmBurdenLineDialog())
            {
                dlg.Object = objCopy;   //�󶨸���

                if (dlg.ShowDialog() != DialogResult.OK)
                {

                    return;
                }
            }

            //�ø������½������
            DataConverter.CopyTo<BurdenLine>(objCopy, obj);
            //ˢ�±��
            gridControl.RefreshDataSource();
            v.refeshchart();
        }
Example #9
0
        /// <summary>
        /// ��Ӷ���
        /// </summary>
        public void AddObject()
        {
            //�����������Ƿ��Ѿ�����
            if (ObjectList == null)
            {
                return;
            }
            //�½�����
            BurdenLine obj = new BurdenLine();
            obj.UID = Guid.NewGuid().ToString() + "|" + Itop.Client.MIS.ProgUID;
            obj.BurdenDate = DateTime.Now;

            //ִ����Ӳ���
            using (FrmBurdenLineDialog dlg = new FrmBurdenLineDialog())
            {
                dlg.IsCreate = true;    //�����½���־
                dlg.Object = obj;
                if (dlg.ShowDialog() != DialogResult.OK)
                {
                    return;
                }
            }

            //���¶�����뵽������
            ObjectList.Add(obj);

            //ˢ�±�񣬲��������ж�λ���¶����ϡ�
            gridControl.RefreshDataSource();
            GridHelper.FocuseRow(this.gridView, obj);
        }
Example #10
0
        private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {
                DataTable dts = new DataTable();
                OpenFileDialog op = new OpenFileDialog();
                op.Filter = "Excel�ļ�(*.xls)|*.xls";
                if (op.ShowDialog() == DialogResult.OK)
                {
                    dts = GetExcel(op.FileName);
                    for (int k = 0; k < dts.Rows.Count; k++)
                    {
                        string year = dts.Rows[k][1].ToString();
                        //string da = dts.Rows[1][1].ToString();
                        //string jj = da.Substring(0, 2);
                        //string day = year + da.Substring(2, da.Length - 2).Replace("(", "").Replace(")", "").Replace("��", "").Replace("��", "");

                        BurdenLine bl = new BurdenLine();
                        bl.UID = bl.UID + "|" + Itop.Client.MIS.ProgUID;
                     try{
                        bl.BurdenDate = DateTime.Parse(year);
                     }catch{
                         bl.BurdenDate = DateTime.Now;
                     }
                     bl.UID = "Datename(year,BurdenDate)='" + bl.BurdenDate.Year
                         + "' and (Datename (month,BurdenDate)='" + bl.BurdenDate.Month + "'or Datename (month,BurdenDate)='0" + bl.BurdenDate.Month
                         + "') and (Datename(day,BurdenDate) ='" + bl.BurdenDate.Day + " ' or Datename(day,BurdenDate) ='0" + bl.BurdenDate.Day
                         + "') and  uid like '%" + Itop.Client.MIS.ProgUID + "%'  ";
                     IList<BurdenLine> lis = Common.Services.BaseService.GetList<BurdenLine>("SelectBurdenLineByWhere", bl.UID);
                     bool flag = false;
                     foreach (BurdenLine bltemp in lis)
                     {

                         flag = true;
                         bl.UID = bltemp.UID;
                         break;

                         //else
                         //{
                         //    if (bl.BurdenDate.Year < 1900)
                         //        bl.BurdenDate = DateTime.Now;
                         //}

                     }
                        if (!flag)
                        {
                            bl.UID = Guid.NewGuid().ToString() + "|" + Itop.Client.MIS.ProgUID;
                        }

                     string pjt = " ProjectID='" + MIS.ProgUID + "'and Title='" + dts.Rows[k][0].ToString() + "'";
                     PS_Table_AreaWH lt = (PS_Table_AreaWH)Common.Services.BaseService.GetObject("SelectPS_Table_AreaWHByConn", pjt);
                     if (lt != null)
                     {
                         bl.AreaID = lt.ID;
                     }

                        if (dts.Rows[k][2].ToString().Length>1)
                        bl.Season = dts.Rows[k][2].ToString().Substring(0, 2);
                        try{
                            bl.Hour1 = double.Parse(dts.Rows[k][3].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour2 = double.Parse(dts.Rows[k][4].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour3 = double.Parse(dts.Rows[k][5].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour4 = double.Parse(dts.Rows[k][6].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour5 = double.Parse(dts.Rows[k][7].ToString());

                        }
                        catch{}
                        try{
                         bl.Hour6 = double.Parse(dts.Rows[k][8].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour7 = double.Parse(dts.Rows[k][9].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour8 = double.Parse(dts.Rows[k][10].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour9 = double.Parse(dts.Rows[k][11].ToString());
                        }

                        catch{}
                        try{
                        bl.Hour10 = double.Parse(dts.Rows[k][12].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour11 = double.Parse(dts.Rows[k][13].ToString());
                        }

                        catch{}
                        try{
                        bl.Hour12 = double.Parse(dts.Rows[k][14].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour13 = double.Parse(dts.Rows[k][15].ToString());
                        }

                        catch{}
                        try{
                        bl.Hour14 = double.Parse(dts.Rows[k][16].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour15 = double.Parse(dts.Rows[k][17].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour16 = double.Parse(dts.Rows[k][18].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour17 = double.Parse(dts.Rows[k][19].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour18 = double.Parse(dts.Rows[k][20].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour19 = double.Parse(dts.Rows[k][21].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour20 = double.Parse(dts.Rows[k][22].ToString());
                        }
                        catch { }
                        try
                        {
                        bl.Hour21 = double.Parse(dts.Rows[k][23].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour22 = double.Parse(dts.Rows[k][24].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour23 = double.Parse(dts.Rows[k][25].ToString());
                        }
                        catch{}
                        try{
                        bl.Hour24 = double.Parse(dts.Rows[k][26].ToString());
                        }
                        catch{}
                        try
                        {
                            if (dts.Rows[k][27].ToString()=="ѡ��")
                            {
                                bl.IsType = true;
                            }
                            else
                            {
                                bl.IsType = false;
                            }
                        }
                        catch
                        {
                        }
                        try
                        {
                            if (dts.Rows[k][28].ToString() == "ѡ��")
                            {
                                bl.IsMaxDate = true;
                            }
                            else
                            {
                                bl.IsMaxDate = false;
                            }
                        }
                        catch
                        {
                        }

                        double minData = 0;
                        double maxData = 0;
                        double sumData = 0;

                        for (int i = 1; i <= 24; i++)
                        {
                            PropertyInfo pi = bl.GetType().GetProperty("Hour" + i.ToString());
                            if (i == 1)
                            {
                                minData = (double)pi.GetValue(bl, null);
                                maxData = (double)pi.GetValue(bl, null);
                                sumData = (double)pi.GetValue(bl, null);
                            }
                            else
                            {
                                minData = Math.Min((double)pi.GetValue(bl, null), minData);
                                maxData = Math.Max((double)pi.GetValue(bl, null), maxData);
                                sumData += (double)pi.GetValue(bl, null);
                            }
                        }

                        bl.DayAverage = sumData / (24 * maxData);
                        bl.MinAverage = minData / maxData;

                       // bl.IsType = true;
                        Common.Services.BaseService.Delete<BurdenLine>(bl);
                        Common.Services.BaseService.Create<BurdenLine>(bl);
                        ctrlBurdenLine1.ObjectList.Add(bl);

                    }
                    ctrlBurdenLine1.RefreshData();
                    refeshchart();
                    MsgBox.Show("�ѳɹ��������� ��");
                }
            }
            catch { MsgBox.Show("�����ʽ����ȷ��"); }
        }
Example #11
0
        private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            try
            {
                DataTable      dts = new DataTable();
                OpenFileDialog op  = new OpenFileDialog();
                op.Filter = "Excel文件(*.xls)|*.xls";
                if (op.ShowDialog() == DialogResult.OK)
                {
                    dts = GetExcel(op.FileName);
                    for (int k = 0; k < dts.Rows.Count; k++)
                    {
                        string year = dts.Rows[k][1].ToString();
                        //string da = dts.Rows[1][1].ToString();
                        //string jj = da.Substring(0, 2);
                        //string day = year + da.Substring(2, da.Length - 2).Replace("(", "").Replace(")", "").Replace("(", "").Replace(")", "");

                        BurdenLine bl = new BurdenLine();
                        bl.UID = bl.UID + "|" + Itop.Client.MIS.ProgUID;
                        try{
                            bl.BurdenDate = DateTime.Parse(year);
                        }catch {
                            bl.BurdenDate = DateTime.Now;
                        }
                        bl.UID = "Datename(year,BurdenDate)='" + bl.BurdenDate.Year
                                 + "' and (Datename (month,BurdenDate)='" + bl.BurdenDate.Month + "'or Datename (month,BurdenDate)='0" + bl.BurdenDate.Month
                                 + "') and (Datename(day,BurdenDate) ='" + bl.BurdenDate.Day + " ' or Datename(day,BurdenDate) ='0" + bl.BurdenDate.Day
                                 + "') and  uid like '%" + Itop.Client.MIS.ProgUID + "%'  ";
                        IList <BurdenLine> lis = Common.Services.BaseService.GetList <BurdenLine>("SelectBurdenLineByWhere", bl.UID);
                        bool flag = false;
                        foreach (BurdenLine bltemp in lis)
                        {
                            flag   = true;
                            bl.UID = bltemp.UID;
                            break;


                            //else
                            //{
                            //    if (bl.BurdenDate.Year < 1900)
                            //        bl.BurdenDate = DateTime.Now;
                            //}
                        }
                        if (!flag)
                        {
                            bl.UID = Guid.NewGuid().ToString() + "|" + Itop.Client.MIS.ProgUID;
                        }

                        string          pjt = " ProjectID='" + MIS.ProgUID + "'and Title='" + dts.Rows[k][0].ToString() + "'";
                        PS_Table_AreaWH lt  = (PS_Table_AreaWH)Common.Services.BaseService.GetObject("SelectPS_Table_AreaWHByConn", pjt);
                        if (lt != null)
                        {
                            bl.AreaID = lt.ID;
                        }

                        if (dts.Rows[k][2].ToString().Length > 1)
                        {
                            bl.Season = dts.Rows[k][2].ToString().Substring(0, 2);
                        }
                        try{
                            bl.Hour1 = double.Parse(dts.Rows[k][3].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour2 = double.Parse(dts.Rows[k][4].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour3 = double.Parse(dts.Rows[k][5].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour4 = double.Parse(dts.Rows[k][6].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour5 = double.Parse(dts.Rows[k][7].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour6 = double.Parse(dts.Rows[k][8].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour7 = double.Parse(dts.Rows[k][9].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour8 = double.Parse(dts.Rows[k][10].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour9 = double.Parse(dts.Rows[k][11].ToString());
                        }

                        catch {}
                        try{
                            bl.Hour10 = double.Parse(dts.Rows[k][12].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour11 = double.Parse(dts.Rows[k][13].ToString());
                        }

                        catch {}
                        try{
                            bl.Hour12 = double.Parse(dts.Rows[k][14].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour13 = double.Parse(dts.Rows[k][15].ToString());
                        }

                        catch {}
                        try{
                            bl.Hour14 = double.Parse(dts.Rows[k][16].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour15 = double.Parse(dts.Rows[k][17].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour16 = double.Parse(dts.Rows[k][18].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour17 = double.Parse(dts.Rows[k][19].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour18 = double.Parse(dts.Rows[k][20].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour19 = double.Parse(dts.Rows[k][21].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour20 = double.Parse(dts.Rows[k][22].ToString());
                        }
                        catch { }
                        try
                        {
                            bl.Hour21 = double.Parse(dts.Rows[k][23].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour22 = double.Parse(dts.Rows[k][24].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour23 = double.Parse(dts.Rows[k][25].ToString());
                        }
                        catch {}
                        try{
                            bl.Hour24 = double.Parse(dts.Rows[k][26].ToString());
                        }
                        catch {}
                        try
                        {
                            if (dts.Rows[k][27].ToString() == "选中")
                            {
                                bl.IsType = true;
                            }
                            else
                            {
                                bl.IsType = false;
                            }
                        }
                        catch
                        {
                        }
                        try
                        {
                            if (dts.Rows[k][28].ToString() == "选中")
                            {
                                bl.IsMaxDate = true;
                            }
                            else
                            {
                                bl.IsMaxDate = false;
                            }
                        }
                        catch
                        {
                        }


                        double minData = 0;
                        double maxData = 0;
                        double sumData = 0;

                        for (int i = 1; i <= 24; i++)
                        {
                            PropertyInfo pi = bl.GetType().GetProperty("Hour" + i.ToString());
                            if (i == 1)
                            {
                                minData = (double)pi.GetValue(bl, null);
                                maxData = (double)pi.GetValue(bl, null);
                                sumData = (double)pi.GetValue(bl, null);
                            }
                            else
                            {
                                minData  = Math.Min((double)pi.GetValue(bl, null), minData);
                                maxData  = Math.Max((double)pi.GetValue(bl, null), maxData);
                                sumData += (double)pi.GetValue(bl, null);
                            }
                        }

                        bl.DayAverage = sumData / (24 * maxData);
                        bl.MinAverage = minData / maxData;

                        // bl.IsType = true;
                        Common.Services.BaseService.Delete <BurdenLine>(bl);
                        Common.Services.BaseService.Create <BurdenLine>(bl);
                        ctrlBurdenLine1.ObjectList.Add(bl);
                    }
                    ctrlBurdenLine1.RefreshData();
                    refeshchart();
                    MsgBox.Show("已成功导入数据 !");
                }
            }
            catch { MsgBox.Show("导入格式不正确!"); }
        }