gyhlw_dotnet/网站项目/VRS/Management/ZHC/Fault_List.aspx.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Telerik.Web.UI;

namespace VRS.Management.ZHC
{
    public partial class Fault_List : BaseListPage
    {
        DataService.BLL.zhc_fault_list bll = new DataService.BLL.zhc_fault_list();
        DataService.BLL.zhc_fault_dev bll_fault_dev = new DataService.BLL.zhc_fault_dev();
        DataService.BLL.admin_log log = new DataService.BLL.admin_log();
        DataService.BLL.zhc_menu_tree bll_menu_tree = new DataService.BLL.zhc_menu_tree();
        protected override void Page_Load(object sender, EventArgs e)
        {
            base.Page_Load(sender, e);
            if (!IsPostBack)
            {
                VerifyPermissions("10003");
                loadMenuTree();
                DataLoad();

            }
        }

        protected override void DataLoad()
        {
            #region old condtion
            /*
            StringBuilder query = new StringBuilder(" 1 = 1 ");
            if (!string.IsNullOrWhiteSpace(name.Text.Trim()))
            {
                query.AppendFormat(" AND name LIKE '%{0}%' ", name.Text.Trim());
            }
            if (!string.IsNullOrWhiteSpace(type.Text.Trim()))
            {
                query.AppendFormat(" AND type LIKE '%{0}%' ", type.Text.Trim());
            }
            if (!string.IsNullOrWhiteSpace(RadDropDownTree1.SelectedValue))
            {
                query.AppendFormat(" AND menu_tree_id = '{0}' ", RadDropDownTree1.SelectedValue);
            }
            var data = bll.GetModelList(query.ToString());
             */
            #endregion
            
            var menu_id = RadDropDownTree1.SelectedValue;
            var data = bll.GetListByMenuTree(name.Text.Trim(), type.Text.Trim(), menu_id);
            dataList.DataSource = data;
            dataList.Rebind();
            span_name.InnerHtml = "";
        }

        public void loadMenuTree()
        {
            var list = bll_menu_tree.GetList("id,parentId,name", "").Tables[0];
            for (int i = 0; i < list.Rows.Count; i++)
            {
                var obj = list.Rows[i]["parentId"];
                if (obj != DBNull.Value)
                {
                    if (string.IsNullOrEmpty(obj.ToString()))
                    {
                        list.Rows[i]["parentId"] = DBNull.Value;
                    }
                }
            }
            RadDropDownTree1.DataFieldID = "id";
            RadDropDownTree1.DataFieldParentID = "parentId";
            RadDropDownTree1.DataValueField = "id";
            RadDropDownTree1.DataTextField = "name";
            RadDropDownTree1.DataSource = list;
            RadDropDownTree1.DataBind();
        }



        protected override void GridList_PageIndexChanged(object sender, GridPageChangedEventArgs e)
        {
            DataLoad();
        }

        protected override void GridList_PageSizeChanged(object sender, GridPageSizeChangedEventArgs e)
        {
            DataLoad();
        }

        protected override void GridList_SortCommand(object sender, GridSortCommandEventArgs e)
        {
            DataLoad();
        }

        protected override void GrdList_DeleteCommand(object sender, GridCommandEventArgs e)
        {
            string Id = (e.Item as GridDataItem).OwnerTableView.DataKeyValues[e.Item.ItemIndex]["Id"].ToString();
            bll.Delete(Id);
            DataLoad();
        }

        protected override void AjaxManager_AjaxRequest(object sender, AjaxRequestEventArgs e)
        {

        }

        protected void btnSelect_Click(object sender, EventArgs e)
        {
            DataLoad();
            DataLoad_FaultDev();
        }




        protected void btnDelete_Click(object sender, EventArgs e)
        {
            var model = bll.GetModel(IdInput.Value);
            if (bll.Delete(IdInput.Value))
            {
                var list_id = IdInput.Value;
                bll_fault_dev.DeleteByFaultListId(list_id);
                log.write_log("删除故障列表成功。" + "名称：" + model.name + "，ID：" + IdInput.Value);
            }
            DataLoad();
        }

        #region 故障设备方法

        /// <summary>
        /// 绑定故障设备
        /// </summary>
        public void DataLoad_FaultDev()
        {
            var list_id = hd_listid.Value;
            if (!string.IsNullOrEmpty(list_id))
            {
                var list = bll_fault_dev.GetModelList(string.Format("  list_id='{0}' ", list_id));
                grid_fault_dev.DataSource = list;
                grid_fault_dev.Rebind();
            }
            else
            {
                var list = bll_fault_dev.GetModelList(string.Format("  list_id='{0}' ", list_id));
                grid_fault_dev.DataSource = list;
                grid_fault_dev.Rebind();
            }
        }

        protected void btnSelectDevice_Click(object sender, EventArgs e)
        {
            DataLoad();
            DataLoad_FaultDev();
            
        }

        protected void fault_dev_PageIndexChanged(object sender, GridPageChangedEventArgs e)
        {
            DataLoad_FaultDev();
        }

        protected void fault_dev_PageSizeChanged(object sender, GridPageSizeChangedEventArgs e)
        {
            DataLoad_FaultDev();
        }

        protected void fault_dev_SortCommand(object sender, GridSortCommandEventArgs e)
        {
            DataLoad_FaultDev();
        }

        //删除设备并绑定
        protected void btnDelete_dev_Click(object sender, EventArgs e)
        {
            var dev_id = IdInput_dev.Value;
            var model = bll_fault_dev.GetModel(dev_id);
            if (bll_fault_dev.Delete(dev_id))
            {
                RadAjaxManager1.Alert("删除设备成功！");
                log.write_log("删除故障设备成功。" + "名称：" + model.eqName + "，ID：" + dev_id + "，故障列表ID：" + model.list_id);
            }
            DataLoad_FaultDev();
        }

        #endregion

        protected void dataList_DetailTableDataBind(object sender, GridDetailTableDataBindEventArgs e)
        {
            
            GridDataItem dataItem = (GridDataItem)e.DetailTableView.ParentItem;
            string list_id = dataItem.GetDataKeyValue("list_id").ToString();
            var data = bll_fault_dev.GetModelList(" list_id='"+ list_id + "' ");
            e.DetailTableView.DataSource = data;
        }

        protected void dataList_SelectedIndexChanged(object sender, EventArgs e)
        {
            var values = dataList.SelectedValues;
            hd_listid.Value = dataList.SelectedValue.ToString();
            DataLoad_FaultDev();
            span_name.InnerHtml = string.Format("{0}【{1}】", values["name"], values["full_name"]);
        }
    }
}