jQuery UI的Datapicker和日期从DB（asp.net） [英] jQuery UI Datapicker and dates from DB (asp.net)

问题描述

有没有办法从数据库加载日期和粘贴它来做日期选择器，使来自DB该日期可能对在日期选择该日期diferent类（彩色），还是有其他的日历，可以做到这一点。

Is there way to load dates from DB and paste it do datepicker so that that date from DB would have diferent class (colour) on that date in datepicker, or is there other calendar that can do that.

推荐答案

下面的脚本从数据库中读取日期值并将它们作为数组日历 [＆LT;％= sBlockedDates％]的计算值

Script Below reads date value from Database and passes them as array to calendar [<%=sBlockedDates%>]

实际的数组例如

var holiDays = [[2012,25, 12, 'Christmas'],[2012,7, 7, 'WEEKEND Event'],[2012,7, 13, 'Some Holiday'],[2012,7, 14, 'Festival']];

脚本的UI日历

除了禁止低于previous日期这个脚本和日期比+90天＆放越大;也阻断日期数组传递。您可以更改脚本根据你的逻辑。

Besides this script below disable previous dates and dates greater than +90 Days & also blocks date passed as array. You can alter the script to according to your logic.

function BindEvents()
{
//Script for Calendar
        var holiDays = [<%=sBlockedDates%>];
        $(function () {
            $("#<%=txtBookingDate.ClientID %>").datepicker({
                dateFormat: "yy-mm-dd",
                minDate: "-0d",
                maxDate: "+90d",
                firstDay: 0,
                beforeShowDay: noWeekendsOrHolidaysOrBlockedDates
            });

            function noWeekendsOrHolidaysOrBlockedDates(date) {
                //var noWeekend = jQuery.datepicker.noWeekends(date);
                return setHoliDays(date);
            }

            // set holidays function which is configured in beforeShowDay
            function setHoliDays(date) {
                var day = date.getDay();
                if (day == 5 || day ==6) return [false, 'CalWeekEnd', ];

                for (i = 0; i < holiDays.length; i++) {
                    if (date.getFullYear() == holiDays[i][0]
                        && date.getMonth() == holiDays[i][1] - 1
                        && date.getDate() == holiDays[i][2]) {
                        return [false, 'holiday', holiDays[i][3]];
                    }
                }
                return [true, ''];
            }
        });
}

BindEvents();  

这篇关于jQuery UI的Datapicker和日期从DB（asp.net）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！