using SchedulingSystemClient.EntityClass;
using SchedulingSystemClient.InsertWindow;
using SchedulingSystemClient.UpdateWindow;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Input;

namespace SchedulingSystemClient
{
    /// <summary>
    /// XTGLWindow.xaml 的交互逻辑
    /// </summary>
    public partial class XTGLWindow : UserControl
    {
        public XTGLWindow()
        {
            InitializeComponent();
        }
        SurgerySchedulingEntities myModel = new SurgerySchedulingEntities();

        string str = "人员管理";
        private void UserControl_Loaded(object sender, RoutedEventArgs e)
        {
            rygl.IsEnabled = false;
            jsgl.IsEnabled = true;
            ryglgrid.Visibility = Visibility.Visible;
            jsglgrid.Visibility = Visibility.Collapsed;
            czmm.Visibility = Visibility.Visible;
            bcjs.Visibility = Visibility.Collapsed;
            str = "人员管理";
            ShuaXin();
        }
        private void rygl_Click(object sender, RoutedEventArgs e)
        {
            rygl.IsEnabled = false;
            jsgl.IsEnabled = true;
            ryglgrid.Visibility = Visibility.Visible;
            jsglgrid.Visibility = Visibility.Collapsed;
            czmm.Visibility = Visibility.Visible;
            bcjs.Visibility = Visibility.Collapsed;
            str = "人员管理";
            ShuaXin();
        }

        private void jsgl_Click(object sender, RoutedEventArgs e)
        {
            rygl.IsEnabled = true;
            jsgl.IsEnabled = false;
            ryglgrid.Visibility = Visibility.Collapsed;
            jsglgrid.Visibility = Visibility.Visible;
            czmm.Visibility = Visibility.Collapsed;
            bcjs.Visibility = Visibility.Visible;
            str = "角色管理";
            ShuaXin();
        }

        private void czmm_Click(object sender, RoutedEventArgs e)
        {
            if (ryrow.ID == 0)
            {
                MessageBox.Show("请选择需要重置的人员");
                return;
            }
            SYS_YHB yh = new SYS_YHB();
            yh.ID = ryrow.ID;
            yh.GH = ryrow.GH;
            yh.YHM = ryrow.Name;
            yh.MM = "123";
            yh.JSID = ryrow.JSID;
            try
            {
                myModel.Entry(yh).State = System.Data.Entity.EntityState.Modified;
                myModel.SaveChanges();
                MessageBox.Show("重置成功");
                myModel.Entry(yh).State = System.Data.Entity.EntityState.Detached;
            }
            catch (Exception)
            {
                MessageBox.Show("重置失败");
            }
        }

        //private void scry_Click(object sender, RoutedEventArgs e)
        //{
        //    if (ryrow.ID == 0)
        //    {
        //        MessageBox.Show("请选择删除的内容");
        //        return;
        //    }
        //    MessageBoxResult dr = MessageBox.Show("确定要删除该人员吗？", "提示", MessageBoxButton.OKCancel, MessageBoxImage.Question);
        //    if (dr == MessageBoxResult.OK)
        //    {
        //        var ryb = (from tbryb in myModel.SYS_YHB
        //                   where tbryb.ID == ryrow.ID
        //                   select new
        //                   {
        //                       tbryb,
        //                   }).Single();
        //        try
        //        {
        //            myModel.SYS_YHB.Remove(ryb.tbryb);
        //            myModel.SaveChanges();
        //            MessageBox.Show("删除成功");
        //        }
        //        catch (Exception)
        //        {
        //            MessageBox.Show("删除失败");
        //        }
        //    }
        //}

        //private void xgry_Click(object sender, RoutedEventArgs e)
        //{
        //    if (ryrow.ID==0)
        //    {
        //        MessageBox.Show("请选择修改的内容");
        //        return;
        //    }

