jQuery基礎テスト.

1--strResultの値を求めます.

    var string1 = "hello";
    var string2 = "hello";
    var strObject1 = new String(string1);
    var strObject2 = new String(string2);
    var strResult = "";
    if (string1 == string2) {
        strResult += " 1";
    }
    if (strObject1 == strObject2) {
        strResult += " 2";
    }
    if (strObject1.valueOf() == strObject2) {
        strResult += " 3";
    }
    alert(strResult);

答え:1 3
2-result 1、result 2、result 3の値を求めます.

<div id="test">
    <span style="color:Red">test1</span>test2
</div>
<script type="text/javascript">
    var dom = document.getElementById("test");
    var result1 = dom.innerHTML;
    var result2 = dom.innerText;
    var result3 = dom.outerHTML;
    alert(result3);
</script>

答:result 1は:test 1test 2
result 2は:test 1 test 2
result 3は、div全体
 

ALTER PROCEDURE [dbo].[prProductSel]
	@PageIndex INT,
	@PageSize INT,
	@PageCount INT =0 OUTPUT,
	@RecordCount INT =0 OUTPUT,
	@O_Return INT=-1 OUTPUT
AS
BEGIN
	SET NOCOUNT ON;
	
	SELECT ROW_NUMBER()OVER(ORDER BY OrderID DESC) AS SN,
		   ProductID,
		   Title, 
		   [Description],
		   LinkUrl,
		   ImgUrl,
		   IsShow, 
		   OrderID,
		   CreatedUserID,
		   CreatedTime,
		   ModifiedUserID, 
		   ModifiedTime, 
		   IsValid
    INTO  #temp 
	FROM  dbo.Product 
	WHERE IsValid=1;
		  
    SELECT ProductID,
		   Title, 
		   [Description],
		   LinkUrl,
		   ImgUrl,
		   IsShow,
		   OrderID,
		   CreatedUserID,
		   CreatedTime,
		   ModifiedUserID, 
		   ModifiedTime, 
           IsValid 
    FROM #temp
    WHERE SN>(@PageIndex-1)*@PageSize AND SN<=(@PageIndex)*@PageSize ORDER BY SN asc;
  
    SELECT @RecordCount=COUNT(*) FROM #temp;
    SELECT @PageCount=CEILING(@RecordCount*1.0/@PageSize);
    DROP TABLE #temp;
END