政采招标oa系统
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
username@email.com
2023-03-27 0d96ff4e0833d6a2813a969e1ae0a48f27eee497 
 zhengcaioa/zhengcaioa/Controllers/Customer/IntentionCustomerController.cs


@@ -16,6 +16,12 @@


using zhengcaioa.Models;


using zhengcaioa.IService;


using System.Transactions;


using OfficeOpenXml;


using OfficeOpenXml.Drawing;


using OfficeOpenXml.Drawing.Chart;


using OfficeOpenXml.Style;


using System.IO;


using DTO.zcUserInfoN_db;




namespace zhengcaioa.Controllers.Customer


{


@@ -30,9 +36,12 @@


        private readonly ICooperatecustomCustomerService _cooperatecustomCustomerService;


        private readonly IMapper _mapper;


        private readonly IHrDeptService _hrDeptService;


        private readonly IPltPageService _pltPageService;


        private readonly IIntentionVisitService _intentionVisitService;






        public IntentionCustomerController(ILogger<IntentionCustomerController> logger, IProjectService projectService, ILiaotianService liaotianService, IIntentionCustomerService intentionCustomerService, IUserService userService, ICooperatecustomCustomerService cooperatecustomCustomerService, IMapper mapper, IHrDeptService hrDeptService)


        public IntentionCustomerController(ILogger<IntentionCustomerController> logger, IProjectService projectService, ILiaotianService liaotianService, IIntentionCustomerService intentionCustomerService, IUserService userService


            , ICooperatecustomCustomerService cooperatecustomCustomerService, IMapper mapper, IHrDeptService hrDeptService, IPltPageService pltPageService


            , IIntentionVisitService intentionVisitService)


        {


            _logger = logger;


            _projectService = projectService;


@@ -42,6 +51,8 @@


            _cooperatecustomCustomerService = cooperatecustomCustomerService;


            _mapper = mapper;


            _hrDeptService = hrDeptService;


            _pltPageService = pltPageService;


            _intentionVisitService = intentionVisitService;


        }




        public IActionResult Index()


@@ -49,82 +60,138 @@


            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 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 = "Zhuanyi";


            actionEntity2.PageIco = "fa fa-exchange";


            actionEntity2.ActionName = "转移客户";


            actionlist.Add(actionEntity2);


            //ActionEntity actionEntity2 = new ActionEntity();


            //actionEntity2.OpenType = 0;


            //actionEntity2.ActionUrl = "";


            //actionEntity2.ActionFun = "Zhuanyi";


            //actionEntity2.PageIco = "fa fa-exchange";


            //actionEntity2.ActionName = "转移客户";


            //actionlist.Add(actionEntity2);




            ActionEntity actionEntity3 = new ActionEntity();


            actionEntity3.OpenType = 0;


            actionEntity3.ActionUrl = "";


            actionEntity3.ActionFun = "Print";


            actionEntity3.PageIco = "fa fa-print";


            actionEntity3.ActionName = "打印资料";


            actionlist.Add(actionEntity3);


            //ActionEntity actionEntity3 = new ActionEntity();


            //actionEntity3.OpenType = 0;


            //actionEntity3.ActionUrl = "";


            //actionEntity3.ActionFun = "Print";


            //actionEntity3.PageIco = "fa fa-print";


            //actionEntity3.ActionName = "打印资料";


            //actionlist.Add(actionEntity3);








            ActionEntity actionEntity4 = new ActionEntity();


            actionEntity4.OpenType = 0;


            actionEntity4.ActionUrl = "";


            actionEntity4.ActionFun = "Duanxin";


            actionEntity4.PageIco = "";


            actionEntity4.ActionName = "群发短信";


            actionlist.Add(actionEntity4);


            //ActionEntity actionEntity4 = new ActionEntity();


            //actionEntity4.OpenType = 0;


            //actionEntity4.ActionUrl = "";


            //actionEntity4.ActionFun = "Duanxin";


            //actionEntity4.PageIco = "";


            //actionEntity4.ActionName = "群发短信";


            //actionlist.Add(actionEntity4);






            ActionEntity actionEntity5 = new ActionEntity();


            actionEntity5.OpenType = 0;


            actionEntity5.ActionUrl = "";


            actionEntity5.ActionFun = "Youjian";


