优化查询

username@email.com

2022-09-21 6131316db2e61c717a6fbd1db774b41b60c933e9

优化查询

 zhengcaioa/zhengcaioa/Controllers/Customer/CooperatecustomCustomerController.cs

@@ -155,6 +155,12 @@
            areaDTOsic.ParentId = "0     ";
            areaDTOs.Insert(1, areaDTOsic);
            ViewBag.ShengDropDown = areaDTOs.Select(x => new { code = x.CodeId, label = x.Name }).ToList();


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


            return View();
   
        }

 zhengcaioa/zhengcaioa/Controllers/Customer/IntentionCustomerController.cs

@@ -182,6 +182,10 @@
            areaDTOsic.ParentId = "0     ";
            areaDTOs.Insert(1, areaDTOsic);
            ViewBag.ShengDropDown = areaDTOs.Select(x => new { code = x.CodeId, label = x.Name }).ToList();

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

            return View();

        }

 zhengcaioa/zhengcaioa/Controllers/ProjectController.cs

@@ -385,6 +385,10 @@
            ViewBag.Creater = _userService.GetList().Select(x => new { code = x.Id, label = x.UserName }).ToList();
            ViewBag.flbx = _liaotianService.GetSYScode("system", "shifou").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();
            ViewBag.ShiFouyReasonname = _liaotianService.GetSYScode("Project", "ShiFouyReasonname").Select(x => new { code = x.CodeSn, label = x.Comments }).ToList();

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

            return View();
        }


 zhengcaioa/zhengcaioa/Views/CooperatecustomCustomer/Index.cshtml

@@ -17,6 +17,9 @@
        var shengDropDown = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.ShengDropDown))';
        var shifou = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.shifou))';

        var Baomingtimebegin = '@Html.Raw(ViewBag.Baomingtimebegin)';
        var Baomingtimeend = '@Html.Raw(ViewBag.Baomingtimeend)';

        loseherght = 60;
        gridConfig = { multiselect: true, selectcol: "Id" };
        dataCol = [
@@ -50,7 +53,7 @@
                }
            },
        ];
        dataUrl = "/CooperatecustomCustomer/GetList"+"@(string.IsNullOrEmpty(Creater)?"": "?Ywjl=" + Creater)";
        dataUrl = "/CooperatecustomCustomer/GetList?Createtime=" + Baomingtimebegin + "|" + Baomingtimeend +"@(string.IsNullOrEmpty(Creater)?"": "&Ywjl=" + Creater)";
        searchCol = [

            { label: '客户来源', name: 'Khly', labtype: 'combox', hidden: false, data: JSON.parse(khlys), cwidth: '5%', cccwidth: '8%' },
@@ -69,6 +72,19 @@
        var _pageAdd = function () {
            OpenWindow("新增合作客户", "98%", "100%", "/CooperatecustomCustomer/Edit/");
        }

         var _pageSearch = function () {
            $("#jqGrid").jqGrid('setGridParam', {
                url: dataUrl = "/CooperatecustomCustomer/GetList"+"@(string.IsNullOrEmpty(Creater) ?"": "?Ywjl=" + Creater)", postData: jsons, page: 1
            }); //重新载入
            var jsons = GetSearchEnd();
            if (jsons == false) {
                msg.info("请录入查询条件");
                return false;
            }
            LoadGrid(jsons);
        }


        var _pagePrint = function () {

@@ -282,7 +298,17 @@

            }


           
        };

        $(function () {
            


            $("#PBSCreatetimeend").val(Baomingtimeend);

            $("#PBSCreatetimestart").val(Baomingtimebegin);

        });
    </script>
}

 zhengcaioa/zhengcaioa/Views/IntentionCustomer/Index.cshtml

