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; }