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;
}
}
}
