DBHelper.CurrentSession

DBHelper.CurrentSession

var curSession = DBHelper.CurrentSession;
//保存
curSession.Save();
curSession.SaveOrUpdate();
//删除
curSession.Delete();
//查询
curSession.QueryOver<>().Where();
curSession.AndRestrictionOn(p => p.UnitName).IsLike(args.UnitName);

Material mat = null;
Vendor ven = null;
var query = DBHelper.CurrentSession.QueryOver<Material>(() => mat).JoinQueryOver(p => p.Vendor, () => ven);
query.Where(() => mat.Erpcode.IsLike(queryArgs.QueryValue, MatchMode.Start)
                            || mat.Materialname.IsLike(queryArgs.QueryValue, MatchMode.Anywhere
                            || ven.Vendorname.IsLike(queryArgs.QueryValue, MatchMode.Anywhere)