/// <summary>
/// 插入下载日志
/// </summary>
/// <param name="model"></param>
public static void InsertLog(AttachmentDownloadLogInfo model)
{
string strSQL = @"DECLARE @C AS INT;
SELECT @C = COUNT(*) FROM AttachmentDownloadLog WITH(NOLOCK) WHERE AttachId = @AttachId AND UserId = @UserId
IF(@C =0)
BEGIN
INSERT INTO AttachmentDownloadLog(AttachId,UserId,UserName,DownloadCount,LastDownloadDateTime) VALUES(@AttachId,@UserId,@UserName,1,GETDATE());
END
ElSE
BEGIN
UPDATE AttachmentDownloadLog SET DownloadCount = DownloadCount+1 ,LastDownloadDateTime = GETDATE() WHERE AttachId = @AttachId AND UserId = @UserId;
END" ;
SqlParameter[] param =
{
new SqlParameter("Id", SqlDbType.Int),
new SqlParameter("AttachId", SqlDbType.Int),
new SqlParameter("UserId", SqlDbType.Int),
new SqlParameter("UserName", SqlDbType.NVarChar)
};
param[0].Value = model.Id;
param[1].Value = model.AttachId;
param[2].Value = model.UserId;
param[3].Value = model.UserName;
Goodspeed.Library.Data.SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 插入下载日志
/// </summary>
/// <param name="model"></param>
public static void InsertLog(AttachmentDownloadLogInfo model)
{
AttachmentManage.InsertLog(model);
}