private void store(OleDbConnection cn, uint itemId, string loadCase, JointLoad obj)
{
string sql = "";
if (obj is ForceLoad)
{
float[] force = ((ForceLoad)obj).Force;
sql = "INSERT INTO [Joint Loads - Force] " +
"(Joint,LoadCase,CoordSys,F1,F2,F3,M1,M2,M3) VALUES " +
"(" + itemId + ",\"" + loadCase + "\",\"GLOBAL\"," +
force[0] + "," + force[1] + "," + force[2] + "," +
force[3] + "," + force[4] + "," + force[5] + ");";
}
else if (obj is GroundDisplacementLoad)
{
float[] disp = ((GroundDisplacementLoad)obj).Displacements;
sql = "INSERT INTO [Joint Loads - Ground Displacement] " +
"(Joint,LoadCase,CoordSys,U1,U2,U3,R1,R2,R3) VALUES " +
"(" + itemId + ",\"" + loadCase + "\",\"GLOBAL\"," +
disp[0] + "," + disp[1] + "," + disp[2] + "," +
disp[3] + "," + disp[4] + "," + disp[5] + ");";
}
if (sql.Length > 0)
new OleDbCommand(sql, cn).ExecuteNonQuery();
}
