/// <summary> /// 获取操作model /// </summary> /// <returns></returns> public async Task <UserActionCharacteristics> GetOperateModel(UserType userType, ActionEnum operateType, ActionCharacteristicsEnum actionCharacteristics = ActionCharacteristicsEnum.Action) { string sqlstring = $@"select ua.user_action_guid, ua.user_type_guid, ua.action_guid, ac.action_characteristics_code, ac.action_characteristics_name, ua.enable, ua.created_by, ua.creation_date, ua.last_updated_by, ua.last_updated_date from t_utility_user_action as ua left join t_utility_action_characteristics as ac on ac.action_characteristics_guid=ua.action_guid where ac.action_characteristics_guid=@action_characteristics_guid and ac.action_characteristics_type=@action_characteristics_type and ua.user_type_guid=@user_type_guid"; DynamicParameters parameters = new DynamicParameters(); parameters.Add("action_characteristics_guid", operateType.GetDescription(), System.Data.DbType.String); parameters.Add("action_characteristics_type", actionCharacteristics.ToString(), System.Data.DbType.String); parameters.Add("user_type_guid", userType.ToString(), System.Data.DbType.String); using (MySql.Data.MySqlClient.MySqlConnection conn = MySqlHelper.GetConnection()) { return(await conn.QueryFirstAsync <UserActionCharacteristics>(sqlstring, parameters)); } }
/// <summary> /// 获取积分规则Model /// </summary> /// <param name="userType">用户类型</param> /// <param name="actionCharacteristics">行为特征枚举</param> /// <returns></returns> public async Task <List <GetActionRulesResponseDto> > GetScoreRulesModel(UserType userType, ActionCharacteristicsEnum actionCharacteristics = ActionCharacteristicsEnum.Action) { string sqlstring = $@"select sr.rules_guid AS RulesGuid, ac.action_characteristics_code AS ActionCharacteristicsCode, ac.action_characteristics_name AS ActionCharacteristicsName, ac.action_characteristics_type AS ActionCharacteristicsType from t_utility_score_rules as sr inner join t_utility_user_action as ua on sr.user_action_guid=ua.user_action_guid inner join t_utility_action_characteristics as ac on ac.action_characteristics_guid=ua.action_guid where ac.action_characteristics_type=@action_characteristics_type and ua.user_type_guid=@user_type_guid"; DynamicParameters parameters = new DynamicParameters(); parameters.Add("action_characteristics_type", actionCharacteristics.ToString(), System.Data.DbType.String); parameters.Add("user_type_guid", userType.ToString(), System.Data.DbType.String); using (MySql.Data.MySqlClient.MySqlConnection conn = MySqlHelper.GetConnection()) { return((await conn.QueryAsync <GetActionRulesResponseDto>(sqlstring, parameters)).AsList()); } }