Linq语法：@H_404_6@

/// <summary>
        /// 营业额统计
        /// </summary>
        /// <param name="Year">查询的年份</param>
        /// <param name="Month">查询的月份</param>
        /// <returns></returns>
        public ActionResult YingYeETongJi(string Year,string Month)
        {
            var MarketMoney = 0;//销售金额
            var ServiceMoney = 0;//维修结账金额
            var PurchaseMoney = 0;//采购金额
            var PurchaseReturnOfGoodsMoney = 0;//采购退货金额
            var MarketReturnOfGoodsMoney = 0;//销售退货金额
            var MarketExChangeMoneyMoney = 0;//销售换货金额
            var MarketGuaranteeMoney = 0;//销售保修金额
            var DateTimeData = Year;
            var Count = "12";
            var dtData = "";
            var dateCount = "";
            DataTable dt = new DataTable();
            dt.Columns.Add("d",typeof(string));
            dt.Columns.Add("visits",typeof(string));
            //判断是否查询月份
            if (Month != "" && Convert.ToInt32(Month.ToString().Trim()) > 0)
            {
                if (Convert.ToInt32(Month) < 10)
                {
                    Month = "0" + Month;
                }
                DateTimeData = DateTimeData + "-" + Month;
                Count = DateTime.DaysInMonth(Convert.ToInt32(Year),Convert.ToInt32(Month)).ToString();
            }

            //销售
            var Market = (from dtMarket in myMdl.pw_XiaoShouDan
                          where dtMarket.YouXiaoFou == true && dtMarket.FuKuanZhuangTaiID == 44
                          select dtMarket).AsEnumerable().Select(n => new
                          {
                              n.ShiShouJinE,XiaoShouRiQi = n.XiaoShouRiQi.Value.ToString("yyyy-MM-dd")
                          });
            //维修结账
            var Service = (from dtService in myMdl.pw_JieZhangQuBiao
                           where dtService.YouXiaoFou == true
                           select dtService).AsEnumerable().Select(n => new
                           {
                               n.ShiShouJinE,FuKuanRiQi = n.FuKuanRiQi.Value.ToString("yyyy-MM-dd")
                           });

            //采购
            var Purchase = (from dtPurchase in myMdl.pw_CaiGouDan
                            where dtPurchase.YouXiaoFou == true
                            select dtPurchase).AsEnumerable().Select(n => new
                            {
                                n.JinE,DaoHuoRiQi = n.DaoHuoRiQi.Value.ToString("yyyy-MM-dd")
                            });

            //采购退货
            var PurchaseReturnOfGoods = (from dtPurchaseReturnOfGoods in myMdl.pw_CaiGouTuiHuoDan
                                         where dtPurchaseReturnOfGoods.TuiKuanZhuangTai == "已退款" && dtPurchaseReturnOfGoods.YouXiaoFou == true
                                         select dtPurchaseReturnOfGoods).AsEnumerable().Select(n => new
                                         {
                                             n.JinE,GengXinRiQi = n.GengXinRiQi.Value.ToString("yyyy-MM-dd")
                                         });

            //销售退货单
            var MarketReturnOfGoods = (from dtMarketReturnOfGoods in myMdl.pw_XiaoShouShouHouDan
                                       where dtMarketReturnOfGoods.XiaoShouShouHouLeiXingID == 48 && dtMarketReturnOfGoods.YouXiaoFou == true
                                       select dtMarketReturnOfGoods).AsEnumerable().Select(n => new
                                       {
                                           n.JinE,RiQi = n.RiQi.Value.ToString("yyyy-MM-dd")
                                       });

            //销售换货单
            var MarketExChangeMoney = (from dtMarketExChangeMoney in myMdl.pw_XiaoShouShouHouDan
                                       where dtMarketExChangeMoney.XiaoShouShouHouLeiXingID == 49 && dtMarketExChangeMoney.YouXiaoFou == true
                                       select dtMarketExChangeMoney).AsEnumerable().Select(n => new
                                       {
                                           n.JinE,RiQi = n.RiQi.Value.ToString("yyyy-MM-dd")
                                       });
            //销售保修 
            var MarketGuarantee = (from dtMarketGuarantee in myMdl.pw_XiaoShouShouHouDan
                                   where dtMarketGuarantee.XiaoShouShouHouLeiXingID == 50 && dtMarketGuarantee.YouXiaoFou == true
                                   select dtMarketGuarantee).AsEnumerable().Select(n => new
                                   {
                                       n.JinE,RiQi = n.RiQi.Value.ToString("yyyy-MM-dd")
                                   });
            for (int i = 0; i < Convert.ToInt32(Count) + 1; i++)
            {
                if (Convert.ToInt32(i) < 10)
                {
                    dateCount = "0" + (i + 1).ToString();
                }
                else
                {
                    dateCount = i.ToString();
                }
                dtData = (DateTimeData + "-" + dateCount).ToString().Trim();
                MarketMoney = 0;//销售金额
                ServiceMoney = 0;//维修结账金额
                PurchaseMoney = 0;//采购金额
                PurchaseReturnOfGoodsMoney = 0;//采购退货金额
                MarketReturnOfGoodsMoney = 0;//销售退货金额
                MarketExChangeMoneyMoney = 0;//销售换货金额
                MarketGuaranteeMoney = 0;//销售保修金额
                DataRow dtRow = dt.Rows.Add();
                //销售
                Market = Market.Where(n => n.XiaoShouRiQi.Contains(dtData));
                foreach (var item in Market)
                {
                    MarketMoney += Convert.ToInt32(item.ShiShouJinE);
                }
                //维修结账
                Service = Service.Where(n => n.FuKuanRiQi.Contains(dtData));
                foreach (var item in Service)
                {
                    ServiceMoney += Convert.ToInt32(item.ShiShouJinE);
                }
                //采购
                Purchase = Purchase.Where(n => n.DaoHuoRiQi.Contains(dtData));
                foreach (var item in Purchase)
                {
                    PurchaseMoney += Convert.ToInt32(item.JinE);
                }
                //采购退货
                PurchaseReturnOfGoods = PurchaseReturnOfGoods.Where(n => n.GengXinRiQi.Contains(dtData));
                foreach (var item in PurchaseReturnOfGoods)
                {
                    PurchaseReturnOfGoodsMoney += Convert.ToInt32(item.JinE);
                }
                //销售退货单
                MarketReturnOfGoods = MarketReturnOfGoods.Where(n => n.RiQi.Contains(dtData));
                foreach (var item in MarketReturnOfGoods)
                {
                    MarketReturnOfGoodsMoney += Convert.ToInt32(item.JinE);
                }
                //销售换货单
                MarketExChangeMoney = MarketExChangeMoney.Where(n => n.RiQi.Contains(dtData));
                foreach (var item in MarketExChangeMoney)
                {
                    MarketExChangeMoneyMoney += Convert.ToInt32(item.JinE);
                }
                //销售保修 
                MarketGuarantee = MarketGuarantee.Where(n => n.RiQi.Contains(dtData));
                foreach (var item in MarketGuarantee)
                {
                    MarketGuaranteeMoney += Convert.ToInt32(item.JinE);
                }
                var Money = ServiceMoney + MarketMoney - PurchaseMoney + PurchaseReturnOfGoodsMoney - MarketReturnOfGoodsMoney + MarketExChangeMoneyMoney + MarketGuaranteeMoney;
                dtRow["d"] = dtData;
                dtRow["visits"] = Money;
            }
            List<Dictionary<string,object>> Listreturn = ConvertHelper.DtToList(dt);
            return Json(Listreturn,JsonRequestBehavior.AllowGet);
        }