        //    XGRYWindow window = new XGRYWindow(ryrow);
        //    window.ShowDialog();
        //}
        //private void xzry_Click(object sender, RoutedEventArgs e)
        //{
        //    XZRYWindow window = new XZRYWindow();
        //    window.ShowDialog();
        //}
        //private void cxry_Click(object sender, RoutedEventArgs e)
        //{
        //    var listry = (from tbry in myModel.SYS_YHB
        //                  join tbjs in myModel.SYS_JSB on tbry.JSID equals tbjs.ID
        //                  select new Cus_User
        //                  {
        //                      ID = tbry.ID,
        //                      Name = tbry.Name,
        //                      GH = tbry.GH,
        //                      JSID = tbjs.ID,
        //                      strRole = tbjs.Role
        //                  }).ToList();
        //    rygldata.ItemsSource = listry;
        //}
        int qxid;
        /// <summary>
        /// 角色保存
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void bcjs_Click(object sender, RoutedEventArgs e)
        {
            int count = qxfpdata.Items.Count;
            SYS_QXB qxb = new SYS_QXB();
            qxb.ID = qxid;
            qxb.JSID = jsid;

            for (int i = 0; i < count; i++)
            {
                string str = (qxfpdata.Columns[1].GetCellContent(qxfpdata.Items[i]) as TextBlock).Text;
                DataGridTemplateColumn tempColumn = qxfpdata.Columns[2] as DataGridTemplateColumn;
                FrameworkElement element = qxfpdata.Columns[2].GetCellContent(qxfpdata.Items[i]);
                CheckBox ck = tempColumn.CellTemplate.FindName("box", element) as CheckBox;
                bool? IsChecked = ck.IsChecked;
                if (str == "首页" && IsChecked == true)
                {
                    qxb.Is_SY = true;
                }
                if (str == "排班记录" && IsChecked == true)
                {
                    qxb.Is_PBJL = true;
                }
                if (str == "排班申请" && IsChecked == true)
                {
                    qxb.Is_PBSQ = true;
                }
                if (str == "手术信息维护" && IsChecked == true)
                {
                    qxb.Is_JCXXWH = true;
                }
                if (str == "规则维护" && IsChecked == true)
                {
                    qxb.Is_GZWH = true;
                }
                if (str == "系统管理" && IsChecked == true)
                {
                    qxb.Is_XTGL = true;
                }
                if (str == "数据统计" && IsChecked == true)
                {
                    qxb.Is_SJTJ = true;
                }
                if (str == "排班日志" && IsChecked == true)
                {
                    qxb.Is_PBRZ = true;
                }
                if (str == "手动排班" && IsChecked == true)
                {
                    qxb.Is_SDPB = true;
                }
                if (str == "排班展示" && IsChecked == true)
                {
                    qxb.Is_PBZS = true;
                }
            }
            try
            {
                myModel.Entry(qxb).State = System.Data.Entity.EntityState.Modified;
                myModel.SaveChanges();
                MessageBox.Show("修改成功");
                myModel.Entry(qxb).State = System.Data.Entity.EntityState.Detached;
            }
            catch (Exception ex)
            {
                MessageBox.Show("修改失败" +ex.ToString());
            }

        }

        //private void scjs_Click(object sender, RoutedEventArgs e)
        //{
        //    if (jsid == 0)
        //    {
        //        MessageBox.Show("请选择需要删除的角色");
        //        return;
        //    }
        //    MessageBoxResult dr = MessageBox.Show("确定要删除该角色吗？", "提示", MessageBoxButton.OKCancel, MessageBoxImage.Question);
        //    if (dr == MessageBoxResult.OK)
        //    {
        //        var yhb = (from ybyh in myModel.SYS_YHB
        //                   where ybyh.JSID == jsid
        //                   select new
        //                   {
        //                       ybyh,
        //                   }).ToList();
        //        if (yhb.Count>0)
        //        {
        //            MessageBox.Show("该角色正在使用不能删除");
        //            return;
        //        }
        //        var jsb = (from tbjsb in myModel.SYS_JSB
        //                     where tbjsb.ID == jsid
        //                     select new
        //                     {
        //                         tbjsb,
        //                     }).Single();
        //        try
        //        {
        //            myModel.SYS_JSB.Remove(jsb.tbjsb);
        //            myModel.SaveChanges();
        //            MessageBox.Show("删除成功");
        //        }
        //        catch (Exception)
        //        {

        //            MessageBox.Show("删除失败");
        //        }


        //    }
        //}

        //private void xgjs_Click(object sender, RoutedEventArgs e)
        //{
        //    if (jsid==0)
        //    {
        //        MessageBox.Show("请选择角色");
        //        return;
        //    }
        //    XGJSWindow window = new XGJSWindow(row);
        //    window.ShowDialog();
        //}

        //private void xzjs_Click(object sender, RoutedEventArgs e)
        //{
        //    XZJSWindow window = new XZJSWindow();
        //    window.ShowDialog();
        //}

        //private void cxjs_Click(object sender, RoutedEventArgs e)
        //{
        //    var listjs = (from tbjs in myModel.SYS_JSB 
        //                  select new Cus_Role 
        //                  { 
        //                      ID =tbjs.ID, 
        //                      Role =tbjs.Role, 
        //                      SFKY =tbjs.SFKY, 
        //                      strSFKY =tbjs.SFKY == true? "可用":"不可用", 
        //                  }).ToList();
        //    qxfpdata.ItemsSource = null;
        //    jsgldata.ItemsSource = listjs;
        //    qxid = 0;
        //}

