| | |
| | | try |
| | | { |
| | | sNode.Nodes.Clear(); |
| | | DataSet Ds = oCn.RunProcReturn("select hitemid,hnumber,hname from " + sBill + " where HStopflag=0 and HParentID=" + sNode.Name.Trim().Substring(1, sNode.Name.Trim().Length - 1) + " order by HNumber ", sBill); |
| | | DataSet Ds = oCn.RunProcReturn("select hitemid,hnumber,hname from " + sBill + " where HStopflag=0 and HParentID=" + sNode.Name.Trim().Substring(1, sNode.Name.Trim().Length - 1) + sDlgWhere + " order by HNumber ", sBill); |
| | | for (int i = 0; i < Ds.Tables[0].Rows.Count; i++) |
| | | { |
| | | TreeNode oNode = sNode.Nodes.Add("T" + Ds.Tables[0].Rows[i]["HItemID"].ToString(), Ds.Tables[0].Rows[i]["HNumber"].ToString() + spChar + Ds.Tables[0].Rows[i]["HName"].ToString(), 0, 1); |