/ - Diff - HYTOS - 일정관리

개정판 2425d530

ID	2425d53039b944c6d1bdc09dcd81477d4ef42a2a
상위	f4485671
하위	534af32d

gaqhf 이(가) 5년 이상 전에 추가함

dev issue #1203 : MSSQL 지원 완료

Change-Id: I39e4c4c9d7ab4bf8162bc2025aff410ac9449a2a

DTI_PID/SPPIDConverter/DB/Project_DB.cs
7	7	using System.Data.SQLite;
8	8	using System.Data;
9	9	using System.Data.SqlClient;
	10	using Converter.SPPID;
	11	using System.IO;
10	12	using Newtonsoft.Json;
11	13
12	14	namespace Converter.BaseModel
...	...
46	48	}
47	49	catch (Exception ex)
48	50	{
	51	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
49	52	connection.Dispose();
50	53	connection = null;
51	54	}
...	...
158	161	}
159	162	catch (Exception ex)
160	163	{
161
	164	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
162	165	}
163	166	finally
164	167	{
...	...
227	230	}
228	231	catch (Exception ex)
229	232	{
230
	233	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
231	234	}
232	235	finally
233	236	{
...	...
264	267	}
265	268	catch (Exception ex)
266	269	{
	270	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
267	271	return false;
268	272	}
269	273	finally
...	...
298	302	}
299	303	catch (Exception ex)
300	304	{
	305	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
301	306	return false;
302	307	}
303	308	finally
...	...
333	338	}
334	339	catch (Exception ex)
335	340	{
336
	341	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
337	342	}
338	343	finally
339	344	{
...	...
360	365	}
361	366	catch (Exception ex)
362	367	{
363
	368	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
364	369	}
365	370	finally
366	371	{
...	...
402	407	}
403	408	catch (Exception ex)
404	409	{
	410	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
405	411	return false;
406	412	}
407	413	finally
...	...
439	445	}
440	446	catch (Exception ex)
441	447	{
	448	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
442	449	return false;
443	450	}
444	451	finally
...	...
473	480	}
474	481	catch (Exception ex)
475	482	{
476
	483	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
477	484	}
478	485	finally
479	486	{
...	...
500	507	}
501	508	catch (Exception ex)
502	509	{
503
	510	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
504	511	}
505	512	finally
506	513	{
...	...
548	555	}
549	556	catch (Exception ex)
550	557	{
551
	558	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
552	559	}
553	560	finally
554	561	{
...	...
580	587	}
581	588	catch (Exception ex)
582	589	{
583
	590	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
584	591	}
585	592	finally
586	593	{
...	...
657	664	}
658	665	catch (Exception ex)
659	666	{
660
	667	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
661	668	}
662	669	finally
663	670	{
...	...
721	728	}
722	729	catch (Exception ex)
723	730	{
724
	731	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
725	732	}
726	733	finally
727	734	{
...	...
757	764	}
758	765	catch (Exception ex)
759	766	{
760
	767	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
761	768	}
762	769	finally
763	770	{
...	...
787	794	}
788	795	catch (Exception ex)
789	796	{
790
	797	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
791	798	}
792	799	finally
793	800	{
...	...
827	834	}
828	835	catch (Exception ex)
829	836	{
830
	837	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
831	838	}
832	839	finally
833	840	{
...	...
860	867	}
861	868	catch (Exception ex)
862	869	{
863
	870	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
864	871	}
865	872	finally
866	873	{
...	...
903	910	}
904	911	catch (Exception ex)
905	912	{
906
	913	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
907	914	}
908	915	finally
909	916	{
...	...
941	948	}
942	949	catch (Exception ex)
943	950	{
944
	951	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
945	952	}
946	953	finally
947	954	{
...	...
976	983	}
977	984	catch (Exception ex)
978	985	{
979
	986	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
980	987	}
981	988	finally
982	989	{
...	...
1003	1010	}
1004	1011	catch (Exception ex)
1005	1012	{
1006
	1013	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1007	1014	}
1008	1015	finally
1009	1016	{
...	...
1037	1044	}
1038	1045	catch (Exception ex)
1039	1046	{
1040
	1047	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1041	1048	}
1042	1049	finally
1043	1050	{
...	...
1064	1071	}
1065	1072	catch (Exception ex)
1066	1073	{
1067
	1074	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1068	1075	}
1069	1076	finally
1070	1077	{
...	...
1098	1105	}
1099	1106	catch (Exception ex)
1100	1107	{
1101
	1108	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1102	1109	}
1103	1110	finally
1104	1111	{
...	...
1125	1132	}
1126	1133	catch (Exception ex)
1127	1134	{
1128
	1135	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1129	1136	}
1130	1137	finally
1131	1138	{
...	...
1159	1166	}
1160	1167	catch (Exception ex)
1161	1168	{
1162
	1169	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1163	1170	}
1164	1171	finally
1165	1172	{
...	...
1186	1193	}
1187	1194	catch (Exception ex)
1188	1195	{
1189
	1196	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1190	1197	}
1191	1198	finally
1192	1199	{
...	...
1220	1227	}
1221	1228	catch (Exception ex)
1222	1229	{
1223
	1230	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1224	1231	}
1225	1232	finally
1226	1233	{
...	...
1247	1254	}
1248	1255	catch (Exception ex)
1249	1256	{
1250
	1257	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1251	1258	}
1252	1259	finally
1253	1260	{
...	...
1281	1288	}
1282	1289	catch (Exception ex)
1283	1290	{
1284
	1291	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1285	1292	}
1286	1293	finally
1287	1294	{
...	...
1308	1315	}
1309	1316	catch (Exception ex)
1310	1317	{
1311
	1318	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1312	1319	}
