jibie.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;

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.JIBIE.FindAll(Expression.Eq("JBDELETELAG", false), Expression.Eq("JBID", decimal.Parse(ddlNian.SelectedValue)));
       GridView1.DataSource = ilst;
        GridView1.DataBind();
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        Server.Transfer("JBadd.aspx?JBID=ADD");
    }
    public void INit()
    {

        ilst = JPKC.DAL.WLDXT.JIBIE.FindAll(Expression.Eq("JBDELETELAG", false));
        GridView1.DataSource = ilst;
        GridView1.DataBind();

        ddlNian.DataSource = JPKC.DAL.WLDXT.JIBIE.FindAll(Expression.Eq("JBDELETELAG", false));
        ddlNian.DataTextField = "JBName";
        ddlNian.DataValueField = "JBID";
        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.JIBIE jb = JPKC.DAL.WLDXT.JIBIE.Find(decimal.Parse(GridView1.DataKeys[i].Value.ToString()));
                    jb.JBDELETELAG = true;
                    jb.Update();
               
                    lMsg.Text = "删除成功";
                }
                catch 
                {
                    lMsg.Text = "删除失败";
                }
            }
        }
        lMsg.ForeColor = System.Drawing.Color.Red;
        lMsg.Visible = true;

        INit();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.DataSource = ilst;
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataBind();
    }
}