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 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); }
public ActionResult SubmitForm(TableFieldEntity tableFieldEntity, string f_Id) { app.SubmitForm(tableFieldEntity, f_Id); return(Success("操作成功。")); }