string UserName = Session["UserName"].ToString();
int i=1;
SqlConnection con=new SqlConnection(ConfigurationManager.AppSettings["Connection"]);
con.Open();
string Da = DateTime.Now.ToLongDateString();
string sql = "select * from [Check] where UserName='"+UserName+ "' and shang="+i+" order by OndutyId desc";
SqlCommand com = new SqlCommand(sql,con);
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
string Check = dr["Checkdate"].ToString();
if (Check == Da)
{
Response.Write("<script>alert('你已完成上班考勤!')</script>");