4.6笔记

一、TreePanel 绑定数据 public static SqlDatabase DB = DatabaseFactory.CreateDatabase("test") as SqlDatabase; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var cmd = DB.GetSqlStringCommand("select * from T_Menu"); var ds = DB.ExecuteDataSet(cmd); var treeNode = new TreeNode("机构管理") { Expanded = true }; //GenerateTreeView(treeNode, dataSet, checkBox, ""); GenerateTreeView(ds,treeNode); TreePanel1.Root.Clear(); TreePanel1.Root.Add(treeNode); } } protected void GenerateTreeView(DataSet ds, TreeNode treeNodeCollection) { ds.Relations.Add("NodeRelation",ds.Tables[0].Columns["MenuID"],ds.Tables[0].Columns["ParentMenuID"]);//父子表关联 foreach (DataRow dbRow in ds.Tables[0].Rows) { if (!dbRow.IsNull("ParentMenuID")) continue; var node = CreateNode(dbRow["MenuName"].ToString(),dbRow["MenuTarget"].ToString(), dbRow["MenuID"].ToString() ); treeNodeCollection.Nodes.Add(node); RecursivelyPopulate(dbRow, node); } } private static TreeNode CreateNode(string menuName, string target, string id) { var node = new Coolite.Ext.Web.TreeNode(menuName) { HrefTarget = target, Qtip = target, NodeID = id, Expanded = true }; return node; } private static void RecursivelyPopulate(DataRow dbRow, TreeNode node) { foreach (var childRow in dbRow.GetChildRows("NodeRelation")) { var childNode = CreateNode(childRow["MenuName"].ToString(), childRow["MenuTarget"].ToString(), childRow["MenuID"].ToString()); node.Nodes.Add(childNode); RecursivelyPopulate(childRow, childNode); } } 二、报价单的载人与导出为PDF格式 protected void Page_Load(object sender, EventArgs e) { string qvn = System.Web.HttpUtility.UrlDecode(Request.QueryString["qvn"]); string path = Server.MapPath(".") + "//Quotation.rpt"; qvn = "{Quotation.QuotationVN}='" + qvn + "'"; CRBind crBind=new CRBind(); crBind.ReportViewBind(CrystalReportViewer1,path,qvn); } protected void Button1_Click(object sender, EventArgs e) { string qvn = System.Web.HttpUtility.UrlDecode(Request.QueryString["qvn"]); string path = Server.MapPath(".") + "//Quotation.rpt"; String exportPath = Server.MapPath(".") + "//pdf//" + qvn + ".pdf"; qvn = "{Quotation.QuotationVN}='" + qvn + "'"; CRBind crBind = new CRBind(); crBind.ExportPdf(CrystalReportViewer1, path, qvn,exportPath); }