博客
关于我
强烈建议你试试无所不能的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

你可能感兴趣的文章
【转】Android底层库和程序
查看>>
OnContextMenu事件(转)
查看>>
Comparación para 2019 Nueva Lonsdor K518S y K518ISE
查看>>
论文笔记——MobileNets(Efficient Convolutional Neural Networks for Mobile Vision Applications)
查看>>
从今天开始
查看>>
Attribute(特性)与AOP
查看>>
[翻译] CBStoreHouseTransition
查看>>
第三次作业
查看>>
Codeforces 962 /2错误 相间位置排列 堆模拟 X轴距离最小值 前向星点双连通分量求只存在在一个简单环中的边...
查看>>
Matrix快速幂 模板
查看>>
laravel command调用方法命令
查看>>
20162302 - 20162319 结对编程项目-四则运算(第一周)
查看>>
用python2和python3伪装浏览器爬取网页
查看>>
MySQL开启远程连接权限
查看>>
tomcat7.0.27的bio,nio.apr高级运行模式
查看>>
SAP HANA 三大特点
查看>>
C#预处理器命令
查看>>
苹果手表:大方向和谷歌一样,硬件分道扬镳
查看>>
ccf 出现次数最多的数
查看>>
单例模式
查看>>