using dccdc.BLL;
using dccdc.code;
using dccdc.Models;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using static dccdc.Controllers.DictionariesController;

namespace dccdc.Controllers
{
    public class SbjfwwhglController : Controller
    {
        // GET: Sbjfwwhgl
        public ActionResult Index()
        {
            return View();
        }
        /**
         * 我的申请列表页
         **/
        public ActionResult sbjfwwhlb()
        {
            var list = new List<Droplist>() { new Droplist { Value = "1", Title = "科室领导审批" },
                new Droplist { Value = "2", Title = "分管领导审批" },
                new Droplist { Value = "3", Title = "中心领导审批" },
                new Droplist { Value = "4", Title = "通过" },
                new Droplist { Value = "0", Title = "申请" }
            };
            ViewData["ztlist"] = new SelectList(list, "value", "title");
            return View();
        }
        /**
         * 新增页面
         * */
        [HttpGet]
        public ActionResult xzsbjfwwh(String id)
        {

            List<Droplist> fylyD = new List<Droplist>() { new Droplist { Value = "1", Title = "自有资金" }, new Droplist { Value = "2", Title = "项目经费" }, new Droplist { Value = "3", Title = "三重一大" } };

            ViewData["group"] = new SelectList(fylyD, "value", "title");
            if (id != "")
            {
                var bll = new dccdc.BLL.SbjfwwhBLL();
                var viewModel = new dccdc.Models.JfSjfwwxgl();
                viewModel.id = Convert.ToInt32(id);
                viewModel = bll.getJfSjfwwxglxxOne(viewModel);
                return View(viewModel);
            }
            else
            {
                return View();
            }
        }

        [HttpPost]
        public ActionResult xzsbjfwwh(dccdc.Models.JfSjfwwxgl model)
        {
            var bll = new dccdc.BLL.SbjfwwhBLL();
            bool f;

            try
            {
                if (model.id != 0)
                {
                    JfSjfwwxgl info = bll.getJfSjfwwxglxxOne(model);
                    info.zt = model.zt;
                    info.wxly = model.wxly;
                    info.wxnr = model.wxnr;
                    info.sxfy = model.sxfy;
                    info.jfly = model.jfly;
                    info.glsqd = model.glsqd;
                    info.szydsqd = model.szydsqd;
                    info.bz = model.bz;
                    f = bll.updJfSjfwwxglxx(info);
                }
                else
                {
                    ERPUser user = Session["loginUser"] as Models.ERPUser;
                    model.ksid = user.ksid;
                    model.sqrid = user.ID;
                    String str = new dccdc.BLL.JfGwjdglBll().getckkdh("sbfwwxid", "jf_sbjfwwxgl");
                    model.sbfwwxid = str;
                    model.sqsj = DateTime.Today;
                    model.zt = "1";
                    f = bll.addJfSjfwwxglxx(model);
                }
                return Json(f ? new { State = 1, Message = "操作成功！" } : new { State = 0, Message = "操作失败,请确认！" });
            }
            catch (Exception ex)
            {
                return Json(new { State = 0, Message = ex.Message });
            }
        }
     
        public JsonResult getJfSbjfwwxgl(int page, int pagesize, string key, string sqsj, string zt)
        {
            var bll = new SbjfwwhBLL();
            JfSjfwwxgl jfsjfwwxgl = new JfSjfwwxgl();
            ERPUser user = Session["loginUser"] as Models.ERPUser;
            //user.ZhiWei = "科室领导,财务领导,中心主任";
            //Session["loginUser"] = user;
            jfsjfwwxgl.ksid = Convert.ToInt32(user.ksid);
            //jfsjfwwxgl.sqsj = Convert.ToDateTime(sqsj);
            //jfsjfwwxgl.zt = zt;
            jfsjfwwxgl.sqrid = user.ID;
            List<JfSjfwwxgl> ctList = bll.getJfSjfwwxglxx(jfsjfwwxgl, page, pagesize);

            int count = bll.count(jfsjfwwxgl);
            return Json(new { Total = count, Rows = ctList });
        }


        public ActionResult chooseszydView()
        {
            return View();
        }