            actionEntity5.PageIco = "";


            actionEntity5.ActionName = "群发邮件";


            actionlist.Add(actionEntity5);


            //ActionEntity actionEntity5 = new ActionEntity();


            //actionEntity5.OpenType = 0;


            //actionEntity5.ActionUrl = "";


            //actionEntity5.ActionFun = "Youjian";


            //actionEntity5.PageIco = "";


            //actionEntity5.ActionName = "群发邮件";


            //actionlist.Add(actionEntity5);








            ActionEntity actionEntity6 = new ActionEntity();


            actionEntity6.OpenType = 0;


            actionEntity6.ActionUrl = "";


            actionEntity6.ActionFun = "Xinhan";


            actionEntity6.PageIco = "";


            actionEntity6.ActionName = "商业信函";


            actionlist.Add(actionEntity6);


            //ActionEntity actionEntity6 = new ActionEntity();


            //actionEntity6.OpenType = 0;


            //actionEntity6.ActionUrl = "";


            //actionEntity6.ActionFun = "Xinhan";


            //actionEntity6.PageIco = "";


            //actionEntity6.ActionName = "商业信函";


            //actionlist.Add(actionEntity6);






            //ActionEntity actionEntity7 = new ActionEntity();


            //actionEntity7.OpenType = 0;


            //actionEntity7.ActionUrl = "";


            //actionEntity7.ActionFun = "Daochu";


            //actionEntity7.PageIco = "";


            //actionEntity7.ActionName = "导出";


            //actionlist.Add(actionEntity7);






            var pageEntities = _pltPageService.GetUserPage(curentuser.Id, "/IntentionCustomer/Index/");


            var pageEntities1 = pageEntities.Where(x => x.PageMethod == "01").ToList();


            if (pageEntities1.Count(x => x.PageShortcut == "Search") <= 0)


            {


                ActionEntity actionEntity = new ActionEntity();


                actionEntity.OpenType = 0;


                actionEntity.ActionUrl = "";


                actionEntity.ActionFun = "Search";


                actionEntity.PageIco = "fa fa-search";


                actionEntity.ActionName = "查询";


                actionlist.Add(actionEntity);




                ViewData["Creater11"] = curentuser.Id;


            }


            var pageEntities2 = pageEntities.Where(x => x.PageMethod == "02").ToList();




            foreach (var pageEntity in pageEntities1)


            {


                ActionEntity actionEntity1 = new ActionEntity();


                actionEntity1.OpenType = pageEntity.OpenType;


                actionEntity1.ActionUrl = "";


                actionEntity1.ActionFun = pageEntity.PageShortcut;


                actionEntity1.PageIco = pageEntity.PageIco;


                actionEntity1.ActionName = pageEntity.PageName;


                actionlist.Add(actionEntity1);


            }


            ViewData["ActionInfo"] = actionlist;




            ViewData["ActionInfo2"] = pageEntities2;




            ViewBag.khlx = _liaotianService.GetSYScode("CooperatecustomCustomer", "khlx").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();


            ViewBag.khly = _liaotianService.GetSYScode("IntentionCustomer", "khly").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();


            ViewBag.hyfl = _liaotianService.GetSYScode("CooperatecustomCustomer", "hyfl").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();




            ViewBag.users = _userService.GetList().Where(x => x.IsYwjl == "A").Select(x => new { code = x.Id, label = x.UserName }).ToList();


            var users = _userService.GetList().Where(x => x.IsYwjl == "A").Select(x => new { code = x.Id, label = x.UserName }).ToList();


            users.Insert(0, new { code = "11111", label = "无业务经理" });




            ViewBag.users = users;




            ViewBag.Creater = _userService.GetList().Select(x => new { code = x.Id, label = x.UserName }).ToList();




            ViewBag.shifou = _liaotianService.GetSYScode("system", "shifou").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();






            var areaDTOs = _projectService.Getsheng().ToList();


            foreach (var areaDTO in areaDTOs)


            {


                if (areaDTO.CodeId == "510000")


                {


                    areaDTOs.Remove(areaDTO);


                    break;


                }


            }


            var areaDTOsic = new Area();


            areaDTOsic.CodeId = "510000";


            areaDTOsic.Name = "四川省";


            areaDTOsic.ParentId = "0     ";


