protected void Button1_Click(object sender, EventArgs e)
{
ModelFieldModel m = new ModelFieldModel();
m.FieldName = "GL_" + txtFieldName.Text.Trim();//自定义字段加前缀，区别于系统字段
m.FieldName2 = txtFieldName2.Text.Trim();
m.FieldType = int.Parse(txtFieldType.SelectedValue);
m.FieldIsNull = txtFieldIsNully.Checked ? 0 : 1;
m.FieldOnOff = txtFieldOnOffy.Checked ? 0 : 1;
m.FieldPx = int.Parse(txtFieldPx.Text);
m.FieldIntro = txtFieldIntro.Text;
m.Modeid = mid;
m.FieldVaules = txtvalue.Text;
m.id = id;
if (id == 0)
{
//取得该模型数据表名称
ModelModel mo = new ModelBll().GetModel(mid);
bool bo = DbHelperSQL.ColumnExists(mo.ModelTable, txtFieldName.Text);
if (bo)
{
BasePage.Alertback(Page, "字段名称已经存在于数据中");
return;
}
else
{
//在数据库中添加字段
string fieldtype;
if (txtFieldType.Text == "1")
{
fieldtype = " int";
}
else
{
fieldtype = " nvarchar(50)";
}
string column = "GL_" + txtFieldName.Text.Trim() + fieldtype;
string sqlContent = "alter table " + mo.ModelTable + " add " + column + "";
object obj = DbHelperSQL.GetSingle(sqlContent.ToString());
int i = new ModelFieldBll().Add(m);
if (i > 0)
{
BasePage.JscriptPrint(Page, "添加成功！", "ModelField.aspx?mid=" + mid);
}
}
}
else
{
bool b = new ModelFieldBll().Update(m);
if (b)
{
BasePage.JscriptPrint(Page, "修改成功！", "ModelField.aspx?mid=" + mid);
}
}
}
