dbo.ui_listSermon @SQLType = '1',@PageSize = 25,@NowPage = 1,@Search_Key=' AND (U.UserName NOT IN (SELECT Category FROM t_CD_UserGroup WHERE (ThreadID like ''1001071%'' ) AND Status=1)) AND (U.UserNum NOT IN (SELECT U.UserNum FROM t_User U, t_LK_UserGroup LK_U WHERE U.UserNum = LK_U.UserNum and GroupNum in (111,112,114))) AND ( (S.FileNum7 IS NOT NULL AND S.FileNum7 > 0) or (S.FileNum4 IS NOT NULL AND S.FileNum4 > 0) or (S.MsgNum=''1'') ) ' ,@CodeNum = 100 ,@Search_Order_Name='s_date' ,@Search_Order_Type='DOWN'
dbo.ui_listSermon @SQLType = '0',@PageSize = 25,@NowPage = 1,@Search_Key=' AND (U.UserName NOT IN (SELECT Category FROM t_CD_UserGroup WHERE (ThreadID like ''1001071%'' ) AND Status=1)) AND (U.UserNum NOT IN (SELECT U.UserNum FROM t_User U, t_LK_UserGroup LK_U WHERE U.UserNum = LK_U.UserNum and GroupNum in (111,112,114))) AND ( (S.FileNum7 IS NOT NULL AND S.FileNum7 > 0) or (S.FileNum4 IS NOT NULL AND S.FileNum4 > 0) or (S.MsgNum=''1'') ) ' ,@CodeNum = 100 ,@Search_Order_Name='s_date' ,@Search_Order_Type='DOWN'
dbo.ui_listSubMenu @TBL_NAME='t_CD_Service',@Search_Key = ' AND CodeNum = 100'
