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));
}