1313	1320	finally
1314	1321	{
...	...
1353	1360	}
1354	1361	catch (Exception ex)
1355	1362	{
	1363	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1356	1364	transaction.Rollback();
1357	1365	return false;
1358	1366	}
...	...
1364	1372	}
1365	1373	catch (Exception ex)
1366	1374	{
	1375	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1367	1376	return false;
1368	1377	}
1369	1378	finally
...	...
1408	1417	}
1409	1418	catch (Exception ex)
1410	1419	{
	1420	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1411	1421	return false;
1412	1422	}
1413	1423	finally
...	...
1451	1461	}
1452	1462	catch (Exception ex)
1453	1463	{
	1464	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1454	1465	transaction.Rollback();
1455	1466	}
1456	1467	finally
...	...
1461	1472	}
1462	1473	catch (Exception ex)
1463	1474	{
	1475	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1464	1476	return false;
1465	1477	}
1466	1478	finally
...	...
1501	1513	}
1502	1514	catch (Exception ex)
1503	1515	{
	1516	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1504	1517	return false;
1505	1518	}
1506	1519	finally
...	...
1544	1557	}
1545	1558	catch (Exception ex)
1546	1559	{
	1560	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1547	1561	transaction.Rollback();
1548	1562	return false;
1549	1563	}
...	...
1555	1569	}
1556	1570	catch (Exception ex)
1557	1571	{
	1572	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1558	1573	return false;
1559	1574	}
1560	1575	finally
...	...
1593	1608	}
1594	1609	catch (Exception ex)
1595	1610	{
	1611	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1596	1612	return false;
1597	1613	}
1598	1614	finally
...	...
1649	1665	}
1650	1666	catch (Exception ex)
1651	1667	{
	1668	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1652	1669	transaction.Rollback();
1653	1670	return false;
1654	1671	}
...	...
1660	1677	}
1661	1678	catch (Exception ex)
1662	1679	{
	1680	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1663	1681	return false;
1664	1682	}
1665	1683	finally
...	...
1678	1696	{
1679	1697	using (SqlCommand cmd = connection.CreateCommand())
1680	1698	{
1681		cmd.CommandText = string.Format("INSERT OR REPLACE INTO {0} (ID2_DRAWING_UID, PATH, DRAWINGNUMBER, DRAWINGNAME) VALUES (@ID2_DRAWING_UID, @PATH, @DRAWINGNUMBER, @DRAWINGNAME)", SPPID_DRAWING_INFO);
	1699	cmd.Parameters.Clear();
	1700	cmd.CommandText = string.Format(@"
	1701	IF EXISTS (SELECT * FROM {0} WHERE UID = '{1}')
	1702	UPDATE {0} SET PATH = @PATH, DRAWINGNUMBER = @DRAWINGNUMBER, DRAWINGNAME = @DRAWINGNAME WHERE ID2_DRAWING_UID = @ID2_DRAWING_UID
	1703	ELSE
	1704	INSERT INTO {0} (ID2_DRAWING_UID, PATH, DRAWINGNUMBER, DRAWINGNAME) VALUES (@ID2_DRAWING_UID, @PATH, @DRAWINGNUMBER, @DRAWINGNAME)", SPPID_DRAWING_INFO, document.UID);
	1705
1682	1706	cmd.Parameters.AddWithValue("@ID2_DRAWING_UID", document.UID);
1683	1707	cmd.Parameters.AddWithValue("@PATH", path);
1684	1708	cmd.Parameters.AddWithValue("@DRAWINGNUMBER", drawingNumber);
...	...
1691	1715	{
1692	1716	using (SqlCommand cmd = connection.CreateCommand())
1693	1717	{
1694		cmd.CommandText = string.Format("INSERT OR REPLACE INTO {0} (ID2_OPC_UID, SPPID_OPC_MODELITEM_ID, ID2_DRAWING_UID, ATTRIBUTES, PAIRED) VALUES (@ID2_OPC_UID, @SPPID_OPC_MODELITEM_ID, @ID2_DRAWING_UID, @ATTRIBUTES, @PAIRED)", SPPID_OPC_INFO);
	1718	cmd.Parameters.Clear();
	1719	cmd.CommandText = string.Format(@"
	1720	IF EXISTS (SELECT * FROM {0} WHERE UID = '{1}')
	1721	UPDATE {0} SET SPPID_OPC_MODELITEM_ID = @SPPID_OPC_MODELITEM_ID, ID2_DRAWING_UID = @ID2_DRAWING_UID, ATTRIBUTES = @ATTRIBUTES, PAIRED = @PAIRED WHERE ID2_OPC_UID = @ID2_OPC_UID
	1722	ELSE
	1723	INSERT INTO {0} (ID2_OPC_UID, SPPID_OPC_MODELITEM_ID, ID2_DRAWING_UID, ATTRIBUTES, PAIRED) VALUES (@ID2_OPC_UID, @SPPID_OPC_MODELITEM_ID, @ID2_DRAWING_UID, @ATTRIBUTES, @PAIRED)", SPPID_OPC_INFO, item.UID);
	1724
1695	1725	cmd.Parameters.AddWithValue("@ID2_OPC_UID", item.UID);
1696		cmd.Parameters.AddWithValue("@SPPID_OPC_MODELITEM_ID", item.SPPID.ModelItemID);
	1726	if (string.IsNullOrEmpty(item.SPPID.ModelItemID))
	1727	cmd.Parameters.AddWithValue("@SPPID_OPC_MODELITEM_ID", DBNull.Value);
	1728	else
	1729	cmd.Parameters.AddWithValue("@SPPID_OPC_MODELITEM_ID", item.SPPID.ModelItemID);
1697	1730	cmd.Parameters.AddWithValue("@ID2_DRAWING_UID", document.UID);
1698	1731	cmd.Parameters.AddWithValue("@ATTRIBUTES", JsonConvert.SerializeObject(item.SPPID.Attributes));
1699	1732	cmd.Parameters.AddWithValue("@PAIRED", false);
...	...
1705	1738	}
1706	1739	catch (Exception ex)
1707	1740	{
	1741	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1708	1742	return false;
1709	1743	}
1710	1744	finally
...	...
1746	1780	}
1747	1781	catch (Exception ex)
1748	1782	{
	1783	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1749	1784	transaction.Rollback();
1750	1785	return false;
1751	1786	}
...	...
1757	1792	}
1758	1793	catch (Exception ex)
1759	1794	{
	1795	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1760	1796	return false;
1761	1797	}
1762	1798	finally
...	...
1775	1811	{
1776	1812	using (SqlCommand cmd = connection.CreateCommand())
1777	1813	{
1778		cmd.CommandText = string.Format("INSERT OR REPLACE INTO {0} (ID2_OPC_UID, SPPID_OPC_MODELITEM_ID, ID2_DRAWING_UID, PAIRED) VALUES (@ID2_OPC_UID, @SPPID_OPC_MODELITEM_ID, @ID2_DRAWING_UID, @PAIRED)", SPPID_OPC_INFO);
	1814	cmd.Parameters.Clear();
	1815	cmd.CommandText = string.Format(@"
	1816	UPDATE {0} SET SPPID_OPC_MODELITEM_ID = @SPPID_OPC_MODELITEM_ID, ID2_DRAWING_UID = @ID2_DRAWING_UID, PAIRED = @PAIRED WHERE ID2_OPC_UID = @ID2_OPC_UID", SPPID_OPC_INFO);
1779	1817	cmd.Parameters.AddWithValue("@ID2_OPC_UID", UID);
1780		cmd.Parameters.AddWithValue("@SPPID_OPC_MODELITEM_ID", ModelItemID);
	1818	if (string.IsNullOrEmpty(ModelItemID))
	1819	cmd.Parameters.AddWithValue("@SPPID_OPC_MODELITEM_ID", DBNull.Value);
	1820	else
	1821	cmd.Parameters.AddWithValue("@SPPID_OPC_MODELITEM_ID", ModelItemID);
1781	1822	cmd.Parameters.AddWithValue("@ID2_DRAWING_UID", drawingUID);
1782	1823	cmd.Parameters.AddWithValue("@PAIRED", Paired);
1783	1824	cmd.ExecuteNonQuery();
...	...
1787	1828	}
1788	1829	catch (Exception ex)
1789	1830	{
	1831	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
1790	1832	return false;
1791	1833	}
1792	1834	finally
...	...
1798	1840	}
1799	1841	return true;
1800	1842	}
	1843
	1844	public static bool ExportMappingData()
	1845	{
	1846	bool result = true;
	1847	try
	1848	{
	1849	DataSet dataSet = new DataSet();
	1850	DataTable symbolMappingDT = GetTable(SPPID_SYMBOL_MAPPING_TABLE);
	1851	if (symbolMappingDT != null)
	1852	{
	1853	symbolMappingDT.TableName = SPPID_SYMBOL_MAPPING_TABLE;
	1854	dataSet.Tables.Add(symbolMappingDT);
	1855	}
	1856	else
	1857	result = false;
	1858
	1859	DataTable attributeMappingDT = GetTable(SPPID_ATTRIBUTE_MAPPING_TABLE);
	1860	if (attributeMappingDT != null)
	1861	{
	1862	attributeMappingDT.TableName = SPPID_ATTRIBUTE_MAPPING_TABLE;
	1863	dataSet.Tables.Add(attributeMappingDT);
	1864	}
	1865	else
	1866	result = false;
	1867
	1868	if (result)
	1869	{
	1870	string text = JsonConvert.SerializeObject(dataSet);
	1871	using (StreamWriter sw = new StreamWriter(Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory) + @"\ExportFile.mapf", false))
	1872	{
	1873	sw.Write(text);
	1874	sw.Close();
	1875	sw.Dispose();
	1876	}
	1877	}
	1878	}
	1879	catch (Exception ex)
	1880	{
	1881	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
	1882	result = false;
	1883	}
	1884
	1885	return result;
	1886	}
	1887
	1888	public static bool ImportMappingData()
	1889	{
	1890	bool result = true;
	1891	try
	1892	{
	1893	string sJson = string.Empty;
	1894	using (StreamReader sw = new StreamReader(Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory) + @"\ExportFile.mapf"))
	1895	{
	1896	sJson = sw.ReadToEnd();
	1897	sw.Close();
	1898	sw.Dispose();
	1899	}
	1900
	1901	DataSet dataSet = JsonConvert.DeserializeObject<DataSet>(sJson);
	1902	DataTable symbolMappingDT = dataSet.Tables[SPPID_SYMBOL_MAPPING_TABLE];
	1903	if (symbolMappingDT == null \|\| !ImportSymbolMappingTable(symbolMappingDT))
	1904	result = false;
	1905
	1906	DataTable attributeMappingDT = dataSet.Tables[SPPID_ATTRIBUTE_MAPPING_TABLE];
	1907	if (attributeMappingDT == null \|\| !ImportAttributeMappingTable(attributeMappingDT))
	1908	result = false;
	1909	}
	1910	catch (Exception ex)
	1911	{
	1912	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
	1913	result = false;
	1914	}
	1915
	1916	return result;
	1917	}
	1918
	1919	private static DataTable GetTable(string tableName)
	1920	{
	1921	DataTable dt = new DataTable();
	1922	Project_Info projectInfo = Project_Info.GetInstance();
	1923	if (projectInfo.DBType == ID2DB_Type.SQLite)
	1924	{
	1925	using (SQLiteConnection connection = new SQLiteConnection(string.Format(CultureInfo.CurrentCulture, "Data Source = {0}", projectInfo.DBFilePath)))
	1926	{
	1927	try
	1928	{
	1929	connection.Open();
	1930	using (SQLiteCommand cmd = connection.CreateCommand())
	1931	{
	1932	cmd.CommandText = string.Format("SELECT * FROM {0}", tableName);
	1933	using (SQLiteDataReader dr = cmd.ExecuteReader())
	1934	dt.Load(dr);
	1935	}
	1936	connection.Close();
	1937	}
	1938	catch (Exception ex)
	1939	{
	1940	dt = null;
	1941	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
	1942	}
	1943	finally
	1944	{
	1945	connection.Dispose();
	1946	}
	1947	}
	1948	}
	1949	else if (projectInfo.DBType == ID2DB_Type.MSSQL)
	1950	{
	1951	using (SqlConnection connection = GetSqlConnection())
	1952	{
	1953	try
	1954	{
	1955	if (connection != null && connection.State == ConnectionState.Open)
	1956	{
	1957	using (SqlCommand cmd = connection.CreateCommand())
	1958	{
	1959	cmd.CommandText = string.Format("SELECT * FROM {0}", tableName);
	1960	using (SqlDataReader dr = cmd.ExecuteReader())
	1961	dt.Load(dr);
	1962	}
	1963	connection.Close();
	1964	}
	1965	}
	1966	catch (Exception ex)
	1967	{
	1968	dt = null;
	1969	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
	1970	}
	1971	finally
	1972	{
	1973	if (connection != null)
	1974	connection.Dispose();
	1975	}
	1976	}
	1977	}
	1978
	1979	return dt;
	1980	}
	1981
	1982	private static bool ImportSymbolMappingTable(DataTable dt)
	1983	{
	1984	bool result = false;
	1985
	1986	Project_Info projectInfo = Project_Info.GetInstance();
	1987	if (projectInfo.DBType == ID2DB_Type.SQLite)
	1988	{
	1989	using (SQLiteConnection connection = new SQLiteConnection(string.Format(CultureInfo.CurrentCulture, "Data Source = {0}", projectInfo.DBFilePath)))
	1990	{
	1991	try
	1992	{
	1993	connection.Open();
	1994	using (SQLiteTransaction transaction = connection.BeginTransaction())
	1995	{
	1996	try
	1997	{
	1998	using (SQLiteCommand cmd = connection.CreateCommand())
	1999	{
	2000	foreach (DataRow item in dt.Rows)
	2001	{
	2002	string UID = DBNull.Value.Equals(item["UID"]) ? null : (string)item["UID"];
	2003	string NAME = DBNull.Value.Equals(item["NAME"]) ? null : (string)item["NAME"];
	2004	string SPPID_SYMBOL_PATH = DBNull.Value.Equals(item["SPPID_SYMBOL_PATH"]) ? null : (string)item["SPPID_SYMBOL_PATH"];
	2005	bool LEADERLINE = Convert.ToBoolean(item["LEADERLINE"]);
	2006
	2007	cmd.Parameters.Clear();
	2008	cmd.CommandText = string.Format("INSERT OR REPLACE INTO {0} (UID, NAME, SPPID_SYMBOL_PATH, LEADERLINE) VALUES (@UID, @NAME, @SPPID_SYMBOL_PATH, @LEADERLINE)", SPPID_SYMBOL_MAPPING_TABLE);
	2009	cmd.Parameters.AddWithValue("@UID", UID);
	2010	cmd.Parameters.AddWithValue("@NAME", NAME);
	2011	cmd.Parameters.AddWithValue("@SPPID_SYMBOL_PATH", SPPID_SYMBOL_PATH);
	2012	cmd.Parameters.AddWithValue("@LEADERLINE", LEADERLINE);
	2013	cmd.ExecuteNonQuery();
	2014	}
	2015	}
	2016	transaction.Commit();
	2017	connection.Close();
	2018	result = true;
	2019	}
	2020	catch (Exception ex)
	2021	{
	2022	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
	2023	transaction.Rollback();
	2024	}
	2025	finally
	2026	{
	2027	transaction.Dispose();
	2028	}
	2029	}
	2030	}
	2031	catch (Exception ex)
	2032	{
	2033	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
	2034	}
	2035	finally
	2036	{
	2037	connection.Dispose();
	2038	}
	2039	}
	2040	}
	2041	else if (projectInfo.DBType == ID2DB_Type.MSSQL)
	2042	{
	2043	using (SqlConnection connection = GetSqlConnection())
	2044	{
	2045	try
	2046	{
	2047	if (connection != null && connection.State == ConnectionState.Open)
	2048	{
	2049	using (SqlCommand cmd = connection.CreateCommand())
	2050	{
	2051	foreach (DataRow item in dt.Rows)
	2052	{
	2053	string UID = DBNull.Value.Equals(item["UID"]) ? null : (string)item["UID"];
	2054	string NAME = DBNull.Value.Equals(item["NAME"]) ? null : (string)item["NAME"];
	2055	string SPPID_SYMBOL_PATH = DBNull.Value.Equals(item["SPPID_SYMBOL_PATH"]) ? null : (string)item["SPPID_SYMBOL_PATH"];
	2056	bool LEADERLINE = DBNull.Value.Equals(item["LEADERLINE"]) ? false : Convert.ToBoolean(item["LEADERLINE"]);
	2057
	2058	cmd.Parameters.Clear();
	2059	cmd.CommandText = string.Format(@"
	2060	IF EXISTS (SELECT * FROM {0} WHERE UID = '{1}')
	2061	UPDATE {0} SET NAME = @NAME, SPPID_SYMBOL_PATH = @SPPID_SYMBOL_PATH, LEADERLINE = @LEADERLINE WHERE UID = @UID
	2062	ELSE
	2063	INSERT INTO {0} (UID, NAME, SPPID_SYMBOL_PATH, LEADERLINE) VALUES (@UID, @NAME, @SPPID_SYMBOL_PATH, @LEADERLINE)", SPPID_SYMBOL_MAPPING_TABLE, UID);
	2064	cmd.Parameters.AddWithValue("@UID", UID);
	2065	if (string.IsNullOrEmpty(NAME))
	2066	cmd.Parameters.AddWithValue("@NAME", DBNull.Value);
	2067	else
	2068	cmd.Parameters.AddWithValue("@NAME", NAME);
	2069	if (string.IsNullOrEmpty(SPPID_SYMBOL_PATH))
	2070	cmd.Parameters.AddWithValue("@SPPID_SYMBOL_PATH", DBNull.Value);
	2071	else
	2072	cmd.Parameters.AddWithValue("@SPPID_SYMBOL_PATH", SPPID_SYMBOL_PATH);
	2073	cmd.Parameters.AddWithValue("@LEADERLINE", LEADERLINE);
	2074	cmd.ExecuteNonQuery();
	2075	}
	2076	}
	2077	connection.Close();
	2078	result = true;
	2079	}
	2080	}
	2081	catch (Exception ex)
	2082	{
	2083	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
	2084	}
	2085	finally
	2086	{
	2087	if (connection != null)
	2088	connection.Dispose();
	2089	}
	2090	}
	2091	}
	2092
	2093	return result;
	2094	}
	2095
	2096	private static bool ImportAttributeMappingTable(DataTable dt)
	2097	{
	2098	bool result = false;
	2099
	2100	Project_Info projectInfo = Project_Info.GetInstance();
	2101	if (projectInfo.DBType == ID2DB_Type.SQLite)
	2102	{
	2103	using (SQLiteConnection connection = new SQLiteConnection(string.Format(CultureInfo.CurrentCulture, "Data Source = {0}", projectInfo.DBFilePath)))
	2104	{
	2105	try
	2106	{
	2107	connection.Open();
	2108	using (SQLiteTransaction transaction = connection.BeginTransaction())
	2109	{
	2110	try
	2111	{
	2112	using (SQLiteCommand cmd = connection.CreateCommand())
	2113	{
	2114	foreach (DataRow item in dt.Rows)
	2115	{
	2116	string UID = DBNull.Value.Equals(item["UID"]) ? null : (string)item["UID"];
	2117	string SPPID_ATTRIBUTE = DBNull.Value.Equals(item["SPPID_ATTRIBUTE"]) ? null : (string)item["SPPID_ATTRIBUTE"];
	2118
	2119	cmd.Parameters.Clear();
	2120	cmd.CommandText = string.Format("INSERT OR REPLACE INTO {0} (UID, SPPID_ATTRIBUTE) VALUES (@UID, @SPPID_ATTRIBUTE)", SPPID_ATTRIBUTE_MAPPING_TABLE);
	2121	cmd.Parameters.AddWithValue("@UID", UID);
	2122	cmd.Parameters.AddWithValue("@SPPID_ATTRIBUTE", SPPID_ATTRIBUTE);
	2123	cmd.ExecuteNonQuery();
	2124	}
	2125	}
	2126	transaction.Commit();
	2127	connection.Close();
	2128	result = true;
	2129	}
	2130	catch (Exception ex)
	2131	{
	2132	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
	2133	transaction.Rollback();
	2134	}
	2135	finally
	2136	{
	2137	transaction.Dispose();
	2138	}
	2139	}
	2140	}
	2141	catch (Exception ex)
	2142	{
	2143	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
	2144	}
	2145	finally
	2146	{
	2147	connection.Dispose();
	2148	}
	2149	}
	2150	}
	2151	else if (projectInfo.DBType == ID2DB_Type.MSSQL)
	2152	{
	2153	using (SqlConnection connection = GetSqlConnection())
	2154	{
	2155	try
	2156	{
	2157	if (connection != null && connection.State == ConnectionState.Open)
	2158	{
	2159	using (SqlCommand cmd = connection.CreateCommand())
	2160	{
	2161	foreach (DataRow item in dt.Rows)
	2162	{
	2163	string UID = DBNull.Value.Equals(item["UID"]) ? null : (string)item["UID"];
	2164	string SPPID_ATTRIBUTE = DBNull.Value.Equals(item["SPPID_ATTRIBUTE"]) ? null : (string)item["SPPID_ATTRIBUTE"];
	2165
	2166	cmd.Parameters.Clear();
	2167	cmd.CommandText = string.Format(@"
	2168	IF EXISTS (SELECT * FROM {0} WHERE UID = '{1}')
	2169	UPDATE {0} SET SPPID_ATTRIBUTE = @SPPID_ATTRIBUTE WHERE UID = @UID
	2170	ELSE
	2171	INSERT INTO {0} (UID, SPPID_ATTRIBUTE) VALUES (@UID, @SPPID_ATTRIBUTE)", SPPID_ATTRIBUTE_MAPPING_TABLE, UID);
	2172
	2173	cmd.Parameters.AddWithValue("@UID", UID);
	2174	if (string.IsNullOrEmpty(SPPID_ATTRIBUTE))
	2175	cmd.Parameters.AddWithValue("@SPPID_ATTRIBUTE", DBNull.Value);
	2176	else
	2177	cmd.Parameters.AddWithValue("@SPPID_ATTRIBUTE", SPPID_ATTRIBUTE);
	2178	cmd.ExecuteNonQuery();
	2179	}
	2180	}
	2181	connection.Close();
	2182	result = true;
	2183	}
	2184	}
	2185	catch (Exception ex)
	2186	{
	2187	Log.Write(ex.Message + "\r\n" + ex.StackTrace);
	2188	}
	2189	finally
	2190	{
	2191	if (connection != null)
	2192	connection.Dispose();
	2193	}
	2194	}
	2195	}
	2196
	2197
	2198
	2199	return result;
	2200	}
1801	2201	}
1802	2202	}

                 this.layoutControlItem12 = new DevExpress.XtraLayout.LayoutControlItem();
                 this.layoutControlItem4 = new DevExpress.XtraLayout.LayoutControlItem();
                 this.emptySpaceItem1 = new DevExpress.XtraLayout.EmptySpaceItem();
                 this.btnExportData = new DevExpress.XtraEditors.SimpleButton();
                 this.layoutControlItem26 = new DevExpress.XtraLayout.LayoutControlItem();
                 this.btnImportData = new DevExpress.XtraEditors.SimpleButton();
                 this.layoutControlItem27 = new DevExpress.XtraLayout.LayoutControlItem();
                 ((System.ComponentModel.ISupportInitialize)(this.ribbonControl)).BeginInit();
                 ((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).BeginInit();
                 this.layoutControl1.SuspendLayout();
-...
                 ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem12)).BeginInit();
                 ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem4)).BeginInit();
                 ((System.ComponentModel.ISupportInitialize)(this.emptySpaceItem1)).BeginInit();
                 ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem26)).BeginInit();
                 ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem27)).BeginInit();
                 this.SuspendLayout();
                 //
                 // ribbonControl
