/// 根据--状态--得到话题信息 public DataSet FindTeamByState(TeamManage teammanage, string tbName) { SqlParameter[] prams = { data.MakeInParam("@state", SqlDbType.Int, 4, teammanage._State), }; return(data.RunProcReturn("select * from aspnet_Team where State = @state ORDER BY CreateTime", prams, tbName)); }
/// 根据--标题关键字--得到话题信息 public DataSet FindTeamByTitle(TeamManage teammanage, string tbName) { SqlParameter[] prams = { data.MakeInParam("@teamtitle", SqlDbType.NVarChar, 50, "%" + teammanage._TeamTitle + "%"), }; return(data.RunProcReturn("select * from aspnet_Team where TeamTitle like @teamtitle ORDER BY CreateTime", prams, tbName)); }
/// 根据--是否显示--得到话题信息 public DataSet FindTeamByVisible(TeamManage teammanage, string tbName) { SqlParameter[] prams = { data.MakeInParam("@isvisible", SqlDbType.Bit, 1, teammanage._IsVisible), }; return(data.RunProcReturn("select * from aspnet_Team where IsVisible = @isvisible ORDER BY CreateTime", prams, tbName)); }
/// 根据--用户编号--得到话题信息 public DataSet FindTeamByUerID(TeamManage teammanage, string tbName) { SqlParameter[] prams = { data.MakeInParam("@createrid", SqlDbType.UniqueIdentifier, 4, teammanage._CreaterID), }; return(data.RunProcReturn("select * from aspnet_Team where CreaterID = @createrid ORDER BY CreateTime", prams, tbName)); }
/// 根据--分类编号--得到组队信息 public DataSet FindTeamByClassID(TeamManage teammanage, string tbName) { SqlParameter[] prams = { data.MakeInParam("@classid", SqlDbType.Int, 4, teammanage._ClassID), }; return(data.RunProcReturn("select * from aspnet_Team where ClassID = @classid ORDER BY CreateTime", prams, tbName)); }
public int DeleteTeam(TeamManage teammanage) { SqlParameter[] prams = { data.MakeInParam("@teamid", SqlDbType.Int, 4, teammanage._TeamID), }; return(data.RunProc("delete from aspnet_Team where TeamID=@teamid", prams)); }
public int AddTeam(TeamManage teammanage) { SqlParameter[] prams = { data.MakeInParam("@teamname", SqlDbType.NVarChar, 50, teammanage._TeamName), data.MakeInParam("@createtime", SqlDbType.DateTime, 8, teammanage._CreateTime), data.MakeInParam("@createrid", SqlDbType.UniqueIdentifier, 16, teammanage._CreaterID), data.MakeInParam("@createpos", SqlDbType.NVarChar, 50, teammanage._CreatePos), data.MakeInParam("@teamtitle", SqlDbType.NVarChar, 50, teammanage._TeamTitle), data.MakeInParam("@createcontent", SqlDbType.NVarChar, 2000, teammanage._CreateContent), data.MakeInParam("@dateline", SqlDbType.DateTime, 8, teammanage._DateLine), data.MakeInParam("@maxnum", SqlDbType.Int, 4, teammanage._MaxNum), data.MakeInParam("@presentnum", SqlDbType.Int, 4, teammanage._PresentNum), data.MakeInParam("@attention", SqlDbType.Int, 4, teammanage._Attention), data.MakeInParam("@image", SqlDbType.NVarChar, 50, teammanage._Image), data.MakeInParam("@classid", SqlDbType.Int, 4, teammanage._ClassID), data.MakeInParam("@isvisible", SqlDbType.Bit, 1, teammanage._IsVisible), data.MakeInParam("@state", SqlDbType.Bit, 1, teammanage._State), }; return(data.RunProc("insert into aspnet_Team values(TeamName,CreateTime,CreaterID,CreatePos,TeamTitle,CreateContent,DateLine,MaxNum,PresentNum,Attention,Image,ClassID,IsVisible,State) values(@teamname,@createtime,@createrid,@createpos,@teamtitle,@createcontent,@dateline,@maxnum,@presentnum,@attention,@image,@classid,@isvisible,@state)", prams)); }
public int UpdateTeam(TeamManage teammanage) { SqlParameter[] prams = { data.MakeInParam("@teamid", SqlDbType.Int, 4, teammanage._TeamID), data.MakeInParam("@teamname", SqlDbType.NVarChar, 50, teammanage._TeamName), data.MakeInParam("@createtime", SqlDbType.DateTime, 8, teammanage._CreateTime), data.MakeInParam("@createrid", SqlDbType.UniqueIdentifier, 16, teammanage._CreaterID), data.MakeInParam("@createpos", SqlDbType.NVarChar, 50, teammanage._CreatePos), data.MakeInParam("@teamtitle", SqlDbType.NVarChar, 50, teammanage._TeamTitle), data.MakeInParam("@createcontent", SqlDbType.NVarChar, 2000, teammanage._CreateContent), data.MakeInParam("@dateline", SqlDbType.DateTime, 8, teammanage._DateLine), data.MakeInParam("@maxnum", SqlDbType.Int, 4, teammanage._MaxNum), data.MakeInParam("@presentnum", SqlDbType.Int, 4, teammanage._PresentNum), data.MakeInParam("@attention", SqlDbType.Int, 4, teammanage._Attention), data.MakeInParam("@image", SqlDbType.NVarChar, 50, teammanage._Image), data.MakeInParam("@classid", SqlDbType.Int, 4, teammanage._ClassID), data.MakeInParam("@isvisible", SqlDbType.Bit, 1, teammanage._IsVisible), data.MakeInParam("@state", SqlDbType.Bit, 1, teammanage._State), }; return(data.RunProc("update aspnet_Team set TeamName = @teamname, CreateTime = @createtime,CreaterID = @createrid,CreatePos= @createpos,TeamTitle = @teamtitle,CreateContent = @createcontent,DateLine = @dateline,MaxNum = @maxnum,PresentNum = @presentnum,Attention = @attention,Image = @image,ClassID = @classid,IsVisible = @isvisible, State = @state where TeamID = @teamid", prams)); }