//初始化表结构 private void btnTableStruc_Click(object sender, EventArgs e) { if (DialogResult.No == ShowMessageHelper.ShowBoxMsg("是否要初始化当前连接下的表结构?", MessageBoxButtons.YesNo, MessageBoxIcon.Question)) { return; } //验证 if (!CheckInput()) { return; } //保存连接 if (!SaveConfig()) { ShowMessageHelper.ShowBoxMsg("当前连接保存失败,请检查当前输入连接!"); return; } //读取当前版本 double oldVersion; DASoftversionBLL dasoftversionbll = new DASoftversionBLL(); DASoftversion oObj = new DASoftversion(); try { oObj = dasoftversionbll.GetLastSoftVersion(); } catch { } if (oObj != null) { oldVersion = Convert.ToDouble(oObj.Versioncode); } else { oldVersion = 0.0; } if (oldVersion >= 1.0) { ShowMessageHelper.ShowBoxMsg("当前连接下的数据表已经健全!"); return; } DataBaseinfo info = new DataBaseinfo(); if (radOracle.Checked == true) { info.databasetype = "0"; info.dataname = tbxSID.Text.ToString(); info.userid = tbxOracleUserName.Text.ToString(); info.password = tbxOraclePwd.Text.ToString(); info.datasource = tbxOracleService.Text.ToString(); } else { info.databasetype = "1"; info.dataname = tbxDatabase.Text.ToString(); info.userid = tbxSQLUserName.Text.ToString(); info.password = tbxSQLPwd.Text.ToString(); info.datasource = tbxSQLService.Text.ToString(); } if (common.ScriptUpdateByBat(info, 0, 1.0))//只读取1.0的脚本 { ShowMessageHelper.ShowBoxMsg("初始化表结构成功!"); } else { ShowMessageHelper.ShowBoxMsg("初始化表结构失败!"); } }