Ejemplo n.º 1
0
    //添加分类
    protected void btnSubAdd_Click(object sender, EventArgs e)
    {
        string category = txtCategory.Text;

        if (category.Length == 0)
        {
            JSHelper.ShowAlert("输入不能为空!");
        }
        else if (DevelopHelper.checkCategoryNameExit(category))
        {
            JSHelper.ShowAlert("该分类已存在!");
        }
        else
        {
            using (var db = new TeachingCenterEntities())
            {
                var cate = new DevelopCategory();
                cate.DevelopCategory_name = category;
                db.DevelopCategory.Add(cate);
                db.SaveChanges();
                Server.Transfer("DevelopCategoryManage.aspx");
                //                JSHelper.AlertThenRedirect("添加成功!", "DevelopCategoryManage.aspx");
            }
        }
    }
Ejemplo n.º 2
0
 static public string getCategoryName(int id)
 {
     using (var db = new TeachingCenterEntities())
     {
         DevelopCategory ac = db.DevelopCategory.Single(a => a.DevelopCategory_id == id);
         return(ac.DevelopCategory_name);
     }
 }
Ejemplo n.º 3
0
 static public int getCategoryId(string name)
 {
     using (var db = new TeachingCenterEntities())
     {
         DevelopCategory ac = db.DevelopCategory.Single(a => a.DevelopCategory_name == name);
         return(ac.DevelopCategory_id);
     }
 }
Ejemplo n.º 4
0
    //批量删除
    protected void btnDelete_Click(object sender, EventArgs e)
    {
        using (var db = new TeachingCenterEntities())
        {
            int count = 0;
            for (int i = 0; i < this.rptCategory.Items.Count; i++)
            {
                CheckBox cbx = (CheckBox)rptCategory.Items[i].FindControl("chbCheck");
                if (cbx != null)
                {
                    if (cbx.Checked == true)
                    {
                        count++;
                    }
                }
            }

            var list = from it in db.DevelopCategory select it;
            if (list.Count() == count)
            {
                JSHelper.ShowAlert("请至少留有一个分类!");
            }
            else
            {
                for (int i = 0; i < this.rptCategory.Items.Count; i++)
                {
                    CheckBox cbx  = (CheckBox)rptCategory.Items[i].FindControl("chbCheck");
                    string   name = ((Literal)rptCategory.Items[i].FindControl("ltName")).Text;
                    if (cbx != null)
                    {
                        if (cbx.Checked == true)
                        {
                            DevelopCategory sc = db.DevelopCategory.Single(a => a.DevelopCategory_name == name);
                            db.DevelopCategory.Remove(sc);
                            db.SaveChanges();
                        }
                    }
                }
                // JSHelper.AlertThenRedirect("删除成功!", "DevelopCategoryManage.aspx");
                Server.Transfer("DevelopCategoryManage.aspx");
            }
        }
    }
Ejemplo n.º 5
0
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            string teacher = Session["AdminID"].ToString();
            if (!IsPostBack)
            {
                using (var db = new TeachingCenterEntities())
                {
                    //绑定下拉框
                    var category = from it in db.DevelopCategory select it;

                    List <DevelopCategory> cate = category.ToList();

                    DevelopCategory all = new DevelopCategory();

                    cate.Insert(0, all);

                    all.DevelopCategory_id = 0;

                    all.DevelopCategory_name = "全部分类";

                    dropCategory.DataSource = cate;

                    dropCategory.DataTextField = "DevelopCategory_name";

                    dropCategory.DataBind();

                    //绑定列表信息
                    DataBindToRepeater(1);
                }
            }
        }
        catch
        {
            JSHelper.AlertThenRedirect("请先登录!", "Login.aspx");
        }
    }
Ejemplo n.º 6
0
 //修改分类
 protected void btnChange_Click(object sender, EventArgs e)
 {
     if (txtChange.Text.Length == 0)
     {
         JSHelper.ShowAlert("输入不能为空!");
     }
     else if (DevelopHelper.checkCategoryNameExit(txtChange.Text))
     {
         JSHelper.ShowAlert("该分类已存在!");
     }
     else
     {
         using (var db = new TeachingCenterEntities())
         {
             int             id = Convert.ToInt32(lbID.Text);
             DevelopCategory sc = db.DevelopCategory.Single(a => a.DevelopCategory_id == id);
             sc.DevelopCategory_name = txtChange.Text;
             db.SaveChanges();
             //JSHelper.AlertThenRedirect("修改成功!", "DevelopCategoryManage.aspx");
             Server.Transfer("DevelopCategoryManage.aspx");
         }
     }
 }
Ejemplo n.º 7
0
    protected void rptCategory_ItemCommand(object source, RepeaterCommandEventArgs e)
    {
        //删除专题分类
        if (e.CommandName == "Delete")
        {
            int id = Convert.ToInt32(e.CommandArgument.ToString());
            using (var db = new TeachingCenterEntities())
            {
                var list = from it in db.DevelopCategory select it;
                if (list.Count() == 1)
                {
                    JSHelper.ShowAlert("已经是最后一个分类了!");
                }
                else
                {
                    DevelopCategory sc = db.DevelopCategory.Single(a => a.DevelopCategory_id == id);
                    db.DevelopCategory.Remove(sc);
                    db.SaveChanges();
                    Server.Transfer("DevelopCategoryManage.aspx");
//                    JSHelper.AlertThenRedirect("删除成功!", "DevelopCategoryManage.aspx");
                }
            }
        }
        //修改分类
        if (e.CommandName == "Editor")
        {
            int id = Convert.ToInt32(e.CommandArgument.ToString());
            lbID.Text = id.ToString();
            using (var db = new TeachingCenterEntities())
            {
                DevelopCategory sc = db.DevelopCategory.Single(a => a.DevelopCategory_id == id);
                txtChange.Text = sc.DevelopCategory_name;
            }
            divEditor.Visible = true;
        }
    }