一个 NHIBERNATE+GRIDVIEW 添加删除修改的例子(单表)

点击这里下载



aspx：

<% @ Page Language = " C# "  AutoEventWireup = " true "   CodeFile = " Default.aspx.cs "  Inherits = " _Default "   %>

<! DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" >

< html  xmlns ="http://www.w3.org/1999/xhtml"   >
< head  runat ="server" >
     < title > 无标题页 </ title >
</ head >
< body >
     < form  id ="form1"  runat ="server" >
     < div >
         < asp:Button  ID ="btn_INSERT"  runat ="server"  OnClick ="btn_INSERT_Click"  Text ="INSERT"   />< br  />
         < asp:GridView  ID ="GridView1"  runat ="server"  BackColor ="White"  BorderColor ="#DEDFDE"  BorderStyle ="None"  BorderWidth ="1px"  CellPadding ="4"  Font-Names ="Arial"  Font-Size ="9pt"  ForeColor ="Black"  GridLines ="Vertical"  OnRowDeleting ="GridView1_RowDeleting"  OnRowEditing ="GridView1_RowEditing"  OnRowUpdating ="GridView1_RowUpdating"  AutoGenerateColumns ="False"  DataKeyNames ="ID"  OnRowCancelingEdit ="GridView1_RowCancelingEdit" >
             < FooterStyle  BackColor ="#CCCC99"   />
             < RowStyle  BackColor ="#F7F7DE"   />
             < SelectedRowStyle  BackColor ="#CE5D5A"  Font-Bold ="True"  ForeColor ="White"   />
             < PagerStyle  BackColor ="#F7F7DE"  ForeColor ="Black"  HorizontalAlign ="Right"   />
             < HeaderStyle  BackColor ="#6B696B"  Font-Bold ="True"  ForeColor ="White"   />
             < AlternatingRowStyle  BackColor ="White"   />
             < Columns >
             < asp:BoundField  DataField ="UserID"  HeaderText ="UserID" />
             < asp:BoundField  DataField ="Message"  HeaderText ="Message" />
             < asp:BoundField  DataField ="CreateTime"  HeaderText ="CreateTime"  ReadOnly ="True" />
             < asp:CommandField  CancelText ="CANCEL"  UpdateText ="UPDATE"  EditText ="EDIT"  DeleteText ="DELETE"  ShowDeleteButton ="True"  ShowEditButton ="True" />
             </ Columns >
         </ asp:GridView >
    
     </ div >
     </ form >
</ body >
</ html >

aspx.cs

using  System;
using  System.Data;
using  System.Configuration;
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  System.Collections;

public  partial  class  _Default : System.Web.UI.Page 
{
     protected   void  Page_Load( object  sender, EventArgs e)
    {
         if  ( ! IsPostBack)
        {
            SetBind();
        }
    }
     private   void  SetBind()
    {
        CUID.GuestMessageCUID gm  =   new  CUID.GuestMessageCUID();
         this .GridView1.DataSource  =  gm.GetGuestMessage();
         this .GridView1.DataBind();
    }
     protected   void  btn_INSERT_Click( object  sender, EventArgs e)
    {
        CUID.GuestMessageCUID gm  =   new  CUID.GuestMessageCUID();
        IList list  =  gm.GetGuestMessage();
        list.Insert( 0 ,  new  DataEntity.GuestMessage());
         this .GridView1.EditIndex  =   0 ;
         this .GridView1.DataSource  =  list;
         this .GridView1.DataBind();  
    }

     protected   void  GridView1_RowDeleting( object  sender, GridViewDeleteEventArgs e)
    {
        GridViewRow gvr  =   this .GridView1.Rows[e.RowIndex];
         object  AutoID  =   this .GridView1.DataKeys[e.RowIndex].Value;
        DataEntity.GuestMessage gmentity  =   new  DataEntity.GuestMessage();
         if  (AutoID  !=   null )
        {
            gmentity.Id  =  AutoID.ToString();
            CUID.GuestMessageCUID gm  =   new  CUID.GuestMessageCUID();
            gm.DeleteGuestMessage(gmentity);
            SetBind();
        }
       
    }

