/// <summary> /// 愿望上下架 /// </summary> /// <param name="wishNo"></param> /// <param name="isOnline"></param> /// <returns></returns> public async Task <int> ChangeStatus(string activityNo, string wishNo, int isOnline) { string strSql = $@"UPDATE t_wish_base SET is_online={ isOnline } WHERE activity_no=@activityNo AND wish_no=@wishNo AND is_online<> { isOnline };"; return(await _jiakeRepository.SQLExecute(strSql, new { activityNo, wishNo })); }
/*****************************************分隔符*************************************************/ /// <summary> /// 获取会员信息 /// 如果存在直接取回,如果不存在就创建 /// </summary> /// <param name="openId"></param> /// <param name="seeionKey"></param> /// <returns></returns> public async Task <LoginMemberResponse> GetMemberByOpenIdAsync(string activityNo, string openId, string sessionKey) { //查询会员是否存在 string strSql = $@"SELECT id AS memberId, gender, CASE WHEN LENGTH( tel ) > 0 THEN 1 ELSE 0 END AS isBind, nick_name AS nickName,avatar_url avatarUrl FROM t_member WHERE openId = @openId and is_deleted=0;" ; var member = await _jiakeRepository.SQLQueryFirstOrDefaultAsync <LoginMemberResponse>(strSql, new { openId }); //会员存在,返回信息 if (member != null && member.memberId > 0) { strSql = $@"UPDATE t_member SET session_key=@sessionKey,updated_time = NOW( ) WHERE id={member.memberId};"; await _jiakeRepository.SQLExecute(strSql, new { sessionKey }); } else //会员不存在,创建会员 { strSql = $@"INSERT INTO t_member (activity_no,openId,session_key,is_deleted,created_time) VALUES (@activityNo,@openId,@sessionKey,0,NOW()); SELECT @@IDENTITY;"; member = new LoginMemberResponse(); member.memberId = await _jiakeRepository.SQLQueryFirstOrDefaultAsync <int>(strSql, new { activityNo, openId, sessionKey }); } return(member); }
public async Task Invoke() { string activityNo = CronJobParam.ActivityNo; var(startTime, endTime) = await _cronJobParam.GetActivity(); if (startTime.AddDays(2).Date == DateTime.Now.Date) // 活动第三天上午十点 { string strSql = $@"UPDATE t_merchant SET fake_wish_complated=fake_wish_complated+152 WHERE activity_no=@activityNo;"; await _jiakeRepository.SQLExecute(strSql, new { activityNo }); } }
public async Task Invoke() { string activityNo = CronJobParam.ActivityNo; var(startTime, endTime) = await _cronJobParam.GetActivity(); if (endTime.Date == DateTime.Now.Date) // 活动结束 { string strSql = $@"UPDATE t_make_wish SET `status`=3,updated_time=NOW() WHERE activity_no = @activityNo AND `status`=0;"; await _jiakeRepository.SQLExecute(strSql, new { activityNo }); } if (startTime.Date == DateTime.Now.Date) { // 活动开始,关注公众号全部用户发消息 await _cronJobParam.AllSendTemplateMessage(); } }
// 2分钟 public async Task Invoke() { #region 批量 // 获取开始活动的ids // string acSql = $@"SELECT id,start_time FROM t_activity WHERE NOW() BETWEEN start_time AND end_time;"; // var datas = (await _jiakeRepository.SQLQueryAsync<(int, DateTime)>(acSql)).ToList(); // // 当前时间 // var now = DateTime.Now; // foreach (var item in datas) // { // var start_date = item.Item2; // var fakeUp = GetFakeByStartDatetime(start_date, now); // } #endregion 批量 // 活动编号 // string acSql = $@"SELECT start_time FROM t_activity WHERE NOW() BETWEEN start_time AND end_time AND activity_no = @activity_no;"; // var start_date = await _jiakeRepository.SQLQueryFirstOrDefaultAsync<DateTime>(acSql, new { activity_no }); var(start_date, end_date) = await _cronJobParam.GetActivity(); var now = DateTime.Now; var activity_no = CronJobParam.ActivityNo; if (now >= start_date && now <= end_date) { // 计算天数获得应累加的值 var fakeUp = GetFakeByStartDatetime(start_date, now); string sqlStr = $@"UPDATE t_activity SET fake_base = fake_base + @fakeUp WHERE activity_no = @activity_no;"; var result = await _jiakeRepository.SQLExecute(sqlStr, new { fakeUp, activity_no }); if (result > 0) { // log .. fake 成功 } } }