public CasNumberFormula()
{
InitializeComponent();
DataContext = this;
//Inicializo los listados y las variables
Record = new C_CasNumberFormula();
CasNumber = service.GetC_CasNumber(new C_CasNumber());
}
public CasNumberFormula()
{
InitializeComponent();
DataContext = this;
//Inicializo los listados y las variables
Record = new C_CasNumberFormula();
CasNumber = service.GetC_CasNumber(new C_CasNumber());
}
public IList <C_CasNumberFormula> Select(C_CasNumberFormula data)
{
IList <C_CasNumberFormula> datos = new List <C_CasNumberFormula>();
datos = GetHsql(data).List <C_CasNumberFormula>();
if (!Factory.IsTransactional)
{
Factory.Commit();
}
return(datos);
}
public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from C_CasNumberFormula a where ");
C_CasNumberFormula C_CasNumberFormula = (C_CasNumberFormula)data;
if (C_CasNumberFormula != null)
{
Parms = new List <Object[]>();
if (C_CasNumberFormula.RowID != 0)
{
sql.Append(" a.RowID = :id and ");
Parms.Add(new Object[] { "id", C_CasNumberFormula.RowID });
}
if (C_CasNumberFormula.Product != null && C_CasNumberFormula.Product.ProductID != 0)
{
sql.Append(" a.Product.ProductID = :idp1 and ");
Parms.Add(new Object[] { "idp1", C_CasNumberFormula.Product.ProductID });
}
if (C_CasNumberFormula.CasNumberComponent != null && C_CasNumberFormula.CasNumberComponent.CasNumberID != 0)
{
sql.Append(" a.CasNumberComponent.CasNumberID = :idc1 and ");
Parms.Add(new Object[] { "idc1", C_CasNumberFormula.CasNumberComponent.CasNumberID });
}
if (C_CasNumberFormula.CasNumberComponent != null && !string.IsNullOrEmpty(C_CasNumberFormula.CasNumberComponent.Code))
{
sql.Append(" a.CasNumberComponent.Code = :idz1 and ");
Parms.Add(new Object[] { "idz1", C_CasNumberFormula.CasNumberComponent.Code });
}
if (C_CasNumberFormula.Product != null && !string.IsNullOrEmpty(C_CasNumberFormula.Product.ProductCode))
{
sql.Append(" a.Product.ProductCode = :idy1 and ");
Parms.Add(new Object[] { "idy1", C_CasNumberFormula.Product.ProductCode });
}
}
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 C_CasNumberFormula SelectById(C_CasNumberFormula data)
{
return((C_CasNumberFormula)base.SelectById(data));
}
public Boolean Delete(C_CasNumberFormula data)
{
return(base.Delete(data));
}
public Boolean Update(C_CasNumberFormula data)
{
return(base.Update(data));
}
public C_CasNumberFormula Save(C_CasNumberFormula data)
{
return((C_CasNumberFormula)base.Save(data));
}
internal void DeleteC_CasNumberFormula(C_CasNumberFormula c_CasNumberFormula)
{
try
{
SetService();
SerClient.DeleteC_CasNumberFormula(c_CasNumberFormula);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
internal C_CasNumberFormula SaveC_CasNumberFormula(C_CasNumberFormula c_CasNumberFormula)
{
try
{
SetService();
return SerClient.SaveC_CasNumberFormula(c_CasNumberFormula);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
