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