        public JsonResult getszydspPage(int page, int pagesize, string key)
        {
            //var user = Session["loginUser"] as Models.ERPUser;
            ////string where = " and sqrid=" + user.ID;
            //string zw = getZW();
            ////非职务人员
            //if (zw == "0")
            //    return Json(null);
            //string where = "";
            //switch (zw)
            //{
            //    case "1": where = " and zt=1 and ksid=" + user.ksid; break;
            //    case "2": where = " and zt=2 and ksid in" + getChildrenKsid(user.ksid); break;
            //    case "3": where = " and zt=3 and ksid in" + getChildrenKsid(user.ksid); break;
            //    case "4": where = " and zt=4 and ksid in" + getChildrenKsid(user.ksid); break;
            //    case "5": where = " and zt=5 and ksid in" + getChildrenKsid(user.ksid); break;
            //}
            string where = " AND ZT > 5";
            var bll = new BLL.szyd_zjsysqBll();
            int count = bll.getCountLevel(where);
            var models = bll.getPageLevel(page, pagesize, where);
            return Json(new { Total = count, Rows = models });
        }
        public JsonResult delJfSjfwwxglxx(String id)
        {
            JfSjfwwxgl jfsjfwwxgl = new JfSjfwwxgl();
            jfsjfwwxgl.id = Convert.ToInt32(id);
            var bll = new SbjfwwhBLL();
            JfSjfwwxgl delinfo = bll.getJfSjfwwxglxxOne(jfsjfwwxgl);
            try
            {
                bool f = bll.delJfSjfwwxglxx(delinfo);
                return Json(f ? new { State = 1, Message = "操作成功！" } : new { State = 0, Message = "操作失败,请确认！" });
            }
            catch (Exception ex)
            {
                return Json(new { State = 0, Message = ex.Message });
            }
        }

        #region 审批
        /**
        * 我的工作列表页
        **/
        public ActionResult sbjfwwhjoblb()
        {
            return View();
        }

        /**
         * 办理页面
        * */
        [HttpGet]
        public ActionResult blsbjfwwh(String id)
        {
            var bll = new dccdc.BLL.SbjfwwhBLL();
            var viewModel = new dccdc.Models.JfSjfwwxgl();
            viewModel.id = Convert.ToInt32(id);
            viewModel = bll.getJfSjfwwxglxxOne(viewModel);
            ERPUser user = Session["loginUser"] as Models.ERPUser;
            String[] qx = user.ZhiWei.Split(',');
            
            if (qx.Contains(ContextUtils.KSLD_QX) &&viewModel.zt=="1" )
            {
                ViewBag.ksldqx = "0";
                ViewBag.fgldqx = "1";
                ViewBag.zxldqx = "1";
            }
            else if (qx.Contains(ContextUtils.FGLD_QX) && viewModel.zt == "2")
            {
                ViewBag.ksldqx = "1";
                ViewBag.fgldqx = "0";
                ViewBag.zxldqx = "1";

            }
            else if (qx.Contains(ContextUtils.ZXLD_QX) && viewModel.zt == "4")
            {
                ViewBag.ksldqx = "1";
                ViewBag.fgldqx = "1";
                ViewBag.zxldqx = "0";
            }
            return View(viewModel);

        }
        [HttpPost]
        public ActionResult blsbjfwwh(dccdc.Models.JfSjfwwxgl model)
        {
            var bll = new dccdc.BLL.SbjfwwhBLL();
            JfSjfwwxgl info = bll.getJfSjfwwxglxxOne(model);
            ERPUser user = Session["loginUser"] as Models.ERPUser;
            String[] qx = user.ZhiWei.Split(',');

            var modelinfo = new sqshModel();
            modelinfo.type = "房屋及设备维护";             //添加 查询与添加一致就行
            modelinfo.sqid = Convert.ToInt32(info.id);
            modelinfo.spr = user.TrueName;
            modelinfo.sptime = DateTime.Now;
            if (qx.Contains(ContextUtils.KSLD_QX) && info.zt == "1")
            {
                info.ksldspyj = model.ksldspyj;
                info.ksldsprq = DateTime.Today;
                if (model.zt == "1")//--同意
                {
                    info.zt = "2";
                }
                else
                {
                    info.zt = "1";
                }

                modelinfo.spnr = model.ksldspyj;
            }
            else if (qx.Contains(ContextUtils.FGLD_QX) && info.zt == "2")
            {
                info.fgldspyj = model.fgldspyj;
                info.fgldsprq = DateTime.Today;
                if (model.zt == "1")//--同意
                {
                    info.zt = "4";
                }
                else
                {
                    info.zt = "1";
                }
                modelinfo.spnr = model.fgldspyj;
            }
            else if (qx.Contains(ContextUtils.ZXLD_QX) && info.zt == "4")
            {
                info.zxldspyj = model.zxldspyj;
                info.zxldsprq = DateTime.Today;
                if (model.zt == "1")//--同意
                {
                    info.zt = "5";
                }
                else
                {
                    info.zt = "1";
                }
                modelinfo.spnr = model.zxldspyj;

            }
            try
            {
                bool f = bll.updJfSjfwwxglxx(info);
                modelinfo.zt = (model.zt == "1") ? "通过" : "不通过";
                new BLL.sqshBll().Add(modelinfo);
                return Json(f ? new { State = 1, Message = "操作成功！" } : new { State = 0, Message = "操作失败,请确认！" });
            }
            catch (Exception ex)
            {
                return Json(new { State = 0, Message = ex.Message });
            }
        }
        public JsonResult getsbjfwwhxx(int page, int pagesize)
        {

            var bll = new SbjfwwhBLL();
            JfSjfwwxgl jfsjfwwxgl = new JfSjfwwxgl();
            ERPUser user = Session["loginUser"] as Models.ERPUser;
            String[] qx = user.ZhiWei.Split(',');
            string ksidstr = ContextUtils.getChildrenKsid(user.ksid);
            List<String> list = ContextUtils.getChildrenZT(qx);
            string str = "";
            if (list != null&&list.Count>0)
            {

                str = " AND (";
                for (int i = 0; i < list.Count; i++)
                {
                    if (i != 0)
                    {
                        str += " OR";
                    }
                    if ("1" == list[i])
                    {
                        str +="  (KSID = "+user.ksid+" AND ZT =1)";
                    }else if ("2" == list[i])
                    {
                        str += "  (KSID IN " + ksidstr + " AND ZT =2)";
                    }
                    else if ("3" == list[i])
                    {
                        str += "   (ZT =3)";
                    }
                    else if ("4" == list[i])
                    {
                        str += "  (KSID IN " + ksidstr + " AND ZT =4)";
                    }
                }
                str += ")";
            }

            List<JfSjfwwxgl> ctList = bll.getspJfSjfwwxglxx(ksidstr, str, page, pagesize);
            int count = bll.countspsbjfwwh(ksidstr, str);
            return Json(new { Total = count, Rows = ctList });
        }
        #endregion

