kecheng.aspx.cs

四川某学院的精品课管理系统,有学年管理、级别管理和课程管理

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using Castle.ActiveRecord;
using Castle.ActiveRecord.Queries;
using JPKC.DAL.WLDXT;
using NHibernate.Expression;

public partial class KeC : System.Web.UI.Page 
{
    static IList ilst;
    protected void Page_Load(object sender, EventArgs e)
    {
         
        lblMsg.Visible = false;
        btnDel.Attributes.Add("onclick", "javascript:return WhetherSelect()");
        if (!IsPostBack)
        {
            ilst = JPKC.DAL.WLDXT.KECHENG.FindAll(Expression.Eq("KCDELETELAG", false));
            GridView1.DataSource = ilst;
            GridView1.DataBind();
            ddlNian.Items.Clear();
              
            ddlNian.Items.Add(new ListItem("-请选择-", "0"));
            ddlNian.DataSource = JPKC.DAL.WLDXT.XUENIAN.FindAll(Expression.Eq("XNDELETELAG", false));
            ddlNian.DataTextField = "XNName";
            ddlNian.DataValueField = "XNID";
            ddlNian.DataBind();


            ddlJIBie.Items.Clear();
            ddlJIBie.Items.Add(new ListItem("-请选择-", "0"));
            ddlJIBie.DataSource = JPKC.DAL.WLDXT.JIBIE.FindAll(Expression.Eq("JBDELETELAG", false));
            ddlJIBie.DataTextField = "JBName";
            ddlJIBie.DataValueField = "JBID";
            ddlJIBie.DataBind();

        }
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        Response.Redirect("addKC.aspx?KCID=ADD");
        
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        SimpleQuery query = new SimpleQuery(typeof(KECHENG), @"from KECHENG k  where k.KCDELETELAG = ? and ( k.XUENIAN.XNID = ? or ? = 0) and  ( k.JIBIE.JBID = ? or ? = 0 ) ",false,
                    int.Parse(ddlNian.SelectedValue), int.Parse(ddlNian.SelectedValue),
                    decimal.Parse(ddlJIBie.SelectedValue), decimal.Parse(ddlJIBie.SelectedValue));
        //SimpleQuery query = new SimpleQuery(typeof(KECHENG), @"from KECHENG k  where k.KCName = ?", "C++");
        ilst = (JPKC.DAL.WLDXT.KECHENG[])JPKC.DAL.WLDXT.KECHENG.ExecuteQuery(query);
        GridView1.DataSource = ilst;
        GridView1.DataBind();
    }
    protected void btnDel_Click(object sender, EventArgs e)
    {
        
        for (int i = 0; i < this.GridView1.Rows.Count; i++)
        {
            bool ischecked = ((CheckBox)GridView1.Rows[i].FindControl("chkSel")).Checked;
            if (ischecked)
            {

                try 
                {
                    
                    JPKC.DAL.WLDXT.KECHENG kc = JPKC.DAL.WLDXT.KECHENG.Find( decimal.Parse(GridView1.DataKeys[i].Value.ToString()));
                    kc.KCDELETELAG = true;
                    kc.Update();
                    lblMsg.Text = "删除成功";
                }
                catch 
                {
                    lblMsg.Text = "删除失败";
                }
            }
        }
        lblMsg.ForeColor = System.Drawing.Color.Red;
        lblMsg.Visible = true;
        ilst = JPKC.DAL.WLDXT.KECHENG.FindAll(Expression.Eq("KCDELETELAG", false));
        GridView1.DataSource = ilst;
        GridView1.DataBind();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataSource = ilst;
        GridView1.DataBind();
    }
}