¹ØÓÚasp.net mvc ·ÖÒ³¼Ó²éѯµÄÎÊÌâ
±¾ÈËÔÚ×öÒ»¸ö²©¿ÍµÄ¹«¸æÀ¸ ¹¦ÄÜÓзÖÒ³ºÍËÑË÷ »¹Ó¦¸ÃÓÐÅÅÐò£¬ÅÅÐòÔݲ»Ì¸ÂÛ£¬Controller´úÂëÈçÏÂ
public ActionResult Index(int? page)
{
int currentPageIndex = page.HasValue ? page.Value - 1 : 0;
IList <BoardMain> list = service.GetAllBoardMain();
return View(list.ToPagedList(currentPageIndex, defaulstPageSize));
}
public ActionResult IndexFind(int? page, string Find)
{
int currentPageIndex = page.HasValue ? page.Value - 1 : 0;
IList <BoardMain> list = service.GetAllBoardMain(Find);
return View(list.ToPagedList(currentPageIndex, defaulstPageSize));
}
µÚÒ»¸öIndex action ÊDzéѯȫ²¿ Service,GetAllBoardMain()·µ»Ø ILIst <BoardMain(ʵÌåÀà)>Ð͵ļ¯ºÏ
µÚ¶þ¸öIndexFInd Action ·µ»Ø °´ÊäÈëÌõ¼þ²éѯ³öÀ´µÄÈ«²¿ ·µ»ØÀàÐÍͬÉÏ °´Ìõ¼þ²éѯ ¼Ó¸öFind,FindÊÇViewÒ³Ãæ¶ÔÓ¦µÄTextBoxµÄÃû³Æ.
ÎÊÌâ:ÔÚÎÒ²éѯ³ö°´Ìõ¼þ²éѯºó ÏÔʾÊÇûÎÊÌâ Ò»¹²¿ÉÄÜÓкܶàÒ³Êý,µ«ÊÇÎÒ°´ÏÂÒ»Ò³ »áÌøµ½ Index action ¾ÍÊÇûÓÐÌõ¼þµÄÄǸöaction ÏëÇë¸ßÈ˰ïÎÒ½â¾öÕâ¸öÎÊÌâ ±¾È
Ïà¹ØÎÊ´ð£º
select top 12 * from Product where [id] not in (select top 12 [id] from Product)
ÕâÑù¿ÉÒÔ·ÖÒ³£¬µ«ÊÇÎÒÔÚºóÃæÏë¼Ó¸öÌõ¼þ
select top 12 * from Product where [id] not in (select top 12 [id] from Prod ......
ÎÒÔÚºǫ́µ÷ÓÃJavaScriptµÄʱºò£¬ËûÊÇÔÚºǫ́°ÑʼþµÄ´úÂëÖ´ÐÐÒ»´ÎºóÔÚÖ´ÐÐJavaScript·½·¨
ÓÐʲô°ì·¨ ÔÚÖ´ÐÐJavaScript·½·¨µÄʱºòͣס£¬ÔÚÖ´ÐкóÃæµÄ´úÂë
²»Ì«Ã÷°×°¡£¬ËµÇå³þµã°É
¾ÍÊÇÖ´Ðкǫ́´úÂëµÄʱºò ......
µ÷ÕûÁËÕâÀÄÇÀï³öÎÊÌâ¡£
ÓÐûÓÐʲôºÃµÄ·½·¨£¬Ïñµ÷Õû¶Ô»°¿òÒ»Ñù£¿£¿£¿£¿
ÕÒ¸öרÃÅ×öÒ³ÃæµÄ
ÔÚdreamweaverÀïµ÷¡£¡£¡£Ò²¿ÉÒÔÖ±½Ó¿ØÖÆHTML´úÂë
ȷʵʹ¿à ¸ÐͬÉíÊÜѽ
¹þ¹þ ¼á¾ö·¹ý¡£
ÓÃDW°É£¬VS¸ãÉè¼Æ ......
CREATE PROCEDURE [selectvipcompany]
@username varchar(50),
@companyname varchar(50),
@endtime varchar(1)
AS
declare @sql varchar(1000)
set @sql='' ......