if($folder=="inbox"||$folder=='') $postuser = "******"; if(!empty($keyword)) $whereSql .= " AND (subject like '%".$keyword."%' OR message like '%".$keyword."%')"; if(!empty($username)) $whereSql .= " AND msgfrom like '%".$username."%'"; function GetFolders($me){ if($me=="track") return "发件箱"; else if($me=="inbox") return "收件箱"; else if($me=="outbox") return "草搞箱"; } function IsReader($me){ $me = ereg_replace("[^0-1]","",$me); if($me) return "<font color='green'>×</font>"; else return "<font color='red'>√</font>"; } $sql = "SELECT * FROM #@__pms $whereSql ORDER BY dateline desc"; $dlist = new DataList(); $dlist->Init(); $dlist->SetParameter("folder",$folder); $dlist->SetParameter("username",$username); $dlist->SetParameter("keyword",$keyword); $dlist->SetSource($sql); $dlist->SetTemplet(dirname(__FILE__)."/templets/member_pm.htm"); $dlist->display(); $dlist->Close(); ClearAllLink(); ?>
function GetSta($sta) { if($sta==1) return "内页"; if($sta==2) return "首页"; else return "未审核"; } $addquery = " where 1=1 "; if($ischeck!=-1){ if($ischeck==3) $addquery .= " And ischeck>0 "; else $addquery .= " And ischeck='$ischeck' "; } if(!empty($keyword)){ $addquery .= " And (url like '%$keyword%' OR webname like '%$keyword%') "; } $sql = ""; $sql = "Select * From #@__flink $addquery order by dtime desc"; $dlist = new DataList(); $dlist->Init(); $dlist->SetParameter("ischeck",$ischeck); $dlist->SetParameter("keyword",$keyword); $dlist->SetSource($sql); $dlist->SetTemplet(dirname(__FILE__)."/templets/friendlink_main.htm"); $dlist->display(); $dlist->Close(); ClearAllLink(); ?>
case "4": //按肋记词 $query = "select * from #@__mainkc,#@__basic where #@__basic.cp_helpword LIKE '%" . $stext . "%' and #@__basic.cp_categories='{$cp_categories}' and #@__basic.cp_categories_down='{$cp_categories_down}' and #@__mainkc.p_id=#@__basic.cp_number"; break; } } else { $query = "select * from #@__mainkc,#@__basic where #@__mainkc.p_id=#@__basic.cp_number"; } //echo $query; //exit(); $csql = new Dedesql(false); $dlist = new DataList(); $dlist->pageSize = $cfg_record; //设置GET参数表 if ($action == 'seek') { $dlist->SetParameter("action", $action); $dlist->SetParameter("cp_categories", $cp_categories); $dlist->SetParameter("cp_categories_down", $cp_categories_down); $dlist->SetParameter("sort", $sort); $dlist->SetParameter("stext", $stext); } $dlist->SetSource($query); echo "<tr class='row_color_head'><td>货号</td><td>名称</td><td>规格</td><td>分类</td><td>单位</td><td>进价</td><td>供应商</td><td>所在仓库</td><td>库存</td><td>选择</td></tr>"; $mylist = $dlist->GetDataList(); while ($row = $mylist->GetArray('dm')) { echo "<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\">\r\n<td>" . $row['p_id'] . "</td><td> " . $row['cp_name'] . "</td><td>" . $row['cp_gg'] . "</td><td>" . get_name($row['cp_categories'], 'categories') . ">" . get_name($row['cp_categories_down'], 'categories') . "</td><td>" . get_name($row['cp_dwname'], 'dw') . "</td><td>¥" . $row['cp_jj'] . "</td><td>" . get_name($row['p_id'], 'gys') . "</td><td>" . get_name($row['l_id'], 'lab') . "</td><td><font color=red>" . $row['number'] . "</font></td><td><a href='system_kc_edit.php?pid=" . $row['cp_number'] . "&lid=" . $row['l_id'] . "&n=" . $row['number'] . "'>修改</a>|<a href='system_kc_del.php?action=del&id=" . $row['cp_number'] . "'>删除</a><input type='checkbox' name='sel_pro" . $row['id'] . "' value='" . $row['id'] . "'></td>\r\n</tr>"; } echo "<tr><td colspan='8'> " . $dlist->GetPageList($cfg_record) . "</td></tr>"; echo "</table>"; $csql->close(); ?>
<tr> <td bgcolor="#FFFFFF"> <?php echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">"; if ($action == 'seek') { if ($s_number == '') { echo "<script>alert('请输入要退货的销售单号');history.go(-1);</script>"; } $query = "select * from #@__sale where rdh='{$s_number}' and productid LIKE '%" . $stext . "%'"; } else { $query = "select * from #@__sale"; } $csql = new Dedesql(false); $dlist = new DataList(); $dlist->pageSize = $cfg_record; $dlist->SetParameter("form", $form); $dlist->SetParameter("field", $field); //设置GET参数表 if ($action == 'seek') { $dlist->SetParameter("action", $action); $dlist->SetParameter("s_number", $s_number); $dlist->SetParameter("stext", $stext); } $dlist->SetSource($query); echo "<tr class='row_color_head'><td>货号</td><td>名称</td><td>规格</td><td>售价</td><td>供应商</td><td>销售单号</td><td>选择</td></tr>"; $mylist = $dlist->GetDataList(); while ($row = $mylist->GetArray('dm')) { echo "<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\">\r\n<td>" . $row['productid'] . "</td><td> " . get_name($row['productid'], 'name') . "</td><td>" . get_name($row['productid'], 'gg') . "</td><td>¥" . getsale($row['productid']) . "</td><td>" . get_name($row['productid'], 'gys') . "</td><td>" . $row['rdh'] . "</td><td><input type='checkbox' name='sel_pro" . $row['id'] . "' value='" . get_name($row['productid'], 'name') . "' onclick=\"selectpro(this.value," . $row['productid'] . ",'" . get_name($row['productid'], 'gg') . "','" . get_name(get_name($row['productid'], 'dwname'), 'dw') . "')\"></td>\r\n</tr>"; } echo "<tr><td colspan='8'> " . $dlist->GetPageList($cfg_record) . "</td></tr>"; echo "</table>";
} function IsExData($isex){ if($isex==0) return "未导出"; else return "已导出"; } if($nid!=""){ $exportbt = "<input type='button' name='b0' value='导出采集内容' class='inputbut' style='width:100' onClick=\"location.href='co_export.php?nid=$nid';\"> "; } else{ $exportbt = ""; } $sql .= "Select #@__courl.aid,#@__courl.nid,#@__courl.isex,#@__courl.title,#@__courl.url,"; $sql .= "#@__courl.dtime,#@__courl.isdown,#@__conote.gathername From #@__courl "; $sql .= " left join #@__conote on #@__conote.nid=#@__courl.nid $where"; $sql .= " order by #@__courl.aid desc"; $dlist = new DataList(); $dlist->Init(); $dlist->SetParameter("nid",$nid); $dlist->SetParameter("small",$small); $dlist->SetSource($sql); if($small==0) include(dirname(__FILE__)."/templets/co_url.htm"); else include(dirname(__FILE__)."/templets/co_url_2.htm"); $dlist->Close(); ClearAllLink(); ?>
<?php require_once(dirname(__FILE__)."/config.php"); require_once(dirname(__FILE__)."/../include/pub_datalist_dm.php"); setcookie("ENV_GOBACK_URL",$dedeNowurl,time()+3600,"/"); $bgcolor = ""; if(!isset($keyword)) $keyword=""; if(!isset($typeid)) $typeid="0"; function IsCheck($st) { if($st==1) return "[已审核]"; else return "<font color='red'>[未审核]</font>"; } $querystring = "select * from #@__feedback where CONCAT(#@__feedback.msg,#@__feedback.arctitle) like '%$keyword%' order by dtime desc"; $dlist = new DataList(); $dlist->pageSize = 10; $dlist->Init(); $dlist->SetParameter("typeid",$typeid); $dlist->SetParameter("keyword",$keyword); $dlist->SetSource($querystring); include(dirname(__FILE__)."/templets/feedback_main.htm"); $dlist->Close(); ClearAllLink(); ?>
<?php require_once(dirname(__FILE__)."/config.php"); require_once(dirname(__FILE__)."/../include/pub_datalist_dm.php"); setcookie("ENV_GOBACK_URL",$dedeNowurl,time()+3600,"/"); function GetSta($sta) { if($sta==1) return "正常"; else return "<font color='red'>禁用</font>"; } function GetMan($sta) { if($sta==1) return "<u>禁用</u>"; else return "<u>启用</u>"; } if(empty($keywords)) $keywords = ""; $sql = "Select * from #@__keywords order by rank desc"; $dlist = new DataList(); $dlist->Init(); $dlist->pageSize = 300; $dlist->SetParameter("f",$f); $dlist->SetSource($sql); include(dirname(__FILE__)."/templets/article_keywords_select.htm"); $dlist->Close(); ClearAllLink(); ?>
} } function GetAreaName($e,$df) { global $Areas; if(isset($Areas[$e])) return $Areas[$e]; else return $df; } function GetMAtt($m){ if($m<1) return ""; else return "<img src='img/adminuserico.gif' width='16' height='15'><font color='red'>(荐)</font>"; } $sql = "select ID,userid,pwd,uname,sex,email,money,c1,c2,c3,matt, logintime,loginip,membertype,scores,spaceshow,pageshow From #@__member $whereSql order by $sortkey desc "; $dlist = new DataList(); $dlist->Init(); $dlist->SetParameter("sex",$sex); $dlist->SetParameter("status",$status); $dlist->SetParameter("keyword",$keyword); $dlist->SetSource($sql); $dlist->SetTemplet(dirname(__FILE__)."/templets/member_main.htm"); $dlist->display(); $dlist->Close(); ClearAllLink(); ?>
<?php require_once(dirname(__FILE__)."/config.php"); require_once(dirname(__FILE__)."/../include/pub_datalist_dm.php"); setcookie("ENV_GOBACK_URL",$dedeNowurl,time()+3600,"/"); function GetSta($sta) { if($sta==1) return ""; else return " checked"; } if(empty($keyword)){ $keyword = ""; $addquery = ""; } else $addquery = " where keyword like '%$keyword%'"; $sql = "Select * from #@__keywords $addquery order by rank desc"; $dlist = new DataList(); $dlist->Init(); $dlist->pageSize = 30; $dlist->SetParameter("keyword",$keyword); $dlist->SetSource($sql); include(dirname(__FILE__)."/templets/article_keywords_main.htm"); $dlist->Close(); ClearAllLink(); ?>
<tr> <td> </td> <td> <table width="100%" border="0" cellpadding="0" cellspacing="2"> <tr> <td><strong> 销售单管理</strong> - <a href="sale.php">新单</a></td> </tr> <tr> <td bgcolor="#FFFFFF"> <?php echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">"; $query = "select * from #@__reportsale"; $csql = new Dedesql(false); $dlist = new DataList(); $dlist->pageSize = $cfg_record; $dlist->SetParameter("action", $action); //设置GET参数表 $dlist->SetSource($query); echo "<tr class='row_color_head'><td>ID</td><td>销售单号</td><td>操作人员</td><td>创单时间</td><td>保存状态</td><td>相关操作</td></tr>"; $mylist = $dlist->GetDataList(); while ($row = $mylist->GetArray('dm')) { if ($row['r_status'] == 1) { $statusstring = "<img src='images/yes.png'>"; } else { $statusstring = "<img src='images/no.png'>"; } echo "<tr><td>ID号:" . $row['id'] . "</td><td> " . $row['r_dh'] . "</td><td> " . $row['r_people'] . "</td><td> " . $row['r_date'] . "</td><td> " . $statusstring . "</td><td><span onclick=showsubinfo(" . $row['id'] . ") style='cursor:hand;'>展开详情</span> | <a href=system_basic_del.php?id=" . $row['id'] . ">打印此单</a></td></tr>"; echo "<tr id='rk_subinfo" . $row['id'] . "' style='display:none;'><td colspan='6'><br><table width=\"98%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\" align=\"center\">"; $csql1 = new Dedesql(false); $csql1->SetQuery("select * from #@__sale where rdh='" . $row['r_dh'] . "'"); $csql1->Execute();
<?php echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">"; if ($action == 'seek') { if ($stext == '' || !is_numeric($stext) || $stext < 0) { echo "<script>alert('请输入正确的数字');history.go(-1);</script>"; } $query = "select * from #@__mainkc,#@__basic where #@__mainkc.number<'{$stext}' and #@__mainkc.p_id=#@__basic.cp_number"; } else { $query = "select * from #@__mainkc,#@__basic where #@__mainkc.number<5 and #@__mainkc.p_id=#@__basic.cp_number"; } $csql = new Dedesql(false); $dlist = new DataList(); $dlist->pageSize = $cfg_record; //设置GET参数表 if ($action == 'seek') { $dlist->SetParameter("action", $action); $dlist->SetParameter("stext", $stext); } $dlist->SetSource($query); echo "<tr class='row_color_head'><td>货号</td><td>名称</td><td>规格</td><td>分类</td><td>单位</td><td>进价</td><td>供应商</td><td>所在仓库</td><td>库存</td><td>选择</td></tr>"; $mylist = $dlist->GetDataList(); while ($row = $mylist->GetArray('dm')) { echo "<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\">\r\n<td>" . $row['p_id'] . "</td><td> " . $row['cp_name'] . "</td><td>" . $row['cp_gg'] . "</td><td>" . get_name($row['cp_categories'], 'categories') . ">" . get_name($row['cp_categories_down'], 'categories') . "</td><td>" . get_name($row['cp_dwname'], 'dw') . "</td><td>¥" . $row['cp_jj'] . "</td><td><a href='' title='查看与该供应商的数据'>" . get_name($row['p_id'], 'gys') . "</a></td><td><a href='' title='查看此仓库所有产品'>" . get_name($row['l_id'], 'lab') . "</a></td><td><font color=red>" . $row['number'] . "</font></td><td><a href='system_kc_edit.php?pid=" . $row['cp_number'] . "&lid=" . $row['l_id'] . "&n=" . $row['number'] . "'>修改</a>|<a href='system_kc_del.php?action=del&id=" . $row['cp_number'] . "'>删除</a><input type='checkbox' name='sel_pro" . $row['id'] . "' value='" . $row['id'] . "'></td>\r\n</tr>"; } echo "<tr><td colspan='8'> " . $dlist->GetPageList($cfg_record) . "</td></tr>"; echo "</table>"; $csql->close(); ?> </td> </tr></form> </table>
$nowtime = time(); $starttime = $nowtime - ($dtime*24*3600); $where .= " And #@__log.dtime>'$starttime' "; } $sql = "Select #@__log.*,#@__admin.userid From #@__log left join #@__admin on #@__admin.ID=#@__log.adminid where 1=1 $where order by #@__log.lid desc"; $adminlist = ""; $dsql = new DedeSql(false); $dsql->SetQuery("Select ID,uname From #@__admin"); $dsql->Execute('admin'); while($myrow = $dsql->GetObject('admin')){ $adminlist .="<option value='{$myrow->ID}'>{$myrow->uname}</option>\r\n"; } $dsql->Close(); $dlist = new DataList(); $dlist->Init(); $dlist->pageSize = 20; $dlist->SetParameter("adminid",$adminid); $dlist->SetParameter("cip",$cip); $dlist->SetParameter("dtime",$dtime); $dlist->SetSource($sql); include(dirname(__FILE__)."/templets/log_list.htm"); $dlist->Close(); ClearAllLink(); ?>
$whereSql .= " And (arc.title like '%$keyword%' Or arc.keywords like '%$keyword%' Or arc.addinfos like '%$keyword%') "; } if($typeid!=0){ $tids = $tl->GetSunID($typeid,'',$channelid,true); $whereSql .= " And arc.typeid in($tids) "; } $query = " select arc.aid as ID,arc.typeid,arc.uptime,arc.channelid,arc.arcrank,arc.title, arc.litpic,arc.adminID,arc.mid,t.typename,c.typename as channelname from `#@__full_search` arc left join #@__arctype t on t.ID=arc.typeid left join #@__channeltype c on c.ID=arc.channelid $whereSql order by aid desc "; $dlist = new DataList(); $dlist->pageSize = 20; $dlist->SetParameter("dopost","listArchives"); $dlist->SetParameter("keyword",$keyword); $dlist->SetParameter("cid",$cid); $dlist->SetParameter("f",$f); $dlist->SetParameter("arcrank",$arcrank); $dlist->SetParameter("channelid",$channelid); $dlist->SetSource($query); include(dirname(__FILE__)."/templets/content_select_list.htm"); ClearAllLink(); ?>
$CheckUserSend = "<input type='button' onClick=\"location='full_list.php?arcrank=-1&channelid=$channelid';\" value='稿件审核' class='inputbut'>"; } if(empty($orderby)) $orderby = "aid"; $query = " select a.aid,a.adminid,a.typeid,a.uptime,a.channelid,a.arcrank,a.click,a.title,a.litpic,a.adminid,a.mid, t.typename,c.typename as channelname,adm.uname as adminname from `#@__full_search` a left join `#@__arctype` t on t.ID=a.typeid left join `#@__channeltype` c on c.ID=a.channelid left join `#@__admin` adm on adm.ID=a.adminid $whereSql order by a.aid desc "; $dsql = new DedeSql(false); $dlist = new DataList(); $dlist->pageSize = 20; $dlist->SetParameter("dopost","listArchives"); $dlist->SetParameter("keyword",$keyword); $dlist->SetParameter("adminid",$adminid); $dlist->SetParameter("memberid",$memberid); $dlist->SetParameter("cid",$cid); $dlist->SetParameter("arcrank",$arcrank); $dlist->SetParameter("channelid",$channelid); $dlist->SetParameter("ismember",$ismember); $dlist->SetParameter("orderby",$orderby); $dlist->SetSource($query); include_once(dirname(__FILE__)."/templets/full_list.htm"); $dlist->Close(); ClearAllLink(); ?>
if(empty($buyid)) $buyid = ''; $addsql = " where buyid like '%$buyid%' "; if(isset($sta)){ $addsql .= " And sta='$sta' "; } $sql = "Select * From #@__member_operation $addsql order by aid desc"; $dlist = new DataList(); $dlist->Init(); $dlist->SetParameter("buyid",$buyid); if(isset($sta)){ $dlist->SetParameter("sta",$sta); } $dlist->dsql->SetQuery("Select * From #@__moneycard_type "); $dlist->dsql->Execute('ts'); while($rw = $dlist->dsql->GetArray('ts')){ $TypeNames[$rw['tid']] = $rw['pname']; } $dlist->SetSource($sql); include(dirname(__FILE__)."/templets/member_operations.htm"); $dlist->Close(); ClearAllLink();
else return "附件/其它"; } function GetFileSize($fs){ $fs = $fs/1024; return sprintf("%10.1f",$fs)." K"; } if(empty($keyword)) $keyword = ""; $addsql = " where (title like '%$keyword%' Or url like '%$keyword%') "; if($mediatype==2) $addsql .= " And (mediatype='2' OR mediatype='3') "; else if($mediatype>0) $addsql .= " And mediatype='$mediatype' "; $addsql .= " And memberid='{$cfg_ml->M_ID}' "; $sql = "Select aid,title,url,mediatype,filesize,uptime From #@__uploads $addsql order by aid desc"; //echo $sql; $dlist = new DataList(); $dlist->pageSize = 20; $dlist->Init(); $dlist->SetParameter("mediatype",$mediatype); $dlist->SetParameter("keyword",$keyword); $dlist->SetParameter("f",$f); $dlist->SetSource($sql); include(dirname(__FILE__)."/all_medias.htm"); $dlist->Close(); ?>
if($sta==1) return '已售出'; else if($sta==-1) return '已使用'; else return '未使用'; } $addsql = ''; if(isset($isexp)){ $addsql = " where isexp='$isexp' "; } $sql = "Select * From #@__moneycard_record $addsql order by aid desc"; $dlist = new DataList(); $dlist->Init(); if(isset($isexp)){ $dlist->SetParameter("isexp",$isexp); } $dlist->dsql->SetQuery("Select * From #@__moneycard_type "); $dlist->dsql->Execute('ts'); while($rw = $dlist->dsql->GetArray('ts')){ $TypeNames[$rw['tid']] = $rw['pname']; } $dlist->SetSource($sql); include(dirname(__FILE__)."/templets/member_card.htm"); $dlist->Close(); ClearAllLink(); ?>
} else { $query = "select * from #@__accounts where dtime between '{$cp_sdate}' and '{$cp_edate}' order by dtime desc"; } } else { if ($atype != '') { $query = "select * from #@__accounts where atype='{$atype}' order by dtime desc"; } else { $query = "select * from #@__accounts order by dtime desc"; } } $csql = new Dedesql(false); $dlist = new DataList(); $dlist->pageSize = $cfg_record; //设置GET参数表 if ($action == 'seek') { $dlist->SetParameter("action", $action); $dlist->SetParameter("cp_sdate", $cp_sdate); $dlist->SetParameter("cp_edate", $cp_edate); } $dlist->SetSource($query); echo "<tr><td colspan='8' align='right'>" . $moneystring . " </td></tr>"; echo "<tr class='row_color_head'><td>ID号</td><td>科目</td><td>账户</td><td>操作用户</td><td>日期</td><td>金额</td><td>备注</td><td>选择</td></tr>"; $mylist = $dlist->GetDataList(); while ($row = $mylist->GetArray('dm')) { $cmoney += $row['amoney']; echo "<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\">\r\n<td>" . $row['id'] . "</td><td> <a href='{$hurl}" . $row['atype'] . "'>" . $row['atype'] . "</td><td>" . getbank($row['abank']) . "</td><td>" . $row['apeople'] . "</td><td>" . $row['dtime'] . "</td><td>¥" . $row['amoney'] . "</td><td>" . $row['atext'] . "</td><td><input type='checkbox' name='sel_pro" . $row['id'] . "' value='" . $row['id'] . "'></td>\r\n</tr>"; } echo "<tr><td colspan=\"8\"> 总计: ¥" . $cmoney . "元</td></tr>"; echo "<tr><td colspan='8'> " . $dlist->GetPageList($cfg_record) . "</td></tr>"; echo "</table>"; $csql->close();
if(empty($membertype)) $membertype = 0; if($membertype==1) $addsql .= " And u.adminID>0 "; else if($membertype==2) $addsql .= " And u.memberID>0 "; if(empty($mediatype)) $mediatype = 0; if($mediatype>1) $addsql .= " And u.mediatype='$membertype' "; if(!empty($memberid)) $addsql .= " And u.memberID='$memberid' "; else $memberid = 0; if(!empty($memberid)) $addsql .= " And u.memberid='$memberid' "; $sql = "Select u.aid,u.title,u.url,u.mediatype,u.filesize,u.memberID,u.uptime ,a.userid as adminname,m.userid as membername From #@__uploads u Left join #@__admin a on a.ID = u.adminID Left join #@__member m on m.ID = u.memberID $addsql order by u.aid desc"; $dlist = new DataList(); $dlist->pageSize = 10; $dlist->SetParameter("mediatype",$mediatype); $dlist->SetParameter("keyword",$keyword); $dlist->SetParameter("membertype",$membertype); $dlist->SetParameter("memberid",$memberid); $dlist->SetSource($sql); include(dirname(__FILE__)."/templets/media_main.htm"); $dlist->Close(); ClearAllLink(); ?>
} $wheresql .= " and typeid2=$sectorid2"; } if($comname != ''){ $wheresql .= " and comname LIKE '%".$comname."%'"; } $wheresql = trim($wheresql); if(eregi("^and", $wheresql)) { $wheresql = substr($wheresql,3); } if($wheresql != ''){ $wheresql = 'where '.trim($wheresql); } $companys = array(); $query = "select id, comname, regyear, areaid, areaid2, service, typeid1, typeid2, comaddr, website, postid from #@__member_cominfo $wheresql"; $dlist = new DataList(); $dlist->pageSize = 10; $dlist->SetParameter("sectorid",$sectorid); $dlist->SetParameter("sectorid2",$sectorid2); $dlist->SetParameter("areaid",$areaid); $dlist->SetParameter("comname",$comname); $dlist->SetParameter("areaid2",$areaid2); $dlist->SetSource($query); include(dirname(__FILE__)."/template/default/search_list.htm"); ?>
global $dsql; global $untjs; if(!isset($untjs[$nid])) { $dsql->SetSql("Select count(aid) as kk From #@__courl where nid='$nid'"); $dsql->Execute(); $row = $dsql->GetObject(); $kk = $row->kk; $untjs[$nid] = $kk." "; } return $untjs[$nid]; } $where = ""; if(!isset($typeid)) $typeid=""; if(!empty($typeid)) $where = " where #@__conote.typeid='$typeid' "; $sql = "Select #@__conote.nid,#@__conote.typeid,#@__conote.gathername,#@__conote.language,"; $sql .= "#@__conote.savetime,#@__conote.lasttime,#@__co_exrule.rulename as typename From #@__conote "; $sql .= "left join #@__co_exrule on #@__co_exrule.aid=#@__conote.typeid "; $sql .= " $where order by nid desc"; $dlist = new DataList(); $dlist->Init(); $dlist->SetParameter("typeid",$typeid); $dlist->SetSource($sql); $dlist->SetTemplet(dirname(__FILE__)."/templets/co_main.htm"); $dlist->display(); $dlist->Close(); ClearAllLink(); ?>