-...
                 this.ribbonControl.ShowDisplayOptionsMenuButton = DevExpress.Utils.DefaultBoolean.False;
                 this.ribbonControl.ShowPageHeadersMode = DevExpress.XtraBars.Ribbon.ShowPageHeadersMode.ShowOnMultiplePages;
                 this.ribbonControl.ShowToolbarCustomizeItem = false;
                 this.ribbonControl.Size = new System.Drawing.Size(1094, 32);
                 this.ribbonControl.Size = new System.Drawing.Size(1135, 27);
                 this.ribbonControl.Toolbar.ShowCustomizeItem = false;
                 //
                 // layoutControl1
                 //
                 this.layoutControl1.Controls.Add(this.btnImportData);
                 this.layoutControl1.Controls.Add(this.btnExportData);
                 this.layoutControl1.Controls.Add(this.btnExportExcel);
                 this.layoutControl1.Controls.Add(this.spinEditDrainValveCellCount);
                 this.layoutControl1.Controls.Add(this.spinEditMinSymbolGridCellCount);
-...
                 this.layoutControl1.Controls.Add(this.checkEditSnapGrid);
                 this.layoutControl1.Controls.Add(this.textBoxFlowMarkSymbolPath);
                 this.layoutControl1.Dock = System.Windows.Forms.DockStyle.Fill;
                 this.layoutControl1.Location = new System.Drawing.Point(0, 32);
                 this.layoutControl1.Location = new System.Drawing.Point(0, 27);
                 this.layoutControl1.Name = "layoutControl1";
                 this.layoutControl1.Root = this.Root;
                 this.layoutControl1.Size = new System.Drawing.Size(1094, 738);
                 this.layoutControl1.Size = new System.Drawing.Size(1135, 792);
                 this.layoutControl1.TabIndex = 2;
                 this.layoutControl1.Text = "layoutControl1";
                 //
                 // btnExportExcel
                 //
                 this.btnExportExcel.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("btnExportExcel.ImageOptions.Image")));
                 this.btnExportExcel.Location = new System.Drawing.Point(801, 638);
                 this.btnExportExcel.Location = new System.Drawing.Point(825, 606);
                 this.btnExportExcel.Name = "btnExportExcel";
                 this.btnExportExcel.Size = new System.Drawing.Size(269, 36);
                 this.btnExportExcel.Size = new System.Drawing.Size(286, 38);
                 this.btnExportExcel.StyleController = this.layoutControl1;
                 this.btnExportExcel.TabIndex = 37;
                 this.btnExportExcel.Text = "Export to Excel";
                 this.btnExportExcel.Text = "Export Mapping Info to Excel";
                 this.btnExportExcel.Click += new System.EventHandler(this.btnExportExcel_Click);
                 //
                 // spinEditDrainValveCellCount
