/// <summary>
/// 初始化dbtune管理工作流程
/// </summary>
private void InitDbtuneDbtuneManageWorkFlow()
{
if (this._workFlow == EnumWorkFlow.TablePartition.ToString())
{
InitDbConnect();
this.txbDbPort.Text = "5151";
CommonUtil.WriteBlog(this.txbBlog, "--- SDE服务当前未连接");
this.cmbDbtuneKeyWord.SelectedIndex = -1;
this.txbDbtuneParamValue.Text = string.Empty;
this.cmbDbtuneKeyWord.Properties.Items.Clear();
}
this.lciConnTips_2.Visibility = LayoutVisibility.Always;
this.cmbDbtuneKeyWord.Enabled = false;
this._dbtuneConfigHelper = null;
this._dbtuneConfigParam = null;
this._featureClass = null;
this.btnImportFeature.Text = string.Empty;
this.lciConnTips_1.Visibility = LayoutVisibility.Never;
this._tbPtitionHelper = null;
this._partitionParam = null;
this.cmbTablespace.SelectedIndex = -1;
this.cmbOriginTable.SelectedIndex = -1;
this.cmbTablespace.Properties.Items.Clear();
this.cmbOriginTable.Properties.Items.Clear();
this._workFlow = EnumWorkFlow.DbtuneManage.ToString();
}
/// <summary>
/// 检查Dbtune配置流程涉及参数
/// </summary>
/// <returns></returns>
internal static bool CheckDbtuneConfigParam(MemoEdit txbBlog, DbtuneConfigParam dbtuneConfigParam)
{
if (dbtuneConfigParam.DBHelper == null)
{
WriteBlog(txbBlog, "--- 数据库连接异常, 请查看错误日志");
return(false);
}
else if (dbtuneConfigParam.FeatureClass == null)
{
WriteBlog(txbBlog, "--- 未指定要素类");
return(false);
}
else if (RegexCheck.IsEmpty(dbtuneConfigParam.BasicField))
{
WriteBlog(txbBlog, "--- 未指定分区列");
return(false);
}
else if (dbtuneConfigParam.PartitionWay == EnumPartitionWay.Unknow)
{
WriteBlog(txbBlog, "--- 未指定分区方式");
return(false);
}
else if (!RegexCheck.IsFull(dbtuneConfigParam.TablespaceSet))
{
WriteBlog(txbBlog, "--- 存在没有指定表空间的分区");
return(false);
}
else if (DbtuneXMLOperate.CheckKeyWordExist(dbtuneConfigParam.DbtuneKeyWord))
{
WriteBlog(txbBlog, "--- 关键字为 " + dbtuneConfigParam.DbtuneKeyWord + "的配置项已经存在，请更改关键字");
return(false);
}
else
{
if (dbtuneConfigParam.PartitionWay == EnumPartitionWay.Range)
{
if (dbtuneConfigParam.PartitionCount == -1)
{
WriteBlog(txbBlog, "--- 未指定范围分区数");
return(false);
}
else
{
return(true);
}
}
else
{
return(true);
}
}
}
/// <summary>
/// 执行dbtune配置工作
/// </summary>
/// <param name="txbBlog"></param>
/// <param name="dbtuneConfigParam"></param>
/// <param name="dbtuneConfigHelper"></param>
internal static void ExcuteDbtuneConfig(MemoEdit txbBlog, DbtuneConfigParam dbtuneConfigParam, DbtuneConfigHelper.DbtuneConfigHelper dbtuneConfigHelper)
{
dbtuneConfigHelper = new DbtuneConfigHelper.DbtuneConfigHelper(dbtuneConfigParam, Environment.CurrentDirectory);
if (dbtuneConfigHelper.AlterParamValueEX())
{
WriteBlog(txbBlog, "--- 执行成功");
}
else
{
WriteBlog(txbBlog, "--- 执行失败，请检查参数");
}
}
/// <summary>
/// 初始化dbtune配置工作流程
/// </summary>
private void InitDbtuneConfigWorkFlow()
{
if (this._workFlow == EnumWorkFlow.TablePartition.ToString())
{
InitDbConnect();
this.txbDbPort.Text = "5151";
CommonUtil.WriteBlog(this.txbBlog, "--- SDE服务当前未连接");
this.btnImportFeature.Text = string.Empty;
this.cmbColumnIdentity.SelectedIndex = -1;
this.cmbPartitionWay.SelectedIndex = -1;
this.txbTips.Text = string.Empty;
this.btnAssignTablespace.Text = string.Empty;
this.txbTargetName.Text = string.Empty;
this.cmbColumnIdentity.Properties.Items.Clear();
}
this.lciConnTips_1.Visibility = LayoutVisibility.Always;
this._dbtuneConfigParam = new DbtuneConfigParam();
this._dbtuneConfigParam.Clear();
this._featureClass = null;
this._partitionCount = -1;
this._columnInfoSet = new Dictionary <string, string>();
this._boundary = new Dictionary <string, double>();
this._partitionInfoSet = new List <PartitionInfo>();
this._partitionRefer = new List <string>();
this.btnImportFeature.Enabled = false;
this._tbPtitionHelper = null;
this._partitionParam = null;
this.cmbTablespace.SelectedIndex = -1;
this.cmbOriginTable.SelectedIndex = -1;
this.cmbTablespace.Properties.Items.Clear();
this.cmbOriginTable.Properties.Items.Clear();
this._dbtuneManageHelper = null;
this.cmbDbtuneKeyWord.SelectedIndex = -1;
this.txbDbtuneParamValue.Text = string.Empty;
this.cmbDbtuneKeyWord.Properties.Items.Clear();
this.lciConnTips_2.Visibility = LayoutVisibility.Never;
this._workFlow = EnumWorkFlow.DbtuneConfigure.ToString();
}
