/// 根据--回复内容--得到回帖信息 /// </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)); }