-...
 ,
 ,
 });
                 this.spinEditDrainValveCellCount.Location = new System.Drawing.Point(543, 158);
                 this.spinEditDrainValveCellCount.Location = new System.Drawing.Point(557, 156);
                 this.spinEditDrainValveCellCount.MenuManager = this.ribbonControl;
                 this.spinEditDrainValveCellCount.Name = "spinEditDrainValveCellCount";
                 this.spinEditDrainValveCellCount.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                 new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
                 this.spinEditDrainValveCellCount.Properties.IsFloatValue = false;
                 this.spinEditDrainValveCellCount.Properties.Mask.EditMask = "N00";
                 this.spinEditDrainValveCellCount.Size = new System.Drawing.Size(196, 20);
                 this.spinEditDrainValveCellCount.Size = new System.Drawing.Size(211, 20);
                 this.spinEditDrainValveCellCount.StyleController = this.layoutControl1;
                 this.spinEditDrainValveCellCount.TabIndex = 35;
                 //
-...
 ,
 ,
 });
                 this.spinEditMinSymbolGridCellCount.Location = new System.Drawing.Point(196, 158);
                 this.spinEditMinSymbolGridCellCount.Location = new System.Drawing.Point(196, 156);
                 this.spinEditMinSymbolGridCellCount.MenuManager = this.ribbonControl;
                 this.spinEditMinSymbolGridCellCount.Name = "spinEditMinSymbolGridCellCount";
                 this.spinEditMinSymbolGridCellCount.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                 new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
                 this.spinEditMinSymbolGridCellCount.Properties.IsFloatValue = false;
                 this.spinEditMinSymbolGridCellCount.Properties.Mask.EditMask = "N00";
                 this.spinEditMinSymbolGridCellCount.Size = new System.Drawing.Size(195, 20);
                 this.spinEditMinSymbolGridCellCount.Size = new System.Drawing.Size(209, 20);
                 this.spinEditMinSymbolGridCellCount.StyleController = this.layoutControl1;
                 this.spinEditMinSymbolGridCellCount.TabIndex = 34;
                 //
                 // comboBoxEditUnit
                 //
                 this.comboBoxEditUnit.EditValue = "Inch";
                 this.comboBoxEditUnit.Location = new System.Drawing.Point(543, 101);
                 this.comboBoxEditUnit.Location = new System.Drawing.Point(557, 101);
                 this.comboBoxEditUnit.MenuManager = this.ribbonControl;
                 this.comboBoxEditUnit.Name = "comboBoxEditUnit";
                 this.comboBoxEditUnit.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                 new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
                 this.comboBoxEditUnit.Properties.Items.AddRange(new object[] {
                 "Inch"});
                 this.comboBoxEditUnit.Size = new System.Drawing.Size(208, 20);
                 this.comboBoxEditUnit.Size = new System.Drawing.Size(223, 20);
                 this.comboBoxEditUnit.StyleController = this.layoutControl1;
                 this.comboBoxEditUnit.TabIndex = 33;
                 //
