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; }
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"); }
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 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 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 cargaSupervALL(string comd) { con.conectar("WEB"); MySqlCommand mcm = new MySqlCommand(comd, con.mysqlconec); mcm.CommandTimeout = 1200; MySqlDataReader mdr = mcm.ExecuteReader(); while (mdr.Read()) { comboBox1.Items.Add(mdr["usuario"]); } con.Desconectar("WEB"); }
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 button2_Click(object sender, EventArgs e) { DT.Columns.Clear(); DT.Clear(); dataGridView1.Refresh(); switch (comboBox1.Text) { case "Tiempos de Impresion de Facturas": con.conectar("DM"); SqlCommand cm1 = new SqlCommand("SELECT ped.VENDEDOR,COUNT(ped.[PEDIDO]) as 'PEDIDOS' , CONVERT(varchar,CAST(MAX(CAST(ped.CreateDate as FLOAT))as Datetime),8) as 'Hora de Proceso',COUNT(fac.FACTURA) as 'Facturados',CONVERT(varchar,CAST(MAX(CAST(fac.CreateDate as FLOAT))as Datetime),8) as 'Hora de Facturacion',DATEDIFF(MINUTE,CONVERT(varchar,CAST(MAX(CAST(ped.CreateDate as FLOAT))as Datetime),8),CONVERT(varchar,CAST(MAX(CAST(fac.CreateDate as FLOAT))as Datetime),8)) as 'Minutos Transcurridos'FROM [EXACTUS].[" + empresa + "].[PEDIDO] ped left join [EXACTUS].[" + empresa + "].[FACTURA] fac on ped.PEDIDO =fac.PEDIDO where ped.FECHA_PEDIDO = '" + dateTimePicker1.Value.ToString("yyyy/MM/dd") + "' and ped.RUTA like 'E%' Group by ped.VENDEDOR order by ped.VENDEDOR", con.condm); SqlDataAdapter da = new SqlDataAdapter(cm1); da.Fill(DT); con.Desconectar("DM"); dataGridView1.DataSource = DT; dataGridView1.Refresh(); Encabezado = "REPORTE TIEMPOS DE IMPRESION FACTURAS"; break; case "Tiempos de Sincronizacion": con.conectar("DM"); SqlCommand cmd2 = new SqlCommand("[CORRECT].[SINCRONIZACION]", con.condm); cmd2.CommandType = CommandType.StoredProcedure; SqlDataAdapter da1 = new SqlDataAdapter(cmd2); cmd2.Parameters.AddWithValue("@fechaini", dateTimePicker1.Value.ToString("yyyy/MM/dd")); cmd2.Parameters.AddWithValue("@fechafin", dateTimePicker2.Value.ToString("yyyy/MM/dd")); cmd2.ExecuteNonQuery(); da1.Fill(DT); con.Desconectar("DM"); dataGridView1.DataSource = DT; dataGridView1.Refresh(); Encabezado = "REPORTE TIEMPOS DE SINCRONIZACION"; break; case "Articulos Bonificados por REP": con.conectar("DM"); SqlCommand cmd3 = new SqlCommand("[CORRECT].[ATICULOS_BONIFICADOS]", con.condm); cmd3.CommandType = CommandType.StoredProcedure; SqlDataAdapter da3 = new SqlDataAdapter(cmd3); cmd3.Parameters.AddWithValue("@fechaini", dateTimePicker1.Value.ToString("yyyy/MM/dd")); cmd3.Parameters.AddWithValue("@fechafin", dateTimePicker2.Value.ToString("yyyy/MM/dd")); cmd3.Parameters.AddWithValue("@empresa", Login.empresa); cmd3.ExecuteNonQuery(); da3.Fill(DT); con.Desconectar("DM"); dataGridView1.DataSource = DT; dataGridView1.Refresh(); Encabezado = "Articulos Bonificados por REP"; break; } }
private void Form12_Load(object sender, EventArgs e) { label16.Hide(); comboBox5.Hide(); editmode = 0; toolStripButton5.Enabled = false; if (Regalias_Vencido.modo == 2) { dt.Clear(); dataGridView1.Enabled = true; dataGridView1.RowHeadersVisible = false; dataGridView1.AutoResizeColumns(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.ReadOnly = true; dataGridView1.Refresh(); con.conectar("DM"); pictureBox1.Hide(); pictureBox2.Hide(); this.dateTimePicker1.Value = Regalias_Vencido.fechadc; this.toolStripButton1.Enabled = false; this.toolStripButton2.Enabled = false; this.toolStripButton5.Enabled = true; this.textBox1.Text = Regalias_Vencido.Documento_fisico; this.textBox1.Enabled = false; SqlCommand cmd = new SqlCommand("SELECT Articulo as 'ARTICULO',DescripcionArticulo as 'DESCRIPCION',CAST(Cantidad as decimal (18,2))as 'CANTIDAD' FROM [EXACTUS].[dismo].[SoftlandBI_CI_Movimientos] where Bodega = 'B013' and Naturaleza = 'Entrada' and Documento = '" + Regalias_Vencido.Documento + "' ", con.condm); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); dataGridView1.DataSource = dt; dataGridView1.Refresh(); con.Desconectar("DM"); } else if (Regalias_Vencido.modo == 3) { dataGridView1.ColumnCount = 3; dataGridView1.Columns[0].Name = "CODIGO"; dataGridView1.Columns[1].Name = "DESCRIPCION"; dataGridView1.Columns[2].Name = "CANTIDAD"; this.label5.Hide(); this.label1.Hide(); this.label2.Hide(); this.comboBox1.Hide(); this.comboBox3.Hide(); this.richTextBox1.Hide(); this.label10.Text = "Fecha de Vencimiento"; this.Text = "INGRESO DE VENCIDO"; } else if (Regalias_Vencido.modo == 4) { dataGridView1.Enabled = false; dataGridView1.ReadOnly = true; this.toolStripButton1.Enabled = false; this.toolStripButton5.Enabled = false; this.toolStripButton3.Enabled = false; this.label5.Hide(); this.label1.Hide(); this.label2.Hide(); this.comboBox1.Hide(); this.comboBox3.Hide(); this.richTextBox1.Hide(); this.label10.Text = "Fecha de Vencimiento"; this.Text = "INGRESO DE VENCIDO"; dt.Clear(); dataGridView1.RowHeadersVisible = false; dataGridView1.AutoResizeColumns(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.Refresh(); con.conectar("DM"); SqlCommand cmd = new SqlCommand("select COD_PROD as 'CODIGO',DESCRIPCION,CANTIDAD FROM [DM].[CORRECT].[DET_VENCIDO] WHERE NUM_DOC ='" + Regalias_Vencido.Documento + "' ", con.condm); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); dataGridView1.DataSource = dt; dataGridView1.Refresh(); SqlCommand cmd2 = new SqlCommand("SELECT A.NUM_DOC ,A.RUTA,A.AGENCIA ,B.FECHA_VEN FROM [DM].[CORRECT].[ENC_VENCIDO] A LEFT JOIN [DM].[CORRECT].[DET_VENCIDO] B ON A.NUM_DOC = B.NUM_DOC WHERE A.NUM_DOC ='" + Regalias_Vencido.Documento + "'GROUP BY A.[NUM_DOC] ,A.[RUTA],A.[AGENCIA],B.FECHA_VEN", con.condm); SqlDataReader dr2 = cmd2.ExecuteReader(); while (dr2.Read()) { this.comboBox2.Text = Convert.ToString(dr2["RUTA"]); this.textBox1.Text = Convert.ToString(dr2["NUM_DOC"]); this.comboBox4.Text = Convert.ToString(dr2["AGENCIA"]); this.dateTimePicker1.Value = (DateTime)dr2["FECHA_VEN"]; } dr2.Close(); con.Desconectar("DM"); } else { dataGridView1.ColumnCount = 3; dataGridView1.Columns[0].Name = "CODIGO"; dataGridView1.Columns[1].Name = "DESCRIPCION"; dataGridView1.Columns[2].Name = "CANTIDAD"; pictureBox1.Hide(); pictureBox2.Hide(); } toolStripButton3.Enabled = false; ControlBox = false; this.ActiveControl = comboBox2; dataGridView1.RowHeadersVisible = false; dataGridView1.AllowUserToAddRows = false; dateTimePicker1.Format = DateTimePickerFormat.Custom; dateTimePicker1.CustomFormat = "dd-MM-yyyy"; fecha_actual = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"); dataGridView1.Enabled = false; Usuario = Login.usuario.ToUpper(); label8.Text = Usuario; comboBox4.Text = Main_Menu.Agencia; comboBox2.DataSource = AutocompleteRuta.AutocompleteRutas.RUTAS(); comboBox2.DisplayMember = "RUTA"; comboBox2.ValueMember = "RUTA"; comboBox2.AutoCompleteCustomSource = AutocompleteRuta.AutocompleteRutas.AutocompleteRT(); comboBox2.AutoCompleteMode = AutoCompleteMode.Suggest; comboBox2.AutoCompleteSource = AutoCompleteSource.CustomSource; comboBox5.DataSource = AutocompleteRuta.AutocompleteRutas.ACTIVIDADES(); comboBox5.DisplayMember = "NOMBRE"; comboBox5.ValueMember = "NOMBRE"; comboBox5.AutoCompleteCustomSource = AutocompleteRuta.AutocompleteRutas.AutocompleteACTIVIDAD(); comboBox5.AutoCompleteMode = AutoCompleteMode.Suggest; comboBox5.AutoCompleteSource = AutoCompleteSource.CustomSource; comboBox6.DataSource = AutocompleteRuta.AutocompleteRutas.CUENTA_BAT(); comboBox6.DisplayMember = "CUENTA"; comboBox6.ValueMember = "CUENTA"; comboBox6.AutoCompleteCustomSource = AutocompleteRuta.AutocompleteRutas.AutocompleteCUENTA_BAT(); comboBox6.AutoCompleteMode = AutoCompleteMode.Suggest; comboBox6.AutoCompleteSource = AutoCompleteSource.CustomSource; comboBox6.Hide(); label17.Hide(); }
private void button1_Click_1(object sender, EventArgs e) { dt.Clear(); if (dt.Columns.Count >= 1) { dt.Columns.Clear(); } if (gridView1.Columns.Count >= 1) { gridView1.Columns.Clear(); } gridControl1.DataSource = null; // gridControl1.Refresh(); if (tip_rep == 2) { string fechaini = dateTimePicker1.Value.ToString("yyyy-MM-dd"); string fechafin = dateTimePicker2.Value.ToString("yyyy-MM-dd"); con.conectar("DM"); SqlCommand cmd = new SqlCommand("[CORRECT].[VISITA_DISTANCIA]", con.condm); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@empresa", Login.empresa); cmd.Parameters.AddWithValue("@fecha_ini", fechaini + " 00:00:00.000"); cmd.Parameters.AddWithValue("@fecha_fin", fechafin + " 23:59:59.000"); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); con.Desconectar("DM"); gridControl1.DataSource = dt; int numRows = gridView1.RowCount; label3.Text = Convert.ToString(numRows - 1); if (numRows - 1 > 0) { button3.Enabled = true; } } else { con.conectar("DM"); SqlCommand cmd = new SqlCommand("[CORRECT].[RUTEROGPS]", con.condm); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@empresa", Login.empresa); if (checkBox3.Checked) { cmd.Parameters.AddWithValue("@geo", 0); } else { cmd.Parameters.AddWithValue("@geo", 1); } cmd.Parameters.AddWithValue("@tipo_rep", tip_rep); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); con.Desconectar("DM"); gridControl1.DataSource = dt; int numRows = gridView1.RowCount; label3.Text = Convert.ToString(numRows - 1); if (numRows - 1 > 0) { if (checkBox3.Checked) { this.button2.Enabled = false; this.button4.Enabled = false; } else { this.button2.Enabled = true; this.button4.Enabled = true; } this.button3.Enabled = true; } else { this.button2.Enabled = false; this.button4.Enabled = false; this.button3.Enabled = false; } } }
private void Form4_Load(object sender, EventArgs e) { ven_name.Clear(); listView1.View = View.Details; //Detalles listView1.GridLines = true; //Lineas listView1.FullRowSelect = true; listView1.Clear(); listView1.Columns.Add("Ruta", 50, HorizontalAlignment.Left); listView1.Columns.Add("Nombre", 120, HorizontalAlignment.Left); show_nosinc(Join_tablas(Sincronizacion.No_sincronizadas, ven_name)); con.conectar("EX"); SqlCommand cm1 = new SqlCommand("SELECT [HANDHELD] as RUTA,VEN.NOMBRE FROM [EXACTUS].[ERPADMIN].[RUTA_ASIGNADA_RT] RT LEFT JOIN [EXACTUS].[" + Login.empresa + "].[VENDEDOR] as VEN on RT.AGENTE = VEN.VENDEDOR where RT.COMPANIA = '" + Login.empresa + "' and VEN.ACTIVO = 'S'", con.conex); SqlDataAdapter da = new SqlDataAdapter(cm1); da.Fill(ven_name); con.Desconectar("EX"); show_nosinc(Join_tablas(Sincronizacion.No_sincronizadas, ven_name)); //if (Sincronizacion.time == "Tarde") //{ // try // { // listView1.Clear(); // listView1.Columns.Add("Ruta", 50, HorizontalAlignment.Left); // listView1.Columns.Add("Nombre", 120, HorizontalAlignment.Left); // con.conectar("EX"); // SqlCommand cm1 = new SqlCommand("SELECT A. HANDHELD,B.NOMBRE FROM ERPADMIN.RUTA_ASIGNADA_RT A INNER JOIN ERPADMIN.AGENTE_RT B ON A.AGENTE = B.AGENTE WHERE A.COMPANIA = '" + Login.empresa + "' AND A. HANDHELD NOT IN (SELECT PDA FROM [EXACTUS].[ERPADMIN].[EMM_SYNCINFO] WHERE CONDUIT = '" + Sincronizacion.conduit + "' AND SYNC_START BETWEEN '" + Sincronizacion.fecha_sinc + " 12:00:00' AND '" + Sincronizacion.fecha_sinc + " 23:59:00')AND B.NOMBRE <> 'OFFLINE' GROUP BY A.HANDHELD,B.NOMBRE", 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()); // listView1.Items.Add(lvItem); // } // dr1.Close(); // con.Desconectar("EX"); // } // catch // { // MessageBox.Show("Error Carga de Rutas"); // con.Desconectar("EX"); // } //} //else // if (Sincronizacion.time == "Mañana") // { // try // { // listView1.Clear(); // listView1.Columns.Add("Ruta", 50, HorizontalAlignment.Left); // listView1.Columns.Add("Nombre", 120, HorizontalAlignment.Left); // con.conectar("EX"); // SqlCommand cm1 = new SqlCommand("SELECT A. HANDHELD,B.NOMBRE FROM ERPADMIN.RUTA_ASIGNADA_RT A INNER JOIN ERPADMIN.AGENTE_RT B ON A.AGENTE = B.AGENTE WHERE A.COMPANIA = '"+Login.empresa+"' AND A. HANDHELD NOT IN (SELECT PDA FROM [EXACTUS].[ERPADMIN].[EMM_SYNCINFO] WHERE A.COMPANIA = '" + Login.empresa + "' AND CONDUIT = '" + Sincronizacion.conduit + "' AND PDA LIKE 'P%' AND SYNC_START BETWEEN '" + Sincronizacion.fecha_sinc + " 1:00:00' AND '" + Sincronizacion.fecha_sinc + " 12:00:00')AND B.NOMBRE <> 'OFFLINE' GROUP BY A.HANDHELD,B.NOMBRE", 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()); // listView1.Items.Add(lvItem); // } // dr1.Close(); // con.Desconectar("EX"); // } // catch // { // MessageBox.Show("Error Carga de Rutas"); // con.Desconectar("EX"); // } // } // else if (Sincronizacion.time == "Todos") // { // //try // //{ // listView1.Clear(); // listView1.Columns.Add("Ruta", 50, HorizontalAlignment.Left); // listView1.Columns.Add("Nombre", 120, HorizontalAlignment.Left); // con.conectar("EX"); // SqlCommand cm1 = new SqlCommand("SELECT A. HANDHELD,B.NOMBRE FROM ERPADMIN.RUTA_ASIGNADA_RT A INNER JOIN ERPADMIN.AGENTE_RT B ON A.AGENTE = B.AGENTE WHERE A.COMPANIA = '" + Login.empresa+"' AND A. HANDHELD NOT IN (SELECT PDA FROM [EXACTUS].[ERPADMIN].[EMM_SYNCINFO] WHERE A.COMPANIA = '" + Login.empresa + "' AND CONDUIT = '" + Sincronizacion.conduit + "' AND PDA LIKE 'P%' AND SYNC_START BETWEEN '" + Sincronizacion.fecha_sinc + " 1:00:00' AND '" + Sincronizacion.fecha_sinc + " 23:59:59')AND B.NOMBRE <> 'OFFLINE' GROUP BY A.HANDHELD,B.NOMBRE", 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()); // listView1.Items.Add(lvItem); // } // dr1.Close(); // con.Desconectar("EX"); // //} // //catch // //{ // // MessageBox.Show("Error Carga de Rutas"); // // con.Desconectar("EX"); // //} //} }
public GenerarArchivos() { // int NroReporte = 0; // 1=Reporte de Ventas 2=Clientes 3=Inventario // Generar fecha actual menos 15 dias // DataTable dt ; // DataSet DS; cargar_lineas_prod(); if (linea.Rows.Count >= 1) { for (int t = 0; t < linea.Rows.Count; t++) //Controla las columnas { string Nombre_linea; DataRow rowL = linea.Rows[t]; Nombre_linea = Convert.ToString(rowL["DESCRIPCION"]); string NArchivo; //fecha de Archivo string NomredelTXT = ""; //Nombre de Archivo System.IO.StreamWriter sw; // Escritura de archivo int x = 0; StringBuilder csvMemoria; //Calcular inicio de Mes los primeros 5 dias toma tambien los ultimos 5 dias del mes anterior int diaini = 0; int diafin = 0; SqlDataAdapter da; //GENERAR ARCHIVO for (int i = 1; i <= 4; i++) { // DS = new DataSet(); try { //REPORTE DE VENTAS con.conectar("DM"); da = new SqlDataAdapter("CORRECT.KC_EXPORTA_VENTAV2", 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("@REP", SqlDbType.Int); da.SelectCommand.Parameters.Add("@EMPRESA", SqlDbType.VarChar); diaini = -15; //Resto 15 dias a Fecha actual diafin = -1; //Resto solo un dia a la Fecha Actual if (DateTime.Today.Day == 1 && i == 4) // Si es el primer dia de cada mes Imprime el mensual como reporte 4 { da.SelectCommand.Parameters["@FINI"].Value = new DateTime(DateTime.Today.Year, DateTime.Today.Month - 1, 1); da.SelectCommand.Parameters["@FFIN"].Value = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1).AddDays(-1); da.SelectCommand.Parameters["@REP"].Value = Convert.ToInt32("1"); da.SelectCommand.Parameters["@EMPRESA"].Value = Nombre_linea; } else // Si no es el primer dia se imprime ultimos 15 dias de venta { da.SelectCommand.Parameters["@FINI"].Value = Convert.ToDateTime(DateTime.Today.AddDays(diaini)); da.SelectCommand.Parameters["@FFIN"].Value = Convert.ToDateTime(DateTime.Today.AddDays(diafin)); da.SelectCommand.Parameters["@REP"].Value = Convert.ToInt32(i); da.SelectCommand.Parameters["@EMPRESA"].Value = Nombre_linea; } da.SelectCommand.CommandTimeout = 1200; Datos.Clear(); if (Datos.Columns.Count > 1) { Datos.Columns.Clear(); } da.Fill(Datos); //Guardando datos en tabla // con.Desconectar("DM"); } catch (Exception ex) { // MessageBox.Show("No se Pudo conectar a la BD Error: " + ex.Message); } //GENERANDO ARCHIVO DE TEXTO csvMemoria = new StringBuilder(); for (int m = 0; m < Datos.Rows.Count; m++) //Controla las filas { x = Datos.Rows.Count; for (int n = 0; n < Datos.Columns.Count; n++) //Controla las columnas { //si es la última columna no poner el | if (n == Datos.Columns.Count - 1) { csvMemoria.Append(String.Format("{0}", Datos.Rows[m].ItemArray[n].ToString().Trim())); } else { if (Datos.Rows[m].ItemArray[n].GetType() == Type.GetType("System.DateTime")) { csvMemoria.Append(String.Format("{0}|", Datos.Rows[m].ItemArray[n].ToString().Substring(0, 10))); } else { if (Datos.Rows[m].ItemArray[n].GetType() == Type.GetType("System.Decimal")) { if (Datos.Columns[n].Caption.Equals("LONGITUD") || Datos.Columns[n].Caption.Equals("LATITUD")) { csvMemoria.Append(String.Format("{0}|", Datos.Rows[m].ItemArray[n].ToString().Trim())); } else { csvMemoria.Append(String.Format("{0}|", Math.Round(Convert.ToDecimal(Datos.Rows[m].ItemArray[n]), 3).ToString())); } } else { csvMemoria.Append(String.Format("{0}|", Datos.Rows[m].ItemArray[n].ToString().Trim())); } } } } csvMemoria.AppendLine(); } //Fecha en formato ddmmyyyy if (DateTime.Today.Day == 1) //Si es primero de mes { if (DateTime.Today.Month == 1) //Si es 1 de Enero coloca fecha del ultimo dia del año pasado { NArchivo = DateTime.Today.AddDays(-1).Day.ToString().PadLeft(2, '0') + DateTime.Today.AddDays(-1).Month.ToString().PadLeft(2, '0') + DateTime.Today.AddDays(-1).Year.ToString(); } else // Si uno de mes pero no es enero { NArchivo = DateTime.Today.AddDays(-1).Day.ToString().PadLeft(2, '0') + DateTime.Today.AddDays(-1).Month.ToString().PadLeft(2, '0') + DateTime.Today.Year.ToString(); } } else { NArchivo = DateTime.Today.AddDays(-1).Day.ToString().PadLeft(2, '0') + DateTime.Today.Month.ToString().PadLeft(2, '0') + DateTime.Today.Year.ToString(); } if (Nombre_linea == "KIMBERLYPRO") { NomredelTXT = "P" + NArchivo + "_" + i.ToString() + ".txt"; } else { NomredelTXT = NArchivo + "_" + i.ToString() + ".txt"; } sw = new System.IO.StreamWriter(@"C:\CORRECT\DatosKC" + NomredelTXT, false, System.Text.Encoding.Default); sw.Write(csvMemoria.ToString()); sw.Close(); Datos.Clear(); if (DateTime.Today.Day > 1 && i == 3) //Si llego al 3 y no es dia primero sale del for para no generar el mensual { break; } } //fin del For //CARGAR AL FTP /* Create Object Instance */ // String ftpsitio= @"ftp://dt.kcmkt.com/"; DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand("SELECT Empresa,Ftp,Usuario,Clave FROM DM.CORRECT.FTP_LOGIN WHERE EMPRESA='KIMBERLYSFTP'", con.condm); da = new SqlDataAdapter(cmd); da.Fill(dt); DataRow row = dt.Rows[0]; String Servidorftp = row["Ftp"].ToString(); String Usuario = row["Usuario"].ToString(); String Clave = row["Clave"].ToString(); // ftp ftpClient = new ftp(@"ftp://dt.kcmkt.com/", "*****@*****.**", "Clave1"); //ftp ftpClient = new ftp(@Servidorftp, Usuario, Clave); for (int i = 1; i <= 4; i++) //Cargando Archivo por Archivo { if (DateTime.Today.Day == 1) { if (DateTime.Today.Month == 1) //Si es 1 de Enero coloca fecha del ultimo dia del año pasado { NArchivo = DateTime.Today.AddDays(-1).Day.ToString().PadLeft(2, '0') + DateTime.Today.AddDays(-1).Month.ToString().PadLeft(2, '0') + DateTime.Today.AddDays(-1).Year.ToString(); } else //Si es primero de mes { NArchivo = DateTime.Today.AddDays(-1).Day.ToString().PadLeft(2, '0') + DateTime.Today.AddDays(-1).Month.ToString().PadLeft(2, '0') + DateTime.Today.Year.ToString(); } } else { NArchivo = DateTime.Today.AddDays(-1).Day.ToString().PadLeft(2, '0') + DateTime.Today.Month.ToString().PadLeft(2, '0') + DateTime.Today.Year.ToString(); } if (Nombre_linea == "KIMBERLYPRO") { NomredelTXT = "P" + NArchivo + "_" + i.ToString() + ".txt"; } else { NomredelTXT = NArchivo + "_" + i.ToString() + ".txt"; } /* Upload a File */ // ftpClient.upload("/DatosKC" + NomredelTXT, @"C:\CORRECT\DatosKC" + NomredelTXT); sftp(Servidorftp, Usuario, Clave, NomredelTXT); if (DateTime.Today.Day > 1 && i == 3) //Si llego al 3 y no es dia primero sale del for para no generar el mensual { break; } } con.Desconectar("DM"); // MessageBox.Show(row["Ftp"].ToString()+","+row["Usuario"].ToString()+","+row["Clave"].ToString()+" Generacion Automatica Terminada"); } Application.Exit(); } }
public void Ejecutar() { conexionXML con = new conexionXML(); DataTable dt = new DataTable(); //GENERAR ARCHIVO try { con.conectar("DM"); SqlDataAdapter da = new SqlDataAdapter("[CORRECT].[KC_EXPORTADOR]", con.condm); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.Add("@FINI", SqlDbType.DateTime); da.SelectCommand.Parameters.Add("@FFIN", SqlDbType.DateTime); //Calcular inicio de Mes los primeros 5 dias toma tambien los ultimos 5 dias del mes anterior int diaini = 0; if (DateTime.Today.Day <= 5) { diaini = (DateTime.Today.Day + 5) * -1; } else { diaini = (DateTime.Today.Day - 1) * -1; } da.SelectCommand.Parameters["@FINI"].Value = Convert.ToDateTime(DateTime.Today.AddDays(diaini)); da.SelectCommand.Parameters["@FFIN"].Value = Convert.ToDateTime(DateTime.Today); dt.Clear(); da.Fill(dt); con.Desconectar("DM"); } catch (Exception ex) { // MessageBox.Show("No se Pudo conectar a la BD Error: " + ex.Message); } StringBuilder csvMemoria = new StringBuilder(); for (int m = 0; m < dt.Rows.Count; m++) { int x = dt.Rows.Count; for (int n = 0; n < dt.Columns.Count; n++) { //si es la última columna no poner el | if (n == dt.Columns.Count - 1) { csvMemoria.Append(String.Format("{0}", dt.Rows[m].ItemArray[n].ToString().Trim())); } else { if (dt.Rows[m].ItemArray[n].GetType() == Type.GetType("System.DateTime")) { csvMemoria.Append(String.Format("{0}|", dt.Rows[m].ItemArray[n].ToString().Substring(0, 10))); } else { if (dt.Rows[m].ItemArray[n].GetType() == Type.GetType("System.Decimal")) { if (dt.Columns[n].Caption.Equals("LONGITUD") || dt.Columns[n].Caption.Equals("LATITUD")) { csvMemoria.Append(String.Format("{0}|", dt.Rows[m].ItemArray[n].ToString().Trim())); } else { csvMemoria.Append(String.Format("{0}|", Math.Round(Convert.ToDecimal(dt.Rows[m].ItemArray[n]), 3).ToString())); } } else { csvMemoria.Append(String.Format("{0}|", dt.Rows[m].ItemArray[n].ToString().Trim())); } } } } csvMemoria.AppendLine(); } //Fecha en formato ddmmyyyy string NArchivo; NArchivo = DateTime.Today.Day.ToString().PadLeft(2, '0') + DateTime.Today.Month.ToString().PadLeft(2, '0') + DateTime.Today.Year.ToString(); string NomredelTXT; NomredelTXT = NArchivo + ".txt"; System.IO.StreamWriter sw = new System.IO.StreamWriter(@"C:\CORRECT\DatosKC" + NomredelTXT, false, System.Text.Encoding.Default); sw.Write(csvMemoria.ToString()); sw.Close(); //CARGAR AL FTP /* Create Object Instance */ ftp ftpClient = new ftp(@"ftp://dt.kcmkt.com/", "*****@*****.**", "Clave1"); /* Upload a File */ ftpClient.upload("/DatosKC" + NomredelTXT, @"C:\CORRECT\DatosKC" + NomredelTXT); }
// Evento Carga Grid por primera vez private void Form13_Load(object sender, EventArgs e) { MenuItem ANULAR = new MenuItem("ANULAR", new System.EventHandler(this.ANULAR)); MenuItem ELIMINAR = new MenuItem("ELIMINAR", new System.EventHandler(this.ELIMINAR)); menugrid.MenuItems.AddRange(new MenuItem[] { ANULAR }); menugrid1.MenuItems.AddRange(new MenuItem[] { ELIMINAR }); Usuario = Login.usuario.ToUpper(); if (Main_Menu.Departamento == "INFORMATICA") { actualizarNombresVenedoresToolStripMenuItem.Enabled = true; } else { actualizarNombresVenedoresToolStripMenuItem.Enabled = false; } label10.Hide(); ID = 0; label9.Show(); con.conectar("EX"); if (modo == 2 || modo == 1 || modo == 0) { fecha_actual = DateTime.Now.ToString("yyyy/MM/dd"); this.toolStripButton2.Enabled = false; this.textBox1.Enabled = false; dateTimePicker1.Format = DateTimePickerFormat.Custom; dateTimePicker1.CustomFormat = "dd-MM-yyyy"; dateTimePicker2.Format = DateTimePickerFormat.Custom; dateTimePicker2.CustomFormat = "dd-MM-yyyy"; this.comboBox2.Text = "REGALIA"; dt.Clear(); dt.Columns.Clear(); dataGridView1.RowHeadersVisible = false; dataGridView1.AutoResizeColumns(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.ReadOnly = true; dataGridView1.AllowUserToAddRows = false; dataGridView1.Refresh(); Usuario = Login.usuario.ToUpper(); comboBox1.Text = Main_Menu.Agencia; textBox1.Text = Usuario; //SqlCommand cmd = new SqlCommand("SELECT NUM_DOC,RUTA,NOMBRE_VENDEDOR,TIPO,CUENTA,CONCEPTO,CANTIDAD,AGENCIA,FECHA FROM [DM].[CORRECT].[ENC_REGALIA] WHERE USUARIO = '" + Usuario + "' AND (DATEADD(dd, 0, DATEDIFF(dd, 0, FECHA)) >= '" + this.dateTimePicker1.Value.ToString("yyyy-MM-dd") + "') AND (DATEADD(dd, 0, DATEDIFF(dd, 0, FECHA)) <= '" + this.dateTimePicker2.Value.ToString("yyyy-MM-dd") + "') ", con.condm); SqlCommand cmd = new SqlCommand("SELECT A.[APLICACION] as 'TRANSACCION',B.Bodega as 'BODEGA',A.[REFERENCIA] as 'DOCUMENTO',A.[Usuario] as 'USUARIO',A.[FECHA_HORA] ,A.[AUDIT_TRANS_INV] as 'TRANSACCION ID' ,SUM(B.Cantidad) as 'CANTIDAD' FROM [EXACTUS].[dismo].[AUDIT_TRANS_INV]A INNER JOIN [EXACTUS].[dismo].[SoftlandBI_CI_Movimientos] B ON A.APLICACION = B.Documento where A.APLICACION like 'REG%' AND A.REFERENCIA not like '%[a-z]%' AND B.Bodega ='B013' and A.USUARIO = '" + Usuario.ToUpper() + "' and (DATEADD(dd, 0, DATEDIFF(dd, 0, FECHA_HORA)) >= '" + this.dateTimePicker1.Value.ToString("yyyy-MM-dd") + "') AND (DATEADD(dd, 0, DATEDIFF(dd, 0, FECHA_HORA)) <= '" + this.dateTimePicker2.Value.ToString("yyyy-MM-dd") + "') and A.APLICACION not in (SELECT [TRANSACCION] FROM [DM].[CORRECT].[REGALIAS]) Group by A.[AUDIT_TRANS_INV] ,A.[CONSECUTIVO] ,A.[Usuario] ,A.[FECHA_HORA] ,A.[APLICACION] ,A.[REFERENCIA],B.Bodega", con.conex); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); dataGridView1.DataSource = dt; dataGridView1.Refresh(); int linea = dataGridView1.Rows.Count; double suma = 0; foreach (DataGridViewRow row in dataGridView1.Rows) { suma += Convert.ToDouble(row.Cells["CANTIDAD"].Value); } this.label7.Text = Convert.ToString(suma); this.label8.Text = Convert.ToString(linea); } else if (modo == 3) { fecha_actual = DateTime.Now.ToString("yyyy/MM/dd"); this.toolStripButton2.Enabled = false; this.textBox1.Enabled = false; dateTimePicker1.Format = DateTimePickerFormat.Custom; dateTimePicker1.CustomFormat = "dd-MM-yyyy"; dateTimePicker2.Format = DateTimePickerFormat.Custom; dateTimePicker2.CustomFormat = "dd-MM-yyyy"; this.comboBox2.Text = "VENCIDOS"; dt.Clear(); dataGridView1.RowHeadersVisible = false; dataGridView1.AutoResizeColumns(); dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; dataGridView1.ReadOnly = true; dataGridView1.AllowUserToAddRows = false; dataGridView1.Refresh(); comboBox1.Text = Main_Menu.Agencia; SqlCommand cmd = new SqlCommand("SELECT [NUM_DOC],[USUARIO],[RUTA],[NOMBRE_VENDEDOR],[AGENCIA],[CANTIDAD],[FECHA_DOC] FROM [DM].[CORRECT].[ENC_VENCIDO] WHERE USUARIO = '" + Usuario + "' AND (DATEADD(dd, 0, DATEDIFF(dd, 0, FECHA_DOC)) >= '" + this.dateTimePicker1.Value.ToString("yyyy-MM-dd") + "') AND (DATEADD(dd, 0, DATEDIFF(dd, 0, FECHA_DOC)) <= '" + this.dateTimePicker2.Value.ToString("yyyy-MM-dd") + "') ", con.condm); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); dataGridView1.DataSource = dt; dataGridView1.Refresh(); int linea = dataGridView1.Rows.Count; decimal suma = 0; foreach (DataGridViewRow row in dataGridView1.Rows) { suma += Convert.ToDecimal(row.Cells["CANTIDAD"].Value); } this.label7.Text = Convert.ToString(suma); this.label8.Text = Convert.ToString(linea); SqlCommand cm2 = new SqlCommand("SELECT [USUARIO]FROM [DM].[CORRECT].[USUARIOS] where DEPARTAMENTO = 'OPERACIONES'", con.condm); SqlDataReader dr2 = cm2.ExecuteReader(); while (dr2.Read()) { toolStripComboBox1.Items.Add(dr2["USUARIO"]); } dr2.Close(); } else { 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; } }
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 button3_Click(object sender, EventArgs e) { operador = 0; string fecha = DateTime.Now.ToString("yyyy-MM-dd"); Registros = dt.Rows.Count; if (Registros > 0) { foreach (DataRow row in dt.Rows) { if (Usuario != row["SUPERVISOR"].ToString()) { EstadoError = 1; break; } else { EstadoError = 0; break; } } if (EstadoError == 1) { MessageBox.Show("NO PUEDES INGRESAR RUTA DE OTRO SUPERVISOR SELECIONADO"); } else { // Elimar_Ruta(); // Reindex(); // Ultimo_ID(); for (int i = 0; i < dt.Rows.Count; i++) { DataRow row = dt.Rows[i]; RUTA = Convert.ToString(row["VENDEDOR"]); DIA = Convert.ToString(row["DIA_VISITA"]); SUPERVISOR = Convert.ToString(row["SUPERVISOR"]); ORDEN = Convert.ToInt32(row["ORDEN"]); if (i == 0 && DIA != "CUSTOM") { operador = 1; } else { operador = 0; } CODIGO = Convert.ToString(row["CLIENTE"]); int digitos = CODIGO.Length; switch (digitos) { case 1: CODIGO = "0000" + CODIGO; break; case 2: CODIGO = "000" + CODIGO; break; case 3: CODIGO = "00" + CODIGO; break; case 4: CODIGO = "0" + CODIGO; break; } if (Exite_cliente(CODIGO, SUPERVISOR) && Main_Menu.Multi_cliente_app != "S") { MessageBoxButtons bt1 = MessageBoxButtons.YesNo; DialogResult result = MessageBox.Show("CLIENTE " + CODIGO + " YA EXISTE EN OTRA RUTA NO SE AGREGARA A RUTA \n ¿DESEA FINALIZAR LA IMPORTACION?", "CARGA CLIENTES DISMOAPP", bt1, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1); if (result == DialogResult.Yes) { break; } } else { datos_clie(CODIGO); } if (DBNull.Value == (row["CLIENTE"])) { } else if (DBNull.Value == (row["VENDEDOR"])) { } else if (DBNull.Value == (row["DIA_VISITA"])) { } else if (DBNull.Value == (row["SUPERVISOR"])) { } else { try { con.conectar("WEB"); ID = ID + 1; MySqlCommand cmd = new MySqlCommand(); cmd.Connection = con.mysqlconec; //cmd.CommandText = "INSERT INTO dismodb.dmRutero (ruta,codcli,dia,orden,updateby,fechaupdate,equipo) VALUES (@ruta,@codcli,@dia,@orden,@updateby,@fechaupdate,@equipo)"; //cmd.CommandText = "CALL UPDATE_CLIENTESYRUTERO (@porden, @pdia, @pcliente,@pnombre,@palias,@pdireccion, @ptel , @pcel , @pruta ,@pvendedor,@pentrega , @pcobrador ,@ptipodoc,@pdui,@pnit , @pregistro,@pgiro,@pcondicion,@plimite,@platitud, @plongitud,@pusuario , @pupdateby , @operador);"; cmd.CommandText = "SET SQL_SAFE_UPDATES=0; CALL UPDATE_CLIENTESYRUTERO('" + ORDEN + "','" + DIA + "','" + CODIGO + "','" + NOMBRE + "','" + ALIAS + "','" + DIRECCION + "','" + TELEFONO + "','" + CELULAR + "','" + RUTA + "','" + VENDEDOR + "','" + ENTREGA + "','" + COBRADOR + "','" + DOCUMENTO + "','" + DUI + "','" + NIT + "','" + REGISTRO + "','" + RUBRO + "','" + CONDICION_PAGO + "','" + LIMITE_CREDITO + "','" + LATITUD + "','" + LONGITUD + "','" + Usuario + "','" + Login.usuario.ToUpper() + "','" + operador + "')"; cmd.ExecuteNonQuery(); con.Desconectar("WEB"); row.Delete(); dataGridView1.DataSource = dt; dataGridView1.Refresh(); } catch { MessageBox.Show("ERROR NO SE ENGRESARON REGISTROS"); } } } // Reindex(); MessageBox.Show("CARGA DE CLIENTES EXITOSA"); button3.Enabled = false; } } }