public IList <ConfigOptionByCompany> Select(ConfigOptionByCompany data) { IList <ConfigOptionByCompany> datos = new List <ConfigOptionByCompany>(); datos = GetHsql(data).List <ConfigOptionByCompany>(); //if (!Factory.IsTransactional) //Factory.Commit(); return(datos); }
public override IQuery GetHsql(object data) { StringBuilder sql = new StringBuilder("select a from ConfigOptionByCompany a where "); ConfigOptionByCompany configoption = (ConfigOptionByCompany)data; if (configoption != null) { Parms = new List <Object[]>(); if (configoption.RowID != 0) { sql.Append(" a.RowID = :id and "); Parms.Add(new Object[] { "id", configoption.RowID }); } if (configoption.ConfigOption != null && configoption.ConfigOption.ConfigOptionID != 0) { sql.Append("a.ConfigOption.ConfigOptionID = :id1 and "); Parms.Add(new Object[] { "id1", configoption.ConfigOption.ConfigOptionID }); } if (!String.IsNullOrEmpty(configoption.Value)) { sql.Append(" a.Value = :nom and "); Parms.Add(new Object[] { "nom", configoption.Value }); } if (configoption.ConfigOption != null) { if (!String.IsNullOrEmpty(configoption.ConfigOption.Code)) { sql.Append(" a.ConfigOption.Code = :nom1 and "); Parms.Add(new Object[] { "nom1", configoption.ConfigOption.Code }); } if (configoption.ConfigOption.ConfigType != null && configoption.ConfigOption.ConfigType.ConfigTypeID != 0) { sql.Append(" a.ConfigOption.ConfigType.ConfigTypeID = :cfg and "); Parms.Add(new Object[] { "cfg", configoption.ConfigOption.ConfigType.ConfigTypeID }); } if (configoption.ConfigOption.IsAdmin != null) { sql.Append(" a.ConfigOption.IsAdmin = :adm and "); Parms.Add(new Object[] { "adm", configoption.ConfigOption.IsAdmin }); } } if (configoption.Company != null && configoption.Company.CompanyID != 0) { sql.Append("a.Company.CompanyID = :id2 and "); Parms.Add(new Object[] { "id2", configoption.Company.CompanyID }); } } 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 ConfigOptionByCompany SelectById(ConfigOptionByCompany data) { return((ConfigOptionByCompany)base.SelectById(data)); }
public Boolean Delete(ConfigOptionByCompany data) { return(base.Delete(data)); }
public Boolean Update(ConfigOptionByCompany data) { return(base.Update(data)); }
public ConfigOptionByCompany Save(ConfigOptionByCompany data) { return((ConfigOptionByCompany)base.Save(data)); }
public void UpdateConfigOptionByCompany(ConfigOptionByCompany data) { try { SetService(); SerClient.UpdateConfigOptionByCompany(data); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
// public IList<UserTransactionLog> GetUserTransactionLog(UserTransactionLog data) //{ //try { //SetService(); return SerClient.GetUserTransactionLog( data) ; } //finally //{ //SerClient.Close(); //if (SerClient.State == CommunicationState.Faulted) //{SerClient.Abort();} //} //} // public UserTransactionLog SaveUserTransactionLog(UserTransactionLog data) //{ //try { //SetService(); return SerClient.SaveUserTransactionLog( data) ; } //finally //{ //SerClient.Close(); //if (SerClient.State == CommunicationState.Faulted) //{SerClient.Abort();} //} //} // public void UpdateUserTransactionLog(UserTransactionLog data) //{ //try { //SetService(); SerClient.UpdateUserTransactionLog( data) ; } //finally //{ //SerClient.Close(); //if (SerClient.State == CommunicationState.Faulted) //{SerClient.Abort();} //} //} // public void DeleteUserTransactionLog(UserTransactionLog data) //{ //try { //SetService(); SerClient.DeleteUserTransactionLog( data) ; } //finally //{ //SerClient.Close(); //if (SerClient.State == CommunicationState.Faulted) //{SerClient.Abort();} //} //} public IList<ConfigOptionByCompany> GetConfigOptionByCompany(ConfigOptionByCompany data) { try { SetService(); return SerClient.GetConfigOptionByCompany(data); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }