/// <summary> /// 设置实体 /// </summary> /// <param name="entity">实体</param> private void SetObject(SQLBuilder sqlBuilder, BaseRoleOrganizeEntity entity) { sqlBuilder.SetValue(BaseRoleOrganizeEntity.FieldOrganizeId, entity.OrganizeId); sqlBuilder.SetValue(BaseRoleOrganizeEntity.FieldRoleId, entity.RoleId); sqlBuilder.SetValue(BaseRoleOrganizeEntity.FieldEnabled, entity.Enabled); sqlBuilder.SetValue(BaseRoleOrganizeEntity.FieldDescription, entity.Description); sqlBuilder.SetValue(BaseRoleOrganizeEntity.FieldDeletionStateCode, entity.DeletionStateCode); SetObjectExpand(sqlBuilder, entity); }
/// <summary> /// 为了提高授权的运行速度 /// </summary> /// <param name="Id">主键</param> /// <param name="systemCode">系统编号</param> /// <param name="organizeId">组织机构主键</param> /// <param name="roleId">角色主键</param> /// <returns>主键</returns> public string AddToRole(string systemCode, string organizeId, string roleId) { string result = string.Empty; BaseRoleOrganizeEntity entity = new BaseRoleOrganizeEntity(); entity.OrganizeId = organizeId; entity.RoleId = roleId; entity.Enabled = 1; entity.DeletionStateCode = 0; string tableName = systemCode + "RoleOrganize"; BaseRoleOrganizeManager manager = new BaseRoleOrganizeManager(this.DbHelper, this.UserInfo, tableName); return(manager.Add(entity)); }
/// <summary> /// 更新实体 /// </summary> /// <param name="entity">实体</param> public int UpdateObject(BaseRoleOrganizeEntity entity) { SQLBuilder sqlBuilder = new SQLBuilder(DbHelper); sqlBuilder.BeginUpdate(this.CurrentTableName); this.SetObject(sqlBuilder, entity); if (UserInfo != null) { sqlBuilder.SetValue(BaseRoleOrganizeEntity.FieldModifiedUserId, UserInfo.Id); sqlBuilder.SetValue(BaseRoleOrganizeEntity.FieldModifiedBy, UserInfo.RealName); } sqlBuilder.SetDBNow(BaseRoleOrganizeEntity.FieldModifiedOn); sqlBuilder.SetWhere(BaseRoleOrganizeEntity.FieldId, entity.Id); return(sqlBuilder.EndUpdate()); }
/// <summary> /// 添加 /// </summary> /// <param name="entity">实体</param> /// <returns>主键</returns> public string Add(BaseRoleOrganizeEntity entity) { return(this.AddObject(entity)); }
partial void SetObjectExpand(SQLBuilder sqlBuilder, BaseRoleOrganizeEntity entity);
/// <summary> /// 添加实体 /// </summary> /// <param name="entity">实体</param> public string AddObject(BaseRoleOrganizeEntity entity) { string result = string.Empty; SQLBuilder sqlBuilder = new SQLBuilder(DbHelper, this.Identity, this.ReturnId); sqlBuilder.BeginInsert(this.CurrentTableName, BaseRoleOrganizeEntity.FieldId); if (!this.Identity) { sqlBuilder.SetValue(BaseRoleOrganizeEntity.FieldId, entity.Id); } else { if (!this.ReturnId && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2)) { if (DbHelper.CurrentDbType == CurrentDbType.Oracle) { sqlBuilder.SetFormula(BaseRoleOrganizeEntity.FieldId, "SEQ_" + BaseRoleEntity.TableName.ToUpper() + ".NEXTVAL "); } if (DbHelper.CurrentDbType == CurrentDbType.DB2) { sqlBuilder.SetFormula(BaseRoleOrganizeEntity.FieldId, "NEXT VALUE FOR SEQ_" + BaseRoleEntity.TableName.ToUpper()); } } else { if (this.Identity && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2)) { if (entity.Id == null) { if (string.IsNullOrEmpty(result)) { BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity); result = sequenceManager.Increment(BaseRoleEntity.TableName); } entity.Id = int.Parse(result); } sqlBuilder.SetValue(BaseRoleOrganizeEntity.FieldId, entity.Id); } } } this.SetObject(sqlBuilder, entity); if (UserInfo != null) { sqlBuilder.SetValue(BaseRoleOrganizeEntity.FieldCreateUserId, UserInfo.Id); sqlBuilder.SetValue(BaseRoleOrganizeEntity.FieldCreateBy, UserInfo.RealName); } sqlBuilder.SetDBNow(BaseRoleOrganizeEntity.FieldCreateOn); if (UserInfo != null) { sqlBuilder.SetValue(BaseRoleOrganizeEntity.FieldModifiedUserId, UserInfo.Id); sqlBuilder.SetValue(BaseRoleOrganizeEntity.FieldModifiedBy, UserInfo.RealName); } sqlBuilder.SetDBNow(BaseRoleOrganizeEntity.FieldModifiedOn); if (DbHelper.CurrentDbType == CurrentDbType.SqlServer && this.Identity) { result = sqlBuilder.EndInsert().ToString(); } else { sqlBuilder.EndInsert(); } return(result); }
/// <summary> /// 更新 /// </summary> /// <param name="entity">实体</param> public int Update(BaseRoleOrganizeEntity entity) { return(this.UpdateObject(entity)); }
/// <summary> /// 添加 /// </summary> /// <param name="entity">实体</param> /// <param name="identity">自增量方式</param> /// <param name="returnId">返回主鍵</param> /// <returns>主键</returns> public string Add(BaseRoleOrganizeEntity entity, bool identity, bool returnId) { this.Identity = identity; this.ReturnId = returnId; return(this.AddObject(entity)); }