Web/App/shop/GetSaleMoney.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

using System.Text;

using WMPT.Model;
using WMPT.SQLServerDAL;
using WMPT.Common;

/// <summary>
/// 商家营业额，及订单量统计
/// </summary>
public partial class Android_togo_GetSaleMoney : System.Web.UI.Page
{
    Custorder dalorder = new Custorder();
    protected void Page_Load(object sender, EventArgs e)
    {
        Response.Clear();

        StringBuilder json = new StringBuilder("");
        string SqlWhere = "  ";
        int togoid = HjNetHelper.GetPostParam("shopid", 0);
        if (togoid > 0)
        {
            SqlWhere = "1=1 AND TogoId=" + togoid;
        }

        string starttime = WebUtility.InputText(Request["starttime"]);//开始日期
        string endtime = WebUtility.InputText(Request["endtime"]);//结束日期


        string order_state = WebUtility.InputText(Request["state"]);//订单状态
        int paymode =  HjNetHelper.GetPostParam("paymode", -1);//支付方式

        //分页参数
        int pagesize = HjNetHelper.GetPostParam("pagesize", 10); //分页大小
        int pageindex = HjNetHelper.GetPostParam("pageindex", 1);//分页标签
        int pagecount = 1;//分页总数


        StringBuilder orderlistjson = new StringBuilder();
        IList<CustorderInfo> list = new List<CustorderInfo>();

        if (starttime != "")
        {
            SqlWhere += " and OrderDateTime > '" + starttime + "' ";
        }
        if (endtime != "")
        {
            SqlWhere = SqlWhere + " and OrderDateTime <  '" + endtime + " 23:59:59'";
        }

        if (starttime == "" && endtime == "")
        {
            SqlWhere += " and DATEDIFF(day,OrderDateTime,GETDATE()) = 0 ";
        }