public IList <C_CasNumberRule> GetCasNumberRule(C_CasNumberRule data) { //Obtiene la lisata de el Regulator a Mirar //MetaMaster IList <MMaster> regulatorList = Factory.DaoMMaster().Select( new MMaster { MetaType = new MType { Code = data.Rule.MetaType.Code } }) .OrderBy(f => f.NumOrder).ToList(); //Obtiene la lista de las Regulaciones existentes IList <C_CasNumberRule> casNumberList = Factory.DaoC_CasNumberRule().Select(data); try { //Left Outer Join entregando Regualciones FULL casNumberList = (from ori in regulatorList join rule in casNumberList on ori.MetaMasterID equals rule.Rule.MetaMasterID into g from rule in g.DefaultIfEmpty() select new C_CasNumberRule { Rule = ori, CasNumber = data.CasNumber, RuleValue = rule == null ? "" : rule.RuleValue, CreatedBy = rule == null ? "" : rule.CreatedBy, CreationDate = rule == null ? null : rule.CreationDate, RowID = rule == null ? 0 : rule.RowID }) .ToList(); } catch { } return(casNumberList); }
public override IQuery GetHsql(Object data) { StringBuilder sql = new StringBuilder("select a from C_CasNumberRule a where "); C_CasNumberRule C_CasNumberRule = (C_CasNumberRule)data; if (C_CasNumberRule != null) { Parms = new List <Object[]>(); if (C_CasNumberRule.RowID != 0) { sql.Append(" a.RowID = :id and "); Parms.Add(new Object[] { "id", C_CasNumberRule.RowID }); } if (C_CasNumberRule.CasNumber != null && C_CasNumberRule.CasNumber.CasNumberID != 0) { sql.Append(" a.CasNumber.CasNumberID = :idp1 and "); Parms.Add(new Object[] { "idp1", C_CasNumberRule.CasNumber.CasNumberID }); } if (C_CasNumberRule.Rule != null) { if (C_CasNumberRule.Rule.MetaMasterID != 0) { sql.Append(" a.Rule.MetaMasterID = :idc1 and "); Parms.Add(new Object[] { "idc1", C_CasNumberRule.Rule.MetaMasterID }); } if (C_CasNumberRule.Rule.MetaType != null) { if (C_CasNumberRule.Rule.MetaType.MetaTypeID != 0) { sql.Append(" a.Rule.MetaType.MetaTypeID = :itt1 and "); Parms.Add(new Object[] { "itt1", C_CasNumberRule.Rule.MetaType.MetaTypeID }); } if (!string.IsNullOrEmpty(C_CasNumberRule.Rule.MetaType.Code)) { sql.Append(" a.Rule.MetaType.Code= :itc1 and "); Parms.Add(new Object[] { "itc1", C_CasNumberRule.Rule.MetaType.Code }); } } } if (!string.IsNullOrEmpty(C_CasNumberRule.RuleValue)) { sql.Append(" a.RuleValue = :idz1 and "); Parms.Add(new Object[] { "idz1", C_CasNumberRule.RuleValue }); } } sql = new StringBuilder(sql.ToString()); sql.Append(" 1=1 order by a.RowID asc "); IQuery query = Factory.Session.CreateQuery(sql.ToString()); SetParameters(query); return(query); }
public IList <C_CasNumberRule> Select(C_CasNumberRule data) { IList <C_CasNumberRule> datos = new List <C_CasNumberRule>(); datos = GetHsql(data).List <C_CasNumberRule>(); if (!Factory.IsTransactional) { Factory.Commit(); } return(datos); }
internal void DeleteC_CasNumberRule(C_CasNumberRule C_CasNumberRule) { try { SetService(); SerClient.DeleteC_CasNumberRule(C_CasNumberRule); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
internal C_CasNumberRule SaveC_CasNumberRule(C_CasNumberRule C_CasNumberRule) { try { SetService(); return SerClient.SaveC_CasNumberRule(C_CasNumberRule); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
public C_CasNumberRule SelectById(C_CasNumberRule data) { return((C_CasNumberRule)base.SelectById(data)); }
public Boolean Delete(C_CasNumberRule data) { return(base.Delete(data)); }
public Boolean Update(C_CasNumberRule data) { return(base.Update(data)); }
public C_CasNumberRule Save(C_CasNumberRule data) { return((C_CasNumberRule)base.Save(data)); }