private void buttonTextKeyCheck_Click(object sender, EventArgs e)
{
var tableName = this.comboBoxTable.Text;
this.checkBoxTextKeyStatus.Checked = TableUtil.ColumnExistInTable(tableName, "TextKey");
this.buttonTextKeyCreate.Enabled = !this.checkBoxTextKeyStatus.Checked;
this.buttonStartSP.Enabled = this.checkBoxTextKeyStatus.Checked;
this.buttonDetailReportCheck.Enabled = this.checkBoxTextKeyStatus.Checked;
this.buttonDraftReportCheck.Enabled = this.checkBoxTextKeyStatus.Checked;
this.buttonErrorStatCheck.Enabled = this.checkBoxTextKeyStatus.Checked;
this.textBoxRowCount.Text = TableUtil.RowCountForPrepare.ToString();
this.textBoxPreparedRowCount.Text = TableUtil.RowCountPrepared.ToString();
}
private void buttonMinuteAndSecondCheck_Click(object sender, EventArgs e)
{
var columnsExist = TableUtil.ColumnExistInTable(TableUtil.TableName, "Second01");
columnsExist = columnsExist && TableUtil.ColumnExistInTable(TableUtil.TableName, "Second05");
columnsExist = columnsExist && TableUtil.ColumnExistInTable(TableUtil.TableName, "Second10");
columnsExist = columnsExist && TableUtil.ColumnExistInTable(TableUtil.TableName, "Munute01");
columnsExist = columnsExist && TableUtil.ColumnExistInTable(TableUtil.TableName, "Munute02");
columnsExist = columnsExist && TableUtil.ColumnExistInTable(TableUtil.TableName, "Munute03");
columnsExist = columnsExist && TableUtil.ColumnExistInTable(TableUtil.TableName, "Munute04");
columnsExist = columnsExist && TableUtil.ColumnExistInTable(TableUtil.TableName, "Munute05");
this.checkBoxMinuteAndSecondStatus.Checked = columnsExist;
this.buttonMinuteAndSecondCreate.Enabled = !columnsExist;
}
