/// <summary> /// 设置实体 /// </summary> /// <param name="entity">实体</param> private void SetObject(SQLBuilder sqlBuilder, BaseUserScoreEntity entity) { SetObjectExpand(sqlBuilder, entity); sqlBuilder.SetValue(BaseUserScoreEntity.FieldUserId, entity.UserId); sqlBuilder.SetValue(BaseUserScoreEntity.FieldUsername, entity.Username); sqlBuilder.SetValue(BaseUserScoreEntity.FieldScore, entity.Score); sqlBuilder.SetValue(BaseUserScoreEntity.FieldFunctionCode, entity.FunctionCode); sqlBuilder.SetValue(BaseUserScoreEntity.FieldObjectId, entity.ObjectId); sqlBuilder.SetValue(BaseUserScoreEntity.FieldContents, entity.Contents); sqlBuilder.SetValue(BaseUserScoreEntity.FieldDeletionStateCode, entity.DeletionStateCode); sqlBuilder.SetValue(BaseUserScoreEntity.FieldEnabled, entity.Enabled); sqlBuilder.SetValue(BaseUserScoreEntity.FieldDescription, entity.Description); }
/// <summary> /// 更新实体 /// </summary> /// <param name="entity">实体</param> public int UpdateObject(BaseUserScoreEntity entity) { SQLBuilder sqlBuilder = new SQLBuilder(DbHelper); sqlBuilder.BeginUpdate(this.CurrentTableName); this.SetObject(sqlBuilder, entity); if (UserInfo != null) { sqlBuilder.SetValue(BaseUserScoreEntity.FieldModifiedUserId, UserInfo.Id); sqlBuilder.SetValue(BaseUserScoreEntity.FieldModifiedBy, UserInfo.Realname); } sqlBuilder.SetDBNow(BaseUserScoreEntity.FieldModifiedOn); sqlBuilder.SetWhere(this.PrimaryKey, entity.Id); return(sqlBuilder.EndUpdate()); }
/// <summary> /// 添加 /// </summary> /// <param name="entity">实体</param> /// <returns>主键</returns> public string Add(BaseUserScoreEntity entity) { string result = string.Empty; // 添加子表,用户积分表 result = this.AddObject(entity); // 更新用户积分 SQLBuilder sqlBuilder = new SQLBuilder(this.DbHelper); sqlBuilder.BeginUpdate(BaseUserEntity.TableName); sqlBuilder.SetFormula(BaseUserEntity.FieldScore, BaseUserEntity.FieldScore + " + " + entity.Score); sqlBuilder.SetWhere(BaseUserEntity.FieldId, entity.UserId); sqlBuilder.EndUpdate(); // 发送手机短信提醒 return(result); }
// 这个是声明扩展方法 partial void SetObjectExpand(SQLBuilder sqlBuilder, BaseUserScoreEntity entity);
/// <summary> /// 添加实体 /// </summary> /// <param name="entity">实体</param> public string AddObject(BaseUserScoreEntity entity) { string sequence = string.Empty; SQLBuilder sqlBuilder = new SQLBuilder(DbHelper, this.Identity, this.ReturnId); sqlBuilder.BeginInsert(this.CurrentTableName, this.PrimaryKey); if (entity.Id != null || !this.Identity) { // 这里已经是指定了主键了,所以不需要返回主键了 sqlBuilder.ReturnId = false; sqlBuilder.SetValue(this.PrimaryKey, entity.Id); } else { if (!this.ReturnId && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2)) { if (DbHelper.CurrentDbType == CurrentDbType.Oracle) { sqlBuilder.SetFormula(this.PrimaryKey, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL "); } if (DbHelper.CurrentDbType == CurrentDbType.DB2) { sqlBuilder.SetFormula(this.PrimaryKey, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper()); } } else { if (this.Identity && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2)) { if (entity.Id == null) { if (string.IsNullOrEmpty(sequence)) { BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper, this.Identity); sequence = sequenceManager.Increment(this.CurrentTableName); } } sqlBuilder.SetValue(this.PrimaryKey, entity.Id); } } } this.SetObject(sqlBuilder, entity); if (UserInfo != null) { sqlBuilder.SetValue(BaseUserScoreEntity.FieldCreateUserId, UserInfo.Id); sqlBuilder.SetValue(BaseUserScoreEntity.FieldCreateBy, UserInfo.Realname); } sqlBuilder.SetDBNow(BaseUserScoreEntity.FieldCreateOn); if (UserInfo != null) { sqlBuilder.SetValue(BaseUserScoreEntity.FieldModifiedUserId, UserInfo.Id); sqlBuilder.SetValue(BaseUserScoreEntity.FieldModifiedBy, UserInfo.Realname); } sqlBuilder.SetDBNow(BaseUserScoreEntity.FieldModifiedOn); if (this.Identity && (DbHelper.CurrentDbType == CurrentDbType.SqlServer || DbHelper.CurrentDbType == CurrentDbType.Access)) { sequence = sqlBuilder.EndInsert().ToString(); } else { sqlBuilder.EndInsert(); } return(sequence); }
/// <summary> /// 更新 /// </summary> /// <param name="entity">实体</param> public int Update(BaseUserScoreEntity entity) { return(this.UpdateObject(entity)); }
/// <summary> /// 添加 /// </summary> /// <param name="entity">实体</param> /// <param name="identity">自增量方式</param> /// <param name="returnId">返回主键</param> /// <returns>主键</returns> public string Add(BaseUserScoreEntity entity, bool identity, bool returnId) { this.Identity = identity; this.ReturnId = returnId; return(this.AddObject(entity)); }