博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
提醒窗口
阅读量:5287 次
发布时间:2019-06-14

本文共 2096 字,大约阅读时间需要 6 分钟。

脚本:

后台:

using System;using System.Collections;using System.Configuration;using System.Data;using System.Linq;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.HtmlControls;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Xml.Linq;using System.Web.Services;public partial class AJAX_GetMsg : System.Web.UI.Page{    zab_HuiFang zhf = new zab_HuiFang();    zab_SheJiYQ zsj = new zab_SheJiYQ();    protected void Page_Load(object sender, EventArgs e)    {        DateTime now = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);        //提示框高度        int height = 100;        //客户回访数量 提早一天提示        int hfcount = 0;        DataTable hfdt = zhf.GetHFTongji(" and hf_khTime >= '" + now.AddDays(1) + "' and hf_khTime < '" + now.AddDays(2) + "'");        if (hfdt != null)        {            hfcount = hfdt.Rows.Count;        }        //设计图纸提交数量 提早一天提示        int sjcount = 0;        DataTable sjdt = zsj.GetSheJi(" and ((sj_timePm >= '" + now.AddDays(1) + "' and sj_timePm < '" + now.AddDays(2) + "' and sj_jiaoTuOneState = 1)"            + " or (sj_timeXg >= '" + now.AddDays(1) + "' and sj_timeXg < '" + now.AddDays(2) + "' and sj_jiaoTuTwoState = 1)"            + " or (sj_timeSg >= '" + now.AddDays(1) + "' and sj_timeSg < '" + now.AddDays(2) + "' and sj_jiaoTuThreeState = 1)"            + " or (sj_timeQT >= '" + now.AddDays(1) + "' and sj_timeQT < '" + now.AddDays(2) + "' and sj_jiaoTuFourState = 1))");        if (sjdt != null)        {            sjcount = sjdt.Rows.Count;        }        string msg = string.Empty;        if (hfcount != 0)        {            msg += "明天需要回访的客户有:" + hfcount + "个
"; height += 30; } if (sjcount != 0) { msg += "明天需要提交的图纸有:" + sjcount + "个
"; height += 30; } if (!string.IsNullOrEmpty(msg)) { msg += "时间:" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "
" + "■" + height; } Response.Write(msg); }}

 

转载于:https://www.cnblogs.com/tianrui/p/3393797.html

你可能感兴趣的文章
解决升级系统导致的 curl: (48) An unknown option was passed in to libcurl
查看>>
Shell命令-内置命令及其它之watch、date
查看>>
Java Session 介绍;
查看>>
spoj TBATTLE 质因数分解+二分
查看>>
Django 模型层
查看>>
第8章-方法
查看>>
dedecms讲解-arc.listview.class.php分析,列表页展示
查看>>
Microsoft SQL Server Transact-SQL
查看>>
Font: a C++ class
查看>>
Extjs6 经典版 combo下拉框数据的使用及动态传参
查看>>
Java四种引用包括强引用,软引用,弱引用,虚引用
查看>>
【NodeJS】http-server.cmd
查看>>
iOS bundle identifier 不一致,target general的Bundle Identifier后面总是有三条灰色的横线...
查看>>
研磨JavaScript系列(五):奇妙的对象
查看>>
xpath
查看>>
IOS开发基础知识--碎片25
查看>>
对比传统的Xilinx AMP方案和OPENAMP方案-xapp1078和ug1186
查看>>
面试题2
查看>>
selenium+java iframe定位
查看>>
js基础
查看>>