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(); }
private void simpleButton1_Click(object sender, EventArgs e) { 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(); pp3.PicSelectName = rw1["B"].ToString(); Services.BaseService.Create <PowerPicSelect>(pp3); } } } } }