            areaDTOs.Insert(1, areaDTOsic);


            ViewBag.ShengDropDown = areaDTOs.Select(x => new { code = x.CodeId, label = x.Name }).ToList();




            ViewBag.ShengDropDown = _projectService.Getsheng().Select(x => new { code = x.CodeId, label = x.Name }).ToList();


            ViewBag.Baomingtimebegin = DateTime.Now.AddMonths(-6).ToString("yyyy-MM-dd");


            ViewBag.Baomingtimeend = DateTime.Now.ToString("yyyy-MM-dd");




            return View();




        }


@@ -136,7 +203,9 @@


        }






        public IActionResult IndexYiXiang()






        public IActionResult Indexhuiyuan()


        {


            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));


            ViewData["curentuser"] = curentuser;


@@ -148,11 +217,428 @@


            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);


 


            ViewData["ActionInfo"] = actionlist;


           


 




            ViewBag.shifou = _liaotianService.GetSYScode("system", "shifou").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();






             




            ViewBag.Baomingtimebegin = DateTime.Now.AddMonths(-6).ToString("yyyy-MM-dd");


            ViewBag.Baomingtimeend = DateTime.Now.ToString("yyyy-MM-dd");




            return View();




        }




        public IActionResult GetListhuiyuan(FrameworkUserSearch search)


        {


            //JsonResult jsonResult =   new JsonResult(_liaotianService.SearchByPaging(search), new Newtonsoft.Json.Serialization.DefaultContractResolver());


            return new JsonResult(_cooperatecustomCustomerService.SearchByPagingGuanlianHuiyuan(search));


        }






        public IActionResult Indexhuiyuanchakantongshi(string CustomerId)


        {


            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);




            ViewData["ActionInfo"] = actionlist;




            ViewBag.CustomerId = CustomerId;




            //ViewBag.shifou = _liaotianService.GetSYScode("system", "shifou").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();










            //ViewBag.Baomingtimebegin = DateTime.Now.AddMonths(-6).ToString("yyyy-MM-dd");


            //ViewBag.Baomingtimeend = DateTime.Now.ToString("yyyy-MM-dd");




            return View();




        }




        public IActionResult GetListhuiyuanchakantongshi(string CustomerId)


        {


            //JsonResult jsonResult =   new JsonResult(_liaotianService.SearchByPaging(search), new Newtonsoft.Json.Serialization.DefaultContractResolver());


            return new JsonResult(_cooperatecustomCustomerService.GetListFrameworkUser(CustomerId));


        }




        public IActionResult IndexSelectHuiyuan(string Huiyuanid, string CustomerId)


        {


            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 actionEntity2 = new ActionEntity();


            actionEntity2.OpenType = 0;


            actionEntity2.ActionUrl = "";


            actionEntity2.ActionFun = "Zhuanyi";


            actionEntity2.PageIco = "fa fa-exchange";


            actionEntity2.ActionName = "确认";


            actionlist.Add(actionEntity2);






            ViewData["ActionInfo"] = actionlist;


            //ViewData["ActionInfo2"] = pageEntities2;




            ViewBag.khlx = _liaotianService.GetSYScode("CooperatecustomCustomer", "khlx").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();


            ViewBag.khly = _liaotianService.GetSYScode("IntentionCustomer", "khly").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();


            ViewBag.hyfl = _liaotianService.GetSYScode("CooperatecustomCustomer", "hyfl").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();




            ViewBag.users = _userService.GetList().Where(x => x.IsYwjl == "A").Select(x => new { code = x.Id, label = x.UserName }).ToList();




            ViewBag.Creater = _userService.GetList().Select(x => new { code = x.Id, label = x.UserName }).ToList();




            ViewBag.shifou = _liaotianService.GetSYScode("system", "shifou").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();






            var areaDTOs = _projectService.Getsheng().ToList();


            foreach (var areaDTO in areaDTOs)


            {


                if (areaDTO.CodeId == "510000")


                {


                    areaDTOs.Remove(areaDTO);


                    break;


                }


            }


            var areaDTOsic = new Area();


            areaDTOsic.CodeId = "510000";


            areaDTOsic.Name = "四川省";


            areaDTOsic.ParentId = "0     ";


            areaDTOs.Insert(1, areaDTOsic);


            ViewBag.ShengDropDown = areaDTOs.Select(x => new { code = x.CodeId, label = x.Name }).ToList();




            ViewBag.Baomingtimebegin = DateTime.Now.AddMonths(-6).ToString("yyyy-MM-dd");


            ViewBag.Baomingtimeend = DateTime.Now.ToString("yyyy-MM-dd");




            ViewBag.Customertype = _liaotianService.GetSYScode("ADM_Askzczbwsydtl", "Customertype").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();




            ViewBag.Huiyuanid = Huiyuanid;


            ViewBag.CustomerId = CustomerId;


            


            return View();




        }






        public IActionResult GetListSelectHuiyuan(CooperatecustomCustomerDTOSearch search)


        {


            //JsonResult jsonResult =   new JsonResult(_liaotianService.SearchByPaging(search), new Newtonsoft.Json.Serialization.DefaultContractResolver());


 


                return new JsonResult(_cooperatecustomCustomerService.SearchByPagingAll(search));


            




        }






        /// <summary>


        /// 保存


        /// </summary>


        /// <param name="data">岗位实体类对象</param>


        /// <returns></returns>


        /// 


        [HttpPost]


        public IActionResult Savezaizhiqiye(string CustomerId,string Huiyuanid,string khlx, string CustomerIddel)


        {


            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));


            ViewData["curentuser"] = curentuser;


            CustomerGuanlianhuiyuan DTO = new CustomerGuanlianhuiyuan();


            DTO.Huiyuanid = Huiyuanid;


            DTO.Customerid = CustomerId;


            DTO.Customertype = khlx;


            if (String.IsNullOrEmpty(DTO.Id))


            {


                DTO.Creater = curentuser.Id;


                DTO.Createtime = DateTime.Now;


            }


            DTO.Modifier = curentuser.Id;


            DTO.Modifytime = DateTime.Now;


            ResultEntity resultEntity = _cooperatecustomCustomerService.saveCustomerGuanlian(DTO, CustomerIddel);








 




            return new JsonResult(resultEntity);


        }








        public IActionResult IndexSelect()


        {


            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 actionEntity2 = new ActionEntity();


            actionEntity2.OpenType = 0;


            actionEntity2.ActionUrl = "";


            actionEntity2.ActionFun = "Zhuanyi";


            actionEntity2.PageIco = "fa fa-exchange";


            actionEntity2.ActionName = "确认";


            actionlist.Add(actionEntity2);






            ViewData["ActionInfo"] = actionlist;


            //ViewData["ActionInfo2"] = pageEntities2;




            ViewBag.khlx = _liaotianService.GetSYScode("CooperatecustomCustomer", "khlx").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();


            ViewBag.khly = _liaotianService.GetSYScode("IntentionCustomer", "khly").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();


            ViewBag.hyfl = _liaotianService.GetSYScode("CooperatecustomCustomer", "hyfl").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();




            ViewBag.users = _userService.GetList().Where(x => x.IsYwjl == "A").Select(x => new { code = x.Id, label = x.UserName }).ToList();




            ViewBag.Creater = _userService.GetList().Select(x => new { code = x.Id, label = x.UserName }).ToList();




            ViewBag.shifou = _liaotianService.GetSYScode("system", "shifou").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();






            var areaDTOs = _projectService.Getsheng().ToList();


            foreach (var areaDTO in areaDTOs)


            {


                if (areaDTO.CodeId == "510000")


                {


                    areaDTOs.Remove(areaDTO);


                    break;


                }


            }


            var areaDTOsic = new Area();


            areaDTOsic.CodeId = "510000";


            areaDTOsic.Name = "四川省";


            areaDTOsic.ParentId = "0     ";


            areaDTOs.Insert(1, areaDTOsic);


            ViewBag.ShengDropDown = areaDTOs.Select(x => new { code = x.CodeId, label = x.Name }).ToList();




            ViewBag.Baomingtimebegin = DateTime.Now.AddMonths(-6).ToString("yyyy-MM-dd");


            ViewBag.Baomingtimeend = DateTime.Now.ToString("yyyy-MM-dd");




            ViewBag.Customertype = _liaotianService.GetSYScode("ADM_Askzczbwsydtl", "Customertype").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();






            return View();




        }




        public IActionResult GetListSelect(IntentionCustomerDTOSearch search)


        {


            //JsonResult jsonResult =   new JsonResult(_liaotianService.SearchByPaging(search), new Newtonsoft.Json.Serialization.DefaultContractResolver());




            if(search.Customertype == "01")


            {


                CooperatecustomCustomerDTOSearch search1 = new CooperatecustomCustomerDTOSearch();


                search1.page = search.page;


                search1.rows = search.rows;


                search1.Khly = search.Khly;


                search1.Hyfl = search.Hyfl;


                search1.Khlx = search.Khlx;


                search1.Sheng = search.Sheng;


                search1.City = search.City;


                search1.AreaId = search.AreaId;


                search1.Ywjl = search.Ywjl;


                search1.Name = search.Name;


                search1.Createtime = search.Createtime;


                search1.Shifouweixin = search.Shifouweixin;






                return new JsonResult(_cooperatecustomCustomerService.SearchByPaging(search1));


            }


            else


            {


                return new JsonResult(_intentionCustomerService.SearchByPaging(search));


            }


  


        }








        //[HttpGet("excel")]


        public IActionResult GetDaochu(IntentionCustomerDTOSearch search)


        {


          


            search.page = 1;


            search.rows = 10000;


         var aaa =    _intentionCustomerService.SearchByPaging(search);


          var data1 =   aaa.DataList;




            ExcelPackage.LicenseContext = OfficeOpenXml.LicenseContext.NonCommercial;


            using var ep = new ExcelPackage();




            //添加sheet


            using var worksheet = ep.Workbook.Worksheets.Add("档案客户资料");




           




            int x = 1;


            int y = 1;


            var columnTitles = new List<string>()


            {


                "建档时间","客户来源","行业分类","客户类型","客户名称","客户单位","联系人微信"


                ,"客户地址","网址","联系人座机","联系人手机","联系人QQ","联系人邮箱",




                "联系人2姓名","联系人2手机","联系人2QQ"




            };


            foreach(var columnTitle in columnTitles)


            {


                //设置样式


                var cell = worksheet.Cells[x, y++];


                cell.Style.Font.Bold = true;


                cell.Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;


                cell.Style.VerticalAlignment = ExcelVerticalAlignment.Center;


                cell.Value = columnTitle;


            }


            foreach (var item in data1)


            {


                x++;


                y = 1;


                var cell = worksheet.Cells[x, y++];


                cell.Value = item.CreatetimeName;




                cell = worksheet.Cells[x, y++];


                cell.Value = item.KhlyName;


                cell = worksheet.Cells[x, y++];


                cell.Value = item.HyflName;


                cell = worksheet.Cells[x, y++];


                cell.Value = item.KhlxName;


                cell = worksheet.Cells[x, y++];


                cell.Value = item.Name;


                cell = worksheet.Cells[x, y++];


                cell.Value = item.Name;


                cell = worksheet.Cells[x, y++];


                cell.Value = item.Weixin;


                cell = worksheet.Cells[x, y++];


                cell.Value = item.Address;


                cell = worksheet.Cells[x, y++];


                cell.Value = item.Url;


                cell = worksheet.Cells[x, y++];


                cell.Value = item.Tel;


                cell = worksheet.Cells[x, y++];


                cell.Value = item.Phone;


                cell = worksheet.Cells[x, y++];


                cell.Value = item.Qq;


                cell = worksheet.Cells[x, y++];


                cell.Value = item.Email;


                cell = worksheet.Cells[x, y++];


                cell.Value = item.YwName;


                cell = worksheet.Cells[x, y++];


                cell.Value = item.YwTel;


                cell = worksheet.Cells[x, y++];


                cell.Value = item.YwQq;








            }




            worksheet.Cells[worksheet.Dimension.Address].AutoFitColumns();




            using (var stream = new MemoryStream())


            {


                ep.SaveAs(stream);


                return new FileContentResult(stream.ToArray(),


                "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")


                {


                    FileDownloadName = "导出档案客户资料" + DateTime.Now.ToString("yyyyMMdd") + ".xlsx"


                };


            }










        }






        public IActionResult IndexYiXiang()


        {


            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));


            ViewData["curentuser"] = curentuser;


            List<ActionEntity> actionlist = new List<ActionEntity>();














            var pageEntities = _pltPageService.GetUserPage(curentuser.Id, "/IntentionCustomer/IndexYiXiang/");


            var pageEntities1 = pageEntities.Where(x => x.PageMethod == "01").ToList();


            if (pageEntities1.Count(x => x.PageShortcut == "Search") <= 0)


            {


                ActionEntity actionEntity = new ActionEntity();


                actionEntity.OpenType = 0;


                actionEntity.ActionUrl = "";


                actionEntity.ActionFun = "Search";


                actionEntity.PageIco = "fa fa-search";


                actionEntity.ActionName = "查询";


                actionlist.Add(actionEntity);




                


            }


            var pageEntities2 = pageEntities.Where(x => x.PageMethod == "02").ToList();




            foreach (var pageEntity in pageEntities1)


            {


                ActionEntity actionEntity1 = new ActionEntity();


                actionEntity1.OpenType = pageEntity.OpenType;


                actionEntity1.ActionUrl = "";


                actionEntity1.ActionFun = pageEntity.PageShortcut;


                actionEntity1.PageIco = pageEntity.PageIco;


                actionEntity1.ActionName = pageEntity.PageName;


                actionlist.Add(actionEntity1);


            }


            ViewData["ActionInfo"] = actionlist;


            ViewData["ActionInfo2"] = pageEntities2;






            ViewBag.khly = _liaotianService.GetSYScode("IntentionCustomer", "khly").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();




            ViewBag.ywjl = _userService.GetList().Where(x => x.IsYwjl == "A").Select(x => new { code = x.Id, label = x.UserName }).ToList();