-...
 ,
 ,
 });
                 this.spinEditDensity.Size = new System.Drawing.Size(207, 20);
                 this.spinEditDensity.Size = new System.Drawing.Size(221, 20);
                 this.spinEditDensity.StyleController = this.layoutControl1;
                 this.spinEditDensity.TabIndex = 32;
                 //
                 // checkComboBoxLineNumberLocation
                 //
                 this.checkComboBoxLineNumberLocation.Location = new System.Drawing.Point(529, 79);
                 this.checkComboBoxLineNumberLocation.Location = new System.Drawing.Point(546, 78);
                 this.checkComboBoxLineNumberLocation.MenuManager = this.ribbonControl;
                 this.checkComboBoxLineNumberLocation.Name = "checkComboBoxLineNumberLocation";
                 this.checkComboBoxLineNumberLocation.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                 new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
                 this.checkComboBoxLineNumberLocation.Size = new System.Drawing.Size(222, 20);
                 this.checkComboBoxLineNumberLocation.Size = new System.Drawing.Size(234, 20);
                 this.checkComboBoxLineNumberLocation.StyleController = this.layoutControl1;
                 this.checkComboBoxLineNumberLocation.TabIndex = 30;
                 //
                 // checkComboBoxNoteLocation
                 //
                 this.checkComboBoxNoteLocation.Location = new System.Drawing.Point(522, 103);
                 this.checkComboBoxNoteLocation.Location = new System.Drawing.Point(538, 102);
                 this.checkComboBoxNoteLocation.MenuManager = this.ribbonControl;
                 this.checkComboBoxNoteLocation.Name = "checkComboBoxNoteLocation";
                 this.checkComboBoxNoteLocation.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                 new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
                 this.checkComboBoxNoteLocation.Size = new System.Drawing.Size(229, 20);
                 this.checkComboBoxNoteLocation.Size = new System.Drawing.Size(242, 20);
                 this.checkComboBoxNoteLocation.StyleController = this.layoutControl1;
                 this.checkComboBoxNoteLocation.TabIndex = 29;
                 //
                 // checkComboBoxTextLocation
                 //
                 this.checkComboBoxTextLocation.Location = new System.Drawing.Point(522, 79);
                 this.checkComboBoxTextLocation.Location = new System.Drawing.Point(538, 78);
                 this.checkComboBoxTextLocation.MenuManager = this.ribbonControl;
                 this.checkComboBoxTextLocation.Name = "checkComboBoxTextLocation";
                 this.checkComboBoxTextLocation.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                 new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});
                 this.checkComboBoxTextLocation.Size = new System.Drawing.Size(229, 20);
                 this.checkComboBoxTextLocation.Size = new System.Drawing.Size(242, 20);
                 this.checkComboBoxTextLocation.StyleController = this.layoutControl1;
                 this.checkComboBoxTextLocation.TabIndex = 28;
                 //
                 // btnImageRefresh
                 //
                 this.btnImageRefresh.ImageOptions.SvgImage = ((DevExpress.Utils.Svg.SvgImage)(resources.GetObject("btnImageRefresh.ImageOptions.SvgImage")));
                 this.btnImageRefresh.Location = new System.Drawing.Point(801, 598);
                 this.btnImageRefresh.Location = new System.Drawing.Point(825, 564);
                 this.btnImageRefresh.Name = "btnImageRefresh";
                 this.btnImageRefresh.Size = new System.Drawing.Size(269, 36);
                 this.btnImageRefresh.Size = new System.Drawing.Size(286, 38);
                 this.btnImageRefresh.StyleController = this.layoutControl1;
                 this.btnImageRefresh.TabIndex = 27;
                 this.btnImageRefresh.Text = "Refresh SPPID Image";
-...
                 //
                 // textBoxDrainValveSize
                 //
                 this.textBoxDrainValveSize.Location = new System.Drawing.Point(184, 241);
                 this.textBoxDrainValveSize.Location = new System.Drawing.Point(184, 236);
                 this.textBoxDrainValveSize.MenuManager = this.ribbonControl;
                 this.textBoxDrainValveSize.Name = "textBoxDrainValveSize";
                 this.textBoxDrainValveSize.Size = new System.Drawing.Size(567, 20);
                 this.textBoxDrainValveSize.Size = new System.Drawing.Size(596, 20);
                 this.textBoxDrainValveSize.StyleController = this.layoutControl1;
                 this.textBoxDrainValveSize.TabIndex = 26;
                 //
                 // textBoxNoteSymbolPath
                 //
                 this.textBoxNoteSymbolPath.Location = new System.Drawing.Point(184, 103);
                 this.textBoxNoteSymbolPath.Location = new System.Drawing.Point(184, 102);
                 this.textBoxNoteSymbolPath.MenuManager = this.ribbonControl;
                 this.textBoxNoteSymbolPath.Name = "textBoxNoteSymbolPath";
                 this.textBoxNoteSymbolPath.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                 new DevExpress.XtraEditors.Controls.EditorButton()});
                 this.textBoxNoteSymbolPath.Size = new System.Drawing.Size(251, 20);
                 this.textBoxNoteSymbolPath.Size = new System.Drawing.Size(267, 20);
                 this.textBoxNoteSymbolPath.StyleController = this.layoutControl1;
                 this.textBoxNoteSymbolPath.TabIndex = 25;
                 this.textBoxNoteSymbolPath.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(this.textBoxETC_ButtonClick);
                 //
                 // textBoxTextSymbolPath
                 //
                 this.textBoxTextSymbolPath.Location = new System.Drawing.Point(184, 79);
                 this.textBoxTextSymbolPath.Location = new System.Drawing.Point(184, 78);
                 this.textBoxTextSymbolPath.MenuManager = this.ribbonControl;
                 this.textBoxTextSymbolPath.Name = "textBoxTextSymbolPath";
                 this.textBoxTextSymbolPath.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                 new DevExpress.XtraEditors.Controls.EditorButton()});
                 this.textBoxTextSymbolPath.Size = new System.Drawing.Size(251, 20);
                 this.textBoxTextSymbolPath.Size = new System.Drawing.Size(267, 20);
                 this.textBoxTextSymbolPath.StyleController = this.layoutControl1;
                 this.textBoxTextSymbolPath.TabIndex = 24;
                 this.textBoxTextSymbolPath.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(this.textBoxETC_ButtonClick);
                 //
                 // textBoxLineNumberPath
                 //
                 this.textBoxLineNumberPath.Location = new System.Drawing.Point(208, 79);
                 this.textBoxLineNumberPath.Location = new System.Drawing.Point(208, 78);
                 this.textBoxLineNumberPath.MenuManager = this.ribbonControl;
                 this.textBoxLineNumberPath.Name = "textBoxLineNumberPath";
                 this.textBoxLineNumberPath.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                 new DevExpress.XtraEditors.Controls.EditorButton()});
                 this.textBoxLineNumberPath.Properties.ReadOnly = true;
                 this.textBoxLineNumberPath.Size = new System.Drawing.Size(234, 20);
                 this.textBoxLineNumberPath.Size = new System.Drawing.Size(251, 20);
                 this.textBoxLineNumberPath.StyleController = this.layoutControl1;
                 this.textBoxLineNumberPath.TabIndex = 23;
                 this.textBoxLineNumberPath.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(this.textBoxLineNumberPath_ButtonClick);
                 //
                 // gridControlLineNumber
                 //
                 this.gridControlLineNumber.Location = new System.Drawing.Point(36, 103);
                 this.gridControlLineNumber.Location = new System.Drawing.Point(36, 102);
                 this.gridControlLineNumber.MainView = this.gridViewLineNumber;
                 this.gridControlLineNumber.MenuManager = this.ribbonControl;
                 this.gridControlLineNumber.Name = "gridControlLineNumber";
                 this.gridControlLineNumber.Size = new System.Drawing.Size(715, 559);
                 this.gridControlLineNumber.Size = new System.Drawing.Size(744, 614);
                 this.gridControlLineNumber.TabIndex = 21;
                 this.gridControlLineNumber.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
                 this.gridViewLineNumber});
