会员发送app后台消息

username@email.com

2023-03-27 0d96ff4e0833d6a2813a969e1ae0a48f27eee497

 zhengcaioa/zhengcaioa/Controllers/Customer/IntentionCustomerController.cs

@@ -15,6 +15,13 @@
using System.Threading.Tasks;
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
{
@@ -29,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;
@@ -41,9 +51,161 @@
            _cooperatecustomCustomerService = cooperatecustomCustomerService;
            _mapper = mapper;
            _hrDeptService = hrDeptService;
            _pltPageService = pltPageService;
            _intentionVisitService = intentionVisitService;
        }

        public IActionResult Index()
        {
            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 = "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 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 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();

            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.Baomingtimebegin = DateTime.Now.AddMonths(-6).ToString("yyyy-MM-dd");
            ViewBag.Baomingtimeend = DateTime.Now.ToString("yyyy-MM-dd");

            return View();

        }

        public IActionResult GetList(IntentionCustomerDTOSearch search)
        {
            //JsonResult jsonResult =   new JsonResult(_liaotianService.SearchByPaging(search), new Newtonsoft.Json.Serialization.DefaultContractResolver());
            return new JsonResult(_intentionCustomerService.SearchByPaging(search));
        }




        public IActionResult Indexhuiyuan()
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
@@ -55,95 +217,494 @@
            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 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 = "转移客户";
            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 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 actionEntity6 = new ActionEntity();
            actionEntity6.OpenType = 0;
            actionEntity6.ActionUrl = "";
            actionEntity6.ActionFun = "Xinhan";
            actionEntity6.PageIco = "";
            actionEntity6.ActionName = "商业信函";
            actionlist.Add(actionEntity6);


            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("CooperatecustomCustomer", "khly").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.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");

            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 GetList(IntentionCustomerDTOSearch search)

        public IActionResult GetListSelectHuiyuan(CooperatecustomCustomerDTOSearch search)
        {
            //JsonResult jsonResult =   new JsonResult(_liaotianService.SearchByPaging(search), new Newtonsoft.Json.Serialization.DefaultContractResolver());
            return new JsonResult(_intentionCustomerService.SearchByPaging(search));
 
                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();

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


            ViewBag.ywjlId = curentuser.Id;

            //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();
            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
            {
@@ -154,15 +715,31 @@
                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(); ;

            ViewData["khlx"] = _liaotianService.GetSYScode("CooperatecustomCustomer", "khlx");
            ViewData["khly"] = _liaotianService.GetSYScode("CooperatecustomCustomer", "khly");
            ViewData["khly"] = _liaotianService.GetSYScode("IntentionCustomer", "khly");
            ViewData["hyfl"] = _liaotianService.GetSYScode("CooperatecustomCustomer", "hyfl");

            ViewData["users"] = users;
@@ -187,15 +764,29 @@
             
                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(); ;

            ViewData["khlx"] = _liaotianService.GetSYScode("CooperatecustomCustomer", "khlx");
            ViewData["khly"] = _liaotianService.GetSYScode("CooperatecustomCustomer", "khly");
            ViewData["khly"] = _liaotianService.GetSYScode("IntentionCustomer", "khly");
            ViewData["hyfl"] = _liaotianService.GetSYScode("CooperatecustomCustomer", "hyfl");

            ViewData["users"] = users;
@@ -222,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;
@@ -274,31 +897,39 @@
                resultEntity.Result = false;
                resultEntity.Message = "没有找到客户!";
            }
          
         
            if (result != null && result.Count > 0)
             using(TransactionScope scope = new TransactionScope())
            {
                for (int i = 0; i < result.Count; i++)
                if (result != null && result.Count > 0)
                {
                    var dto = _mapper.Map<CooperatecustomCustomerDTO>(result[i]);
                    dto.Id = "";
                    dto.Creater = curentuser.Id;
                    dto.Modifier = curentuser.Id;
                    dto.Createtime = DateTime.Now;
                    dto.Modifytime = dto.Createtime;
                    dto.zhuanyi = true;
                    resultEntity =  _cooperatecustomCustomerService.save(dto);
                    if (!resultEntity.Result)
                    for (int i = 0; i < result.Count; i++)
                    {
                        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 = "";
                        dto.Creater = curentuser.Id;
                        dto.Modifier = curentuser.Id;
                        dto.Createtime = DateTime.Now;
                        dto.Modifytime = dto.Createtime;
                        dto.zhuanyi = true;
                        resultEntity = _cooperatecustomCustomerService.save(dto);
                        if (!resultEntity.Result)
                        {
                            return new JsonResult(resultEntity);
                        }
                    }
                }
                

                scope.Complete();
            }
            else
            {
                resultEntity.Result = false;
                resultEntity.Message = "无联系人号码";
            }
         
            

            

@@ -312,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>;