//给时间添加天
function AddDay(strInterval, Number, dtTmp) {
switch (strInterval) {
case 's': return new Date(Date.parse(dtTmp) + (1000 * Number));
case 'n': return new Date(Date.parse(dtTmp) + (60000 * Number));
case 'h': return new Date(Date.parse(dtTmp) + (3600000 * Number));
case 'd': return new Date(Date.parse(dtTmp) + (86400000 * Number));
case 'w': return new Date(Date.parse(dtTmp) + ((86400000 * 7) * Number));
case 'q': return new Date(dtTmp.getFullYear(), (dtTmp.getMonth()) + Number * 3, dtTmp.getDate());
case 'm': return new Date(dtTmp.getFullYear(), (dtTmp.getMonth()) + Number, dtTmp.getDate());
case 'y': return new Date((dtTmp.getFullYear() + Number), dtTmp.getMonth(), dtTmp.getDate());
}
}
使用如下：
AddDay（'d',2,new date()）这个是将时间向后移两天
Bind(DataGrid1,"select * from [work]");
Response.Clear();
Response.Charset="utf-8"; //输出
string Title = this.Title.Text;
Response.AppendHeader("Content-Disposition","attachment;filename="+System.Web.HttpUtility.UrlEncode(Title)+".xls");
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312"); //设置输出编码
System.IO.StringWriter osw=new System.IO.StringWriter();//new System.IO.StringWriter(myinfo);
System.Web.UI.HtmlTextWriter ohtw=new System.Web.UI.HtmlTextWriter(osw);
DataGrid1.RenderControl(ohtw);
Response.Write(osw);
Response.End();