/// <summary> /// 设置实体 /// </summary> /// <param name="entity">实体</param> private void SetEntity(SQLBuilder sqlBuilder, PiUserOrganizeEntity entity) { sqlBuilder.SetValue(PiUserOrganizeTable.FieldUserId, entity.UserId); sqlBuilder.SetValue(PiUserOrganizeTable.FieldCompanyId, entity.CompanyId); sqlBuilder.SetValue(PiUserOrganizeTable.FieldSubCompanyId, entity.SubCompanyId); sqlBuilder.SetValue(PiUserOrganizeTable.FieldDepartmentId, entity.DepartmentId); sqlBuilder.SetValue(PiUserOrganizeTable.FieldSubDepartmentId, entity.SubDepartmentId); sqlBuilder.SetValue(PiUserOrganizeTable.FieldWorkgroupId, entity.WorkgroupId); sqlBuilder.SetValue(PiUserOrganizeTable.FieldRoleId, entity.RoleId); sqlBuilder.SetValue(PiUserOrganizeTable.FieldEnabled, entity.Enabled); sqlBuilder.SetValue(PiUserOrganizeTable.FieldDescription, entity.Description); sqlBuilder.SetValue(PiUserOrganizeTable.FieldDeleteMark, entity.DeleteMark); }
/// <summary> /// 更新实体 /// </summary> /// <param name="entity">实体</param> public int UpdateEntity(PiUserOrganizeEntity entity) { var sqlBuilder = new SQLBuilder(DBProvider); sqlBuilder.BeginUpdate(this.CurrentTableName); this.SetEntity(sqlBuilder, entity); if (UserInfo != null) { sqlBuilder.SetValue(PiUserOrganizeTable.FieldModifiedUserId, UserInfo.Id); sqlBuilder.SetValue(PiUserOrganizeTable.FieldModifiedBy, UserInfo.RealName); } sqlBuilder.SetDBNow(PiUserOrganizeTable.FieldModifiedOn); sqlBuilder.SetWhere(PiUserOrganizeTable.FieldId, entity.Id); return(sqlBuilder.EndUpdate()); }
/// <summary> /// 把用户添加到组织机构 /// </summary> /// <param name="userInfo">用户</param> /// <param name="userOrganizeEntity">用户组织机构关系</param> /// <param name="statusCode">状态码</param> /// <param name="statusMessage">状态信息</param> /// <returns>主键</returns> public string AddUserToOrganize(UserInfo userInfo, PiUserOrganizeEntity userOrganizeEntity, out string statusCode, out string statusMessage) { string returnValue = string.Empty; string returnCode = string.Empty; string returnMessage = string.Empty; var parameter = ParameterUtil.CreateWithLog(userInfo, MethodBase.GetCurrentMethod()); ServiceUtil.ProcessRDIReadDb(userInfo, parameter, dbProvider => { var userOrganizeManager = new PiUserOrganizeManager(dbProvider, userInfo); returnValue = userOrganizeManager.Add(userOrganizeEntity, out returnCode); returnMessage = userOrganizeManager.GetStateMessage(returnCode); }); statusCode = returnCode; statusMessage = returnMessage; return(returnValue); }
/// <summary> /// 添加用户 /// </summary> /// <param name="userOrganizeEntity">用户组织机构实体</param> /// <param name="statusCode">状态码</param> /// <returns>主键</returns> public string Add(PiUserOrganizeEntity userOrganizeEntity, out string statusCode) { var returnValue = string.Empty; // 判断数据是否重复了 string[] names = { PiUserOrganizeTable.FieldDeleteMark, PiUserOrganizeTable.FieldEnabled, PiUserOrganizeTable.FieldCompanyId, PiUserOrganizeTable.FieldDepartmentId, PiUserOrganizeTable.FieldWorkgroupId, PiUserOrganizeTable.FieldUserId }; object[] values = { 0, 1, userOrganizeEntity.UserId, userOrganizeEntity.CompanyId, userOrganizeEntity.DepartmentId, userOrganizeEntity.WorkgroupId, userOrganizeEntity.UserId }; if (this.Exists(names, values)) { statusCode = StatusCode.Exist.ToString(); } else { returnValue = this.AddEntity(userOrganizeEntity); statusCode = StatusCode.OKAdd.ToString(); } return(returnValue); }
/// <summary> /// 添加 /// </summary> /// <param name="entity">实体</param> /// <returns>主键</returns> public string Add(PiUserOrganizeEntity entity) { return(this.AddEntity(entity)); }
/// <summary> /// 添加实体 /// </summary> /// <param name="entity">实体</param> public string AddEntity(PiUserOrganizeEntity entity) { var sequence = string.Empty; this.Identity = false; var sqlBuilder = new SQLBuilder(DBProvider, this.Identity, this.ReturnId); sqlBuilder.BeginInsert(this.CurrentTableName, PiUserOrganizeTable.FieldId); if (!this.Identity) { if (string.IsNullOrEmpty(entity.Id)) { sequence = BusinessLogic.NewGuid(); entity.Id = sequence; } sqlBuilder.SetValue(PiUserOrganizeTable.FieldId, entity.Id); } else { if (!this.ReturnId && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2)) { if (DBProvider.CurrentDbType == CurrentDbType.Oracle) { sqlBuilder.SetFormula(PiUserOrganizeTable.FieldId, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL "); } if (DBProvider.CurrentDbType == CurrentDbType.DB2) { sqlBuilder.SetFormula(PiUserOrganizeTable.FieldId, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper()); } } else { if (this.Identity && (DBProvider.CurrentDbType == CurrentDbType.Oracle || DBProvider.CurrentDbType == CurrentDbType.DB2)) { if (entity.Id == null) { if (string.IsNullOrEmpty(sequence)) { var sequenceManager = new CiSequenceManager(DBProvider, this.Identity); sequence = sequenceManager.GetSequence(this.CurrentTableName); } entity.Id = sequence; } sqlBuilder.SetValue(PiUserOrganizeTable.FieldId, entity.Id); } } } this.SetEntity(sqlBuilder, entity); if (UserInfo != null) { sqlBuilder.SetValue(PiUserOrganizeTable.FieldCreateUserId, UserInfo.Id); sqlBuilder.SetValue(PiUserOrganizeTable.FieldCreateBy, UserInfo.RealName); } sqlBuilder.SetDBNow(PiUserOrganizeTable.FieldCreateOn); if (UserInfo != null) { sqlBuilder.SetValue(PiUserOrganizeTable.FieldModifiedUserId, UserInfo.Id); sqlBuilder.SetValue(PiUserOrganizeTable.FieldModifiedBy, UserInfo.RealName); } sqlBuilder.SetDBNow(PiUserOrganizeTable.FieldModifiedOn); if (DBProvider.CurrentDbType == CurrentDbType.SqlServer && this.Identity) { sequence = sqlBuilder.EndInsert().ToString(); } else { sqlBuilder.EndInsert(); } return(sequence); }
/// <summary> /// 更新 /// </summary> /// <param name="entity">实体</param> public int Update(PiUserOrganizeEntity entity) { return(this.UpdateEntity(entity)); }
/// <summary> /// 添加 /// </summary> /// <param name="entity">实体</param> /// <param name="identity">自增量方式</param> /// <param name="returnId">返回主鍵</param> /// <returns>主键</returns> public string Add(PiUserOrganizeEntity entity, bool identity, bool returnId) { this.Identity = identity; this.ReturnId = returnId; return(this.AddEntity(entity)); }