public int Add(T_UserCollectModel t_UserCollectModel)
{
try
{
var sqlparams = new SqlParameter[] {
new SqlParameter("@UserId", t_UserCollectModel.UserId),
new SqlParameter("@RoomId", t_UserCollectModel.RoomId),
new SqlParameter("@CreateTime", DateTime.Now),
};
string sql = @"INSERT INTO [T_UserCollect]
([UserId]
,[RoomId]
,[CreateTime])
VALUES
(@UserId
,@RoomId
,@CreateTime )
";
return(SqlHelper.ExecuteNonQuery(ConnectionString.WTVDns, CommandType.Text, sql, sqlparams));
}
catch (Exception ex)
{
throw ex;
}
}
public int Del(T_UserCollectModel t_UserCollectModel)
{
var sqlparams = new SqlParameter[] {
new SqlParameter("@UserId", t_UserCollectModel.UserId),
new SqlParameter("@RoomId", t_UserCollectModel.RoomId),
};
string sql = @"DELETE FROM [T_UserCollect]
WHERE UserId=@UserId AND RoomId=@RoomId
";
return(SqlHelper.ExecuteNonQuery(ConnectionString.WTVDns, CommandType.Text, sql, sqlparams));
}
public int Del(T_UserCollectModel t_UserCollectModel)
{
new T_UserCollectDAL().Del(t_UserCollectModel);
return(new T_RoomDAL().DelCollect(t_UserCollectModel.RoomId));
}
public int Add(T_UserCollectModel t_UserCollectModel)
{
new T_UserCollectDAL().Add(t_UserCollectModel);
return(new T_RoomDAL().AddCollect(t_UserCollectModel.RoomId));
}