第三步、视图层（views）

<div id="_revealloading"  class="reveal-loadding" style="display:block">
    <span class="loading" style="display:block">
    </span>
</div>
<br />
<table>
    <tr>
        <td style="width:50px"></td>
        <td><input type="text" id="Year" maxlength="4" onkeyup="value=value.replace(/[^\d]/g,''); inputFullYear(this);" onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\d]/g,''))"/></td>
        <td><input type="text" id="Month" maxlength="2" onkeyup="value=value.replace(/[^\d]/g,''); inputMonth(this);" onbeforepaste="clipboardData.setData('text',''))"/></td>
        <td><input type="button" class="goodButton1" onclick="onClickLoadData()" style="width:100px;height:26px;border:0" value="查询" /></td>
    </tr>
</table>
<br />
    <center>
        <div style="width:1130px">
        <div class="row">
              <div class="col-lg-12">
                <div class="panel panel-primary">
                  <div class="panel-heading">
                    <h3 class="panel-title"><i class="fa fa-bar-chart-o"></i>营业额统计</h3>
                  </div>
                  <div class="panel-body">
                    <div id="morris-chart-area"></div>
                  </div>
                </div>
              </div>
        </div>
    </div>
    </center>

var data = undefined;
    var nowDate = new Date();//实例化date
    $(document).ready(function () {
        $("#Month").val(nowDate.getMonth() + 1)//绑定当前月份
        $("#Year").val(nowDate.getFullYear()); //绑定当前年份
        onClickLoadData();
        $('#Year').keydown(function (e) {
            if (e.keyCode == 13) {//键盘回车事件,触发查询功能
                onClickLoadData()
            }
        });
        $('#Month').keydown(function (e) {
            if (e.keyCode == 13) {//键盘回车事件,触发查询功能
                onClickLoadData()
            }
        });
    });

    function onClickLoadData() {
    //打开进度条
        $("#_revealloading").css("display","block");
        //通过ajax进行查询
        $.ajax({
            type: 'post',url: '/ShuJuBiaoGe/YingYeETongJi?Year=' + $("#Year").val() + '&Month=' + $("#Month").val(),success: function (requiredata) {
            //查询成功，返回数据
                data = requiredata;
                document.getElementById('morris-chart-area').innerHTML = ""; //清空插件的数据，否则数据会出现重复现象，图像重叠
                //为图表插件绑定数据
                Morris.Area({
                    element: 'morris-chart-area',data: data,xkey: 'd',ykeys: ['visits'],labels: ['金额（RMB）'],smooth: false
                });
                //关闭进度条
                $("#_revealloading").css("display","none");
            }
        });
    }
    function inputMonth(event) {
        if (event.value>12) {//限制月份不能输入超出12的数
            alert("月份数不能大于12！");
            $("#Month").val(nowDate.getMonth() + 1);
        }
    }
    function inputFullYear(event) {
        if (event.value > nowDate.getFullYear()) {//限制年份输入不能超出当前时间年份
            alert("年份数不能大于当前时间年份！");
            $("#Year").val(nowDate.getFullYear());
        }
    }

