public static Model.Categoria GetSubCategoria(string idCategoria, string idSubCategoria) { StdBELista objList; if (PriEngine.InitializeCompany(SINF.Properties.Settings.Default.Company.Trim(), SINF.Properties.Settings.Default.User.Trim(), SINF.Properties.Settings.Default.Password.Trim()) == true) { //objList = PriEngine.Engine.Comercial.Clientes.LstClientes(); objList = PriEngine.Engine.Consulta("SELECT SubFamilia, Descricao FROM SubFamilias WHERE SubFamilia = '" + idSubCategoria + "' AND Familia = '" + idCategoria + "'"); if (objList.NoFim()) { return null; } else { Model.Categoria categoria = new Model.Categoria { CodCategoria = objList.Valor("SubFamilia"), DescCategoria = objList.Valor("Descricao") }; return categoria; } } else return null; }
public static List<Model.Categoria> ListaCategorias() { StdBELista objList; List<Model.Categoria> listCategorias = new List<Model.Categoria>(); if (PriEngine.InitializeCompany(SINF.Properties.Settings.Default.Company.Trim(), SINF.Properties.Settings.Default.User.Trim(), SINF.Properties.Settings.Default.Password.Trim()) == true) { //objList = PriEngine.Engine.Comercial.Clientes.LstClientes(); objList = PriEngine.Engine.Consulta("SELECT Familia, Descricao FROM Familias"); while (!objList.NoFim()) { StdBELista objList2 = PriEngine.Engine.Consulta("SELECT SubFamilia, Descricao FROM SubFamilias WHERE Familia = '" + objList.Valor("Familia") + "'"); if (objList2.NoFim()) { listCategorias.Add(new Model.Categoria { CodCategoria = objList.Valor("Familia"), DescCategoria = objList.Valor("Descricao") }); } else { List<Model.Categoria> subs = new List<Model.Categoria>(); while (!objList2.NoFim()) { Model.Categoria categoria = new Model.Categoria { CodCategoria = objList2.Valor("SubFamilia"), DescCategoria = objList2.Valor("Descricao") }; subs.Add(categoria); objList2.Seguinte(); } listCategorias.Add(new Model.Categoria { CodCategoria = objList.Valor("Familia"), DescCategoria = objList.Valor("Descricao"), SubCategorias = subs }); } objList.Seguinte(); } return listCategorias; } else return null; }
public static Model.Categoria GetCategoria(string cod) { StdBELista objList; if (PriEngine.InitializeCompany(SINF.Properties.Settings.Default.Company.Trim(), SINF.Properties.Settings.Default.User.Trim(), SINF.Properties.Settings.Default.Password.Trim()) == true) { //objList = PriEngine.Engine.Comercial.Clientes.LstClientes(); objList = PriEngine.Engine.Consulta("SELECT Familia, Descricao FROM Familias WHERE Familia = '" + cod + "'"); if (!objList.NoFim()) { Model.Categoria categoria = new Model.Categoria { CodCategoria = objList.Valor("Familia"), DescCategoria = objList.Valor("Descricao") }; objList.Seguinte(); return categoria; } return null; } else return null; }