     protected   void  GridView1_RowEditing( object  sender, GridViewEditEventArgs e)
    {
         this .GridView1.EditIndex  =  e.NewEditIndex;
        SetBind();
    }

     protected   void  GridView1_RowUpdating( object  sender, GridViewUpdateEventArgs e)
    {
        CUID.GuestMessageCUID gm  =   new  CUID.GuestMessageCUID();
        GridViewRow gvr  =   this .GridView1.Rows[e.RowIndex];
        TextBox tbUserID  =  gvr.Cells[ 0 ].Controls[ 0 ]  as  TextBox;
        TextBox tbMessage  =  gvr.Cells[ 1 ].Controls[ 0 ]  as  TextBox;
         object  AutoID  =   this .GridView1.DataKeys[e.RowIndex].Value;
        DataEntity.GuestMessage gmentity  =   new  DataEntity.GuestMessage();
        gmentity.UserID  =  tbUserID.Text;
        gmentity.Message  =  tbMessage.Text;
         if  (AutoID  ==   null )
        {
            gmentity.CreateTime  =  DateTime.Now;
            gm.AddGuestMessage(gmentity);
        }
         else
        {
            gmentity.Id  =  AutoID.ToString();
            gmentity.CreateTime  =  DateTime.Parse(gvr.Cells[ 2 ].Text);
            gm.UpdateGuestMessage(gmentity);
        }
         this .GridView1.EditIndex  =   - 1 ;
        SetBind();
    }
     protected   void  GridView1_RowCancelingEdit( object  sender, GridViewCancelEditEventArgs e)
    {
         this .GridView1.EditIndex  =   - 1 ;
        SetBind();
    }
}

cuid.cs

using  System;
using  System.Collections.Generic;
using  System.Text;
using  System.Collections;
using  DataHelper;
using  System.Data;

namespace  CUID
{
     public   class  GuestMessageCUID
    {
         private  EntityControl control;

         public  GuestMessageCUID()
        {
            control  =  EntityControl.CreateEntityControl( " DataEntity " );
        }

         public  IList GetGuestMessage()
        {
             return  control.GetEntities( " from DataEntity.GuestMessage " );
        }

         public   void  AddGuestMessage(DataEntity.GuestMessage gm)
        {
            control.AddEntity(gm);
        }

         public   void  UpdateGuestMessage(DataEntity.GuestMessage gm)
        {
            control.UpdateEntity(gm,gm.Id);
        }

         public   void  DeleteGuestMessage(DataEntity.GuestMessage gm)
        {
            control.DeleteEntity(gm);
        }
    }
}

datahelper.cs

using  System;
using  System.Collections.Generic;
using  System.Text;
using  System.Collections;
using  NHibernate;
using  NHibernate.Cfg;
using  System.Data;

namespace  DataHelper
{
     public   class  SessionFactory
    {
         private   static  ISessionFactory sessions;
         private   static  Configuration cfg;
         static   readonly   object  padlock  =   new   object ();
         public   static  ISession OpenSession( string  AssemblyName)
        {
             if  (sessions  ==   null )
            {
                 lock  (padlock)
                {
                     if  (sessions  ==   null )
                    {
                        BuildSessionFactory(AssemblyName);
                    }
                }
            }
             return  sessions.OpenSession();
        }

         private   static   void  BuildSessionFactory( string  AssemblyName)
        {
            cfg  =   new  Configuration();
            cfg.AddAssembly(AssemblyName);
            sessions  =  cfg.BuildSessionFactory();
        }
    }

     public   class  EntityControl
    {
         private   static  EntityControl entity;
         private   string  _AssemblyName;
         static   readonly   object  padlock  =   new   object ();
         public   static  EntityControl CreateEntityControl( string  AssemblyName)
        {
             if  (entity  ==   null )
            {
                 lock  (padlock)
                {
                     if  (entity  ==   null )
                    {
                        entity  =   new  EntityControl();
                        entity._AssemblyName  =  AssemblyName;
                    }
                }
            }
             return  entity;

        }

