gyhlw_dotnet/网站项目/VRS/Management/VSAT/Fault.aspx.cs

using System;
using System.Collections.Generic;
using System.IO;
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.VSAT
{
    public partial class Fault : BaseListPage
    {
        DataService.BLL.pro_fault bll = new DataService.BLL.pro_fault();
        DataService.BLL.admin_log log = new DataService.BLL.admin_log();
        DataService.BLL.zhc_task_proc_material bll_task_proc_material = new DataService.BLL.zhc_task_proc_material();
        DataService.BLL.admin_user bll_user= new DataService.BLL.admin_user();
        protected override void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindMajors(dpMajor, "");
                BindGrade(grade, "");

                DataLoad();
                DataLoad_Sub();
            }
        }

        protected override void DataLoad()
        {
            StringBuilder query = new StringBuilder(" 1 = 1 ");
            if (!string.IsNullOrWhiteSpace(name.Text.Trim()))
            {
                query.AppendFormat(" AND fault_name LIKE '%{0}%' ", name.Text.Trim());
            }
            var data = bll.GetList(query.ToString()).Tables[0];
            dataList.DataSource = data;
            dataList.Rebind();
        }

        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_Sub();
        }

        protected void btnDelete_Click(object sender, EventArgs e)
        {
            var model = bll.GetModel(IdInput.Value);
            if (bll.Delete(IdInput.Value))
            {
                log.write_log("删除故障成功。" + "故障名称：" + model.fault_name + "，步骤ID：" + IdInput.Value);
            }

            DataLoad();
        }

        #region 关联列表方法

        /// <summary>
        /// 绑定列表
        /// </summary>
        public void DataLoad_Sub()
        {
          
            var main_id = hd_mainId.Value;
            StringBuilder query = new StringBuilder(" 1 = 1 ");
            if (!string.IsNullOrWhiteSpace(main_id))
            {
                query.AppendFormat(" AND T1.fault_id='" + main_id + "' ");
            }
            else
            {
                query.AppendFormat(" AND T1.fault_id is not null ");
            }

            if (!string.IsNullOrWhiteSpace(login_name.Text.Trim()))
            {
                query.AppendFormat(" AND login_name LIKE '%{0}%' ", login_name.Text.Trim());
            }
            if (!string.IsNullOrWhiteSpace(real_name.Text.Trim()))
            {
                query.AppendFormat(" AND real_name LIKE '%{0}%' ", real_name.Text.Trim());
            }
         
            if (!string.IsNullOrWhiteSpace(dpMajor.SelectedValue))
            {
                query.AppendFormat(" AND major = '{0}' ", dpMajor.SelectedValue);
            }
            if (!string.IsNullOrWhiteSpace(grade.SelectedValue))
            {
                query.AppendFormat(" AND grade = '{0}' ", grade.SelectedValue);
            }

            var data = bll_user.GetUsrUsersWithFault(query.ToString());
            dataList_Sub.DataSource = data;
            dataList_Sub.Rebind();
        }

        protected void btnSelectSub_Click(object sender, EventArgs e)
        {
            DataLoad_Sub();
        }

        protected void dataList_Sub_PageIndexChanged(object sender, GridPageChangedEventArgs e)
        {
            DataLoad_Sub();
        }

        protected void dataList_Sub_PageSizeChanged(object sender, GridPageSizeChangedEventArgs e)
        {
            DataLoad_Sub();
        }

        protected void dataList_Sub_SortCommand(object sender, GridSortCommandEventArgs e)
        {
            DataLoad_Sub();
        }

        //删除记录并绑定
        protected void btnDelete_Sub_Click(object sender, EventArgs e)
        {

            var sub_id = hd_subId.Value;
            var user = bll_user.GetModel(sub_id);
          
            if (bll_user.Update(user))
            {
               
                RadAjaxManager1.Alert("删除学员故障点成功！");
                log.write_log("删除学员故障点成功。" + "学员名称：" + user.user_id + "，user_id：" + sub_id  );
            }
            DataLoad_Sub();
        }

      
        //删除所有记录并绑定
        protected void btnDelete_SubALL_Click(object sender, EventArgs e)
        {

            List<string> list = new List<string>();
            var users = bll_user.GetModelList(" fault_id is not null and fault_id!='' ");
            foreach (var obj in users)
            {
                list.Add("'" + obj.user_id + "'");
            }
            var success = bll_user.update_fault("", string.Join(",", list.ToArray()));
            if (success)
            {
                RadAjaxManager1.Alert("删除所有学员故障点成功！");
                log.write_log("删除所有学员故障点成功。" );
            }
            DataLoad_Sub();
        }
        #endregion


    }
}