/// <summary> /// 创建一个数据字典 /// </summary> /// <param name="db">实体数据</param> /// <param name="entity">将要创建的一个数据字典</param> public void Create(SysEntities db, SysField entity) { if (entity != null) { db.SysField.AddObject(entity); } }
/// <summary> /// 创建一个数据字典 /// </summary> /// <param name="entity">一个对象</param> /// <returns></returns> public int Create(SysField entity) { using (SysEntities db = new SysEntities()) { Create(db, entity); return(this.Save(db)); } }
/// <summary> /// 删除一个数据字典 /// </summary> /// <param name="db">实体数据</param> /// <param name="id">一条数据字典的主键</param> public void Delete(SysEntities db, string id) { SysField deleteItem = GetById(db, id); if (deleteItem != null) { db.SysField.DeleteObject(deleteItem); } }
/// <summary> /// 判断是否存在引用 /// </summary> /// <param name="db">数据库上下文</param> /// <param name="field">字典表对象</param> /// <returns>是否存在引用(true:是,false:否)</returns> public bool ExistsReference(SysEntities db, SysField field) { bool bResult = false; if (db != null && field != null) { String sql = String.Format("select Value o from SysEntities.{0} as o where o.{1}=@id", field.MyTables, field.MyColums); var reader = db.CreateQuery <DbDataReader>(sql, new ObjectParameter("id", field.Id)); bResult = reader.Count() > 0; } return(bResult); }
/// <summary> /// 编辑一个数据字典对象 /// </summary> /// <param name="db">实体数据</param> /// <param name="entity">将要编辑的一个数据字典对象</param> public SysField Edit(SysEntities db, SysField entity) { db.SysField.Attach(entity); db.ObjectStateManager.ChangeObjectState(entity, EntityState.Modified); return(entity); }