-...
                 // btnClose
                 //
                 this.btnClose.ImageOptions.SvgImage = ((DevExpress.Utils.Svg.SvgImage)(resources.GetObject("btnClose.ImageOptions.SvgImage")));
                 this.btnClose.Location = new System.Drawing.Point(996, 690);
                 this.btnClose.Location = new System.Drawing.Point(1037, 744);
                 this.btnClose.Name = "btnClose";
                 this.btnClose.Size = new System.Drawing.Size(86, 36);
                 this.btnClose.StyleController = this.layoutControl1;
-...
                 //
                 // gridControlAttribute
                 //
                 this.gridControlAttribute.Location = new System.Drawing.Point(36, 79);
                 this.gridControlAttribute.Location = new System.Drawing.Point(36, 78);
                 this.gridControlAttribute.MainView = this.gridViewAttribute;
                 this.gridControlAttribute.MenuManager = this.ribbonControl;
                 this.gridControlAttribute.Name = "gridControlAttribute";
                 this.gridControlAttribute.Size = new System.Drawing.Size(715, 583);
                 this.gridControlAttribute.Size = new System.Drawing.Size(744, 638);
                 this.gridControlAttribute.TabIndex = 19;
                 this.gridControlAttribute.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
                 this.gridViewAttribute});
-...
                 //
                 // gridControlLine
                 //
                 this.gridControlLine.Location = new System.Drawing.Point(36, 79);
                 this.gridControlLine.Location = new System.Drawing.Point(36, 78);
                 this.gridControlLine.MainView = this.gridViewLine;
                 this.gridControlLine.MenuManager = this.ribbonControl;
                 this.gridControlLine.Name = "gridControlLine";
                 this.gridControlLine.Size = new System.Drawing.Size(715, 583);
                 this.gridControlLine.Size = new System.Drawing.Size(744, 638);
                 this.gridControlLine.TabIndex = 18;
                 this.gridControlLine.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
                 this.gridViewLine});
-...
                 //
                 // gridControlSymbol
                 //
                 this.gridControlSymbol.Location = new System.Drawing.Point(36, 79);
                 this.gridControlSymbol.Location = new System.Drawing.Point(36, 78);
                 this.gridControlSymbol.MainView = this.gridViewSymbol;
                 this.gridControlSymbol.MenuManager = this.ribbonControl;
                 this.gridControlSymbol.Name = "gridControlSymbol";
                 this.gridControlSymbol.Size = new System.Drawing.Size(715, 253);
                 this.gridControlSymbol.Size = new System.Drawing.Size(744, 280);
                 this.gridControlSymbol.TabIndex = 16;
                 this.gridControlSymbol.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {
                 this.gridViewSymbol});
-...
                 //
                 // pictureEditSPPIDSymbol
                 //
                 this.pictureEditSPPIDSymbol.Location = new System.Drawing.Point(813, 370);
                 this.pictureEditSPPIDSymbol.Location = new System.Drawing.Point(837, 328);
                 this.pictureEditSPPIDSymbol.MenuManager = this.ribbonControl;
                 this.pictureEditSPPIDSymbol.Name = "pictureEditSPPIDSymbol";
                 this.pictureEditSPPIDSymbol.Properties.ShowCameraMenuItem = DevExpress.XtraEditors.Controls.CameraMenuItemVisibility.Auto;
                 this.pictureEditSPPIDSymbol.Properties.SizeMode = DevExpress.XtraEditors.Controls.PictureSizeMode.Squeeze;
                 this.pictureEditSPPIDSymbol.Size = new System.Drawing.Size(245, 212);
                 this.pictureEditSPPIDSymbol.Size = new System.Drawing.Size(262, 220);
                 this.pictureEditSPPIDSymbol.StyleController = this.layoutControl1;
                 this.pictureEditSPPIDSymbol.TabIndex = 15;
                 //
                 // btnSave
                 //
                 this.btnSave.ImageOptions.SvgImage = ((DevExpress.Utils.Svg.SvgImage)(resources.GetObject("btnSave.ImageOptions.SvgImage")));
                 this.btnSave.Location = new System.Drawing.Point(893, 690);
                 this.btnSave.Location = new System.Drawing.Point(934, 744);
                 this.btnSave.Name = "btnSave";
                 this.btnSave.Size = new System.Drawing.Size(84, 36);
                 this.btnSave.StyleController = this.layoutControl1;
-...
                 // treeListSPPIDTreeList
                 //
                 this.treeListSPPIDTreeList.Cursor = System.Windows.Forms.Cursors.Default;
                 this.treeListSPPIDTreeList.Location = new System.Drawing.Point(801, 45);
                 this.treeListSPPIDTreeList.Location = new System.Drawing.Point(825, 43);
                 this.treeListSPPIDTreeList.Name = "treeListSPPIDTreeList";
                 this.treeListSPPIDTreeList.Size = new System.Drawing.Size(269, 278);
                 this.treeListSPPIDTreeList.Size = new System.Drawing.Size(286, 245);
                 this.treeListSPPIDTreeList.TabIndex = 12;
                 this.treeListSPPIDTreeList.FocusedNodeChanged += new DevExpress.XtraTreeList.FocusedNodeChangedEventHandler(this.treeListSPPIDTreeList_FocusedNodeChanged);
                 this.treeListSPPIDTreeList.DoubleClick += new System.EventHandler(this.treeListSPPIDTreeList_DoubleClick);
                 //
                 // pictureEditID2Symbol
                 //
                 this.pictureEditID2Symbol.Location = new System.Drawing.Point(36, 391);
                 this.pictureEditID2Symbol.Location = new System.Drawing.Point(36, 410);
                 this.pictureEditID2Symbol.MenuManager = this.ribbonControl;
                 this.pictureEditID2Symbol.Name = "pictureEditID2Symbol";
                 this.pictureEditID2Symbol.Properties.ShowCameraMenuItem = DevExpress.XtraEditors.Controls.CameraMenuItemVisibility.Auto;
                 this.pictureEditID2Symbol.Properties.SizeMode = DevExpress.XtraEditors.Controls.PictureSizeMode.Squeeze;
                 this.pictureEditID2Symbol.Size = new System.Drawing.Size(364, 271);
                 this.pictureEditID2Symbol.Size = new System.Drawing.Size(379, 306);
                 this.pictureEditID2Symbol.StyleController = this.layoutControl1;
                 this.pictureEditID2Symbol.TabIndex = 4;
                 //
                 // pictureEditMapped
                 //
                 this.pictureEditMapped.Location = new System.Drawing.Point(438, 391);
                 this.pictureEditMapped.Location = new System.Drawing.Point(448, 410);
                 this.pictureEditMapped.MenuManager = this.ribbonControl;
                 this.pictureEditMapped.Name = "pictureEditMapped";
                 this.pictureEditMapped.Properties.ShowCameraMenuItem = DevExpress.XtraEditors.Controls.CameraMenuItemVisibility.Auto;
                 this.pictureEditMapped.Properties.SizeMode = DevExpress.XtraEditors.Controls.PictureSizeMode.Squeeze;
                 this.pictureEditMapped.Size = new System.Drawing.Size(313, 271);
                 this.pictureEditMapped.Size = new System.Drawing.Size(332, 306);
                 this.pictureEditMapped.StyleController = this.layoutControl1;
                 this.pictureEditMapped.TabIndex = 5;
                 //
                 // checkEditSnapGrid
                 //
                 this.checkEditSnapGrid.EditValue = true;
                 this.checkEditSnapGrid.Location = new System.Drawing.Point(36, 79);
                 this.checkEditSnapGrid.Location = new System.Drawing.Point(36, 78);
                 this.checkEditSnapGrid.MenuManager = this.ribbonControl;
                 this.checkEditSnapGrid.Name = "checkEditSnapGrid";
                 this.checkEditSnapGrid.Properties.Caption = "Use Snap Grid";
                 this.checkEditSnapGrid.Size = new System.Drawing.Size(715, 18);
                 this.checkEditSnapGrid.Size = new System.Drawing.Size(744, 19);
                 this.checkEditSnapGrid.StyleController = this.layoutControl1;
                 this.checkEditSnapGrid.TabIndex = 31;
                 this.checkEditSnapGrid.CheckedChanged += new System.EventHandler(this.checkEditSnapGrid_CheckedChanged);
                 //
                 // textBoxFlowMarkSymbolPath
                 //
                 this.textBoxFlowMarkSymbolPath.Location = new System.Drawing.Point(184, 172);
                 this.textBoxFlowMarkSymbolPath.Location = new System.Drawing.Point(184, 169);
                 this.textBoxFlowMarkSymbolPath.MenuManager = this.ribbonControl;
                 this.textBoxFlowMarkSymbolPath.Name = "textBoxFlowMarkSymbolPath";
                 this.textBoxFlowMarkSymbolPath.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {
                 new DevExpress.XtraEditors.Controls.EditorButton()});
                 this.textBoxFlowMarkSymbolPath.Size = new System.Drawing.Size(567, 20);
                 this.textBoxFlowMarkSymbolPath.Size = new System.Drawing.Size(596, 20);
                 this.textBoxFlowMarkSymbolPath.StyleController = this.layoutControl1;
                 this.textBoxFlowMarkSymbolPath.TabIndex = 36;
                 this.textBoxFlowMarkSymbolPath.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(this.textBoxETC_ButtonClick);
