private void CargaDatos() { var sorted = default(SortOrder); var xnomcolumna = string.Empty; if ((Examinar.SortedColumn != null)) { xnomcolumna = Examinar.Columns[Examinar.SortedColumn.Index].Name; sorted = Examinar.SortOrder; } var BL = new tb_plla_retencionquintaBL(); var BE = new tb_plla_retencionquinta(); BE.perianio = spnperiodo.Value.ToString(); Tabla = BL.GetAll_CONSULTA(VariablesPublicas.EmpresaID, BE).Tables[0]; Examinar.AutoGenerateColumns = false; Examinar.DataSource = Tabla; VariablesPublicas.PintaEncabezados(Examinar); Examinar.Sort(Examinar.Columns["nombrelargo"], System.ComponentModel.ListSortDirection.Ascending); }
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.AcceptChanges(); var BL = new tb_plla_retencionquintaBL(); var BE = new tb_plla_retencionquinta(); BE.perianio = spnperiodo.Value.ToString(); if (BL.Insert_Update(VariablesPublicas.EmpresaID, BE, Tabla)) { U_CancelarEdicion(0); } else { Frm_Class.ShowError(BL.Sql_Error, this); } } }
private void btnCalcular_Click(object sender, EventArgs e) { var xvmmes = string.Empty; if ((cbMes.SelectedValue != null)) { xvmmes = cbMes.SelectedValue.ToString(); } if (xvmmes.Trim().Length == 0) { MessageBox.Show("Seleccione mes", "Mensaje del Sistema"); return; } if (MessageBox.Show("Desea recalcular Renta Quinta" + "\r" + "La información existente será eliminada...?", string.Empty, MessageBoxButtons.YesNo) == DialogResult.Yes) { var BL = new tb_plla_retencionquintaBL(); var BE = new tb_plla_retencionquinta(); BE.perianio = spnperiodo.Value.ToString(); BE.perimes = xvmmes; BE.ntipo = 1; tmpcursor = BL.CalcularRta5ta(VariablesPublicas.EmpresaID, BE).Tables[0]; if (BL.Sql_Error.Length > 0) { Frm_Class.ShowError(BL.Sql_Error, this); return; } else { if (tmpcursor.Rows.Count > 0) { Tabla.AcceptChanges(); for (lc_cont = 0; lc_cont <= Tabla.Rows.Count - 1; lc_cont++) { Tabla.Rows[lc_cont].Delete(); } for (lc_cont = 0; lc_cont <= tmpcursor.Rows.Count - 1; lc_cont++) { Tabla.ImportRow(tmpcursor.Rows[lc_cont]); } Tabla.AcceptChanges(); } } } }