public IList <WFDataType> Select(WFDataType data)
{
IList <WFDataType> datos = new List <WFDataType>();
try {
datos = GetHsql(data).List <WFDataType>();
if (!Factory.IsTransactional)
{
Factory.Commit();
}
}
catch (Exception e)
{
NHibernateHelper.WriteEventLog(WriteLog.GetTechMessage(e));
}
return(datos);
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from WFDataType a where ");
WFDataType DataType = (WFDataType)data;
if (DataType != null)
{
Parms = new List <Object[]>();
if (DataType.DataTypeID != 0)
{
sql.Append(" a.DataTypeID = :id and ");
Parms.Add(new Object[] { "id", DataType.DataTypeID });
}
if (!String.IsNullOrEmpty(DataType.Name))
{
sql.Append(" a.Name = :nom and ");
Parms.Add(new Object[] { "nom", DataType.Name });
}
if (DataType.IsBasic != null)
{
sql.Append(" a.IsBasic = :nomf and ");
Parms.Add(new Object[] { "nomf", DataType.IsBasic });
}
if (!String.IsNullOrEmpty(DataType.UIListControl))
{
sql.Append(" a.UIListControl = :nom1 and ");
Parms.Add(new Object[] { "nom1", DataType.UIListControl });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.DataTypeID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return(query);
}
internal void DeleteWFDataType(WFDataType WFDataType)
{
try
{
SetService();
SerClient.DeleteWFDataType(WFDataType);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
internal WFDataType SaveWFDataType(WFDataType WFDataType)
{
try
{
SetService();
return SerClient.SaveWFDataType(WFDataType);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public WFDataType SelectById(WFDataType data)
{
return((WFDataType)base.SelectById(data));
}
public Boolean Delete(WFDataType data)
{
return(base.Delete(data));
}
public Boolean Update(WFDataType data)
{
return(base.Update(data));
}
public WFDataType Save(WFDataType data)
{
return((WFDataType)base.Save(data));
}