public static int DeleteItem(M_Item item)
{
int count = D_Class.GetItemcount(item.Item_ID);
if (count > 0)
{
HttpContext.Current.Response.Write("<script>alert('删除失败！所属栏目下有记录！')</script>");
return(-1);
}
else
{
string strsql = "delete Item where Item_ID=@Item_ID ";
SqlParameter[] comSql = new SqlParameter[]
{
new SqlParameter("@Item_ID", item.Item_ID),
};
return(DBHelper.IDUTable(strsql, comSql));
}
}
public static List <M_Class> SelectClass(M_Admin admin)
{
if (admin.Power == 0)
{
string strsql = string.Format("select Class.* from Class,Popedom where Class.Class_ID=Popedom.Class_ID and Popedom.Admin_ID={0}", admin.Admin_ID);
List <M_Class> listClass = new List <M_Class>();
using (SqlDataReader dr = DBHelper.SelectTable(strsql))
{
while (dr.Read())
{
listClass.Add(D_Class.GetClass(dr));
}
}
return(listClass);
}
else
{
return(D_Class.SelectClass());
}
}
public static void DeleteClass(M_Class newsclass)
{
D_Class.DeleteClass(newsclass);
}
public static void UpdateClass(M_Class newsclass)
{
D_Class.UpdateClass(newsclass);
}
public static List <M_Class> SelectClass()
{
return(D_Class.SelectClass());
}
public static bool InsertClass(M_Class newsclass)
{
int count = D_Class.InsertClass(newsclass);
return(count > 0 ? true : false);
}
