±í Category
itemId itemName
--------------------------
100 A
101 B
102 C
±í Area
areaId areaName
--------------------------
100 ......
a£º±í
×Ö¶Î id name
1 Àî
2 Íõ
3 ÕÅ
b£º±í
×Ö¶Î p_id file id
a1 aaaa 1
......
ÈçºÎÈ¡ÏûsqlÖе¥Ôª¸ñÖ»¶ÁÊôÐÔ
£¿Ã×Ã÷°×
ÒýÓÃ
ÈçºÎÈ¡ÏûsqlÖе¥Ôª¸ñÖ»¶ÁÊôÐÔ
Ī·ÇlzÒªÐ޸IJéѯºóµÄ½á¹û?????
û¸ã¶®
ÕâÊÇǰ̨³ÌÐòµÄDATAGRIDVIEWÖаÉ,
ÓиöREADONLYÊôÐÔ
?
ÎÒµÄÒâ˼ÊÇ˵sqlÖеıíÀÓÐÒ»ÁÐÊý¾ÝÊÇÉèÖÃÖ»¶ÁÊôÐԵģ¬ÎÒÏë°Ñ¸ÃÁеÄÊý¾ÝÉèÖÃΪ¿É±à¼µÄ£¬ËÄܸæËßÎÒ£¬Ð»Ð»
2000µÄÆóÒµ¹ÜÀíÆ÷Àï´ò ......
select * from zzq_shangjia_liuyan where UserName in (select card_id from [card] where card_sales='"&session("gwid")&"'£©
±¨´í£ºËµ¡°£©¡±¸½½üÓÐÓï·¨´íÎó£¡
²»ÖªµÀ´íÔÚÄÄÀïÁË!
Èç¹û°Ñ'"&session("gwid")&"' Ö± ......
×î½üÓÃintraWeb, ºÜ¶à·½Ê½ÒªÓô«²Î·½Ê½.¸ÕûÊÂ,дÁËÒ»¸öÍæ. Ï£ÍûÓÐÓÃ. ˳±ãÉ¢·Ö
SQL code:
--select * from KcbWebRegMast
execute PR_GetParaSql 'KcbWebRegMast'
if Exists (select 1 from sysobjects where xtype = 'P' And name = 'PR_GetParaSql')
drop procedure dbo.PR_GetParaSq ......
(case when convert(varchar(16),ʱ¼ä×Ö¶Î,120) between convert(varchar(10),ʱ¼ä×Ö¶Î,120)+' 00:00' and convert(varchar(10),ʱ¼ä×Ö¶Î,120)+' 04:59' then convert(varchar(10),ʱ¼ä×Ö¶Î-1,120)
"else convert(varchar(10),vdatetime2,120) end) as ʱ¼ä¶Î
ÏÖÔÚ¿ÉÒÔʵÏÖ£¬±ÈÈç×òÌì5µãµ½Ã ......