[RDLC] RDLC報表檔IIF使用方式

使用IIF 判斷DataSet傳回欄位值傳回True 就顯示 "是",反之顯示"否"

=First(IIF(Fields!IsAll.Value = "True","是","否"), "DataSet1")

[Jquery]尋找元素

<li onclick="SetRoomNumber('209', '雙人房', '');" class="list">
     <span class="fontSize14px fontweight fontColorBlue2">209</span>
     <div class="roomStatusTxt">
             <span class="fontColorBlack">空房</span>
              <span class="fontColorBrown">雙人房</span>
     </div>
</li>

尋找items 下li裡span class = "fontColorBlack"
$("#items").on("click", "li", function (e) {
    $(this).find("span.fontColorBlack").html() ;
});
結果:空房

[Jquery]將CheckBox 勾選

$("#UseShareForm").prop('checked', res.UseShareForm);

[JSON] 將傳回JSON日期格式化

Birthday傳回格式 : /Date(1418900173730)/
var parsedDate = new Date(parseInt(JData[i].Birthday.substr(6)));
                    var customBirthday = new Date(parsedDate);
                    customBirthday = customBirthday.getFullYear() + "/" + (customBirthday.getMonth() + 1) + "/" + customBirthday.getDate();

格式化後:2014/12/18

[SQL] IN 使用資料表值函示傳回table篩選條件

資料列表

1.建立function
CREATE FUNCTION GetWeekStrings (@roomListID int)
RETURNS TABLE
AS
RETURN (
         SELECT [Week] FROM RoomOpenSet WHERE RoomListID= 1
          )

2.找出資料Week欄位不等於 2,3,4
SELECT *, DATEPART(WEEKDAY, StartDate -1) as [Week] FROM RoomOpen WHERE RoomListID = 1 AND convert(varchar,DATEPART(WEEKDAY, StartDate -1)) not in
(
  Select * From GetWeekStrings(1)
)

結果為下表,過濾掉星期2,3,4 只撈出星期五的資料

[SQL]如何將多筆資料列的值組成同一欄位

原本的資料列表

但是我想將Week欄位組成 2,3,4 使用stuff

select stuff(Strings.MarkUp,1,1,'') as [Week]
from
(
select RoomListID,
(
SELECT ',' +cast([Week] AS NVARCHAR)
FROM RoomOpenSet  
WHERE RoomListID=ro2.RoomListID
for xml path('')
)MarkUp
from RoomOpenSet ro2
GROUP BY RoomListID
) as Strings
where RoomListID = 1

[JavaScript]格林威治時間轉換

dates =  Fri Dec 19 2014 12:00:00 GMT+0800 (台北標準時間)
var d = new Date(dates);
var year = d.getFullYear();
var month = d.getMonth() + 1;
var day = d.getDate();
alert(year + "/" + month + "/" + day)
輸出結果: 2014/12/19