/// <summary>
/// 根据表编码，获取列字段
/// </summary>
/// <param name="tablesCode">表编码</param>
/// <returns></returns>
public static IList <Column> GetColumn(Guid tablesCode)
{
try
{ //获得当前运行的NHibernate实例
using (ISession session = NHibernateHelper.GetCurrentSession())
{
//事务开始
ITransaction transaction = session.BeginTransaction();
ICriteria criteria = session.CreateCriteria <Column>();
criteria.Add(Expression.Eq("TablesCode", tablesCode));
criteria.Add(Expression.Eq("FieldState", 1));//状态为启用
IList <Column> list = criteria.SetCacheable(true).AddOrder(Order.Asc("Id")).List <Column>();
//提交事务
transaction.Commit();
return(list);
}
}
catch (Exception ex)
{
NHibernateHelper.WriteErrorLog("根据表编码，获取列字段", ex);
throw;
}
}
/// <summary>
/// 根据项目编码，获取数据库
/// </summary>
/// <param name="projectCode">项目编码</param>
/// <returns></returns>
public static IList <Database> GetDatabase(Guid projectCode)
{
try
{
//获得当前运行的NHibernate实例
using (ISession session = NHibernateHelper.GetCurrentSession())
{
//事务开始
ITransaction transaction = session.BeginTransaction();
ICriteria criteria = session.CreateCriteria <Database>();
criteria.Add(Expression.Eq("ProjectCode", projectCode));
IList <Database> list = criteria.SetCacheable(true).AddOrder(Order.Asc("Id")).List <Database>();
//提交事务
transaction.Commit();
return(list);
}
}
catch (Exception ex)
{
NHibernateHelper.WriteErrorLog("根据项目编码，获取数据库", ex);
throw;
}
}
/// <summary>
/// 根据编码删除表并返回这个实体对象.
/// </summary>
/// <param name="code">编码</param>
/// <returns>T</returns>
public static T Delete(Guid code)
{
using (ISession session = NHibernateHelper.GetCurrentSession())
{
ITransaction transaction = session.BeginTransaction();
try
{
T entity = GetProjectById(code);
if (entity != null)
{
session.Delete(entity);
}
session.Flush();
transaction.Commit();
return(entity);
}
catch (Exception ex)
{
NHibernateHelper.WriteErrorLog("NHibernate执行删除操作", ex);
transaction.Rollback();
return(default(T));
}
}
}
