public void ValidaCcosto() { if (txtccosto.Text.Trim().Length == 0) { txtdcosto.Text = string.Empty; } else { txtccosto.Text = VariablesPublicas.PADL(txtccosto.Text.Trim(), txtccosto.MaxLength, "0"); var BL = new centrocostoBL(); var BE = new tb_centrocosto(); BE.cencosid = txtccosto.Text.Trim(); BE.norden = 1; BE.ver_blanco = 0; tmptabla = BL.GetAll_Consulta(VariablesPublicas.EmpresaID, BE).Tables[0]; if (BL.Sql_Error.Length == 0) { if (tmptabla.Rows.Count > 0) { txtccosto.Text = tmptabla.Rows[0]["cencosid"].ToString(); txtdcosto.Text = tmptabla.Rows[0]["cencosname"].ToString(); txtccargo.Text = string.Empty; txtdcargo.Text = string.Empty; } else { txtccosto.Text = j_ccosto; } } else { txtccosto.Text = j_ccosto; } } }
private void Filtrar() { var sorted = default(SortOrder); var xnomcolumna = string.Empty; if ((dgProveedor.SortedColumn != null)) { xnomcolumna = dgProveedor.Columns[dgProveedor.SortedColumn.Index].Name; sorted = dgProveedor.SortOrder; } var xpalabra1 = string.Empty; var xpalabra2 = string.Empty; var xpalabra3 = string.Empty; var xpalabra4 = string.Empty; if (txtdescripcion.Enabled) { xpalabra1 = VariablesPublicas.Palabras(txtdescripcion.Text, 1); xpalabra2 = VariablesPublicas.Palabras(txtdescripcion.Text, 2); xpalabra3 = VariablesPublicas.Palabras(txtdescripcion.Text, 3); xpalabra4 = VariablesPublicas.Palabras(txtdescripcion.Text, 4); } dgProveedor.DataSource = null; dgProveedor.AutoGenerateColumns = false; var BL = new centrocostoBL(); var BE = new tb_centrocosto(); BE.nomlike1 = xpalabra1; BE.nomlike2 = xpalabra2; BE.nomlike3 = xpalabra3; BE.norden = 1; BE.ver_blanco = 0; dgProveedor.DataSource = BL.GetAll_Consulta(VariablesPublicas.EmpresaID, BE).Tables[0]; if (xnomcolumna.Trim().Length > 0) { if (sorted == SortOrder.Ascending) { dgProveedor.Sort(dgProveedor.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Ascending); } else { dgProveedor.Sort(dgProveedor.Columns[xnomcolumna], System.ComponentModel.ListSortDirection.Descending); } } else { dgProveedor.Sort(dgProveedor.Columns["cencosid"], System.ComponentModel.ListSortDirection.Ascending); } VariablesPublicas.PintaEncabezados(dgProveedor); }
private void Frm_Planilla_Cargos_Activated(object sender, EventArgs e) { if (Sw_LOad) { Llenar_Ccosto(); cmbfiltroccosto.ValueMember = "cencosid"; cmbfiltroccosto.DisplayMember = "descripcion"; centrocostoBL BL = new centrocostoBL(); tb_centrocosto BE = new tb_centrocosto(); BE.norden = 1; BE.ver_blanco = 0; tmpcursor = BL.GetAll_Consulta(VariablesPublicas.EmpresaID, BE).Tables[0]; cmbfiltroccosto.SelectedValue = ""; if (BL.Sql_Error.Length == 0) { cmbfiltroccosto.DataSource = tmpcursor; if (tmpcursor.Rows.Count > 0) { cmbfiltroccosto.SelectedValue = tmpcursor.Rows[0]["cencosid"]; } } U_RefrescaControles(); CargaDatos(); U_RefrescaControles(); Sw_LOad = false; } }
public void Llenar_Ccosto() { centrocostoBL BL = new centrocostoBL(); tb_centrocosto BE = new tb_centrocosto(); BE.norden = 1; BE.ver_blanco = 0; cmbccosto.ValueMember = "cencosid"; cmbccosto.DisplayMember = "descripcion"; cmbccosto.DataSource = BL.GetAll_Consulta(VariablesPublicas.EmpresaID, BE).Tables[0]; }
public void ValidaCcosto() { if (txtccosto.Text.Trim().Length == 0) { txtdcosto.Text = ""; } else { txtccosto.Text = VariablesPublicas.PADL(txtccosto.Text.Trim(), txtccosto.MaxLength, "0"); centrocostoBL BL = new centrocostoBL(); tb_centrocosto BE = new tb_centrocosto(); BE.cencosid = txtccosto.Text.Trim(); BE.norden = 1; BE.ver_blanco = 0; tmpTabla = BL.GetAll_Consulta(VariablesPublicas.EmpresaID, BE).Tables[0]; //tmpTabla = oCapa.CaeSoft_GetAllAyudaCentrodeCosto(GlobalVars.GetInstance.Company, txtccosto.Text, 1, "", "", "", ""); if (BL.Sql_Error.Length == 0) { if (tmpTabla.Rows.Count > 0) { txtccosto.Text = tmpTabla.Rows[0]["cencosid"].ToString().Trim(); txtdcosto.Text = tmpTabla.Rows[0]["cencosname"].ToString().Trim(); } else { txtccosto.Text = j_ccosto; } } else { txtccosto.Text = j_ccosto; } } u_RefrescaControles(); }