public void DeleteForm(string f_Id)
{
TableFieldEntity entity = GetForm(f_Id);
string sqlTableName = new TableApp().GetForm(entity.TableId).SqlTableName;
DbHelper.ExecuteNonQuery("alter table " + sqlTableName + " drop column " + entity.FieldName);
service.Delete(t => t.F_Id == f_Id);
}
public void SubmitForm(TableFieldEntity entity, string f_Id)
{
string sqlTableName = new TableApp().GetForm(entity.TableId).SqlTableName;
string strSql = "";
if (!string.IsNullOrEmpty(f_Id))
{
entity.Modify(f_Id);
service.Update(entity);
strSql = "alter table " + sqlTableName + " alter column " + entity.FieldName + " " + entity.FieldType;
}
else
{
entity.Create();
service.Insert(entity);
strSql = "alter table " + sqlTableName + " add " + entity.FieldName + " " + entity.FieldType;
}
switch (entity.FieldType)
{
case "varchar":
case "nvarchar":
strSql += "(" + entity.FieldLength + ")";
break;
case "decimal":
strSql += "(" + entity.FieldLength + "," + entity.FieldAccuracy + ")";
break;
case "int":
case "bigint":
case "float":
case "bit":
case "date":
case "datetime":
case "text":
default:
break;
}
DbHelper.ExecuteNonQuery(strSql);
}