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(); }