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