//初始化表结构
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("初始化表结构失败!");
}
}
