private void cbCategoria_SelectedIndexChanged(object sender, EventArgs e) { cbSubCategoria.SelectedItem = string.Empty; var categoriaWhere = "Producto_categoria_descripcion = '" + DataUtil.GetString(cbCategoria.SelectedItem) + "'"; DataUtil.FillComboBox(cbSubCategoria.Items, DataBaseQuerys.ProductoSubCategoriaActivos(false, DataUtil.FindSingleRow("producto_categoria", "Producto_categoria_id", categoriaWhere)), null); }
private void SubCategoriasCarouselDataBinding_Load(int categoriaID) { if (categoriaID != 0) { if (categoriaIdSelected != categoriaID) { tcAdicionales.Visible = false; tcProductos.Visible = false; categoriaIdSelected = categoriaID; rcSubCategorias.ItemDataBound += new ItemDataBoundEventHandler(rcSubCategorias_ItemDataBound); rcSubCategorias.NewCarouselItemCreating += new NewCarouselItemCreatingEventHandler(rcSubCategorias_NewCarouselItemCreating); // Create a generic list of Feature objects and bind it List <SubCategoriasFeatures> sub_products = new List <SubCategoriasFeatures>(); DataSet dsSubCategorias = DataUtil.FillDataSet(DataBaseQuerys.ProductoSubCategoriaActivos(true, categoriaID.ToString()), "producto_sub_categoria"); if (dsSubCategorias.Tables["producto_sub_categoria"].Rows.Count > 0) { foreach (DataRow subCategoriaRow in dsSubCategorias.Tables["producto_sub_categoria"].Rows) { string subCategoriaDesc = DataUtil.GetString(subCategoriaRow["Producto_sub_categoria_descripcion"]); if (subCategoriaDesc.Length > 12) { subCategoriaDesc = subCategoriaDesc.Remove(12); } int subCategoriaID = DataUtil.GetInt(subCategoriaRow["Producto_sub_categoria_id"]); sub_products.Add(new SubCategoriasFeatures(subCategoriaID, subCategoriaDesc)); } } rcSubCategorias.DataSource = sub_products; } } }
private void btnAddCategoria_Click(object sender, EventArgs e) { DialogResult result = MessageBox.Show("Desea agregar una nueva sub categoria?", "Sub Categoria", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { frmProductSubCategory frmProductSubCategoryAdd = new frmProductSubCategory(); frmProductSubCategoryAdd.adding = true; frmProductSubCategoryAdd.formTitle = "Producto Sub Categoria - Agregar"; frmProductSubCategoryAdd.ShowDialog(); string categoriaWhere = "Producto_categoria_descripcion = '" + DataUtil.GetString(cbCategoria.SelectedItem) + "'"; DataUtil.FillComboBox(cbSubCategoria.Items, DataBaseQuerys.ProductoSubCategoriaActivos(false, DataUtil.FindSingleRow("producto_categoria", "Producto_categoria_id", categoriaWhere)), null); } }
private void frmProductSearch_Load(object sender, EventArgs e) { btnAdd.Visible = DataBaseQuerys.GetAccess(13, AppConstant.EmployeeInfo.Codigo, AppConstant.AccessoTipos.Nuevo); btnModify.Visible = DataBaseQuerys.GetAccess(13, AppConstant.EmployeeInfo.Codigo, AppConstant.AccessoTipos.Edicion); DataUtil.FillComboBox(cbCategoria.Items, DataBaseQuerys.ProductoCategoriaActivos(false), string.Empty); DataUtil.FillComboBox(cbSubCategoria.Items, DataBaseQuerys.ProductoSubCategoriaActivos(false, string.Empty), string.Empty); lblNo.Text = @"0"; if (dsSearchProd != null) { cbCategoria.SelectedItem = string.Empty; cbSubCategoria.SelectedItem = string.Empty; cbTipo.SelectedItem = string.Empty; txtDescripcion.Text = descriptionSearch; dgwResult.DataSource = dsSearchProd; dgwResult.DataMember = "producto"; dgwResult.Columns[1].Width = 300; lblNo.Text = DataUtil.GetString(dsSearchProd.Tables[0].Rows.Count); if (tipoSearch != string.Empty) { cbTipo.SelectedItem = tipoSearch; cbTipo.Enabled = false; btnClean.Visible = false; } if (categoriaIdSearch != string.Empty) { string sWhere = "producto_categoria_id = " + categoriaIdSearch + ""; cbCategoria.SelectedItem = DataUtil.FindSingleRow("producto_categoria", "Producto_categoria_descripcion", sWhere); sWhere = "producto_sub_categoria_id = " + subCategoriaIdSearch + ""; cbSubCategoria.SelectedItem = DataUtil.FindSingleRow("producto_sub_categoria", "Producto_sub_categoria_descripcion", sWhere); cbCategoria.Enabled = false; cbSubCategoria.Enabled = false; btnClean.Visible = false; } } }
public void BindDataGrid() { lblNo.Text = "0"; if (stringBrowserSQL != string.Empty) { DataSet dsTable = DataUtil.FillDataSet(stringBrowserSQL, tableNameBrowser); dgwResult.DataSource = dsTable; dgwResult.DataMember = tableNameBrowser; dgwResult.Columns[0].Width = columnWidth0; dgwResult.Columns[1].Width = columnWidth1; dgwResult.Columns[2].Width = columnWidth2; dgwResult.Columns[3].Width = columnWidth3; dgwResult.Columns[4].Width = columnWidth4; dgwResult.Columns[5].Width = columnWidth5; dgwResult.Columns[6].Width = columnWidth6; if (dgwResult.Columns.Count > 7) { dgwResult.Columns[7].Width = columnWidth7; } if (dgwResult.Columns.Count > 8) { dgwResult.Columns[8].Width = columnWidth8; } lblNo.Text = DataUtil.GetString(dsTable.Tables[0].Rows.Count); if (searchVisible) { DataUtil.FillComboBox(cbField.Items, "SELECT * FROM configuracion_busqueda WHERE tabla = '" + tableNameBrowser + "' ORDER BY campo", string.Empty); } } if (categoriaVisible) { DataUtil.FillComboBox(cbCategoria.Items, DataBaseQuerys.ProductoCategoriaActivos(false), null); DataUtil.FillComboBox(cbSubCategoria.Items, DataBaseQuerys.ProductoSubCategoriaActivos(false, string.Empty), null); } }