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