private void barButtonItem3_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (this.gridView2.FocusedRowHandle >= 0)
{
if (MessageBox.Show("确定删除该地区？", "删除", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
PS_Table_AreaWH data = this.gridView2.GetRow(this.gridView2.FocusedRowHandle) as PS_Table_AreaWH;// new Ps_Table_GDP();
Common.Services.BaseService.Delete <PS_Table_AreaWH>(data);
}
}
InitGrid2();
}
private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
IList <string> filedList = new List <string>();
IList <string> capList = new List <string>();
for (int i = 0; i < gridView2.Columns.Count; i++)
{
if (gridView2.Columns[i].Visible == true)
{
capList.Add(gridView2.Columns[i].Caption);
filedList.Add(gridView2.Columns[i].FieldName);
}
}
OpenFileDialog op = new OpenFileDialog();
op.Filter = "Excel文件(*.xls)|*.xls";
if (op.ShowDialog() == DialogResult.OK)
{
try
{
DataTable table = OperTable.GetExcel(op.FileName, filedList, capList);
for (int i = 0; i < table.Rows.Count; i++)
{
if (table.Rows[i][0].ToString().IndexOf("建表时间") >= 0)
{
continue;
}
PS_Table_AreaWH area = new PS_Table_AreaWH();
area.ID += "|" + ProjectID;
area.ProjectID = ProjectID;
foreach (DataColumn col in table.Columns)
{
if (col.ColumnName == "Yearf")
{
area.GetType().GetProperty(col.ColumnName).SetValue(area, int.Parse(table.Rows[i][col].ToString()), null);
}
else
{
area.GetType().GetProperty(col.ColumnName).SetValue(area, table.Rows[i][col].ToString(), null);
}
}
Common.Services.BaseService.Create <PS_Table_AreaWH>(area);
}
}
catch { }
InitGrid2();
}
}
private void simpleButton5_Click(object sender, EventArgs e)
{
frmAreaSel f = new frmAreaSel();
if (f.ShowDialog() == DialogResult.OK)
{
string id = f.FocusedObject.ID;
PS_Table_AreaWH w = new PS_Table_AreaWH();
w.ID = id;
w = (PS_Table_AreaWH)Services.BaseService.GetObject("SelectPS_Table_AreaWHByKey", w);
if (w != null)
{
w.Col2 = Str;
comboBoxEdit1.Text = w.Title;
Services.BaseService.Update <PS_Table_AreaWH>(w);
}
}
}
//添加地区
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FrmAddPN frm = new FrmAddPN();
frm.SetFrmName = "添加地区";
frm.SetLabelName = "地区名称";
if (frm.ShowDialog() == DialogResult.OK)
{
PS_Table_AreaWH data = new PS_Table_AreaWH();
data.ID += "|" + ProjectID;
data.ProjectID = ProjectID;
data.Title = frm.ParentName;
data.Col1 = frm.Col1;
data.Col2 = frm.Col2;
Common.Services.BaseService.Create <PS_Table_AreaWH>(data);
}
InitGrid2();
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (this.gridView2.FocusedRowHandle >= 0)
{
FrmAddPN frm = new FrmAddPN();
frm.SetFrmName = "修改地区";
frm.SetLabelName = "地区名称";
PS_Table_AreaWH _data = this.gridView2.GetRow(this.gridView2.FocusedRowHandle) as PS_Table_AreaWH;// new Ps_Table_GDP();
frm.Col2 = _data.Col2;
frm.ParentName = this.gridView2.GetRowCellValue(this.gridView2.FocusedRowHandle, "Title").ToString();
if (frm.ShowDialog() == DialogResult.OK)
{
PS_Table_AreaWH data = this.gridView2.GetRow(this.gridView2.FocusedRowHandle) as PS_Table_AreaWH;// new Ps_Table_GDP();
data.Title = frm.ParentName;
data.Col1 = frm.Col1;
data.Col2 = frm.Col2;
Common.Services.BaseService.Update <PS_Table_AreaWH>(data);
}
}
InitGrid2();
}
private void barButtonItem4_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("）", "");
BurdenMonth bl = new BurdenMonth();
bl.UID = bl.UID + "|" + Itop.Client.MIS.ProgUID;
bl.CreateDate = DateTime.Now;
bl.UpdateDate = DateTime.Now;
bl.BurdenYear = int.Parse(year);
//try
//{
// bl. = DateTime.Parse(year);
//}
//catch
//{
// bl.BurdenDate = DateTime.Now;
//}
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;
}
bl.Title = "BurdenYear ='" + bl.BurdenYear + "' and uid like '%" + Itop.Client.MIS.ProgUID + "%' and AreaID='" + bl.AreaID + "'";
IList <BurdenMonth> lis = Common.Services.BaseService.GetList <BurdenMonth>("SelectBurdenMonthByWhere", bl.Title);
foreach (BurdenMonth bltemp in lis)
{
bl.UID = bltemp.UID;
bl.CreateDate = bltemp.CreateDate;
bl.UpdateDate = bltemp.UpdateDate;
break;
}
try{
bl.Month1 = double.Parse(dts.Rows[k][2].ToString());
}
catch { }
try{
bl.Month2 = double.Parse(dts.Rows[k][3].ToString());
}
catch { }
try{
bl.Month3 = double.Parse(dts.Rows[k][4].ToString());
}
catch { }
try{
bl.Month4 = double.Parse(dts.Rows[k][5].ToString());
}
catch { }
try{
bl.Month5 = double.Parse(dts.Rows[k][6].ToString());
}
catch { }
try{
bl.Month6 = double.Parse(dts.Rows[k][7].ToString());
}
catch { }
try{
bl.Month7 = double.Parse(dts.Rows[k][8].ToString());
}
catch { }
try{
bl.Month8 = double.Parse(dts.Rows[k][9].ToString());
}
catch { }
try{
bl.Month9 = double.Parse(dts.Rows[k][10].ToString());
}
catch { }
try{
bl.Month10 = double.Parse(dts.Rows[k][11].ToString());
}
catch { }
try{
bl.Month11 = double.Parse(dts.Rows[k][12].ToString());
}
catch { }
try{
bl.Month12 = double.Parse(dts.Rows[k][13].ToString());
}
catch { }
double minData = 0;
double maxData = 0;
double sumData = 0;
Common.Services.BaseService.Delete <BurdenMonth>(bl);
Common.Services.BaseService.Create <BurdenMonth>(bl);
ctrlBurdenMonth1.ObjectList.Add(bl);
}
ctrlBurdenMonth1.RefreshData();
UpdataChart();
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("导入格式不正确！"); }
}