@@ -165,21 +651,60 @@


            //ViewBag.khlx = _liaotianService.GetSYScode("CooperatecustomCustomer", "khlx").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();




            //ViewBag.hyfl = _liaotianService.GetSYScode("CooperatecustomCustomer", "hyfl").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();


            //ViewBag.ShengDropDown = _projectService.Getsheng().Select(x => new { code = x.CodeId, label = x.Name }).ToList();


            return View();




        }




        /// <summary>


        /// 解绑


        /// </summary>


        /// <param name="id"></param>


        /// <returns></returns>


        [HttpPost]


        public JsonResult UnBind(string id)


        {


            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));


            ResultEntity resultEntity = new ResultEntity();


            using (TransactionScope scope = new TransactionScope())


            {


                string[] ids = id.Split(',');


                foreach (var iddd in ids)


                {


                    var intentionCustomerDTO = _intentionCustomerService.Get(iddd);


                    intentionCustomerDTO.Yixiang = null;


                    intentionCustomerDTO.Yixiangtime = null;


                    resultEntity =  _intentionCustomerService.save(intentionCustomerDTO);


                    if (!resultEntity.Result)


                    {


                        return new JsonResult(resultEntity);


                    }


                }




                  


                


                scope.Complete();


            }


            return new JsonResult(resultEntity);


        }




        public IActionResult Edit(string id = null,string namecus = null)


        {


            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));


            ViewData["curentuser"] = curentuser;




            var pageEntities = _pltPageService.GetUserPage(curentuser.Id, "/IntentionCustomer/Index/");


            var pageEntities2 = pageEntities.Where(x => x.PageMethod == "02").ToList();


            ViewData["ActionInfo2"] = pageEntities2;


            IntentionCustomerDTO intentionCustomerDTO = new IntentionCustomerDTO();


            if (!String.IsNullOrEmpty(id))


            {


                intentionCustomerDTO = _intentionCustomerService.Get(id);




                IntentionVisitDTOSearch searchEntity = new IntentionVisitDTOSearch();


                searchEntity.page = 1;


                searchEntity.rows = 1000;


                searchEntity.Viscustomer = id;


                var resultDataEntity = _intentionVisitService.SearchByPaging(searchEntity);


                ViewData["visitlishi"] = resultDataEntity.DataList;


            }


            else


            {


@@ -190,9 +715,25 @@


                intentionCustomerDTO.AreaId = "510107";


                intentionCustomerDTO.Name = namecus;




                ViewData["visitlishi"] = new List<IntentionVisitDTO>();




            }




            var sheng = _projectService.Getsheng();


            var areaDTOs = _projectService.Getsheng().ToList();


            foreach (var areaDTO in areaDTOs)


            {


                if (areaDTO.CodeId == "510000")


                {


                    areaDTOs.Remove(areaDTO);


                    break;


                }


            }


            var areaDTOsic = new Area();


            areaDTOsic.CodeId = "510000";


            areaDTOsic.Name = "四川省";


            areaDTOsic.ParentId = "0     ";


            areaDTOs.Insert(1, areaDTOsic);


            var sheng = areaDTOs;


            var shi = _projectService.Getshi(intentionCustomerDTO.Sheng);


            var quxian = _projectService.Getquxian(intentionCustomerDTO.City);


            var users = _userService.GetList().Where(x => x.IsYwjl == "A").ToList(); ;


