public bool IsUserExist(string Emailid)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from User u where u.EmailId = : email");
query.SetParameter("email", Emailid);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
}
}
}
/// <checkTaskExists>
/// checkTaskExists
/// </summary>
/// <param name="TaskId">Task id.(String)</param>
/// <param name="Userid">User id.(Guid)</param>
/// <returns>True and False.(bool)</returns>
public bool checkTaskExists(string TaskId, Guid Userid)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
//Proceed action, to get task details by userid and task id.
NHibernate.IQuery query = session.CreateQuery("from Task where UserId = :userid and Id = :taskid");
query.SetParameter("userid", Userid);
query.SetParameter("taskid", TaskId);
var result = query.UniqueResult();
if (result == null)
{
return(false);
}
else
{
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(true);
}
} //End Transaction
} //End Session
}
/// <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>
/// 得到最新的一次流转记录
/// 根据EPCID得到
/// </summary>
/// <param name="strEpcId">根据EPCID</param>
/// <returns></returns>
public string Get(string strEpcId)
{
try
{
using (NHibernate.ISession session = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession())
{
if (session.IsOpen)
{
NHibernate.IQuery query = session.CreateQuery("from AscmTagLog where readTime in (select to_char(max(to_date(readTime,'yyyy-MM-dd HH24:mi:ss')),'yyyy-MM-dd HH24:mi:ss') from AscmTagLog where epcId='" + strEpcId + "' ) and epcId='" + strEpcId + "' ");
AscmTagLog ascmTagLog = query.UniqueResult <AscmTagLog>();
if (ascmTagLog != null)
{
object obj = YnDaoHelper.GetInstance().nHibernateHelper.GetObject("select address from AscmReadingHead where id=" + ascmTagLog.readingHeadId + "");
ascmTagLog.place = obj.ToString();
return
(YnBaseClass2.Helper.ObjectHelper.Serialize <AscmTagLog>(ascmTagLog));
}
else
{
return(null);
}
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmContainer)", ex);
throw ex;
}
return(null);
}
/// <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 Dal.ContainerManage.Entities.AscmCheck Get()
{
Dal.ContainerManage.Entities.AscmCheck ack = null;
try
{
NHibernate.IQuery query = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().CreateQuery("from AscmCheck where id in (select max(id) from AscmCheck)");
ack = query.UniqueResult <Dal.ContainerManage.Entities.AscmCheck>();
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmCheck)", ex);
throw ex;
}
return(ack);
}
/// <getTaskById>
/// Get Task By Id
/// </summary>
/// <param name="Taskid">Task id.(string)</param>
/// <param name="userId">User id.(Guid)</param>
/// <returns>Return object of Tasks Class with all Tasks info.(List<Tasks>)</returns>
public Tasks getTaskById(string Taskid, Guid userId)
{
//Creates a database connection and opens up a session
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
//After Session creation, start Transaction.
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
//Proceed action, to get Account details by Fb user id and user id.
NHibernate.IQuery query = session.CreateQuery("from FacebookAccount where FbUserId = :Fbuserid and UserId=:userId");
query.SetParameter("Fbuserid", Taskid);
query.SetParameter("userId", userId);
Tasks result = (Tasks)query.UniqueResult();
return(result);
} //End Transaction
} //End Session
}
/// <summary>
/// 2013/07/17
/// </summary>
/// <param name="epc"></param>
/// <returns></returns>
public AscmRfid GetByEpc(string epcId)
{
AscmRfid ascmRfid = null;
try
{
NHibernate.ISession session = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession();
NHibernate.IQuery query = session.CreateQuery("from AscmRfid where epcId='" + epcId + "' ");
ascmRfid = query.UniqueResult <AscmRfid>();
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmRfid)", ex);
throw ex;
}
return(ascmRfid);
}
public User getUsersById(Guid userId)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from User where Id =: userid");
query.SetParameter("userid", userId);
User usr = query.UniqueResult <User>();
return(usr);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
}
}
}
public User GetUserInfo(string EmailId, string Password)
{
using (NHibernate.ISession session = SessionFactory.GetNewSession())
{
using (NHibernate.ITransaction transaction = session.BeginTransaction())
{
try
{
NHibernate.IQuery query = session.CreateQuery("from User u where u.EmailId = : email and u.Password= :password");
query.SetParameter("email", EmailId);
query.SetParameter("password", Password);
User result = (User)query.UniqueResult();
return(result);
}
catch (Exception ex)
{
Console.WriteLine(ex.StackTrace);
return(null);
}
}
}
}
/// <summary>
/// 手持机出入库
/// </summary>
/// <param name="userName"></param>
/// <param name="containerId"></param>
/// <param name="direction"></param>
public string AscmStoreInOutSave(string userName, string containerId, string direction, string docNumber)
{
NHibernate.IQuery query = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().CreateQuery("from AscmStoreInOut where containerId='" + containerId + "' and readTime=(select max(readTime) from AscmStoreInOut where containerId='" + containerId + "')");
Dal.ContainerManage.Entities.AscmStoreInOut ack = query.UniqueResult <Dal.ContainerManage.Entities.AscmStoreInOut>();
if (ack != null && ack.direction == direction)
{
return("请勿重复提交！");
}
else
{
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction())
{
try
{
Dal.SupplierPreparation.Entities.AscmContainer ascmContainer = MideaAscm.Services.SupplierPreparation.AscmContainerService.GetInstance().Get(containerId);
Dal.ContainerManage.Entities.AscmStoreInOut ascmStoreInOut = new Dal.ContainerManage.Entities.AscmStoreInOut();
ascmStoreInOut.containerId = ascmContainer.sn;
ascmStoreInOut.createUser = userName;
ascmStoreInOut.direction = direction;
ascmStoreInOut.containerId = ascmContainer.sn;
ascmStoreInOut.supplierId = ascmContainer.supplierId;
ascmStoreInOut.epcId = ascmContainer.rfid;
ascmStoreInOut.createTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
ascmStoreInOut.readTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
ascmStoreInOut.docNumber = docNumber;//每次提交都产生新的单据号
ascmStoreInOut.id = YnDaoHelper.GetInstance().nHibernateHelper.GetMaxId("select max(id) from AscmStoreInOut)") + 1;
if (direction == "STOREIN")
{
ascmStoreInOut.status = AscmStoreInOut.StatusDefine.inStored;
object obj = YnDaoHelper.GetInstance().nHibernateHelper.GetObject("select to_char(id) from AscmReadingHead where address= '容器监管中心' and ip='0.0.0.0'");
ascmContainer.place = obj.ToString();
}
else
{
object obj = YnDaoHelper.GetInstance().nHibernateHelper.GetObject("select to_char(id) from AscmReadingHead where address= '厂区外' and ip='0.0.0.0'");
ascmStoreInOut.status = AscmStoreInOut.StatusDefine.outStored;
if (ascmContainer.supplierId != 6128)
{
ascmContainer.place = obj.ToString();
}
else
{
ascmContainer.place = null;
}
}
ascmContainer.modifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
ascmContainer.modifyUser = userName;
YnDaoHelper.GetInstance().nHibernateHelper.Update <Dal.SupplierPreparation.Entities.AscmContainer>(ascmContainer);
YnDaoHelper.GetInstance().nHibernateHelper.Save <Dal.ContainerManage.Entities.AscmStoreInOut>(ascmStoreInOut);
tx.Commit();//正确执行提交
return("");
}
catch (Exception ex)
{
tx.Rollback();//回滚
YnBaseClass2.Helper.LogHelper.GetLog().Error("保存失败(Save AscmCheckContainerInfo)", ex);
throw ex;
}
}
}
}
