Web/Admin/Service/ajax/mymsg.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>
/// 1、操作员进行订单分配之后，骑士在5分钟之内未进行订单确定的，请弹窗提醒，调度员好电话进行提醒；
///2、订单配送时间超过XX分钟未送达，系统自动提醒。
///3、订单超过xxx分钟未被任何处理，那么系统应当自动提醒。
/// 三个提醒都一起返回.
/// </summary>
public partial class qy_54tss_Admin_Service_ajax_mymsg : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Custorder dalorder = new Custorder();
        OrderDeliver dalod = new OrderDeliver();

        int cid = HjNetHelper.GetQueryInt("cid", 0);

        //1,操作员进行订单分配之后，骑士在5分钟之内未进行订单确定的，请弹窗提醒，调度员好电话进行提醒；
        int GPSDelay = 5;
        string sql = " orderid in (select orderid from Custorder where OrderStatus = 7 and sendstate = 0 and cityid = " + cid + "  and ReveVar1 = '点必得配送' and ReveInt2 = 0  ) and Inve1 = 0 and DispatchTime < '" + DateTime.Now.AddMinutes(-GPSDelay) + "' ";

        IList<OrderDeliverInfo> GPSDelaylist = dalod.GetList(10, 1, sql, "DispatchTime", 0);
        StringBuilder sb = new StringBuilder();
        if (GPSDelaylist.Count > 0)
        {
            sb.Append("<div class='clear'>");
            sb.Append("<span>" + GPSDelay + "分内骑士未进行订单确定的订单</span>");
            sb.Append("<div  style=' width:337px' class='mymsg_notice'><ul>");
            foreach (OrderDeliverInfo item in GPSDelaylist)
            {
                sb.Append("<li><a href=\"OrderDelive.aspx?oid=" + item.Orderid + "\" style='margin-left:5px;'>" + item.Orderid + "</a></li>");
            }
            sb.Append("</ul></div>");
            sb.Append("</div>");
        }
        //2、订单配送时间超过XX分钟未送达，系统自动提醒。
        int DeliverDelay = 10;
        sql = " orderid in (select orderid from Custorder where OrderStatus = 7 and cityid = " + cid + "  and ReveVar1 = '点必得配送' and ReveInt2 = 0 ) and   DATEADD ( minute  ,inve1, DeliveryTime ) < '" + DateTime.Now.AddMinutes(-DeliverDelay) + "' ";

        IList<OrderDeliverInfo> DeliverDelaylist = dalod.GetList(10, 1, sql, "DeliveryTime", 0);
        if (DeliverDelaylist.Count > 0)
        {
            sb.Append("<div class='clear'>");
            sb.Append("<span>订单配送时间超过" + DeliverDelay + "分钟未送达的订单</span>");
            sb.Append("<div  style=' width:337px' class='mymsg_notice'><ul>");
            foreach (OrderDeliverInfo item in DeliverDelaylist)
            {
                sb.Append("<li><a href=\"OrderDelive.aspx?oid=" + item.Orderid + "\" style='margin-left:5px;'>" + item.Orderid + "</a></li>");
            }
            sb.Append("</ul></div>");