// 添加联系人 public void AddLinkman(Linkman linkman) { NHibernateHelper helper = new NHibernateHelper(); ISession Session = helper.GetSession(); if (linkman != null) Session.Save(linkman); }
// 添加用户 public void AddUser(User user) { NHibernateHelper helper = new NHibernateHelper(); ISession Session = helper.GetSession(); string useremail; if(user != null) useremail = (string)Session.Save(user); // return useremail; }
private YnDaoHelper(NHibernateType nHibernateType, string configFileName, XmlReader xmlReader, string connection_string, Assembly[] assemblys) { try { nHibernateHelper = new NHibernateHelper(nHibernateType,configFileName, xmlReader, connection_string, assemblys); } catch (Exception ex) { throw ex; } }
private YnDaoHelper(NHibernateType nHibernateType, XmlReader xmlReader, string connection_string) { try { nHibernateHelper = new NHibernateHelper(nHibernateType, xmlReader, connection_string, null); } catch (Exception ex) { throw ex; } }
private YnDaoHelper(NHibernateType nHibernateType,string configFileName, Assembly[] assemblys) { try { nHibernateHelper = new NHibernateHelper(nHibernateType,configFileName, null, null, assemblys); } catch (Exception ex) { throw ex; } }
private YnDaoHelper(NHibernateType nHibernateType, string configFileName) { try { nHibernateHelper = new NHibernateHelper(nHibernateType, configFileName); } catch (Exception ex) { throw ex; } }
/// <summary> /// 根据条件得到客户信息集合 /// </summary> /// <param name="where">条件</param> /// <returns>客户信息集合</returns> public IList<UserProfile> GetUserProfileList(Expression<Func<UserProfile, bool>> where) { try { NHibernateHelper nhibernateHelper = new NHibernateHelper(); ISession session = nhibernateHelper.GetSession(); return session.Query<UserProfile>().Where(where).ToList(); } catch (Exception ex) { throw ex; } }
//根据邮箱查询用户(status) public Email.Domain.Entities.User GetUserByEmail(string Email) { NHibernateHelper helper = new NHibernateHelper(); ISession session = helper.GetSession(); try { return session.Get<Email.Domain.Entities.User>(Email); } catch (Exception e) { throw e; } /* return session1.CreateCriteria(typeof(Email.Domain.Entities.User)) .Add(NHibernate.Criterion.Restrictions.Eq("Email", Email)) .List();*/ }
// 获取所有联系人信息 public IList<Linkman> GetAllLinkman() { NHibernateHelper helper = new NHibernateHelper(); ISession session = helper.GetSession(); // return session.CreateCriteria(typeof(LinkmanData)); try { ICriteria crit = session.CreateCriteria(typeof(Linkman)) .Add(NHibernate.Criterion.Restrictions.Eq("Sender", UserHelper.uEmail)); crit.SetMaxResults(50); IList<Linkman> linkmans = crit.List<Linkman>(); return linkmans; } catch (Exception e) { throw e; } }
public override void Load() { string connectionString = ConfigurationManager.ConnectionStrings["defaultconnection"].ConnectionString; NHibernateHelper helper = new NHibernateHelper(connectionString); Bind<ISessionFactory>().ToConstant(helper.SessionFactory) .InSingletonScope(); //Bind<IUnitOfWork>().To<UnitOfWork>().InRequestScope(); Bind<ISession>().ToProvider(new SessionProvider(helper.SessionFactory)).InRequestScope(); //Bind<SessionProvider>().ToSelf().Using<OnePerRequestBehavior>(); //Bind<ISession>().ToMethod(CreateSession).InRequestScope(); Bind<ITokenRepository>().To<TokenRepository>(); Bind<IUserRepository>().To<UserRepository>(); }
// 删除用户 /*public void DeleteUser(User user) { NHibernateHelper helper = new NHibernateHelper(); ISession session = helper.GetSession(); session.Delete(user); session.Flush(); }*/ public void UpdateUser(Object user) { NHibernateHelper helper = new NHibernateHelper(); ISession session = helper.GetSession(); ITransaction transaction = session.BeginTransaction(); try { session.Update(user); transaction.Commit(); } catch (Exception e ) { transaction.Rollback(); throw e; } finally { session.Close(); } }
// 删除单个联系人 public void DeleteLinkmanByReceiver(string receiver, string sender) { NHibernateHelper helper = new NHibernateHelper(); ISession session = helper.GetSession(); try { ICriteria crit1 = session.CreateCriteria(typeof(Email.Domain.Entities.Linkman)) .Add(NHibernate.Criterion.Restrictions.Eq("Sender", sender)) .Add(NHibernate.Criterion.Restrictions.Eq("Receiver", receiver)); crit1.SetMaxResults(50); IList<Linkman> linkman1 = crit1.List<Linkman>(); foreach (Linkman linkman in linkman1) { session.Delete(linkman); session.Flush(); } } catch (Exception e) { throw e; } }
// 删除所有联系人 public void DeleteAllLinkman() { // LinkmanData linkmandata = new LinkmanData(); NHibernateHelper helper = new NHibernateHelper(); ISession session = helper.GetSession(); try { ICriteria crit2 = session.CreateCriteria(typeof(Email.Domain.Entities.Linkman)) .Add(NHibernate.Criterion.Restrictions.Eq("Sender",UserHelper.uEmail)); crit2.SetMaxResults(50); IList<Linkman> linkman2 = crit2.List<Linkman>(); foreach (Linkman linkmans in linkman2) { session.Delete(linkmans); session.Flush(); } } catch (Exception e) { throw e; } }
public void AddUser(AddUserRequest request) { var isAdmin = _loginQueryDao.GetUser(request.Ticket).IsAdmin; if (!isAdmin) { throw new Exception("User is not admin therefore cannot add users"); } var taken = _userQuery.GetUsers().Count(x => x.Login == request.Login.Trim()); if (taken > 0) { throw new Exception("Login already in use"); } using (var session = NHibernateHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { var entity = new Users { IsAdmin = request.IsAdmin, Name = request.Name, Login = request.Login, Password = request.Password, Surname = request.Surname, Unit = new Unit { Id = request.UnitId } }; session.Save(entity); transaction.Commit(); } } }
public void deleteReferingSite(int siteId, string platform) { string forcd4 = System.Text.RegularExpressions.Regex.Replace("Flow Cytometry", @"\s+", ""); string forchemistry = System.Text.RegularExpressions.Regex.Replace("Bio Chemistry", @"\s+", ""); string forviralload = System.Text.RegularExpressions.Regex.Replace("PCR", @"\s+", ""); string forchemistry2 = System.Text.RegularExpressions.Regex.Replace("Clinical Chemistry", @"\s+", ""); string sql = ""; if (platform == "CD4" || platform == "FlowCytometry" || platform == forcd4) { sql = string.Format(" update site set CD4RefSite ='0' FROM Site WHERE SiteID={0}", siteId); } else if (platform == "Chemistry" || platform == forchemistry) { sql = string.Format(" update site set ChemistryRefSite ='0' FROM Site WHERE SiteID={0}", siteId); } else if (platform == "Chemistry" || platform == forchemistry2) { sql = string.Format(" update site set ChemistryRefSite ='0' FROM Site WHERE SiteID={0}", siteId); } else if (platform == "Hematology") { sql = string.Format(" update site set HematologyRefSite ='0' FROM Site WHERE SiteID={0}", siteId); } else if (platform == "Other") { sql = string.Format(" update site set OtherRefSite ='0' FROM Site WHERE SiteID={0}", siteId); } else if (platform == "ViralLoad" || platform == forviralload) { sql = string.Format(" update site set ViralLoadRefSite ='0' FROM Site WHERE SiteID={0}", siteId); } ISession session = NHibernateHelper.OpenSession(); IList result = session.CreateSQLQuery(sql). AddScalar("SiteId", NHibernateUtil.Int32).List(); }
// Obtiene un producto por ID public IList <TallaEN> getTallasPorTipo(int tipo) { IList <TallaEN> lista = new List <TallaEN>(); try { using (ISession session = NHibernateHelper.OpenSession()) using (ITransaction tr = session.BeginTransaction()) { TallaCAD tallaCAD = new TallaCAD(session); lista = tallaCAD.GetTallasPorTipo(tipo); tr.Commit(); } } catch (Exception ex) { throw ex; } return(lista); }
//заполняет справочник (коллекцию) единиц измерения из БД и возвращает его public ObservableCollection <Unit> GetUnits() { ObservableCollection <Unit> unitList; using (var session = NHibernateHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { var tmpList = session.QueryOver <Unit>().List(); transaction.Commit(); unitList = new ObservableCollection <Unit>(); foreach (Unit un in tmpList) { unitList.Add(un); } } } return(unitList); }
private IEnumerable <InvalidValue> MembersInvalidValues(object entity, string memberName, ICollection <object> activeTags) { // Property & Field Validation var membersValidators = membersToValidate.Where(mtv => memberName == null || mtv.Getter.Name.Equals(memberName)).ToArray(); if (memberName != null && membersValidators.Length == 0 && TypeUtils.GetPropertyOrField(entityType, memberName) == null) { throw new TargetException( string.Format("The property or field '{0}' was not found in class {1}", memberName, entityType.FullName)); } return(from mtv in membersValidators let member = mtv.Getter where NHibernateHelper.IsPropertyInitialized(entity, member.Name) let value = TypeUtils.GetMemberValue(entity, member) where IsValidationNeededByTags(activeTags, mtv.ValidatorDef.Tags) && NHibernateHelper.IsInitialized(value) let validator = mtv.ValidatorDef.Validator let constraintContext = new ConstraintValidatorContext(member.Name, defaultInterpolator.GetAttributeMessage(validator)) where !validator.IsValid(value, constraintContext) from invalidValue in new InvalidMessageTransformer(constraintContext, activeTags, entityType, member.Name, value, entity, mtv.ValidatorDef, defaultInterpolator, userInterpolator).Transform() select invalidValue); }
// Obtiene una entrada por ID public EntradaEN getEntradaPorId(int idEntrada) { EntradaEN entrada = null; EntradaCAD entradaCAD = null; try { using (ISession session = NHibernateHelper.OpenSession()) using (ITransaction tr = session.BeginTransaction()) { entradaCAD = new EntradaCAD(session); entrada = entradaCAD.ReadOID(idEntrada); tr.Commit(); } } catch (Exception ex) { throw ex; } return(entrada); }
public static bool Select() { using (var session = NHibernateHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { try { var result = session.Query <GrandParent>( ).ToList(); // session.Update(entity); //session.Get<T>(id); // session.Delete(entity); transaction.Commit(); } catch { transaction.Rollback(); throw; } } } return(false); }
public ActionResult Editar(int id, Categoria cat) { try { using (var session = NHibernateHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { var CategoriaEditar = session.Get <Categoria>(id); CategoriaEditar.descricao = cat.descricao; CategoriaEditar.slug = GerarSlug.GerarSlugTexto(cat.descricao); session.SaveOrUpdate(CategoriaEditar); transaction.Commit(); } return(RedirectToAction("Index")); } } catch { return(View()); } }
// Devuelve todos los usuario public System.Collections.Generic.IList <UsuarioEN> getUsuarios() { System.Collections.Generic.IList <UsuarioEN> en = null; UsuarioCAD usuarioCAD = null; try { using (ISession session = NHibernateHelper.OpenSession()) using (ITransaction tr = session.BeginTransaction()) { usuarioCAD = new UsuarioCAD(session); en = usuarioCAD.GetUsuarios(); tr.Commit(); } } catch (Exception ex) { throw ex; } return(en); }
// Obtiene un producto por ID public ProductoEN getProductoPorId(int idProducto) { ProductoEN producto = null; ProductoCAD productoCAD = null; try { using (ISession session = NHibernateHelper.OpenSession()) using (ITransaction tr = session.BeginTransaction()) { productoCAD = new ProductoCAD(session); producto = productoCAD.ReadOID(idProducto); tr.Commit(); } } catch (Exception ex) { throw ex; } return(producto); }
public System.Collections.Generic.IList <AbonoEN> getAbonosTienda() { System.Collections.Generic.IList <AbonoEN> en = null; AbonoCAD abonoCAD = null; try { using (ISession session = NHibernateHelper.OpenSession()) using (ITransaction tr = session.BeginTransaction()) { abonoCAD = new AbonoCAD(session); en = abonoCAD.GetAbonos(); tr.Commit(); } } catch (Exception ex) { throw ex; } return(en); }
public System.Collections.Generic.IList <EntradaEN> getEntradasTienda() { System.Collections.Generic.IList <EntradaEN> en = null; EntradaCAD entradaCAD = null; try { using (ISession session = NHibernateHelper.OpenSession()) using (ITransaction tr = session.BeginTransaction()) { entradaCAD = new EntradaCAD(session); en = entradaCAD.GetEntradas(); tr.Commit(); } } catch (Exception ex) { throw ex; } return(en); }
public ActionResult Create(FormCollection collection) { try { // TODO: Add insert logic here UserRole role = new UserRole(); role.Name = collection.Get("Name"); role.CanEditPersonal = Convert.ToBoolean(collection["CanEditPersonal"]); role.CanEditReference = Convert.ToBoolean(collection["CanEditReference"]); role.CanEditUsers = Convert.ToBoolean(collection["CanEditUsers"]); using (ISession session = NHibernateHelper.OpenSession()) { ITransaction tr = session.BeginTransaction(); session.Save(role); tr.Commit(); } return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Incluir(Categoria cat) { try { using (var session = NHibernateHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { Categoria categoriaNova = new Categoria(); categoriaNova.descricao = cat.descricao; categoriaNova.slug = GerarSlug.GerarSlugTexto(cat.descricao); session.SaveOrUpdate(categoriaNova); transaction.Commit(); } return(RedirectToAction("Index")); } } catch { return(View()); } }
public ActionResult Edit(int id, Anexos anexo) { try { using (NHibernate.ISession session = NHibernateHelper.AbreSessao()) { var anexoAlterado = session.Get<Anexos>(id); anexoAlterado.Id = anexo.Id; anexoAlterado.Caminho_Arquivo = anexo.Caminho_Arquivo; anexoAlterado._Tarefa = anexo._Tarefa; using (ITransaction transacao = session.BeginTransaction()) { session.Save(anexoAlterado); transacao.Commit(); } } return RedirectToAction(nameof(Index)); } catch { return View(); } }
public static T Save(T record, bool saveToCache = true) { if (record == null) return null; using (ISession session = NHibernateHelper.GetSession()) using (ITransaction transaction = session.BeginTransaction()) { session.Save(record); transaction.Commit(); if (record is IRecord<K>) { record = GetByID(((IRecord<K>)record).RecordId); } //NHibernateHelper.InitializeNHibernate(record); if (record != null && saveToCache) record.SaveToCache(); return record; } }
public object Put(AddLocation request) { AddLocationValidator.ValidateAndThrow(request); using (var session = NHibernateHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { var location = new LocationModel(); location.User = session.Get <UserModel>(request.UserId); location.Timestamp = DateTime.Now.ToTimestamp(); location.Latitude = request.Latitude; location.Longitude = request.Longitude; session.SaveOrUpdate(location); transaction.Commit(); return(new LocationDto(location)); } } }
public IList <ViewFinMovimentoCaixaBancoDTO> selectPeriodo(ViewFinMovimentoCaixaBancoDTO objeto) { try { IList <ViewFinMovimentoCaixaBancoDTO> resultado = new List <ViewFinMovimentoCaixaBancoDTO>(); using (ISession session = NHibernateHelper.getSessionFactory().OpenSession()) { DateTime data = (DateTime)objeto.DataPagoRecebido; DateTime dataInicio = new DateTime(data.Year, data.Month, 1); DateTime dataFim = new DateTime(data.Year, data.Month, 1).AddMonths(1).AddDays(-1); resultado = session.CreateCriteria(typeof(ViewFinMovimentoCaixaBancoDTO)). Add(Restrictions.And(Restrictions.Between("DataPagoRecebido", dataInicio, dataFim), Restrictions.Eq("IdContaCaixa", (int)objeto.IdContaCaixa))). List <ViewFinMovimentoCaixaBancoDTO>(); } return(resultado); } catch (Exception ex) { throw ex; } }
public System.Collections.Generic.IList <ProductoEN> getProductosPorRangoPrecio(float min, float max) { System.Collections.Generic.IList <ProductoEN> en = null; ProductoCAD productoCAD = null; try { using (ISession session = NHibernateHelper.OpenSession()) using (ITransaction tr = session.BeginTransaction()) { productoCAD = new ProductoCAD(session); en = productoCAD.GetProductosPorRangoPrecio(min, max); tr.Commit(); } } catch (Exception ex) { throw ex; } return(en); }
// Obtiene un abono por ID public AbonoEN getAbonoPorId(int idAbono) { AbonoEN abono = null; AbonoCAD abonoCAD = null; try { using (ISession session = NHibernateHelper.OpenSession()) using (ITransaction tr = session.BeginTransaction()) { abonoCAD = new AbonoCAD(session); abono = abonoCAD.ReadOID(idAbono); tr.Commit(); } } catch (Exception ex) { throw ex; } return(abono); }
// Obtiene los pedidos de un usuario public IList <PedidoEN> getPedidosPorUsuario(UsuarioEN usuario) { IList <PedidoEN> pedido = null; try { using (ISession session = NHibernateHelper.OpenSession()) using (ITransaction tr = session.BeginTransaction()) { PedidoCAD pedidoCAD = new PedidoCAD(session); pedido = pedidoCAD.GetPedidosPorCliente(usuario.Nif); tr.Commit(); } } catch (Exception ex) { throw ex; } return(pedido); }
static public IList <Code> GetAllByOperatorsListAndRegionList(List <Operator> operators, List <Region> regions) { List <Capacity> capacities = null; using (var session = NHibernateHelper.OpenSession()) { var criteria = session.CreateCriteria(typeof(Capacity)); criteria.Add(Restrictions.In(nameof(Operator), operators.Select(x => x.ID).ToArray())); criteria.Add(Restrictions.In(nameof(Region), regions.Select(x => x.ID).ToArray())); criteria.AddOrder(Order.Asc(nameof(Capacity.ID))); capacities = criteria.List <Capacity>().ToList(); } using (var session = NHibernateHelper.OpenSession()) { var criteria = session.CreateCriteria(typeof(Code)); criteria.Add(Restrictions.In(nameof(Capacity.ID), capacities.Select(x => x.Code.ID).Distinct().ToArray())); return(criteria.List <Code>().ToList()); } }
public void CreateEntityWithRelation() { var session = NHibernateHelper.GetCurrentSession(); //var expected = TransInvoke.InvokTransFunction(() => // { var question = CreateQAndA(session); session.Flush(); //foreach (var answer in question.Answers) //{ // session.Delete(answer); //} //question.Answers.Clear(); //question.QuestionID = Guid.NewGuid(); //session.Update(question); //session.Flush(); session.Delete(question); session.Flush(); //return 0; //}); }
public static bool Check(string Name) { try { using (ISession session = NHibernateHelper.OpenSession()) { var result = session.CreateCriteria(typeof(Nameface)) .Add(Restrictions.Eq("NameOn", Name).IgnoreCase()) .List <Nameface>().ToList <Nameface>(); if (result == null) { return(false); } return(true); } } catch { return(false); } }
public static string Normalize(string Name) { try { using (ISession session = NHibernateHelper.OpenSession()) { var result = session.CreateCriteria(typeof(Nameface)) .Add(Restrictions.Like("NameOff", Name)) .List <Nameface>().ToList(); if (result == null) { return(""); } return(result[0].NameOn); } } catch { return(""); } }
public ICollection <Candidate> SelectFilteredOrdered(CandidateFilter filter, CandidateOrdering ordering) { using (ISession session = NHibernateHelper.OpenSession()) { var criteria = session.CreateCriteria <Vacancy>("v"); Util.AddStringRestrictions(criteria, filter.TitleWords, "Title"); criteria.Add(Restrictions.Between ("Salary", filter.SalaryLowerBound, filter.SalaryUpperBound)); var join = criteria.CreateCriteria("Skills"); criteria.Add(Restrictions.InG("Title", join.List <Skill>())); if (!ordering.Salary) { criteria.AddOrder(Order.Desc("Salary")); } return(criteria.List <Candidate>()); } }
internal void Settingscheck() { try { if (!SettingsProvider.HaveAgeSettings()) { InsertAgeSettings(); } } catch (Exception e) { Console.WriteLine(e.StackTrace); try { NHibernateHelper.ResetDatabase(); } catch (Exception ee) { new ErrorMessage(this, "Programmet finner ikke databasen, vennligst skjekk at databasen er installert og riktig satt opp med databasen \"VisitDatabase\" og at brukeren \"rodekors\" har dbcreator og adminrettigheter på den"); mw.ExitApplication(this, null); } } }
//修改 public static void UpdateChargeF(ChargeF tNew) { ISession session = NHibernateHelper.OpenSession(); try { ITransaction tx = session.BeginTransaction(); ChargeF tModify = session.Get <ChargeF>(tNew.CFID); tModify.PeriodNo = tNew.PeriodNo; tModify.ChargeTotal = tNew.ChargeTotal; tModify.Abstract = tNew.Abstract; tModify.CustomerID = tNew.CustomerID; tModify.CustomerName = tNew.CustomerName; tModify.SFPerson = tNew.SFPerson; tx.Commit(); } catch (Exception e) { Debug.Assert(false, e.Message); } session.Close(); }
// GET: Default public ActionResult Index() { var session = NHibernateHelper.OpenSession(); var list = session.QueryOver <Character>() .Where(chr => chr.ID > 1 && chr.ID < 4) .List(); var count = session.QueryOver <Character>().RowCount(); var only_second_page = session.QueryOver <Character>() .OrderBy(x => x.ID).Asc .Take(1) .Skip((2 - 1) * 1) .List(); session.Save(new Character("Random_nick_" + (count + 1).ToString(), new Random().Next(0, 100), new Random().Next(0, 50), new Random().Next(0, 50), new Random().Next(0, 50))); count = session.QueryOver <Character>().RowCount(); list = session.QueryOver <Character>().List(); list = session.QueryOver <Character>().List(); return(View()); }
public void TestFood() { using (var session = NHibernateHelper.OpenSession()) { using (var transaction = session.BeginTransaction()) { var RecipeIdList = RecipeId(); Recipe recipe = session.Get <Recipe>(RecipeIdList); var food = new Food { Name = "Pasta", Quality = 135, Price = 354 }; food.recipes.Add(recipe); session.Save(food); transaction.Commit(); var resultFood = session.Get <Food>(food.ID); Assert.IsNotNull(resultFood); Assert.AreEqual(resultFood.Name, "Pasta"); } } }
public override void Configure(Container container) { SetConfig(new EndpointHostConfig { GlobalResponseHeaders = { {"Access-Control-Allow-Origin", "*"}, {"Access-Control-Allow-Methods", "GET, POST, PUT, DELETE, OPTIONS "}, { "Access-Control-Allow-Headers", "X-Requested-With , origin, content-type, accept" }, {"Access-Control-Allow-Credentials", "true"} }, }); JsConfig.EmitCamelCaseNames = false; var local = new NHibernateHelper(NHibernateHelper.TipoServidor.MySqlServer, "localhost", "csunifytd", "cygnisoft", "8adyl6do", "false", new[] {"UnifyModels"}); container.Register(session => local.GetCurrentSession()).ReusedWithin(ReuseScope.Container); container.Register(rp => new RpArticulo(container.TryResolve<ISession>())); container.Register(rp => new RpArticuloFoto(container.TryResolve<ISession>())); container.Register(rp => new RpArticuloDeposito(container.TryResolve<ISession>(), "Remoto", "Remota")); container.Register(rp => new RpDeposito(container.TryResolve<ISession>())); container.Register(rp => new RpEmpresa(container.TryResolve<ISession>())); container.Register(rp => new RpEntidad(container.TryResolve<ISession>())); container.Register(rp => new RpImpuesto(container.TryResolve<ISession>())); container.Register(rp => new RpSeguridadGo(container.TryResolve<ISession>())); container.Register(rp => new RpRevision(container.TryResolve<ISession>())); container.Register(rp => new RpTomaInventario(container.TryResolve<ISession>())); container.Register(rp => new RpTraslado(container.TryResolve<ISession>())); Plugins.Add(new CorsFeature()); //Registers global CORS Headers }
public void saveDataTest() { // TODO: 初始化为适当的值 ISession session = new NHibernateHelper().GetSession(); target = new NHibernateData(); UserData studentInfo = new UserData("510", "学生", "开个户", "计划公开", "45", "男", "hgh", "hj", "dghsgh"); //存储数据 target.CreateStudentData(studentInfo); UserData studentdata = target.GetUserDataByNum("510"); string name = ""; if(null != studentdata) name = studentdata.Name; Assert.AreEqual("开个户", name); }
public LogTrackerDataAccess(ISessionFactory sessionFactory) { _helper = new NHibernateHelper(sessionFactory); }
public NHibernateSample(Type type) { NHibernateHelper a = new NHibernateHelper(type); //ISession Session = NHibernateHelper.GetSession(); Session = a.GetSession(); }
/*public void AddLinkman(Object linkman) { NHibernateHelper helper = new NHibernateHelper(); ISession Session = helper.GetSession(); ITransaction transaction = Session.BeginTransaction(); try { Session.Save(linkman); transaction.Commit(); } catch (Exception e) { transaction.Rollback(); throw e; } finally { Session.Close(); } }*/ // 按收件人查看联系人 public IList<Linkman> GetLinkmanByReceiver(string Sender,string Receiver) { NHibernateHelper helper = new NHibernateHelper(); ISession session = helper.GetSession(); try { ICriteria crit = session.CreateCriteria(typeof(Linkman)) .Add(NHibernate.Criterion.Restrictions.Eq("Sender", Sender) & NHibernate.Criterion.Restrictions.Eq("Receiver", Receiver)); crit.SetMaxResults(50); IList<Linkman> linkmans = crit.List<Linkman>(); return linkmans; } catch (Exception e) { throw e; } }
// 查看发件人信息 /* public IList<LinkmanData> GetlinkmanBySender(string email) { NHibernateHelper helper = new NHibernateHelper(); ISession session = helper.GetSession(); return session.Get<Email.Domain.Entities.LinkmanData>(email); }*/ public Email.Domain.Entities.Linkman GetlinkmanBySender(string Email) { NHibernateHelper helper = new NHibernateHelper(); ISession session = helper.GetSession(); return session.Get<Email.Domain.Entities.Linkman>(Email); }
// 按主题查询联系人 public Email.Domain.Entities.Linkman GetLinkmanByLinkmanId(string linkmanid) { NHibernateHelper helper = new NHibernateHelper(); ISession session = helper.GetSession(); return session.Get<Email.Domain.Entities.Linkman>(linkmanid); }