解决微信扫名片码时,不正确显示名片用户名称的问题(只保留第一次扫码的名片用户)
| | |
| | | + " begin\n" |
| | | + " update a set LastFromOpenId =case when isnull(@FromOpenId,'') <> '' then @FromOpenId else LastFromOpenId end,\n" |
| | | + " LastFromOpenIdVisitDate = case when isnull(@FromOpenId,'') <> '' then getdate() else LastFromOpenIdVisitDate end,\n" |
| | | + " LastSessionId = @SessionId,LastUserId = @FromUserId,LastUserName = @FromUserName \n" |
| | | + " LastSessionId = @SessionId \n" |
| | | //+ " ,LastUserId = @FromUserId,LastUserName = @FromUserName \n" 只保留第一次扫码的名片用户,后续扫码时,不再更新 |
| | | + " from t730102 a where a.OpenId = @OpenId\n" |
| | | + " select @myrowcount = @@rowcount \n" |
| | | + " end \n" |