public MDIParentPadre() { try { InitializeComponent(); } catch (Exception ex) { em.sendmail(ex, "Error: F-MDI-001"); } }
private void Ingresar_Click(object sender, EventArgs e) { try { MDIParentPadre.Usuario = textBox_Usuario.Text; MDIParentPadre.Password = textBox_Pass.Text; } catch (Exception ex) { em.sendmail(ex, "Error: F-LO1-001"); } }
private void cargoVendedores() { try { // Me conecto SqlCeConnection conexion = new SqlCeConnection(MDIParentPadre.st_conexion); DataSet sgdbDataSet = new DataSet(); string sql = "SELECT id_usuario, nombre, apellido FROM data_usuarios WHERE usertype='Vendedor' ORDER BY id_usuario DESC"; SqlCeDataAdapter da = new SqlCeDataAdapter(sql, conexion); da.Fill(sgdbDataSet, "data_usuarios"); int rowsCount = sgdbDataSet.Tables["data_usuarios"].Rows.Count; Dictionary <string, string> Items = new Dictionary <string, string>(); // Cargo el primer item vacio Items.Add("", ""); for (int i = 0; i < rowsCount; i++) { DataRow dRow = sgdbDataSet.Tables["data_usuarios"].Rows[i]; Items.Add(dRow.ItemArray.GetValue(0).ToString(), dRow.ItemArray.GetValue(1).ToString() + " " + dRow.ItemArray.GetValue(2).ToString()); } this.comboBox_C_Vendedor.DataSource = new BindingSource(Items, null); this.comboBox_C_Vendedor.DisplayMember = "Value"; this.comboBox_C_Vendedor.ValueMember = "Key"; // Get combobox selection (in handler) //string value = ((KeyValuePair<string, string>)this.comboBox_C_Vendedor.SelectedItem).Value; conexion.Close(); } catch (Exception ex) { em.sendmail(ex, "Error: F-CA0-003"); } }
public void cambio_pictureBox(string picPath) { try { if (picPath != "") { this.pictureBox_I_Imagen.Image = Image.FromFile(picPath); } } catch (Exception ex) { em.sendmail(ex, "Error: F-FA2-001"); } }
public static bool backupdata(string tipo) //datos o config { try { string[] AppArray = Application.ExecutablePath.Split('\\'); string ExeFile = AppArray[AppArray.Count() - 1]; DirectoryInfo backupdata = new DirectoryInfo(Environment.CurrentDirectory + @"\backupdata\"); string[] DateArray = DateTime.Now.ToShortDateString().Split('/'); string DateTimeHora = DateTime.Now.Hour.ToString(); string DateTimeMin = DateTime.Now.Minute.ToString(); string DateTimeSeg = DateTime.Now.Second.ToString(); string DateTimeNow = DateArray[2] + "-" + DateArray[1] + "-" + DateArray[0] + "-" + DateTimeHora + "-" + DateTimeMin + "-" + DateTimeSeg; if (!backupdata.Exists) { backupdata.Create(); // creo el directorio ARTICULOS } if (tipo == "datos") { //busco archivo y lo salvo sgdb.sdf File.Copy(Environment.CurrentDirectory + @"\sgdb.sdf", Environment.CurrentDirectory + @"\backupdata\" + DateTimeNow + @".sdf"); return(true); } else { if (tipo == "config") { //busco archivo y lo salvo App.config File.Copy(Environment.CurrentDirectory + @"\" + ExeFile + @".config", Environment.CurrentDirectory + @"\backupdata\" + DateTimeNow + @".config"); return(true); } else { return(false); } } } catch (Exception ex) { enviamail em = new enviamail(); // Porque el metodo es publico em.sendmail(ex, "Error: F-MDI-003"); return(false); } }
private void button_A_Guardar_Click(object sender, EventArgs e) { try { if (this.textBox_A_Nombre.Text == "" || this.textBox_A_Apellido.Text == "" || this.textBox_A_Usuario.Text == "" || this.textBox_A_Clave.Text == "" || this.textBox_A_Clave2.Text == "" || this.comboBox_A_Nivel.Text == "" || this.textBox_A_Telefono.Text == "" || this.textBox_A_Celular.Text == "") { MessageBox.Show("ATENCION: Debe conpletar todos los casilleros marcados con (*)", "Error: F-US1-002", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { if (this.textBox_A_Clave.Text == this.textBox_A_Clave2.Text) { SqlCeConnection conexion = new SqlCeConnection(MDIParentPadre.st_conexion); string sql = "INSERT INTO data_usuarios (nombre,apellido,login,password,usertype,tel_casa,tel_cel) VALUES ('" + this.textBox_A_Nombre.Text + "', '" + this.textBox_A_Apellido.Text + "', '" + this.textBox_A_Usuario.Text + "', '" + this.textBox_A_Clave.Text + "', '" + this.comboBox_A_Nivel.Text + "', '" + this.textBox_A_Telefono.Text + "', '" + this.textBox_A_Celular.Text + "')"; SqlCeCommand cmd = new SqlCeCommand(sql, conexion); cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); MessageBox.Show("El usuario se ingreso correctamente."); Limpiar_Formulario_Agregar(); } else { MessageBox.Show("ATENCION: La verificación de la clave es incorrecta", "Error: F-US1-003", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } } catch (Exception ex) { em.sendmail(ex, "Error: F-US1-004"); } }
private void PopUp_F_Vendedor_Load(object sender, EventArgs e) { try { // Me conecto SqlCeConnection conexion = new SqlCeConnection(MDIParentPadre.st_conexion); DataSet sgdbDataSet = new DataSet(); SqlCeCommand cmd = new SqlCeCommand(); string sql = "SELECT [id_usuario],[nombre],[apellido] FROM data_usuarios WHERE usertype LIKE '%Vendedor%' ORDER BY id_usuario DESC"; SqlCeDataAdapter da = new SqlCeDataAdapter(sql, conexion); da.Fill(sgdbDataSet, "data_usuarios"); BindingSource bindingSource = new BindingSource(sgdbDataSet.Tables[0], null); dataGridView1.AutoGenerateColumns = false; dataGridView1.Columns.Clear(); //Borro todas las columnas de dataGridView1 dataGridView1.Columns.Add("VendedorNumero", "Vendedor N°"); //(nombre de la columna,Titulo de la columna) dataGridView1.Columns.Add("Nombre", "Nombre"); dataGridView1.Columns.Add("Apellido", "Apellido"); //dataGridView1.Columns[0].Width = 110; // ancho de la columna //dataGridView1.Columns[1].Width = 300; dataGridView1.Columns[0].DataPropertyName = "id_usuario"; //son los campos de la base de datos dataGridView1.Columns[1].DataPropertyName = "nombre"; dataGridView1.Columns[2].DataPropertyName = "apellido"; dataGridView1.DataSource = bindingSource; //bindingNavigator1.BindingSource = bindingSource; conexion.Close(); } catch (Exception ex) { em.sendmail(ex, "Error: F-VE1-001"); } }
private void buscoUltimoID() { try { // Me conecto SqlCeConnection conexion = new SqlCeConnection(MDIParentPadre.st_conexion); DataSet sgdbDataSet = new DataSet(); SqlCeCommand cmd = new SqlCeCommand(); string sql = "SELECT id_cp FROM cliente_proveedor ORDER BY id_cp DESC"; SqlCeDataAdapter da = new SqlCeDataAdapter(sql, conexion); da.Fill(sgdbDataSet, "cliente_proveedor"); DataRow dRow = sgdbDataSet.Tables["cliente_proveedor"].Rows[0]; this.textBox_A_ID.Text = (Convert.ToInt32(dRow.ItemArray.GetValue(0)) + 1).ToString(); } catch (Exception ex) { em.sendmail(ex, "Error: F-CL1-000"); } }
//private DataGridViewCheckBoxColumn facturar; private void listoFacturas() { try { string buscarEn = ""; if (toolStripComboBox_buscarEn.SelectedItem.ToString() != "") { buscarEn = toolStripComboBox_buscarEn.SelectedItem.ToString(); } else { buscarEn = "Facturado A,B,C,T"; } string busco = toolStripTextBox_Buscar.Text; // Me conecto SqlCeConnection conexion = new SqlCeConnection(MDIParentPadre.st_conexion); DataSet sgdbDataSet = new DataSet(); if (this.toolStripTextBox_Buscar.Text != "") { string sql = ""; if (buscarEn == "Facturado A,B,C,T") { sql = "SELECT * FROM facturas WHERE (upper(f_numero) LIKE upper('%" + busco + "%') OR upper(f_fecha) LIKE upper('%" + busco + "%') OR upper(f_c_razon_social) LIKE upper('%" + busco + "%')) AND (upper(f_tipo) = upper('A') OR upper(f_tipo) = upper('B') OR upper(f_tipo) = upper('C') OR upper(f_tipo) = upper('Ticket'))"; } if (buscarEn == "Cuenta Corriente") { sql = "SELECT * FROM facturas WHERE (upper(f_numero) LIKE upper('%" + busco + "%') OR upper(f_fecha) LIKE upper('%" + busco + "%') OR upper(f_c_razon_social) LIKE upper('%" + busco + "%')) AND (upper(f_tipo) = upper('CC'))"; } if (buscarEn == "NC") { sql = "SELECT * FROM facturas WHERE (upper(f_numero) LIKE upper('%" + busco + "%') OR upper(f_fecha) LIKE upper('%" + busco + "%') OR upper(f_c_razon_social) LIKE upper('%" + busco + "%')) AND (upper(f_tipo) = upper('NC'))"; } if (buscarEn == "NP") { sql = "SELECT * FROM facturas WHERE (upper(f_numero) LIKE upper('%" + busco + "%') OR upper(f_fecha) LIKE upper('%" + busco + "%') OR upper(f_c_razon_social) LIKE upper('%" + busco + "%')) AND (upper(f_tipo) = upper('NC'))"; } if (buscarEn == "MovStock") { sql = "SELECT * FROM facturas WHERE (upper(f_numero) LIKE upper('%" + busco + "%') OR upper(f_fecha) LIKE upper('%" + busco + "%') OR upper(f_c_razon_social) LIKE upper('%" + busco + "%')) AND (upper(f_tipo) = upper('MovStock'))"; } if (buscarEn == "Remitos") { sql = "SELECT * FROM facturas WHERE (upper(f_numero) LIKE upper('%" + busco + "%') OR upper(f_fecha) LIKE upper('%" + busco + "%') OR upper(f_c_razon_social) LIKE upper('%" + busco + "%')) AND (upper(f_tipo) = upper('Remito'))"; } if (buscarEn == "Presupuesto") { sql = "SELECT * FROM facturas WHERE (upper(f_numero) LIKE upper('%" + busco + "%') OR upper(f_fecha) LIKE upper('%" + busco + "%') OR upper(f_c_razon_social) LIKE upper('%" + busco + "%')) AND (upper(f_tipo) = upper('Presupuesto'))"; } if (buscarEn == "Guardado") { sql = "SELECT * FROM facturas WHERE (upper(f_numero) LIKE upper('%" + busco + "%') OR upper(f_fecha) LIKE upper('%" + busco + "%') OR upper(f_c_razon_social) LIKE upper('%" + busco + "%')) AND (upper(f_tipo) = upper('Guardado'))"; } SqlCeDataAdapter da = new SqlCeDataAdapter(sql, conexion); da.Fill(sgdbDataSet, "facturas"); int rowsCount = sgdbDataSet.Tables["facturas"].Rows.Count; if (rowsCount > 0) { this.dataGridView.AutoGenerateColumns = false; // Sin esta linea me llena el datagrid con todo lo que tiene la tabla o las tablas this.dataGridView.Columns[1].DataPropertyName = "f_tipo"; this.dataGridView.Columns[2].DataPropertyName = "f_punto_venta"; this.dataGridView.Columns[3].DataPropertyName = "f_numero"; //son los campos de la base de datos this.dataGridView.Columns[4].DataPropertyName = "f_fecha"; this.dataGridView.Columns[5].DataPropertyName = "fi_total"; this.dataGridView.Columns[6].DataPropertyName = "f_c_codigo"; this.dataGridView.Columns[7].DataPropertyName = "f_c_razon_social"; this.dataGridView.Columns[8].DataPropertyName = "f_c_descuento"; /* * if (buscarEn == "Facturado A,B,C,T") * { * DataGridViewCheckBoxColumn facturar = new DataGridViewCheckBoxColumn(); * { * facturar.HeaderText = "Facturar"; * facturar.Name = "facturar"; * facturar.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.AllCells; * facturar.ReadOnly = true; * facturar.Width = 52; * facturar.CellTemplate = cbFacturar; * } * * this.dataGridView.Columns.Insert(9, facturar); * } * else * { * this.dataGridView.Columns.RemoveAt(9); * } * this.dataGridView.Columns[9].DataPropertyName = "f_status"; * * //dataGridView.Columns[9].CellTemplate = new DataGridViewCheckBoxCell(); * //dataGridView.Columns[9].CellTemplate.ReadOnly = false; * * * if (buscarEn == "Facturado A,B,C,T" || buscarEn == "Nota de Credito" || buscarEn == "Movimiento Stock") * { * this.dataGridView.Columns[9].Visible = false; * } * else * { * this.dataGridView.Columns[9].Visible = true; * this.dataGridView.Columns[9].DataPropertyName = "f_status"; * } */ BindingSource bS = new BindingSource(sgdbDataSet.Tables["facturas"], null); dataGridView.DataSource = bS; bindingNavigator1.BindingSource = bS; } } else { this.dataGridView.DataSource = null; //MessageBox.Show("Debe seleccionar un método de busqueda desde la lista desplegable.", "ATENCION", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } if (dataGridView.Rows.Count > 0) { this.toolStripButton_Eliminar.Enabled = true; } else { this.toolStripButton_Eliminar.Enabled = false; } } catch (Exception ex) { em.sendmail(ex, "Error: F-FA3-001"); } }
private void creoBotones() { try { /* * EJEMPLO DE COMO AGREGAR UN ELEMENTO * * this.button1 = new System.Windows.Forms.Button(); * this.SuspendLayout(); * // * // button1 * // * this.button1.BackColor = System.Drawing.Color.PaleTurquoise; * this.button1.Location = new System.Drawing.Point(12, 32); * this.button1.Name = "button1"; * this.button1.Size = new System.Drawing.Size(75, 75); * this.button1.TabIndex = 0; * this.button1.Text = "Caramelos $0.25"; * this.button1.UseVisualStyleBackColor = false; * * this.Controls.Add(this.button1); */ // Me conecto SqlCeConnection conexion = new SqlCeConnection(MDIParentPadre.st_conexion); DataSet ds = new DataSet(); string sql = "SELECT codigo_barra, codigo_interno, descripcion, unidad, precio_venta1 FROM articulos WHERE orden!='' ORDER BY orden"; SqlCeDataAdapter da = new SqlCeDataAdapter(sql, conexion); da.Fill(ds, "articulos"); int i; int c = 1; int cols = 80; int rows = 80; int cantidad = ds.Tables["articulos"].Rows.Count; MessageBox.Show(cantidad.ToString()); for (i = 0; i < cantidad && i < 30; i++) { if (c == 10) { cols = 80; rows = rows + 80; c = 1; } else { cols = c * 80; } DataRow dRow = ds.Tables["articulos"].Rows[i]; this.button1 = new System.Windows.Forms.Button(); this.SuspendLayout(); this.button1.BackColor = System.Drawing.Color.PaleTurquoise; this.button1.Location = new System.Drawing.Point((15 + cols), (15 + rows)); this.button1.Name = "button" + i; this.button1.Size = new System.Drawing.Size(75, 75); this.button1.TabIndex = 0; this.button1.Text = dRow.ItemArray.GetValue(2).ToString() + "\n\t(" + dRow.ItemArray.GetValue(3).ToString() + "x" + dRow.ItemArray.GetValue(4).ToString() + ")"; this.button1.UseVisualStyleBackColor = false; this.Controls.Add(this.button1); c++; } /* * if (dRow.ItemArray.GetValue(14).ToString() != "") * { * this.pictureBox_E_Imagen.Image = Image.FromFile(dRow.ItemArray.GetValue(14).ToString()); * } * else this.pictureBox_E_Imagen.Image = null; */ conexion.Close(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); em.sendmail(ex, "Error: F-FB1-001"); } }