private void Form2_Load(object sender, EventArgs e) { dateTimePicker1.Format = DateTimePickerFormat.Custom; dateTimePicker1.CustomFormat = " dd-MM-yyyy"; dateTimePicker2.Format = DateTimePickerFormat.Custom; dateTimePicker2.CustomFormat = " dd-MM-yyyy"; // label3.Text= DateTime.Now.ToString("dddd", new System.Globalization.CultureInfo("es-ES")); label3.Text = DateTime.Now.ToString("tt"); con.conectar("EX"); SqlCommand cm2 = new SqlCommand("SELECT USUARIO FROM dismo.AUDITORIA_DE_PROC GROUP BY USUARIO ", con.conex); SqlDataReader dr2 = cm2.ExecuteReader(); while (dr2.Read()) { comboBox1.Items.Add(dr2["USUARIO"]); } dr2.Close(); listView1.View = View.Details; //Detalles encabezado listView1.GridLines = true; //Lineas tipo cuaderno listView1.FullRowSelect = true; try { } catch { MessageBox.Show("conexion Error"); } listView1.Clear(); listView1.Columns.Add("USUARIO", 80, HorizontalAlignment.Left); listView1.Columns.Add("MODULO", 50, HorizontalAlignment.Left); listView1.Columns.Add("TABLA", 80, HorizontalAlignment.Left); listView1.Columns.Add("PROCESO", 180, HorizontalAlignment.Left); listView1.Columns.Add("FECHA / HORA", 180, HorizontalAlignment.Left); SqlCommand cm1 = new SqlCommand("SELECT USUARIO,ORIGEN,OPCION,NOTAS,FECHA_HORA FROM dismo.AUDITORIA_DE_PROC WHERE DATEADD(dd, 0, DATEDIFF(dd, 0, FECHA_HORA))>='" + Sincronizacion.fecha_sinc + "' ", con.conex); SqlDataReader dr1 = cm1.ExecuteReader(); while (dr1.Read()) { ListViewItem lvItem = new ListViewItem(); lvItem.SubItems[0].Text = dr1[0].ToString(); lvItem.SubItems.Add(dr1[1].ToString()); lvItem.SubItems.Add(dr1[2].ToString()); lvItem.SubItems.Add(dr1[3].ToString()); lvItem.SubItems.Add(dr1[4].ToString()); listView1.Items.Add(lvItem); } dr1.Close(); con.Desconectar("EX"); }
private void Form11_Load(object sender, EventArgs e) { fecha_actual = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); this.textBox1.Enabled = false; this.textBox2.Enabled = false; this.textBox3.Enabled = false; this.linkLabel1.Enabled = false; this.button2.Enabled = false; this.button3.Enabled = false; con.conectar("DM"); SqlCommand cm1 = new SqlCommand("SELECT [RUTA] FROM [EXACTUS].[" + empresa + "].[RUTA] where DESCRIPCION = 'PRONTA'ORDER BY RUTA", con.condm); SqlDataReader dr1 = cm1.ExecuteReader(); while (dr1.Read()) { comboBox1.Items.Add("R" + dr1["RUTA"]); } dr1.Close(); con.Desconectar("DM"); }
private void button3_Click(object sender, EventArgs e) { DateTime Fecha_crea; Fecha_crea = DateTime.Now; int Registros = dt.Rows.Count; eliminar_costos(); for (int i = 0; i < dt.Rows.Count; i++) { con.conectar("DM"); DataRow row = dt.Rows[i]; code = Convert.ToString(row["Code"]); Costo = Convert.ToString(row["Costo"]); SqlCommand cmd1 = new SqlCommand(); cmd1.Connection = con.condm; cmd1.CommandText = "INSERT INTO [DM].[CORRECT].[COSTOS]([ARTICULO],[COSTO],[fecha_update]) VALUES(@ARTICULO,@COSTO,@fecha_update)"; cmd1.Parameters.Add("@ARTICULO", SqlDbType.NVarChar).Value = code; cmd1.Parameters.Add("@COSTO", SqlDbType.NVarChar).Value = Costo; cmd1.Parameters.Add("@fecha_update", SqlDbType.DateTime).Value = Fecha_crea; cmd1.ExecuteNonQuery(); row.Delete(); con.Desconectar("DM"); } }
private void button2_Click(object sender, EventArgs e) { con.conectar("WEB"); for (int i = 0; i < result.Rows.Count; i++) { DataRow row = result.Rows[i]; MySqlCommand cmd = new MySqlCommand(); cmd.Connection = con.mysqlconec; cmd.CommandText = "INSERT INTO dismodb.CLIENTS (TIMEST,CODCLIE,NOMBRE,DIRECCION,RUTA,AREA,Mueble,MUECANT,COMUNI,ALAS,NEC,TEL,CUMP,LAT,LON) VALUES (@TIMEST,@CODCLIE,@NOMBRE,@DIRECCION,@RUTA,@AREA,@Mueble,@MUECANT,@COMUNI,@ALAS,@NEC,@TEL,@CUMP,@LAT,@LON)"; cmd.Prepare(); cmd.Parameters.AddWithValue("@TIMEST", 0); cmd.Parameters.AddWithValue("@CODCLIE", Convert.ToString(row["CODCLIE"])); cmd.Parameters.AddWithValue("@NOMBRE", Convert.ToString(row["NOMBRE"])); cmd.Parameters.AddWithValue("@DIRECCION", Convert.ToString(row["DIRECCION"])); cmd.Parameters.AddWithValue("@RUTA", Convert.ToString(row["VENDEDOR"])); cmd.Parameters.AddWithValue("@AREA", Convert.ToString(row["AREA"])); cmd.Parameters.AddWithValue("@Mueble", "0"); cmd.Parameters.AddWithValue("@MUECANT", "0"); cmd.Parameters.AddWithValue("@COMUNI", "0"); cmd.Parameters.AddWithValue("@ALAS", Convert.ToString(row["ALIAS"])); cmd.Parameters.AddWithValue("@NEC", "0"); cmd.Parameters.AddWithValue("@TEL", Convert.ToString(row["TEL"])); cmd.Parameters.AddWithValue("@CUMP", "0"); cmd.Parameters.AddWithValue("@LAT", Convert.ToString(row["LAT"])); cmd.Parameters.AddWithValue("@LON", Convert.ToString(row["LON"])); cmd.ExecuteNonQuery(); } con.Desconectar("WEB"); }
private void Form15_Load(object sender, EventArgs e) { ControlBox = false; this.button2.Enabled = false; dateTimePicker1.Format = DateTimePickerFormat.Custom; dateTimePicker1.CustomFormat = "dd-MM-yyyy"; dateTimePicker2.Format = DateTimePickerFormat.Custom; dateTimePicker2.CustomFormat = "dd-MM-yyyy"; dt.Clear(); dataGridView1.RowHeadersVisible = false; dataGridView1.AutoResizeColumns(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.ReadOnly = true; dataGridView1.AllowUserToAddRows = false; dataGridView1.Refresh(); con.conectar("EX"); SqlCommand cmd2 = new SqlCommand("SELECT [VENDEDOR] FROM [EXACTUS].[dismo].[FACTURA] GROUP BY [VENDEDOR]ORDER BY [VENDEDOR]", con.conex); SqlDataReader dr1 = cmd2.ExecuteReader(); while (dr1.Read()) { comboBox1.Items.Add(dr1["VENDEDOR"]); } dr1.Close(); con.Desconectar("EX"); }
private void Cargas_Load(object sender, EventArgs e) { checkBox1.Checked = true; dateTimePicker2.CustomFormat = "hh:mm tt"; dateTimePicker2.ShowUpDown = true; dateTimePicker3.CustomFormat = "hh:mm tt"; dateTimePicker3.ShowUpDown = true; // dateTimePicker3.Value = 24; dateTimePicker2.Enabled = false; dateTimePicker3.Enabled = false; dateTimePicker4.Enabled = false; detalle = 1; filto_tiempo = 1; this.reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local; dateTimePicker1.Format = DateTimePickerFormat.Custom; dateTimePicker1.CustomFormat = "dd-MM-yyyy"; this.comboBox2.Text = Login.usuario.ToUpper(); con.conectar("EX"); SqlCommand cm2 = new SqlCommand("SELECT [RUTA] FROM [EXACTUS].[" + Login.empresa + "].[RUTA] where RUTA like 'E%' ", con.conex); SqlDataReader dr2 = cm2.ExecuteReader(); while (dr2.Read()) { comboBox1.Items.Add(dr2["RUTA"]); } dr2.Close(); SqlCommand cm4 = new SqlCommand("SELECT USUARIO FROM [EXACTUS].[" + Login.empresa + "].[FACTURA] Group by USUARIO ", con.conex); SqlDataReader dr4 = cm4.ExecuteReader(); while (dr4.Read()) { comboBox2.Items.Add(dr4["USUARIO"]); } dr4.Close(); con.Desconectar("EX"); if (Main_Menu.carga_detallefac == "S") { checkBox1.Enabled = true; } else { checkBox1.Enabled = false; } }
private void button1_Click(object sender, EventArgs e) { clie_dismo.Clear(); clie_FR.Clear(); clie_dismo.Columns.Clear(); con.conectar("EX"); if (this.radioButton2.Checked) { SqlCommand cmd = new SqlCommand("SELECT A.[CLIENTE],A.[NOMBRE],A.[ALIAS],A.[DIRECCION],A.[TELEFONO1],A.[CONTRIBUYENTE],A.[PAIS],A.[ZONA],A.[RUTA],A.[E_MAIL],A.[RUBRO1_CLI],A.[RUBRO2_CLI],A.FCH_HORA_ULT_MOD,A.USUARIO_ULT_MOD FROM [EXACTUS].[" + empresa + "].[CLIENTE] A where DATEADD(dd, 0, DATEDIFF(dd, 0, FCH_HORA_ULT_MOD)) = '" + this.dateTimePicker1.Value.ToString("yyyy-MM-dd") + " ' and CLIENTE in (SELECT CLIENTE FROM [EXACTUS].[ERPADMIN].[CLIENTE_RT]) and NOMBRE not in (SELECT NOMBRE FROM [EXACTUS].[ERPADMIN].[CLIENTE_RT] where CLIENTE >'30000' ) and SUBSTRING (NOMBRE,0,31) not in (SELECT NOMBRE FROM [EXACTUS].[ERPADMIN].[CLIENTE_RT] where CLIENTE > '30000') and CLIENTE > '30000'", con.conex); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(clie_dismo); } else if (this.radioButton1.Checked) { SqlCommand cmd = new SqlCommand("SELECT [CLIENTE],[NOMBRE],[ALIAS],[DIRECCION],[TELEFONO1],[CONTRIBUYENTE],[PAIS],[ZONA],[RUTA],[E_MAIL],[RUBRO1_CLI],[RUBRO2_CLI],FCH_HORA_ULT_MOD,USUARIO_ULT_MOD FROM [EXACTUS].[" + empresa + "].[CLIENTE] where DATEADD(dd, 0, DATEDIFF(dd, 0, FCH_HORA_ULT_MOD)) = ' " + this.dateTimePicker1.Value.ToString("yyyy-MM-dd") + " ' and CLIENTE in (SELECT CLIENTE FROM [EXACTUS].[ERPADMIN].[CLIENTE_RT]) and NOMBRE not in (SELECT NOMBRE FROM [EXACTUS].[ERPADMIN].[CLIENTE_RT] ) and SUBSTRING (NOMBRE,0,31) not in (SELECT NOMBRE FROM [EXACTUS].[ERPADMIN].[CLIENTE_RT] ) and CLIENTE <'30000'", con.conex); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(clie_dismo); } con.Desconectar("EX"); dataGridView1.DataSource = clie_dismo; dataGridView1.Refresh(); con.conectar("EX"); for (int i = 0; i < clie_dismo.Rows.Count; i++) { DataRow row = clie_dismo.Rows[i]; Cliente = Convert.ToString(row["CLIENTE"]); SqlCommand cmd1 = new SqlCommand("SELECT C.COD_ZON,A.CLIENTE,A.NOMBRE,B.NOM_CTO,B.ALIAS,B.NUM_TEL,C.DIR_CLT FROM [EXACTUS].[ERPADMIN].[CLIENTE_RT] A left JOIN [EXACTUS].[ERPADMIN].[CLIENTE_CIA] B ON A.CLIENTE = B.COD_CLT left join [EXACTUS].[ERPADMIN].[CLIENTE] C on A.CLIENTE = C.COD_CLT where A.CLIENTE ='" + Cliente + "' ", con.conex); SqlDataReader dr1 = cmd1.ExecuteReader(); while (dr1.Read()) { clie_FR.Rows.Add(Convert.ToString(dr1["COD_ZON"]), Convert.ToString(dr1["CLIENTE"]), Convert.ToString(dr1["NOMBRE"]), Convert.ToString(dr1["NOM_CTO"]), Convert.ToString(dr1["ALIAS"]), Convert.ToString(dr1["NUM_TEL"]), Convert.ToString(dr1["DIR_CLT"])); } dr1.Close(); } con.Desconectar("EX"); dataGridView2.DataSource = clie_FR; dataGridView2.Refresh(); label2.Text = Convert.ToString(dataGridView1.Rows.Count); }
private void BtnGenerar_Click(object sender, EventArgs e) { { try { con.conectar("DM"); SqlDataAdapter da = new SqlDataAdapter("[CORRECT].[CARGARECIBOS]", con.condm); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@FINI", SqlDbType.DateTime); da.SelectCommand.Parameters.Add("@FFIN", SqlDbType.DateTime); da.SelectCommand.Parameters.Add("@Ruta", SqlDbType.NVarChar); da.SelectCommand.Parameters.Add("@empresa", SqlDbType.NVarChar); da.SelectCommand.Parameters["@FINI"].Value = Convert.ToDateTime(FechaIni.Value.ToShortDateString()); da.SelectCommand.Parameters["@FFIN"].Value = Convert.ToDateTime(FechaFin.Value.ToShortDateString()); da.SelectCommand.Parameters["@Ruta"].Value = Convert.ToString(CBEntrega.SelectedValue.ToString()); da.SelectCommand.Parameters["@empresa"].Value = Empresa; dt.Clear(); da.Fill(dt); this.dataGridView1.DataSource = dt; TxtMonto.Text = dt.Rows[0].ItemArray[3].ToString().Substring(0, dt.Rows[0].ItemArray[3].ToString().Length - 6); this.BtnGenerarCSV.Enabled = true; TxtConcepDoc.Text = "Liquidacion Entrega " + CBEntrega.SelectedValue.ToString(); TxtConceptoGral.Text = "Liquidacion Entrega " + CBEntrega.SelectedValue.ToString(); LbRegistros.Text = dataGridView1.RowCount.ToString(); con.Desconectar("DM"); // foreach (DataRow row in dt.Rows) // { //// MessageBox.Show( dt.Rows[0].ItemArray[5].ToString()); // } // da.Fill(mibase, "CargadorCC"); //RECORRER EL DATA SET //foreach (DataRow renglon in mibase.Tables["MH_ICV"].Rows) //{ // // textBox1.Text = renglon["NOMBRE"].ToString(); // // textBox2.Text = renglon["RFC"].ToString(); // // textBox3.Text = renglon["Telefono"].ToString(); // // textBox4.Text = renglon["Pagina"].ToString(); //} } catch (Exception ex) { MessageBox.Show("No se pudo conectar a la BD Error: " + ex.Message); con.Desconectar("DM"); } } }
private void cargar_usuarios() { con.conectar("DM"); SqlCommand cm2 = new SqlCommand("SELECT[USUARIO]FROM [DM].[CORRECT].[REGALIAS] GROUP BY USUARIO", con.condm); SqlDataReader dr2 = cm2.ExecuteReader(); while (dr2.Read()) { comboBox1.Items.Add(dr2["USUARIO"]); } dr2.Close(); con.Desconectar("DM"); }
private void ExceltoKML_Load(object sender, EventArgs e) { button2.Enabled = false; button1.Enabled = false; comboBox1.Enabled = false; comboBox2.Enabled = false; label1.Hide(); textBox2.Text = "100"; resultado.Columns.Add("LATITUD", typeof(string)); resultado.Columns.Add("LONGITUD", typeof(string)); resultado.Columns.Add("CLIENTEK", typeof(string)); resultado.Columns.Add("CLIENTEXACT", typeof(string)); resultado.Columns.Add("METROS", typeof(double)); resultado.Columns.Add("RUTA", typeof(string)); resultado.Columns.Add("NOMBREK", typeof(string)); resultado.Columns.Add("DIRECCION", typeof(string)); worker.WorkerReportsProgress = true; worker.WorkerSupportsCancellation = true; worker.DoWork += new DoWorkEventHandler(backgroundWorker1_DoWork); worker.ProgressChanged += new ProgressChangedEventHandler(backgroundWorker1_ProgressChanged); worker.RunWorkerCompleted += new RunWorkerCompletedEventHandler(backgroundWorker1_RunWorkerCompleted); con.conectar("EX"); SqlCommand cmd = new SqlCommand("SELECT A.[RUTA],C.E_MAIL FROM [EXACTUS].[ERPADMIN].[CLIENTE_UBICACION] A LEFT JOIN [EXACTUS].[ERPADMIN].[RUTA_ASIGNADA_RT] B on A.RUTA = B.RUTA INNER JOIN [EXACTUS].[dismo].[VENDEDOR] C on B.AGENTE = C.VENDEDOR Group by A.[RUTA],C.E_MAIL", con.conex); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(Rutas); this.comboBox1.DataSource = Rutas; this.comboBox1.DisplayMember = "RUTA"; SqlCommand cmd1 = new SqlCommand("SELECT [E_MAIL] as 'AREA' FROM [EXACTUS].[dismo].[VENDEDOR] group by E_MAIL", con.conex); SqlDataAdapter da1 = new SqlDataAdapter(cmd1); da1.Fill(Areas); this.comboBox2.DataSource = Areas; this.comboBox2.DisplayMember = "AREA"; con.Desconectar("EX"); this.comboBox1.Text = "TODAS"; this.comboBox2.Text = "TODAS"; }
private void button1_Click(object sender, EventArgs e) { pedidos.Clear(); dataGridView1.Refresh(); con.conectar("EX"); SqlCommand cmd = new SqlCommand("SELECT [PEDIDO],[CLIENTE_ORIGEN] ,[CLIENTE],[EMBARCAR_A],[DIRECCION_FACTURA],[COBRADOR],[RUTA],[USUARIO],[CONDICION_PAGO],[BODEGA],[ZONA],[VENDEDOR],[CLIENTE_DIRECCION],[FECHA_PEDIDO] FROM [EXACTUS].[" + Login.empresa + "].[PEDIDO] where ESTADO = 'N' AND (CLIENTE_DIRECCION like '90%') and IMPRESO = 'N' and FECHA_PEDIDO = '" + this.dateTimePicker1.Value.ToString("yyyy-MM-dd") + "'", con.conex); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(pedidos); con.Desconectar("EX"); dataGridView1.DataSource = pedidos; }
public FrmPromociones() { InitializeComponent(); try { con.conectar("DM"); SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM [CORRECT].[BONIFICACION_x_CLIE]", con.condm); //da.SelectCommand.CommandType = CommandType.StoredProcedure; //da.SelectCommand.Parameters.Add("@FINI", SqlDbType.DateTime); //da.SelectCommand.Parameters.Add("@FFIN", SqlDbType.DateTime); //da.SelectCommand.Parameters["@FINI"].Value = Convert.ToDateTime(FechaIni.Value.ToShortDateString()); //da.SelectCommand.Parameters["@FFIN"].Value = Convert.ToDateTime(FechaFin.Value.ToShortDateString()); dt.Clear(); da.Fill(dt); this.dataGridView1.DataSource = dt; con.Desconectar("DM"); } catch (Exception ex) { MessageBox.Show("No se Pudo conectar a la BD Error: " + ex.Message); } }
private void consulta(string Usuario, int id_empresa) { Menu_Acces.Clear(); APP_acces.Clear(); SUBAPP_acces.Clear(); con.conectar("DM"); SqlCommand cm = new SqlCommand("SELECT A.ACCES,C.NOMBRE,A.MENU_ID FROM [DM].[CORRECT].[ACCES_MAIN] A INNER JOIN [DM].[CORRECT].[USUARIOS] B ON A.ID_USER = B.USER_ID INNER JOIN [DM].[CORRECT].[MENU]C on A.MENU_ID = C.MENU_ID WHERE B.USUARIO = '" + Usuario + "' and ID_EMPRESA = '" + id_empresa + "' ", con.condm); SqlDataAdapter da = new SqlDataAdapter(cm); da.Fill(Menu_Acces); SqlCommand cm1 = new SqlCommand("SELECT A.[ACCCESS],C.NOMBRE,A.APP_ID FROM [DM].[CORRECT].[ACCESO_APP] A INNER JOIN [DM].[CORRECT].[USUARIOS] B ON A.ID_USER = B.USER_ID INNER JOIN [DM].[CORRECT].[MENU_APP]C on A.APP_ID = C.APP_ID WHERE B.USUARIO = '" + Usuario + "' and ID_EMPRESA = '" + id_empresa + "' ", con.condm); SqlDataAdapter da1 = new SqlDataAdapter(cm1); da1.Fill(APP_acces); SqlCommand cm2 = new SqlCommand("SELECT A.SUBAPP_ID,A.ACCESS,C.NOMBRE FROM [DM].[CORRECT].[ACCESO_SUBAPP] A INNER JOIN [DM].[CORRECT].[USUARIOS] B ON A.ID_USER = B.USER_ID INNER JOIN [DM].[CORRECT].[MENU_SUB_APP]C on A.SUBAPP_ID = C.SUBAPP_ID WHERE B.USUARIO ='" + Usuario + "' and ID_EMPRESA = '" + id_empresa + "' ", con.condm); SqlDataAdapter da2 = new SqlDataAdapter(cm2); da2.Fill(SUBAPP_acces); con.Desconectar("DM"); }
private void Proveedores_Flota_Load(object sender, EventArgs e) { ID = 0; Usuario = "TURCIOSI"; process = 0; dt2.Clear(); dt1.Clear(); dataGridView1.Enabled = true; dataGridView1.RowHeadersVisible = false; //dataGridView2.AutoResizeColumns(); //dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.ReadOnly = true; dataGridView1.AllowUserToAddRows = false; textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; textBox5.Text = ""; textBox6.Text = ""; textBox7.Text = ""; textBox2.Enabled = false; textBox3.Enabled = false; textBox4.Enabled = false; textBox5.Enabled = false; textBox6.Enabled = false; textBox7.Enabled = false; con.conectar("DM"); string consulta = "SELECT * FROM [DM].[CORRECT].[Proveedores] ORDER BY Registro"; SqlCommand comando = new SqlCommand(consulta, con.condm); SqlDataAdapter adap = new SqlDataAdapter(comando); adap.Fill(dt2); con.Desconectar("DM"); dataGridView1.DataSource = dt1; dataGridView1.Refresh(); toolStripButton4.Enabled = false; toolStripButton2.Enabled = false; toolStripButton3.Enabled = false; }
private void button1_Click(object sender, EventArgs e) { clie_dismo.Clear(); clie_PED.Clear(); clie_dismo.Columns.Clear(); con.conectar("EX"); SqlCommand cmd = new SqlCommand("SELECT CLIE.[CLIENTE],CLIE.[NOMBRE],CLIE.[ALIAS],CLIE.[DIRECCION],CLIE.[DOC_A_GENERAR],CLIE.[TELEFONO1],CLIE.[CONTRIBUYENTE],CLIE.[PAIS],CLIE.[ZONA],CLIE.[RUTA],CLIE.[E_MAIL],CLIE.[RUBRO1_CLI],CLIE.[RUBRO2_CLI],CLIE.FCH_HORA_ULT_MOD,CLIE.USUARIO_ULT_MOD FROM [EXACTUS].[" + empresa + "].[PEDIDO] as PED LEFT JOIN [EXACTUS].[" + empresa + "].[CLIENTE] CLIE on PED.CLIENTE = CLIE.CLIENTE where PED.NOMBRE_CLIENTE <> CLIE.NOMBRE and (DATEADD(dd, 0, DATEDIFF(dd, 0, CLIE.FCH_HORA_ULT_MOD)) >= '" + this.dateTimePicker1.Value.ToString("yyyy-MM-dd") + "'and PED.ESTADO ='N' )", con.conex); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(clie_dismo); con.Desconectar("EX"); dataGridView1.DataSource = clie_dismo; dataGridView1.Refresh(); con.conectar("EX"); for (int i = 0; i < clie_dismo.Rows.Count; i++) { DataRow row = clie_dismo.Rows[i]; Cliente = Convert.ToString(row["CLIENTE"]); SqlCommand cmd1 = new SqlCommand("SELECT [CLIENTE],[PEDIDO],[NOMBRE_CLIENTE],[EMBARCAR_A],[DIRECCION_FACTURA],[COBRADOR],[ESTADO],[RUTA],[CONDICION_PAGO],[ZONA],[VENDEDOR],[PAIS] FROM [EXACTUS].[" + empresa + "].[PEDIDO] where ESTADO ='N' and CLIENTE = '" + Cliente + "' ", con.conex); SqlDataReader dr1 = cmd1.ExecuteReader(); while (dr1.Read()) { clie_PED.Rows.Add(Convert.ToString(dr1["CLIENTE"]), Convert.ToString(dr1["PEDIDO"]), Convert.ToString(dr1["NOMBRE_CLIENTE"]), Convert.ToString(dr1["EMBARCAR_A"]), Convert.ToString(dr1["DIRECCION_FACTURA"]), Convert.ToString(dr1["COBRADOR"]), Convert.ToString(dr1["ESTADO"]), Convert.ToString(dr1["RUTA"]), Convert.ToString(dr1["CONDICION_PAGO"]), Convert.ToString(dr1["ZONA"]), Convert.ToString(dr1["VENDEDOR"]), Convert.ToString(dr1["PAIS"])); } dr1.Close(); } con.Desconectar("EX"); dataGridView2.DataSource = clie_PED; dataGridView2.Refresh(); label2.Text = Convert.ToString(dataGridView1.Rows.Count); }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { if (consulta == 0) { con.conectar("DM"); SqlCommand cm1 = new SqlCommand("SELECT[CECO] FROM [DM].[CORRECT].[VEHICULOS] where PLACA ='" + comboBox1.Text + "' ", con.condm); SqlDataReader dr1 = cm1.ExecuteReader(); while (dr1.Read()) { label28.Text = Convert.ToString(dr1["CECO"]); } dr1.Close(); con.Desconectar("DM"); } }
private void Form7_Load(object sender, EventArgs e) { comboBox1.Enabled = false; textBox1.Enabled = false; con.conectar("EX"); SqlCommand cm1 = new SqlCommand("SELECT Vendedor FROM [EXACTUS].[dismo].[SoftlandBI_CC_SaldoClientes] GROUP BY Vendedor", con.conex); SqlDataReader dr1 = cm1.ExecuteReader(); while (dr1.Read()) { comboBox1.Items.Add(dr1["Vendedor"]); } dr1.Close(); con.Desconectar("EX"); }
private void Ruteroreporte_Load(object sender, EventArgs e) { this.Text = " REPORTE RUTEROS (" + Login.empresa + " ) "; this.label1.Hide(); HoyH = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); comboBox1.Text = ""; con.conectar("DM"); SqlCommand cm1 = new SqlCommand("SELECT RUTA FROM [DM].[dbo].[RUTERO] where EMPRESA = '" + Login.empresa + "' group by RUTA order by RUTA", con.condm); SqlDataReader dr1 = cm1.ExecuteReader(); while (dr1.Read()) { comboBox1.Items.Add(dr1["RUTA"]); } dr1.Close(); con.Desconectar("DM"); }
private void textBox2_Leave(object sender, EventArgs e) { button2.Hide(); con.conectar("EX"); SqlCommand cm1 = new SqlCommand("SELECT A.[EMPLEADO],A.[NOMBRE],B.DESCRIPCION as PUESTO ,C.DESCRIPCION as DEPARTAMENTO FROM [EXACTUS].[dismo].[EMPLEADO] A INNER JOIN [EXACTUS].[dismo].[PUESTO] B ON A.PUESTO = B.PUESTO INNER JOIN [EXACTUS].[dismo].[DEPARTAMENTO] C on A.DEPARTAMENTO = C.DEPARTAMENTO where A.EMPLEADO = '" + textBox2.Text + "'", con.conex); SqlDataReader dr1 = cm1.ExecuteReader(); while (dr1.Read()) { Nombre_Empleado = Convert.ToString(dr1["NOMBRE"]); ID_EMPLEADO = Convert.ToString(dr1["EMPLEADO"]); Cargo = Convert.ToString(dr1["PUESTO"]); Departamento = Convert.ToString(dr1["DEPARTAMENTO"]); textBox1.Text = Nombre_Empleado; Cargadatos(); } con.Desconectar("EX"); }
private void textBox1_KeyUp(object sender, KeyEventArgs e) { Pedido.Clear(); con.conectar("EX"); SqlCommand cmd = new SqlCommand("SELECT [PEDIDO],[ESTADO],[FECHA_PEDIDO],[FECHA_PROMETIDA],[FECHA_PROX_EMBARQU],[FECHA_ULT_EMBARQUE] FROM [EXACTUS].[" + Login.empresa + "].[PEDIDO] where PEDIDO = '" + this.textBox1.Text + "'", con.conex); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(Pedido); dataGridView1.DataSource = Pedido; dataGridView1.Refresh(); con.Desconectar("EX"); groupBox1.Enabled = false; }
private void Forma_pago_flota_Load(object sender, EventArgs e) { //Usuario = Login.usuario.ToUpper(); Usuario = "TURCIOSI"; process = 0; textBox1.Enabled = false; textBox2.Enabled = false; comboBox1.Enabled = false; textBox4.Enabled = false; ID = 0; textBox1.Text = ""; textBox2.Text = ""; comboBox1.Text = ""; textBox4.Text = ""; toolStripButton2.Enabled = false; toolStripButton3.Enabled = false; toolStripButton4.Enabled = false; toolStripButton5.Enabled = false; dataGridView1.Enabled = true; dataGridView1.RowHeadersVisible = false; dataGridView1.AutoResizeColumns(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.ReadOnly = true; dataGridView1.AllowUserToAddRows = false; con.conectar("DM"); dt1.Clear(); string consulta = "SELECT [ID],[TIPO],[NUMERO_TAR],[AGENCIA],[USUARIO],[FECHA] FROM [DM].[CORRECT].[FORMA_PAGO_GAS]"; SqlCommand comando = new SqlCommand(consulta, con.condm); SqlDataAdapter adap = new SqlDataAdapter(comando); adap.Fill(dt1); dataGridView1.DataSource = dt1; dataGridView1.Refresh(); con.Desconectar("DM"); }
private bool Exists_FAC(string factura, string registro) { con.conectar("DM"); SqlCommand cmd = new SqlCommand("select COUNT (*) from [DM].[CORRECT].[FAC_FLOTA] where FACTURA = '" + factura + "' and REGISTRO = '" + registro + "'", con.condm); string contar = Convert.ToString(cmd.ExecuteScalar()); con.Desconectar("DM"); if (contar == "0") { return(false); } else { return(true); } }
private void Cobro_bod_Load(object sender, EventArgs e) { this.reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local; con.conectar("EX"); SqlCommand cm2 = new SqlCommand("SELECT [RUTA] FROM [EXACTUS].[" + Login.empresa + "].[RUTA] where RUTA like 'E%' ", con.conex); SqlDataReader dr2 = cm2.ExecuteReader(); while (dr2.Read()) { comboBox1.Items.Add(dr2["RUTA"]); } dr2.Close(); con.Desconectar("EX"); // this.reportViewer1.RefreshReport(); }
private void Form14_Load(object sender, EventArgs e) { label3.Text = DateTime.Now.ToString("dd-MM-yyyy"); this.radioButton2.Checked = true; con.conectar("DM"); SqlCommand cmd = new SqlCommand("SELECT [RUTA]FROM [DM].[CORRECT].[RUTA_REGALIAS] where RUTA like 'R%'", con.condm); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); con.Desconectar("DM"); }
private void Reporte_Carera_XLS_Load(object sender, EventArgs e) { button1.Enabled = false; dataGridView1.Enabled = true; dataGridView1.RowHeadersVisible = false; //dataGridView1.AutoResizeColumns(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.ReadOnly = true; this.comboBox1.Text = "Todos"; con.conectar("EX"); SqlCommand cm1 = new SqlCommand("SELECT Vendedor FROM [EXACTUS].[" + empresa + "].[SoftlandBI_CC_SaldoClientes] GROUP BY Vendedor", con.conex); SqlDataReader dr1 = cm1.ExecuteReader(); while (dr1.Read()) { comboBox1.Items.Add(dr1["Vendedor"]); } dr1.Close(); con.Desconectar("EX"); }
public static DataTable EMPLEADOS_ACCESO() { DataTable dt9 = new DataTable(); conexionXML con = new conexionXML(); con.conectar("SEG"); string consulta = "SELECT UPPER(RTRIM(LTRIM(ISNULL(FIRSTNAME,''))))+' '+ UPPER(RTRIM(LTRIM(isnull(MIDNAME,''))))+' '+UPPER(RTRIM(LTRIM(ISNULL(LASTNAME,'')))) AS NOMBRE, CARDT.ID as CARNET FROM [ACCESSCONTROL].[dbo].[EMP] EMPLE LEFT JOIN [ACCESSCONTROL].[dbo].[BADGE] CARDT on EMPLE.ID = CARDT.EMPID where CARDT.STATUS = '1'"; SqlCommand comando = new SqlCommand(consulta, con.conseg); SqlDataAdapter adap = new SqlDataAdapter(comando); adap.Fill(dt9); con.Desconectar("SEG"); return(dt9); }
private void Form5_Load(object sender, EventArgs e) { MaximizeBox = false; try { DTconexion = XMLRW.Readxml("CONFIGURACION"); } catch (Exception conexerro) { MessageBox.Show(conexerro.ToString(), "Error en Configuracion XML"); } var ensablado = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version; vercion_actual = ensablado.ToString(); label3.Text = vercion_actual; cont.conectar("DM"); SqlCommand cm2 = new SqlCommand("SELECT [VERCION] FROM [DM].[CORRECT].[VERCION_CORRECTX] WHERE ID_VERCION = '1'", cont.condm); SqlDataReader dr2 = cm2.ExecuteReader(); while (dr2.Read()) { vercion = Convert.ToString(dr2["VERCION"]); } dr2.Close(); cont.Desconectar("DM"); int ctn = vercion_actual.Length; actual = vercion_actual.Substring((ctn - 3), 3); int ctn2 = vercion.Length; nueva = vercion.Substring((ctn2 - 3), 3); if (Convert.ToInt32(actual) < Convert.ToInt32(nueva)) { MessageBoxButtons bt1 = MessageBoxButtons.YesNo; DialogResult result = MessageBox.Show("EXISTE UNA NUEVA VERSION DE CORRECT " + vercion + " ¿DESEA REALIZAR LA ACTUALIZACION ?", "ACTUALIZACION SISTEMA " + vercion_actual + "", bt1, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1); if (result == DialogResult.Yes) { compiar_archivo(); instalar_actualizacion(); this.Close(); } } else { } cargaempresas(); combo_empresa(comboBox1, agencias, "NOMRE"); }
private void Correlativo_process_Load(object sender, EventArgs e) { label5.Hide(); textBox2.Hide(); dataGridView1.Enabled = true; dataGridView1.RowHeadersVisible = false; //dataGridView1.AutoResizeColumns(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.ReadOnly = true; dataGridView2.Enabled = true; dataGridView2.RowHeadersVisible = false; //dataGridView1.AutoResizeColumns(); dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView2.ReadOnly = true; fecha_actual = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); label2.Text = "Correlativo Actual"; textBox1.ForeColor = Color.Gray; button2.Enabled = false; con.conectar("EX"); SqlCommand cm1 = new SqlCommand("SELECT [RUTA] FROM [EXACTUS].[" + Login.empresa + "].[RUTA] where DESCRIPCION = 'PRONTA'ORDER BY RUTA", con.conex); SqlDataReader dr1 = cm1.ExecuteReader(); while (dr1.Read()) { comboBox1.Items.Add("R" + dr1["RUTA"]); } dr1.Close(); con.Desconectar("EX"); }
private void Form9_Load(object sender, EventArgs e) { fecha = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); MaximizeBox = false;; dt.Clear(); dataGridView1.RowHeadersVisible = false; dataGridView1.AutoResizeColumns(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.Refresh(); Inicializar(); /*this.comboBox1.Enabled = false; * this.comboBox2.Enabled = false; * this.richTextBox1.Enabled = false; * this.button1.Enabled = false; * this.cbCausas.Enabled = false; * this.txtSerie.Enabled = false; * this.txtModelo.Enabled = false; */ if (Main_Menu.Departamento != "INFORMATICA") { this.groupBox2.Hide(); dataGridView1.Size = new Size(556, 140); dataGridView1.Location = new Point(13, 122); pictureBox1.Location = new Point(440, 5); } else { con.conectar("DM"); SqlCommand cm0 = new SqlCommand("SELECT NOMRE FROM [DM].[CORRECT].[EMPRESAS] ORDER BY NOMRE ", con.condm); SqlDataReader dr0 = cm0.ExecuteReader(); while (dr0.Read()) { comboBox1.Items.Add(dr0["NOMRE"]); } dr0.Close(); con.Desconectar("DM"); /**This.comboBox1.Items.Add("KOI"); * this.comboBox1.Items.Add("DISMO"); * this.comboBox1.Items.Add("CV+"); * this.comboBox1.Items.Add("SMASH BURGER"); * this.comboBox1.Items.Add("LESA"); * this.comboBox1.Items.Add("IMPACTO"); **/ } if (Login.usuario.IndexOf("p") >= 0 || Login.usuario.IndexOf("P") >= 0) { string rutaP = Login.usuario.ToUpper(); char[] RTchar = { 'P' }; string rutaR = rutaP.TrimStart(RTchar); this.comboBox1.Text = "R" + rutaR; } else { this.comboBox1.Text = null; } con.conectar("DM"); //Cargando Departamentos SqlCommand cmdep = new SqlCommand("SELECT [DEPTO] FROM [DM].[CORRECT].[DEPARTAMENTO] order by DEPTO ", con.condm); SqlDataReader drdep = cmdep.ExecuteReader(); while (drdep.Read()) { this.cbDepto.Items.Add(drdep["DEPTO"]); } drdep.Close(); //Cargando Causas de Soporte SqlCommand cmcau = new SqlCommand("SELECT [nombre] FROM [DM].[CORRECT].[CAUSAS] ORDER BY NOMBRE ", con.condm); SqlDataReader drcau = cmcau.ExecuteReader(); while (drcau.Read()) { this.cbCausas.Items.Add(drcau["NOMBRE"]); } drcau.Close(); //Cargando Dispositivos SqlCommand cmdis = new SqlCommand("SELECT [NOMBRE] FROM [DM].[CORRECT].[DISPOSITIVOS] ORDER BY NOMBRE ", con.condm); SqlDataReader drdis = cmdis.ExecuteReader(); while (drdis.Read()) { comboBox2.Items.Add(drdis["NOMBRE"]); } drdis.Close(); SqlCommand cm2 = new SqlCommand("SELECT [RUTA]FROM [DM].[CORRECT].[RUTAS] ORDER BY RUTA ", con.condm); SqlDataReader dr2 = cm2.ExecuteReader(); while (dr2.Read()) { comboBox1.Items.Add(dr2["RUTA"]); } dr2.Close(); SqlCommand cm3 = new SqlCommand("SELECT [NOMBRE] FROM [DM].[CORRECT].[RUTAS] WHERE HANDHELD = '" + Login.usuario + "' ", con.condm); SqlDataReader dr3 = cm3.ExecuteReader(); while (dr3.Read()) { this.label4.Text = Convert.ToString(dr3["NOMBRE"]); } dr3.Close(); /* * //SqlCommand cmd = new SqlCommand("SELECT [NUM_CASO],[USUARIO_REP],[ESTATUS],[NOMBRE],[DET_PROBLEMA],[RUTA] ,[EQUIPO] ,[FECHA_CREA],MODELO,SERIE,CAUSA,DEPTO FROM [DM].[CORRECT].[CASOS] WHERE RUTA = '" + this.comboBox1.Text + "' ", con.condm); * SqlCommand cmd = new SqlCommand("SELECT [NUM_CASO],[USUARIO_REP],[ESTATUS],PRIORIDAD,[DET_PROBLEMA],[RUTA] ,[NOMBRE],[EQUIPO] ,[FECHA_CREA],MODELO,SERIE,CAUSA,DEPTO FROM [DM].[CORRECT].[CASOS] WHERE ESTATUS!='Cerrado' order by PRIORIDAD,FECHA_CREA", con.condm); * SqlDataAdapter da = new SqlDataAdapter(cmd); * da.Fill(dt); * * dataGridView1.DataSource = dt; * dataGridView1.Refresh(); */ con.Desconectar("DM"); }
private void Form10_Load(object sender, EventArgs e) { fecha = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); this.label7.Text = Login.usuario.ToUpper(); this.label8.Text = fecha; if (Main_Menu.Departamento == "INFORMATICA") { if (Casos_Main.status == "Cerrado") { this.richTextBox1.Enabled = false; this.button1.Hide(); this.comboBox2.Enabled = false; } } else { this.richTextBox1.Enabled = false; this.button1.Hide(); this.comboBox2.Enabled = false; } con.conectar("DM"); SqlCommand cm2 = new SqlCommand("SELECT SOLUCION,FECHA_UPDATE,USUARIO_UPDATE FROM [DM].[CORRECT].[CASOS] WHERE NUM_CASO ='" + Casos_Main.Caso + "' ", con.condm); SqlDataReader dr2 = cm2.ExecuteReader(); while (dr2.Read()) { this.richTextBox1.Text = Convert.ToString(dr2["SOLUCION"]); usuario = Convert.ToString(dr2["USUARIO_UPDATE"]); if (Casos_Main.status != "Abierto") { this.label4.Text = Convert.ToString(dr2["FECHA_UPDATE"]); } else { this.label4.Text = "Caso Sin Atender"; this.label6.Text = "Caso Sin Atender"; } } dr2.Close(); con.Desconectar("DM"); this.comboBox2.Text = Casos_Main.status; switch (usuario) { case "TURCIOSI": this.label6.Text = "ISAAC TURCIOS"; break; case "SANTOSM": this.label6.Text = "MISAEL SANTOS"; break; case "HERCULESC": this.label6.Text = "CARLOS HERCULES"; break; case "ESTRADAJ": this.label6.Text = "JAVIER ESTRADA"; break; default: this.label6.Text = usuario; break; } }