private void btn_ExportExcel_Click(object sender, EventArgs e) { /*//MessageBox.Show(Directory.GetFiles(@"\\10.72.221.18\02-PROYECTOS\").ToString()); * var _path = @"Z:\02-PROYECTOS"; * var _folders = Directory.GetDirectories(_path, "*", SearchOption.TopDirectoryOnly); * * var _this = ""; * foreach (var item in _folders) * { * var _depth1 = Directory.GetDirectories(Path.Combine(_path, item), "*", SearchOption.TopDirectoryOnly); * foreach (var item2 in _depth1) * { * if (item2.Contains("P70")) * _this += item2 + "\n"; * } * } * * MessageBox.Show(_this);*/ SaveFileDialog _dialog = new SaveFileDialog(); _dialog.RestoreDirectory = true; _dialog.InitialDirectory = @"Z:\02-PROYECTOS"; _dialog.Filter = "Excel File|*.xls"; _dialog.FileName = _proyecto.Cod + "_" + "BaseDatos.xlsx"; _dialog.Title = @"Guardar en: ...\01 Doc graficos\01 BIM\20_Recursos\02_Datos\"; DialogResult _result = _dialog.ShowDialog(); if (_result == DialogResult.OK) { //var _filepath = Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "/" + _proyecto.Cod + "_" + "BaseDatos.xlsx"; var _filepath = _dialog.FileName; var _file = new FileInfo(_filepath); using (var _excelPackage = new ExcelPackage(_file)) { if (_excelPackage.Workbook.Worksheets.FirstOrDefault(x => x.Name == "BaseDatos") != null) { _excelPackage.Workbook.Worksheets.Delete("BaseDatos"); } ExcelWorksheet _worksheet = _excelPackage.Workbook.Worksheets.Add("BaseDatos"); _worksheet.Cells["A1:AK10000"].AutoFilter = true; #region Encabezados //Encabezados //RoomID MakeHeader(ref _worksheet, 1, "RoomID"); //Cod0 MakeHeader(ref _worksheet, 2, "Cod0"); //Cod1 MakeHeader(ref _worksheet, 3, "Cod1"); //Cod2 MakeHeader(ref _worksheet, 4, "Cod2"); //KeyName MakeHeader(ref _worksheet, 5, "Key Name"); //Name MakeHeader(ref _worksheet, 6, "Name"); //Coef/Area MakeHeader(ref _worksheet, 7, "CoeficienteArea"); //Coef/NumHab MakeHeader(ref _worksheet, 8, "CoeficienteNumHab"); //PorcientoBD MakeHeader(ref _worksheet, 9, "PorcientoBD"); //Habitacion MakeHeader(ref _worksheet, 10, "Habitacion"); //Modulo MakeHeader(ref _worksheet, 11, "Modulo"); //TipoEdificio MakeHeader(ref _worksheet, 12, "TipoEdificio"); //SubsistemaTipo MakeHeader(ref _worksheet, 13, "SubsistemaTipo"); //SubsistemaArea MakeHeader(ref _worksheet, 14, "SubsistemaArea"); //LocalTipo MakeHeader(ref _worksheet, 15, "LocalTipo"); //AmbienteClave MakeHeader(ref _worksheet, 16, "AmbienteClave"); //Floor MakeHeader(ref _worksheet, 17, "Floor"); //Rodapie MakeHeader(ref _worksheet, 18, "Rodapie"); //WallFinish MakeHeader(ref _worksheet, 19, "WallFinish"); //CeilingFinish MakeHeader(ref _worksheet, 20, "CeilingFinish"); //BaseFinish MakeHeader(ref _worksheet, 21, "BaseFinish"); //Tratamiento MakeHeader(ref _worksheet, 22, "Tratamiento"); //Equipamiento MakeHeader(ref _worksheet, 23, "Equipamiento"); //Criterio[m²/ kW] MakeHeader(ref _worksheet, 24, "Criterio[m²/ kW]"); //Criterio [W/m²] MakeHeader(ref _worksheet, 25, "Criterio [W/m²]"); //Aire Fresco [m³/h*m²] MakeHeader(ref _worksheet, 26, "Aire Fresco [m³/h*m²]"); //Aire Fresco [m³/h*personas] MakeHeader(ref _worksheet, 27, "Aire Fresco [m³/h*personas]"); //Renovaciones[Cambios / hr] MakeHeader(ref _worksheet, 28, "Renovaciones[Cambios / hr]"); //W_Aire MakeHeader(ref _worksheet, 29, "W_Aire"); //TF MakeHeader(ref _worksheet, 30, "TF"); //TD MakeHeader(ref _worksheet, 31, "TD"); //TD_POS MakeHeader(ref _worksheet, 32, "TD_POS"); //UPSC MakeHeader(ref _worksheet, 33, "UPSC"); //UPSI MakeHeader(ref _worksheet, 34, "UPSI"); //TT_TV MakeHeader(ref _worksheet, 35, "TT_TV"); //DI MakeHeader(ref _worksheet, 36, "DI"); //ALTV MakeHeader(ref _worksheet, 37, "ALTV"); #endregion var _locales = new DB_PLANTILLA().GetAllRecords <T_Local>(); var _grupoLocales = new DB_PLANTILLA().GetAllRecords <T_Grupo_Locales>(); var _porcientos = new DB_PLANTILLA().GetAllRecords <T_Porciento_BD>(); var _suelos = new DB_PLANTILLA().GetAllRecords <T_Catalogo_Suelo>(); var _rodapie = new DB_PLANTILLA().GetAllRecords <T_Catalogo_Rodapie>(); var _pared = new DB_PLANTILLA().GetAllRecords <T_Catalogo_Pared>(); var _techos = new DB_PLANTILLA().GetAllRecords <T_Catalogo_Techo>(); var _impermeables = new DB_PLANTILLA().GetAllRecords <T_Catalogo_Impermeable>(); SplashScreenManager.ShowForm(typeof(WaitScreen)); for (int i = 0; i < _localesByProject.Count; i++) { var _local = _locales.FirstOrDefault(x => x.RoomId == _localesByProject[i].Local1.RoomId); _worksheet.Cells[i + 2, 1].Value = _localesByProject[i].Local1.RoomId; var _cod1 = _grupoLocales.FirstOrDefault(x => x.Id == _localesByProject[i].Local1.LocalTipo.Grupo_Locales).Cod1; _worksheet.Cells[i + 2, 2].Value = _cod1.Split('.').First(); _worksheet.Cells[i + 2, 3].Value = _cod1; _worksheet.Cells[i + 2, 4].Value = _localesByProject[i].Local1.CalcularCod2(); _worksheet.Cells[i + 2, 5].Value = _local.Key_Name; _worksheet.Column(5).AutoFit(); _worksheet.Cells[i + 2, 6].Value = _localesByProject[i].Local1.Key_Name; _worksheet.Column(6).AutoFit(); _worksheet.Cells[i + 2, 7].Value = _localesByProject[i].Local1.CoefArea.Value; _worksheet.Cells[i + 2, 8].Value = _localesByProject[i].Local1.GetCoefNumHab(_proyecto.Cant_Habitaciones.GetValueOrDefault()); _worksheet.Cells[i + 2, 9].Value = _porcientos.FirstOrDefault(x => x.Id == _localesByProject[i].Local1.Porciento_BD).Value.GetValueOrDefault().ToString("#,##"); _worksheet.Cells[i + 2, 10].Value = _local.Habitacion.GetValueOrDefault() ? "1" : "0"; _worksheet.Cells[i + 2, 11].Value = _local.Mod.GetValueOrDefault(); _worksheet.Cells[i + 2, 12].Value = _local.T_Tipo_Edificio.Value; _worksheet.Column(12).AutoFit(); _worksheet.Cells[i + 2, 13].Value = _local.T_Subsistema_Tipo.Value; _worksheet.Column(13).AutoFit(); _worksheet.Cells[i + 2, 14].Value = _local.T_Subsistema_Area.Value; _worksheet.Column(14).AutoFit(); _worksheet.Cells[i + 2, 15].Value = _localesByProject[i].Local1.LocalTipo.Value; _worksheet.Column(15).AutoFit(); _worksheet.Cells[i + 2, 16].Value = _localesByProject[i].Local1.Ambiente1.Nombre; _worksheet.Column(16).AutoFit(); _worksheet.Cells[i + 2, 17].Value = _suelos.FirstOrDefault(x => x.Id == _localesByProject[i].Local1.Ambiente1.Suelo).Cod; _worksheet.Cells[i + 2, 18].Value = _rodapie.FirstOrDefault(x => x.Id == _localesByProject[i].Local1.Ambiente1.Rodapie).Cod; _worksheet.Cells[i + 2, 19].Value = _pared.FirstOrDefault(x => x.Id == _localesByProject[i].Local1.Ambiente1.Pared).Cod; _worksheet.Cells[i + 2, 20].Value = _techos.FirstOrDefault(x => x.Id == _localesByProject[i].Local1.Ambiente1.Techo).Cod; _worksheet.Cells[i + 2, 21].Value = _impermeables.FirstOrDefault(x => x.Id == _localesByProject[i].Local1.Ambiente1.Impermeable).Cod; _worksheet.Cells[i + 2, 22].Value = _localesByProject[i].Local1.Climatizacion1.Tratamiento1.Value; _worksheet.Cells[i + 2, 23].Value = _localesByProject[i].Local1.Climatizacion1.Equipamiento1.Value; var _criterio = _localesByProject[i].Local1.Climatizacion1.Criterio1.Value == "-" ? 0 : float.Parse(_localesByProject[i].Local1.Climatizacion1.Criterio1.Value); _worksheet.Cells[i + 2, 24].Value = _criterio; _worksheet.Cells[i + 2, 25].Value = _criterio / 1000; _worksheet.Cells[i + 2, 26].Value = _localesByProject[i].Local1.Climatizacion1.Aire_Fresco1.AF_Metro_Cuadrado.Value; _worksheet.Cells[i + 2, 27].Value = _localesByProject[i].Local1.Climatizacion1.Aire_Fresco1.AF_Persona.Value; _worksheet.Cells[i + 2, 28].Value = _localesByProject[i].Local1.Climatizacion1.Renovaciones1.Value; _worksheet.Cells[i + 2, 28].Value = _localesByProject[i].Local1.Climatizacion1.W_Aire1.Value; _worksheet.Cells[i + 2, 29].Value = _localesByProject[i].Local1.Comunicaciones_Tv1.TF1.Value; _worksheet.Cells[i + 2, 30].Value = _localesByProject[i].Local1.Comunicaciones_Tv1.TD1.Value; _worksheet.Cells[i + 2, 31].Value = _localesByProject[i].Local1.Comunicaciones_Tv1.TD_Pos1.Value; _worksheet.Cells[i + 2, 32].Value = _localesByProject[i].Local1.Comunicaciones_Tv1.UPSC1.Value; _worksheet.Cells[i + 2, 33].Value = _localesByProject[i].Local1.Comunicaciones_Tv1.UPSI1.Value; _worksheet.Cells[i + 2, 34].Value = _localesByProject[i].Local1.Comunicaciones_Tv1.TT_TV1.Value; _worksheet.Cells[i + 2, 35].Value = _localesByProject[i].Local1.Comunicaciones_Tv1.DI1.Value; _worksheet.Cells[i + 2, 36].Value = _localesByProject[i].Local1.Comunicaciones_Tv1.ALTV1.Value; } if (_excelPackage.Workbook.Worksheets.FirstOrDefault(x => x.Name == DateTime.Now.ToString("yyyyMMdd") + "-Programa") != null) { _excelPackage.Workbook.Worksheets.Delete(DateTime.Now.ToString("yyyyMMdd") + "-Programa"); } _worksheet = _excelPackage.Workbook.Worksheets.Add(DateTime.Now.ToString("yyyyMMdd") + "-Programa"); MakeHeader(ref _worksheet, 1, "Cod1"); MakeHeader(ref _worksheet, 2, "Cod2"); MakeHeader(ref _worksheet, 3, "Cod3"); MakeHeader(ref _worksheet, 4, "Obj. Obra"); MakeHeader(ref _worksheet, 5, "Local Tipo"); MakeHeader(ref _worksheet, 6, "Nombre"); MakeHeader(ref _worksheet, 7, "Cantidad"); MakeHeader(ref _worksheet, 8, "Área Útil"); MakeHeader(ref _worksheet, 9, "Porciento BD"); MakeHeader(ref _worksheet, 10, "Área Calculo"); var orderedList = _localesByProject.OrderBy(l => l.Local1.Desglose1.Value).ThenBy(l => l.Local1.LocalTipo.Value).ToList(); var desglose = ""; var localTipo = ""; for (int i = 0; i < orderedList.Count; i++) { _worksheet.Cells[i + 2, 1].Value = _locales.FirstOrDefault(l => l.RoomId == orderedList[i].Local1.RoomId).T_Grupo_Locales.Cod1;; _worksheet.Cells[i + 2, 2].Value = orderedList[i].Local1.CalcularCod2(); _worksheet.Cells[i + 2, 3].Value = orderedList[i].Local1.CalcularCod3(); _worksheet.Cells[i + 2, 4].Value = orderedList[i].Local1.Desglose1.Value.ToUpper(); _worksheet.Cells[i + 2, 5].Value = orderedList[i].Local1.LocalTipo.Value.ToUpper(); _worksheet.Cells[i + 2, 6].Value = orderedList[i].Local1.Key_Name; _worksheet.Cells[i + 2, 6].AutoFitColumns(); _worksheet.Cells[i + 2, 7].Value = orderedList[i].Cantidad; float coefArea = float.Parse(orderedList[i].Local1.CoefArea.Value); var areaUtil = orderedList[i].Local1.CalcularArea(_proyecto.Cant_Habitaciones.GetValueOrDefault()); _worksheet.Cells[i + 2, 8].Value = areaUtil; double porcientos = double.Parse(_porcientos.FirstOrDefault(p => p.Id == orderedList[i].Local1.Porciento_BD).Value.ToString()); _worksheet.Cells[i + 2, 9].Value = ModificarPorcientos(_porcientos.FirstOrDefault(p => p.Id == orderedList[i].Local1.Porciento_BD).Value.ToString().Replace('.', ',')); var areaCalculo = areaUtil * porcientos; _worksheet.Cells[i + 2, 10].Value = areaCalculo; #region codigo viejo //if (orderedList[i].Local1.Desglose1.Value == desglose) //{ // if (orderedList[i].Local1.LocalTipo.Value == localTipo) // { // _worksheet.Cells[i + 1, 1].Value = _locales.FirstOrDefault(l => l.RoomId == orderedList[i].Local1.RoomId).T_Grupo_Locales.Cod1; ; // _worksheet.Cells[i + 1, 2].Value = orderedList[i].Local1.CalcularCod2(); // _worksheet.Cells[i + 1, 3].Value = orderedList[i].Local1.CalcularCod3(); // _worksheet.Cells[i + 1, 5].Value = orderedList[i].Local1.Key_Name; // _worksheet.Cells[i + 1, 5].AutoFitColumns(); // _worksheet.Cells[i + 1, 6].Value = orderedList[i].Cantidad; // float coefArea = float.Parse(orderedList[i].Local1.CoefArea.Value); // var areaUtil = orderedList[i].Local1.CalcularArea(_proyecto.Cant_Habitaciones.GetValueOrDefault()); // //_worksheet.Cells[i + 1, 7].Value = coefArea; // _worksheet.Cells[i + 1, 7].Value = areaUtil; // double porcientos = double.Parse(_porcientos.FirstOrDefault(p => p.Id == orderedList[i].Local1.Porciento_BD).Value.ToString()); // _worksheet.Cells[i + 1, 8].Value = ModificarPorcientos(_porcientos.FirstOrDefault(p => p.Id == orderedList[i].Local1.Porciento_BD).Value.ToString().Replace('.',',')); // //var areaUtil = coefArea*porcientos; // var areaCalculo = areaUtil * porcientos; // _worksheet.Cells[i + 1, 9].Value = areaCalculo; // } // else // { // localTipo = orderedList[i].Local1.LocalTipo.Value; // _worksheet.Cells[i + 1, 4].Value = localTipo.ToUpper(); // } //} //else //{ // desglose = orderedList[i].Local1.Desglose1.Value; // _worksheet.Cells[i + 1, 4].Value = desglose.ToUpper(); //} #endregion } SplashScreenManager.CloseForm(); _excelPackage.Save(); MessageBox.Show("¡Exportado con éxito!"); } } }
private void simpleButton1_Click(object sender, EventArgs e) { var _selectedGrid = gridControlPrograma.Visible ? gridPrograma : gridDetalle; var _subsistemasTipo = new DB_PLANTILLA().GetAllRecords <T_Subsistema_Tipo>(); var _subsistemasArea = new DB_PLANTILLA().GetAllRecords <T_Subsistema_Area>(); var _grupoLocales = new DB_PLANTILLA().GetAllRecords <T_Grupo_Locales>(); var _porcientos = new DB_PLANTILLA().GetAllRecords <T_Porciento_BD>(); var _coefAreas = new DB_PLANTILLA().GetAllRecords <T_CoefArea>(); var _locales = new DB_PLANTILLA().GetAllRecords <T_Local>(); for (int i = 0; i < _selectedGrid.DataRowCount; i++) { try { _selectedGrid.FocusedRowHandle = i; Local _local = new Local(); Locales_Proyecto _localProyecto = new Locales_Proyecto(); var _subsistemaTipo = ""; var _subsistemaArea = ""; GetSubsistemas(_selectedGrid.GetRowCellValue(i, "Cod2").ToString(), ref _subsistemaTipo, ref _subsistemaArea, _selectedGrid.GetRowCellValue(i, "Cod1").ToString()); //var _subTipoValue = _selectedGrid.GetRowCellValue(i, "Subsistema Tipo").ToString(); _local.SubsistemaTipo = _subsistemasTipo.FirstOrDefault(x => x.Value == _subsistemaTipo).Id; //var _subAreaValue = _selectedGrid.GetRowCellValue(i, "Subsistema Area").ToString(); _local.SubsistemaArea = _subsistemasArea.FirstOrDefault(x => x.Value == _subsistemaArea).Id; var _localTipoValue = _selectedGrid.GetRowCellValue(i, "LocalTipo").ToString(); var _cod1Value = _selectedGrid.GetRowCellValue(i, "Cod1").ToString().Replace(',', '.'); var _grupoLocal = _grupoLocales.FirstOrDefault(x => x.Cod1.Contains(_cod1Value)).Id; LocalTipo _localTipo = new LocalTipo() { Grupo_Locales = _grupoLocal, Value = _localTipoValue }; var _porcientoBD = double.Parse(_selectedGrid.GetRowCellValue(i, "PorcientoBD").ToString()); //_porcientoBD = _porcientoBD / 100; _local.Porciento_BD = _porcientos.FirstOrDefault(x => x.Value == _porcientoBD).Id; var _areaUtil = _selectedGrid.GetRowCellValue(i, "AreaLocal").ToString() == "" ? 0.00 : double.Parse(_selectedGrid.GetRowCellValue(i, "AreaLocal").ToString()); CoefArea _coef = new CoefArea() { Area_Local = _areaUtil }; var _desgloseValue = _selectedGrid.GetRowCellValue(i, "Desglose").ToString(); var _desglose = new DB_BIM().GetSingleElement <Desglose>(x => x.Value == _desgloseValue && x.Proyecto == _proyecto.Id); if (_desglose != null) { _local.Desglose = _desglose.Id; } else { Desglose _newDesglose = new Desglose() { Value = _desgloseValue, Proyecto = _proyecto.Id }; _local.Desglose1 = _newDesglose; } var _localID = _locales.FirstOrDefault(x => x.Key_Name == _selectedGrid.GetRowCellValue(i, "RoomID").ToString()); var keyName = _selectedGrid.GetRowCellValue(i, "Local").ToString(); var localesProyecto = new DB_BIM().GetElements <Locales_Proyecto>(x => x.Proyecto == _proyecto.Id); var realLocal = localesProyecto.FirstOrDefault( x => x.Local1.Desglose == _local.Desglose && x.Local1.LocalTipo == _localTipo && x.Local1.Key_Name == keyName); if (realLocal != null) { LocalController.UpdateLocalesProyecto(realLocal); } else { _local.RoomId = _localID.RoomId; _local.CoefArea = _coef; _local.CoefArea.Value = _coefAreas.FirstOrDefault(x => x.Id == _localID.Coef_Area).Value; _local.LocalTipo = _localTipo; _local.Key_Name = keyName; _local.Ambiente1 = _localID.T_Ambiente.ToProject(); _local.Comunicaciones_Tv1 = _localID.T_Comunicaciones_Tv.ToProject(); _local.Climatizacion1 = _localID.T_Climatizacion.ToProject(); _localProyecto.Local1 = _local; _localProyecto.Proyecto = _proyecto.Id; _localProyecto.Cantidad = _selectedGrid.GetRowCellValue(i, "Hab") == null ? 0 : int.Parse(_selectedGrid.GetRowCellValue(i, "Hab").ToString()); new DB_BIM().AddElemento <Locales_Proyecto>(typeof(Locales_Proyecto), _localProyecto); } } catch (Exception ex) { Excepciones.Excepciones.EnviarCorreo(ex); //throw; } } MessageBox.Show("Completado!"); }
void AddGridViewRow(Locales_Proyecto localProyecto) { var _local = localProyecto.GetLocal(); var _proyecto = localProyecto.GetProyecto(); var _subsistemasTipo = new DB_PLANTILLA().GetAllRecords <T_Subsistema_Tipo>(); var _subsistemasArea = new DB_PLANTILLA().GetAllRecords <T_Subsistema_Area>(); var _localesTipo = new DB_BIM().GetAllElements <LocalTipo>(); var _grupoLocales = new DB_PLANTILLA().GetAllRecords <T_Grupo_Locales>(); var _cod1 = _grupoLocales.FirstOrDefault(x => x.Id == _localesTipo.FirstOrDefault(y => y.Id == _local.Local_Tipo).Grupo_Locales).Cod1; var _porcientos = new DB_PLANTILLA().GetAllRecords <T_Porciento_BD>(); var _coeficientes = new DB_BIM().GetAllElements <CoefArea>(); var _desgloses = new DB_BIM().GetElements <Desglose>(x => x.Proyecto == _proyecto.Id); gridView1.AddNewRow(); var _rowHandle = gridView1.GetRowHandle(gridView1.DataRowCount); if (gridView1.IsNewItemRow(_rowHandle)) { var _coef = _coeficientes.FirstOrDefault(x => x.Id == _local.Coef_Area); if (_coef.Value == null) { _coef.Value = "0"; } //var _coefValue = float.Parse(_coef.Value); var _coefCalc = AddNewRoom(_local.RoomId); var _coefValue = 0f; _coefValue = float.Parse(_coefCalc.Area_Programa?.ToString() ?? _coef.Value); //var _coefValue = float.Parse(_coef.Value); //var _coefValue = _local.CoefArea == null ? float.Parse(_coef.Value) : float.Parse(_local.CoefArea.Value); //var _coefValue = _coef.Value == null ? 0.0 : float.Parse(_coef.Value); var _coefNumHab = _local.GetCoefNumHab(_proyecto.Cant_Habitaciones.GetValueOrDefault()); var _porciento = _porcientos.FirstOrDefault(x => x.Id == _local.Porciento_BD).Value; var _areaPrograma = (_coefValue * _coefNumHab); var _areaCalculo = (_areaPrograma * _porciento).GetValueOrDefault().ToString("#.##"); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["Obj. Obra"], _desgloses.FirstOrDefault(x => x.Id == _local.Desglose).Value); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["RoomID"], _local.RoomId); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["ID"], _local.Id); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["Local"], _local.Key_Name); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["SubsistemaTipo"], _subsistemasTipo.FirstOrDefault(x => x.Id == _local.SubsistemaTipo).Value); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["SubsistemaArea"], _subsistemasArea.FirstOrDefault(x => x.Id == _local.SubsistemaArea).Value); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["LocalTipo"], _localesTipo.FirstOrDefault(x => x.Id == _local.Local_Tipo).Value); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["Cod1"], _cod1); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["Cod2"], _local.CalcularCod2()); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["Cod3"], _local.CalcularCod3()); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["Hab"], localProyecto.Local1.Habitacion.GetValueOrDefault() ? "1" : "0"); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["Cantidad"], localProyecto.Cantidad); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["Coef/Area"], _coef.Area_Programa); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["Coef/Num.Habitaciones"], _coefNumHab); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["Área Útil [m²]"], _coef.Area_Local); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["Promedio de % Base Diseño"], _porciento); gridView1.SetRowCellValue(_rowHandle, gridView1.Columns["Áreas De Cálculo [m²]"], _areaCalculo); } gridView1.Focus(); }