public List <DatabaseItemEdit> GetEdit(string tablename, string Id, ApiCall call) { var db = Kooboo.Data.DB.GetKDatabase(call.Context.WebSite); var dbTable = Kooboo.Data.DB.GetTable(db, tablename); List <DatabaseItemEdit> result = new List <DatabaseItemEdit>(); var obj = dbTable.Get(Id); foreach (var item in dbTable.Setting.Columns) { DatabaseItemEdit model = new DatabaseItemEdit() { Name = item.Name, IsIncremental = item.IsIncremental, IsUnique = item.IsUnique, IsIndex = item.IsIndex, IsPrimaryKey = item.IsPrimaryKey, Seed = item.Seed, Scale = item.Increment, IsSystem = item.IsSystem }; model.DataType = DatabaseColumnHelper.ToFrontEndDataType(item.ClrType); model.ControlType = item.ControlType; model.Setting = item.Setting; // get value if (obj != null && obj.ContainsKey(model.Name)) { model.Value = obj[model.Name]; } result.Add(model); } return(result); }
public List <DatabaseColumnViewModel> Columns(string table, ApiCall call) { var db = Kooboo.Data.DB.GetKDatabase(call.Context.WebSite); var dbTable = db.GetOrCreateTable(table); List <DatabaseColumnViewModel> result = new List <DatabaseColumnViewModel>(); foreach (var item in dbTable.Setting.Columns) { if (item.IsSystem && item.Name == IndexedDB.Dynamic.Constants.DefaultIdFieldName) { continue; } DatabaseColumnViewModel model = new DatabaseColumnViewModel() { Name = item.Name, IsIncremental = item.IsIncremental, IsUnique = item.IsUnique, IsIndex = item.IsIndex, IsPrimaryKey = item.IsPrimaryKey, Seed = item.Seed, Scale = item.Increment, IsSystem = item.IsSystem }; model.DataType = DatabaseColumnHelper.ToFrontEndDataType(item.ClrType); model.ControlType = item.ControlType; model.Setting = item.Setting; result.Add(model); } return(result); }