public void CreatPassiveSPScript(XCollection <SQLOutboundChanel> channelSet) { string interfaceName = Program.DeviceMgt.DeviceDirInfor.Header.Name; string fnameInstall = Application.StartupPath + "\\" + RuleScript.InstallSP.FileName; string fnameUninstall = Application.StartupPath + "\\" + RuleScript.UninstallSP.FileName; //Install //using (StreamWriter sw = File.CreateText(fnameInstall)) // 20110706 OSQL & SQLMgmtStudio only support ASCII and UNICODE { StringBuilder sb = new StringBuilder(); sb.AppendLine(GWDataDB.GetUseDataBaseSql()); foreach (SQLOutboundChanel channel in channelSet) { sb.AppendLine(channel.SPStatement); } //sw.Write(sb.ToString()); File.WriteAllText(fnameInstall, sb.ToString(), Encoding.Unicode); } //UnInstall using (StreamWriter sw = File.CreateText(fnameUninstall)) { StringBuilder sb = new StringBuilder(); sb.AppendLine(GWDataDB.GetUseDataBaseSql()); foreach (SQLOutboundChanel channel in channelSet) { string strSql = RuleControl.GetOutboundSPUninstall(interfaceName, channel.Rule); sb.AppendLine(strSql); } sw.Write(sb.ToString()); } }
private void CreateSPScript() { string dbName = this.textBoxRISDBName.Text.Trim(); string interfaceName = this.textBoxTP.Text.Trim(); string fnameInstall = Application.StartupPath + "\\" + RuleScript.InstallSP.FileName; string fnameUninstall = Application.StartupPath + "\\" + RuleScript.UninstallSP.FileName; using (StreamWriter sw = File.CreateText(fnameInstall)) { StringBuilder sb = new StringBuilder(); foreach (SQLOutboundChanel chn in SQLOutAdapterConfigMgt.SQLOutAdapterConfig.OutboundChanels) { InsertDataId(chn); string strSql = RuleControl.GetOutboundSP(interfaceName, chn.Rule); strSql = strSql.Replace("USE GWDataDB", ""); sb.AppendLine(strSql); } sw.Write("USE " + dbName + "\r\n" + sb.ToString()); } using (StreamWriter sw = File.CreateText(fnameUninstall)) { StringBuilder sb = new StringBuilder(); foreach (SQLOutboundChanel chn in SQLOutAdapterConfigMgt.SQLOutAdapterConfig.OutboundChanels) { string strSql = RuleControl.GetOutboundSPUninstall(interfaceName, chn.Rule); strSql = strSql.Replace("USE GWDataDB", ""); sb.AppendLine(strSql); } sw.Write("USE " + dbName + "\r\n" + sb.ToString()); } }
private void CreateOutboundSPScript(IOutboundRule[] ruleList) { string interfaceName = Program.DeviceMgt.DeviceDirInfor.Header.Name; string fnameInstall = Application.StartupPath + "\\" + RuleScript.InstallSP.FileName; string fnameUninstall = Application.StartupPath + "\\" + RuleScript.UninstallSP.FileName; //using (StreamWriter sw = File.CreateText(fnameInstall)) // 20110706 OSQL & SQLMgmtStudio only support ASCII and UNICODE { StringBuilder sb = new StringBuilder(); sb.AppendLine(GWDataDB.GetUseDataBaseSql()); foreach (IOutboundRule rule in ruleList) { string strSql = RuleControl.GetOutboundSP(interfaceName, rule); sb.AppendLine(strSql); IRuleSupplier supplier = rule as IRuleSupplier; if (supplier != null) { string strSqlSupplied = supplier.GetInstallDBScript(); if (strSqlSupplied != null) { sb.AppendLine(strSqlSupplied); } } } //sw.Write(sb.ToString()); File.WriteAllText(fnameInstall, sb.ToString(), Encoding.Unicode); } using (StreamWriter sw = File.CreateText(fnameUninstall)) { StringBuilder sb = new StringBuilder(); sb.AppendLine(GWDataDB.GetUseDataBaseSql()); foreach (IOutboundRule rule in ruleList) { string strSql = RuleControl.GetOutboundSPUninstall(interfaceName, rule); sb.AppendLine(strSql); IRuleSupplier supplier = rule as IRuleSupplier; if (supplier != null) { string strSqlSupplied = supplier.GetUninstallDBScript(); if (strSqlSupplied != null) { sb.AppendLine(strSqlSupplied); } } } sw.Write(sb.ToString()); } }