public IEnumerable <GroupTreeNode> GetProductLineTreeNode(GroupTreeNode factoryTreeNode) { IList <GroupTreeNode> result = new List <GroupTreeNode>(); Query query = new Query("ProductLine"); query.AddCriterion("CompanyID", "a", factoryTreeNode.CompanyID, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal); query.AddCriterion("FactoryID", "b", factoryTreeNode.FactoryID, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal); DataTable dt = dataFactory.Query(query); foreach (DataRow row in dt.Rows) { GroupTreeNode item = new GroupTreeNode(); item.ProductLineID = int.Parse(row["ID"].ToString().Trim()); item.CompanyID = int.Parse(row["CompanyID"].ToString().Trim()); item.FactoryID = int.Parse(row["FactoryID"].ToString().Trim()); item.Name = row["Name"].ToString().Trim(); item.Address = row["Address"].ToString().Trim(); item.CommissioningDate = row["CommissioningDate"].ToString(); item.Products = row["Products"].ToString().Trim(); item.children = null; result.Add(item); } return(result); }
public IEnumerable<GroupTreeNode> GetFactoryTreeNode(GroupTreeNode companyTreeNode) { IList<GroupTreeNode> result = new List<GroupTreeNode>(); Query query = new Query("Factory"); query.AddCriterion("CompanyID", companyTreeNode.CompanyID, SqlServerDataAdapter.Infrastruction.CriteriaOperator.Equal); DataTable dt = dataFactory.Query(query); foreach (DataRow row in dt.Rows) { GroupTreeNode item = new GroupTreeNode(); item.CompanyID = int.Parse(row["CompanyID"].ToString().Trim()); item.FactoryID = int.Parse(row["ID"].ToString().Trim()); item.Name = row["Name"].ToString().Trim(); item.Address = row["Address"].ToString().Trim(); item.CommissioningDate = row["CommissioningDate"].ToString(); item.Products = row["Products"].ToString().Trim(); result.Add(item); } return result; }
public IEnumerable<GroupTreeNode> GetCompanyTreeNode() { IList<GroupTreeNode> result = new List<GroupTreeNode>(); Query query = new Query("Company"); DataTable dt = dataFactory.Query(query); foreach (DataRow row in dt.Rows) { GroupTreeNode item = new GroupTreeNode(); if (row["ID"].ToString().Trim() != "") { item.CompanyID = int.Parse(row["ID"].ToString().Trim()); } item.Name = row["Name"].ToString().Trim(); item.Address = row["Address"].ToString().Trim(); item.CommissioningDate = row["CommissioningDate"].ToString(); item.Products = row["Products"].ToString().Trim(); result.Add(item); } return result; }
public IEnumerable <GroupTreeNode> GetCompanyTreeNode() { IList <GroupTreeNode> result = new List <GroupTreeNode>(); Query query = new Query("Company"); DataTable dt = dataFactory.Query(query); foreach (DataRow row in dt.Rows) { GroupTreeNode item = new GroupTreeNode(); if (row["ID"].ToString().Trim() != "") { item.CompanyID = int.Parse(row["ID"].ToString().Trim()); } item.Name = row["Name"].ToString().Trim(); item.Address = row["Address"].ToString().Trim(); item.CommissioningDate = row["CommissioningDate"].ToString(); item.Products = row["Products"].ToString().Trim(); result.Add(item); } return(result); }