根据时间进行查询

最新推荐文章于 2022-12-02 17:23:36 发布

iteye_8644

最新推荐文章于 2022-12-02 17:23:36 发布

阅读量497

点赞数

文章标签： ui xhtml javascript ViewUI

前台：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="selectData.aspx.cs" Inherits="YC.SH.WEB.selectData" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <mce:script src="js/calendars.js" mce_src="js/calendars.js" type="text/javascript"></mce:script> <mce:script src="js/validate.js" mce_src="js/validate.js" type="text/javascript"></mce:script> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> <mce:style type="text/css"></mce:style><style type="text/css" mce_bogus="1"> .input01 { height: 18px; width: 170px; background-color: #fff; border: 1px solid #a6b9bf; } .input02 { height: 18px; width: 170px; background-color: #FFEEC2; border: 1px solid #4B4B6F; } .btn02 { width: 60px; height: 24px; border: 1px solid #87a3c1; background: url(../images/ContentPage/submitbg.gif); color: #555; font-size: 12px; line-height: 180%; cursor: pointer; } .btn04 { width: 60px; height: 24px; border: 1px solid #a2904d; background: url(../images/ContentPage/submitbg.gif) 0 -66px; color: #630; font-size: 12px; cursor: pointer; line-height: 180%; } </style> <mce:script type="text/javascript" language="javascript"></mce:script> </head> <body> <form id="form1" runat="server"> <div> <table> <tr> <td align="right" nowrap> <asp:CheckBox ID="cb_lastPhotoTime" Text="最后拍照时间：" runat="server" οnclick="enabledDate(this);" Checked="true" /> </td> <td align="left"> <table cellpadding="0" cellspacing="0"> <tr> <td> <asp:TextBox ID="tb_start" runat="server" CssClass="input01" οnblur="this.className='input01';" οnfοcus="this.className='input02';this.select();setday(this);" Width="123px" /> </td> <td align="center" nowrap width="20px"> 到 </td> <td> <asp:TextBox ID="tb_end" runat="server" CssClass="input01" οnblur="this.className='input01';" οnfοcus="this.className='input02';this.select();setday(this);" Width="123px" /> </td> </tr> </table> </td> <td align="left" nowrap> <input id="btn_Serch" type="button" value="查询" οnclick="filterValidate();" class="btn02" οnmοuseοver="this.className='btn04'" οnmοuseοut="this.className='btn02'" /> </td> </tr> </table> </div> </form> </body> </html>

后台：

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using YC.SH.DataAccess.PictureCompare;//插入的类 namespace YC.SH.WEB { public partial class selectData : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { loadDate(); } /// <summary> /// 加载日期 /// </summary> private void loadDate() { //日期控件要用readOnly在后台写，否则取不到值 tb_start.Attributes.Add("ReadOnly", "ReadOnly"); tb_end.Attributes.Add("ReadOnly", "ReadOnly"); tb_start.Text = DateTime.Now.AddDays(-1).ToString(); tb_end.Text = DateTime.Now.ToString(); } //查询 private string getFilter() { string filter = " 1=1 "; if (cb_lastPhotoTime.Checked) { string startDate = tb_start.Text.Trim(); string endDate = tb_end.Text.Trim(); if (!string.IsNullOrEmpty(startDate) && !string.IsNullOrEmpty(endDate)) { //V_PHOTO_HISTORYPHOTODLST.Col_拍照时间：就是查询的字段 //=查询 //filter += " and " + string.Format(T_SHGPS_CARPHOTO.Col_CATCHPHOTOTIME + "= to_date('{0}', 'yyyy-MM-dd HH24:MI:SS') ", tb_photoTime.Text); //between查询 filter += " and " + string.Format(V_PHOTO_HISTORYPHOTODLST.Col_拍照时间 + " between to_date( '" + tb_start.Text + "', 'yyyy-MM-dd HH24:mi:ss') and to_date( '" + tb_end.Text + "', 'yyyy-MM-dd HH24:mi:ss')"); } } return filter; } } }

iteye_8644

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
根据时间进行查询

前台：&lt;%@ Page Language="C#" AutoEventWireup="true" CodeBehind="selectData.aspx.cs" Inherits="YC.SH.WEB.selectData" %&gt;&lt;!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" &
复制链接

扫一扫