日期段查询完美解决方案
首先要建立一个JS文件
MyCalendar.js
![]()
if(start_date_txt.Value==""||start_date_txt.Value==null)
![]()
{
![]()
start_date_txt.Value = System.DateTime.Now.ToString("yyyy-MM-dd");
![]()
}
![]()
if(end_date_txt.Value==""||end_date_txt.Value==null)
![]()
{
![]()
end_date_txt.Value = System.DateTime.Now.ToString("yyyy-MM-dd");
![]()
}
![]()
string betweenDate = " convert(char(10),Order_Date,120) between '"+Convert.ToDateTime(start_date_txt.Value).ToString("yyyy-MM-dd")+"' AND '"+Convert.ToDateTime(end_date_txt.Value).ToString("yyyy-MM-dd")+"'";
![]()
string zhangtai = zt(dlistTime.SelectedValue.ToString());
![]()
string Qsql = "where "+zhangtai+betweenDate;
![]()
BindGrid(Qsql);
MyCalendar.js
1 var DS_x,DS_y;
2 function dateSelector() //构造dateSelector对象，用来实现一个日历形式的日期输入框。
3 {
4 var myDate=new Date();
5 this.year=myDate.getFullYear()+1; //定义year属性，年份，默认值为当前系统年份。
6 this.month=myDate.getMonth()+1; //定义month属性，月份，默认值为当前系统月份。
7 this.date=myDate.getDate(); //定义date属性，日，默认值为当前系统的日。
8 this.inputName=''; //定义inputName属性，即输入框的name，默认值为空。注意：在同一页中出现多个日期输入框，不能有重复的name！
9 this.display=display; //定义display方法，用来显示日期输入框。
10 }
11
12 function display() //定义dateSelector的display方法，它将实现一个日历形式的日期选择框。
13 {
14 var week=new Array('日','一','二','三','四','五','六');
15
16 document.write("<style type=text/css>");
17 document.write(" .ds_font td,span { font: normal 12px 宋体; color: #000000; }");
18 document.write(" .ds_border { border: 1px solid #000000; cursor: hand; background-color: #DDDDDD }");
19 document.write(" .ds_border2 { border: 1px solid #000000; cursor: hand; background-color: #DDDDDD }");
20 document.write("</style>");
21
22 document.write("<input style='text-align:center;' size='10' id='DS_"+this.inputName+"' name='"+this.inputName+"' value='"+this.year+"-"+this.month+"-"+this.date+"' title=双击可进行编缉 ondblclick='this.readOnly=false;this.focus()' onblur='this.readOnly=true' readonly>");
23 document.write("<button style='width:30px;height:18px;font-size:12px;margin:1px;border:1px solid #A4B3C8;background-color:#DFE7EF;' type=button onclick=this.nextSibling.style.display='block' onfocus=this.blur()>选择</button>");
24
25 document.write("<div style='position:absolute;display:none;text-align:center;width:0px;height:0px;overflow:visible' onselectstart='return false;'>");
26 document.write(" <div style='position:absolute;left:-60px;top:20px;width:142px;height:165px;background-color:#F6F6F6;border:1px solid #245B7D;' class=ds_font>");
27 document.write(" <table cellpadding=0 cellspacing=1 width=140 height=20 bgcolor=#CEDAE7 onmousedown='DS_x=event.x-parentNode.style.pixelLeft;DS_y=event.y-parentNode.style.pixelTop;setCapture();' onmouseup='releaseCapture();' onmousemove='dsMove(this.parentNode)' style='cursor:move;'>");
28 document.write(" <tr align=center>");
29 document.write(" <td width=12% onmouseover=this.className='ds_border' onmouseout=this.className='' onclick=subYear(this) title='减小年份'><<</td>");
30 document.write(" <td width=12% onmouseover=this.className='ds_border' onmouseout=this.className='' onclick=subMonth(this) title='减小月份'><</td>");
31 document.write(" <td width=52%><b>"+this.year+"</b><b>年</b><b>"+this.month+"</b><b>月</b></td>");
32 document.write(" <td width=12% onmouseover=this.className='ds_border' onmouseout=this.className='' onclick=addMonth(this) title='增加月份'>></td>");
33 document.write(" <td width=12% onmouseover=this.className='ds_border' onmouseout=this.className='' onclick=addYear(this) title='增加年份'>>></td>");
34 document.write(" </tr>");
35 document.write(" </table>");
36
37 document.write(" <table cellpadding=0 cellspacing=0 width=140 height=20 onmousedown='DS_x=event.x-parentNode.style.pixelLeft;DS_y=event.y-parentNode.style.pixelTop;setCapture();' onmouseup='releaseCapture();' onmousemove='dsMove(this.parentNode)' style='cursor:move;'>");
38 document.write(" <tr align=center>");
39 for(i=0;i<7;i++)
40 document.write(" <td>"+week[i]+"</td>");
41 document.write(" </tr>");
42 document.write(" </table>");
43
44 document.write(" <table cellpadding=0 cellspacing=2 width=140 bgcolor=#EEEEEE>");
45 for(i=0;i<6;i++)
46 {
47 document.write(" <tr align=center>");
48 for(j=0;j<7;j++)
49 document.write(" <td width=10% height=16 onmouseover=if(this.innerText!=''&&this.className!='ds_border2')this.className='ds_border' onmouseout=if(this.className!='ds_border2')this.className='' onclick=getValue(this,document.all('DS_"+this.inputName+"'))></td>");
50 document.write(" </tr>");
51 }
52 document.write(" </table>");
53
54 document.write(" <span style=cursor:hand onclick=this.parentNode.parentNode.style.display='none'>【关闭】</span>");
55 document.write(" </div>");
56 document.write("</div>");
57
58 dateShow(document.all("DS_"+this.inputName).nextSibling.nextSibling.childNodes[0].childNodes[2],this.year,this.month)
59 }
60
61 function subYear(obj) //减小年份
62 {
63 var myObj=obj.parentNode.parentNode.parentNode.cells[2].childNodes;
64 myObj[0].innerHTML=eval(myObj[0].innerHTML)-1;
65 dateShow(obj.parentNode.parentNode.parentNode.nextSibling.nextSibling,eval(myObj[0].innerHTML),eval(myObj[2].innerHTML))
66 }
67
68 function addYear(obj) //增加年份
69 {
70 var myObj=obj.parentNode.parentNode.parentNode.cells[2].childNodes;
71 myObj[0].innerHTML=eval(myObj[0].innerHTML)+1;
72 dateShow(obj.parentNode.parentNode.parentNode.nextSibling.nextSibling,eval(myObj[0].innerHTML),eval(myObj[2].innerHTML))
73 }
74
75 function subMonth(obj) //减小月份
76 {
77 var myObj=obj.parentNode.parentNode.parentNode.cells[2].childNodes;
78 var month=eval(myObj[2].innerHTML)-1;
79 if(month==0)
80 {
81 month=12;
82 subYear(obj);
83 }
84 myObj[2].innerHTML=month;
85 dateShow(obj.parentNode.parentNode.parentNode.nextSibling.nextSibling,eval(myObj[0].innerHTML),eval(myObj[2].innerHTML))
86 }
87
88 function addMonth(obj) //增加月份
89 {
90 var myObj=obj.parentNode.parentNode.parentNode.cells[2].childNodes;
91 var month=eval(myObj[2].innerHTML)+1;
92 if(month==13)
93 {
94 month=1;
95 addYear(obj);
96 }
97 myObj[2].innerHTML=month;
98 dateShow(obj.parentNode.parentNode.parentNode.nextSibling.nextSibling,eval(myObj[0].innerHTML),eval(myObj[2].innerHTML))
99 }
100
101 function dateShow(obj,year,month) //显示各月份的日
102 {
103 var myDate=new Date(year,month-1,1);
104 var today=new Date();
105 var day=myDate.getDay();
106 var selectDate=obj.parentNode.parentNode.previousSibling.previousSibling.value.split('-');
107 var length;
108 switch(month)
109 {
110 case 1:
111 case 3:
112 case 5:
113 case 7:
114 case 8:
115 case 10:
116 case 12:
117 length=31;
118 break;
119 case 4:
120 case 6:
121 case 9:
122 case 11:
123 length=30;
124 break;
125 case 2:
126 if((year%4==0)&&(year%100!=0)||(year%400==0))
127 length=29;
128 else
129 length=28;
130 }
131 for(i=0;i<obj.cells.length;i++)
132 {
133 obj.cells[i].innerHTML='';
134 obj.cells[i].style.color='';
135 obj.cells[i].className='';
136 }
137 for(i=0;i<length;i++)
138 {
139 obj.cells[i+day].innerHTML=(i+1);
140 if(year==today.getFullYear()&&(month-1)==today.getMonth()&&(i+1)==today.getDate())
141 obj.cells[i+day].style.color='red';
142 if(year==eval(selectDate[0])&&month==eval(selectDate[1])&&(i+1)==eval(selectDate[2]))
143 obj.cells[i+day].className='ds_border2';
144 }
145 }
146
147 function getValue(obj,inputObj) //把选择的日期传给输入框
148 {
149 var myObj=inputObj.nextSibling.nextSibling.childNodes[0].childNodes[0].cells[2].childNodes;
150 if(obj.innerHTML)
151 inputObj.value=myObj[0].innerHTML+"-"+myObj[2].innerHTML+"-"+obj.innerHTML;
152 inputObj.nextSibling.nextSibling.style.display='none';
153 for(i=0;i<obj.parentNode.parentNode.parentNode.cells.length;i++)
154 obj.parentNode.parentNode.parentNode.cells[i].className='';
155 obj.className='ds_border2'
156 if(inputObj.name=='start_date')
157 document.all.start_date_txt.value = inputObj.value;
158 if(inputObj.name=='end_date')
159 document.all.end_date_txt.value = inputObj.value;
160 }
161
162 function dsMove(obj) //实现层的拖移
163 {
164 if(event.button==1)
165 {
166 var X=obj.clientLeft;
167 var Y=obj.clientTop;
168 obj.style.pixelLeft=X+(event.x-DS_x);
169 obj.style.pixelTop=Y+(event.y-DS_y);
170 }
171 }
2 function dateSelector() //构造dateSelector对象，用来实现一个日历形式的日期输入框。
3 {
4 var myDate=new Date();
5 this.year=myDate.getFullYear()+1; //定义year属性，年份，默认值为当前系统年份。
6 this.month=myDate.getMonth()+1; //定义month属性，月份，默认值为当前系统月份。
7 this.date=myDate.getDate(); //定义date属性，日，默认值为当前系统的日。
8 this.inputName=''; //定义inputName属性，即输入框的name，默认值为空。注意：在同一页中出现多个日期输入框，不能有重复的name！
9 this.display=display; //定义display方法，用来显示日期输入框。
10 }
11
12 function display() //定义dateSelector的display方法，它将实现一个日历形式的日期选择框。
13 {
14 var week=new Array('日','一','二','三','四','五','六');
15
16 document.write("<style type=text/css>");
17 document.write(" .ds_font td,span { font: normal 12px 宋体; color: #000000; }");
18 document.write(" .ds_border { border: 1px solid #000000; cursor: hand; background-color: #DDDDDD }");
19 document.write(" .ds_border2 { border: 1px solid #000000; cursor: hand; background-color: #DDDDDD }");
20 document.write("</style>");
21
22 document.write("<input style='text-align:center;' size='10' id='DS_"+this.inputName+"' name='"+this.inputName+"' value='"+this.year+"-"+this.month+"-"+this.date+"' title=双击可进行编缉 ondblclick='this.readOnly=false;this.focus()' onblur='this.readOnly=true' readonly>");
23 document.write("<button style='width:30px;height:18px;font-size:12px;margin:1px;border:1px solid #A4B3C8;background-color:#DFE7EF;' type=button onclick=this.nextSibling.style.display='block' onfocus=this.blur()>选择</button>");
24
25 document.write("<div style='position:absolute;display:none;text-align:center;width:0px;height:0px;overflow:visible' onselectstart='return false;'>");
26 document.write(" <div style='position:absolute;left:-60px;top:20px;width:142px;height:165px;background-color:#F6F6F6;border:1px solid #245B7D;' class=ds_font>");
27 document.write(" <table cellpadding=0 cellspacing=1 width=140 height=20 bgcolor=#CEDAE7 onmousedown='DS_x=event.x-parentNode.style.pixelLeft;DS_y=event.y-parentNode.style.pixelTop;setCapture();' onmouseup='releaseCapture();' onmousemove='dsMove(this.parentNode)' style='cursor:move;'>");
28 document.write(" <tr align=center>");
29 document.write(" <td width=12% onmouseover=this.className='ds_border' onmouseout=this.className='' onclick=subYear(this) title='减小年份'><<</td>");
30 document.write(" <td width=12% onmouseover=this.className='ds_border' onmouseout=this.className='' onclick=subMonth(this) title='减小月份'><</td>");
31 document.write(" <td width=52%><b>"+this.year+"</b><b>年</b><b>"+this.month+"</b><b>月</b></td>");
32 document.write(" <td width=12% onmouseover=this.className='ds_border' onmouseout=this.className='' onclick=addMonth(this) title='增加月份'>></td>");
33 document.write(" <td width=12% onmouseover=this.className='ds_border' onmouseout=this.className='' onclick=addYear(this) title='增加年份'>>></td>");
34 document.write(" </tr>");
35 document.write(" </table>");
36
37 document.write(" <table cellpadding=0 cellspacing=0 width=140 height=20 onmousedown='DS_x=event.x-parentNode.style.pixelLeft;DS_y=event.y-parentNode.style.pixelTop;setCapture();' onmouseup='releaseCapture();' onmousemove='dsMove(this.parentNode)' style='cursor:move;'>");
38 document.write(" <tr align=center>");
39 for(i=0;i<7;i++)
40 document.write(" <td>"+week[i]+"</td>");
41 document.write(" </tr>");
42 document.write(" </table>");
43
44 document.write(" <table cellpadding=0 cellspacing=2 width=140 bgcolor=#EEEEEE>");
45 for(i=0;i<6;i++)
46 {
47 document.write(" <tr align=center>");
48 for(j=0;j<7;j++)
49 document.write(" <td width=10% height=16 onmouseover=if(this.innerText!=''&&this.className!='ds_border2')this.className='ds_border' onmouseout=if(this.className!='ds_border2')this.className='' onclick=getValue(this,document.all('DS_"+this.inputName+"'))></td>");
50 document.write(" </tr>");
51 }
52 document.write(" </table>");
53
54 document.write(" <span style=cursor:hand onclick=this.parentNode.parentNode.style.display='none'>【关闭】</span>");
55 document.write(" </div>");
56 document.write("</div>");
57
58 dateShow(document.all("DS_"+this.inputName).nextSibling.nextSibling.childNodes[0].childNodes[2],this.year,this.month)
59 }
60
61 function subYear(obj) //减小年份
62 {
63 var myObj=obj.parentNode.parentNode.parentNode.cells[2].childNodes;
64 myObj[0].innerHTML=eval(myObj[0].innerHTML)-1;
65 dateShow(obj.parentNode.parentNode.parentNode.nextSibling.nextSibling,eval(myObj[0].innerHTML),eval(myObj[2].innerHTML))
66 }
67
68 function addYear(obj) //增加年份
69 {
70 var myObj=obj.parentNode.parentNode.parentNode.cells[2].childNodes;
71 myObj[0].innerHTML=eval(myObj[0].innerHTML)+1;
72 dateShow(obj.parentNode.parentNode.parentNode.nextSibling.nextSibling,eval(myObj[0].innerHTML),eval(myObj[2].innerHTML))
73 }
74
75 function subMonth(obj) //减小月份
76 {
77 var myObj=obj.parentNode.parentNode.parentNode.cells[2].childNodes;
78 var month=eval(myObj[2].innerHTML)-1;
79 if(month==0)
80 {
81 month=12;
82 subYear(obj);
83 }
84 myObj[2].innerHTML=month;
85 dateShow(obj.parentNode.parentNode.parentNode.nextSibling.nextSibling,eval(myObj[0].innerHTML),eval(myObj[2].innerHTML))
86 }
87
88 function addMonth(obj) //增加月份
89 {
90 var myObj=obj.parentNode.parentNode.parentNode.cells[2].childNodes;
91 var month=eval(myObj[2].innerHTML)+1;
92 if(month==13)
93 {
94 month=1;
95 addYear(obj);
96 }
97 myObj[2].innerHTML=month;
98 dateShow(obj.parentNode.parentNode.parentNode.nextSibling.nextSibling,eval(myObj[0].innerHTML),eval(myObj[2].innerHTML))
99 }
100
101 function dateShow(obj,year,month) //显示各月份的日
102 {
103 var myDate=new Date(year,month-1,1);
104 var today=new Date();
105 var day=myDate.getDay();
106 var selectDate=obj.parentNode.parentNode.previousSibling.previousSibling.value.split('-');
107 var length;
108 switch(month)
109 {
110 case 1:
111 case 3:
112 case 5:
113 case 7:
114 case 8:
115 case 10:
116 case 12:
117 length=31;
118 break;
119 case 4:
120 case 6:
121 case 9:
122 case 11:
123 length=30;
124 break;
125 case 2:
126 if((year%4==0)&&(year%100!=0)||(year%400==0))
127 length=29;
128 else
129 length=28;
130 }
131 for(i=0;i<obj.cells.length;i++)
132 {
133 obj.cells[i].innerHTML='';
134 obj.cells[i].style.color='';
135 obj.cells[i].className='';
136 }
137 for(i=0;i<length;i++)
138 {
139 obj.cells[i+day].innerHTML=(i+1);
140 if(year==today.getFullYear()&&(month-1)==today.getMonth()&&(i+1)==today.getDate())
141 obj.cells[i+day].style.color='red';
142 if(year==eval(selectDate[0])&&month==eval(selectDate[1])&&(i+1)==eval(selectDate[2]))
143 obj.cells[i+day].className='ds_border2';
144 }
145 }
146
147 function getValue(obj,inputObj) //把选择的日期传给输入框
148 {
149 var myObj=inputObj.nextSibling.nextSibling.childNodes[0].childNodes[0].cells[2].childNodes;
150 if(obj.innerHTML)
151 inputObj.value=myObj[0].innerHTML+"-"+myObj[2].innerHTML+"-"+obj.innerHTML;
152 inputObj.nextSibling.nextSibling.style.display='none';
153 for(i=0;i<obj.parentNode.parentNode.parentNode.cells.length;i++)
154 obj.parentNode.parentNode.parentNode.cells[i].className='';
155 obj.className='ds_border2'
156 if(inputObj.name=='start_date')
157 document.all.start_date_txt.value = inputObj.value;
158 if(inputObj.name=='end_date')
159 document.all.end_date_txt.value = inputObj.value;
160 }
161
162 function dsMove(obj) //实现层的拖移
163 {
164 if(event.button==1)
165 {
166 var X=obj.clientLeft;
167 var Y=obj.clientTop;
168 obj.style.pixelLeft=X+(event.x-DS_x);
169 obj.style.pixelTop=Y+(event.y-DS_y);
170 }
171 }
调用办法
1 <script language="javascript">
2 var myDate=new dateSelector();
3 myDate.year--;
4 myDate.inputName='start_date';
5 myDate.display();
6 </script>
7 <p align="center">至</p>
8 <script language="javascript">
9 var myDate=new dateSelector();
10 myDate.year--;
11 myDate.inputName='end_date';
12 myDate.display();
13 </script>
2 var myDate=new dateSelector();
3 myDate.year--;
4 myDate.inputName='start_date';
5 myDate.display();
6 </script>
7 <p align="center">至</p>
8 <script language="javascript">
9 var myDate=new dateSelector();
10 myDate.year--;
11 myDate.inputName='end_date';
12 myDate.display();
13 </script>
1 <INPUT id="start_date_txt" type="hidden" size="0" name="start_date_txt" runat="server">
2 <INPUT id="end_date_txt" type="hidden" size="0" name="end_date_txt" runat="server">
2 <INPUT id="end_date_txt" type="hidden" size="0" name="end_date_txt" runat="server">
if(start_date_txt.Value==""||start_date_txt.Value==null)
{
start_date_txt.Value = System.DateTime.Now.ToString("yyyy-MM-dd");
} if(end_date_txt.Value==""||end_date_txt.Value==null) { end_date_txt.Value = System.DateTime.Now.ToString("yyyy-MM-dd"); } string betweenDate = " convert(char(10),Order_Date,120) between '"+Convert.ToDateTime(start_date_txt.Value).ToString("yyyy-MM-dd")+"' AND '"+Convert.ToDateTime(end_date_txt.Value).ToString("yyyy-MM-dd")+"'"; string zhangtai = zt(dlistTime.SelectedValue.ToString()); string Qsql = "where "+zhangtai+betweenDate; BindGrid(Qsql);
浙公网安备 33010602011771号