抓取的项目， 已确认，未确认 未确认为橙色 客户档案管理 有无手机号，未确认为橙色 客户资料页面查看访问记录

username@email.com

2022-11-14 439f10462e6b1ab0ebd454f53c2156c6fab24266

抓取的项目，      已确认，未确认  未确认为橙色
客户档案管理       有无手机号，未确认为橙色
客户资料页面查看访问记录

 zhengcaioa/DTO/CooperVisitDTO.cs

@@ -27,6 +27,7 @@
        public string JyName { get; set; }
        public string RecStatus { get; set; }
        public string Creater { get; set; }
        public string CreaterName { get; set; }
        public DateTime Createtime { get; set; }
        public string Modifier { get; set; }
        public DateTime Modifytime { get; set; }

 zhengcaioa/DTO/IntentionCustomerDTO.cs

@@ -88,5 +88,7 @@

        public string Shifouweixin { get; set; }

        public string ShifouDianhua { get; set; }

    }
}

 zhengcaioa/DTO/ProjectDTO.cs

@@ -188,6 +188,7 @@
        public string Baojiachaxiaoyu { get; set; }

        public string Chuanbiaofenxi { get; set; }
        public string Shifouqueren { get; set; }

    }
}

 zhengcaioa/Services/CooperVisitService.cs

@@ -161,7 +161,10 @@
                             //join h in _context.Areas on zz.City equals h.CodeId
                             //join i in _context.Areas on zz.AreaId equals i.CodeId


                         join zzz in _context.PltUsers.Where(x => x.RecStatus == "A")
                        on a.Creater equals zzz.Id
                        into zsssss
                         from zzzzz in zsssss.DefaultIfEmpty()


                         where a.RecStatus == "A"
@@ -198,7 +201,7 @@
                             Jy = a.Jy,
                             Creater = a.Creater,
                             Createtime = a.Createtime,

                             CreaterName = zzzzz.UserName,
                             RecStatus = a.RecStatus,
                             Modifier = a.Modifier,
                             Modifytime = a.Modifytime,

 zhengcaioa/Services/IntentionCustomerService.cs

@@ -302,6 +302,19 @@
            {
                query = query.Where( a=>a.Shifoutianjiaweixin == searchEntity.Shifouweixin.Trim()).ToList();
            }
            if (!string.IsNullOrWhiteSpace(searchEntity.ShifouDianhua))
            {
                if (searchEntity.ShifouDianhua != "A")
                {
                    query = query.Where(a => a.Tel == null ||  a.Tel == "").ToList();
                }
                else
                {
                    query = query.Where(a => a.Tel != null && a.Tel != "").ToList();
                }
                
            }
            

        //if (searchEntity.totalrows == 0)
            searchEntity.totalrows = query.Count();

 zhengcaioa/Services/ProjectService.cs

@@ -99,6 +99,7 @@
                    if (updateproject.Creater == "111")
                    {
                        updateproject.Creater = project.Modifier;
                        updateproject.Createtime = project.Modifytime;
                    }

                }
@@ -468,6 +469,20 @@
               

            }
            if (!string.IsNullOrWhiteSpace(searchEntity.Shifouqueren))
            {
                if (searchEntity.Shifouqueren == "A")
                {
                    sql.Append(" and a.creater  != '111' ");
                }
                else
                {
                    sql.Append(" and a.creater  = '111' ");
                }


            }
            

            DateTime StartTimestarstart = DateTime.Now;
            DateTime StartTimestarend = DateTime.Now;

 zhengcaioa/zhengcaioa/Controllers/Customer/CooperatecustomCustomerController.cs

@@ -30,11 +30,12 @@
        private readonly IHrDeptService _hrDeptService;
        private readonly ISysAttachmentService _sysAttachmentService;
        private readonly IPltPageService _pltPageService;

        private readonly ICooperVisitService _cooperVisitService;

        public CooperatecustomCustomerController(ILogger<CooperatecustomCustomerController> logger, IProjectService projectService, ILiaotianService liaotianService, ICooperatecustomCustomerService cooperatecustomCustomerService, IUserService userService, IHrDeptService hrDeptService
            , ISysAttachmentService sysAttachmentService
              , IPltPageService pltPageService)
              , IPltPageService pltPageService
             , ICooperVisitService cooperVisitService)
        {
            _logger = logger;
            _projectService = projectService;
@@ -44,6 +45,7 @@
            _hrDeptService = hrDeptService;
            _sysAttachmentService = sysAttachmentService;
            _pltPageService = pltPageService;
            _cooperVisitService = cooperVisitService;
        }

        public IActionResult Index()
