개정판 e8536f2b
dev issue #498 : Drawing Info 저장
Change-Id: Ide58ac2ad9dec2c01896f65c243c3c7aed26cb6f
| DTI_PID/SPPIDConverter/AutoModeling.cs | ||
|---|---|---|
| 258 | 258 |
application.ActiveWindow.Zoom = 2000; |
| 259 | 259 |
Thread.Sleep(2000); |
| 260 | 260 |
|
| 261 |
//Project_DB.InsertSymbolMapping
|
|
| 261 |
Project_DB.InsertDrawingInfo(document.PATH, drawingNumber, drawingName);
|
|
| 262 | 262 |
} |
| 263 | 263 |
|
| 264 | 264 |
/// <summary> |
| DTI_PID/SPPIDConverter/BaseModel/Document.cs | ||
|---|---|---|
| 57 | 57 |
public double SIZE_WIDTH { get => _SIZE_WIDTH; }
|
| 58 | 58 |
public double SIZE_HEIGHT { get => _SIZE_HEIGHT; }
|
| 59 | 59 |
public List<TrimLine> TRIMLINES { get => _TRIMLINES; set => _TRIMLINES = value; }
|
| 60 |
|
|
| 60 |
public string PATH { get; set; }
|
|
| 61 | 61 |
|
| 62 | 62 |
public Document(string xmlPath) |
| 63 | 63 |
{
|
| 64 | 64 |
try |
| 65 | 65 |
{
|
| 66 |
PATH = xmlPath; |
|
| 66 | 67 |
XElement xml = XElement.Load(xmlPath); |
| 67 | 68 |
DWGNAME = xml.Element("DWGNAME").Value;
|
| 68 | 69 |
SIZE = xml.Element("SIZE").Value;
|
| DTI_PID/SPPIDConverter/ConverterDocking.cs | ||
|---|---|---|
| 105 | 105 |
LMDrawings drawings = new LMDrawings(); |
| 106 | 106 |
drawings.Collect(dataSource); |
| 107 | 107 |
|
| 108 |
List<string> drawingNameList = new List<string>(); |
|
| 109 |
List<string> drawingNumberList = new List<string>(); |
|
| 110 |
|
|
| 108 | 111 |
foreach (LMDrawing item in drawings) |
| 109 | 112 |
{
|
| 110 |
|
|
| 111 |
|
|
| 113 |
drawingNameList.Add(item.Attributes["Name"].get_Value().ToString()); |
|
| 114 |
drawingNumberList.Add(item.Attributes["DrawingNumber"].get_Value().ToString()); |
|
| 112 | 115 |
} |
| 113 | 116 |
|
| 117 |
|
|
| 114 | 118 |
} |
| 115 | 119 |
catch (Exception ex) |
| 116 | 120 |
{
|
| DTI_PID/SPPIDConverter/DB/Project_DB.cs | ||
|---|---|---|
| 16 | 16 |
const string SPPID_ATTRIBUTE_MAPPING_TABLE = "T_SPPID_ATTRIBUTE_MAPPING"; |
| 17 | 17 |
const string SPPID_SETTING_TABLE = "T_SPPID_SETTING_TABLE"; |
| 18 | 18 |
const string SPPID_LABEL_INFO_TABLE = "T_SPPID_LABEL_INFO"; |
| 19 |
const string SPPID_DRAWING_INFO = "T_SPPID_DRAWING_INFO"; |
|
| 19 | 20 |
|
| 20 | 21 |
const string LineProperties_TABLE = "LineProperties"; |
| 21 | 22 |
const string LineTypes_TABLE = "LineTypes"; |
| ... | ... | |
| 215 | 216 |
cmd.CommandText = string.Format("CREATE TABLE {0} (UID TEXT PRIMARY KEY, LOCATION INT DEFAULT 0, LEADERLINE BOOLEAN)", SPPID_LABEL_INFO_TABLE);
|
| 216 | 217 |
cmd.ExecuteNonQuery(); |
| 217 | 218 |
} |
| 219 |
if (dt.Select(string.Format("NAME = '{0}'", SPPID_DRAWING_INFO)).Length == 0)
|
|
| 220 |
{
|
|
| 221 |
cmd.CommandText = string.Format("CREATE TABLE {0} (PATH TEXT PRIMARY KEY, DRAWINGNUMBER TEXT, DRAWINGNAME TEXT)", SPPID_DRAWING_INFO);
|
|
| 222 |
cmd.ExecuteNonQuery(); |
|
| 223 |
} |
|
| 218 | 224 |
} |
| 219 | 225 |
|
| 220 | 226 |
#region Check Column 업데이트시 예비용 |
| ... | ... | |
| 648 | 654 |
return true; |
| 649 | 655 |
} |
| 650 | 656 |
|
| 651 |
public static bool InsertDrawingInfo() |
|
| 657 |
public static bool InsertDrawingInfo(string path, string drawingNumber, string drawingName)
|
|
| 652 | 658 |
{
|
| 653 | 659 |
Project_Info projectInfo = Project_Info.GetInstance(); |
| 654 | 660 |
using (SQLiteConnection connection = new SQLiteConnection(string.Format(CultureInfo.CurrentCulture, "Data Source = {0}", projectInfo.DBFilePath)))
|
| ... | ... | |
| 660 | 666 |
{
|
| 661 | 667 |
try |
| 662 | 668 |
{
|
| 663 |
//using (SQLiteCommand cmd = connection.CreateCommand())
|
|
| 664 |
//{
|
|
| 665 |
// cmd.CommandText = string.Format("INSERT OR REPLACE INTO {0} (UID, LOCATION, LEADERLINE) VALUES (@UID, @LOCATION, @LEADERLINE)", SPPID_LABEL_INFO_TABLE);
|
|
| 666 |
// cmd.Parameters.AddWithValue("@UID", item.Item1);
|
|
| 667 |
// cmd.Parameters.AddWithValue("@LOCATION", item.Item2);
|
|
| 668 |
// cmd.Parameters.AddWithValue("@LEADERLINE", item.Item3);
|
|
| 669 |
// cmd.ExecuteNonQuery();
|
|
| 670 |
//}
|
|
| 671 |
//transaction.Commit();
|
|
| 672 |
//connection.Close();
|
|
| 669 |
using (SQLiteCommand cmd = connection.CreateCommand()) |
|
| 670 |
{
|
|
| 671 |
cmd.CommandText = string.Format("INSERT OR REPLACE INTO {0} (PATH, DRAWINGNUMBER, DRAWINGNAME) VALUES (@PATH, @DRAWINGNUMBER, @DRAWINGNAME)", SPPID_DRAWING_INFO);
|
|
| 672 |
cmd.Parameters.AddWithValue("@PATH", path);
|
|
| 673 |
cmd.Parameters.AddWithValue("@DRAWINGNUMBER", drawingNumber);
|
|
| 674 |
cmd.Parameters.AddWithValue("@DRAWINGNAME", drawingName);
|
|
| 675 |
cmd.ExecuteNonQuery(); |
|
| 676 |
} |
|
| 677 |
transaction.Commit(); |
|
| 678 |
connection.Close(); |
|
| 673 | 679 |
} |
| 674 | 680 |
catch (Exception ex) |
| 675 | 681 |
{
|
내보내기 Unified diff
