private void save() { if (u_Validate()) { tmpcursor = null; var BL = new tb_plla_valor_uitBL(); var BE = new tb_plla_valor_uit(); BE.perianio = txtcodigo.Text.Trim(); tmpcursor = BL.GetAll_CONSULTA(VariablesPublicas.EmpresaID, BE).Tables[0]; if (BL.Sql_Error.Length > 0) { Frm_Class.ShowError(BL.Sql_Error, this); return; } if (tmpcursor.Rows.Count == 0) { tmpcursor.Rows.Add(VariablesPublicas.INSERTINTOTABLE(tmpcursor)); } tmpcursor.Rows[tmpcursor.Rows.Count - 1]["perianio"] = txtcodigo.Text.Trim(); tmpcursor.Rows[tmpcursor.Rows.Count - 1]["perimes"] = cmbmes.SelectedValue; tmpcursor.Rows[tmpcursor.Rows.Count - 1]["valoruit"] = VariablesPublicas.StringtoDecimal(txtvaloruit.Text); tmpcursor.Rows[tmpcursor.Rows.Count - 1]["status"] = '0'; tmpcursor.Rows[tmpcursor.Rows.Count - 1]["sdomin"] = VariablesPublicas.StringtoDecimal(txtsueldomin.Text); tmpcursor.AcceptChanges(); if (BL.Insert_Update(VariablesPublicas.EmpresaID, BE, tmpcursor)) { U_CancelarEdicion(0); } else { Frm_Class.ShowError(BL.Sql_Error, this); } } }
private void Accion(int naccion) { switch (naccion) { case 1: u_n_opsel = 1; U_RefrescaControles(); Blanquear(); txtcodigo.Text = VariablesPublicas.perianio; if ((Examinar.CurrentRow != null)) { Examinar.CurrentRow.Selected = false; } break; case 2: POnedatos(); u_n_opsel = 2; U_RefrescaControles(); Examinar.CurrentRow.Selected = true; break; case 3: xnomcampo = ""; if ((Examinar.CurrentRow != null)) { if (xnomcampo.Length == 0) { var message = "Desea Eliminar Registro ...?"; var caption = "Mensaje del Sistema"; var buttons = MessageBoxButtons.YesNo; DialogResult result; result = MessageBox.Show(this, message, caption, buttons, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); if (result == DialogResult.Yes) { var BL = new tb_plla_valor_uitBL(); var BE = new tb_plla_valor_uit(); BE.perianio = Examinar.Rows[Examinar.CurrentRow.Index].Cells["perianio"].Value.ToString().Trim(); tmpcursor = BL.GetAll_CONSULTA(VariablesPublicas.EmpresaID, BE).Tables[0]; if (BL.Sql_Error.Length == 0) { if (BL.Eliminar(VariablesPublicas.EmpresaID, tmpcursor)) { for (lc_cont = 0; lc_cont <= Tabla.Rows.Count - 1; lc_cont++) { if (Tabla.Rows[lc_cont]["perianio"].ToString() == Examinar.Rows[Examinar.CurrentRow.Index].Cells["perianio"].Value.ToString()) { Tabla.Rows[lc_cont].Delete(); Tabla.AcceptChanges(); break; } } Examinar.Refresh(); } else { Frm_Class.ShowError(BL.Sql_Error, this); } } else { Frm_Class.ShowError(BL.Sql_Error, this); } } } else { MessageBox.Show(xnomcampo, "IMPOSIBLE ELIMINAR REGISTRO"); } } break; } }
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_valor_uitBL(); var BE = new tb_plla_valor_uit(); Tabla = BL.GetAll_CONSULTA(VariablesPublicas.EmpresaID, BE).Tables[0]; Examinar.AutoGenerateColumns = false; Examinar.DataSource = Tabla; if (xnomcolumna.Trim().Length > 0) { if (sorted == SortOrder.Ascending) { Examinar.Sort(Examinar.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Ascending); } else { Examinar.Sort(Examinar.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Descending); } } else { Examinar.Sort(Examinar.Columns["perianio"], System.ComponentModel.ListSortDirection.Descending); } }