private void FgCli_CellButtonClick(object sender, C1.Win.C1FlexGrid.RowColEventArgs e) { if (FgCli.Col == 1) { DataTable dtResult = new DataTable(); string c_dato = ""; objPro.mysConec = mysConec; dtResult = objPro.BuscarCliPro(dtProv, 1, "n_id", ""); if (dtResult != null) { if (dtResult.Rows.Count != 0) { c_dato = dtResult.Rows[0]["c_nombre"].ToString(); FgCli.SetData(FgCli.Row, 1, c_dato); c_dato = dtResult.Rows[0]["n_id"].ToString(); FgCli.SetData(FgCli.Row, 2, c_dato); if (funFunciones.NulosC(FgCli.GetData(FgCli.Rows.Count - 1, 1)) != "") { FgCli.Rows.Count = FgCli.Rows.Count + 1; } } } } }
void BuscarCLientes() { DataTable dtResult = new DataTable(); objClientes.mysConec = mysConec; dtResult = objClientes.BuscarCliPro(dtClientes, 1, "n_id", ""); if (dtResult != null) { if (dtResult.Rows.Count != 0) { TxtNumRuc.Text = dtResult.Rows[0]["c_numdoc"].ToString(); LblIdCliente.Text = dtResult.Rows[0]["n_id"].ToString(); TxtNomCli.Text = dtResult.Rows[0]["c_nombre"].ToString(); TxtDireccion.Text = dtResult.Rows[0]["c_dir"].ToString(); //dtPrecios = objVentas.UltimoPrecioCliente(STU_SISTEMA.EMPRESAID, Convert.ToInt32(LblIdCliente.Text)); FgDetalle.Focus(); FgDetalle.Select(1, 1); } else { TxtNumRuc.Text = ""; LblIdCliente.Text = ""; TxtNomCli.Text = ""; TxtDireccion.Text = ""; } } }
private void CmdBusCliPro_Click(object sender, EventArgs e) { DataTable dtResult = new DataTable(); o_CliPro.mysConec = mysConec; dtResult = o_CliPro.BuscarCliPro(dtCliPro, 1, "n_id", ""); if (dtResult != null) { if (dtResult.Rows.Count != 0) { LblIdCliPro.Text = dtResult.Rows[0]["n_id"].ToString(); LblCliPro.Text = dtResult.Rows[0]["c_nombre"].ToString(); } else { LblIdCliPro.Text = ""; LblCliPro.Text = ""; } } }
private void CmdBusCli_Click(object sender, EventArgs e) { DataTable dtResult = new DataTable(); objPro.mysConec = mysConec; dtResult = objPro.BuscarCliPro(dtPro, 2, "n_id", ""); if (dtResult != null) { if (dtResult.Rows.Count != 0) { TxtNumRuc.Text = dtResult.Rows[0]["c_numdoc"].ToString(); LblIdPro.Text = dtResult.Rows[0]["n_id"].ToString(); TxtPro.Text = dtResult.Rows[0]["c_nombre"].ToString(); } else { TxtNumRuc.Text = ""; LblIdPro.Text = ""; TxtPro.Text = ""; } } }
private void FgCliente_CellButtonClick(object sender, C1.Win.C1FlexGrid.RowColEventArgs e) { if (FgItems.Col == 1) { DataTable dtResul = new DataTable(); string c_dato = ""; dtResul = objCli.BuscarCliPro(dtCli, 1, "n_id", ""); if (dtResul != null) { if (dtResul.Rows.Count != 0) { c_dato = dtResul.Rows[0]["c_nombre"].ToString(); // MOSTRAMOS LA DESCRIPCION DEL ITEM FgCliente.SetData(FgCliente.Row, 1, c_dato); c_dato = dtResul.Rows[0]["n_id"].ToString(); // MOSTRAMOS EL ID DEL ITEM FgCliente.SetData(FgCliente.Row, 2, c_dato); FgCliente.Rows.Count = FgCliente.Rows.Count + 1; } } } }