Hospital/web/Module/Sys/Menu/List.aspx.cs

using System;
using System.Collections.Generic;
//using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
//
using System.Data;
using System.Text;
namespace Com.Jpsoft.Hospital.Web.Module.Sys.Menu
{
    public partial class List : Com.Jpsoft.Hospital.Web.Common.BasePage
    {
        Com.Jpsoft.Hospital.Model.jp_sys_menu model = new Com.Jpsoft.Hospital.Model.jp_sys_menu();
        Com.Jpsoft.Hospital.BLL.jp_sys_menu menu = new Com.Jpsoft.Hospital.BLL.jp_sys_menu();

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                int id = 0;
                int curpage = 1;
                string cmd = string.Empty;
                FetchQueryString("id", out id);
                FetchQueryString("curpage", out curpage);
                FetchQueryString("cmd", out cmd);
                AspNetPager1.RecordCount = curpage * AspNetPager1.PageSize;
                AspNetPager1.CurrentPageIndex = curpage;
                if (cmd == "del")
                {
                    Delete(id, curpage);
                }
                BindData();
            }
        }
        private void Delete(int id, int curpage)
        {
            try
            {
                //删除该条菜单 
                menu.Delete(id);
                //删除菜单的相关功能
                Com.Jpsoft.Hospital.BLL.jp_sys_menufun menufun = new Com.Jpsoft.Hospital.BLL.jp_sys_menufun();
                Com.Jpsoft.Hospital.Model.jp_sys_menufun menufunmodel = new Com.Jpsoft.Hospital.Model.jp_sys_menufun();
                DataTable dt = menufun.GetList(" mf_menuid=" + id).Tables[0];
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        int menfun_id = int.Parse(dt.Rows[i]["mf_id"].ToString());
                        menufun.Delete(menfun_id);
                    }
                }
                Response.Write("<script>alert('删除成功！');window.navigate('List.aspx?curpage="+curpage+"');</script>");
            }
            catch (Exception ex)
            {
                Response.Write("<script>alert('删除失败！原因：" + ex.ToString() + "');</script>");
            }
        }
        protected void AspNetPager1_PageChanged(object sender, EventArgs e)
        {
            BindData();
        }
        /// <summary>
        /// 绑定数据
        /// </summary>
        private void BindData()
        {
            int recordcount = 0;
            string strwhere = " where 1=1 ";
            if (ViewState["SearchTerms"] != null)
            {
                strwhere = ViewState["SearchTerms"].ToString();
            }
            string order = " order by menu_id DESC ";
            using (IDataReader idr = Com.Jpsoft.Hospital.DAL.jp_sys_menuEx.SelectPage(AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, strwhere, order))
            {
                if (idr.Read())
                {
                    recordcount = int.Parse(idr["RecordCount"].ToString());    
                }
                idr.NextResult();
                AspNetPager1.RecordCount = recordcount;
                this.gv.DataSource = idr;
                this.gv.DataBind();
                idr.Close();
            }
                //bind select condition
            this.ddl.Items.Clear();
            DataTable dt = menu.GetList(" menu_upid=0 ").Tables[0];
            if (dt.Rows.Count > 0) 
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    this.ddl.Items.Add(new ListItem(dt.Rows[i]["menu_name"].ToString(), dt.Rows[i]["menu_id"].ToString()));
                }
                this.ddl.Items.Insert(0, new ListItem("==请选择父级菜单==", "0"));
            }
        }
        ///// <summary>
        ///// delete by yqh
        ///// </summary>
        ///// <param name="sender"></param>
        ///// <param name="e"></param>
        //protected void gv_RowDeleting(object sender, GridViewDeleteEventArgs e)
        //{
        //    int id = int.Parse(this.gv.DataKeys[e.RowIndex].Value.ToString());
        //    menu.Delete(id);
        //    Response.Write("<script>alert('删除成功！');</script>");
        //    BindData();
        //}
        ///// <summary>
        ///// bind by yqh
        ///// </summary>
        ///// <param name="sender"></param>
        ///// <param name="e"></param>
        //protected void gv_RowDataBound(object sender, GridViewRowEventArgs e)
        //{
        //    if (e.Row.RowType == DataControlRowType.DataRow)
        //    {
        //        if (e.Row.RowState == DataControlRowState.Alternate || e.Row.RowState == DataControlRowState.Normal)
        //        {
        //            ((LinkButton)e.Row.Cells[2].Controls[0]).Attributes.Add("onclick","return confirm('确定要删除吗？');");
        //        }
        //    }
        //}
        /// <summary>
        /// add by yqh
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnadd_Click(object sender, EventArgs e)
        {
            Response.Redirect("Insert.aspx");
        }
/// <summary>
/// select by yqh
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
        protected void btnselect_Click(object sender, EventArgs e)
        {
            StringBuilder strwhere = new StringBuilder();
            strwhere.Append(" where 1=1 ");
            int menu_upid = int.Parse(this.ddl.SelectedValue.ToString());
            if (menu_upid != 0)
            {
                strwhere.Append(" and menu_upid="+menu_upid);
            }
            if (this.rul.Text!="")
            {
                strwhere.Append(" and menu_url  like '%" + this.rul.Text + "%'");
            }
            ViewState["SearchTerms"] = strwhere.ToString();
            BindData();
        }
    }
}