private void btnAccept_Click(object sender, EventArgs e)
{
if (!NameTool.ValidFieldName(txbFieldName.Text.Trim().ToLower()))
{
MessageForm msgForm = new MessageForm("非法的字段名!", "错误", MessageBoxIcon.Error, true, false);
msgForm.StartPosition = FormStartPosition.CenterParent;
msgForm.ShowDialog();
return;
}
this.FieldName = this.txbFieldName.Text.Trim().ToLower();
this.FieldType = this.cmbFieldType.Text.Trim().ToLower();
this.DialogResult = DialogResult.OK;
this.Close();
}
private void btnCreateTable_Click(object sender, EventArgs e)
{
string tabName = txbTabName.Text.Trim().ToLower();
if (!NameTool.ValidTableName(tabName))
{
MsgBox.ShowError("非法的表名!");
return;
}
StringBuilder sbSql = new StringBuilder();
sbSql.Append(" CREATE TABLE ");
sbSql.Append(tabName);
sbSql.Append("(");
for (int i = 0; i < DGVFields.Rows.Count; i++)
{
if (i == DGVFields.Rows.Count - 1 && DGVFields.Rows[i].Cells[0].Value == null && DGVFields.Rows[i].Cells[1].Value == null)
{
break;
}
if (DGVFields.Rows[i].Cells[0].Value == null)
{
MsgBox.ShowError("字段名为空");
return;
}
if (DGVFields.Rows[i].Cells[1].Value == null)
{
MsgBox.ShowError("字段类型为空");
return;
}
sbSql.AppendFormat(" {0} {1},", DGVFields.Rows[i].Cells[0].Value, DGVFields.Rows[i].Cells[1].Value);
}
//去掉最后的逗号
sbSql.Remove((sbSql.Length - 1), 1);
sbSql.Append(")");
CreateTable(sbSql.ToString());
}
