void Fill(ConsultaGrid c) { int index = 0; lblTitle.Text = " Actualizar consulta en recepcion"; if (c.IdMutual.HasValue) { //index = cmbMutual.Properties.GetDataSourceRowIndex("IdMutual", c.IdMutual); //cmbMutual.ItemIndex = index; } if (c.IdProfecional.HasValue) { index = cmbProfecionales.Properties.GetDataSourceRowIndex("IdProfecional", c.IdProfecional); cmbProfecionales.ItemIndex = index; } if (c.IdTipoConsulta.HasValue) { index = cmbTipoConsulta.Properties.GetDataSourceRowIndex("IdParamComercial", c.IdTipoConsulta); cmbTipoConsulta.ItemIndex = index; } txtCliente.Text = c.NombreCliente; txtCoseguro.Text = c.Coseguro.Value.ToString(); txtArancelMutual.Text = c.ArancelMutual.Value.ToString(); txtObservacion.Text = c.Descripcion; txtNroAfiliado.Text = c.NroAfiliadoMutual; txtTelefono.Text = c.TelefonoCliente; chkPresentaOrden.Checked = c.PresentaOrden.Value; }
public override void Populate(object filter) { if (this.DesignMode) { return; } _Mutuales.AddRange(Controller.MutualList.Where <MutualBE>(p => p.IdMutual != (int)CommonValuesEnum.TodosComboBoxValue)); //cmbMutual.Properties.DataSource = _Mutuales; _ProfecionalList.AddRange(Controller.ProfecionalList.Where <ProfecionalBE>(p => p.IdProfecional != (int)CommonValuesEnum.TodosComboBoxValue)); cmbProfecionales.Properties.DataSource = _ProfecionalList; _TipoCons.AddRange(Controller.TipoConsultaList.Where <ParamComercialBE>(p => p.IdParamComercial != (int)CommonValuesEnum.TodosComboBoxValue)); cmbTipoConsulta.Properties.DataSource = _TipoCons; if (State != Fwk.Bases.EntityUpdateEnum.NEW) { _ConsultaGrid_ToUpdate = (ConsultaGrid)filter; } }
private void gridView1_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e) { selectedConsultaGrid = ((ConsultaGrid)gridControl1.FocusedView.GetRow(gridView1.FocusedRowHandle)); }
/// <summary> /// SearchByParam /// </summary> ///<param name="pConsulta">Consulta</param> /// <returns>ConsultaList</returns> /// <Date>2011-09-23T11:21:03</Date> /// <Author>marcelo</Author> public static ConsultaGridList SearchByParams_(ConsultaBE pConsulta) { Database wDataBase = null; DbCommand wCmd = null; ConsultaGridList wConsultaList = new ConsultaGridList(); ConsultaGrid wConsultaGrid; try { wDataBase = DatabaseFactory.CreateDatabase(CommonDAC.clinica_cnnstring); wCmd = wDataBase.GetStoredProcCommand("dbo.Consulta_s"); wDataBase.AddInParameter(wCmd, "IdTipoConsulta", System.Data.DbType.Int32, pConsulta.IdTipoConsulta); wDataBase.AddInParameter(wCmd, "IdProfecional", System.Data.DbType.Int32, pConsulta.IdProfecional); wDataBase.AddInParameter(wCmd, "IdMutual", System.Data.DbType.Int32, pConsulta.IdMutual); wDataBase.AddInParameter(wCmd, "FechaDesde", System.Data.DbType.DateTime, pConsulta.Fecha); wDataBase.AddInParameter(wCmd, "FechaHasta", System.Data.DbType.DateTime, pConsulta.FechaFin); if (!string.IsNullOrEmpty(pConsulta.NombreCliente)) { wDataBase.AddInParameter(wCmd, "NombreCliente", System.Data.DbType.String, pConsulta.NombreCliente); } wDataBase.AddInParameter(wCmd, "PresentaOrden", System.Data.DbType.Boolean, pConsulta.PresentaOrden); using (IDataReader reader = wDataBase.ExecuteReader(wCmd)) { while (reader.Read()) { wConsultaGrid = new ConsultaGrid(); wConsultaGrid.IdConsulta = Convert.ToInt32(reader["IdConsulta"]); wConsultaGrid.IdTipoConsulta = Convert.ToInt32(reader["IdTipoConsulta"]); if (reader["IdProfecional"] != DBNull.Value) { wConsultaGrid.IdProfecional = Convert.ToInt32(reader["IdProfecional"]); } wConsultaGrid.Descripcion = reader["Descripcion"].ToString(); wConsultaGrid.Coseguro = Convert.ToInt32(reader["Coseguro"]); wConsultaGrid.Fecha = Convert.ToDateTime(reader["Fecha"]); if (reader["IdMutual"] != DBNull.Value) { wConsultaGrid.IdMutual = Convert.ToInt32(reader["IdMutual"]); } wConsultaGrid.MutualNombre = reader["MutualNombre"].ToString(); wConsultaGrid.ProfecionalNombre = reader["ProfecionalNombre"].ToString(); wConsultaGrid.TelefonoCliente = reader["TelefonoCliente"].ToString(); wConsultaGrid.NombreCliente = reader["NombreCliente"].ToString(); wConsultaGrid.NroAfiliadoMutual = reader["NroAfiliadoMutual"].ToString(); if (reader["PresentaOrden"] != DBNull.Value) { wConsultaGrid.PresentaOrden = Convert.ToBoolean(reader["PresentaOrden"]); } if (reader["ExigeCoseguro"] != DBNull.Value) { wConsultaGrid.ExigeCoseguro = Convert.ToBoolean(reader["ExigeCoseguro"]); } if (reader["ArancelMutual"] != DBNull.Value) { wConsultaGrid.ArancelMutual = Convert.ToDecimal(reader["ArancelMutual"]); } wConsultaList.Add(wConsultaGrid); } } return(wConsultaList); } catch (Exception ex) { throw Fwk.Exceptions.ExceptionHelper.ProcessException(ex); } }