Пример #1
0
        public ContentResult cyclingracerule(CyclingRaceRuleRequest request)
        {
            request.SysUserId = UserContext.SysUserContext.Id;
            string msg  = string.Empty;
            var    flag = _eventRuleService.CyclingRaceRule(request, out msg);

            return(Result <string>(flag, msg));
        }
Пример #2
0
        //编辑循环赛规则
        public bool CyclingRaceRule(CyclingRaceRuleRequest request, out string msg)
        {
            bool flag = false;

            msg = string.Empty;
            try
            {
                _dbContext.BeginTransaction();
                foreach (var item in request.Teamscoringrule)
                {
                    var sql = $"update t_event_teamscoringrule set teamScoringRules={(int)item.TeamScoringRules},updatetime='{DateTime.Now}' where id={item.Id}";
                    _dbContext.Execute(sql);
                }

                foreach (var item in request.Scoringrule)
                {
                    var sql = $"update t_event_playerscoringrule set scoringRules={(int)item.ScoringRules},updatetime='{DateTime.Now}' where id={item.Id}";
                    _dbContext.Execute(sql);
                }

                foreach (var item in request.Avoidrule)
                {
                    var sql = $"update t_event_cycling_avoidrule set avoidRules={(int)item.AvoidRules},updatetime='{DateTime.Now}' where id={item.Id}";
                    _dbContext.Execute(sql);
                }

                foreach (var item in request.RefereeAvoidrule)
                {
                    var sql = $"update t_event_refereeavoidrule set refereeAvoidRules={(int)item.RefereeAvoidRules},updatetime='{DateTime.Now}' where id={item.Id}";
                    _dbContext.Execute(sql);
                }
                _dbContext.CommitChanges();
                flag = true;
            }
            catch (Exception ex)
            {
                _dbContext.Rollback();
                flag = false;
                msg  = "服务异常";
                LogUtils.LogError("EventRuleService.CyclingRaceRule", ex);
            }
            return(flag);
        }