/// <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)); }