摘要：
public virtual EmployeeJoinInfo GetEmployeeJoinByWorkCode(string workCode) { using(ISession session = OpenSession()) { IList list = session.CreateCriteria(typeof(EmployeeJoinInfo)).Add(Expression.Eq("WorkCode", workCode)).Add(Expression.Not(Expression.Eq("... 阅读全文
摘要：
public virtual ArrayList QueryEmployeeDemissionSettlementListByExec(DateTime begin,DateTime end) { using (ISession session = OpenSession()) { return (ArrayList)session.CreateCriteria(typeof(EmployeeDemissionInfo)).Add(Expression.Eq("SettlementStatus",... 阅读全文
摘要：
public virtual DemissionRemittanceInfo GetDemissionRemittanceInfo(int demissionremittanceID) { using (ISession session = OpenSession()) { return (DemissionRemittanceInfo)NHibernateHelper.GetObject(session, typeof(DemissionRemittanceInfo), demissionremitta... 阅读全文
摘要：
public virtual void DeletePerson(int id) { using(ISession session = OpenSession()) { ITransaction tx = null; try { tx = session.BeginTransaction(); session.Delete(string.Format("from Perso... 阅读全文
摘要：
public virtual IList GetEmployeeListByPeriodAndDeptList(IList deptlist, DateTime begin, DateTime end) { using (ISession session = OpenSession()) { return session.CreateCriteria(typeof(EmployeeInfo)).Add(Expression.In("DeptID", deptlist)).Add(Expression.S... 阅读全文
摘要：
public virtual int InsertEmployeeInfoByImport(EmployeeInfo info, PersonInfo person, CorporationSaveCountInfo count) { using (ISession session = OpenSession()) { ITransaction tx = null;//创建一个事务 try { tx = se... 阅读全文
摘要：
View Code select sum(c) from ( select count(*) as c from auditingapply where AuditingStatus in (4400000 ) and MakeDraftMan=9500 union select count(*) as c from auditingapply where AuditingStatus in (4400004 ) and MakeDraftMan=9500 and createtime>(select case when month(getdate())-5<0 --如果当前月份. 阅读全文