/// <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 Boolean SaveConnectionInfo()
{
//保存本地数据源配置信息
string text1 = Yqun.Common.Encoder.EncryptSerivce.Encrypt(DataSourceTxt.Text);
string text2 = Yqun.Common.Encoder.EncryptSerivce.Encrypt(DataBaseTxt.Text);
string text3 = Yqun.Common.Encoder.EncryptSerivce.Encrypt(UserTxt.Text);
string text4 = Yqun.Common.Encoder.EncryptSerivce.Encrypt(PasswordTxt.Text);
string text5 = DataISAttach.Checked.ToString();
string text6 = DataIntegratedLogin.Checked.ToString();
int num1 = DataSetCoder.SetProperty(ref infoSet, 0, "name", "DataSource", "value", text1);
int num2 = DataSetCoder.SetProperty(ref infoSet, 0, "name", "DataInstance", "value", text2);
int num3 = DataSetCoder.SetProperty(ref infoSet, 0, "name", "DataUserName", "value", text3);
int num4 = DataSetCoder.SetProperty(ref infoSet, 0, "name", "DataPassword", "value", text4);
int num5 = DataSetCoder.SetProperty(ref infoSet, 0, "name", "DataAdapterType", "value", "SQLClient");
int num6 = DataSetCoder.SetProperty(ref infoSet, 0, "name", "DataBaseType", "value", "MSSQLServer2k5");
int num8 = DataSetCoder.SetProperty(ref infoSet, 0, "name", "DataIntegratedLogin", "value", text6);
int num9 = DataSetCoder.SetProperty(ref infoSet, 0, "name", "DataISAttach", "value", text5);
Boolean r = (num1 == 1 && num2 == 1 && num3 == 1 && num4 == 1 && num5 == 1 && num6 == 1 && num8 == 1 && num9 == 1);
if (r)
{
infoSet.WriteXml(FileName, XmlWriteMode.IgnoreSchema);
}
return(r);
}
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);
}
