专家资料查询

username@email.com

2021-11-23 516ba4b650a58c367232273124a1ac966f35b5ca

专家资料查询

 zhengcaioa/DTO/ExpertDTO.cs

@@ -15,6 +15,8 @@
        public string Province { get; set; }
        public string AreaId { get; set; }
        public string City { get; set; }

        public string AreaName { get; set; }
        public string Address { get; set; }
        public string Postal { get; set; }
        public string ExpertType { get; set; }
@@ -36,6 +38,7 @@
        public string Sort { 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; }
@@ -68,6 +71,8 @@
        public int JoinCount { get; set; }

        public string ShenheStatus { get; set; }

        public string Creater { get; set; }
    }
    #endregion


 zhengcaioa/IServices/IExpertService.cs

@@ -15,7 +15,7 @@

        ResultEntity ModifyStatus(string id, string userid);

        List<ExpertDTO> GetList();
        List<ExpertDTO> GetList(string[] id = null);

        ResultEntity SaveExpPromote(ExpertPromoteDTO expertPromoteDTO);


 zhengcaioa/Services/ExpertService.cs

@@ -142,6 +142,22 @@
                        into csss
                         from ccc in csss.DefaultIfEmpty()

                         join m in _context.PltUsers
                     on a.Creater equals m.Id
                     into msssss
                         from mmm in msssss.DefaultIfEmpty()


                         join n in _context.Areas
                 on a.Province equals n.CodeId
                 into nsssss
                         from nnn in nsssss.DefaultIfEmpty()

                         join o in _context.Areas
                 on a.City equals o.CodeId
                 into osssss
                         from ooo in osssss.DefaultIfEmpty()


                         where a.RecStatus == "A"
                          && (searchEntity.JoinCount<=0 || hhh.JoinCount >= searchEntity.JoinCount)
@@ -169,6 +185,7 @@
                             Remark = a.Remark,

                             Creater = a.Creater,
                             CreaterName = mmm.UserName,
                             Createtime = a.Createtime,

                             RecStatus = a.RecStatus,
@@ -184,8 +201,10 @@
                             
                             Sort = a.Sort,
                             ShenheStatus = a.ShenheStatus,
                             
                             

                             AreaName = nnn.Name + "-" + ooo.Name,


                         }).ToList(); 

            if (!string.IsNullOrEmpty(searchEntity.Name))
@@ -236,7 +255,11 @@
            {
                query = query.Where(m => m.Phone1.Contains(searchEntity.Phone1)).ToList();
            }

            if (!string.IsNullOrEmpty(searchEntity.Creater))
            {
                query = query.Where(m => m.Creater == searchEntity.Creater).ToList();
            }
              

           query = query.OrderByDescending(x => x.Modifytime).ToList();
            //if (searchEntity.totalrows == 0)
@@ -266,9 +289,17 @@
            return result;
        }

        public List<ExpertDTO> GetList()
        public List<ExpertDTO> GetList(string[] id = null)
        {
            var listExperts = _context.Experts.Where(e => e.RecStatus == "A" && e.ShenheStatus == "A").ToList();

            if (id != null)
            {

                listExperts = listExperts.Where(r => id.Contains(r.Id)).ToList();
            }


            var list = _mapper.Map<List<ExpertDTO>>(listExperts);
            return list;
        }

 zhengcaioa/zhengcaioa/Controllers/Customer/CooperVisitController.cs

