Пример #1
0
        //赛事管理员 批量签到
        public bool BatchSign(List <int> memberId, int eventId, EventSignTypeEm eventSignType, out string msg)
        {
            bool flag = false;

            msg = string.Empty;
            try
            {
                var sql = "update t_event_sign set eventSignStatus=@EventSignStatus,signtime=@SignTime where eventSignType=@EventSignType and memberId in @MemberId and eventId=@EventId and signDate=@SignDate ";
                var dy  = new DynamicParameters();
                dy.Add("MemberId", memberId.ToArray());
                dy.Add("EventId", eventId);
                dy.Add("EventSignType", eventSignType);
                dy.Add("EventSignStatus", EventSignStatusEm.已签到);
                dy.Add("SignTime", DateTime.Now);
                dy.Add("SignDate", DateTime.Now.ToString("yyyy-MM-dd"));
                _dbContext.Execute(sql, dy);
                flag = true;
            }
            catch (Exception ex)
            {
                flag = false;
                msg  = "服务异常";
                LogUtils.LogError("EventSignService.BatchSign", ex);
            }
            return(flag);
        }
Пример #2
0
        public ContentResult batchsign(List <int> memberId, int eventId, EventSignTypeEm eventSignType)
        {
            string msg  = string.Empty;
            var    flag = _eventSignService.BatchSign(memberId, eventId, eventSignType, out msg);

            return(Result <string>(flag, msg));
        }
Пример #3
0
        //选手/裁判获取签到信息
        public SignResponse GetSign(int eventId, int memberId, EventSignTypeEm eventSignType)
        {
            SignResponse response = null;

            try
            {
                var sql = $@"select a.id,b.code EventCode,b.name EventName,a.signdate,a.eventSignStatus from t_event_sign a
                            inner join t_event b on a.eventId=b.id
                            where a.isdelete=0 and a.eventId=@EventId and a.memberId=@MemberId 
                            and a.signdate=@SignDate and a.isStop=@IsStop and a.eventSignType={(int)eventSignType}";
                var dy  = new DynamicParameters();
                dy.Add("EventId", eventId);
                dy.Add("IsStop", false);
                dy.Add("MemberId", memberId);
                dy.Add("SignDate", DateTime.Now.ToShortDateString());
                response = _dbContext.QueryFirstOrDefault <SignResponse>(sql, dy);
            }
            catch (Exception ex)
            {
                LogUtils.LogError("EventSignService.GetSign", ex);
            }
            return(response);
        }