public DataTable SearchCount(vAlimentosDeEncuestasEntityFilter EntityFilter) { try { return(this.CreateDataAccess().SearchCount(EntityFilter)); } catch (Exception ex) { Helpers.Logger.Logger.LogExceptionStatic(ex); throw ex; } }
public void Search(vAlimentosDeEncuestasEntityFilter EntityFilter, out vAlimentosDeEncuestasEntityInfo.vAlimentosDeEncuestasEntityInfoList listaAGenerar) { try { listaAGenerar = this.DataTableToListOfEntityInfo(this.CreateDataAccess().Search(EntityFilter)); } catch (Exception ex) { Helpers.Logger.Logger.LogExceptionStatic(ex); throw ex; } }
public DataTable Search(vAlimentosDeEncuestasEntityFilter EntityFilter) { DbCommand storedProcCommand = this.DataBase.GetStoredProcCommand("vAlimentosDeEncuestas_Search"); try { using (storedProcCommand) { this.DataBase.AddInParameter(storedProcCommand, "WhereExtendido", DbType.String, (object)EntityFilter.WhereExtendido); this.DataBase.AddInParameter(storedProcCommand, "OrdenDeRegistros", DbType.String, (object)EntityFilter.OrderBy); this.DataBase.AddInParameter(storedProcCommand, "OpeOrden1", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeOrden1)); this.DataBase.AddInParameter(storedProcCommand, "Orden1", DbType.Int32, (object)EntityFilter.Orden1); this.DataBase.AddInParameter(storedProcCommand, "OpeOrden2", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeOrden2)); this.DataBase.AddInParameter(storedProcCommand, "Orden2", DbType.Int32, (object)EntityFilter.Orden2); this.DataBase.AddInParameter(storedProcCommand, "OpeTipoDeAlimento", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeTipoDeAlimento)); this.DataBase.AddInParameter(storedProcCommand, "TipoDeAlimento", DbType.AnsiString, (object)EntityFilter.TipoDeAlimento); this.DataBase.AddInParameter(storedProcCommand, "OpeAlimentoCodigo", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeAlimentoCodigo)); this.DataBase.AddInParameter(storedProcCommand, "AlimentoCodigo", DbType.AnsiString, (object)EntityFilter.AlimentoCodigo); this.DataBase.AddInParameter(storedProcCommand, "OpeNombre", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeNombre)); this.DataBase.AddInParameter(storedProcCommand, "Nombre", DbType.AnsiString, (object)EntityFilter.Nombre); this.DataBase.AddInParameter(storedProcCommand, "OpeNunca", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeNunca)); this.DataBase.AddInParameter(storedProcCommand, "Nunca", DbType.Int32, (object)EntityFilter.Nunca); this.DataBase.AddInParameter(storedProcCommand, "OpeVM", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeVM)); this.DataBase.AddInParameter(storedProcCommand, "VM", DbType.Int32, (object)EntityFilter.VM); this.DataBase.AddInParameter(storedProcCommand, "OpeVS", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeVS)); this.DataBase.AddInParameter(storedProcCommand, "VS", DbType.Int32, (object)EntityFilter.VS); this.DataBase.AddInParameter(storedProcCommand, "OpeVD", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeVD)); this.DataBase.AddInParameter(storedProcCommand, "VD", DbType.Int32, (object)EntityFilter.VD); this.DataBase.AddInParameter(storedProcCommand, "OpeP", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeP)); this.DataBase.AddInParameter(storedProcCommand, "P", DbType.Int32, (object)EntityFilter.P); this.DataBase.AddInParameter(storedProcCommand, "OpeM", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeM)); this.DataBase.AddInParameter(storedProcCommand, "M", DbType.Int32, (object)EntityFilter.M); this.DataBase.AddInParameter(storedProcCommand, "OpeG", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeG)); this.DataBase.AddInParameter(storedProcCommand, "G", DbType.Int32, (object)EntityFilter.G); return(this.DataBase.ExecuteDataSet(storedProcCommand).Tables[0]); } } catch (SqlException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public vAlimentosDeEncuestasEntityInfo.vAlimentosDeEncuestasEntityInfoList Search(vAlimentosDeEncuestasEntityFilter EntityFilter, bool NoUtilizar) { try { return(this.DataTableToListOfEntityInfo(this.CreateDataAccess().Search(EntityFilter))); } catch (Exception ex) { Helpers.Logger.Logger.LogExceptionStatic(ex); throw ex; } }