         public   void  AddEntity(Object entity)
        {
            ISession session  =  SessionFactory.OpenSession(_AssemblyName);
            ITransaction transaction  =  session.BeginTransaction();
             try
            {
                session.Save(entity);
                transaction.Commit();
            }

             catch  (Exception ex)
            {
                transaction.Rollback();
                 throw  ex;
            }
             finally
            {
                session.Close();
            }
        }

         public   void  UpdateEntity(Object entity ,Object key)
        {
            ISession session  =  SessionFactory.OpenSession(_AssemblyName);
            ITransaction transaction  =  session.BeginTransaction();
             try
            {
                session.Update(entity);
                transaction.Commit();
            }
             catch  (Exception ex)
            {
                transaction.Rollback();
                 throw  ex;
            }
             finally
            {
                session.Close();
            }
        }

         public   void  DeleteEntity( object  entity)
        {
            ISession session  =  SessionFactory.OpenSession(_AssemblyName);
            ITransaction transaction  =  session.BeginTransaction();
             try
            {
                session.Delete(entity);
                transaction.Commit();
            }
             catch  (Exception ex)
            {
                transaction.Rollback();
                 throw  ex;
            }
             finally
            {
                session.Close();
            }
        }

         public  IList GetEntities( string  strHQL)
        {
            IList list;
            ISession session  =  SessionFactory.OpenSession(_AssemblyName);
            list  =  session.Find(strHQL);
            session.Close();
             return  list;
        }
    }
}

实体

using  System;
using  System.Collections;

namespace  DataEntity
{
     #region  GuestMessage

     ///   <summary>
     ///  GuestMessage object for NHibernate mapped table 'GuestMessage'.
     ///   </summary>
     public   class  GuestMessage
    {
         #region  Member Variables
        
         protected   string  _id;
         protected   string  _userID;
         protected   string  _message;
         protected  DateTime _createTime;

         #endregion

         #region  Constructors

         public  GuestMessage() { }

         public  GuestMessage(  string  userID,  string  message, DateTime createTime )
        {
             this ._userID  =  userID;
             this ._message  =  message;
             this ._createTime  =  createTime;
        }

         #endregion

         #region  Public Properties

         public   string  Id
        {
             get  { return  _id;}
             set
            {
                 if  ( value  !=   null   &&  value.Length  >   50 )
                     throw   new  ArgumentOutOfRangeException( " Invalid value for Id " , value, value.ToString());
                _id  =  value;
            }
        }

         public   string  UserID
        {
             get  {  return  _userID; }
             set
            {
                 if  ( value  !=   null   &&  value.Length  >   50 )
                     throw   new  ArgumentOutOfRangeException( " Invalid value for UserID " , value, value.ToString());
                _userID  =  value;
            }
        }

         public   string  Message
        {
             get  {  return  _message; }
             set
            {
                 if  ( value  !=   null   &&  value.Length  >   16 )
                     throw   new  ArgumentOutOfRangeException( " Invalid value for Message " , value, value.ToString());
                _message  =  value;
            }
        }

         public  DateTime CreateTime
        {
             get  {  return  _createTime; }
             set  { _createTime  =  value; }
        }

        

         #endregion
    }
     #endregion
}

实体xml

<? xml version="1.0" encoding="utf-8"  ?>
< hibernate-mapping  xmlns ="urn:nhibernate-mapping-2.0" >
     < class  name ="DataEntity.GuestMessage, DataEntity"  table ="GuestMessage" >
         < id  name ="Id"  type ="String"  unsaved-value ="null" >
             < column  name ="AutoID"  length ="50"  sql-type ="varchar"  not-null ="true"  unique ="true"  index ="PK_Message" />
             < generator  class ="identity"   />
         </ id >
         < property  name ="UserID"  type ="String" >
             < column  name ="UserID"  length ="50"  sql-type ="varchar"  not-null ="false" />
         </ property >
         < property  name ="Message"  type ="String" >
             < column  name ="Message"  length ="16"  sql-type ="text"  not-null ="false" />
         </ property >
         < property  name ="CreateTime"  type ="DateTime" >
             < column  name ="CreateTime"  length ="8"  sql-type ="datetime"  not-null ="false" />
         </ property >
     </ class >
</ hibernate-mapping >