public void ReadFloorData()
{
SQLiteConnection conn;
SQLiteCommand cmd;
SQLiteDataReader reader;
conn = new SQLiteConnection(@"Data Source = " + Path);
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT ID,No_,Name,StdFlrID,LevelB,Height FROM tblFloor";
reader = cmd.ExecuteReader();
while (reader.Read())
{
Floor floor = new Floor();
floor.ID = reader.GetInt64(0);
floor.No = reader.GetInt64(1);
floor.Name = reader.GetString(2);
floor.StdFlrID = reader.GetInt64(3);
floor.LevelB = reader.GetDouble(4);
floor.Height = reader.GetDouble(5);
Floors.Add(floor);
StoryModel storyModel = new StoryModel();
storyModel.StdFlrID = floor.StdFlrID;
storyModel.FloorID = floor.ID;
storyModel.No = floor.No;
storyModel.Height = floor.Height;
storyModel.Level = floor.LevelB;
StoryModels.Add(storyModel);
}
}
public void ReadWallData()
{
SQLiteConnection conn;
SQLiteCommand cmd;
SQLiteDataReader reader;
conn = new SQLiteConnection(@"Data Source = " + Path);
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT ID,StdFlrID,SectID,GridID FROM tblWallSeg";
reader = cmd.ExecuteReader();
while (reader.Read())
{
Wall wall = new Wall();
wall.ID = reader.GetInt64(0);
wall.StdFlrID = reader.GetInt64(1);
wall.SectID = reader.GetInt64(2);
wall.GridID = reader.GetInt64(3);
StoryModel storyModel = GetStdStoryModel(wall.StdFlrID);
wall.Grid = storyModel.GetGrid(wall.GridID);
wall.wallSect = GetWallSect(wall.SectID);
wall.ExtrudeDirection = new Vector3d(0, 0, -1 * storyModel.Height);
wall.GetSectPolyLineCurve();
wall.GetWallSurface();
storyModel.Walls.Add(wall);
}
}
public List <Surface> GetModel(int iStart = 0, int iEnd = 0)
{
if (iEnd == 0)
{
iEnd = Floors.Count;
}
ClearModel();
List <Surface> DisplaySurfaces = new List <Surface>();
for (int i = iStart; i < iEnd; i++)
{
Floor floor = Floors[i];
StoryModel storyModel = GetStdStoryModel(floor.StdFlrID);
FloorSurface floorSurface = new FloorSurface();
floorSurface.ID = floor.ID;
floorSurface.StdFlrID = floor.StdFlrID;
floorSurface.Height = floor.Height;
floorSurface.Level = floor.LevelB;
floorSurface.DisplaySurface.AddRange(storyModel.SetLevel(floor.LevelB + floor.Height, floor.Height));
storyModel.FloorSurfaces.Add(floorSurface);
DisplaySurfaces.AddRange(floorSurface.DisplaySurface);
}
return(DisplaySurfaces);
}
//List<Wall> Walls = new List<Wall>();
#region StdFlr
/// <summary>
/// 读取标准层信息
/// </summary>
public void ReadStdFlrData()
{
SQLiteConnection conn;
SQLiteCommand cmd;
SQLiteDataReader reader;
conn = new SQLiteConnection(@"Data Source = " + Path);
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT ID,No_,Height FROM tblStdFlr";
reader = cmd.ExecuteReader();
while (reader.Read())
{
StdFlr stdFlr = new StdFlr();
stdFlr.ID = reader.GetInt64(0);
stdFlr.No = reader.GetInt64(1);
stdFlr.Height = reader.GetDouble(2);
StdFlrs.Add(stdFlr);
StoryModel storyModel = new StoryModel();
storyModel.StdFlrID = stdFlr.ID;
storyModel.FloorID = -1;
storyModel.No = stdFlr.No;
storyModel.Height = stdFlr.Height;
storyModel.Level = 0;
StdStoryModels.Add(storyModel);
}
}
/// <summary>
/// 读取柱构件信息
/// </summary>
public void ReadColData()
{
SQLiteConnection conn;
SQLiteCommand cmd;
SQLiteDataReader reader;
conn = new SQLiteConnection(@"Data Source = " + Path);
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT ID,StdFlrID,SectID,JtID FROM tblColSeg";
reader = cmd.ExecuteReader();
while (reader.Read())
{
Column column = new Column();
column.ID = reader.GetInt64(0);
column.StdFlrID = reader.GetInt64(1);
column.SectID = reader.GetInt64(2);
column.JtID = reader.GetInt64(3);
StoryModel storyModel = GetStdStoryModel(column.StdFlrID);
column.Jt = storyModel.GetJoint(column.JtID);
column.colSect = GetColSect(column.SectID);
//column.Grid.Jt1 = column.Jt.Point;
//column.Grid.Jt2 = new Point3d(column.Jt.Point.X, column.Jt.Point.Y, 0);
column.ExtrudeDirection = new Vector3d(0, 0, -1 * storyModel.Height);
column.GetSectPolyLineCurve();
column.GetColumnSurface();
storyModel.Columns.Add(column);
}
}
/// <summary>
/// 读取梁构件信息
/// </summary>
public void ReadBeamdata()
{
SQLiteConnection conn;
SQLiteCommand cmd;
SQLiteDataReader reader;
conn = new SQLiteConnection(@"Data Source = " + Path);
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT ID,StdFlrID,SectID,GridID FROM tblBeamSeg";
reader = cmd.ExecuteReader();
while (reader.Read())
{
Beam beam = new Beam();
beam.ID = reader.GetInt64(0);
beam.StdFlrID = reader.GetInt64(1);
beam.SectID = reader.GetInt64(2);
beam.GridID = reader.GetInt64(3);
StoryModel storyModel = GetStdStoryModel(beam.StdFlrID);
beam.Grid = storyModel.GetGrid(beam.GridID);
beam.beamSect = GetBeamSect(beam.SectID);
beam.GetSectPolyLineCurve();
beam.GetBeamSurface();
storyModel.Beams.Add(beam);
}
}
public void ReadGridtData()
{
SQLiteConnection conn;
SQLiteCommand cmd;
SQLiteDataReader reader;
conn = new SQLiteConnection(@"Data Source = " + Path);
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT ID,StdFlrID,Jt1ID,Jt2ID,AxisID FROM tblGrid";
reader = cmd.ExecuteReader();
while (reader.Read())
{
Grid grid = new Grid();
grid.ID = reader.GetInt64(0);
grid.StdFlrID = reader.GetInt64(1);
grid.Jt1ID = reader.GetInt64(2);
grid.Jt2ID = reader.GetInt64(3);
StoryModel storyModel = GetStdStoryModel(grid.StdFlrID);
grid.Jt1 = storyModel.GetJoint(grid.Jt1ID);
grid.Jt2 = storyModel.GetJoint(grid.Jt2ID);
storyModel.Grids.Add(grid);
}
}
/// <summary>
/// 读取节点信息
/// </summary>
public void ReadJointData()
{
SQLiteConnection conn;
SQLiteCommand cmd;
SQLiteDataReader reader;
conn = new SQLiteConnection(@"Data Source = " + Path);
conn.Open();
cmd = conn.CreateCommand();
cmd.CommandText = @"SELECT ID,StdFlrID,X,Y,HDiff FROM tblJoint";
reader = cmd.ExecuteReader();
while (reader.Read())
{
Joint joint = new Joint();
joint.ID = reader.GetInt64(0);
joint.StdFlrID = reader.GetInt64(1);
StoryModel storyModel = GetStdStoryModel(joint.StdFlrID);
double fZ = storyModel.Height;
double fX = reader.GetDouble(2);
double fY = reader.GetDouble(3);
joint.Point = new Point3d(fX, fY, fZ);
joint.HDiff = reader.GetDouble(4);
storyModel.Joints.Add(joint);
}
}
