//////////private void InitSodata1()
//////////{
////////// string sid = "1";
////////// Hashtable hs = new Hashtable();
////////// Hashtable hs2 = new Hashtable();
////////// IList<LineInfo> listLineInfo = Services.BaseService.GetList<LineInfo>("SelectLineInfoByPowerID", sid);
////////// foreach (LineInfo l1 in listLineInfo)
////////// {
////////// hs.Add(Guid.NewGuid().ToString(), l1.UID);
////////// }
////////// IList<Line_Info> ll1 = Common.Services.BaseService.GetList<Line_Info>("SelectLine_InfoByFlag", sid);
////////// foreach (Line_Info ps in ll1)
////////// {
////////// hs2.Add(Guid.NewGuid().ToString(), ps.Code);
////////// }
////////// foreach (Line_Info p1 in ll1)
////////// {
////////// if (p1.Code != "" && !hs.ContainsValue(p1.Code))
////////// {
////////// Services.BaseService.Delete<Line_Info>(p1);
////////// }
////////// }
////////// foreach (LineInfo l2 in listLineInfo)
////////// {
////////// if (!hs2.ContainsValue(l2.UID) && l2.Voltage != "")
////////// {
////////// //添加
////////// try
////////// {
////////// Line_Info line1 = new Line_Info();
////////// line1.DY = int.Parse(l2.Voltage.ToUpper().Replace("KV", ""));
////////// line1.Title = l2.LineName;
////////// line1.Code = l2.UID;
////////// line1.Flag = sid;
////////// Services.BaseService.Create<Line_Info>(line1);
////////// }
////////// catch { }
////////// }
////////// }
//////////}
//////////private void InitSodata2()
//////////{
////////// string sid = "1";
////////// Hashtable hs1 = new Hashtable();
////////// Hashtable hs3 = new Hashtable();
////////// IList<substation> listsubstation = Services.BaseService.GetList<substation>("SelectsubstationByPowerIDStuff", sid);
////////// foreach (substation s1 in listsubstation)
////////// {
////////// hs1.Add(Guid.NewGuid().ToString(), s1.UID);
////////// }
////////// IList<PSP_PowerSubstationInfo> ll2 = Common.Services.BaseService.GetList<PSP_PowerSubstationInfo>("SelectSubstation_InfoByFlag", sid);
////////// foreach (PSP_PowerSubstationInfo ps in ll2)
////////// {
////////// hs3.Add(Guid.NewGuid().ToString(), ps.Code);
////////// }
////////// foreach (PSP_PowerSubstationInfo p2 in ll2)
////////// {
////////// if (p2.Code != "" && !hs1.ContainsValue(p2.Code))
////////// {
////////// //删除
////////// Services.BaseService.Delete<PSP_PowerSubstationInfo>(p2);
////////// }
////////// }
////////// foreach (substation s2 in listsubstation)
////////// {
////////// if (!hs3.ContainsValue(s2.UID) && s2.ObligateField1 != "")
////////// {
////////// //添加
////////// try
////////// {
////////// PSP_PowerSubstationInfo substation1 = new PSP_PowerSubstationInfo();
////////// substation1.L1 = int.Parse(s2.ObligateField1);
////////// substation1.Title = s2.EleName;
////////// substation1.Code = s2.UID;
////////// substation1.Flag = sid;
////////// try
////////// {
////////// substation1.L1 = int.Parse(s2.ObligateField1);
////////// }
////////// catch { }
////////// try
////////// {
////////// substation1.L10 = double.Parse(s2.ObligateField2);
////////// }
////////// catch { }
////////// try
////////// {
////////// substation1.L2 = Convert.ToDouble(s2.Number);
////////// }
////////// catch { }
////////// try
////////// {
////////// substation1.L9 = Convert.ToDouble(s2.Burthen);
////////// }
////////// catch { }
////////// Services.BaseService.Create<PSP_PowerSubstationInfo>(substation1);
////////// //PSP_PowerSubstationInfo substation1 = new PSP_PowerSubstationInfo();
////////// //substation1.L1 = int.Parse(s2.ObligateField1);
////////// //substation1.Title = s2.EleName;
////////// //substation1.Code = s2.UID;
////////// //substation1.Flag = sid;
////////// //Services.BaseService.Create<PSP_PowerSubstationInfo>(substation1);
////////// }
////////// catch { }
////////// }
////////// }
//////////}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FileClass.ExportExcel(this.ctrlPSP_PowerSubstationInfo1.GridControl);
}
private void barButtonItem6_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//FileClass.ExportExcel(this.gridControl1);
FileClass.ExportExcel(this.gridView1.GroupPanelText, "汽了:嵐認欲扮 ", this.gridControl1);
}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FileClass.ExportExcel(this.ctrlProject_Sum1.GridControl);
}
private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
//FileClass.ExportExcel(dataTable, this.ctrlBurdenMonth1.GridView.GroupPanelText, false, true, true);
FileClass.ExportExcel(this.ctrlBurdenMonth1.GridView.GroupPanelText, "", this.ctrlBurdenMonth1.GridControl);
}
private void barButtonItem5_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FileClass.ExportExcel(this.gridControl1);
}
//////////private void InitSodata1()
//////////{
////////// string sid = "1";
////////// Hashtable hs = new Hashtable();
////////// Hashtable hs2 = new Hashtable();
////////// IList<LineInfo> listLineInfo = Services.BaseService.GetList<LineInfo>("SelectLineInfoByPowerID", sid);
////////// foreach (LineInfo l1 in listLineInfo)
////////// {
////////// hs.Add(Guid.NewGuid().ToString(), l1.UID);
////////// }
////////// IList<Line_Info> ll1 = Common.Services.BaseService.GetList<Line_Info>("SelectLine_InfoByFlag", sid);
////////// foreach (Line_Info ps in ll1)
////////// {
////////// hs2.Add(Guid.NewGuid().ToString(), ps.Code);
////////// }
////////// foreach (Line_Info p1 in ll1)
////////// {
////////// if (p1.Code != "" && !hs.ContainsValue(p1.Code))
////////// {
////////// Services.BaseService.Delete<Line_Info>(p1);
////////// }
////////// }
////////// foreach (LineInfo l2 in listLineInfo)
////////// {
////////// if (!hs2.ContainsValue(l2.UID) && l2.Voltage != "")
////////// {
////////// //添加
////////// try
////////// {
////////// Line_Info line1 = new Line_Info();
////////// line1.DY = int.Parse(l2.Voltage.ToUpper().Replace("KV", ""));
////////// line1.Title = l2.LineName;
////////// line1.Code = l2.UID;
////////// line1.Flag = sid;
////////// Services.BaseService.Create<Line_Info>(line1);
////////// }
////////// catch { }
////////// }
////////// }
//////////}
//////////private void InitSodata2()
//////////{
////////// string sid = "1";
////////// Hashtable hs1 = new Hashtable();
////////// Hashtable hs3 = new Hashtable();
////////// IList<substation> listsubstation = Services.BaseService.GetList<substation>("SelectsubstationByPowerIDStuff", sid);
////////// foreach (substation s1 in listsubstation)
////////// {
////////// hs1.Add(Guid.NewGuid().ToString(), s1.UID);
////////// }
////////// IList<PSP_PowerSubstationInfo> ll2 = Common.Services.BaseService.GetList<PSP_PowerSubstationInfo>("SelectSubstation_InfoByFlag", sid);
////////// foreach (PSP_PowerSubstationInfo ps in ll2)
////////// {
////////// hs3.Add(Guid.NewGuid().ToString(), ps.Code);
////////// }
////////// foreach (PSP_PowerSubstationInfo p2 in ll2)
////////// {
////////// if (p2.Code != "" && !hs1.ContainsValue(p2.Code))
////////// {
////////// //删除
////////// Services.BaseService.Delete<PSP_PowerSubstationInfo>(p2);
////////// }
////////// }
////////// foreach (substation s2 in listsubstation)
////////// {
////////// if (!hs3.ContainsValue(s2.UID) && s2.ObligateField1 != "")
////////// {
////////// //添加
////////// try
////////// {
////////// PSP_PowerSubstationInfo substation1 = new PSP_PowerSubstationInfo();
////////// substation1.L1 = int.Parse(s2.ObligateField1);
////////// substation1.Title = s2.EleName;
////////// substation1.Code = s2.UID;
////////// substation1.Flag = sid;
////////// try
////////// {
////////// substation1.L1 = int.Parse(s2.ObligateField1);
////////// }
////////// catch { }
////////// try
////////// {
////////// substation1.L10 = double.Parse(s2.ObligateField2);
////////// }
////////// catch { }
////////// try
////////// {
////////// substation1.L2 = Convert.ToDouble(s2.Number);
////////// }
////////// catch { }
////////// try
////////// {
////////// substation1.L9 = Convert.ToDouble(s2.Burthen);
////////// }
////////// catch { }
////////// Services.BaseService.Create<PSP_PowerSubstationInfo>(substation1);
////////// //PSP_PowerSubstationInfo substation1 = new PSP_PowerSubstationInfo();
////////// //substation1.L1 = int.Parse(s2.ObligateField1);
////////// //substation1.Title = s2.EleName;
////////// //substation1.Code = s2.UID;
////////// //substation1.Flag = sid;
////////// //Services.BaseService.Create<PSP_PowerSubstationInfo>(substation1);
////////// }
////////// catch { }
////////// }
////////// }
//////////}
private void barButtonItem2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
FileClass.ExportExcel(this.ctrlPower1.GridView.GroupPanelText, "", this.ctrlPower1.GridControl);
}