@@ -212,7 +212,7 @@
                resultEntity.Message = "无联系人";
            }

            string sss   = SMSHelper.PushWToUserMES(number.ToString(), neirong + " 退订回N");
            string sss   = SMSHelper.PushWToUserMES(number.ToString(), "您好，客户. 详情见" + neirong);
            if (int.Parse(sss) <= 0)
            {
                resultEntity.Result = false;

 zhengcaioa/zhengcaioa/Controllers/Customer/IntentionVisitController.cs

@@ -342,7 +342,7 @@
                resultEntity.Message = "无联系人";
            }

            string sss = SMSHelper.PushWToUserMES(number.ToString(), neirong+ " 退订回N");
            string sss = SMSHelper.PushWToUserMES(number.ToString(), "您好，客户. 详情见" + neirong );
            if (int.Parse(sss) <= 0)
            {
                resultEntity.Result = false;

 zhengcaioa/zhengcaioa/Controllers/Expert/ExpertController.cs

@@ -12,6 +12,8 @@
using System.IO;
using Microsoft.Extensions.Configuration;
using System.Transactions;
using CommonToolsCore;
using System.Text;

namespace zhengcaioa.Controllers.Expert
{
@@ -80,6 +82,41 @@
            return JsonConvert.SerializeObject(_expertService.SearchByPaging(search));
        }
        #endregion



        [CheckLogin]
        public IActionResult Indexziliao()
        {
            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 actionEntity4 = new ActionEntity();
            actionEntity4.OpenType = 0;
            actionEntity4.ActionUrl = "";
            actionEntity4.ActionFun = "Duanxin";
            actionEntity4.PageIco = "";
            actionEntity4.ActionName = "群发短信";
            actionlist.Add(actionEntity4);
            ViewData["ActionInfo"] = actionlist;

            ViewBag.expertType = _liaotianService.GetSYScode("experts", "expertType").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
            ViewBag.level = _liaotianService.GetSYScode("experts", "level").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
            ViewBag.Province = _projectService.Getsheng().Select(x => new { code = x.CodeId, label = x.Name }).ToList();
            //  ViewBag.City = _projectService.Getshi( ).Select(x => new { code = x.CodeId, label = x.Name }).ToList();
            ViewBag.ReviewItem = _liaotianService.GetSYScode("experts", "ReviewItem").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();


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


        #region 编辑
@@ -532,9 +569,74 @@



        


        #endregion




        public IActionResult Duanxin(string id = null)
        {
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
            ViewData["baifangid"] = id;



            return View();
        }



        public IActionResult Fasong(string neirong, string baifangid)
        {
            ResultEntity resultEntity = new ResultEntity();
            resultEntity.Result = true;
            var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
            ViewData["curentuser"] = curentuser;
            List<ExpertDTO> result = new List<ExpertDTO>();

            if (baifangid != null)
            {
                result = _expertService.GetList(baifangid.Split(","));
            }
            else
            {
                resultEntity.Result = false;
                resultEntity.Message = "无联系人号码";
            }
            string customename = "";
            StringBuilder number = new StringBuilder(); ;
            if (result != null && result.Count > 0)
            {
                for (int i = 0; i < result.Count; i++)
                {
                    number.Append(string.IsNullOrEmpty(result[i].Phone1) ? result[i].Phone2 : result[i].Phone1);
                    customename += result[i].Name + ",";
                    if (i != result.Count - 1)
                    {
                        number.Append(",");
                    }
                }
            }
            else
            {
                resultEntity.Result = false;
                resultEntity.Message = "无联系电话";
            }

            string sss = SMSHelper.PushWToUserMES(number.ToString(), "您好，专家. 详情见" + neirong);
            if (int.Parse(sss) <= 0)
            {
                resultEntity.Result = false;
                resultEntity.Message = "短信发送失败";

            }

            _logger.LogInformation(curentuser.UserName + "发送短信给专家" + customename);
            return new JsonResult(resultEntity);
        }

    }
}

 zhengcaioa/zhengcaioa/Views/Expert/Duanxin.cshtml

