private void save() { if (u_Validate()) { if (Examinar.IsCurrentCellInEditMode) { Examinar.CommitEdit(DataGridViewDataErrorContexts.Commit); } Tabla.AcceptChanges(); for (lc_cont = 0; lc_cont <= Tabla.Rows.Count - 1; lc_cont++) { Tabla.Rows[lc_cont]["perianio"] = spnperiodo.Value.ToString(); Tabla.Rows[lc_cont]["perimes"] = cboMes.SelectedValue; Tabla.Rows[lc_cont]["tipoplla"] = cboTipoplanilla.SelectedValue; } Tabla.AcceptChanges(); var BL = new tb_plla_rubrosafectosleyestrabemplBL(); var BE = new tb_plla_rubrosafectosleyestrabempl(); BE.perianio = spnperiodo.Value.ToString(); BE.perimes = cboMes.SelectedValue.ToString(); BE.tipoplla = cboTipoplanilla.SelectedValue.ToString(); if (BL.Insert_Update(VariablesPublicas.EmpresaID, BE, Tabla)) { U_CancelarEdicion(0); } else { Frm_Class.ShowError(BL.Sql_Error, this); } } }
private void CargaDatos() { var xcodmes = "99"; var xtipoplanilla = "."; var sorted = default(SortOrder); var xnomcolumna = string.Empty; if (cboMes.SelectedValue != null) { xcodmes = cboMes.SelectedValue.ToString(); } if (cboTipoplanilla.SelectedValue != null) { xtipoplanilla = cboTipoplanilla.SelectedValue.ToString(); } if (Examinar.SortedColumn != null) { xnomcolumna = Examinar.Columns[Examinar.SortedColumn.Index].Name; sorted = Examinar.SortOrder; } var BL = new tb_plla_rubrosafectosleyestrabemplBL(); var BE = new tb_plla_rubrosafectosleyestrabempl(); BE.perianio = spnperiodo.Value.ToString(); BE.perimes = xcodmes; BE.tipoplla = xtipoplanilla; Tabla = BL.GetAll_CONSULTA(VariablesPublicas.EmpresaID, BE).Tables[0]; Examinar.AutoGenerateColumns = false; Examinar.DataSource = Tabla; }