@@ -223,9 +764,23 @@


             


                intentionCustomerDTO = _intentionCustomerService.GetByName(name);




            




            var sheng = _projectService.Getsheng();




            var areaDTOs = _projectService.Getsheng().ToList();


            foreach (var areaDTO in areaDTOs)


            {


                if (areaDTO.CodeId == "510000")


                {


                    areaDTOs.Remove(areaDTO);


                    break;


                }


            }


            var areaDTOsic = new Area();


            areaDTOsic.CodeId = "510000";


            areaDTOsic.Name = "四川省";


            areaDTOsic.ParentId = "0     ";


            areaDTOs.Insert(1, areaDTOsic);


            var sheng = areaDTOs;


            var shi = _projectService.Getshi(intentionCustomerDTO.Sheng);


            var quxian = _projectService.Getquxian(intentionCustomerDTO.City);


            var users = _userService.GetList().Where(x => x.IsYwjl == "A").ToList(); ;


@@ -258,10 +813,42 @@


            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));


            ViewData["curentuser"] = curentuser;


            data.RecStatus = "A";


            if (string.IsNullOrEmpty(data.Shifoutianjiaweixin))


            {


                data.Shifoutianjiaweixin = "D";


                data.Weixiner = null;


                data.Weixintime = null;


            }


            else


            {


                if (String.IsNullOrEmpty(data.Id))


                {


                    data.Weixiner = curentuser.Id;


                    data.Weixintime = DateTime.Now;


                }


                else


                {


                    var cooperatecustomCustomerDTO = _intentionCustomerService.Get(data.Id);


                    if (string.IsNullOrEmpty(cooperatecustomCustomerDTO.Weixiner))


                    {


                        data.Weixiner = curentuser.Id;


                        data.Weixintime = DateTime.Now;


                    }




                }


            }


            if (String.IsNullOrEmpty(data.Id))


            {


                data.Creater = curentuser.Id;


                data.Createtime = DateTime.Now;


            }


            else


            {


                var intentionCustomerDTO = _intentionCustomerService.Get(data.Id);


                data.Yixiangtime = intentionCustomerDTO.Yixiangtime;


                data.Yixiang = intentionCustomerDTO.Yixiang;


                data.Dianxiaozhuanyuan = intentionCustomerDTO.Dianxiaozhuanyuan;


                data.Zuijinzhuizongtime = intentionCustomerDTO.Zuijinzhuizongtime;


            }


            data.Modifier = curentuser.Id;


            data.Modifytime = DateTime.Now;


@@ -317,11 +904,11 @@


                    for (int i = 0; i < result.Count; i++)


                    {




                        //resultEntity = _intentionCustomerService.ModifyStatus(result[i].Id, curentuser.Id);


                        //if (!resultEntity.Result)


                        //{


                        //    return new JsonResult(resultEntity);


                        //}


                        resultEntity = _intentionCustomerService.ModifyStatus(result[i].Id, curentuser.Id);


                        if (!resultEntity.Result)


                        {


                            return new JsonResult(resultEntity);


                        }




                        var dto = _mapper.Map<CooperatecustomCustomerDTO>(result[i]);


                        dto.Id = "";


@@ -356,7 +943,7 @@


        public IActionResult print(IntentionCustomerDTOSearch search)


        {


            //JsonResult jsonResult =   new JsonResult(_liaotianService.SearchByPaging(search), new Newtonsoft.Json.Serialization.DefaultContractResolver());


            search.rows = 1000;


            search.rows = 10000;


            search.page = 1;


            ViewBag.listLiaotianDTO = _intentionCustomerService.SearchByPaging(search).DataList as List<IntentionCustomerDTO>;