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) { } }