private void Buscar_Click(object sender, EventArgs e)
{
DateTime fecha_inicial = dateTimePicker1.Value;
DateTime fecha_final = dateTimePicker2.Value;
DataTable dtbl_datos = new DataTable();
try
{
//cargar los datos del empleado
string aux = string.Empty;
conexionBD cnn = new conexionBD();
dtbl_datos = cnn.fnConsultaSentencia("SELECT * FROM tbl_transaccionDet WHERE fecha BETWEEN '" + fecha_inicial.ToString("MM/dd/yyyy") + "' AND '" + fecha_final.ToString("MM/dd/yyyy") + "'");
if (dtbl_datos.Rows.Count > 0)
{
dgv_historico.DataSource = dtbl_datos;
}
else
{
return;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message + " " + ex.StackTrace);
}
}
public string fnGeneraTransaccionPrevia()
{
conexionBD cnn = new conexionBD();
transacciones trans = new transacciones();
if (trans.fnInsertaDatosTransaccion(txt_num_empleado.Text, id_entrevistador, DateTime.Now.ToString("MM/dd/yyyy"), "0", "0", "0", "0", "0", " "))
{
DataTable dtl = cnn.fnConsultaSentencia("SELECT id_det FROM tbl_transaccionDet WHERE id_user= "******" AND id_encuestador = " + id_entrevistador + " AND fiebre = 0 AND tos_estornudos = 0 AND malestar_gen = 0 AND dolor_cabeza = 0 AND dificultad_resp = 0 AND path_comprobante = ' '");
foreach (DataRow item in dtl.Rows)
{
object[] obj = item.ItemArray;
return(obj[0].ToString());
}
}
return(string.Empty);
}
private void Form1_Load(object sender, EventArgs e)
{
// Declaramos una variable para manejar los monitores
Screen[] sMonitores;
sMonitores = Screen.AllScreens;
// Posicion del formulario
this.Left = sMonitores[1].Bounds.Left;
this.Top = sMonitores[1].Bounds.Top;
DataTable dtbl = new DataTable();
conexionBD cnn = new conexionBD();
dtbl = cnn.fnConsultaSentencia("select marca, dir_ip from tbl_camaras");
foreach (DataRow item in dtbl.Rows)
{
cbbx_camara_empleado.Items.Add(item.Field <string>("marca") + " " + item.Field <string>("dir_ip"));
cbbx_camara_entrevistador.Items.Add(item.Field <string>("marca") + " " + item.Field <string>("dir_ip"));
}
}
private void visorScreenShot_Shown(object sender, EventArgs e)
{
try
{
Image[] imagenes = new Image[2]; int cont = 0;
conexionBD bd = new conexionBD();
DataTable tbl = bd.fnConsultaSentencia("select id from tbl_screenshot where id_trans = " + this.id_transaccion);
foreach (DataRow item in tbl.Rows)
{
imagenes[cont] = bd.ObtenerBitmapBDD(item.Field <int>("id"), "tbl_screenshot", "id=@id");
cont++;
}
picture_screen_shot.Image = imagenes[0];
picture_screen_shot.SizeMode = PictureBoxSizeMode.StretchImage;
Thread.Sleep(500);
picture_termografica.Image = imagenes[1];
picture_termografica.SizeMode = PictureBoxSizeMode.StretchImage;
}
catch (Exception ex)
{
}
}
