public void DeleteForm(string id) { TableFieldEntity entity = GetForm(id); string tableName = new TableApp().GetForm(entity.TableId).TableName; DbHelper.ExecuteNonQuery("alter table " + tableName + " drop column " + entity.FieldName); service.Delete(t => t.Id == id); }
public void SubmitForm(TableFieldEntity entity, string id) { string tableName = new TableApp().GetForm(entity.TableId).TableName; string strSql = ""; if (!string.IsNullOrEmpty(id)) { entity.Modify(id); service.Update(entity); strSql = "alter table " + tableName + " alter column " + entity.FieldName + " " + entity.FieldType; } else { entity.Create(); service.Insert(entity); strSql = "alter table " + tableName + " add " + entity.FieldName + " " + entity.FieldType; } switch (entity.FieldType) { case "binary": case "char": case "nchar": case "varchar": case "nvarchar": case "datetime2": case "datetimeoffset": strSql += "(" + entity.FieldLength + ")"; break; case "numeric": case "decimal": strSql += "(" + entity.FieldLength + "," + entity.FieldAccuracy + ")"; break; case "image": case "bit": case "text": case "int": case "bigint": case "float": case "money": case "date": case "datetime": default: break; } DbHelper.ExecuteNonQuery(strSql); }