private void get_cbo_modulo() { var BL = new sys_dominioBL(); try { cbomodulo.DataSource = BL.GetAllDominioModuloPorUsuario(EmpresaID, VariablesPublicas.Usuar, dominio).Tables[0]; cbomodulo.ValueMember = "moduloid"; cbomodulo.DisplayMember = "moduloname"; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ValidaDominio() { if (dominioid.Text.Trim().Length > 0) { sys_dominioBL BL = new sys_dominioBL(); tb_sys_dominio BE = new tb_sys_dominio(); DataTable dt = new DataTable(); BE.dominioid = dominioid.Text.Trim().PadLeft(2, '0'); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { dominioid.Text = dt.Rows[0]["dominioid"].ToString().Trim(); dominioname.Text = dt.Rows[0]["dominioname"].ToString().Trim(); } else { dominioid.Text = ""; dominioname.Text = ""; } } else { dominioid.Text = ""; dominioname.Text = ""; } }
private void fill_cboModuloid() { var BL = new sys_dominioBL(); try { cboModuloid.DataSource = BL.GetAllDominioModuloPorUsuario(VariablesPublicas.EmpresaID, VariablesPublicas.Usuar, "60").Tables[0]; cboModuloid.ValueMember = "moduloid"; cboModuloid.DisplayMember = "moduloname"; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } cboModuloid.SelectedValue = modulo; if (cboModuloid.Items.Count > 0) { fill_cbolocal(dominio, cboModuloid.SelectedValue.ToString()); } }
private void get_cbo_modulo2() { var BL = new sys_dominioBL(); var dt = new DataTable(); try { dt = BL.GetAllDominioModuloPorUsuario(VariablesPublicas.EmpresaID, VariablesPublicas.Usuar, "60").Tables[0]; if (dt.Rows.Count > 0) { cboModuloID2.DataSource = dt; cboModuloID2.ValueMember = "moduloid"; cboModuloID2.DisplayMember = "moduloname"; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void get_cargarComboDominio() { sys_dominioBL BL = new sys_dominioBL(); tb_sys_dominio BE = new tb_sys_dominio(); DataTable dt = new DataTable(); Tdominio = BL.GetAllDominioPorUsuario(VariablesPublicas.EmpresaID, VariablesPublicas.Usuar).Tables[0]; if (Tdominio.Rows.Count > 0) { try { dt = BL.GetAllDominioPorUsuario(VariablesPublicas.EmpresaID, VariablesPublicas.Usuar).Tables[0]; cboDominioID.DataSource = dt; cboDominioID.ValueMember = "dominioid"; cboDominioID.DisplayMember = "dominioname"; } catch (Exception ex) { MessageBoxEx.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } get_cbo_modulo(); } else { MessageBoxEx.Show("Usuario no tiene definido Dominio y Módulo... " + "\r" + "Consulte con Sistemas !!!", "Mensaje del Sistema", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } }
private void get_cbo_modulo() { sys_dominioBL BL = new sys_dominioBL(); tb_sys_dominio BE = new tb_sys_dominio(); DataTable dt = new DataTable(); try { dt = BL.GetAllDominioModuloPorUsuario(VariablesPublicas.EmpresaID, VariablesPublicas.Usuar, cboDominioID.SelectedValue.ToString()).Tables[0]; cboModuloID.DataSource = dt; cboModuloID.ValueMember = "moduloid"; cboModuloID.DisplayMember = "moduloname"; } catch (Exception ex) { MessageBoxEx.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } if (cboModuloID.Items.Count > 0) { get_dominio_modulo_local(cboDominioID.SelectedValue.ToString(), cboModuloID.SelectedValue.ToString()); } }
private void get_cargarComboDominio() { var BL = new sys_dominioBL(); try { cboDominioID.DataSource = BL.GetAllDominioPorUsuario(VariablesPublicas.EmpresaID, VariablesPublicas.Usuar).Tables[0]; cboDominioID.ValueMember = "dominioid"; cboDominioID.DisplayMember = "dominioname"; if (_dominioid != null) { cboDominioID.SelectedValue = _dominioid; get_cbo_modulo(); } else { get_cbo_modulo(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void get_cbo_modulo() { var BL = new sys_dominioBL(); try { cboModuloID.DataSource = BL.GetAllDominioModuloPorUsuario(VariablesPublicas.EmpresaID, VariablesPublicas.Usuar, cboDominioID.SelectedValue.ToString()).Tables[0]; cboModuloID.ValueMember = "moduloid"; cboModuloID.DisplayMember = "moduloname"; if (_moduloid != null) { cboModuloID.SelectedValue = _moduloid; if (cboModuloID.Items.Count > 0) { get_dominio_modulo_local(cboDominioID.SelectedValue.ToString(), cboModuloID.SelectedValue.ToString()); } } else { if (cboModuloID.Items.Count > 0) { get_dominio_modulo_local(cboDominioID.SelectedValue.ToString(), cboModuloID.SelectedValue.ToString()); } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ValidaDominio_nuevo() { var BL = new sys_dominioBL(); var BE = new tb_sys_dominio(); var dt = new DataTable(); BE.dominioid = dominioid.Text.Trim(); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count == 0) { mensaje.Text = "VALIDO"; mensaje.ForeColor = Color.Green; form_bloqueado(true); dominioname.Focus(); btn_cancelar.Enabled = true; btn_grabar.Enabled = true; } else { mensaje.Text = "YA EXISTE"; mensaje.ForeColor = Color.Red; dominioid.Focus(); } }
private void ValidaDominio() { if (dominioid.Text.Trim().Length > 0) { var BL = new sys_dominioBL(); var BE = new tb_sys_dominio(); var dt = new DataTable(); BE.dominioid = dominioid.Text.Trim().PadLeft(2, '0'); dt = BL.GetAll(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { dominioid.Text = dt.Rows[0]["dominioid"].ToString().Trim(); dominioname.Text = dt.Rows[0]["dominioname"].ToString().Trim(); } else { dominioid.Text = string.Empty; dominioname.Text = string.Empty; moduloid.Text = string.Empty; moduloname.Text = string.Empty; xlocal.Text = string.Empty; localname.Text = string.Empty; moduloid.Enabled = false; xlocal.Enabled = false; } } else { dominioid.Text = string.Empty; dominioname.Text = string.Empty; moduloid.Text = string.Empty; moduloname.Text = string.Empty; xlocal.Text = string.Empty; localname.Text = string.Empty; moduloid.Enabled = false; xlocal.Enabled = false; } }
private void Update() { try { if (dominioid.Text.Trim().Length != 2) { MessageBox.Show("Ingrese Código de dominio", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { if (dominioname.Text.Trim().Length == 0) { MessageBox.Show("Ingrese nombre de Dominio", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { var BL = new sys_dominioBL(); var BE = new tb_sys_dominio(); BE.dominioid = dominioid.Text.Trim(); BE.dominioname = dominioname.Text.Trim().ToUpper(); if (BL.Update(EmpresaID, BE)) { SEGURIDAD_LOG("M"); MessageBox.Show("Datos modificado correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information); procesado = true; } } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void form_cargar_datos(String posicion) { try { var BL = new sys_dominioBL(); var BE = new tb_sys_dominio(); var dt = new DataTable(); BE.dominioid = dominioid.Text.Trim(); BE.posicion = posicion.Trim(); dt = BL.GetAll_paginacion(EmpresaID, BE).Tables[0]; if (dt.Rows.Count > 0) { ssModo = "EDIT"; limpiar_documento(); dominioid.Text = dt.Rows[0]["dominioid"].ToString().Trim(); dominioname.Text = dt.Rows[0]["dominioname"].ToString().Trim(); btn_editar.Enabled = true; btn_eliminar.Enabled = true; btn_imprimir.Enabled = true; btn_primero.Enabled = true; btn_anterior.Enabled = true; btn_siguiente.Enabled = true; btn_ultimo.Enabled = true; btn_buscar.Enabled = true; btn_log.Enabled = true; btn_salir.Enabled = true; } else { limpiar_documento(); btn_editar.Enabled = false; btn_eliminar.Enabled = false; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Delete() { try { if (dominioid.Text.Trim().Length != 2) { MessageBox.Show("Ingrese Código de dominio", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } else { var BL = new sys_dominioBL(); var BE = new tb_sys_dominio(); BE.dominioid = dominioid.Text.Trim(); if (BL.Delete(EmpresaID, BE)) { SEGURIDAD_LOG("E"); MessageBox.Show("Datos Eliminado correctamente !!!", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information); NIVEL_FORMS(); limpiar_documento(); form_bloqueado(false); data_Tabladominio(); btn_nuevo.Enabled = true; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void data_Tabladominio() { try { if (Tabladominio != null) { Tabladominio.Rows.Clear(); } var BL = new sys_dominioBL(); var BE = new tb_sys_dominio(); Tabladominio = BL.GetAll(EmpresaID, BE).Tables[0]; if (Tabladominio.Rows.Count > 0) { btn_imprimir.Enabled = true; griddominio.DataSource = Tabladominio; griddominio.Rows[0].Selected = false; griddominio.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void data_cbo_dominio() { try { var BL = new sys_dominioBL(); var BE = new tb_sys_dominio(); dominioid.DataSource = BL.GetAll(EmpresaID, BE).Tables[0]; dominioid.ValueMember = "dominioid"; dominioid.DisplayMember = "dominioname"; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }