$rowcount = $csql1->GetTotalRow();
echo "<tr class='row1_color_head'><td>货号</td><td>名称</td><td>规格</td><td>分类</td><td>单位</td><td>售价</td><td>供应商<td>入库数量</td><td>操作</tr>";
while ($row = $csql1->GetArray()) {
$nsql = new dedesql(false);
$query1 = "select * from #@__basic where cp_number='" . $row['productid'] . "'";
$nsql->setquery($query1);
$nsql->execute();
$row1 = $nsql->getone();
echo "<tr onMouseMove=\"javascript:this.bgColor='#EBF1F6';\" onMouseOut=\"javascript:this.bgColor='#FFFFFF';\"><td>" . $row['productid'] . "</td><td> " . $row1['cp_name'] . "</td><td>" . $row1['cp_gg'] . "</td><td>" . get_name($row1['cp_categories'], 'categories') . ">" . get_name($row1['cp_categories_down'], 'categories') . "</td><td>" . get_name($row1['cp_dwname'], 'dw') . "</td><td>￥" . $row1['cp_sale'] . "</td><td>" . $row1['cp_gys'] . "</td><td>" . $row['number'] . "</td><td><a href=''></a></td></tr>";
$nsql->close();
}
$csql1->close();
echo "</table><br></td></tr>\r\n";
}
$csql->close();
echo "<tr><td colspan='6'> " . $dlist->GetPageList($cfg_record) . "</td></tr></table>\r\n </td></tr></table>\r\n </td></tr> <tr>\r\n <td id=\"table_style\" class=\"l_b\"> </td>\r\n <td> </td>\r\n <td id=\"table_style\" class=\"r_b\"> </td>\r\n </tr>\r\n</table>";
} else {
?>
<body onload="form1.seek_text.focus()">
<table width="100%" border="0" id="table_style_all" cellpadding="0" cellspacing="0">
<tr>
<td id="table_style" class="l_t"> </td>
<td> </td>
<td id="table_style" class="r_t"> </td>
</tr>
<tr>
<td> </td>
<td>
<table width="100%" border="0" cellpadding="0" cellspacing="2">
<tr>
<td><strong><strong> 销售管理</strong> - <a href="sale.php">新单</a> - <a href="sale.php?action=seek">销售单查询</a></td>
//设置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();
?>
</td>
</tr></form>
</table>
</td>
<td> </td>
</tr>
<tr>
<td id="table_style" class="l_b"> </td>
<td> </td>
<td id="table_style" class="r_b"> </td>
</tr>
</table>
<?php
require_once(dirname(__FILE__)."/config.php");
CheckPurview('member_List');
require_once(dirname(__FILE__)."/../include/pub_datalist_dm.php");
$query = "select * from #@__score2money_logs order by dateline desc";
$dlist = new DataList();
$dlist->Init();
$dlist->pageSize = 20;
$dlist->SetSource($query);
$log = $dlist->GetDataList();
$logs = array();
while($row = $log->GetArray('dm')) {
$row['dbdateline'] = GetDateTimeMk($row['dateline']);
$row['dbtype'] = $row['type'] == 'score2money' ? '积分 → 金币' : '金币 → 积分';
$logs[] = $row;
}
$page = $dlist->GetPageList(7);
require_once(dirname(__FILE__)."/templets/money2score.htm");
ClearAllLink();
?>