        #region 查询申请单

        public ActionResult sbjfwwhsqdcx()
        {
            var list = new List<Droplist>() { new Droplist { Value = "1", Title = "科室领导审批" },
                new Droplist { Value = "2", Title = "分管领导审批" },
                new Droplist { Value = "3", Title = "中心领导审批" },
                new Droplist { Value = "4", Title = "通过" },
                new Droplist { Value = "0", Title = "申请" }
            };
            ViewData["ztlist"] = new SelectList(list, "value", "title");
            return View();
        }

        public JsonResult getJfSbjfwwxglsqd(int page, int pagesize, string key, string sqsj, string zt)
        {
            var bll = new SbjfwwhBLL();
            JfSjfwwxgl jfsjfwwxgl = new JfSjfwwxgl();
            ERPUser user = Session["loginUser"] as Models.ERPUser;
            jfsjfwwxgl.ksid = Convert.ToInt32(key ==null?"0":key);
            if(sqsj!= null && sqsj != "")
                jfsjfwwxgl.sqsj = Convert.ToDateTime(sqsj);
            if(zt!=null&&zt!="")
                jfsjfwwxgl.zt = zt;
            List<JfSjfwwxgl> ctList = bll.getJfSjfwwxglxx(jfsjfwwxgl, page, pagesize);

            int count = bll.count(jfsjfwwxgl);
            return Json(new { Total = count, Rows = ctList });
        }
        #endregion
        #region 选择科室
        public ActionResult chooseksView()
        {
            return View();
        }

        public JsonResult GetERPBuMen(int page, int pagesize, string key, string sqsj, string zt)
        {
            var bll = new SbjfwwhBLL();
            ERPBuMenModel erpbm = new ERPBuMenModel();
         
            List<ERPBuMenModel> ctList = bll.geterpbm(erpbm, page, pagesize);

            int count = bll.counterpnm(erpbm);
            return Json(new { Total = count, Rows = ctList });
        }
        #endregion

        #region 打印
        [AllowAnonymous]
        public string sbjfwwhdy(string id)
        {
            if (string.IsNullOrEmpty(id))
                return "";
            var bll = new dccdc.BLL.SbjfwwhBLL();
            var viewModel = new dccdc.Models.JfSjfwwxgl();
            viewModel.id = Convert.ToInt32(id);
            viewModel = bll.getJfSjfwwxglxxOne(viewModel);
            List<JfSjfwwxgl> list = new List<JfSjfwwxgl>();
            list.Add(viewModel);
            return Newtonsoft.Json.JsonConvert.SerializeObject(list);
        }
        #endregion
    }
}