/// <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);
}
