TaoBaoKe.SQLServerDal/FavouriteDal.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Text;
using TaoBaoKe.Model;
using TaoBaoKe.IDal;
using NHibernate;

namespace TaoBaoKe.SQLServerDal
{
    public class FavouriteDal:IFavouriteDal
    {
        private EntityControl control; //add by luzi 6-22
        public FavouriteDal()
        {
            control = EntityControl.CreateEntityControl();
        }
        public bool Add(Favourite obj)
        {
            return control.AddEntity(obj);
        }
        public bool Update(Favourite obj)
        {
            return control.UpdateEntity(obj);
        }
        public bool Delete(int _id)
        {
            string strHql = string.Format("from Favourite where Iid = {0}", _id);
            return control.DeleteEntity(strHql);
        }
        public object GetScalar(string queryString, bool useSql, IDictionary namedParas)//自增量
        {
            return control.GetScalar(queryString, useSql, namedParas);
        }
        public Favourite GetModel(int Iid)
        {
            IDictionary hash = new Hashtable();
            hash.Add("Iid", Iid);
            return (Favourite)control.GetEntity("From Favourite where Iid=:Iid", hash);
        }
        public IList GetList(string where, string orderBy, IDictionary namedParas)
        {
            return control.GetEntities("Favourite", where, orderBy, namedParas);
        }
        public IList GetList(string where, string orderBy, IDictionary namedParas, int pageIndex, int pageSize, out int recordCount)
        {
            return control.GetEntities("Favourite", where, orderBy, namedParas, pageIndex, pageSize, out recordCount);
        }
    }
}