-...
                 this.layoutControlItem4,
                 this.emptySpaceItem1});
                 this.Root.Name = "Root";
                 this.Root.Size = new System.Drawing.Size(1094, 738);
                 this.Root.Size = new System.Drawing.Size(1135, 792);
                 this.Root.TextVisible = false;
                 //
                 // layoutControlGroup2
-...
                 this.layoutControlGroup5,
                 this.splitterItem5,
                 this.layoutControlItem15,
                 this.layoutControlItem25});
                 this.layoutControlGroup2.Location = new System.Drawing.Point(777, 0);
                 this.layoutControlItem25,
                 this.layoutControlItem26,
                 this.layoutControlItem27});
                 this.layoutControlGroup2.Location = new System.Drawing.Point(801, 0);
                 this.layoutControlGroup2.Name = "layoutControlGroup2";
                 this.layoutControlGroup2.Size = new System.Drawing.Size(297, 678);
                 this.layoutControlGroup2.Size = new System.Drawing.Size(314, 732);
                 this.layoutControlGroup2.Text = "SPPID Symbol";
                 //
                 // layoutControlItem8
-...
                 this.layoutControlItem8.Control = this.treeListSPPIDTreeList;
                 this.layoutControlItem8.Location = new System.Drawing.Point(0, 0);
                 this.layoutControlItem8.Name = "layoutControlItem8";
                 this.layoutControlItem8.Size = new System.Drawing.Size(273, 282);
                 this.layoutControlItem8.Size = new System.Drawing.Size(290, 249);
                 this.layoutControlItem8.TextSize = new System.Drawing.Size(0, 0);
                 this.layoutControlItem8.TextVisible = false;
                 //
-...
                 //
                 this.layoutControlGroup5.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
                 this.layoutControlItem9});
                 this.layoutControlGroup5.Location = new System.Drawing.Point(0, 292);
                 this.layoutControlGroup5.Location = new System.Drawing.Point(0, 254);
                 this.layoutControlGroup5.Name = "layoutControlGroup5";
                 this.layoutControlGroup5.Size = new System.Drawing.Size(273, 261);
                 this.layoutControlGroup5.Size = new System.Drawing.Size(290, 267);
                 this.layoutControlGroup5.Text = "SPPID Image";
                 //
                 // layoutControlItem9
-...
                 this.layoutControlItem9.Control = this.pictureEditSPPIDSymbol;
                 this.layoutControlItem9.Location = new System.Drawing.Point(0, 0);
                 this.layoutControlItem9.Name = "layoutControlItem9";
                 this.layoutControlItem9.Size = new System.Drawing.Size(249, 216);
                 this.layoutControlItem9.Size = new System.Drawing.Size(266, 224);
                 this.layoutControlItem9.TextSize = new System.Drawing.Size(0, 0);
                 this.layoutControlItem9.TextVisible = false;
                 //
                 // splitterItem5
                 //
                 this.splitterItem5.AllowHotTrack = true;
                 this.splitterItem5.Location = new System.Drawing.Point(0, 282);
                 this.splitterItem5.Location = new System.Drawing.Point(0, 249);
                 this.splitterItem5.Name = "splitterItem5";
                 this.splitterItem5.Size = new System.Drawing.Size(273, 10);
                 this.splitterItem5.Size = new System.Drawing.Size(290, 5);
                 //
                 // layoutControlItem15
                 //
                 this.layoutControlItem15.Control = this.btnImageRefresh;
                 this.layoutControlItem15.Location = new System.Drawing.Point(0, 553);
                 this.layoutControlItem15.Location = new System.Drawing.Point(0, 521);
                 this.layoutControlItem15.Name = "layoutControlItem15";
                 this.layoutControlItem15.Size = new System.Drawing.Size(273, 40);
                 this.layoutControlItem15.Size = new System.Drawing.Size(290, 42);
                 this.layoutControlItem15.TextSize = new System.Drawing.Size(0, 0);
                 this.layoutControlItem15.TextVisible = false;
                 //
                 // layoutControlItem25
                 //
                 this.layoutControlItem25.Control = this.btnExportExcel;
                 this.layoutControlItem25.Location = new System.Drawing.Point(0, 593);
                 this.layoutControlItem25.Location = new System.Drawing.Point(0, 563);
                 this.layoutControlItem25.Name = "layoutControlItem25";
                 this.layoutControlItem25.Size = new System.Drawing.Size(273, 40);
                 this.layoutControlItem25.Size = new System.Drawing.Size(290, 42);
                 this.layoutControlItem25.TextSize = new System.Drawing.Size(0, 0);
                 this.layoutControlItem25.TextVisible = false;
                 //
                 // emptySpaceItem2
                 //
                 this.emptySpaceItem2.AllowHotTrack = false;
                 this.emptySpaceItem2.Location = new System.Drawing.Point(0, 678);
                 this.emptySpaceItem2.Location = new System.Drawing.Point(0, 732);
                 this.emptySpaceItem2.Name = "emptySpaceItem2";
                 this.emptySpaceItem2.Size = new System.Drawing.Size(881, 40);
                 this.emptySpaceItem2.Size = new System.Drawing.Size(922, 40);
                 this.emptySpaceItem2.TextSize = new System.Drawing.Size(0, 0);
                 //
                 // splitterItem3
                 //
                 this.splitterItem3.AllowHotTrack = true;
                 this.splitterItem3.Location = new System.Drawing.Point(767, 0);
                 this.splitterItem3.Location = new System.Drawing.Point(796, 0);
                 this.splitterItem3.Name = "splitterItem3";
                 this.splitterItem3.Size = new System.Drawing.Size(10, 678);
                 this.splitterItem3.Size = new System.Drawing.Size(5, 732);
                 //
                 // tabbedControlGroup
                 //
                 this.tabbedControlGroup.Location = new System.Drawing.Point(0, 0);
                 this.tabbedControlGroup.Name = "tabbedControlGroup";
                 this.tabbedControlGroup.SelectedTabPage = this.GroupSymbol;
                 this.tabbedControlGroup.Size = new System.Drawing.Size(767, 678);
                 this.tabbedControlGroup.Size = new System.Drawing.Size(796, 732);
                 this.tabbedControlGroup.TabPages.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
                 this.GroupSymbol,
                 this.GroupLine,
