/// <summary>
/// DataModel 转 ViewModel
/// </summary>
/// <param name="userbuyinglog"></param>
/// <returns></returns>
public static UserBuyingLogVModel UserBuyingLogInfoToVModel(UserBuyingLogInfo userbuyinglog)
{
if (userbuyinglog == null)
{
return(new UserBuyingLogVModel());
}
return(new UserBuyingLogVModel
{
Id = userbuyinglog.Id,
AId = userbuyinglog.AId,
Score = userbuyinglog.Score,
UserId = userbuyinglog.UserId,
CreateTime = userbuyinglog.CreateTime
});
}
/// <summary>
/// 添加UserBuyingLogInfo
/// </summary>
/// <param name="userbuyinglog"></param>
/// <returns></returns>
public static int AddUserBuyingLog(UserBuyingLogInfo userbuyinglog)
{
string sql = @"INSERT INTO [UserBuyingLog]
([AId],[Score],[UserId],[CreateTime])
VALUES
(@AId,@Score,@UserId,@CreateTime)
SELECT SCOPE_IDENTITY()
" ;
var par = new DynamicParameters();
par.Add("@AId", userbuyinglog.AId, DbType.Int64);
par.Add("@Score", userbuyinglog.Score, DbType.Int32);
par.Add("@UserId", userbuyinglog.UserId, DbType.Int32);
par.Add("@CreateTime", userbuyinglog.CreateTime, DbType.DateTime);
return(DapWrapper.InnerQueryScalarSql <int>(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 修改UserBuyingLogInfo
/// </summary>
/// <param name="userbuyinglog"></param>
/// <returns></returns>
public static int UpdateUserBuyingLog(UserBuyingLogInfo userbuyinglog)
{
string sql = @"UPDATE [UserBuyingLog] SET
AId=@AId,
Score=@Score,
UserId=@UserId,
CreateTime=@CreateTime
WHERE Id=@Id";
var par = new DynamicParameters();
par.Add("@Id", userbuyinglog.Id, DbType.Int32);
par.Add("@AId", userbuyinglog.AId, DbType.Int64);
par.Add("@Score", userbuyinglog.Score, DbType.Int32);
par.Add("@UserId", userbuyinglog.UserId, DbType.Int32);
par.Add("@CreateTime", userbuyinglog.CreateTime, DbType.DateTime);
return(DapWrapper.InnerExecuteSql(DbConfig.ArticleManagerConnString, sql, par));
}
/// <summary>
/// 修改UserBuyingLogInfo
/// </summary>
/// <param name="userbuyinglog"></param>
/// <returns></returns>
public static int UpdateUserBuyingLog(UserBuyingLogInfo userbuyinglog)
{
return(DataProvider.UserBuyingLogs.UpdateUserBuyingLog(userbuyinglog));
}
