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);
}
}
}
}
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);
}
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("导入格式不正确！"); }
}
