private void CmdProcess_Exited(object sender, EventArgs e)
{
string myConnString = "user id=" + UpdateInfo.DBusername + ";data source=" + UpdateInfo.DBSID + ";password="******"insert into system_version_info(modulename,modulecode,version,publish_date,update_date,remark) " +
"values('" + name + "','" + code + "','" + ver + "','" + publishdate + "',to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss'),'" + keyword + "')";
try {
if (UpdateInfo.DBType.Equals("sqlserver"))
{
sql = "insert into system_version_info(modulename,modulecode,version,publish_date,update_date,remark) " +
"values('" + name + "','" + code + "','" + ver + "','" + publishdate + "', convert(varchar(20),getdate(),121),'" + keyword + "')";
myConnString = "Initial Catalog=" + UpdateInfo.DBSID + ";Data Source=" + UpdateInfo.DBDataSource + ";User ID=" + UpdateInfo.DBusername + "; Password="******"插点版本信息你数据库里去，又不会怀孕。干嘛呢？" + e1.Message, "提示");
}
MessageBox.Show("SQL语句执行完毕！", "提示");
}
public bool OnNextButton()
{
if (string.IsNullOrEmpty(this.textBox2.Text))
{
MessageBox.Show("请选择备份目录", "提示");
return(false);
}
if (string.IsNullOrEmpty(this.textBox1.Text) || string.IsNullOrEmpty(this.textBox4.Text))
{
MessageBox.Show("Sorry,你必须得连接数据库，否则，最后执行SQL就悲催了。");
return(false);
}
else
{
XmlHelper.Delete("/root/DBConfig", "");
XmlHelper.Insert("/root", "DBConfig", "", "");
XmlHelper.Insert("/root/DBConfig", "username", "", this.textBox1.Text);
XmlHelper.Insert("/root/DBConfig", "password", "", this.textBox3.Text);
XmlHelper.Insert("/root/DBConfig", "SID", "", this.textBox4.Text);
string myConnString = "";
if (this.radioButton1.Checked)
{
XmlHelper.Insert("root/DBConfig", "TYPE", "", "oracle");
myConnString = "user id=" + this.textBox1.Text + ";data source=" + this.textBox4.Text + ";password="******"select 1 from dual");
}
else
{
XmlHelper.Insert("/root/DBConfig", "DataSource", "", this.textBox5.Text);
XmlHelper.Insert("root/DBConfig", "TYPE", "", "sqlserver");
myConnString = "Initial Catalog=" + this.textBox4.Text + ";Data Source=" + this.textBox5.Text + ";User ID=" + this.textBox1.Text + "; Password="******"select 1");
}
}
if (!Checked)
{
DialogResult dr = MessageBox.Show("更新包版本检查不通过，是否继续", "提示", MessageBoxButtons.OKCancel);
if (dr != DialogResult.OK)
{
return(false);
}
}
cf = new CopyFileFrame();
cf.servicespath = this.Parent.Tag as string;
cf.bakToPath = this.textBox2.Text;
cf.Closing += new CancelEventHandler(cf_Closing);
cf.ShowDialog();
return(true);
}
