Hospital/web/Module/jp_druginfo/ShowDrugInfo.aspx.cs

using System;
using System.Collections;
using System.Configuration;
using System.Data;
//using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
//using System.Xml.Linq;
using System.Text;

namespace Com.Jpsoft.Hospital.Web.Module.jp_druginfo
{
    public partial class ShowDrugInfo : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                //string id = string.Empty;
                //if (QUtility.FetchQueryString("treeid", out id))
                //{
                //    InitTree(SecendMenu.Nodes, id);
                //}
                SetDDL();
                InitTree(SecendMenu.Nodes, "0");
                BindData();
            }

        }

        protected void ddldrugtype_SelectedIndexChanged(object sender, EventArgs e)
        {
            //if (ddldrugtype.SelectedValue != "0")
            //{
            //SecendMenu.Nodes.Clear();
            //    InitTree(SecendMenu.Nodes, ddldrugtype.SelectedValue);
            //}
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            string drugname = txtdrugname.Text.Trim();// GetSafeSql(txtdrugname.Value.Trim());
            string py = txtpy.Text.Trim();


            StringBuilder strWhere = new StringBuilder();
            strWhere.Append(" where 1=1 ");

            if (drugname.Length != 0)
            {
                strWhere.Append(" and drugname like '%" + drugname + "%'");
            }
            if (ddldrugtype.SelectedValue != "0")
            {
                strWhere.Append(" and fatherid = '" + ddldrugtype.SelectedValue + "'");
            }
            if (py.Length != 0)
            {
                strWhere.Append(" and py like '%" + py + "%'");
            }
            ViewState["SearchTerms"] = strWhere.ToString();
            BindData();
        }

        protected void AspNetPager1_PageChanged(object sender, EventArgs e)
        {
            BindData();
        }

        #region
        /// <summary>
        /// 产品分类菜单
        /// </summary>
        /// <param name="Nds">节点id</param>
        /// <param name="parentId">父id</param>
        protected void InitTree(TreeNodeCollection Nds, string parentId)//用递归方法动态生成节点
        {
            Com.Jpsoft.Hospital.BLL.jp_drugtype bll = new Com.Jpsoft.Hospital.BLL.jp_drugtype();
            DataSet ds = bll.GetList(" 1=1 and fatherid='" + parentId + "' order by listid asc,id desc");
            DataView dv = new DataView();
            TreeNode tmpNode;
            dv.Table = ds.Tables[0];
            dv.RowFilter = " fatherid=" + "'" + parentId + "'";
            foreach (DataRowView drv in dv)
            {
                tmpNode = new TreeNode();
                tmpNode.Value = drv["id"].ToString();
                tmpNode.Text = drv["typename"].ToString();
                if (drv["fatherid"].ToString() != "0")
                {
                    tmpNode.NavigateUrl = "ShowDrugInfo.aspx?id=" + drv["id"].ToString();//设置超链接
                }
                //tmpNode.ImageUrl = "images/defalt/cyj_09.jpg";
                //tmpNode.NavigateUrl = "Default.aspx";//设置超链接
                //if (drv["fatherId"].ToString() == "0")
                //{
                //    tmpNode.SelectAction = TreeNodeSelectAction.None;//禁用超链接属性
                //}
                //tmpNode.Target = "iframeCenter";框架控制
                tmpNode.ExpandAll();//展开所有子节点
                Nds.Add(tmpNode);
                this.InitTree(tmpNode.ChildNodes, tmpNode.Value);
            }
        }

        /// <summary>
        /// 绑定父类别
        /// </summary>
        private void SetDDL()
        {
            Jpsoft.Hospital.BLL.jp_drugtype bll = new Com.Jpsoft.Hospital.BLL.jp_drugtype();
            DataTable dt = bll.GetList(" fatherid=0 ").Tables[0];
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ddldrugtype.Items.Add(new ListItem(dt.Rows[i]["typename"].ToString(), dt.Rows[i]["id"].ToString()));
            }
            ddldrugtype.Items.Insert(0, new ListItem("--请选择一级类别--", "0"));
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        private void BindData()
        {
            int RecordCount = 0;
            string strWhere = " where 1=1 ";
            if (ViewState["SearchTerms"] != null)
            {
                strWhere = ViewState["SearchTerms"].ToString();
            }
            if (Request.Params["id"] != null)
            {
                string id = Request.Params["id"];
                strWhere = strWhere + " and drugtype='" + id + "'";
            }
            string strOrder = " order by id DESC";
            using (IDataReader idr = Com.Jpsoft.Hospital.DAL.jp_druginfoEx.SelectPageEx(AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, strWhere, strOrder))
            {
                if (idr.Read())
                {
                    RecordCount = Convert.ToInt32(idr["RecordCount"]);
                }
                idr.NextResult();

                this.Repeater1.DataSource = idr;
                this.Repeater1.DataBind();
            }
            this.AspNetPager1.RecordCount = RecordCount;
        }

        #endregion




    }
}