• 上一篇：ajax 工具类下一篇：DWR如何获得返回对象

猜你在找的Ajax相关文章

网页的异步请求（Ajax）

JS原生Ajax操作(XMLHttpRequest) GET请求 POST请求 兼容性问题 利用iframe模拟ajax 实现表...

作者：前端之家 时间：2021-01-14

手动实现AJAX

AJAX 每日更新前端基础，如果觉得不错，点个star吧 😃 https://github.com/Win...

作者：前端之家 时间：2020-12-19

axios异步提交表单数据的不同形式

踩坑Axios提交form表单几种格式 前后端分离的开发前后端, 前端使用的vue,后端的安全模块使...

作者：前端之家 时间：2020-12-12

php的ajax简单实例

很早就听闻ajax的名声，但是却一直不知道怎么用，今天自己捣鼓了一下，竟然会用了，哈哈哈...

作者：前端之家 时间：2020-11-11

Json与Ajax(注册实例）

需要在服务器上进行哈 jquery的ajax方法： // jquery请求 $.ajax({ url: "./serv...

作者：前端之家 时间：2020-11-07

jSon和Ajax登录功能，ajax数据交互案例

ajax实例，检测用户与注册 检测用户名是否被占用： 在用户填写完用户名之后，ajax会异步向...

作者：前端之家 时间：2020-11-07

关于AjaxControlToolkit的样式问题

网(LieHuo.Net)教程 技术文章一直都是转载的,从来没有自创过.终于遇到AjaxControlToolkit,...

作者：前端之家 时间：2020-11-04

一个简单的AJAX实现(HELLO AJAX)

客户端部分： <html> <head> <meta http-equiv="Content-Type" ...

作者：前端之家 时间：2020-11-04

AJAX中文乱码的两类问题及解决之策

1）发送路径中的参数有中文，在服务器段接收参数值是乱码 例如： var url=”a.jsp?na...

作者：前端之家 时间：2020-11-04

实例：AJAX返回xml代码如何在网页中显示

建站学院（LieHuo.Net）文档 今天来学习一篇实例代码教程：AJAX返回xml代码如何在网页中显...

作者：前端之家 时间：2020-11-04