@@ -183,6 +185,13 @@
            {
                cooperatecustomCustomerDTO = _cooperatecustomCustomerService.Get(id);


                CooperVisitDTOSearch searchEntity = new CooperVisitDTOSearch();
                searchEntity.page = 1;
                searchEntity.rows = 1000;
                searchEntity.Viscustomer = id;
                var resultDataEntity = _cooperVisitService.SearchByPaging(searchEntity);
                ViewData["visitlishi"] = resultDataEntity.DataList;
            }
            else
            {
@@ -192,6 +201,8 @@
                cooperatecustomCustomerDTO.City = "510100";
                cooperatecustomCustomerDTO.AreaId = "510107";
                 
                ViewData["visitlishi"] = new List<CooperVisitDTO>();

            }

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

 zhengcaioa/zhengcaioa/Controllers/Customer/IntentionCustomerController.cs

@@ -36,10 +36,11 @@
        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, IPltPageService pltPageService)
            , ICooperatecustomCustomerService cooperatecustomCustomerService, IMapper mapper, IHrDeptService hrDeptService, IPltPageService pltPageService
            , IIntentionVisitService intentionVisitService)
        {
            _logger = logger;
            _projectService = projectService;
@@ -50,6 +51,7 @@
            _mapper = mapper;
            _hrDeptService = hrDeptService;
            _pltPageService = pltPageService;
            _intentionVisitService = intentionVisitService;
        }

        public IActionResult Index()
@@ -394,6 +396,12 @@
            {
                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
            {
@@ -404,6 +412,8 @@
                intentionCustomerDTO.AreaId = "510107";
                intentionCustomerDTO.Name = namecus;

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

            }

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

 zhengcaioa/zhengcaioa/Views/CooperatecustomCustomer/Edit.cshtml

@@ -12,6 +12,8 @@
    List<SysCodeDtl> hyfl = ViewData["hyfl"] as List<SysCodeDtl>; //行业分类
    List<HrDeptDTO> DeptId = ViewData["DeptId"] as List<HrDeptDTO>; //部门

    List<CooperVisitDTO> visitlishi = ViewData["visitlishi"] as List<CooperVisitDTO>; //合作客户 


    ResultDataEntity<SysAttachmentDTO> yinyezhizhao = ViewBag.yinyezhizhao as ResultDataEntity<SysAttachmentDTO>; //营业执照
    List<SysAttachmentDTO> yinyezhizhaosssss = new List<SysAttachmentDTO>();
@@ -83,6 +85,19 @@
        .col-md-1.control-label {
            padding-right: 0px;
            font-weight: 400;
        }

        table {
            border-collapse: collapse;
            border: none;
            width: 900px;
            margin-left: 0px;
            text-align: center;
        }

        td {
            border: solid #000000 1px;
            height: 30px;
        }
    </style>

@@ -529,6 +544,51 @@
                                    }

                                </div>


                                <div class="clearfix layer-area" style="padding-bottom:15px;">
                                    @if (visitlishi.Count > 0)
                                    {
                                        <table class="col-sm-12 col-md-12">
                                            @{
                                                int i = 1;
                                            }
                                            <tr>
                                                <td style="width:4%;">  编号</td>
                                                <td style="width:7%;"> 拜访时间</td>

                                                <td style="width:14%;"> 客户单位</td>
                                                <td style="width:7%;"> 拜访方式</td>
                                                <td style="width:7%;"> 接待人</td>
                                                <td style="width:7%;"> 职务</td>
                                                <td style="width:14%;"> 交谈类容</td>
                                                <td style="width:14%;"> 客户反馈</td>
                                                <td style="width:7%;"> 成交意向</td>
                                                <td style="width:7%;"> 跟踪建议</td>
                                                <td style="width:7%;"> 访问人</td>
                                            </tr>
                                            @foreach (var visitDTO in visitlishi)
                                            {
                                                <tr>
                                                    <td>  @i</td>
                                                    <td>   @visitDTO.VistimeName</td>
                                                    <td>   @visitDTO.Name</td>
                                                    <td>   @visitDTO.VisTypeName</td>
                                                    <td>   @visitDTO.Jdr</td>
                                                    <td>   @visitDTO.ZwName</td>
                                                    <td>   @visitDTO.Talk</td>
                                                    <td>   @visitDTO.Khfk</td>
                                                    <td>   @visitDTO.YxName</td>
                                                    <td>   @visitDTO.JyName</td>
                                                    <td>   @visitDTO.CreaterName</td>
                                                </tr>

                                                i++;
                                            }
                                        </table>
                                    }
                                </div>

                            </div>
                        </div>
                    </div>

 zhengcaioa/zhengcaioa/Views/IntentionCustomer/Edit.cshtml

@@ -14,7 +14,7 @@

    List<PageEntity> ActionInfo2 = ViewData["ActionInfo2"] as List<PageEntity>;


    List<IntentionVisitDTO> visitlishi = ViewData["visitlishi"] as List<IntentionVisitDTO>; //意向客户 
    //string[] arrJobLevel = (Model.Zhuanjia ?? "").Split(',');

}
@@ -68,6 +68,18 @@
        .col-md-1.control-label {
            padding-right: 0px;
            font-weight: 400;
        }
        table {
            border-collapse: collapse;
            border: none;
            width: 900px;
            margin-left: 0px;
            text-align: center;
        }

        td {
            border: solid #000000 1px;
            height: 30px;
        }
    </style>