-...
                 this.layoutControlGroup1});
                 this.GroupSymbol.Location = new System.Drawing.Point(0, 0);
                 this.GroupSymbol.Name = "GroupSymbol";
                 this.GroupSymbol.Size = new System.Drawing.Size(743, 632);
                 this.GroupSymbol.Size = new System.Drawing.Size(772, 685);
                 this.GroupSymbol.Text = "Symbol";
                 //
                 // splitterItem1
                 //
                 this.splitterItem1.AllowHotTrack = true;
                 this.splitterItem1.Location = new System.Drawing.Point(0, 302);
                 this.splitterItem1.Location = new System.Drawing.Point(0, 327);
                 this.splitterItem1.Name = "splitterItem1";
                 this.splitterItem1.Size = new System.Drawing.Size(743, 10);
                 this.splitterItem1.Size = new System.Drawing.Size(772, 5);
                 //
                 // layoutControlGroup3
                 //
                 this.layoutControlGroup3.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
                 this.layoutControlItem1});
                 this.layoutControlGroup3.Location = new System.Drawing.Point(0, 312);
                 this.layoutControlGroup3.Location = new System.Drawing.Point(0, 332);
                 this.layoutControlGroup3.Name = "layoutControlGroup3";
                 this.layoutControlGroup3.Size = new System.Drawing.Size(392, 320);
                 this.layoutControlGroup3.Size = new System.Drawing.Size(407, 353);
                 this.layoutControlGroup3.Text = "ID2 Image";
                 //
                 // layoutControlItem1
-...
                 this.layoutControlItem1.Control = this.pictureEditID2Symbol;
                 this.layoutControlItem1.Location = new System.Drawing.Point(0, 0);
                 this.layoutControlItem1.Name = "layoutControlItem1";
                 this.layoutControlItem1.Size = new System.Drawing.Size(368, 275);
                 this.layoutControlItem1.Size = new System.Drawing.Size(383, 310);
                 this.layoutControlItem1.TextSize = new System.Drawing.Size(0, 0);
                 this.layoutControlItem1.TextVisible = false;
                 //
-...
                 //
                 this.layoutControlGroup4.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {
                 this.layoutControlItem2});
                 this.layoutControlGroup4.Location = new System.Drawing.Point(402, 312);
                 this.layoutControlGroup4.Location = new System.Drawing.Point(412, 332);
                 this.layoutControlGroup4.Name = "layoutControlGroup4";
                 this.layoutControlGroup4.Size = new System.Drawing.Size(341, 320);
                 this.layoutControlGroup4.Size = new System.Drawing.Size(360, 353);
                 this.layoutControlGroup4.Text = "Mapped Image";
                 //
                 // layoutControlItem2
-...
                 this.layoutControlItem2.Control = this.pictureEditMapped;
                 this.layoutControlItem2.Location = new System.Drawing.Point(0, 0);
                 this.layoutControlItem2.Name = "layoutControlItem2";
                 this.layoutControlItem2.Size = new System.Drawing.Size(317, 275);
                 this.layoutControlItem2.Size = new System.Drawing.Size(336, 310);
                 this.layoutControlItem2.TextSize = new System.Drawing.Size(0, 0);
                 this.layoutControlItem2.TextVisible = false;
                 //
                 // splitterItem4
                 //
                 this.splitterItem4.AllowHotTrack = true;
                 this.splitterItem4.Location = new System.Drawing.Point(392, 312);
                 this.splitterItem4.Location = new System.Drawing.Point(407, 332);
                 this.splitterItem4.Name = "splitterItem4";
                 this.splitterItem4.Size = new System.Drawing.Size(10, 320);
                 this.splitterItem4.Size = new System.Drawing.Size(5, 353);
                 //
                 // layoutControlGroup1
                 //
-...
                 this.layoutControlItem6});
                 this.layoutControlGroup1.Location = new System.Drawing.Point(0, 0);
                 this.layoutControlGroup1.Name = "layoutControlGroup1";
                 this.layoutControlGroup1.Size = new System.Drawing.Size(743, 302);
                 this.layoutControlGroup1.Size = new System.Drawing.Size(772, 327);
                 this.layoutControlGroup1.Text = "ID2 Symbol List";
                 //
                 // layoutControlItem6
-...
                 this.layoutControlItem6.Control = this.gridControlSymbol;
                 this.layoutControlItem6.Location = new System.Drawing.Point(0, 0);
                 this.layoutControlItem6.Name = "layoutControlItem6";
                 this.layoutControlItem6.Size = new System.Drawing.Size(719, 257);
                 this.layoutControlItem6.Size = new System.Drawing.Size(748, 284);
                 this.layoutControlItem6.TextSize = new System.Drawing.Size(0, 0);
                 this.layoutControlItem6.TextVisible = false;
                 //
-...
                 this.layoutControlGroup6});
                 this.GroupLine.Location = new System.Drawing.Point(0, 0);
                 this.GroupLine.Name = "GroupLine";
                 this.GroupLine.Size = new System.Drawing.Size(743, 632);
                 this.GroupLine.Size = new System.Drawing.Size(772, 685);
                 this.GroupLine.Text = "Line";
                 //
                 // layoutControlGroup6
-...
                 this.layoutControlItem10});
                 this.layoutControlGroup6.Location = new System.Drawing.Point(0, 0);
                 this.layoutControlGroup6.Name = "layoutControlGroup6";
                 this.layoutControlGroup6.Size = new System.Drawing.Size(743, 632);
                 this.layoutControlGroup6.Size = new System.Drawing.Size(772, 685);
                 this.layoutControlGroup6.Text = "ID2 Line List";
                 //
                 // layoutControlItem10
-...
                 this.layoutControlItem10.Control = this.gridControlLine;
                 this.layoutControlItem10.Location = new System.Drawing.Point(0, 0);
                 this.layoutControlItem10.Name = "layoutControlItem10";
                 this.layoutControlItem10.Size = new System.Drawing.Size(719, 587);
                 this.layoutControlItem10.Size = new System.Drawing.Size(748, 642);
                 this.layoutControlItem10.TextSize = new System.Drawing.Size(0, 0);
                 this.layoutControlItem10.TextVisible = false;
                 //
-...
                 this.layoutControlGroup8});
                 this.GroupLineNumber.Location = new System.Drawing.Point(0, 0);
                 this.GroupLineNumber.Name = "GroupLineNumber";
                 this.GroupLineNumber.Size = new System.Drawing.Size(743, 632);
                 this.GroupLineNumber.Size = new System.Drawing.Size(772, 685);
                 this.GroupLineNumber.Text = "Line Number";
                 //
                 // layoutControlGroup8
-...
                 this.layoutControlItem18});
                 this.layoutControlGroup8.Location = new System.Drawing.Point(0, 0);
                 this.layoutControlGroup8.Name = "layoutControlGroup8";
                 this.layoutControlGroup8.Size = new System.Drawing.Size(743, 632);
                 this.layoutControlGroup8.Size = new System.Drawing.Size(772, 685);
                 this.layoutControlGroup8.Text = "ID2 Line Number";
                 //
                 // layoutControlItem13
-...
                 this.layoutControlItem13.Control = this.gridControlLineNumber;
                 this.layoutControlItem13.Location = new System.Drawing.Point(0, 24);
                 this.layoutControlItem13.Name = "layoutControlItem13";
                 this.layoutControlItem13.Size = new System.Drawing.Size(719, 563);
                 this.layoutControlItem13.Size = new System.Drawing.Size(748, 618);
                 this.layoutControlItem13.TextSize = new System.Drawing.Size(0, 0);
                 this.layoutControlItem13.TextVisible = false;
                 //
-...
                 this.layoutControlItem3.Control = this.textBoxLineNumberPath;
                 this.layoutControlItem3.Location = new System.Drawing.Point(0, 0);
                 this.layoutControlItem3.Name = "layoutControlItem3";
                 this.layoutControlItem3.Size = new System.Drawing.Size(410, 24);
                 this.layoutControlItem3.Size = new System.Drawing.Size(427, 24);
                 this.layoutControlItem3.Text = "SPPID Line Number Label Path";
                 this.layoutControlItem3.TextAlignMode = DevExpress.XtraLayout.TextAlignModeItem.AutoSize;
                 this.layoutControlItem3.TextSize = new System.Drawing.Size(167, 14);

... 이 차이점은 표시할 수 있는 최대 줄수를 초과해서 이 차이점은 잘렸습니다.

내보내기 Unified diff

프로젝트

일반

사용자정보

HYTOS

개정판 2425d530