Daniel este e meu codigo. Daniel ate estou imprimindo o codigo de barras como nosso amigo Pablo me orientou, agora estou testando com o coletro e não esta lendo o codigo de barras.
namespace MenuRelatorios
{
public partial class frmEtiquetas : Form
{
int largura;
int altura;
List<string> ListaImpEtiqueta = new List<string>();
string sNomeImpressora = System.Configuration.ConfigurationSettings.AppSettings["ImpressoraPadrao"];
public frmEtiquetas()
{
InitializeComponent();
}
private void frmEtiquetas_Load(object sender, EventArgs e)
{
}
private void btnPesquisar_Click(object sender, EventArgs e)
{
vizualização.Document = EtiquetaProdPS;
vizualização.InvalidatePreview();
}
public string retornaCodBarras(string txtNGuiaFrac)
{
string ret = string.Empty;
string connectionString = this.DataTable1TableAdapter.Connection.ConnectionString;
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
string strQuery = @" SELECT
SC.C2_NUM,
SB.B1_DESC,
SC.C2_XNPAIS,
CONVERT(VARCHAR(10), CAST( SC.C2_XDTFAB
AS DATE),103) AS DATAF,
CONVERT(VARCHAR(10), CAST( SC.C2_XDTVALI
AS DATE),103) AS DATAV,
SC.C2_XLOTEF,
SC.C2_XLOTE,
SB.B1_XDCB,
SB.B1_XCAS,
CAST(SB.B1_PESO AS NUMERIC(15, 3)) AS PESO,
SB.B1_XSEGUM,
SC.C2_XNOMFA,
CB.CB0_CODETI,
SC.C2_QUANT
FROM SC2020 AS SC
INNER JOIN SB1020 AS SB WITH (NOLOCK) ON SB.B1_COD = SC.C2_PRODUTO
INNER JOIN CB0020 AS CB WITH (NOLOCK) ON CB.CB0_LOTE = SC.C2_XLOTE
WHERE C2_NUM = '" + txtNGuiaFrac + "'";
using (SqlCommand command = new SqlCommand(strQuery, con))
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
reader.GetString(12);
ret = reader[12].ToString();
ListaImpEtiqueta.Add("Produto: " + (reader[1].ToString()) + "
" +"N° Guia: " + reader[0].ToString());
ListaImpEtiqueta.Add("Fabricação: " +(reader[3].ToString()) + "
" + "Validade: " + reader[4].ToString() + " " + "Qtda. : " + reader[9].ToString() + reader[10].ToString());
ListaImpEtiqueta.Add("Lote Fabr.: " + (reader[5].ToString()) + "
" + "Lote Inter.: " + reader[6].ToString());
ListaImpEtiqueta.Add("Fabricante : " + (reader[11].ToString()) + "
" + "País Orig.: " + reader[2].ToString());
ListaImpEtiqueta.Add("CAS: " + (reader[8].ToString()));
ListaImpEtiqueta.Add("DCB: " + (reader[7].ToString()) + "
" + reader[12].ToString());
ListaImpEtiqueta.Add("Cod.: " + (reader[12].ToString()));
break;
}
}
con.Close();
}
return ret;
}
public string retornaQunat(string txtNGuiaFrac)
{
string ret = string.Empty;
string connectionString = this.DataTable1TableAdapter.Connection.ConnectionString;
using (SqlConnection con = new SqlConnection(connectionString))
{
con.Open();
string strQuery = @" SELECT
SC.C2_NUM,
SB.B1_DESC,
SC.C2_XNPAIS,
CONVERT(VARCHAR(10), CAST( SC.C2_XDTFAB
AS DATE),103) AS DATAF,
CONVERT(VARCHAR(10), CAST( SC.C2_XDTVALI
AS DATE),103) AS DATAV,
SC.C2_XLOTEF,
SC.C2_XLOTE,
SB.B1_XDCB,
SB.B1_XCAS,
CAST(SB.B1_PESO AS NUMERIC(15, 3)) AS PESO,
SB.B1_XSEGUM,
SC.C2_XNOMFA,
CB.CB0_CODETI,
SC.C2_QUANT
FROM SC2020 AS SC
INNER JOIN SB1020 AS SB WITH (NOLOCK) ON SB.B1_COD = SC.C2_PRODUTO
INNER JOIN CB0020 AS CB WITH (NOLOCK) ON CB.CB0_LOTE = SC.C2_XLOTE
WHERE C2_NUM = '" + txtNGuiaFrac + "'";
using (SqlCommand command = new SqlCommand(strQuery, con))
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
reader.GetDouble(13);
ret = reader[13].ToString();
break;
}
}
con.Close();
}
return ret;
}
private void txtNGuiaFrac_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Enter || e.KeyCode == Keys.Tab)
{
txtCodBarras.Text = retornaCodBarras(txtNGuiaFrac.Text);
txtQuant.Text = retornaQunat(txtNGuiaFrac.Text);
txtNGuiaFrac.Focus();
}
}
private void btnFechar_Click(object sender, EventArgs e)
{
Close();
}
private void btnImprimir_Click(object sender, EventArgs e)
{
EtiquetaProdPS.PrinterSettings.PrinterName = sNomeImpressora;
EtiquetaProdPS.Print();
}
private void EtiquetaProdPS_PrintPage(object sender, PrintPageEventArgs e)
{
Font codBarras = new Font("Bar-Code 39", 12);
Font letra = new Font("Aerial", 9, FontStyle.Regular, GraphicsUnit.Pixel);
SolidBrush cor = new SolidBrush(Color.Black);
Rectangle retangulo = new Rectangle(12, 36, largura, 30);
int y = 55;
foreach (string frase in ListaImpEtiqueta)
{
if (frase.Contains("Cod"))
{
e.Graphics.DrawString("Cod.: ", letra, cor, new Point(180, y));
e.Graphics.DrawString(frase, codBarras, cor, new Point(220, y));
}
else
{
e.Graphics.DrawString(frase, letra, cor, new Point(15, y));
y += 14;
}
}
}
}
}
JUNIOR GUERREIRO T.I
Impressão Codigo de Barras
