// 添加联系人
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);
}
