在if语句中查询 [英] query in if statement

问题描述

我已经尝试过此代码，但是它总是给我ouptut，请下午检查一下并告诉我我哪里出问题了....

i have tried this code but its always giving me ouptut as afternoon please check it and tell me where i go wrong....

if (DateTime.Now.Hour >= 00 && DateTime.Now.Hour <= 11.59)
               {
                   query = "UPDATE Registration_Master SET session= 'MORNING' WHERE regCode= '" + code + "'";
                   com = new SqlCommand(query, con);
                   com.CommandType = CommandType.Text;
                   com.ExecuteNonQuery();
               }
               else if (DateTime.Now.Hour >= 1 && DateTime.Now.Hour <= 17)
               {
                   query = "UPDATE Registration_Master SET session= 'AFTERNOON' WHERE regCode= '" + code + "'";
                   com = new SqlCommand(query, con);
                   com.CommandType = CommandType.Text;
                   com.ExecuteNonQuery();
               }
               else if (DateTime.Now.Hour >= 18 && DateTime.Now.Hour <= 19)
               {
                   query = "UPDATE Registration_Master SET session= 'EVENING' WHERE regCode= '" + code + "'";
                   com = new SqlCommand(query, con);
                   com.CommandType = CommandType.Text;
                   com.ExecuteNonQuery();
               }
               else if (DateTime.Now.Hour >= 20 && DateTime.Now.Hour <= 24)
               {
                   query = "UPDATE Registration_Master SET session= 'NIGHT' WHERE regCode= '" + code + "'";
                   com = new SqlCommand(query, con);
                   com.CommandType = CommandType.Text;
                   com.ExecuteNonQuery();
               }

推荐答案

尝试(保持24小时制1pm-> 13):

Try (keep the 24hr format 1pm -> 13):

else if (DateTime.Now.Hour >= 13 && DateTime.Now.Hour <= 17)

DateTime.Now.Hour是Integer值，从0到23不等. ..尝试以下代码:

DateTime.Now.Hour is Integer value, and it varies from 0 to 23... try the code below:

string session = "";
  if (DateTime.Now.Hour >= 6 && DateTime.Now.Hour < 12)
      {
         session = "Morning";
      }
      else if (DateTime.Now.Hour >= 12 && DateTime.Now.Hour < 18)
      {
         session = "Afternoon";
      }
      else if (DateTime.Now.Hour >= 18 && DateTime.Now.Hour < 20)
      {
         session = "Evening";
      }
      else
      {
         session = "Night";
      }

       query = "UPDATE Registration_Master SET session= '" + session +"' WHERE regCode= '" + code + "'";
       com = new SqlCommand(query, con);
       com.CommandType = CommandType.Text;
       com.ExecuteNonQuery();

早晨
00至12
午后
12.01至17
晚上
17.01至19
夜晚
19.01至24

请更改条件，然后尝试..

Morning
00 to 12
AfterNoon
12.01 to 17
Evening
17.01 to 19
Night
19.01 to 24

Please change if condition and try this..

这篇关于在if语句中查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！