username@email.com
2022-06-15 0e6d0e8975e92a6395d2d9f692edd5a7d0984c5a
zhengcaioa/zhengcaioa/Controllers/ExpertTest/ExpertTestTopicController.cs
@@ -11,6 +11,7 @@
using System.Linq;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Text;
using System.Threading.Tasks;
using System.Transactions;
using zhengcaioa.IService;
@@ -92,6 +93,10 @@
            ViewBag.zhongdian = _liaotianService.GetSYScode("system", "shifou").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
            ViewBag.jiexi_status = _liaotianService.GetSYScode("expert_test_topic", "jiexi_status").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
            ViewBag.shenpi_status = _liaotianService.GetSYScode("expert_test_topic", "shenpi_status").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
            ViewBag.Falv = _liaotianService.GetSYScode("expert_test_topicjiexi", "falv").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
            ViewBag.shanchuzhishitype = _liaotianService.GetSYScodeshanchu("expert_test_topic", "zhishitype").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
            var areaDTOs = _areaService.GetList().Where(x => x.ParentId == "0     ").ToList();
            foreach (var areaDTO in areaDTOs)
            {
@@ -122,7 +127,7 @@
            return new JsonResult(_expertTestTopicService.SearchByPaging(search));
        }
        public IActionResult Edit(string id = null, string Topictype = "", string Zhishitype = "", string Area = "")
        public IActionResult Edit(string id = null, string Topictype = "", string Zhishitype = "", string Area = "",string Falv ="")
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
@@ -134,7 +139,12 @@
            if (!String.IsNullOrEmpty(id))
            {
                dto = _expertTestTopicService.Get(id);
                expertTestTopicanwserDTOs = _expertTestTopicService.GetListanwser(id);
                if (dto.Topictype=="03")
                {
                    expertTestTopicanwserDTOs = expertTestTopicanwserDTOs.OrderBy(x=>x.Anwserno).ToList();
                }
                if (expertTestTopicanwserDTOs.Count == 0)
                {
                    expertTestTopicanwserDTOs.Add(new ExpertTestTopicanwserDTO());
@@ -163,7 +173,7 @@
                    expertTestTopicanwserDTO.Anwserno = "√";
                    expertTestTopicanwserDTOs.Add(expertTestTopicanwserDTO);
                    var expertTestTopicanwserDTO1 = new ExpertTestTopicanwserDTO();
                    expertTestTopicanwserDTO1.Anwserno = "×";
                    expertTestTopicanwserDTO1.Anwserno = "x";
                    expertTestTopicanwserDTOs.Add(expertTestTopicanwserDTO1);
                    
@@ -186,12 +196,39 @@
                    dto.expertTestTopicanwserDTOs = expertTestTopicanwserDTOs;
                }
                if (!string.IsNullOrEmpty(Falv))
                {
                    string[] falvs = Falv.Split(',');
                    for(int i=0;i< falvs.Length; i++)
                    {
                        if (i == 0)
                        {
                            var ssssss = new ExpertTestTopicjiexiDTO();
                            ssssss.Flag = "A";
                            ssssss.Falv = falvs[i];
                            expertTestTopicjiexiDTOs.Add(ssssss);
                        }
                        else if(!string.IsNullOrEmpty(falvs[i]))
                        {
                            var ssssss = new ExpertTestTopicjiexiDTO();
                            ssssss.Flag = "D";
                            ssssss.Falv = falvs[i];
                            expertTestTopicjiexiDTOs.Add(ssssss);
                        }
                    }
                    dto.expertTestTopicjiexiDTOs = expertTestTopicjiexiDTOs;
                }
                else
                {
                    var ssssss = new ExpertTestTopicjiexiDTO();
                    ssssss.Flag = "A";
                    expertTestTopicjiexiDTOs.Add(ssssss);
                    dto.expertTestTopicjiexiDTOs = expertTestTopicjiexiDTOs;
                }
                var ssssss = new ExpertTestTopicjiexiDTO();
                ssssss.Flag = "A";
                expertTestTopicjiexiDTOs.Add(ssssss);
                dto.expertTestTopicjiexiDTOs = expertTestTopicjiexiDTOs;
                if (string.IsNullOrEmpty(Topictype))
                {
@@ -217,6 +254,7 @@
                {
                    dto.Area = Area;
                }
                
            }
@@ -631,5 +669,429 @@
            return View();
        }
        public IActionResult EditResult()
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
            var resultDTOs = _expertTestTopicService.GetListResult();
            var sysCodeDtls = _liaotianService.GetSYScode("expert_test_result", "resulttype");
            if (resultDTOs==null || resultDTOs.Count == 0)
            {
                resultDTOs = new List<ExpertTestResultDTO>();
                foreach (var sysCodeDtl in sysCodeDtls)
                {
                    ExpertTestResultDTO expertTestResultDTO = new ExpertTestResultDTO();
                    expertTestResultDTO.Resulttype = sysCodeDtl.CodeSn;
                    expertTestResultDTO.ResulttypeName = sysCodeDtl.Comments;
                    expertTestResultDTO.Result = "";
                    resultDTOs.Add(expertTestResultDTO);
                }
            }
            ViewBag.resultDTOs = resultDTOs;
            ViewBag.resulttype = sysCodeDtls;
            return View();
        }
        /// <summary>
        /// 保存
        /// </summary>
        /// <param name="data">岗位实体类对象</param>
        /// <returns></returns>
        ///
        [HttpPost]
        public  IActionResult SaveResult(ExpertTestResultDTO data)
        {
            ResultEntity resultEntity = new ResultEntity();
            using (TransactionScope scope = new TransactionScope())
            {
                var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
                ViewData["curentuser"] = curentuser;
                data.RecStatus = "A";
                if(data.Resulttypes!=null&& data.Resulttypes.Length > 0)
                {
                   for(int i=0;i< data.Resulttypes.Length; i++)
                    {
                      var resultDTO = _expertTestTopicService.GetResult(data.Resulttypes[i]);
                        if (string.IsNullOrEmpty(resultDTO.Id))
                        {
                            resultDTO = new ExpertTestResultDTO();
                            resultDTO.Resulttype = data.Resulttypes[i];
                            resultDTO.Result = data.Results[i];
                            resultDTO.Creater = curentuser.Id;
                            resultDTO.Createtime = DateTime.Now;
                        }
                        else
                        {
                            resultDTO.Resulttype = data.Resulttypes[i];
                            resultDTO.Result = data.Results[i];
                        }
                        resultDTO.Modifier = curentuser.Id;
                        resultDTO.Modifytime = DateTime.Now;
                        resultEntity = _expertTestTopicService.saveResult(resultDTO);
                    }
                }
                scope.Complete();
            }
            return new JsonResult(resultEntity);
        }
        public IActionResult EditPeizhi()
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
            var expertTestTopicpeizhiDTOs = _expertTestTopicService.GetListpeizhi();
            var topictypes = _liaotianService.GetSYScode("expert_test_topic", "topictype");
            var zhishitypes = _liaotianService.GetSYScode("expert_test_topic", "zhishitype");
            if (expertTestTopicpeizhiDTOs == null || expertTestTopicpeizhiDTOs.Count == 0)
            {
                expertTestTopicpeizhiDTOs = new List<ExpertTestTopicpeizhiDTO>();
                foreach (var topictype in topictypes)
                {
                    foreach (var zhishitype in zhishitypes)
                    {
                        ExpertTestTopicpeizhiDTO expertTestTopicpeizhiDTO = new ExpertTestTopicpeizhiDTO();
                        expertTestTopicpeizhiDTO.ShijianId = "01";
                        expertTestTopicpeizhiDTO.Topictype = topictype.CodeSn;
                        expertTestTopicpeizhiDTO.TopictypeName = topictype.Comments;
                        expertTestTopicpeizhiDTO.Zhishitype = zhishitype.CodeSn;
                        expertTestTopicpeizhiDTO.ZhishitypeName = zhishitype.Comments;
                        expertTestTopicpeizhiDTO.Fenshu = 0;
                        expertTestTopicpeizhiDTO.Fenzhi = 0;
                        expertTestTopicpeizhiDTO.FenshuName = "0";
                        expertTestTopicpeizhiDTO.FenzhiName = "0";
                        expertTestTopicpeizhiDTO.zongFenshu = "0";
                        expertTestTopicpeizhiDTO.zongFenzhi = "0";
                        expertTestTopicpeizhiDTOs.Add(expertTestTopicpeizhiDTO);
                    }
                }
            }
            else
            {
                foreach (var expertTestTopicpeizhiDTO in expertTestTopicpeizhiDTOs)
                {
                    var aaaa  = expertTestTopicpeizhiDTOs.Where(x => x.Topictype == expertTestTopicpeizhiDTO.Topictype).Sum(x => x.Fenshu);
                    expertTestTopicpeizhiDTO.zongFenshu = aaaa.HasValue? aaaa.Value.ToString("0.##"):"";
                    expertTestTopicpeizhiDTO.zongFenzhi = expertTestTopicpeizhiDTO.Fenzhi.HasValue ? expertTestTopicpeizhiDTO.Fenzhi.Value.ToString("0.##") : "";
                }
                foreach (var zhishitype in zhishitypes)
                {
                    var bbbb = expertTestTopicpeizhiDTOs.Where(x => x.Zhishitype == zhishitype.CodeSn).ToList();
                    if (bbbb.Count <= 0)
                    {
                        foreach (var topictype in topictypes)
                        {
                            ExpertTestTopicpeizhiDTO expertTestTopicpeizhiDTO = new ExpertTestTopicpeizhiDTO();
                            expertTestTopicpeizhiDTO.ShijianId = "01";
                            expertTestTopicpeizhiDTO.Topictype = topictype.CodeSn;
                            expertTestTopicpeizhiDTO.TopictypeName = topictype.Comments;
                            expertTestTopicpeizhiDTO.Zhishitype = zhishitype.CodeSn;
                            expertTestTopicpeizhiDTO.ZhishitypeName = zhishitype.Comments;
                            expertTestTopicpeizhiDTO.Fenshu = 0;
                            expertTestTopicpeizhiDTO.Fenzhi = 0;
                            expertTestTopicpeizhiDTO.FenshuName = "0";
                            expertTestTopicpeizhiDTO.FenzhiName = "0";
                            expertTestTopicpeizhiDTO.zongFenshu = "0";
                            expertTestTopicpeizhiDTO.zongFenzhi = "0";
                            expertTestTopicpeizhiDTOs.Add(expertTestTopicpeizhiDTO);
                        }
                        expertTestTopicpeizhiDTOs = expertTestTopicpeizhiDTOs.OrderBy(x => x.Topictype).ThenBy(x => x.Zhishitype).ToList();
                    }
                }
            }
            ViewBag.expertTestTopicpeizhiDTOs = expertTestTopicpeizhiDTOs;
            ViewBag.topictype = topictypes;
            ViewBag.zhishitype = zhishitypes;
            return View();
        }
        /// <summary>
        /// 保存
        /// </summary>
        /// <param name="data">岗位实体类对象</param>
        /// <returns></returns>
        ///
        [HttpPost]
        public IActionResult SavePeizhi(ExpertTestTopicpeizhiDTO data)
        {
            ResultEntity resultEntity = new ResultEntity();
            using (TransactionScope scope = new TransactionScope())
            {
                var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
                ViewData["curentuser"] = curentuser;
                data.RecStatus = "A";
                if (data.Zhishitypes != null && data.Zhishitypes.Length > 0)
                {
                    for (int i = 0; i < data.Zhishitypes.Length; i++)
                    {
                        var resultDTO = _expertTestTopicService.Getpeizhi(data.Topictypes[i],data.Zhishitypes[i]);
                        if (string.IsNullOrEmpty(resultDTO.Id))
                        {
                            resultDTO = new ExpertTestTopicpeizhiDTO();
                            resultDTO.ShijianId = data.ShijianIds[i];
                            resultDTO.Topictype = data.Topictypes[i];
                            resultDTO.Zhishitype = data.Zhishitypes[i];
                            resultDTO.Fenshu = data.Fenshus[i];
                            for (int j = 0; j < data.Topictypeszong.Length; j++)
                            {
                                if(data.Topictypeszong[j]== resultDTO.Topictype)
                                {
                                    resultDTO.Fenzhi = data.Fenzhizong[j];
                                }
                            }
                            resultDTO.Creater = curentuser.Id;
                            resultDTO.Createtime = DateTime.Now;
                        }
                        else
                        {
                            resultDTO.ShijianId = data.ShijianIds[i];
                            resultDTO.Topictype = data.Topictypes[i];
                            resultDTO.Zhishitype = data.Zhishitypes[i];
                            resultDTO.Fenshu = data.Fenshus[i];
                            for (int j = 0; j < data.Topictypeszong.Length; j++)
                            {
                                if (data.Topictypeszong[j] == resultDTO.Topictype)
                                {
                                    resultDTO.Fenzhi = data.Fenzhizong[j];
                                }
                            }
                        }
                        resultDTO.Modifier = curentuser.Id;
                        resultDTO.Modifytime = DateTime.Now;
                        resultEntity = _expertTestTopicService.savepeizhi(resultDTO);
                    }
                }
                scope.Complete();
            }
            return new JsonResult(resultEntity);
        }
        public IActionResult shititongji()
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
            var expertTestTopicDTOs = new List<ExpertTestTopicDTO>();
            var expertTestTopicDTOs1 = _expertTestTopicService.GetList();
            var sysCodeDtls = _liaotianService.GetSYScode("expert_test_topic", "topictype");
            var sysCodeDtls1 = _liaotianService.GetSYScode("expert_test_topic", "zhishitype");
            foreach (var sysCodeDtl1 in sysCodeDtls1)
            {
                foreach (var sysCodeDtl in sysCodeDtls)
                {
                    var shuliang = expertTestTopicDTOs1.Count(x => x.Zhishitype == sysCodeDtl1.CodeSn && x.Topictype == sysCodeDtl.CodeSn);
                    var expertTestTopicDTO = new ExpertTestTopicDTO();
                    expertTestTopicDTO.Shuliang = shuliang;
                    var sysCodeDtl2 = sysCodeDtls1.Where(x => x.CodeSn == sysCodeDtl1.CodeSn).FirstOrDefault();
                    if (sysCodeDtl2 != null)
                    {
                        expertTestTopicDTO.ZhishitypeName = sysCodeDtl2.Comments;
                    }
                    expertTestTopicDTO.Zhishitype = sysCodeDtl1.CodeSn;
                    expertTestTopicDTO.Topictype = sysCodeDtl.CodeSn;
                    expertTestTopicDTOs.Add(expertTestTopicDTO);
                }
            }
            foreach (var sysCodeDtl in sysCodeDtls)
            {
                var shuliang = expertTestTopicDTOs1.Count(x => x.Topictype == sysCodeDtl.CodeSn);
                var expertTestTopicDTO = new ExpertTestTopicDTO();
                expertTestTopicDTO.Shuliang = shuliang;
                expertTestTopicDTO.ZhishitypeName = "合计";
                expertTestTopicDTO.Zhishitype = "";
                expertTestTopicDTO.Topictype = sysCodeDtl.CodeSn;
                expertTestTopicDTOs.Add(expertTestTopicDTO);
            }
            //ViewBag.topictype = sysCodeDtls;
            //ViewBag.zhishitype = sysCodeDtls1;
            //ViewBag.listExpertTestTopicDTO = expertTestTopicDTOs;
            StringBuilder stringBuilder = new StringBuilder();
            stringBuilder.Append("<table style=\"width:50%;\">");
            stringBuilder.Append(" <tr>");
            stringBuilder.Append("<td style=\"width:25%;\"> 知识点/题型</td>");
            foreach (var sysCodeDtl in sysCodeDtls)
            {
                stringBuilder.Append("<td style = \"width:25%;\" > " + sysCodeDtl.Comments + "</td >");
            }
            stringBuilder.Append(" </tr>");
            int i = 0;
            foreach(var ExpertTestTopicDTO in expertTestTopicDTOs)
            {
                if(i != 0 && i % 3 == 0)
                {
                    stringBuilder.Append(" </tr>");
                }
                if(i == 0 || i % 3 == 0)
                {
                    stringBuilder.Append("<tr>");
                    stringBuilder.Append(" <td>" + ExpertTestTopicDTO.ZhishitypeName + "</td>");
                }
                stringBuilder.Append("<td><a onclick=\"OpenWindow(' ','98%','100%', '/ExpertTestTopic/tongjiIndex?Topictype=" + ExpertTestTopicDTO.Topictype + "&Zhishitype=" + ExpertTestTopicDTO.Zhishitype + "')\"  >             " + ExpertTestTopicDTO.Shuliang +"</a></td>");
                if (i == expertTestTopicDTOs.Count - 1)
                {
                    stringBuilder.Append(" </tr>");
                }
                i++;
            }
            stringBuilder.Append("</table>");
            ViewBag.htmlstring = stringBuilder.ToString(); ;
            return View();
        }
        public IActionResult tongjiIndex(string Topictype="", string Zhishitype = "")
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
            List<ActionEntity> actionlist = new List<ActionEntity>();
            ActionEntity actionEntity = new ActionEntity();
            actionEntity.OpenType = 0;
            actionEntity.ActionUrl = "";
            actionEntity.ActionFun = "Search";
            actionEntity.PageIco = "fa fa-search";
            actionEntity.ActionName = "查询";
            actionlist.Add(actionEntity);
            //ActionEntity actionEntity1 = new ActionEntity();
            //actionEntity1.OpenType = 0;
            //actionEntity1.ActionUrl = "";
            //actionEntity1.ActionFun = "Add";
            //actionEntity1.PageIco = "fa fa-plus";
            //actionEntity1.ActionName = "新增";
            //actionlist.Add(actionEntity1);
            //ActionEntity actionEntity2 = new ActionEntity();
            //actionEntity2.OpenType = 0;
            //actionEntity2.ActionUrl = "";
            //actionEntity2.ActionFun = "Print";
            //actionEntity2.PageIco = "fa fa-print";
            //actionEntity2.ActionName = "打印";
            //actionlist.Add(actionEntity2);
            ViewData["ActionInfo"] = actionlist;
            ViewBag.Topictype1 = Topictype;
            ViewBag.Zhishitype1 = Zhishitype;
            ViewBag.topictype = _liaotianService.GetSYScode("expert_test_topic", "topictype").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
            ViewBag.zhishitype = _liaotianService.GetSYScode("expert_test_topic", "zhishitype").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
            ViewBag.zhongdian = _liaotianService.GetSYScode("system", "shifou").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
            ViewBag.jiexi_status = _liaotianService.GetSYScode("expert_test_topic", "jiexi_status").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
            ViewBag.shenpi_status = _liaotianService.GetSYScode("expert_test_topic", "shenpi_status").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
            var areaDTOs = _areaService.GetList().Where(x => x.ParentId == "0     ").ToList();
            foreach (var areaDTO in areaDTOs)
            {
                if (areaDTO.CodeId == "510000")
                {
                    areaDTOs.Remove(areaDTO);
                    break;
                }
            }
            var areaDTOsic = new AreaDTO();
            areaDTOsic.CodeId = "510000";
            areaDTOsic.Name = "四川省";
            areaDTOsic.ParentId = "0     ";
            areaDTOs.Insert(1, areaDTOsic);
            ViewBag.Area = areaDTOs.Select(x => new { code = x.CodeId, label = x.Name }).ToList(); ;
            return View();
        }
    }
}