/// <summary>
/// 删除--分类信息
/// </summary>
/// <param name="classmanage"></param>
/// <returns></returns>
public int DeleteClass(ClassManage classmanage)
{
SqlParameter[] prams =
{
data.MakeInParam("@classid", SqlDbType.Int, 4, classmanage._ClassID),
};
return(data.RunProc("delete from aspnet_Class where ClassID=@classid", prams));
}
/// <summary>
/// 根据--分类名称--得到分类信息
/// </summary>
/// <param name="classmanage"></param>
/// <param name="tbName"></param>
/// <returns></returns>
public DataSet FindClassByName(ClassManage classmanage, string tbName)
{
SqlParameter[] prams =
{
data.MakeInParam("@classname", SqlDbType.NVarChar, 50, "%" + classmanage._ClassName + "%"),
};
return(data.RunProcReturn("select * from aspnet_Class where ClassName like @classname", prams, tbName));
}
/// <summary>
/// 根据--分类编号--得到分类信息
/// </summary>
/// <param name="classmanage"></param>
/// <param name="tbName"></param>
/// <returns></returns>
public DataSet FindClassByID(ClassManage classmanage, string tbName)
{
SqlParameter[] prams =
{
data.MakeInParam("@classid", SqlDbType.Int, 4, classmanage._ClassID),
};
return(data.RunProcReturn("select * from aspnet_Class where ClassID = @classid", prams, tbName));
}
/// <summary>
/// 修改--分类信息
/// </summary>
/// <param name="classmanage"></param>
/// <returns></returns>
public int UpdateClass(ClassManage classmanage)
{
SqlParameter[] prams =
{
data.MakeInParam("@classid", SqlDbType.Int, 4, classmanage._ClassID),
data.MakeInParam("@classname", SqlDbType.NVarChar, 50, classmanage._ClassName),
};
return(data.RunProc("update aspnet_Class set ClassName =@classname where ClassID=@classid", prams));
}
/// <summary>
/// 添加--分类信息
/// </summary>
/// <param name="classmanage"></param>
/// <returns></returns>
public int AddClass(ClassManage classmanage)
{
SqlParameter[] prams =
{
data.MakeInParam("@classid", SqlDbType.Int, 4, classmanage._ClassID),
data.MakeInParam("@classname", SqlDbType.NVarChar, 50, classmanage._ClassName),
};
return(data.RunProc("INSERT INTO aspnet_Class (ClassID,ClassName) VALUES (@classid,@classname)", prams));
}
