ASP.NET MVC JS发送JSON格式参数，后台获取

最新推荐文章于 2022-02-24 22:39:16 发布

干到60岁退休的码农

最新推荐文章于 2022-02-24 22:39:16 发布

阅读量1.2k

点赞数

分类专栏： ASP.NET MVC

本文链接：https://blog.csdn.net/Gary_888/article/details/79607364

版权

ASP.NET MVC 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

 var queryJson = {
            keyword: $("#txt_keyword").val(),
            starttime: $("#txt_starttime").val(),
            endtime: $("#txt_endtime").val()
        }
        $gridList.jqGrid('setGridParam', {
            postData: {
                keyword: JSON.stringify(queryJson)
            }
        }).trigger('reloadGrid');

var expression = ExtLinq.True<SalesRecordDetailEntity>();
            var queryParam = queryJson.ToJObject();
            if (!queryParam["keyword"].IsEmpty())
            {
                string keyword = queryParam["keyword"].ToString();
                //keyWord可能为设备型号/设备名称/生产厂商/销售人员名称
                string semId = salesEquipmentModelApp.SearchModelIdBySearchkey(keyword);
                //设备型号/设备名称/生产厂商为空
                List<SalesRecordEntity> salesRecordList = new List<SalesRecordEntity>();
                if (string.IsNullOrEmpty(semId))
                {
                    salesRecordList = salesRecordApp.SearchSalesRecordBySalesMan(keyword);
                }
                if (!string.IsNullOrEmpty(keyword))
                {
                    if (!string.IsNullOrEmpty(semId))
                    {
                        expression = expression.And(t => t.SEM_ID.ToLower().Contains(semId.ToLower()));
                    }
                    if (salesRecordList.Count > 0)
                    {
                        foreach (var salesRecord in salesRecordList)
                        {
                            expression = expression.And(t => t.SR_ID.ToLower().Contains(salesRecord.SR_ID.ToLower()));
                        }
                    }
                }
            }
            if (!queryParam["starttime"].IsEmpty() && !queryParam["endtime"].IsEmpty())
            {
                DateTimeFormatInfo dtFormat = new DateTimeFormatInfo();
                dtFormat.ShortDatePattern = "yyyy/MM/dd";
                DateTime starttime = Convert.ToDateTime(queryParam["starttime"], dtFormat);
                DateTime endtime = Convert.ToDateTime(queryParam["endtime"], dtFormat);
                expression = expression.And(t => t.SR_SALESDATE >= starttime && t.SR_SALESDATE <= endtime);
            }
            expression = expression.And(t => t.SRD_STATUS != -1);//已删除的不获取
            return service.FindList(expression, pagination);