New file
@@ -0,0 +1,225 @@
@model DTO.ExpertDTO
@using DTO;
@using zhengcaioa.Models;
@{
    string baifangid = ViewData["baifangid"] as string; //拜访方式


}
@{
    Layout = null;
}

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">
    <meta name="description" content="">
    <meta name="author" content="ThemeBucket">
    <title>@(SiteConfig.SiteName)</title>
    <link href="~/css/bootstrap.min.css" rel="stylesheet">
    <link href="~/css/font-awesome.min.css" rel="stylesheet">
    <link href="~/css/animate.min.css" rel="stylesheet">

    @*<link href="~/css/plugins/iCheck/custom.css" rel="stylesheet">*@
    <link href="~/css/style.min.css" rel="stylesheet">
    <link href="~/css/plugins/chosen/chosen.css" rel="stylesheet">
    @*<link href="~/js/plugins/layer/skin/layer.css" rel="stylesheet">*@
    @*<link href="~/css/plugins/datapicker/datepicker3.css" rel="stylesheet">*@
    <link href="~/css/style.min.css" rel="stylesheet">
    <link href="~/css/plugins/toastr/toastr.min.css" rel="stylesheet" />
    <link href="~/css/plugins/webuploader/webuploader.css" rel="stylesheet" />

    <style type="text/css">
        .webuploader-pick {
            position: relative;
            display: inline-block;
            cursor: pointer;
            background: #00b7ee;
            padding: 8px 14px 7px 14px;
            color: #fff;
            text-align: center;
            border-radius: 3px;
            overflow: hidden;
        }

        div.clearfix > label {
            padding-top: 8px;
        }

        .chosen-container {
            border-radius: 1px;
            border: 1px solid #e5e6e7;
        }

        .col-md-1.control-label {
            padding-right: 0px;
            font-weight: 400;
        }
    </style>

    <!-- jqgrid-->
    @*<link href="~/css/plugins/jqgrid/ui.jqgrid.css" rel="stylesheet">*@
    <script language="javascript" src="~/js/jquery.min.js" type="text/javascript"></script>
    <script src="~/js/bootstrap.min.js"></script>
    @*<script src="~/js/plugins/bootstro/bootstro.js"></script>*@

    <!--容器-->
    @*<script language="javascript" src="~/js/datehelper.js" type="text/javascript"></script>*@
    @*<script language="javascript" src="~/js/plugins/query/jquery.query-object.js" type="text/javascript"></script>*@
    @*<script language="javascript" src="~/js/plugins/iCheck/icheck.min.js" type="text/javascript"></script>*@
    <script language="javascript" src="~/js/plugins/chosen/chosen.jquery.js" type="text/javascript"></script>
    @*<script language="javascript" src="~/js/plugins/datapicker/bootstrap-datepicker.js" type="text/javascript"></script>*@
    <script language="javascript" src="~/js/plugins/layer/layer.js" type="text/javascript"></script>
    @*<script src="~/js/plugins/jqgrid/jquery.jqGrid.min.js" type="text/javascript"></script>*@
    @*<script src="~/js/plugins/jqgrid/i18n/grid.locale-cn.js" type="text/javascript"></script>*@
    <script src="~/js/plugins/toastr/toastr.min.js" type="text/javascript"></script>
    <script src="~/js/plugins/webuploader/webuploader.min.js"></script>

    <script language="javascript" src="~/js/common-layout.js" type="text/javascript"></script>
    <script src="~/js/plugins/layer/laydate/laydate.js" type="text/javascript"></script>
    @*<script src="~/js/plugins/iTexbox/itextbox.js" type="text/javascript"></script>*@
    @*<script src="~/js/plugins/iuploader/iuploader.js"></script>*@
    <script src="~/js/TUJS.js"></script>
</head>
<body class="gray-bg" style="overflow:auto">
    <form id="formtest">
        <div class="wrapper wrapper-content" id="ibox-content" style="padding:15px;">
            <div class="row">
                <div class="col-sm-12">
                    <div class="ibox float-e-margins">
                        <div class="ibox-title">
                            <h5>                            <i class="fa fa-list"></i>&nbsp;群发短信</h5>
                        </div>
                        <div id="div_content" class="ibox-content" style="background-color:white;">
                            <div class="row">

                                <input type="hidden" id="baifangid" name="baifangid" value="@baifangid" />



                                <div class="clearfix layer-area" style="padding-bottom:15px;">
                                    <label grouptype="Vdata" class="text-right col-sm-1 col-md-1 control-label">短信内容<i class="red">*</i></label>
                                    <div class="col-sm-8 col-md-8">
                                        <textarea class="form-control bt" id="neirong" name="neirong" title="短信内容" isempty="" maxlength="4000" length="long"></textarea>
                                    </div>
                                </div>







                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="wrapper wrapper-content" style="margin-top:0px"></div>
        <div class="ibox-content" id="top" style="z-index:100; position:fixed; height:50px; width:100%;bottom:0; text-align: right; padding-top:8px ">
            <div class="" style="float:right;" data-bootstro-width="500px" data-bootstro-content="功能按钮：“保存”，“删除”">
                @*<a class="btn btn-success" href="javascript:void(0)" onclick="delPosition();" style="margin-left:4px; border-radius:4px;">
                        <i class="glyphicon glyphicon-remove"></i>&nbsp;&nbsp;<span class="bold">删除</span>
                    </a>*@

                <a class="btn btn-success" href="javascript:void(0)" onclick="savePosition();" style="margin-left:4px; border-radius:4px;">
                    <i class="glyphicon glyphicon-ok"></i>&nbsp;&nbsp;<span class="bold">提交</span>
                </a>
            </div>
        </div>

    </form>
    <script type="text/javascript">
        var hh = document.body.clientHeight - $('.ibox-title').height() - $("#top").height() * 2 - 95;
        $("#div_content").height(hh);

        toastr.options = {
            "closeButton": true,
            "debug": false,
            "progressBar": true,
            "positionClass": "toast-bottom-right",
            "onclick": null,
            "showDuration": "300",
            "hideDuration": "600",
            "timeOut": "4500",
            "extendedTimeOut": "600",
            "showEasing": "swing",
            "hideEasing": "linear",
            "showMethod": "fadeIn",
            "hideMethod": "fadeOut"
        };






        // 保存岗位信息
        var savePosition = function () {





            if ($.trim($("#neirong").val()) == '') {
                toastr.warning("交谈内容不能为空");
                return;
            }



            var data = { neirong: $("#neirong").val(), baifangid: $("#baifangid").val()}
            $.ajax({
                type: "POST",
                url: "/Expert/Fasong",
                dataType: "json",
                global: false,
                data: data,
                success: function (data) {



                        if (data.Result) {
                            //  parent._afterSave(true);
                            parent.layer.msg('短信发送成功', { icon: 6 });
                            //window.location = "/Project/add?id=" + data.ReturnID;



                                _pageAutoClose();//自动关闭页面方法


                        }
                        else {
                            // toastr.error("失败");
                            parent.layer.msg(data.Message, { icon: 5 });
                        }

                },
                error: function () {


                    parent.layer.msg('失败', { icon: 5 });
                }
            });
        }






        function _pageAutoClose() {
            parent.window._reloadPageData();
            var index = parent.layer.getFrameIndex(window.name);
            parent.layer.isRefresh = true;
            parent.layer.closeAll('loading');
            parent.layer.close(index);
            return false;
        }
    </script>
