把日期作为查询条件的方法

最新推荐文章于 2023-11-20 09:14:12 发布

最新推荐文章于 2023-11-20 09:14:12 发布 · 528 阅读

string start = this.txt_beginDate.Text;
string end = this.txt_endDate.Text;
DateTime start1 = Convert.ToDateTime(txt_beginDate.Text);//
DateTime end1 = Convert.ToDateTime(txt_endDate.Text);
if (start1 > end1)
{
ScriptManager.RegisterStartupScript(this, GetType(), "84", "alert('起始日期不能晚于结束日期');", true);
return false;
}else

{

1.)_filter += " and " + CAR_VIEW_车辆当前电瓶情况.COL_到期日期 + " between to_date('" + start + "','yyyy-MM-dd')" +

"and to_date('" + end + "','yyyy-MM-dd')";

2.) filter += " and " + CAR_VIEW_加油卡充值明细.COL_充值时间 + ">=to_date('" + start + "','yyyy-MM-dd') and " + CAR_VIEW_加油卡充值明细.COL_充值时间 + " <=to_date('" + end + "','yyyy-MM-dd')";

}