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 JfJkxxController : Controller
    {
        // GET: JfJkxx
        public ActionResult Index()
        {
            return View();
        }

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

        [HttpGet]
        public ActionResult EditJfJkxx(String id)
        {
            if (id != "")
            {
                var bll = new dccdc.BLL.JfJkxxBll();
                var viewModel = new dccdc.Models.JfJkxx();
                viewModel.id = Convert.ToInt32(id);
                viewModel = bll.getJfJkxxOne(viewModel);
                return View(viewModel);
            }
            else
            {
                var viewModel = new dccdc.Models.JfJkxx();
                ERPUser user = Session["loginUser"] as Models.ERPUser;
                viewModel.jkrxm = user.TrueName;
                viewModel.jkrid = user.ID;
                viewModel.ksid = user.ksid;
                viewModel.jkbm = user.Department;
              
                return View(viewModel);
            }
        }


        [HttpPost]
        public ActionResult EditJfJkxx(JfJkxx model)
        {
            var bll = new dccdc.BLL.JfJkxxBll();

            bool f;
            try
            {
                if (model.id != 0)
                {
                    JfJkxx info = bll.getJfJkxxOne(model);

                    info.zt = model.zt;
                    info.jkrid = model.jkrid;
                    info.jkrxm = model.jkrxm;
                    info.jkbm = model.jkbm;
                    info.bz = model.bz;
                    info.jkyy = model.jkyy;
                    info.jkje = model.jkje;
                    f = bll.updJfJkxx(info);
                }
                else
                {
                    ERPUser user = Session["loginUser"] as Models.ERPUser;
                    String str = new dccdc.BLL.JfGwjdglBll().getckkdh("sqdid", "jf_jkxx");

                    f = bll.addJfJkxx(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 delJfJKXX(String id)
        {
            JfJkxx jfJkxx = new JfJkxx();
            jfJkxx.id = Convert.ToInt32(id);
            var bll = new JfJkxxBll();
            JfJkxx delinfo = bll.getJfJkxxOne(jfJkxx);
            try
            {
                bool f = bll.delJfJkxx(delinfo);
                return Json(f ? new { State = 1, Message = "操作成功！" } : new { State = 0, Message = "操作失败,请确认！" });
            }
            catch (Exception ex)
            {
                return Json(new { State = 0, Message = ex.Message });
            }

        }

        public JsonResult getJfJkxx(int page, int pagesize, string key, string sqsj, string zt)
        {
            var bll = new JfJkxxBll();
            JfJkxx jfJkxx = new JfJkxx();
            ERPUser user = Session["loginUser"] as Models.ERPUser;
            //  jfJkxx.ksid = Convert.ToInt32(user.ksid);
            //jfsjfwwxgl.sqsj = Convert.ToDateTime(sqsj);
            //jfsjfwwxgl.zt = zt;
            jfJkxx.jkrid = user.ID;
            List<JfJkxx> ctList = bll.getJfJkxx(jfJkxx, page, pagesize);

            int count = bll.countJfJkxx(jfJkxx);
            return Json(new { Total = count, Rows = ctList });
        }
        #region   choose User
        //----erp
        public ActionResult Chooseuserview()
        {
            return View();
        }

        public JsonResult getERPuser(int page, int pagesize, string key)
        {
            var bll = new JfJkxxBll();
            JfJkxx jfJkxx = new JfJkxx();
            ERPUser user = new Models.ERPUser();
          
            List<ERPUser> ctList = bll.getuserlist(key, page, pagesize);

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

        #region   choose借款单
        public ActionResult ChooseJKXXview()
        {
            return View();
        }
        public JsonResult GetJfJkxxbyxm(int page, int pagesize, string key)
        {
            var bll = new JfJkxxBll();
            List<JfJkxx> ctList = bll.GetJfJkxxbyxm(key, page, pagesize);

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


        

        #endregion

        #region
        public ActionResult ChooseBXDView()
        {
            List<Droplist> ztD = new List<Droplist>()
            { new Droplist { Value = "1", Title = "出差报销单" },
                new Droplist { Value = "2", Title = "其他报销单" }
            };
            ViewBag.ztD = new SelectList(ztD, "value", "title");
            ViewData["ztlist"] = new SelectList(ztD, "value", "title");
            return View();
        }

        public JsonResult getbxd(int page, int pagesize, string bxtypeval, string sqr)
        {
            if ("1"== bxtypeval)//---出差
            {
                string where = " ZT = 5 ";
                if (!string.IsNullOrEmpty(sqr))
                {
                        where += " AND sqr like '%"+sqr.Trim()+"%'";
                }

                var bll = new BLL.sqccbxBll();
                int count = bll.getCountLevel(where);
                var models = bll.getPageLevel(page, pagesize, where);
                return Json(new { Total = count, Rows = models });
            }
            else//----其他
            {
                string where = " ZT = 5 ";
                if (!string.IsNullOrEmpty(sqr))
                {
                    where += " AND sqr like '%" + sqr.Trim() + "%'";
                }

                var bll = new BLL.sqqtbxBll();
                int count = bll.getCountLevel(where);
                var models = bll.getPageLevel(page, pagesize, where);
                return Json(new { Total = count, Rows = models });
            }
        }
        #endregion

        #region  款项支付

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

        [HttpGet]
        public ActionResult EditJfKxzf(String id)
        {
            var list = new List<Droplist>() {
                new Droplist { Value = "0", Title = "现金" },
                new Droplist { Value = "1", Title = "银行卡" }
            };
            ViewData["zffsList"] = new SelectList(list, "value", "title");
            if (id != "")
            {
                var bll = new dccdc.BLL.JfJkxxBll();
                JfKxzf model = new JfKxzf();
                model.id = Convert.ToInt32(id);
                JfKxzf info = bll.getJfKxzfOne(model);
                return View(info);
            }
            else
            {
                return View();
            }
            
        }

        [HttpPost]
        public ActionResult EditJfKxzf(JfKxzf model)
        {
            var bll = new dccdc.BLL.JfJkxxBll();

            bool f;
            try
            {
                if (model.id != 0)
                {
                    JfKxzf info = bll.getJfKxzfOne(model);

                    f = bll.updJfKxzf(info);
                }
                else
                {
                    ERPUser user = Session["loginUser"] as Models.ERPUser;


                    f = bll.addJfKxzf(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 GetJfKxzf(int page, int pagesize, string key, string sqsj, string zt)
        {
            var bll = new JfJkxxBll();
            JfKxzf jfKxzf = new JfKxzf();
            ERPUser user = Session["loginUser"] as Models.ERPUser;
            List<JfKxzf> ctList = bll.GetJfKxzf(jfKxzf, page, pagesize);

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

        #region  借款扣除

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

        [HttpGet]
        public ActionResult EditJfJkkc(String id)
        {
            var list = new List<Droplist>() { 
                new Droplist { Value = "1", Title = "现金归还" },
                new Droplist { Value = "0", Title = "报销抵扣" }
            };
            ViewData["jkkcfsList"] = new SelectList(list, "value", "title");
            if (id != "")
            {
                var bll = new dccdc.BLL.JfJkxxBll();
                JfJkkc model = new JfJkkc();
                model.id = Convert.ToInt32(id);
                JfJkkc info = bll.getJfJkkcOne(model);
                return View(info);
            }
            else
            {
                return View();
            }
        }

        [HttpPost]
        public ActionResult EditJfJkkc(JfJkkc model)
        {
            var bll = new dccdc.BLL.JfJkxxBll();

            bool f;
            try
            {
                if (model.id != 0)
                {
                    JfJkkc info = bll.getJfJkkcOne(model);
                    if (model.jkkcfs == "1")
                    {
                        info.jkkcfs = "1";
                        info.bxdid = null;
                        info.jkdid = null;
                        info.dkje = null;

                        info.ghr = model.ghr;
                        info.ghrid = model.ghrid;
                        info.ghje = model.ghje;
                    }
                    else
                    {
                        info.jkkcfs = "0";
                        info.ghrid = 0;
                        info.ghje = null;

                        info.bxdid = model.bxdid;
                        info.jkdid = model.jkdid;
                        info.dkje = model.dkje;
                    }

                    f = bll.updJfJkkc(info);
                }
                else
                {
                    ERPUser user = Session["loginUser"] as Models.ERPUser;
                    if (model.jkkcfs == "1")
                    {
                        model.bxdid = null;
                        model.jkdid = null;
                        model.dkje = null;
                    }
                    else
                    {
                        model.ghr = null;
                        model.ghje = null;
                    }

                    f = bll.addJfJkkc(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 GetJfJkkc(int page, int pagesize, string key, string sqsj, string zt)
        {
            var bll = new JfJkxxBll();
            JfJkkc jfJkkc = new JfJkkc();
            ERPUser user = Session["loginUser"] as Models.ERPUser;
            List<JfJkkc> ctList = bll.GetJfJkkc(jfJkkc, page, pagesize);

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

        #endregion


        #region 审批
        [HttpGet]
        public ActionResult BLjfJkxx(String id)
        {
            var bll = new dccdc.BLL.JfJkxxBll();
            var viewModel = new dccdc.Models.JfJkxx();
            viewModel.id = Convert.ToInt32(id);
            viewModel = bll.getJfJkxxOne(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.cwldqx = "1";
                ViewBag.zxldqx = "1";
            }
            else if (qx.Contains(ContextUtils.FGLD_QX) && viewModel.zt == "2")
            {
                ViewBag.ksldqx = "1";
                ViewBag.cwldqx = "1";
                ViewBag.zxldqx = "1";

                ViewBag.fgldqx = "0";
            }
            else if (qx.Contains(ContextUtils.CWLD_QX) && viewModel.zt == "3")
            {
                ViewBag.ksldqx = "1";
                ViewBag.fgldqx = "1";
                ViewBag.zxldqx = "1";

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

                ViewBag.zxldqx = "0";
            }
            return View(viewModel);
        }

        [HttpPost]
        public ActionResult BLjfJkxx(dccdc.Models.JfJkxx model)
        {
            var bll = new dccdc.BLL.JfJkxxBll();
            var info = bll.getJfJkxxOne(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.ksldspsj = DateTime.Today;
                info.ksldspyj = model.ksldspyj;
                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.fgldspsj = DateTime.Today;
                if (model.zt == "1")//--同意
                {
                    info.zt = "3";
                }
                else
                {
                    info.zt = "1";
                }
                modelinfo.spnr = model.fgldspyj;
            }

            else if (qx.Contains(ContextUtils.CWLD_QX) && info.zt == "3")
            {
                info.cwfzspyj = model.cwfzspyj;
                info.cwfzspsj = DateTime.Today;
                if (model.zt == "1")//--同意
                {
                    info.zt = "4";
                }
                else
                {
                    info.zt = "1";
                }
                modelinfo.spnr = model.cwfzspyj;

            }
            else if (qx.Contains(ContextUtils.ZXLD_QX) && info.zt == "4")
            {
                info.zxldspyj = model.zxldspyj;
                info.zxldspsj = DateTime.Today;
                if (model.zt == "1")//--同意
                {
                    info.zt = "5";
                }
                else
                {
                    info.zt = "1";
                }
                modelinfo.spnr = model.zxldspyj;
            }
            try
            {
                bool f = bll.updJfJkxx(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 ActionResult SPjfJkxx()
        {
            return View();
        }


        public JsonResult getjfJkxxsp(int page, int pagesize, string key, string sqsj, string zt)
        {
            var bll = new JfJkxxBll();
            JfJkxx jfjkxx = new JfJkxx();
            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<JfJkxx> ctList = bll.getspJfJkxx(ksidstr, str, page, pagesize);

            int count = bll.countspJfJkxx(ksidstr, str);
            return Json(new { Total = count, Rows = ctList });
        }
        #endregion

        #region 查询申请单

        public ActionResult jfjkxxsqdcx()
        {
            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 = "5", Title = "通过" },
                new Droplist { Value = "0", Title = "申请" }
            };
            ViewData["ztlist"] = new SelectList(list, "value", "title");
            return View();
        }

        public JsonResult getjfjkxxsqd(int page, int pagesize, string key, string sqsj, string zt)
        {
            var bll = new JfJkxxBll();
            JfJkxx jfjkxx = new JfJkxx();
            ERPUser user = Session["loginUser"] as Models.ERPUser;
            if(key!=null&&key!="")
                jfjkxx.jkbm = key;
            if (sqsj != null && sqsj != "")
                jfjkxx.jkrq = Convert.ToDateTime(sqsj);
            if (zt != null && zt != "")
                jfjkxx.zt = zt;
            List<JfJkxx> ctList = bll.getJfJkxx(jfjkxx, page, pagesize);

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


        #region 打印
        [AllowAnonymous]
        public string jkxxdy(string id)
        {
            if (string.IsNullOrEmpty(id))
                return "";
            var bll = new dccdc.BLL.JfJkxxBll();
            var viewModel = new dccdc.Models.JfJkxx();
            viewModel.id = Convert.ToInt32(id);
            viewModel = bll.getJfJkxxOne(viewModel);
           
            viewModel.bz = Charge3Controller.MoneyToUpper(viewModel.jkje.ToString());
            List<JfJkxx> list = new List<JfJkxx>();
            list.Add(viewModel);
            return Newtonsoft.Json.JsonConvert.SerializeObject(list);
        }
        #endregion
    }
}