private void frmComentarios_Load(object sender, EventArgs e) { this.Icon = ClasesSGUV.Propiedades.IconHalcoNET; try { DataTable tbl = connection.GetDataTable("LOG", "su_Almacen", new string[] { }, new string[] { "@TipoConsulta", "@ItemCode" }, ref valuesOut, 31, txtItemCode.Text); dataGridView1.DataSource = tbl; dataGridView1.DefaultCellStyle.WrapMode = DataGridViewTriState.True; DataTable tblR = connection.GetDataTable("SGUV", "PJ_IdealLinea", new string[] { }, new string[] { "@TipoConsulta" }, ref valuesOut, 8); comboBox1.DataSource = tblR; comboBox1.DisplayMember = "Name"; comboBox1.ValueMember = "Code"; } catch (Exception ex) { MessageBox.Show(ex.Message, "HalcoNET", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void frmSobreStock_Load(object sender, EventArgs e) { try { this.actualizarToolStripButton.Click -= new EventHandler(btnActualizar_Click); this.actualizarToolStripButton.Click += new EventHandler(btnActualizar_Click); ClasesSGUV.Form.ControlsForms.setDataSource(clbLinea, ClasesSGUV.DataSource.GetSource((int)ClasesSGUV.DataSource.TipoQry.LineasTodas, string.Empty, string.Empty), "ItmsGrpNam", "ItmsGrpCod", "--Todos--"); ClasesSGUV.Form.ControlsForms.setDataSource(clbAlmacen, ClasesSGUV.DataSource.GetSource((int)ClasesSGUV.DataSource.TipoQry.AlmacenesTodos, string.Empty, string.Empty), "WhsName", "WhsCode", "--Todos--"); clbLinea.Click -= new EventHandler(ClasesSGUV.Form.ControlsForms.clbBox_Click); clbLinea.Click += new EventHandler(ClasesSGUV.Form.ControlsForms.clbBox_Click); clbAlmacen.Click -= new EventHandler(ClasesSGUV.Form.ControlsForms.clbBox_Click); clbAlmacen.Click += new EventHandler(ClasesSGUV.Form.ControlsForms.clbBox_Click); cbLP.SelectedIndex = 1; DataTable tbl_Acciones = new DataTable(); tbl_Acciones = connection.GetDataTable("SGUV", "PJ_IdealLinea", new string[] { }, new string[] { "@TipoConsulta" }, ref valuesOut, 7); udpAcciones.SetDataBinding(tbl_Acciones, null); udpAcciones.ValueMember = "Name"; udpAcciones.DisplayMember = "Name"; } catch (Exception ex) { this.SetMensaje(ex.Message, 5000, Color.Red, Color.White); } }
private void frmDesabasto_Load(object sender, EventArgs e) { try { nuevoToolStripButton.Enabled = false; guardarToolStripButton.Enabled = false; dgvDatos.DataSource = null; dgvDetalle.DataSource = null; actualizarToolStripButton.Click -= new EventHandler(btnActualizar_Click); actualizarToolStripButton.Click += new EventHandler(btnActualizar_Click); DataTable tbl = connection.GetDataTable("LOG", "sp_Indicadores", new string[] { }, new string[] { "@TipoConsulta", "@Comprador" }, ref valuesOut, 2, string.Empty); dgvDatos.DataSource = tbl; this.dgvDatos.DisplayLayout.Override.RowSelectorHeaderStyle = Infragistics.Win.UltraWinGrid.RowSelectorHeaderStyle.ColumnChooserButton; } catch (Exception ex) { this.SetMensaje(ex.Message, 5000, Color.Red, Color.White); } }
private void btnExaminar_Click(object sender, EventArgs e) { OpenFileDialog dialof = new OpenFileDialog(); System.IO.Stream myStream = null; if (dialof.ShowDialog() == System.Windows.Forms.DialogResult.OK) { try { if ((myStream = dialof.OpenFile()) != null) { using (System.IO.StreamReader cargar = new System.IO.StreamReader(dialof.FileName)) { string renglon = string.Empty; int index = 0; while (!string.IsNullOrEmpty(renglon = cargar.ReadLine())) { if (index > 0) { string[] data = renglon.Split('\t'); Datos.Connection conn = new Datos.Connection(); int x = conn.Ejecutar("LOG", "su_Almacen", new string[] { }, new string[] { "@TipoConsulta", "@ItemCode", "@AlternativeItem" }, ref valuesOut, 25, data[0], data[2]); //System.Threading.Thread.Sleep(60); } index++; } } DataTable tbl = connection.GetDataTable("LOG", "su_Almacen", new string[] { }, new string[] { "@TipoConsulta" }, ref valuesOut, 26); dgvDatos.DataSource = tbl; } } catch (Exception ex) { this.SetMensaje(ex.Message, 5000, Color.Red, Color.White); } } }
private void GetClientes() { DataTable tbl = connection.GetDataTable("LOG", "up_Configuracion", new string[] { }, new string[] { "@TipoConsulta" }, ref valuesOut, 3); dgvClientes.DataSource = tbl; }
public frmTransaccionesFR(int DocEntry) { InitializeComponent(); try { Object[] valuesOut = new Object[] { }; DataTable tbl = connection.GetDataTable("LOG", "sp_SDKDocuments", new string[] { }, new string[] { "@TipoConsulta", "@DocEntry" }, ref valuesOut, 6, DocEntry); textBox1.Text = tbl.Rows[0]["DocNum"].ToString(); } catch (Exception ex) { this.SetMensaje(ex.Message, 5000, Color.Red, Color.White); } }
private void IdealxLinea_Load(object sender, EventArgs e) { this.Icon = ClasesSGUV.Propiedades.IconHalcoNET; log = new ClasesSGUV.Logs(ClasesSGUV.Login.NombreUsuario, this.AccessibleDescription, 0); this.CargarLinea(clbLinea, "Todas"); this.CargarProveedores(clbProveedor, "Todas"); this.CargarCompradores(clbComprador, "Todos"); DataTable tbl_almacenes = new DataTable(); tbl_almacenes = ClasesSGUV.DataSource.GetSource((int)ClasesSGUV.DataSource.Tipos.AlmacenesVenta); DataRow row = tbl_almacenes.NewRow(); row["WhsCode"] = "0"; row["WhsName"] = "Todos"; tbl_almacenes.Rows.InsertAt(row, 0); clbAlmacen.DataSource = tbl_almacenes; clbAlmacen.DisplayMember = "WhsName"; clbAlmacen.ValueMember = "WhsCode"; clbAlmacen.Click -= new EventHandler(ClasesSGUV.Forms.clb_Click); clbAlmacen.Click += new EventHandler(ClasesSGUV.Forms.clb_Click); cbLP.SelectedIndex = 1; cbClasificacion.SelectedIndex = 0; DataTable tbl_Acciones = new DataTable(); tbl_Acciones = connection.GetDataTable("SGUV", "PJ_IdealLinea", new string[] { }, new string[] { "@TipoConsulta" }, ref valuesOut, 7); udpAcciones.SetDataBinding(tbl_Acciones, null); udpAcciones.ValueMember = "Name"; udpAcciones.DisplayMember = "Name"; }
private void btnConsultar_Click(object sender, EventArgs e) { try { dgvDatos.DataSource = null; Object[] valuesOut = new Object[] { }; DataTable tbl = connection.GetDataTable("LOG", "sp_ListaPrecios", new string[] { }, new string[] { "@TipoConsulta", "@ItmsGrpCod" }, ref valuesOut, 9, cbLineas.SelectedValue); foreach (System.Data.DataColumn col in tbl.Columns) { col.ReadOnly = false; } dgvDatos.DataSource = tbl; } catch (Exception ex) { this.SetMensaje(ex.Message, 5000, Color.Red, Color.White); } }
private void btnConsultar_Click(object sender, EventArgs e) { try { dgvDatos.DataSource = null; string Almacenes = ClasesSGUV.Form.ControlsForms.getCadena(clbAlmacen, "'", false, "WhsCode"); DataTable tbl = connection.GetDataTable("LOG", "sp_Reportes", new string[] { }, new string[] { "@TipoConsulta", "@Almacenes", "@Desde", "@Hasta" }, ref valuesOut, 18, Almacenes, dtpDesde.Value, dtpHasta.Value); dgvDatos.DataSource = tbl; } catch (Exception ex) { this.SetMensaje(ex.Message, 5000, Color.Red, Color.White); } }
private void frmAlertasConfig_Load(object sender, EventArgs e) { ClasesSGUV.Form.ControlsForms.setDataSource(cbLinea, ClasesSGUV.DataSource.GetSource((int)ClasesSGUV.DataSource.TipoQry.Lineas, null, string.Empty), "ItmsGrpNam", "ItmsGrpCod", "--Línea--"); DataTable tbl_Articulos = ClasesSGUV.DataSource.GetSource((int)ClasesSGUV.DataSource.TipoQry.GetArticulos, string.Empty, string.Empty); ClasesSGUV.Form.ControlsForms.Autocomplete(txtArticulo, tbl_Articulos.Copy(), "ItemCode"); DataTable tbl = connection.GetDataTable("LOG", "sp_ListaPrecios", new string[] { }, new string[] { "@TipoConsulta" }, ref valuesOut, 14); dgvDatos.DataSource = tbl; tblCanal = new DataTable(); tblTipos = new DataTable(); tblCanal.Columns.Add("Codigo", typeof(Int32)); tblCanal.Columns.Add("Nombre", typeof(string)); DataRow r0 = tblCanal.NewRow(); r0[0] = 0; r0[1] = string.Empty; tblCanal.Rows.Add(r0); DataRow r1 = tblCanal.NewRow(); r1[0] = 60; r1[1] = "Transporte"; tblCanal.Rows.Add(r1); DataRow r2 = tblCanal.NewRow(); r2[0] = 61; r2[1] = "Mayoreo"; tblCanal.Rows.Add(r2); DataRow r3 = tblCanal.NewRow(); r3[0] = 62; r3[1] = "Armadores"; tblCanal.Rows.Add(r3); cbCanal.DataSource = tblCanal; cbCanal.DisplayMember = "Nombre"; cbCanal.ValueMember = "Codigo"; tblTipos.Columns.Add("Codigo", typeof(Int32)); tblTipos.Columns.Add("Nombre", typeof(string)); DataRow r_0 = tblTipos.NewRow(); r_0[0] = 0; r_0[1] = string.Empty; tblTipos.Rows.Add(r_0); DataRow r_1 = tblTipos.NewRow(); r_1[0] = 1; r_1[1] = "% Descuento"; tblTipos.Rows.Add(r_1); DataRow r_2 = tblTipos.NewRow(); r_2[0] = 2; r_2[1] = "Utilidad"; tblTipos.Rows.Add(r_2); DataRow r_3 = tblTipos.NewRow(); r_3[0] = 3; r_3[1] = "Precio Especial"; tblTipos.Rows.Add(r_3); //DataRow r_4 = tblTipos.NewRow(); //r_4[0] = 4; //r_4[1] = "Volumen"; //tblTipos.Rows.Add(r_4); cbEvaluar.DataSource = tblTipos; cbEvaluar.DisplayMember = "Nombre"; cbEvaluar.ValueMember = "Codigo"; nuevoToolStripButton.Click -= new EventHandler(btnNuevo_Click); nuevoToolStripButton.Click += new EventHandler(btnNuevo_Click); }
private void Consultar() { try { string itemcode = txtItemCode.Text; Object[] valuesOut = new Object[] { }; DataTable tbl = connection.GetDataTable("LOG", "su_Almacen", new string[] { }, new string[] { "@TipoConsulta", "@ItemCode" }, ref valuesOut, 22, itemcode); if (tbl.Rows.Count > 0) { this.CleanScreen(this, true); txtItemCode.Text = Convert.ToString(tbl.Rows[0]["ItemCode"]); txtItemName.Text = Convert.ToString(tbl.Rows[0]["ItemName"]); txtU_Subclas.Text = Convert.ToString(tbl.Rows[0]["U_Subclas"]); cbLinea.SelectedValue = Convert.ToInt32(tbl.Rows[0]["ItmsGrpCod"]); txtActive.Text = Convert.ToString(tbl.Rows[0]["Estado"]); txtCardName.Text = Convert.ToString(tbl.Rows[0]["CardName"]); txtNumInBuy.Text = Convert.ToDecimal(tbl.Rows[0]["NumInBuy"]).ToString("N2"); txtBuyUnitMsr.Text = Convert.ToString(tbl.Rows[0]["BuyUnitMsr"]); txtPurPackUn.Text = Convert.ToDecimal(tbl.Rows[0]["PurPackUn"]).ToString("N2"); txtBHeight1.Text = Convert.ToDecimal(tbl.Rows[0]["BHeight1"]).ToString("N2") + " cm"; txtBWidth1.Text = Convert.ToDecimal(tbl.Rows[0]["BWidth1"]).ToString("N2") + " cm"; txtBLength1.Text = Convert.ToDecimal(tbl.Rows[0]["BLength1"]).ToString("N2") + " cm"; txtBVolume.Text = Convert.ToDecimal(tbl.Rows[0]["BVolume"]).ToString("N2"); txtBWeight1.Text = Convert.ToDecimal(tbl.Rows[0]["BWeight1"]).ToString("N2") + " kg"; txtInvntryUom.Text = Convert.ToString(tbl.Rows[0]["InvntryUom"]); txtU_VLGX_PLN.Text = Convert.ToString(tbl.Rows[0]["U_VLGX_PLN"]); txtU_VLGX_LT.Text = Convert.ToString(tbl.Rows[0]["U_VLGX_LT"]); txtU_VLGX_OF.Text = Convert.ToString(tbl.Rows[0]["U_VLGX_OF"]); DataTable tblStock = connection.GetDataTable("LOG", "su_Almacen", new string[] { }, new string[] { "@TipoConsulta", "@ItemCode" }, ref valuesOut, 23, itemcode); dgvDatos.DataSource = tblStock; cbLinea.Enabled = false; } else { SDK.Documentos.frmListadoDocumentos formulario = new SDK.Documentos.frmListadoDocumentos(-4, txtItemCode.Text, txtItemName.Text, DateTime.Now, cbLinea.SelectedValue.ToString()); //formulario.MdiParent = this.MdiParent; formulario.ShowDialog(); txtItemCode.Text = formulario.ItemCode; if (!string.IsNullOrEmpty(txtItemCode.Text)) { SendKeys.Send("{ENTER}"); } } } catch (Exception ex) { this.SetMensaje(ex.Message, 5000, Color.Red, Color.White); } }