public IDBEntity Read(string key) { IDBEntity entity = null; _db.TryGetValue(key, out entity); return(entity); }
/// <summary> /// 复制操作数据 /// </summary> /// <param name="target">复制到的目标对象</param> public virtual void CopyOperation(IDBEntity target) { target.CreatorId = CreatorId; target.CreateTime = CreateTime; target.IsDelete = IsDelete; target.LastOperatorId = LastOperatorId; target.LastUpdateTime = LastUpdateTime; }
private static DesignerPallet BuildPallet(StackAppContext appContext, IDBEntity entity) { var pallet = new DesignerPallet(); pallet.Fields = PrepareFieldList(entity); pallet.Buttons = PrepareButtonNLinks(appContext, entity); return(pallet); }
private void AttachEntity(IDBEntity entity) { if (entity.ID > 0) { this.dbContext.Attach(entity); this.dbContext.Entry(entity).State = EntityState.Modified; } else { this.dbContext.Add(entity); } }
public bool CreateOrUpdate(string key, IDBEntity entity) { if (Read(key) != null) { Update(key, entity); } else { Create(key, entity); } return(true); }
public void Remove(IDBEntity entity) { City cityIn = (City)entity; using (MySqlConnection connection = StaticService.GetConnection()) { StaticService.adapter.DeleteCommand = new MySqlCommand("DELETE FROM mydb.cities WHERE (Id = " + cityIn.Id + ");", connection); connection.Open(); StaticService.adapter.DeleteCommand.ExecuteNonQuery(); } // StaticService.cities.Remove(cityIn); }
public string PrepareRelatedFieldDataQueries(IEntityRelation relation, IDBEntity childEntity) { if (relation.Type == EntityRelationType.ManyToMany) { var relField = relation.ParentRefField.DBName; return($@"select {childEntity.IDField} as id, {childEntity.TextField} as name, pId from {childEntity.DBName} as c1 join ( SELECT pField[s] as x, pId FROM (SELECT {relField} as pField, {_Entity.IDField} as pId, generate_subscripts({relField}, 1) AS s FROM {_Entity.DBName} where id = ANY(@ItemId) ) AS foo ) as z on c1.{childEntity.IDField} = z.x;"); } return(""); }
public void Remove(IDBEntity entity) { Customer customerIn = (Customer)entity; using (MySqlConnection connection = StaticService.GetConnection()) { StaticService.adapter.DeleteCommand = new MySqlCommand("DELETE FROM mydb.customers WHERE (Name = '" + customerIn.Name + "') AND (FirstName = '" + customerIn.FirstName + "');", connection); connection.Open(); StaticService.adapter.DeleteCommand.ExecuteNonQuery(); } // StaticService.customers.Remove(customerIn); }
private TList PrepareLayout(DataListDefinition ds, IDBEntity entity) { var fields = new String[] { ds.ItemIdField, ds.ItemViewField }; var tList = new TList(); tList.Fields = new List <TListField>(); foreach (var f in fields) { var tfield = new TListField() { FieldId = f }; tList.Fields.Add(tfield); } return(tList); }
public IDBEntity Create(IDBEntity entity) { City city = (City)entity; using (MySqlConnection connection = StaticService.GetConnection()) { StaticService.adapter.InsertCommand = new MySqlCommand( "INSERT INTO mydb.cities " + "VALUES(@Id,@City);", connection); StaticService.adapter.InsertCommand.Parameters.Add("@Id", MySqlDbType.Int32).Value = city.Id; StaticService.adapter.InsertCommand.Parameters.Add("@City", MySqlDbType.VarChar).Value = city.Name; connection.Open(); StaticService.adapter.InsertCommand.ExecuteNonQuery(); } StaticService.cities.Add(city); return(city); }
private static List <DynamicObj> PrepareFieldList(IDBEntity entity) { var fields = entity.GetLayoutFields(EntityLayoutType.None); var coll = new List <DynamicObj>(); foreach (var f in fields) { var d = new DynamicObj(); d.Add("Name", f.Name); d.Add("Text", f.Text); d.Add("Type", f.Type); d.Add("WidgetType", f.ControlType); d.Add("Isrequired", f.IsRequired); d.Add("ShouldFullRow", EntityLayoutService.IsWidgetOnFullRow(f.ControlType)); coll.Add(d); } return(coll); }
public IDBEntity Create(IDBEntity entity) { Place place = (Place)entity; using (MySqlConnection connection = StaticService.GetConnection()) { StaticService.adapter.InsertCommand = new MySqlCommand( "INSERT INTO mydb.places " + "VALUES(@Id,@CityId,@Street);", connection); StaticService.adapter.InsertCommand.Parameters.Add("@Id", MySqlDbType.Int32).Value = place.Id; StaticService.adapter.InsertCommand.Parameters.Add("@CityId", MySqlDbType.Int32).Value = place.City.Id; StaticService.adapter.InsertCommand.Parameters.Add("@Street", MySqlDbType.VarChar).Value = place.Street; connection.Open(); StaticService.adapter.InsertCommand.ExecuteNonQuery(); } StaticService.places.Add(place); return(place); }
public void Update(int id, IDBEntity entity) { Place placeIn = (Place)entity; using (MySqlConnection connection = StaticService.GetConnection()) { string query = @"UPDATE places SET Id =" + placeIn.Id + " ,CityId = '" + placeIn.City.Id + "' ,Street = '" + placeIn.Street + @"' WHERE (" + @"Id = " + placeIn.Id + @")"; MySqlDataAdapter localAadapter = new MySqlDataAdapter(); localAadapter.UpdateCommand = new MySqlCommand(query, connection); connection.Open(); localAadapter.UpdateCommand.ExecuteNonQuery(); } // StaticService.places.Remove(StaticService.places.Find(city => city.Id == id)); StaticService.places.Add(placeIn); }
public void Update(int id, IDBEntity entity) { CustomerPlace customerPlaceIn = (CustomerPlace)entity; using (MySqlConnection connection = StaticService.GetConnection()) { string query = @"UPDATE customersPlaces SET Id =" + customerPlaceIn.Id + " ,UpdateTime = '" + customerPlaceIn.UpdateTime.ToString("yyyy-MM-dd hh:mm:ss") + "' ,CustomerId = " + customerPlaceIn.CustomerId + " ,PlaceId = " + customerPlaceIn.PlaceId + @" WHERE (" + @"Id = " + customerPlaceIn.Id + @")"; MySqlDataAdapter localAadapter = new MySqlDataAdapter(); localAadapter.UpdateCommand = new MySqlCommand(query, connection); connection.Open(); localAadapter.UpdateCommand.ExecuteNonQuery(); } // StaticService.customersPlaces.Remove(StaticService.customersPlaces.Find(city => city.Id == id)); StaticService.customersPlaces.Add(customerPlaceIn); }
public void Update(int id, IDBEntity entity) { City cityIn = (City)entity; using (MySqlConnection connection = StaticService.GetConnection()) { string query = @"UPDATE cities SET Id =" + cityIn.Id + " ,City = '" + cityIn.Name + @" WHERE (" + @"Id = " + cityIn.Id + @")"; MySqlDataAdapter localAadapter = new MySqlDataAdapter(); localAadapter.UpdateCommand = new MySqlCommand(query, connection); connection.Open(); localAadapter.UpdateCommand.ExecuteNonQuery(); } // StaticService.cities.Remove(StaticService.cities.Find(city => city.Id == id)); StaticService.cities.Add(cityIn); }
public IDBEntity Create(IDBEntity entity) { CustomerPlace customerPlace = (CustomerPlace)entity; using (MySqlConnection connection = StaticService.GetConnection()) { StaticService.adapter.InsertCommand = new MySqlCommand( "INSERT INTO mydb.customersPlaces " + "VALUES(@Id,@UpdateTime,@CustomerId,@PlaceId);", connection); StaticService.adapter.InsertCommand.Parameters.Add("@Id", MySqlDbType.Int32).Value = customerPlace.Id; StaticService.adapter.InsertCommand.Parameters.Add("@UpdateTime", MySqlDbType.Timestamp).Value = customerPlace.UpdateTime; // no ToString("FormatString") StaticService.adapter.InsertCommand.Parameters.Add("@CustomerId", MySqlDbType.Int32).Value = customerPlace.CustomerId; StaticService.adapter.InsertCommand.Parameters.Add("@PlaceId", MySqlDbType.Int32).Value = customerPlace.PlaceId; connection.Open(); StaticService.adapter.InsertCommand.ExecuteNonQuery(); } StaticService.customersPlaces.Add(customerPlace); return(customerPlace); }
public IDBEntity Create(IDBEntity entity) { Customer customer = (Customer)entity; using (MySqlConnection connection = StaticService.GetConnection()) { StaticService.adapter.InsertCommand = new MySqlCommand( "INSERT INTO mydb.customers " + "VALUES(@Id,@Name,@FirstName,@DateOfBirth);", connection); StaticService.adapter.InsertCommand.Parameters.Add("@Id", MySqlDbType.Int32).Value = customer.Id; StaticService.adapter.InsertCommand.Parameters.Add("@Name", MySqlDbType.VarChar).Value = customer.Name; StaticService.adapter.InsertCommand.Parameters.Add("@FirstName", MySqlDbType.VarChar).Value = customer.Name; StaticService.adapter.InsertCommand.Parameters.Add("@DateOfBirth", MySqlDbType.Date).Value = customer.DateOfBirth.ToString("yyyy-MM-dd"); connection.Open(); StaticService.adapter.InsertCommand.ExecuteNonQuery(); } StaticService.customers.Add(customer); return(customer); }
public void Update(int id, IDBEntity entity) { Customer customerIn = (Customer)entity; using (MySqlConnection connection = StaticService.GetConnection()) { string query = @"UPDATE customers SET Id = " + customerIn.Id + " ,Name = '" + customerIn.Name + @"',FirstName = '" + customerIn.FirstName + @"',DateOfBirth = '" + customerIn.DateOfBirth.ToString("yyyy-MM-dd") + @"' WHERE (" + @"Id = " + id + @")"; MySqlDataAdapter localAadapter = new MySqlDataAdapter(); localAadapter.UpdateCommand = new MySqlCommand(query, connection); connection.Open(); localAadapter.UpdateCommand.ExecuteNonQuery(); } // StaticService.customers.Remove(StaticService.customers.Find(customer => customer.Id == id)); StaticService.customers.Add(customerIn); }
public EntityRecordModel(IDBEntity entity) : base(entity) { }
private static List <int> FetchDataModel(StackAppContext appContext, int parentId, BaseField parentField, IDBEntity entity) { var filterExp = new FilterExpression(entity.EntityId); var relField = (OneToManyField)parentField; filterExp.Add(new FilterExpField(relField.RefFieldName, FilterOperationType.Equal, parentId)); var ids = entity.ReadIds(appContext, filterExp); return(ids); }
public bool Update(string key, IDBEntity entity) { _db[key] = entity; return(true); }
public static TView CreateDefault(IDBEntity Entity, EntityLayoutType layoutType) { var view = new TView(); view.Fields = new List <TField>(); var page = new TPage(); view.Pages.Add(page); var group = new TGroup(); page.Groups.Add(group); var start_new_r = true; List <TCol> col_r = new List <TCol>(); var layoutF = Entity.GetLayoutFields(EntityLayoutType.Edit); int idx = 0; foreach (var f in layoutF) { var col = new TCol(f.Name); view.Fields.Add(new TField() { FieldId = f.Name, Text = f.Text }); if (col_r.Count == 1) { start_new_r = true; } else { start_new_r = false; } if (IsWidgetOnFullRow(f.ControlType)) { start_new_r = true; var row = new TRow(); col.Span = 24; row.Cols = new List <TCol>() { col }; group.Rows.Add(row); } else { col_r.Add(col); } if (start_new_r) { var row = new TRow(); row.Cols = col_r; group.Rows.Add(row); col_r = new List <TCol>(); } else if (layoutF.Count - 1 == idx) { var row = new TRow(); row.Cols = col_r; group.Rows.Add(row); } idx++; } return(view); }
public EntityDBSave(IDBEntity entity) { _entity = entity; }
public static AnyStatus SaveEntity(StackAppContext appContext, IDBEntity entity, EntityModelBase model, IDbConnection connection, IDbTransaction transaction) { AnyStatus sts = AnyStatus.UpdateFailure; var eSave = new EntityDBSave(entity); if (model.IsNew) { var eId = GetNextEntityDBId(entity.EntityId.Code); model.SetID(eId); } IDbConnection conn; IDbTransaction trans; bool isLocalConnection = true; if (connection == null) { conn = DBService.Connection; conn.Open(); trans = conn.BeginTransaction(); } else { conn = connection; trans = transaction; isLocalConnection = false; } try { sts = entity.OnBeforeDbSave(appContext, model, conn, trans); if (sts == AnyStatus.Success) { eSave.Save(model, conn, trans); sts = entity.OnAfterDbSave(appContext, model, conn, trans); if (sts != AnyStatus.Success) { if (isLocalConnection) { trans.Rollback(); } } else { if (isLocalConnection) { trans.Commit(); } } } } catch (Exception ex) { sts = AnyStatus.SaveFailure; sts.Message = ex.Message; if (isLocalConnection) { trans.Rollback(); } } finally { if (isLocalConnection) { trans.Dispose(); conn.Close(); } } return(sts); }
public EntityModelBase(IDBEntity entity) : base(entity) { TempInfo = new DynamicObj(); }
public EntityQueryBuilder(IDBEntity entity) { _Entity = entity; }
public bool Create(string key, IDBEntity entity) { _db.Add(key, entity); return(true); }
private static List <DynamicObj> PrepareButtonNLinks(StackAppContext appContext, IDBEntity entity) { var actions = EntityActionService.GetActions(appContext, entity.EntityId, EntityLayoutType.View); var coll = new List <DynamicObj>(); foreach (var f in actions) { var d = new DynamicObj(); d.Add("Id", f.Id); d.Add("Text", f.Text); coll.Add(d); } return(coll); }