@@ -447,6 +459,51 @@
                                        <textarea class="form-control bt" id="Remark" name="Remark" title="备注" isempty="" maxlength="4000" length="long">@Model.Remark</textarea>
                                    </div>
                                </div>

                                <div class="clearfix layer-area" style="padding-bottom:15px;">
                                    @if (visitlishi.Count > 0)
                                    {
                                        <table class="col-sm-12 col-md-12">
                                            @{
                                                int i = 1;
                                            }
                                            <tr>
                                                <td style="width:4%;">  编号</td>
                                                <td style="width:7%;"> 拜访时间</td>

                                                <td style="width:14%;"> 客户单位</td>
                                                <td style="width:7%;"> 拜访方式</td>
                                                <td style="width:7%;"> 接待人</td>
                                                <td style="width:7%;"> 职务</td>
                                                <td style="width:14%;"> 交谈类容</td>
                                                <td style="width:14%;"> 客户反馈</td>
                                                <td style="width:7%;"> 成交意向</td>
                                                <td style="width:7%;"> 跟踪建议</td>
                                                <td style="width:7%;"> 访问人</td>
                                            </tr>
                                            @foreach (var visitDTO in visitlishi)
                                            {
                                                <tr>
                                                    <td>  @i</td>
                                                    <td>   @visitDTO.VistimeName</td>
                                                    <td>   @visitDTO.Name</td>
                                                    <td>   @visitDTO.VisTypeName</td>
                                                    <td>   @visitDTO.Jdr</td>
                                                    <td>   @visitDTO.ZwName</td>
                                                    <td>   @visitDTO.Talk</td>
                                                    <td>   @visitDTO.Khfk</td>
                                                    <td>   @visitDTO.YxName</td>
                                                    <td>   @visitDTO.JyName</td>
                                                    <td>   @visitDTO.CreaterName</td>
                                                </tr>

                                                i++;
                                            }
                                        </table>
                                    }
                                </div>


                            </div>
                        </div>
                    </div>

 zhengcaioa/zhengcaioa/Views/IntentionCustomer/Index.cshtml

@@ -28,7 +28,11 @@
            {
                label: '客户单位', name: 'Name', labtype: 'txt', hidden: false, width: 400,
                formatter: function (cellvalue, options, rowObject) {
                    return "<a onclick=\"OpenWindow('" + cellvalue.replace(/'/g, '') + "','98%','100%', '/IntentionCustomer/Edit?id=" + rowObject.Id + "')\"  >" + cellvalue + "</a>";
                    var color = "";
                    if (rowObject.Tel == null || rowObject.Tel == '') {
                            color = "orange";
                        }
                    return "<a onclick=\"OpenWindow('" + cellvalue.replace(/'/g, '') + "','98%','100%', '/IntentionCustomer/Edit?id=" + rowObject.Id + "')\"  ><span style='color:" + color + ";'>" + cellvalue + "</span></a>";
                }
            },

@@ -60,7 +64,7 @@
            { label: '建档时间', name: 'Createtime', labtype: 'datearea', hidden: false },
            { label: '录入人', name: 'Creater', labtype: 'combox', hidden: false, data: JSON.parse(Creater), cwidth: '5%', cccwidth: '8%' },
            { label: '是否加微信', name: 'Shifouweixin', labtype: 'combox', hidden: false, data: JSON.parse(shifou), cwidth: '5%', cccwidth: '8%' },

            { label: '是否录入电话', name: 'ShifouDianhua', labtype: 'combox', hidden: false, data: JSON.parse(shifou), cwidth: '5%', cccwidth: '8%' },


        ];

 zhengcaioa/zhengcaioa/Views/Project/Select.cshtml

@@ -36,6 +36,9 @@
                    if (rowObject.Fblx != null && rowObject.Fblx != '') {
                        color = "red";
                    }
                    if (rowObject.Creater != null && rowObject.Creater == '111') {
                        color = "orange";
                    }

                    return "<a onclick=\"OpenWindow('" + cellvalue + "','98%','100%', '/Project/Add?id=" + rowObject.Id + "')\"  ><span style='color:" + color + ";'>" + cellvalue + "</span></a>";
                }
@@ -143,7 +146,7 @@
            { label: '分差大于', name: 'Fenchadayu', labtype: 'txt', hidden: false/*, cwidth: '8.5%', cccwidth: '15%' */ },
            { label: '供应商数量', name: 'Shuliang', labtype: 'txt', hidden: false/*, cwidth: '8.5%', cccwidth: '15%' */ },
            //{ label: '价差小于', name: 'Baojiachaxiaoyu', labtype: 'txt', hidden: false/*, cwidth: '8.5%', cccwidth: '15%' */ },

            { label: '是否确认', name: 'Shifouqueren',  labtype: 'combox', hidden: false, data: JSON.parse(flbx) },


        ];