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