@@ -15,7 +15,11 @@
        var users = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.users))';
        var shengDropDown = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.ShengDropDown))';
        var Creater = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.Creater))';
         var shifou = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.shifou))';
        var shifou = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.shifou))';

        var Baomingtimebegin = '@Html.Raw(ViewBag.Baomingtimebegin)';
        var Baomingtimeend = '@Html.Raw(ViewBag.Baomingtimeend)';

        loseherght = 60;
        gridConfig = { multiselect: true, selectcol: "Id" };
        dataCol = [
@@ -42,7 +46,7 @@
            },

        ];
        dataUrl = "/IntentionCustomer/GetList"+"@(string.IsNullOrEmpty(Creater11) ?"": "?Ywjl=" + Creater11)";
        dataUrl = "/IntentionCustomer/GetList?Createtime=" + Baomingtimebegin + "|" + Baomingtimeend +"@(string.IsNullOrEmpty(Creater11) ?"": "&Ywjl=" + Creater11)";
        searchCol = [
            { label: '客户来源', name: 'Khly', labtype: 'combox', hidden: false, data: JSON.parse(khlys), cwidth: '5%', cccwidth: '8%' },
            { label: '行业分类', name: 'Hyfl', labtype: 'combox', hidden: false, data: JSON.parse(hyfls), cwidth: '5%', cccwidth: '15%' },
@@ -62,6 +66,18 @@
        ];
        var _pageAdd = function () {
            OpenWindow("新增意向客户", "98%", "100%", "/IntentionCustomer/Edit/");
        }

         var _pageSearch = function () {
            $("#jqGrid").jqGrid('setGridParam', {
                url: dataUrl = "/IntentionCustomer/GetList"+"@(string.IsNullOrEmpty(Creater11) ?"": "?Ywjl=" + Creater11)", postData: jsons, page: 1
            }); //重新载入
            var jsons = GetSearchEnd();
            if (jsons == false) {
                msg.info("请录入查询条件");
                return false;
            }
            LoadGrid(jsons);
        }

        var _pagePrint = function () {
@@ -364,7 +380,15 @@
        sendCity();


        $(function () {



            $("#PBSCreatetimeend").val(Baomingtimeend);

            $("#PBSCreatetimestart").val(Baomingtimebegin);

        });

    </script>
}

 zhengcaioa/zhengcaioa/Views/Project/Select.cshtml

@@ -14,7 +14,8 @@
        var Creater = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.Creater))';
        var flbx = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.flbx))';
        var ShiFouyReasonname = '@Html.Raw(Newtonsoft.Json.JsonConvert.SerializeObject(ViewBag.ShiFouyReasonname))';

          var Baomingtimebegin = '@Html.Raw(ViewBag.Baomingtimebegin)';
        var Baomingtimeend = '@Html.Raw(ViewBag.Baomingtimeend)';

        loseherght = 110;
        dataCol = [
@@ -94,7 +95,7 @@
            { label: '废标次数', name: 'Feibiaocishu', labtype: 'txt', hidden: true },
            { label: '中标金额', name: 'Zhongbiaojine', labtype: 'txt', hidden: true }
        ];
        dataUrl = "/Project/GetLiaotianList"+"@(string.IsNullOrEmpty(Creater11) ?"":"?Creater="+ Creater11)";
        dataUrl = "/Project/GetLiaotianList?StartTimestar=" + Baomingtimebegin + "|" + Baomingtimeend +"@(string.IsNullOrEmpty(Creater11) ?"":"&Creater="+ Creater11)";
        searchCol = [
            //{ label: '公告时间', name: 'StartTimestar', labtype: 'date', hidden: false },
            //{ label: '--', name: 'StartTimeend', labtype: 'date', hidden: false, cwidth: '1%', cccwidth: '15%' },
@@ -129,6 +130,18 @@
        ];
        var _pageAdd = function () {
            OpenWindow("新增项目", "98%", "90%", "/Project/Add/");
        }

        var _pageSearch = function () {
            $("#jqGrid").jqGrid('setGridParam', {
                url: dataUrl = "/Project/GetLiaotianList"+"@(string.IsNullOrEmpty(Creater11) ?"":"?Creater="+ Creater11)", postData: jsons, page: 1
            }); //重新载入
            var jsons = GetSearchEnd();
            if (jsons == false) {
                msg.info("请录入查询条件");
                return false;
            }
            LoadGrid(jsons);
        }

        var _afterSave = function (result) {
@@ -259,6 +272,11 @@
            $("#PBSCreater").parent().next().remove();
            $("#PBSFenchadayu").parent().after("<br>");


            $("#PBSStartTimestarend").val(Baomingtimeend);

            $("#PBSStartTimestarstart").val(Baomingtimebegin);

        });

    </script>