/// <summary> /// 初始化数据 /// </summary> public void Init() { string connectString = "Server = 10.20.86.11; DataBase = s3design_rtm; Uid = s3design; Password = davidbowie;"; // 默认连接字符串 string filename = Path.Combine(Application.StartupPath, "GameDesingerTools_Public.ini"); FileInfo fi = new FileInfo(filename); if (fi.Exists) { string content = FileFolderHelper.FileToString(filename); IniStructure m_inis = new IniStructure(); m_inis = IniStructure.ReadIniWithContent(content); connectString = m_inis.GetValue("General", "ConnString"); } else { filename = Path.Combine(Application.StartupPath, "GameDesingerTools_Public.ini"); fi = new FileInfo(filename); if (fi.Exists) // 读取AutoExport.ini文件 { string content = FileFolderHelper.FileToString(filename); SymmetricMethod sm = new SymmetricMethod(); content = sm.Decrypto(content); IniStructure m_inis = new IniStructure(); m_inis = IniStructure.ReadIniWithContent(content); connectString = m_inis.GetValue("General", "ConnString"); } } conn = new SqlConnection(connectString); try { if (conn.State == ConnectionState.Closed) { conn.Open(); } string sqlString = "SELECT * FROM AI_Enum_Define"; enumTable = GetDataTable(sqlString); sqlString = "SELECT * FROM AI_TemplateParamTable"; parameterTable = GetDataTable(sqlString); sqlString = "SELECT ID, FullPath FROM changan.s3diagram_rtm.dbo.diagram WHERE Class = 'AI图'"; diagramTable = GetDataTable(sqlString); } catch (SqlException ex) { MessageBox.Show("在读取数据表信息时产生sql异常:" + ex.ToString()); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } }
/// <summary> /// 初始化数据 /// </summary> public void Init() { string connectString = "Server = 10.20.86.11; DataBase = s3design_rtm; Uid = s3design; Password = davidbowie;"; // 默认连接字符串 string filename = Path.Combine(Application.StartupPath, "GameDesingerTools_Public.ini"); FileInfo fi = new FileInfo(filename); if (fi.Exists) { string content = FileFolderHelper.FileToString(filename); IniStructure m_inis = new IniStructure(); m_inis = IniStructure.ReadIniWithContent(content); connectString = m_inis.GetValue("General", "ConnString"); } else { filename = Path.Combine(Application.StartupPath, "GameDesingerTools_Public.ini"); fi = new FileInfo(filename); if (fi.Exists) // 读取AutoExport.ini文件 { string content = FileFolderHelper.FileToString(filename); SymmetricMethod sm = new SymmetricMethod(); content = sm.Decrypto(content); IniStructure m_inis = new IniStructure(); m_inis = IniStructure.ReadIniWithContent(content); connectString = m_inis.GetValue("General", "ConnString"); } } conn = new SqlConnection(connectString); try { if(conn.State == ConnectionState.Closed) { conn.Open(); } string sqlString = "SELECT * FROM AI_Enum_Define"; enumTable = GetDataTable(sqlString); sqlString = "SELECT * FROM AI_TemplateParamTable"; parameterTable = GetDataTable(sqlString); sqlString = "SELECT ID, FullPath FROM changan.s3diagram_rtm.dbo.diagram WHERE Class = 'AI图'"; diagramTable = GetDataTable(sqlString); } catch (SqlException ex) { MessageBox.Show("在读取数据表信息时产生sql异常:" + ex.ToString()); } finally { if(conn.State == ConnectionState.Open) { conn.Close(); } } }