排班知识点

select *  FROM V_MANAGERPLAN  where  
(SEAT_ID in (45,46)) and  (GETDATE() between  BeginTime and  EndTime) 
 order by Shift_sortid,seatSort

<span class="sWeek">
                <%=DateTime.Now.ToString("yyyy-MM-dd") %> <%=System.Globalization.CultureInfo.CurrentCulture.DateTimeFormat.GetDayName(DateTime.Now.DayOfWeek)%></span>

var time1=$.trim($("#sUserName1").html() == "暂无排班信息")==true?30000:1800000;
        setInterval(function () { LoadScheduling(); }, time1);

 var nowtime = new Date();
        var time = nowtime.getFullYear() + "-" + nowtime.getMonth() + "-" + nowtime.getDate();
        var starttime = time + " 8:40";
        var endtime = time + " 9:40";
        var stime = new Date(starttime.replace("-", "/").replace("-", "/"));
        var etime = new Date(endtime.replace("-", "/").replace("-", "/"));

border-bottom: 1px dashed #666;

    border-radius: 19px;
    letter-spacing: 2px;

 <a href="/Desktop/Scheduling"
                target="_blank"><span class="<%=btnclass %>"><%=seeAll %></span></a>

 Regex reg = new Regex(@"^[0-9]*$");
                sid = !reg.IsMatch(t) ? "" : sid;

public ActionResult Scheduling(DateTime? StartTime, DateTime? EndTime, string sid)
        {
            DateTime stime = StartTime == null ? DateTime.Now.AddDays(-1) : DateTime.Parse(StartTime.ToString());
            DateTime etime = EndTime == null ? DateTime.Now.AddDays(1) : DateTime.Parse(EndTime.ToString());

string strParam = Request.Params["param"];
if ( strParam== null )
{
    strParam= "";
}
 
string strParam=
  Request.Params["param"] == null ? "": Request.Params["param"];

//如果左边为null，取所赋值??右边的
//比如int y = x ?? -1 如果x为空，那么y的值为-1.
string strParam= Request.Params["param"]?? "";