</body>
</html>

 zhengcaioa/zhengcaioa/Views/Expert/Indexziliao.cshtml

New file
@@ -0,0 +1,175 @@
@{
    ViewBag.Title = "Expert";
    Layout = "~/Views/Shared/_Layout_Search.cshtml";
}
@section headerStyle{
    <script type="text/javascript">


        var expertType = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.expertType))';
        var Province = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.Province))';
        var level = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.level))';
        var ReviewItem = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.ReviewItem))';
        var users = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.users))';
        loseherght = 60;
        gridConfig = { multiselect: true, selectcol: "Id" };
        dataCol = [
            { label: 'id', name: 'Id', labtype: 'txt', hidden: true },
            { label: '区域', name: 'AreaName', labtype: 'txt', hidden: false },
            {
                label: '姓名', name: 'Name', labtype: 'txt', hidden: false 
            },
            { label: '专家证号', name: 'CertiNumber', labtype: 'txt', hidden: false },
            { label: '联系电话', name: 'Phone1', labtype: 'txt', hidden: false },
            { label: '录入人', name: 'CreaterName', labtype: 'txt', hidden: false },
 
            {
                label: '操作', name: 'caozuo', labtype: 'txt', hidden: false, width: 50,
                formatter: function (cellvalue, options, rowObject) {
                    return "<a onclick=\"OpenWindow('修改','98%','100%', '/Expert/Edit?id=" + rowObject.Id + "')\"  >修改</a>&nbsp;&nbsp;&nbsp;<a onclick=\"_pagedel('" + rowObject.Id + "')\"  >删除</a>";
                }
            },

          //  { label: '操作', name: '', labtype: 'txt', hidden: false },

            { label: '状态', name: 'RecStatus', labtype: 'txt', hidden: true },
            { label: '创建人', name: 'Creater', labtype: 'txt', hidden: true },
            { label: '创建时间', name: 'Createtime', labtype: 'txt', hidden: true },
            { label: '修改人', name: 'Modifier', labtype: 'txt', hidden: true },
            { label: '修改时间', name: 'Modifytime', labtype: 'txt', hidden: true }

        ];
        dataUrl = "/Expert/GetList";
        searchCol = [
            { label: '省', name: 'Province', labtype: 'combox', hidden: false, data: JSON.parse(Province), cwidth: '5%', cccwidth: '6.5%' },
            { label: '市', name: 'City', labtype: 'combox', hidden: false, data: JSON.parse('[]'), cwidth: '1%', cccwidth: '7%' },
            { label: '专家姓名', name: 'Name', labtype: 'txt', hidden: false },
            { label: '专家证号', name: 'CertiNumber', labtype: 'txt', hidden: false },
            { label: '联系电话', name: 'Phone1', labtype: 'txt', hidden: false },
            { label: '录入时间', name: 'Createtime', labtype: 'datearea', hidden: false },
            { label: '录入人', name: 'Creater', labtype: 'combox', hidden: false, data: JSON.parse(users) },
            { label: '评审品目', name: 'ReviewItem', labtype: 'combox', hidden: false, data: JSON.parse(ReviewItem) },
           
          
           
           
            
         
        ];

        var _pagedel = function (id) {
            if (confirm('是否删除记录')) {
                $.ajax({
                    type: "GET",
                    url: "/Expert/Nullify?Id=" + id,
                    dataType: "json",
                    global: false,
                    data: '',
                    success: function (data) {


                        if (data.Result) {

                            layer.msg('删除成功', { icon: 6 });
                            window._reloadPageData();
                        }
                        else {
                            // toastr.error("");
                            layer.msg('删除失败', { icon: 5 });
                        }

                    },
                    error: function () {
                        if ($.isNumber(imgLoad)) {
                            layer.close(imgLoad);
                        }
                        //toastr.error("保存失败");

                        layer.msg('保存失败', { icon: 5 });
                    }
                });
            }


        }


        var _pageDuanxin = function () {
            var duanxin = GetGridSelect();
            var baifangid = "";
            if (duanxin != '') {
                for (var i = 0; i < duanxin.length; i++) {
                    baifangid += duanxin[i] + ','
                }
                baifangid = baifangid.substring(0, baifangid.length - 1);
            } else {
                toastr.error("请选择专家");
                return;
            }

            OpenWindow("群发短信", "50%", "50%", "/Expert/Duanxin?id=" + baifangid);

        }


        var _afterSave = function (result) {
            if (result) {
                toastr.success("保存成功");
            } else {
                toastr.error("保存失败");
            }
        }

        var _afterDel = function (result) {
            if (result) {
                toastr.success("删除成功");
            } else {
                /**/
                toastr.error("删除成功");
                /**/
            }
        }


        $(function () {
            $("#PBSProvince").change(function () {
                let Province = $("#PBSProvince").val();
                $.ajax({
                    type: "GET",
                    url: "/Project/getCity?shengid=" + Province,
                    dataType: "json",
                    global: false,
                    data: "",
                    success: function (data) {

                        var city = $("#PBSCity");
                        city.find('option').remove();
                        var aaa = '<option value="" hassubinfo="true">请选择</option>';
                        city.append(aaa);
                        if (data.length > 0) {
                            for (var i = 0; i < data.length; i++) {

                                var o = '<option value="' + data[i].CodeId + '" hassubinfo="true">' + data[i].Name + '</option>';
                                city.append(o);
                            }
                        }
                        $("#PBSCity").trigger('chosen:updated');//更新选项
                    },
                    error: function () { }
                });
            });


        });


        $(function () {
            $("#PBSCertiNumber").parent().next().remove();
            $("#PBSPhone1").parent().after("<br>");
            $("#PBSReviewItem").parent().next().remove();
           

        }); 
    </script>
}


 zhengcaioa/zhengcaioa/Views/Zhuanjiahuida/Index.cshtml

