public static DadosEtiqueta getDadosEtiqueta(int _numped)
{
DadosEtiqueta etiq = new DadosEtiqueta();
using (SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlConn"].ToString()))
{
SqlCommand cmm = cnn.CreateCommand();
cmm.CommandText = "SELECT Checkin_Pedido.DataHora, Pedidos.ID_Paciente, Pedidos.Nome_Paciente,"
+ "Pedidos.Cod_Tipo_Paciente, Pedidos.Procedencia,Grupo_Exame.descricao,Pedidos.Cod_Grupo_Exame "
+ "FROM Pedidos INNER JOIN Checkin_Pedido ON Pedidos.Num_Pedido = Checkin_Pedido.Num_Pedido "
+ "INNER JOIN Grupo_Exame on pedidos.cod_Grupo_Exame = Grupo_Exame.cod_Grupo_Exame "
+ "WHERE (Pedidos.Num_Pedido = @numped)";
cmm.Parameters.Add("@numped", SqlDbType.Int).Value = _numped;
try
{
cnn.Open();
SqlDataReader dr = cmm.ExecuteReader();
if (dr.Read())
{
etiq.Dt = dr.GetDateTime(0);
etiq.Id = dr.GetInt32(1);
etiq.Nome = dr.GetString(2);
etiq.Numped = _numped;
etiq.CodTipId = dr.GetInt32(3);
etiq.Procedencia = dr.GetString(4);
etiq.TipExm = dr.GetString(5);
etiq.CodExm = dr.GetInt32(6);
}
}
catch (Exception ex)
{
string erro = ex.Message;
}
}
return(etiq);
}
public static void Imprimir(int _numped, int _count, String _host)
{
/* DadosEtiqueta etiq = SqlSv.getDadosEtiqueta(_numped);
*
* System.IntPtr lhPrinter = new System.IntPtr();
* DOCINFO di = new DOCINFO();
* int pcWritten = 0;
* string st1;
* // text to print with a form feed character
*
* di.pDocName = "my test document";
* di.pDataType = "RAW";
*
* //lhPrinter contains the handle for the printer opened
* //If lhPrinter is 0 then an error has occured
* // PrintDirect.OpenPrinter("\\\\"+_host+"\\Etiq", ref lhPrinter, 0);
* PrintDirect.OpenPrinter("\\\\hspmcac005\\Etiq", ref lhPrinter, 0);
* PrintDirect.StartDocPrinter(lhPrinter, 1, ref di);
* PrintDirect.StartPagePrinter(lhPrinter);
* // for (int i = 0; i < _count; i++)
* {
* try
* {
* st1 = "HSPM - CENTRO DIAGNOSTICO\r\n\n";
* PrintDirect.WritePrinter(lhPrinter, st1, st1.Length, ref pcWritten);
*
* st1 = "PEDIDO: " + etiq.Numped.ToString() + "\r\n";
* PrintDirect.WritePrinter(lhPrinter, st1, st1.Length, ref pcWritten);
* if (etiq.CodTipId == 1)
* st1 = "RH: " + etiq.Id.ToString() + "\r\n";
* else
* st1 = "BE: " + etiq.Id.ToString() + "\r\n";
* PrintDirect.WritePrinter(lhPrinter, st1, st1.Length, ref pcWritten);
*
* st1 = "NOME: " + etiq.Nome + "\r\n";
* PrintDirect.WritePrinter(lhPrinter, st1, st1.Length, ref pcWritten);
*
* st1 = "DATA: " + etiq.Dt.ToShortDateString() + "\r\n";
* PrintDirect.WritePrinter(lhPrinter, st1, st1.Length, ref pcWritten);
*
* st1 = etiq.Procedencia + "\n\n\n\n";
* PrintDirect.WritePrinter(lhPrinter, st1, st1.Length, ref pcWritten);
*
* }
* catch (Exception e)
* {
* Console.WriteLine(e.Message);
* }
* }
* PrintDirect.EndPagePrinter(lhPrinter);
* PrintDirect.EndDocPrinter(lhPrinter);
* PrintDirect.ClosePrinter(lhPrinter);
* }*/
DadosEtiqueta etiq = SqlSv.getDadosEtiqueta(_numped);
StringBuilder st1 = new StringBuilder();
for (int i = 0; i < _count; i++)
{
st1.Append(" HSPM - CENTRO DIAGNOSTICO\r\n\n");
st1.Append("PEDIDO: " + etiq.Numped.ToString() + " ");
if (etiq.CodTipId == 1)
{
st1.Append("RH: " + etiq.Id.ToString() + "\r\n");
}
else
{
st1.Append("BE: " + etiq.Id.ToString() + "\r\n");
}
if (etiq.Nome.Length > 31)
{
etiq.Nome = etiq.Nome.Substring(0, 24);
}
st1.Append("NOME: " + etiq.Nome + "\r\n");
st1.Append("DATA: " + etiq.Dt.ToShortDateString() + "\r\n");
st1.Append("EXAME: " + etiq.TipExm + "\r\n");
if (etiq.Procedencia.Length > 31)
{
etiq.Procedencia = etiq.Procedencia.Substring(0, 30);
}
st1.Append(etiq.Procedencia + "\n\n\n");
}
RawPrinterHelper.SendStringToPrinter("\\\\" + _host + "\\etiq", st1.ToString());
}
