MVC 学习笔记

1.设置控件最大长度，最大输入长度，只能输入数字

<%=Html.TextBox("txtVal", null, new { size = "2", maxlength = "2", onkeyup = "value=value.replace(/[^\\d]/g,'') " })%>

2.取得控件却对位置

//top
$("#txtValYear").offset().top;
//left
$("#txtValYear").offset().left;

3.ROW_Number()应用 分页是用

SELECT *
FROM (SELECT row_number() over(order by A.OrderID) as rownum, A.* 
        FROM (SELECT
                        *
                        FROM dbo.TOrd_Orders log
                        ) A
     ) B
WHERE B.rownum between 100 and 200;