@@ -26,6 +26,12 @@
                label: '回答', name: 'Anwser', labtype: 'txt', hidden: false, width: 300

            },
            {
                label: '操作', name: 'caozuo', labtype: 'txt', hidden: false, width: 50,
                formatter: function (cellvalue, options, rowObject) {
                    return "<a onclick=\"OpenWindow('修改','98%','100%', '/Zhuanjiahuida/Edit?id=" + rowObject.Id + "')\"  >回答</a>&nbsp;&nbsp;&nbsp;<a onclick=\"_pagedel('" + rowObject.Id + "')\"  >删除</a>";
                }
            },
            
        ];
        dataUrl = "/Zhuanjiahuida/GetList";
@@ -48,8 +54,42 @@
        //    OpenWindow("新增基本工资", "98%", "100%", "/Zhuanjiahuida/Edit/");
        //}

        var _pagedel = function (id) {
            if (confirm('是否删除记录')) {
                $.ajax({
                    type: "GET",
                    url: "/Zhuanjiahuida/Nullify?Id=" + id,
                    dataType: "json",
                    global: false,
                    data: '',
                    success: function (data) {


                        if (data.Result) {

                            layer.msg('删除成功', { icon: 6 });
                            window._reloadPageData();
                        }
                        else {
                            // toastr.error("");
                            layer.msg('删除失败', { icon: 5 });
                        }

                    },
                    error: function () {
                        if ($.isNumber(imgLoad)) {
                            layer.close(imgLoad);
                        }
                        //toastr.error("保存失败");

                        layer.msg('保存失败', { icon: 5 });
                    }
                });
            }


        }


        var _afterSave = function (result) {
            if (result) {