/// <summary> /// 添加访客信息 /// </summary> /// <param name="model"></param> public static void Insert(VisitorInfo model) { if (model.FromUserId == 0 || model.ToUserId == 0) { return; } if (model.FromUserId == model.ToUserId) { return; } //首先检查是否有记录 //如果有,则更新访问时间 //如果没有,则插入一条 string strSQL = @"DECLARE @C INT; SELECT @C = COUNT(*) FROM Visitors WHERE FromUserId = @FromUserId AND ToUserId = @ToUserId IF @C = 0 BEGIN INSERT INTO Visitors(FromUserId,FromUserName,ToUserId,ToUserName,VisitDateTime) VALUES(@FromUserId,@FromUserName,@ToUserId,@ToUserName,GETDATE()) END ELSE BEGIN UPDATE Visitors SET VisitDateTime = GETDATE() WHERE FromUserId = @FromUserId AND ToUserId = @ToUserId END"; SqlParameter[] parms = { new SqlParameter("FromUserId",SqlDbType.Int), new SqlParameter("FromUserName",SqlDbType.NVarChar), new SqlParameter("ToUserId",SqlDbType.Int), new SqlParameter("ToUserName",SqlDbType.NVarChar) }; parms[0].Value = model.FromUserId; parms[1].Value = model.FromUserName; parms[2].Value = model.ToUserId; parms[3].Value = model.ToUserName; Goodspeed.Library.Data.SQLPlus.ExecuteNonQuery(CommandType.Text,strSQL,parms); }
/// <summary> /// 添加访客信息 /// </summary> /// <param name="model"></param> public static void Insert(VisitorInfo model) { VisitorManage.Insert(model); }