/// <summary> /// 设置服务端的数据库连接信息 /// </summary> public static void SettingDBConnectionInfo() { DataSet DataSet = new DataSet("DataSourceSet"); String FileName = Path.Combine(SystemFolder.DataSourceFolder, "DataSource.xml"); if (File.Exists(FileName)) { DataSet.ReadXml(FileName); String DataAdapterType = DataSetCoder.GetProperty(DataSet, 0, "name", "DataAdapterType", "value").ToString(); String DataBaseType = DataSetCoder.GetProperty(DataSet, 0, "name", "DataBaseType", "value").ToString(); String DataSource = DataSetCoder.GetProperty(DataSet, 0, "name", "DataSource", "value").ToString(); String DataInstance = DataSetCoder.GetProperty(DataSet, 0, "name", "DataInstance", "value").ToString(); String DataUserName = DataSetCoder.GetProperty(DataSet, 0, "name", "DataUserName", "value").ToString(); String DataPassword = DataSetCoder.GetProperty(DataSet, 0, "name", "DataPassword", "value").ToString(); String DataISAttach = DataSetCoder.GetProperty(DataSet, 0, "name", "DataISAttach", "value").ToString(); String DataIntegratedLogin = DataSetCoder.GetProperty(DataSet, 0, "name", "DataIntegratedLogin", "value").ToString(); ServerLoginInfos.DBConnectionInfo.DataAdapterType = DataAdapterType; ServerLoginInfos.DBConnectionInfo.DataBaseType = DataBaseType; ServerLoginInfos.DBConnectionInfo.DataSource = EncryptSerivce.Dencrypt(DataSource); ServerLoginInfos.DBConnectionInfo.DataInstance = EncryptSerivce.Dencrypt(DataInstance); ServerLoginInfos.DBConnectionInfo.DataUserName = EncryptSerivce.Dencrypt(DataUserName); ServerLoginInfos.DBConnectionInfo.DataPassword = EncryptSerivce.Dencrypt(DataPassword); ServerLoginInfos.DBConnectionInfo.DataISAttach = DataISAttach; ServerLoginInfos.DBConnectionInfo.LocalStartPath = AppDomain.CurrentDomain.BaseDirectory + @"\"; ServerLoginInfos.DBConnectionInfo.DataIntegratedLogin = DataIntegratedLogin; } }
private void DataSourceDialog_Load(object sender, EventArgs e) { #region 数据库初始化 FileName = Path.Combine(SystemFolder.DataSourceFolder, "DataSource.xml"); if (File.Exists(FileName)) { infoSet.ReadXml(FileName); string text1 = DataSetCoder.GetProperty(infoSet, 0, "name", "DataSource", "value").ToString(); string text2 = DataSetCoder.GetProperty(infoSet, 0, "name", "DataInstance", "value").ToString(); string text3 = DataSetCoder.GetProperty(infoSet, 0, "name", "DataUserName", "value").ToString(); string text4 = DataSetCoder.GetProperty(infoSet, 0, "name", "DataPassword", "value").ToString(); string text5 = DataSetCoder.GetProperty(infoSet, 0, "name", "DataIntegratedLogin", "value").ToString(); string text6 = DataSetCoder.GetProperty(infoSet, 0, "name", "DataISAttach", "value").ToString(); DataSourceTxt.Text = Yqun.Common.Encoder.EncryptSerivce.Dencrypt(text1); DataBaseTxt.Text = Yqun.Common.Encoder.EncryptSerivce.Dencrypt(text2); UserTxt.Text = Yqun.Common.Encoder.EncryptSerivce.Dencrypt(text3); PasswordTxt.Text = Yqun.Common.Encoder.EncryptSerivce.Dencrypt(text4); bool _DataISAttach = false; bool.TryParse(text6, out _DataISAttach); bool _DataIntegratedLogin = false; bool.TryParse(text5, out _DataIntegratedLogin); DataISAttach.Checked = _DataISAttach; DataIntegratedLogin.Checked = _DataIntegratedLogin; UserTxt.Enabled = !DataIntegratedLogin.Checked; PasswordTxt.Enabled = !DataIntegratedLogin.Checked; } else { DataTable TableSet = new DataTable("DataSource"); TableSet.Columns.Add("name", typeof(string)); TableSet.Columns.Add("value", typeof(string)); infoSet.Tables.Add(TableSet); FileStream fs = new FileStream(FileName, FileMode.Create); XmlTextWriter xtw = new XmlTextWriter(fs, Encoding.UTF8); xtw.Formatting = Formatting.Indented; xtw.WriteStartDocument(); infoSet.WriteXml(xtw); xtw.WriteEndDocument(); xtw.Close(); } #endregion #region 务端地址初始化 string EndPointAddress = BizCommon.ConfigHelper.GetEndpointAddress("TransferServiceEndPoint").ToString(); string strAddressM = EndPointAddress.Replace("net.tcp://", ""); strAddressM = strAddressM.Substring(0, strAddressM.IndexOf('/')); string strAddressE = EndPointAddress.Replace("net.tcp://", "").Replace(strAddressM, ""); txtServerAddress.Text = strAddressM; #endregion }
private void ButtonExe_Click(object sender, EventArgs e) { String Info = ""; Boolean Result = false; try { DataSet DataSet = new DataSet("DataSourceSet"); String FileName = Path.Combine(SystemFolder.DataSourceFolder, "DataSource.xml"); if (File.Exists(FileName)) { DataSet.ReadXml(FileName); String DataAdapterType = DataSetCoder.GetProperty(DataSet, 0, "name", "DataAdapterType", "value").ToString(); String DataBaseType = DataSetCoder.GetProperty(DataSet, 0, "name", "DataBaseType", "value").ToString(); String DataSource = DataSetCoder.GetProperty(DataSet, 0, "name", "DataSource", "value").ToString(); String DataInstance = DataSetCoder.GetProperty(DataSet, 0, "name", "DataInstance", "value").ToString(); String DataUserName = DataSetCoder.GetProperty(DataSet, 0, "name", "DataUserName", "value").ToString(); String DataPassword = DataSetCoder.GetProperty(DataSet, 0, "name", "DataPassword", "value").ToString(); String DataISAttach = DataSetCoder.GetProperty(DataSet, 0, "name", "DataISAttach", "value").ToString(); String DataIntegratedLogin = DataSetCoder.GetProperty(DataSet, 0, "name", "DataIntegratedLogin", "value").ToString(); ServerLoginInfos.DBConnectionInfo.DataAdapterType = DataAdapterType; ServerLoginInfos.DBConnectionInfo.DataBaseType = DataBaseType; ServerLoginInfos.DBConnectionInfo.DataSource = EncryptSerivce.Dencrypt(DataSource); ServerLoginInfos.DBConnectionInfo.DataInstance = EncryptSerivce.Dencrypt(DataInstance); ServerLoginInfos.DBConnectionInfo.DataUserName = EncryptSerivce.Dencrypt(DataUserName); ServerLoginInfos.DBConnectionInfo.DataPassword = EncryptSerivce.Dencrypt(DataPassword); ServerLoginInfos.DBConnectionInfo.DataISAttach = DataISAttach; ServerLoginInfos.DBConnectionInfo.LocalStartPath = AppDomain.CurrentDomain.BaseDirectory + @"\"; ServerLoginInfos.DBConnectionInfo.DataIntegratedLogin = DataIntegratedLogin; String DataBaseName = ServerLoginInfos.DBConnectionInfo.DataInstance; int index = DataBaseName.ToLower().IndexOf("[apppath]"); if (index != -1) { DataBaseName = DataBaseName.ToLower().Replace("[apppath]", Application.StartupPath); } StringBuilder sql_select = new StringBuilder(); sql_select.Append("dump transaction ["); sql_select.Append(DataBaseName); sql_select.Append("] with no_log;backup log ["); sql_select.Append(DataBaseName); sql_select.Append("] with no_log;dbcc shrinkdatabase(["); sql_select.Append(DataBaseName); sql_select.Append("])"); object o = Agent.CallLocalService("Yqun.BO.BOBase.dll", "ExcuteCommand", new object[] { sql_select.ToString() }); Result = (System.Convert.ToInt32(o) == 1); Info = (Result ? "压缩数据库成功。" : "压缩数据库失败!"); } else { Info = "数据库连接信息未找到,请核实与铁路试验信息管理系统放在同一目录下!"; } } catch (Exception ex) { logger.Error("ShrinkDatabaseApp:" + ex.Message); Info = "压缩数据库失败!"; } this.label1.Text = Info; this.label1.ForeColor = (Result ? Color.Black : Color.Red); this.label1.Font = (Result ? defaultFont : boldFont); }