110,533
社区成员
发帖
与我相关
我的任务
分享
protected void btn_add_Click(object sender, EventArgs e)
{
//顶一个一个时间变量
DateTime datet_begin = new DateTime();
//顶一个一个时间变量
DateTime datet_end = new DateTime();
TimeSpan tsp = new TimeSpan();
int i_days;
string str_sql_where = "";
//取得查询条件的启示和结束时间
string str_begin = this.txt_dBegindate.Text.ToString().Trim();
string str_end = this.txt_dEnddate.Text.ToString().Trim();
if (str_begin.Trim() != "")//不为空在做
{
datet_begin = Convert.ToDateTime(str_begin);
tsp = datet_begin - DateTime.Now;
//距离现在多少天
i_days = tsp.Days;
// 数据库查询,DateDiff功能:距离现在多少天
str_sql_where = " and DateDiff(d,GetDate(),dBegindate) >= " + i_days.ToString();
}
if (str_end.Trim() != "")//同上
{
datet_end = Convert.ToDateTime(str_end);
tsp = datet_end - DateTime.Now;
i_days = tsp.Days;
str_sql_where = str_sql_where + " and DateDiff(d,GetDate(),dEnddate) <= " + i_days.ToString();
}
//应该是个类.实例化
PagedDataSource pds = new PagedDataSource();
pds.DataSource = DataBind_Gv();
pds.AllowPaging = true;
pds.CurrentPageIndex = 0;
pds.PageSize = AspNetPager.PageSize;
//绑定
this.Gv.DataSource = pds;
this.Gv.DataBind();
}