/// 根据--状态--得到话题信息
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));
}
