public static void UpdateRow(SQLiteCommand command, InsertPointModel model)
{
DBPoint3D.UpdateRow(model.position, command.Connection);
DBMatrix3d.Update(command.Connection, model.matrixTransform);
List <List <object> > items = GetItemsList(model);
Dictionary <string, string> variables = new Dictionary <string, string>();
Dictionary <string, string> conditions = new Dictionary <string, string> {
{ DBInsertPointName.ID, DBInsertPointName_AT.id }
};
Dictionary <string, object> paraDict = new Dictionary <string, object>();
foreach (List <object> item in items)
{
variables.Add((string)item[0], (string)item[1]);
paraDict.Add((string)item[1], item[2]);
}
paraDict.Add(DBBlockName_AT.id, model.ID);
DBCommand.UpdateRow(DBInsertPointName.name, variables, conditions, paraDict, command);
}
public static void UpdateRow(FixtureDetailsModel model, SQLiteCommand command)
{
DBPoint3D.UpdateRow(model.position, command.Connection);
DBMatrix3d.Update(command.Connection, model.matrixTransform);
List <List <object> > items = getListItems(model);
Dictionary <string, string> variables = new Dictionary <string, string>();
Dictionary <string, string> conDict = new Dictionary <string, string> {
{ DBFixtureDetailsNames.ID, DBFixtureDetailsNames_AT.id }
};
Dictionary <string, object> paraDict = new Dictionary <string, object>();
foreach (List <object> item in items)
{
variables.Add((string)item[0], (string)item[1]);
paraDict.Add((string)item[1], item[2]);
}
paraDict.Add(DBFixtureDetailsNames_AT.id, model.ID);
DBCommand.UpdateRow(DBFixtureDetailsNames.name, variables, conDict, paraDict, command);
}
public static void UpdateRow(SQLiteCommand command, FixtureBeingUsedAreaModel model)
{
DBPoint3D.UpdateRow(model.pointTop, command.Connection);
DBPoint3D.UpdateRow(model.pointBottom, command.Connection);
DBPoint3D.UpdateRow(model.origin, command.Connection);
DBPoint3D.UpdateRow(model.position, command.Connection);
DBMatrix3d.Update(command.Connection, model.matrixTransform);
List <List <object> > items = GetItems(model);
Dictionary <string, string> variables = new Dictionary <string, string>();
Dictionary <string, string> conDict = new Dictionary <string, string> {
{ DBFixtureBeingUsedAreaName.ID, DBFixtureBeingUsedAreaName_AT.id }
};
Dictionary <string, object> paraDict = new Dictionary <string, object>();
foreach (List <object> item in items)
{
variables.Add((string)item[0], (string)item[1]);
paraDict.Add((string)item[1], item[2]);
}
DBCommand.UpdateRow(DBFixtureBeingUsedAreaName.name, variables, conDict, paraDict, command);
}