Search

最新推荐文章于 2024-07-18 08:38:09 发布

csdou

最新推荐文章于 2024-07-18 08:38:09 发布

阅读量614

点赞数

分类专栏：代码收藏整理文章标签： search server button input javascript class

本文链接：https://blog.csdn.net/csdou/article/details/6965712

版权

代码收藏整理专栏收录该内容

56 篇文章 0 订阅

订阅专栏

<script language="javascript" src="../../My97DatePicker/WdatePicker.js" type="text/javascript"></script>
<table border="0" cellpadding="0" cellspacing="0">
    <tr>                                
        <td>
            日期：<input id="txtBeginTime" runat="server" class="Wdate" name="txtBeginTime" οnfοcus="new WdatePicker(this,'%Y-%M-%D',true)"
                size="15" />
        </td>
        <td>
            到<input id="txtEndTime" runat="server" class="Wdate" name="txtEndTime" οnfοcus="new WdatePicker(this,'%Y-%M-%D',true)"
                size="15" />
        </td>
        <td style="width: 10px">
        </td>
        <td>
            星级：
        </td>
        <td>
            <input id="txtHotelStar" runat="server" size="10" />
        </td>
        <td style="width: 10px">
        </td>
        <td>
            酒店名称：
        </td>
        <td>
            <input id="txtHotelName" runat="server" size="20" />
        </td>
        <td style="width: 10px">
        </td>
        <td>
            <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="搜索" Width="80px" />
        </td>
    </tr>
</table>

DateTime beginTime;
DateTime endTime;

if (txtBeginTime.Value.Trim() == "")
{
    beginTime = DateTime.Parse("1970-1-1 00:00:00");
}
else
{
    beginTime = DateTime.Parse(txtBeginTime.Value.Trim());
}

if (txtEndTime.Value.Trim() == "")
{
    endTime = DateTime.Now.AddDays(1);
}
else
{
    endTime = DateTime.Parse(txtEndTime.Value.Trim());
}

select HTime from HotelTime where cast(HTime as datetime) between cast('" + beginTime + "' as datetime) and cast('" + endtime + "' as datetime) Group by HTime order by HTime desc

select HTime,HotelInfo.HotelID,HotelName,HStarName from HotelTime left join HotelInfo on HotelInfo.HotelID=HotelTime.HotelID where HTime='" + timeHotel + "' and HotelName like '%" + hotelName + "%' and HStarName like '%" + hotelStar + "%'

var dpcfg = {};
dpcfg.skin = "default";		
dpcfg.dateFmt = "%Y-%M-%D";
dpcfg.realValueShortFmt = "%Y-%M-%D";
dpcfg.realValueLongFmt = "%Y-%M-%D %h:%m:%s";
dpcfg.showTime = false;	
dpcfg.highLineWeekDay = true;
dpcfg.minDate = "1900-1-1";
dpcfg.maxDate = "2099-12-30";
dpcfg.errDealMode = 0;