/// <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(); }
/// <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); }
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); } } } }
/// <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(); }
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); }
/// <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(); }
/// <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); }
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("�����ʽ����ȷ��"); } }
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("导入格式不正确!"); } }