private void simpleButton1_Click(object sender, EventArgs e)
{
string str = "";
try
{
str = System.Configuration.ConfigurationSettings.AppSettings["SvgID"];
}
catch { }
DataTable dt = new DataTable();
dt.Columns.Add("A");
dt.Columns.Add("B");
dt.Columns.Add("C", typeof(bool));
dt.Columns.Add("D");
IList<LayerGrade> li = Services.BaseService.GetList<LayerGrade>("SelectLayerGradeListBySvgDataUid", str);
IList<SVG_LAYER> li1 = Services.BaseService.GetList<SVG_LAYER>("SelectSVG_LAYERBySvgID", str);
DataTable dt1 = Itop.Common.DataConverter.ToDataTable((IList)li1);
foreach (LayerGrade node in li)
{
DataRow row = dt.NewRow();
row["A"] = node.SUID;
row["B"] = node.Name;
row["C"] = false;
row["D"] = node.ParentID;
dt.Rows.Add(row);
DataRow[] rows = dt1.Select("YearID='" + node.SUID + "'");
foreach (DataRow row1 in rows)
{
DataRow row2 = dt.NewRow();
row2["A"] = row1["SUID"].ToString();
row2["B"] = row1["NAME"].ToString();
row2["C"] = false;
row2["D"] = node.SUID;
dt.Rows.Add(row2);
}
}
//////SVGFILE sf = Services.BaseService.GetOneByKey<SVGFILE>(str);
//////XmlDocument xd = new XmlDocument();
//////xd.LoadXml(sf.SVGDATA);
//////DataTable dt = new DataTable();
//////dt.Columns.Add("A");
//////dt.Columns.Add("B");
//////dt.Columns.Add("C", typeof(bool));
//////XmlNodeList nli = xd.GetElementsByTagName("layer");
//////foreach (XmlNode node in nli)
//////{
////// XmlElement xe = (XmlElement)node;
////// if (xe.GetAttribute("layerType") == "�����滮��")
////// {
////// DataRow row = dt.NewRow();
////// row["A"] = xe.GetAttribute("id");
////// row["B"] = xe.GetAttribute("label");
////// row["C"] = false;
////// dt.Rows.Add(row);
////// }
//////}
//foreach (DataRow rws in dt.Rows)
//{
// rws["C"] = false;
//}
PowerPicSelect ppsn = new PowerPicSelect();
ppsn.EachListID = _obj.UID;
IList<PowerPicSelect> liss = Services.BaseService.GetList<PowerPicSelect>("SelectPowerPicSelectList", ppsn);
//foreach (PowerPicSelect pps in liss)
//{
// foreach (DataRow rw in dt.Rows)
// {
// if (pps.PicSelectID == rw["A"].ToString())
// rw["C"] = true;
// }
//}
//FrmPicTypeSelect fpt = new FrmPicTypeSelect();
FrmPicTreeSelect fpt = new FrmPicTreeSelect();
fpt.DT = dt;
if (fpt.ShowDialog() == DialogResult.OK)
{
dt = fpt.DT;
int c = 0;
foreach (PowerPicSelect pps1 in liss)
{
c = 0;
foreach (DataRow rw in dt.Rows)
{
if (pps1.PicSelectID == rw["A"].ToString() && (bool)rw["C"])
c = 1;
}
if (c == 0)
{
Services.BaseService.Delete<PowerPicSelect>(pps1);
}
}
foreach (DataRow rw1 in dt.Rows)
{
c = 0;
if ((bool)rw1["C"])
{
foreach (PowerPicSelect pps2 in liss)
{
if (pps2.PicSelectID == rw1["A"].ToString())
c = 1;
}
if (c == 0)
{
PowerPicSelect pp3 = new PowerPicSelect();
pp3.EachListID = _obj.UID;
pp3.PicSelectID = rw1["A"].ToString();
Services.BaseService.Create<PowerPicSelect>(pp3);
}
}
}
}
//foreach (DataRow rws in dt.Rows)
//{
// rws["C"] = false;
//}
//PowerPicSelect ppsn = new PowerPicSelect();
//ppsn.EachListID = _obj.UID;
//IList<PowerPicSelect> liss = Services.BaseService.GetList<PowerPicSelect>("SelectPowerPicSelectList", ppsn);
//foreach (PowerPicSelect pps in liss)
//{
// foreach (DataRow rw in dt.Rows)
// {
// if (pps.PicSelectID == rw["A"].ToString())
// rw["C"] = true;
// }
//}
//FrmPicTypeSelect fpt = new FrmPicTypeSelect();
//fpt.DT = dt;
//if (fpt.ShowDialog() == DialogResult.OK)
//{
// dt = fpt.DT;
// int c = 0;
// foreach (PowerPicSelect pps1 in liss)
// {
// c = 0;
// foreach (DataRow rw in dt.Rows)
// {
// if (pps1.PicSelectID == rw["A"].ToString() && (bool)rw["C"])
// c = 1;
// }
// if (c == 0)
// {
// Services.BaseService.Delete<PowerPicSelect>(pps1);
// }
// }
// foreach (DataRow rw1 in dt.Rows)
// {
// c = 0;
// if ((bool)rw1["C"])
// {
// foreach (PowerPicSelect pps2 in liss)
// {
// if (pps2.PicSelectID == rw1["A"].ToString())
// c = 1;
// }
// if (c == 0)
// {
// PowerPicSelect pp3 = new PowerPicSelect();
// pp3.EachListID = _obj.UID;
// pp3.PicSelectID = rw1["A"].ToString();
// Services.BaseService.Create<PowerPicSelect>(pp3);
// }
// }
// }
//}
}
private void barButtonItem9_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
string str = "";
try
{
str = System.Configuration.ConfigurationSettings.AppSettings["SvgID"];
}
catch { }
DataTable dt = new DataTable();
dt.Columns.Add("A");
dt.Columns.Add("B");
dt.Columns.Add("C", typeof(bool));
dt.Columns.Add("D");
IList <LayerGrade> li = Services.BaseService.GetList <LayerGrade>("SelectLayerGradeListBySvgDataUid", str);
IList <SVG_LAYER> li1 = Services.BaseService.GetList <SVG_LAYER>("SelectSVG_LAYERBySvgID", str);
DataTable dt1 = Itop.Common.DataConverter.ToDataTable((IList)li1);
foreach (LayerGrade node in li)
{
DataRow row = dt.NewRow();
row["A"] = node.SUID;
row["B"] = node.Name;
row["C"] = false;
row["D"] = node.ParentID;
dt.Rows.Add(row);
DataRow[] rows = dt1.Select("YearID='" + node.SUID + "'");
foreach (DataRow row1 in rows)
{
DataRow row2 = dt.NewRow();
row2["A"] = row1["SUID"].ToString();
row2["B"] = row1["NAME"].ToString();
row2["C"] = false;
row2["D"] = node.SUID;
dt.Rows.Add(row2);
}
}
//////SVGFILE sf = Services.BaseService.GetOneByKey<SVGFILE>(str);
//////XmlDocument xd = new XmlDocument();
//////xd.LoadXml(sf.SVGDATA);
//////DataTable dt = new DataTable();
//////dt.Columns.Add("A");
//////dt.Columns.Add("B");
//////dt.Columns.Add("C", typeof(bool));
//////XmlNodeList nli = xd.GetElementsByTagName("layer");
//////foreach (XmlNode node in nli)
//////{
////// XmlElement xe = (XmlElement)node;
////// if (xe.GetAttribute("layerType") == "电网规划层")
////// {
////// DataRow row = dt.NewRow();
////// row["A"] = xe.GetAttribute("id");
////// row["B"] = xe.GetAttribute("label");
////// row["C"] = false;
////// dt.Rows.Add(row);
////// }
//////}
//foreach (DataRow rws in dt.Rows)
//{
// rws["C"] = false;
//}
PowerPicSelect ppsn = new PowerPicSelect();
ppsn.EachListID = selectid;
IList <PowerPicSelect> liss = Services.BaseService.GetList <PowerPicSelect>("SelectPowerPicSelectList", ppsn);
//foreach (PowerPicSelect pps in liss)
//{
// foreach (DataRow rw in dt.Rows)
// {
// if (pps.PicSelectID == rw["A"].ToString())
// rw["C"] = true;
// }
//}
//FrmPicTypeSelect fpt = new FrmPicTypeSelect();
FrmPicTreeSelect fpt = new FrmPicTreeSelect();
fpt.DT = dt;
if (fpt.ShowDialog() == DialogResult.OK)
{
dt = fpt.DT;
int c = 0;
foreach (PowerPicSelect pps1 in liss)
{
c = 0;
foreach (DataRow rw in dt.Rows)
{
if (pps1.PicSelectID == rw["A"].ToString() && (bool)rw["C"])
{
c = 1;
}
}
if (c == 0)
{
Services.BaseService.Delete <PowerPicSelect>(pps1);
}
}
foreach (DataRow rw1 in dt.Rows)
{
c = 0;
if ((bool)rw1["C"])
{
foreach (PowerPicSelect pps2 in liss)
{
if (pps2.PicSelectID == rw1["A"].ToString())
{
c = 1;
}
}
if (c == 0)
{
PowerPicSelect pp3 = new PowerPicSelect();
pp3.EachListID = selectid;
pp3.PicSelectID = rw1["A"].ToString();
Services.BaseService.Create <PowerPicSelect>(pp3);
}
}
}
}
InitSodata2();
InitGridData();
}