        private void qxfpdata_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {

        }
        int jsid;
        Cus_Role row = new Cus_Role();
        private void jsgldata_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            jsid = 0;
            Cus_Role selectedRow = jsgldata.SelectedItem as Cus_Role;

            if (selectedRow != null)
            {
                jsid = selectedRow.ID;
                row = selectedRow;
            }
        }
        int ryid;
        Cus_User ryrow = new Cus_User();
        private void rygldata_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            ryid = 0;
            Cus_User selectedRow = rygldata.SelectedItem as Cus_User;

            if (selectedRow != null)
            {
                ryid = selectedRow.ID;
                ryrow = selectedRow;
            }
        }
        private void jsgldata_MouseDoubleClick(object sender, MouseButtonEventArgs e)
        {
            if (row.ID!=0)
            {
                List<Cus_CDB> listcdb = (from tbcdb in myModel.SYS_CDB select new Cus_CDB { ID = tbcdb.ID ,Name = tbcdb.Name,IsChecked = false }).ToList();
                List<Cus_QXB> listqxb= (from tbqxb in myModel.SYS_QXB 
                                       where tbqxb.JSID == jsid 
                                        select new Cus_QXB
                                        {
                                            ID = tbqxb.ID,
                                            JSID= tbqxb.JSID,
                                            Is_SY= tbqxb.Is_SY,
                                            Is_PBJL= tbqxb.Is_PBJL,
                                            Is_PBSQ= tbqxb.Is_PBSQ,
                                            Is_JCXXWH= tbqxb.Is_JCXXWH,
                                            Is_GZWH= tbqxb.Is_GZWH,
                                            Is_XTGL= tbqxb.Is_XTGL,
                                            Is_PBRZ= tbqxb.Is_PBRZ,
                                            Is_SJTJ= tbqxb.Is_SJTJ,
                                            Is_SDPB= tbqxb.Is_SDPB,
                                            Is_PBZS = tbqxb.Is_PBZS,
                                        }).ToList();
                qxid = listqxb[0].ID;
                for (int i = 0; i < listcdb.Count; i++)
                {
                    if (listcdb[i].Name == "首页" && listqxb[0].Is_SY is true) { listcdb[i].IsChecked = true; }
                    if (listcdb[i].Name == "排班记录" && listqxb[0].Is_PBJL is true) { listcdb[i].IsChecked = true; }
                    if (listcdb[i].Name == "排班申请" && listqxb[0].Is_PBSQ is true) { listcdb[i].IsChecked = true; } 
                    if (listcdb[i].Name == "手术信息维护" && listqxb[0].Is_JCXXWH is true) { listcdb[i].IsChecked = true; } 
                    if (listcdb[i].Name == "规则维护" && listqxb[0].Is_GZWH is true) { listcdb[i].IsChecked = true; }
                    if (listcdb[i].Name == "系统管理" && listqxb[0].Is_XTGL is true) { listcdb[i].IsChecked = true; } 
                    if (listcdb[i].Name == "数据统计" && listqxb[0].Is_SJTJ is true) { listcdb[i].IsChecked = true; } 
                    if (listcdb[i].Name == "排班日志" && listqxb[0].Is_PBRZ is true) { listcdb[i].IsChecked = true; } 
                    if (listcdb[i].Name == "手动排班" && listqxb[0].Is_SDPB is true) { listcdb[i].IsChecked = true; } 
                    if (listcdb[i].Name == "排班展示" && listqxb[0].Is_PBZS is true) { listcdb[i].IsChecked = true; } 
                }
                qxfpdata.ItemsSource = listcdb;
            }
        }

        private void ShuaXin()
        {
            jsid = 0;
            ryrow = new Cus_User();
            if (str == "人员管理")
            {
                var listry = (from tbry in myModel.SYS_YHB
                              join tbjs in myModel.SYS_JSB on tbry.JSID equals tbjs.ID
                              select new Cus_User
                              {
                                  ID = tbry.ID,
                                  Name = tbry.YHM,
                                  GH = tbry.GH,
                                  JSID = tbjs.ID,
                                  strRole = tbjs.JSMC
                              }).ToList();
                rygldata.ItemsSource = listry;
            }
            if (str == "角色管理")
            {
                var listjs = (from tbjs in myModel.SYS_JSB
                              select new Cus_Role
                              {
                                  ID = tbjs.ID,
                                  Role = tbjs.JSMC,
                                  SFKY = tbjs.SFQY,
                                  strSFKY = tbjs.SFQY == true ? "可用" : "不可用",
                              }).ToList();
                qxfpdata.ItemsSource = null;
                jsgldata.ItemsSource = listjs;
                qxid = 0;
            }
        }


        /// <summary>
        /// 刷新
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_sx_Click(object sender, RoutedEventArgs e)
        {
            ShuaXin();
            //jsid = 0;
            //ryrow = new Cus_User();
            //if (str=="人员管理")
            //{
            //    var listry = (from tbry in myModel.SYS_YHB
            //                  join tbjs in myModel.SYS_JSB on tbry.JSID equals tbjs.ID
            //                  select new Cus_User
            //                  {
            //                      ID = tbry.ID,
            //                      Name = tbry.Name,
            //                      GH = tbry.GH,
            //                      JSID = tbjs.ID,
            //                      strRole = tbjs.Role
            //                  }).ToList();
            //    rygldata.ItemsSource = listry;
            //}
            //if (str == "角色管理")
            //{
            //    var listjs = (from tbjs in myModel.SYS_JSB
            //                  select new Cus_Role
            //                  {
            //                      ID = tbjs.ID,
            //                      Role = tbjs.Role,
            //                      SFKY = tbjs.SFKY,
            //                      strSFKY = tbjs.SFKY == true ? "可用" : "不可用",
            //                  }).ToList();
            //    qxfpdata.ItemsSource = null;
            //    jsgldata.ItemsSource = listjs;
            //    qxid = 0;
            //}
        }
        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_xz_Click(object sender, RoutedEventArgs e)
        {
            if (str == "人员管理")
            {
                XZRYWindow window = new XZRYWindow();
                window.ShowDialog();
            }
            if (str == "角色管理")
            {
                XZJSWindow window = new XZJSWindow();
                window.ShowDialog();
            }
            ShuaXin();
        }

        
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btn_xg_Click(object sender, RoutedEventArgs e)
        {
            if (str == "人员管理")
            {
                if (ryrow.ID == 0)
                {
                    MessageBox.Show("请选择人员");
                    return;
                }

                XGRYWindow window = new XGRYWindow(ryrow);
                window.ShowDialog();
            }
            if (str == "角色管理")
            {
                if (jsid == 0)
                {
                    MessageBox.Show("请选择角色");
                    return;
                }
                XGJSWindow window = new XGJSWindow(row);
                window.ShowDialog();
            }
            ShuaXin();
        }

        private void btn_sc_Click(object sender, RoutedEventArgs e)
        {
            if (str == "人员管理")
            {
                if (ryrow.ID == 0)
                {
                    MessageBox.Show("请选择删除的内容");
                    return;
                }
                MessageBoxResult dr = MessageBox.Show("确定要删除该人员吗？", "提示", MessageBoxButton.OKCancel, MessageBoxImage.Question);
                if (dr == MessageBoxResult.OK)
                {
                    var ryb = (from tbryb in myModel.SYS_YHB
                               where tbryb.ID == ryrow.ID
                               select new
                               {
                                   tbryb,
                               }).Single();
                    try
                    {
                        myModel.SYS_YHB.Remove(ryb.tbryb);
                        myModel.SaveChanges();
                        MessageBox.Show("删除成功");
                    }
                    catch (Exception)
                    {
                        MessageBox.Show("删除失败");
                    }
                }
            }
            if (str == "角色管理")
            {
                if (jsid == 0)
                {
                    MessageBox.Show("请选择需要删除的角色");
                    return;
                }
                MessageBoxResult dr = MessageBox.Show("确定要删除该角色吗？", "提示", MessageBoxButton.OKCancel, MessageBoxImage.Question);
                if (dr == MessageBoxResult.OK)
                {
                    var yhb = (from ybyh in myModel.SYS_YHB
                               where ybyh.JSID == jsid
                               select new
                               {
                                   ybyh,
                               }).ToList();
                    if (yhb.Count > 0)
                    {
                        MessageBox.Show("该角色正在使用不能删除");
                        return;
                    }
                    var jsb = (from tbjsb in myModel.SYS_JSB
                               where tbjsb.ID == jsid
                               select new
                               {
                                   tbjsb,
                               }).Single();
                    try
                    {
                        myModel.SYS_JSB.Remove(jsb.tbjsb);
                        myModel.SaveChanges();
                        MessageBox.Show("删除成功");
                    }
                    catch (Exception)
                    {
                        MessageBox.Show("删除失败");
                    }
                }
            }
            ShuaXin();
        }

        
    }
}