private void Cargar_Empresaid() { var BE = new tb_empresa(); var BL = new empresasBL(); var dt = new DataTable(); dt = BL.GetAll(BE).Tables[0]; cbo_empresaid.DataSource = dt; cbo_empresaid.ValueMember = "empresaid"; cbo_empresaid.DisplayMember = "empresaname"; }
private void cboEmpresa_SelectedIndexChanged(object sender, EventArgs e) { try { txtUsuar.Text = string.Empty; txtClave.Text = string.Empty; txtUsuar.Focus(); empresasBL BL = new empresasBL(); tb_empresa BE = new tb_empresa(); DataTable dt2 = new DataTable(); BE.empresaid = cboEmpresa.Text.Substring(0, 2).Trim().PadLeft(2, '0'); dt2 = BL.GetAll(BE).Tables[0]; if (dt2.Rows.Count > 0) { VariablesPublicas.EmpresaID = dt2.Rows[0]["empresaid"].ToString(); VariablesPublicas.EmpresaName = dt2.Rows[0]["empresaname"].ToString().Trim(); VariablesPublicas.EmpresaRuc = dt2.Rows[0]["empresaruc"].ToString(); VariablesPublicas.EmpresaDirecc = dt2.Rows[0]["empresadirec"].ToString(); VariablesPublicas.EmpresaTelef = dt2.Rows[0]["empresatelef"].ToString(); VariablesPublicas.EmpresaSigla = dt2.Rows[0]["empresasigla"].ToString().Trim(); if (dt2.Rows[0]["foto"].ToString().Trim().Length != 0) { VariablesPublicas.EmpresaLogo = dt2.Rows[0]["foto"].ToString(); } else { VariablesPublicas.EmpresaLogo = "nologoempresa.png"; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Empresa() { try { txtUsuar.Text = ""; txtClave.Text = ""; txtUsuar.Focus(); empresasBL BL = new empresasBL(); tb_empresa BE = new tb_empresa(); DataTable dt2 = new DataTable(); BE.empresaid = cboEmpresa.SelectedValue.ToString(); dt2 = BL.GetAll(BE).Tables[0]; VariablesPublicas.EmpresaID = dt2.Rows[0]["empresaid"].ToString(); VariablesPublicas.EmpresaName = dt2.Rows[0]["empresaname"].ToString(); VariablesPublicas.EmpresaRuc = dt2.Rows[0]["empresaruc"].ToString(); if (dt2.Rows[0]["foto"].ToString().Trim().Length != 0) { VariablesPublicas.EmpresaLogo = dt2.Rows[0]["foto"].ToString(); } else { VariablesPublicas.EmpresaLogo = "nologoempresa.png"; } } catch (Exception ex) { MessageBoxEx.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private BindingSource NewMethod() { empresasBL BL = new empresasBL(); tb_empresa BE = new tb_empresa(); DataTable table = BL.GetAll(BE).Tables[0]; DataRowCollection rows = table.Rows; object[] cell; Dictionary<string, string> dic = new Dictionary<string, string>(); BindingSource binding = new BindingSource(); foreach (DataRow item in rows) { cell = item.ItemArray; dic.Add(cell[0].ToString(), cell[0].ToString() + " - " + cell[1].ToString()); cell = null; } binding.DataSource = dic; return binding; }