//UPDATE POINT3D SET 'X' =1, 'Y' = 2, 'Z' = 3 WHERE ID = 3; public static void Update(SQLiteCommand command, Point3dModel model) { List <List <object> > itemList = new List <List <object> > { new List <object> { DBPoint3DName.X, DBPoint3D_AT.x, model.X }, new List <object> { DBPoint3DName.Y, DBPoint3D_AT.y, model.Y }, new List <object> { DBPoint3DName.Z, DBPoint3D_AT.z, model.Z } }; Dictionary <string, string> variable = new Dictionary <string, string>(); Dictionary <string, object> paraDict = new Dictionary <string, object>(); Dictionary <string, string> conDict = new Dictionary <string, string> { { DBPoint3DName.ID, DBPoint3D_AT.id } }; foreach (List <object> item in itemList) { variable.Add((string)item[0], (string)item[1]); paraDict.Add((string)item[1], item[2]); } ; paraDict.Add(DBPoint3D_AT.id, model.ID); DBCommand.UpdateRow(DBPoint3DName.tableName, variable, conDict, paraDict, command); }
protected virtual void CopyModel(BlockModelBase model) { ID = model.ID; handle = model.handle; position = model.position; matrixTransform = model.matrixTransform; file = model.file; }
public Point3dModel GetColdWaterTip() { if (fuS.HasSingleStud() && fuS.HasColdStud()) { Point3dModel point = new Point3dModel(0, 1 + D1, 0); return(matrixTransform.Transform(A1, point)); } return(null); }
public Point3dModel GetDoubleDrainTip() { if (fuS.HasDoubleDrainButNotAtOrigin()) { Point3dModel tipPoint = new Point3dModel(R1.X, R1.Y + Y2, R1.Z); return(matrixTransform.Transform(A3, R1, tipPoint)); } return(null); }
public static long UpdateRow(Point3dModel model, SQLiteConnection connection) { using (SQLiteCommand command = connection.CreateCommand()) { DBPoint3DCommands.Update(command, model); int check = command.ExecuteNonQuery(); return(check); } }
private static FixtureDetailsModel GetFixture(SQLiteDataReader reader, SQLiteConnection connection) { FixtureDetailsModel model; long POSITION_ID = (long)reader[DBFixtureDetailsNames.POSITION_ID]; long TRANSFORM_ID = (long)reader[DBFixtureDetailsNames.MATRIX_ID]; string HANDLE = (string)reader[DBFixtureDetailsNames.HANDLE]; double INDEX = (double)reader[DBFixtureDetailsNames.INDEXX]; string FIXTURE_NAME = (string)reader[DBFixtureDetailsNames.FIXTURE_NAME]; string TAG = (string)reader[DBFixtureDetailsNames.TAG]; string NUMBER = (string)reader[DBFixtureDetailsNames.NUMBER]; double CW_DIA = (double)reader[DBFixtureDetailsNames.CW_DIA]; double HW_DIA = (double)reader[DBFixtureDetailsNames.HW_DIA]; double WASTE_DIA = (double)reader[DBFixtureDetailsNames.WASTE_DIA]; double VENT_DIA = (double)reader[DBFixtureDetailsNames.VENT_DIA]; double STORM_DIA = (double)reader[DBFixtureDetailsNames.STORM_DIA]; double WSFU = (double)reader[DBFixtureDetailsNames.WSFU]; double CWSFU = (double)reader[DBFixtureDetailsNames.CWSFU]; double HWSFU = (double)reader[DBFixtureDetailsNames.HWSFU]; double DFU = (double)reader[DBFixtureDetailsNames.DFU]; string DESCRIPTION = (string)reader[DBFixtureDetailsNames.DESCRIPTION]; long ID = (long)reader[DBFixtureDetailsNames.ID]; long FILE_ID = (long)reader[DBFixtureDetailsNames.FILE_ID]; Matrix3dModel matrix = DBMatrix3d.SelectRow(connection, TRANSFORM_ID); Point3dModel position = DBPoint3D.SelectRow(connection, POSITION_ID); DwgFileModel file = DBDwgFile.SelectRow(connection, FILE_ID); model = new FixtureDetailsModel(); model.position = position; model.matrixTransform = matrix; model.handle = HANDLE; model.INDEX = INDEX; model.FIXTURENAME = FIXTURE_NAME; model.TAG = TAG; model.NUMBER = NUMBER; model.CW_DIA = CW_DIA; model.HW_DIA = HW_DIA; model.WASTE_DIA = WASTE_DIA; model.VENT_DIA = VENT_DIA; model.STORM_DIA = STORM_DIA; model.WSFU = WSFU; model.CWSFU = CWSFU; model.HWSFU = HWSFU; model.DFU = DFU; model.DESCRIPTION = DESCRIPTION; model.ID = ID; model.file = file; return(model); }
/// <summary> /// Return a list of points, the first one is hotWaterTipPoint, the second one is coldWaterTipPoint /// </summary> /// <returns></returns> public List <Point3dModel> GetHotColdTip() { if (fuS.HasHotColdStud()) { Point3dModel hotPoint = new Point3dModel(-5, 1 + D1, 0); Point3dModel coldPoint = new Point3dModel(5, 1 + D1, 0); return(new List <Point3dModel> { matrixTransform.Transform(A1, hotPoint), matrixTransform.Transform(A2, coldPoint) }); } return(null); }
private static InsertPointModel GetModel(SQLiteDataReader reader, SQLiteConnection connection) { string alias = (string)reader[DBInsertPointName.ALIAS]; string name = (string)reader[DBInsertPointName.ANAME]; long ID = (long)reader[DBInsertPointName.ID]; Point3dModel pos = DBPoint3D.SelectRow(connection, (long)reader[DBInsertPointName.POSITION_ID]); string handle1 = (string)reader[DBInsertPointName.HANDLE]; DwgFileModel file = DBDwgFile.SelectRow(connection, (long)reader[DBInsertPointName.FILE_ID]); Matrix3dModel matrix = DBMatrix3d.SelectRow(connection, (long)reader[DBInsertPointName.MATRIX_ID]); InsertPointModel model = new InsertPointModel(alias, name, ID, file, handle1, pos, matrix); return(model); }
public static void Insert(SQLiteCommand command, Point3dModel model) { //"INSERT INTO POINT3D ('X', 'Y', 'Z') VALUES (034.34, 233, 0);" List <string> variables = new List <string> { DBPoint3DName.X, DBPoint3DName.Y, DBPoint3DName.Z }; Dictionary <string, object> paraDict = new Dictionary <string, object> { { DBPoint3D_AT.x, model.X }, { DBPoint3D_AT.y, model.Y }, { DBPoint3D_AT.z, model.Z } }; DBCommand.InsertCommand(DBPoint3DName.tableName, variables, paraDict, command); }
/// <summary> /// Insert a point to Table, return id the row inserted. /// After inserting, ID will be added to model /// </summary> /// <param name="point"></param> /// <param name="connection"></param> /// <returns></returns> public static long InsertRow(ref Point3dModel model, SQLiteConnection connection) { using (SQLiteCommand command = connection.CreateCommand()) { DBPoint3DCommands.Insert(command, model); int check = command.ExecuteNonQuery(); if (check == 1) { model.ID = connection.LastInsertRowId; return(model.ID); } else if (check == 0) { throw new Exception("DBPoint3dCommands -> Insert -> No Point Was Inserted"); } throw new Exception("DBPoint3D -> Insert -> Insert Point not successful."); } }