public static void DeleteOld(string constructionCode) { var sql = @" DELETE FROM SocketBoxes WHERE ConstructionCode = '" + constructionCode + @"' AND PatternId != -1"; var db = SocketBox.GetDatabase(); db.ExecuteNonQuery(sql); }
public static void DeleteByDrawing(string constructionCode, List <string> seqs) { var sql = @" DELETE FROM SocketBoxes WHERE ConstructionCode = '" + constructionCode + @"' AND Seq = " + seqs[0]; //どうせ1つずつしか消せないのでOK var db = SocketBox.GetDatabase(); db.ExecuteNonQuery(sql); }
public static List <SocketBox> Get(string constructionCode) { var sql = @" SELECT * FROM SocketBoxes WHERE ConstructionCode = '" + constructionCode + @"'"; var db = SocketBox.GetDatabase(); return(db.ExecuteQuery <SocketBox>(sql)); }
public static SocketBox Get(string constructionCode, int socketObjectId) { var sql = @" SELECT * FROM SocketBoxes WHERE ConstructionCode = '" + constructionCode + @"' AND SocketObjectId = " + socketObjectId; var db = SocketBox.GetDatabase(); var boxes = db.ExecuteQuery <SocketBox>(sql); if (boxes.Count == 0) { return(null); } return(boxes[0]); }
public static SocketBox Get(string constructionCode, decimal symbolX, decimal symbolY, int patternId) { var sql = @" SELECT * FROM SocketBoxes WHERE ConstructionCode = '" + constructionCode + @"' AND SymbolLocationX = " + symbolX.ToString("0.00") + @" AND SymbolLocationY = " + symbolY.ToString("0.00") + @" AND PatternId = " + patternId; var db = SocketBox.GetDatabase(); var boxes = db.ExecuteQuery <SocketBox>(sql); if (boxes.Count == 0) { return(null); } return(boxes[0]); }
public static int GetMaxSeq(string constructionCode) { var sql = @" SELECT COUNT(*) FROM SocketBoxes WHERE ConstructionCode = '" + constructionCode + @"'"; var db = SocketBox.GetDatabase(); if (Int32.Parse(db.ExecuteScalar(sql).ToString()) == 0) { return(0); } sql = @" SELECT MAX(Seq) FROM SocketBoxes WHERE ConstructionCode = '" + constructionCode + @"'"; return(Int32.Parse(db.ExecuteScalar(sql).ToString())); }