/// 根据--回复内容--得到回帖信息
/// </summary>
/// <param name="revertmanage"></param>
/// <param name="tbName"></param>
/// <returns></returns>
public DataSet FindRevertByRContent(RevertManage revertmanage, string tbName)
{
SqlParameter[] prams =
{
data.MakeInParam("@revertcontent", SqlDbType.NVarChar, 2000, "%" + revertmanage._RevertContent + "%"),
};
return(data.RunProcReturn("select * from aspnet_Revert where RevertContent like @revertcontent ORDER BY RevertTime", prams, tbName));
}
/// <summary>
/// 根据--用户编号--得到回帖信息
/// </summary>
/// <param name="revertmanage"></param>
/// <param name="tbName"></param>
/// <returns></returns>
public DataSet FindRevertByUserID(RevertManage revertmanage, string tbName)
{
SqlParameter[] prams =
{
data.MakeInParam("@userid", SqlDbType.UniqueIdentifier, 16, revertmanage._UserID),
};
return(data.RunProcReturn("select * from aspnet_Revert where UserID = @userid ORDER BY RevertTime", prams, tbName));
}
/// <summary>
/// 根据--组队编号--得到回帖信息
/// </summary>
/// <param name="revertmanage"></param>
/// <param name="tbName"></param>
/// <returns></returns>
public DataSet FindRevertByTeamID(RevertManage revertmanage, string tbName)
{
SqlParameter[] prams =
{
data.MakeInParam("@teamid", SqlDbType.Int, 4, revertmanage._TeamID),
};
return(data.RunProcReturn("select * from aspnet_Revert where TeamID = @teamid ORDER BY RevertTime", prams, tbName));
}
/// <summary>
/// 删除--回帖信息
/// </summary>
/// <param name="revertmanage"></param>
/// <returns></returns>
public int DeleteRevert(RevertManage revertmanage)
{
SqlParameter[] prams =
{
data.MakeInParam("@revertid", SqlDbType.Int, 4, revertmanage._RevertID)
};
return(data.RunProc("delete from aspnet_Revert where RevertID=@revertid", prams));
}
/// <summary>
/// 添加--回帖信息
/// </summary>
/// <param name="revertmanage"></param>
/// <returns></returns>
///
public int AddRevert(RevertManage revertmanage)
{
SqlParameter[] prams =
{
data.MakeInParam("@topicid", SqlDbType.Int, 4, revertmanage._TopicID),
data.MakeInParam("@teamid", SqlDbType.Int, 4, revertmanage._TeamID),
data.MakeInParam("@revertcontent", SqlDbType.NVarChar, 2000, revertmanage._RevertContent),
data.MakeInParam("@userid", SqlDbType.UniqueIdentifier, 16, revertmanage._UserID),
data.MakeInParam("@attention", SqlDbType.Int, 4, revertmanage._Attention),
data.MakeInParam("@image", SqlDbType.NVarChar, 50, revertmanage._Image),
data.MakeInParam("@reverttime", SqlDbType.DateTime, 8, revertmanage._RevertTime),
data.MakeInParam("@isvisible", SqlDbType.Bit, 1, revertmanage._IsVisible),
};
return(data.RunProc("insert into aspnet_Revert values(TopicID,TeamID,RevertContent,UserID,Attention,Image,RevertTime,IsVisible) values(@topicid,@teamid,@revertcontent,@userid,@attention,@image,@reverttime,@isvisible)", prams));
}
/// <summary>
/// 修改--回帖信息
/// </summary>
/// <param name="revertmanage"></param>
/// <returns></returns>
public int UpdateRevert(RevertManage revertmanage)
{
SqlParameter[] prams =
{
data.MakeInParam("@revertid", SqlDbType.Int, 4, revertmanage._RevertID),
data.MakeInParam("@topicid", SqlDbType.Int, 4, revertmanage._TopicID),
data.MakeInParam("@teamid", SqlDbType.Int, 4, revertmanage._TeamID),
data.MakeInParam("@revertcontent", SqlDbType.NVarChar, 2000, revertmanage._RevertContent),
data.MakeInParam("@userid", SqlDbType.UniqueIdentifier, 16, revertmanage._UserID),
data.MakeInParam("@attention", SqlDbType.Int, 4, revertmanage._Attention),
data.MakeInParam("@image", SqlDbType.NVarChar, 50, revertmanage._Image),
data.MakeInParam("@reverttime", SqlDbType.DateTime, 8, revertmanage._RevertTime),
data.MakeInParam("@isvisible", SqlDbType.Bit, 1, revertmanage._IsVisible),
};
return(data.RunProc("update aspnet_Revert set TopicID=@topicid,TeamID=@teamid,RevertContent=@revertcontent,UserID = @userid,Attention = @attention, Image = @imge,RevertTime = @reverttime, IsVisible = @isvisible where RevertID=@revertid", prams));
}
