public IEnumerable <T> Get(NHibernate.IQuery query, int baseIndex, short pageSize, out int count, string sortFieldName, SortDirection sortDirection)
{
count = query.List <T>().Count;
//if pageSize>0 then do paging, otherwise no paging and all records will be displayed
if (pageSize > 0)
{
query.SetFirstResult(baseIndex)
.SetMaxResults(pageSize)
.SetMaxResults(pageSize);
}
IList <T> result = query.List <T>();
return(result);
}
/// <summary>
/// 通过EPCID查询
/// </summary>
/// <param name="sql"></param>
/// <param name="isSetSupplier"></param>
/// <param name="isSetSpec"></param>
/// <returns></returns>
public AscmContainer GetByEpcId(string epcId, string sessionKey = null)
{
AscmContainer ascmContainer = null;
try
{
NHibernate.ISession session = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession();
if (sessionKey != null)
{
session = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession(sessionKey);
}
NHibernate.IQuery query = session.CreateQuery("from AscmContainer where rfid='" + epcId + "' ");
if (query.List().Count > 0)
{
ascmContainer = query.UniqueResult <AscmContainer>();
if (!string.IsNullOrEmpty(ascmContainer.supplierId.ToString()))
{
ascmContainer.supplier = MideaAscm.Services.Base.AscmSupplierService.GetInstance().Get(ascmContainer.supplierId, sessionKey);
}
if (!string.IsNullOrEmpty(ascmContainer.specId.ToString()))
{
ascmContainer.containerSpec = MideaAscm.Services.SupplierPreparation.AscmContainerSpecService.GetInstance().Get(ascmContainer.specId, sessionKey);
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find AscmContainer)", ex);
throw ex;
}
return(ascmContainer);
}
/// <summary>
/// Gets the entity list from respersitory.
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="hQuery">The hibernate query string.</param>
/// <param name="paras">The parameters in the query string,a dictionary,its key represent the parameter name,and its value is the parameter value.</param>
/// <returns></returns>
public IList <T> GetList <T>(string hQuery, Dictionary <string, object> paras)
{
try
{
OpenConnect();
Hib.IQuery query = _Session.CreateQuery(hQuery);
if (paras != null)
{
foreach (string key in paras.Keys)
{
query.SetParameter(key, paras[key]);
}
}
return(query.List <T>());
}
catch (Exception ex)
{
LogExepttion(ex);
throw;
}
finally
{
Disconnect();
}
}
public ActionResult Registration(Models.RegistrationModel reg_model)
{
if (Session["session_key"] != null)
{
return(RedirectToAction("index"));
}
using (NHibernate.ISession session = NHibernateSessionManeger.OpenSession())
{
if (!ModelState.IsValid)
{
return(View());
}
else
{
NHibernate.IQuery query = session.CreateQuery("FROM Users WHERE name = '" + reg_model.Name + "'");
if (query.List <Models.Users>().Count() > 0)
{
ViewData["ErrorMessage"] = " Пользователь с ником " + reg_model.Name + " уже занят ";
return(View());
}
var usr = new Models.Users();
usr.Email = reg_model.Email;
usr.Name = reg_model.Name;
var salt = Guid.NewGuid().ToByteArray();
string hashsed_password = Convert.ToBase64String(CryptSharp.Utility.SCrypt.ComputeDerivedKey(System.Text.UTF8Encoding.UTF8.GetBytes(reg_model.Password), salt, 16384, 8, 1, null, 128));
usr.HashPassword = hashsed_password;
usr.Salt = Convert.ToBase64String(salt);
session.Save(usr);
return(RedirectToAction("authorization"));
}
}
}
/// <summary>
/// 普通查询
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="hql">查询语句</param>
/// <returns></returns>
public static List <T> GetEntitiesByHQL <T>(string hql)
{
BasicDataManipulation baseData = new BasicDataManipulation();
ISession Session = baseData.GetSession();
List <T> list = new List <T>();
if (Session == null)
{
throw new Exception("打开数据库连接失败！");
}
try
{
NHibernate.IQuery query = Session.CreateQuery(hql);
list = query.List <T>().ToList();
return(list);
}
catch (Exception ex)
{
LogAPI.Debug(ex);
return(list);
}
finally
{
if (Session != null)
{
Session.Dispose();
Session = null;
}
}
}
public IList FindByMainId(string id)
{
NHibernate.ISession session = HibernateTemplate.SessionFactory.OpenSession();
NHibernate.IQuery query = session.CreateQuery("from MasterInfo m where m.InfoCode=:infoCode");
query.SetParameter("infoCode", id);
return(query.List());
}
public IEnumerable <T> Get(NHibernate.IQuery query, int pageIndex, int pageSize, out int count, string sortFieldName, SortDirection sortDirection)
{
count = query.List <T>().Count;
//if pageSize>0 then do paging, otherwise no paging and all records will be displayed
if (pageSize > 0)
{
query.SetFirstResult((int)pageIndex * pageSize)
.SetMaxResults(pageSize)
.SetMaxResults(pageSize);
}
IList <T> result = query.List <T>();
//var rowCount = query.SetFirstResult(0).FutureValue<Int32>();
//count = rowCount.Value;
return(result);
}
/// <summary>
/// 分页查询
/// </summary>
/// <typeparam name="T">类型</typeparam>
/// <param name="hql">查询语句</param>
/// <param name="skip">页数</param>
/// <param name="take">每页显示条数</param>
/// <param name="count">总数</param>
/// <returns></returns>
public static List <T> GetEntitiesByHQL <T>(string hql, int skip, int take, out int count)
{
BasicDataManipulation baseData = new BasicDataManipulation();
ISession Session = baseData.GetSession();
List <T> list = new List <T>();
if (Session == null)
{
throw new Exception("打开数据库连接失败！");
}
try
{
NHibernate.IQuery query1 = Session.CreateQuery(hql);
string hqlcount = "";
int fromIndex = hql.IndexOf("from");
int toIndex = hql.IndexOf("order");
int len = 0;
if (toIndex == -1)
{
hqlcount = "select count(*) " + hql.Substring(fromIndex);
}
else
{
len = toIndex - fromIndex;
hqlcount = "select count(*) " + hql.Substring(fromIndex, len);
}
NHibernate.IQuery querycount = Session.CreateQuery(hqlcount);
try
{
count = int.Parse(querycount.UniqueResult().ToString());
}
catch
{
count = 0;
}
NHibernate.IQuery query = query1.SetFirstResult(skip).SetMaxResults(take);
list = query.List <T>().ToList();
return(list);
}
catch (Exception ex)
{
count = 0;
LogAPI.Debug(ex);
return(list);
}
finally
{
if (Session != null)
{
Session.Dispose();
Session = null;
}
}
}
public ArrayList UnPaidUserCountByMonth()
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
ArrayList alstUser = new ArrayList();
try
{
NHibernate.IQuery query = session.CreateSQLQuery("Select month(CreateDate),Count(*) from User where PaymentStatus='unpaid' group by month(CreateDate)");
foreach (var item in query.List())
{
alstUser.Add(item);
}
return(alstUser);
}
catch (Exception Err)
{
Console.Write(Err.StackTrace);
return(alstUser);
}
}
}
}
public IEnumerable <T> Get(NHibernate.IQuery query)
{
return(query.List <T>());
}
