核心提示:FINEUI中时间查询框的写法,f:DatePicker runat='server' Required='false' DateFormatString='yyyy-MM-dd HH:mm:ss'...
FINEUI中时间查询框的写法,
<f:DatePicker runat="server" Required="false" DateFormatString="yyyy-MM-dd HH:mm:ss" width="200px" EmptyText="请选择开始日期" ID="bdate" ShowRedStar="false">
</f:DatePicker>
// HH-mm-ss中的HH表示24小时,hh则表示12小时
//获取当前日期时间字符串
edate.Text=System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
//获取当天零点日期时间字符串
bdate.Text = System.DateTime.Now.ToShortDateString();
bdate.Text = bdate.Text + " 00:00:00";
SQL
where (time between '" + bdate.Text + "' and '" + edate.Text + "')