public override IQuery GetHsql(Object data) { StringBuilder sql = new StringBuilder("select a from LabelMissingComponent a where "); LabelMissingComponent label = (LabelMissingComponent)data; if (label != null) { Parms = new List <Object[]>(); if (label.RowID != 0) { sql.Append(" a.RowID = :id1 and "); Parms.Add(new Object[] { "id1", label.RowID }); } if (label.FatherLabel != null && label.FatherLabel.LabelID != 0) { sql.Append(" a.FatherLabel.LabelID = :nom9 and "); Parms.Add(new Object[] { "nom9", label.FatherLabel.LabelID }); } if (label.Status != null && label.Status.StatusID != 0) { sql.Append(" a.Status.StatusID = :st11 and "); Parms.Add(new Object[] { "st11", label.Status.StatusID }); } if (label.Component != null && label.Component.ProductID != 0) { sql.Append(" a.Component.ProductID = :nom11 and "); Parms.Add(new Object[] { "nom11", label.Component.ProductID }); } if (!String.IsNullOrEmpty(label.Notes)) { sql.Append(" a.Notes = :nom1 and "); Parms.Add(new Object[] { "nom1", label.Notes }); } } sql = new StringBuilder(sql.ToString()); sql.Append(" 1=1 order by a.RowID "); IQuery query = Factory.Session.CreateQuery(sql.ToString()); SetParameters(query); return(query); }
public IList <LabelMissingComponent> Select(LabelMissingComponent data) { IList <LabelMissingComponent> datos = new List <LabelMissingComponent>(); try { datos = GetHsql(data).List <LabelMissingComponent>(); if (!Factory.IsTransactional) { Factory.Commit(); } } catch (Exception e) { NHibernateHelper.WriteEventLog(WriteLog.GetTechMessage(e)); } return(datos); }
public LabelMissingComponent SelectById(LabelMissingComponent data) { return((LabelMissingComponent)base.SelectById(data)); }
public Boolean Delete(LabelMissingComponent data) { return(base.Delete(data)); }
public Boolean Update(LabelMissingComponent data) { return(base.Update(data)); }
public LabelMissingComponent Save(LabelMissingComponent data) { return((LabelMissingComponent)base.Save(data)); }