private void BindTreeChildNodes(TreeNode node) { DataTable dt = PurchaseRequireBus.GetProductType(Convert.ToInt32(node.Value)); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow Row in dt.Rows) { TreeNode nodes = new TreeNode(); nodes.Text = Row["TypeName"].ToString(); nodes.Value = Row["ID"].ToString(); nodes.NavigateUrl = string.Format("javascript:SelectedTypeChanged1('{0}','{1}');", nodes.Text, nodes.Value); node.ChildNodes.Add(nodes); BindTreeChildNodes(nodes); } } }
private void BindTreeChildNodes(TreeNode node) { DataTable dt = PurchaseRequireBus.GetProductType(Convert.ToInt32(node.Value)); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow Row in dt.Rows) { TreeNode nodes = new TreeNode(); nodes.Text = Row["TypeName"].ToString(); nodes.Value = Row["ID"].ToString(); node.ChildNodes.Add(nodes); BindTreeChildNodes(nodes); } } }
protected void btnImport_Click(object sender, ImageClickEventArgs e) { PurchaseRequireModel PurchaseRequireM = new PurchaseRequireModel(); PurchaseRequireM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; PurchaseRequireM.ProdTypeID = txtProductTypeID.Value; PurchaseRequireM.ProdID = txtProductID.Value; PurchaseRequireM.CreateCondition = ddlCreate.Value; PurchaseRequireM.RequireDate = txtStartRequireDate.Value; PurchaseRequireM.EndRequireDate = txtEndRequireDate.Value; string OrderBy = hidOrderBy.Value; DataTable dt = PurchaseRequireBus.GetPurchaseRequireInfo(PurchaseRequireM, OrderBy); OutputToExecl.ExportToTableFormat(this, dt, new string[] { "物料需求计划单编号", "物料编码", "物料名称", "物料分类", "规格", "单位", "订单需求量", "现有存量", "需申购数量", "采购提前期", "已计划数量", "需求日期" }, new string[] { "MRPNo", "ProdNo", "ProductName", "ProductTypeName", "Specification", "UnitName", "NeedCount", "HasNum", "WantingNum", "WaitingDays", "OrderCount", "RequireDate" }, "采购需求列表"); }