private void loadSubProjects() { string sql = "select * from CJSITE_SECTION order by SECTIONNAME"; DBManager.ConnectCGDB(); DataTable data = DBManager.DBHelperCG.ExcuteSql(sql); sections = CJSITE_SECTION.ToClass(data); for (int i = 0; i < sections.Count; i++) { string sqlMP = "select * from CJSITE_MEASUREPOINT"; CJSITE_MEASUREPOINT inst = new CJSITE_MEASUREPOINT(); inst.POINTID = "IP09332"; sections[i].MEASUREPOINTS.Add(inst); } tree.ItemsSource = sections; }
public static List<CJSITE_MEASUREPOINT> ToClass(DataTable data) { List<CJSITE_MEASUREPOINT> list = new List<CJSITE_MEASUREPOINT>(); for (int i = 0; i < data.Rows.Count; i++) { CJSITE_MEASUREPOINT cjsite_measurepoint = new CJSITE_MEASUREPOINT(); cjsite_measurepoint.ID = data.Rows[i]["ID"]==DBNull.Value?"":Convert.ToString(data.Rows[i]["ID"]); cjsite_measurepoint.POINTID = data.Rows[i]["POINTID"]==DBNull.Value?"":Convert.ToString(data.Rows[i]["POINTID"]); cjsite_measurepoint.INSTRUID = data.Rows[i]["INSTRUID"]==DBNull.Value?"":Convert.ToString(data.Rows[i]["INSTRUID"]); cjsite_measurepoint.SECTIONID = data.Rows[i]["SECTIONID"]==DBNull.Value?"":Convert.ToString(data.Rows[i]["SECTIONID"]); cjsite_measurepoint.PARA = data.Rows[i]["PARA"]==DBNull.Value?"":Convert.ToString(data.Rows[i]["PARA"]); cjsite_measurepoint.ISBROKEN = data.Rows[i]["ISBROKEN"]==DBNull.Value?false:Convert.ToBoolean(data.Rows[i]["ISBROKEN"]); cjsite_measurepoint.ISAUTO = data.Rows[i]["ISAUTO"]==DBNull.Value?false:Convert.ToBoolean(data.Rows[i]["ISAUTO"]); cjsite_measurepoint.BROKENDATE = data.Rows[i]["BROKENDATE"]==DBNull.Value?Convert.ToDateTime("1970-01-01 00:00:00"):Convert.ToDateTime(data.Rows[i]["BROKENDATE"]); cjsite_measurepoint.INSTALLPERSON = data.Rows[i]["INSTALLPERSON"]==DBNull.Value?"":Convert.ToString(data.Rows[i]["INSTALLPERSON"]); cjsite_measurepoint.INSTALLDATE = data.Rows[i]["INSTALLDATE"]==DBNull.Value?Convert.ToDateTime("1970-01-01 00:00:00"):Convert.ToDateTime(data.Rows[i]["INSTALLDATE"]); cjsite_measurepoint.X = data.Rows[i]["X"]==DBNull.Value?"":Convert.ToString(data.Rows[i]["X"]); cjsite_measurepoint.Y = data.Rows[i]["Y"]==DBNull.Value?"":Convert.ToString(data.Rows[i]["Y"]); cjsite_measurepoint.Z = data.Rows[i]["Z"]==DBNull.Value?"":Convert.ToString(data.Rows[i]["Z"]); list.Add(cjsite_measurepoint); } return list; }