nian.aspx.cs

系统使用VS2005编写 数据库 使用SQL server 2000 或 SQL server 2005 测试前请先修改app.config 或web.config 的数据库连接字符串

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 NHibernate.Expression;
using Castle.ActiveRecord;

public partial class Nian : System.Web.UI.Page
{
   static IList ilst;
    protected void Page_Load(object sender, EventArgs e)
    {
        lMsg.Visible = false;
        btnDel.Attributes.Add("onclick", "javascript:return WhetherSelect()");
        if (!IsPostBack)
        {
            INit(); 
        }

    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowIndex != -1)
        {
            int id = e.Row.RowIndex + 1;
            e.Row.Cells[1].Text = id.ToString();
           
        }
    }
    protected void btnQuery_Click(object sender, EventArgs e)
    {

        ilst = JPKC.DAL.WLDXT.XUENIAN.FindAll(Expression.Eq("XNDELETELAG", false), Expression.Eq("XNID", int.Parse(ddlNian.SelectedValue)));
        GridView1.DataSource = ilst;
        GridView1.DataBind();
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        Server.Transfer("XNadd.aspx?XNID=ADD");
        
    }
    public void INit()
    {


        ilst = JPKC.DAL.WLDXT.XUENIAN.FindAll(Expression.Eq("XNDELETELAG", false));
        GridView1.DataSource = ilst;
        GridView1.DataBind();
        ddlNian.DataSource = JPKC.DAL.WLDXT.XUENIAN.FindAll(Expression.Eq("XNDELETELAG", false));
        ddlNian.DataTextField = "XNName";
        ddlNian.DataValueField = "XNID";
        ddlNian.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.XUENIAN xu =JPKC .DAL .WLDXT.XUENIAN .Find (int .Parse ( GridView1.DataKeys[i].Value.ToString()));
                  xu.XNDELETELAG =true ;
                  xu.Update ();
           
               
                    lMsg.Text = "删除成功";
                }
                catch 
                {
                    lMsg.Text = "删除失败";
                }
            }
        }
        lMsg.Visible = true;
        INit();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.DataSource = ilst;
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataBind();
    }
}