sql
create table Name
(
id int primary key IDentity(1,1)
piPeiDateTime datetime,
)
C#
int id= Convert.ToInt32(context.Request.Params["id"].ToString());
List<dbParam> list = new List<dbParam>() {
new dbParam(){ ParamName="@id",ParamValue=id},
};
Name name= nameDAL.m_nameDal.GetModel("id=@id", list);
if (name!= null)
{
name.piPeiDateTime =Convert.ToDateTime(DateTime.Now.ToString());
nameDAL.m_nameDal.Update(order);
}
else
{
res = "error";
}
html
<div class="guidTime">
<dl>
<dd>您已等候:<font><!--1分42秒--></font></dd>
</dl>
</div>
jq
let timer;
$.ajax({
url: "url",
data: {data},
success: function (data) {
var obj = jQuery.parseJSON(data);
console.log(obj);
console.log(obj.piPeiDateTime);
if (obj.piPeiDateTime === "1900-01-01T00:00:00") {
console.log("ajax更新命令");
} else {
timer=setInterval(function () {
//显示数据库时间和当前时间的差值
var date1 =obj.piPeiDateTime; //开始时间
var date2 = new Date(); //结束时间
var date3 = date2.getTime() - new Date(date1).getTime(); //时间差的毫秒数
//计算出相差天数
// var days = Math.floor(date3 / (24 * 3600 * 1000));
//计算出小时数
var leave1 = date3 % (24 * 3600 * 1000) //计算天数后剩余的毫秒数
var hours = Math.floor(leave1 / (3600 * 1000));
//计算相差分钟数
var leave2 = leave1 % (3600 * 1000) //计算小时数后剩余的毫秒数
var minutes = Math.floor(leave2 / (60 * 1000));
//计算相差秒数
var leave3 = leave2 % (60 * 1000) //计算分钟数后剩余的毫秒数
var seconds = Math.round(leave3 / 1000);
//alert(minutes + " 分钟" + seconds + " 秒");
$(".guidTime dl dd font").text(hours + "时" + minutes + "分" + seconds + "秒");
if (hours >= "00" &&minutes >= "30") { or if (hours >= "0" &&minutes >= "30")
console.log(等待30分钟以上);
}
if (hours >= "02" && minutes >= "30") {
clearInterval(timer);
console.log(等待2个小时30分钟以上);
}
}, 1000);
}
}
});