Пример #1
0
		 <td id="row_style">&nbsp;是否默认银行:</td>
		 <td>
		 &nbsp;<select name="b_default"><option value="1">是</option><option value="0" selected>否</option></select>&nbsp;只能保留一个默认银行</td>
	    </tr>
		<tr>
		 <td id="row_style">&nbsp;</td>
		 <td>&nbsp;<input type="submit" name="submit" value=" 添加账户 "></td>
	    </tr></form>
	   </table>
	   <?php 
} else {
    echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">";
    $csql = new Dedesql(false);
    $csql->SetQuery("select * from #@__bank");
    $csql->Execute();
    $rowcount = $csql->GetTotalRow();
    if ($rowcount == 0) {
        echo "<tr><td>&nbsp;还没添加银行账户,请先<a href=bank.php?action=new>添加账户</a>。</td></tr>";
    } else {
        echo "<tr class='row_color_head'><td>ID</td><td>银行名称</td><td>银行账号</td><td>金额</td><td>默认</td><td>备注</td><td>修改</td></tr>";
        while ($row = $csql->GetArray()) {
            if ($row['bank_default'] == 1) {
                $default_yes = "<img src=images/yes.png>";
            } else {
                $default_yes = "&nbsp;";
                $delstring = " | <a href=bank_del.php?id=" . $row['id'] . ">删除</a>";
            }
            echo "<tr><td>ID号:" . $row['id'] . "</td><td>&nbsp;" . $row['bank_name'] . "</td><td>&nbsp;" . $row['bank_account'] . "</td><td>&nbsp;¥" . $row['bank_money'] . "</td><td>&nbsp;" . $default_yes . "</td><td>" . $row['bank_text'] . "</td><td><a href=bank_edit.php?id=" . $row['id'] . ">修改</a>" . $delstring . "</td></tr>";
        }
    }
    echo "</table>";
<script language="javascript">
function cway(value){
if(value==0)
document.forms[0].s_e.value="%";
else
document.forms[0].s_e.value="元/件";
}
</script>
</head>
<body>
<?php 
$esql = new Dedesql(false);
$query = "select * from #@__staff where id='{$id}'";
$esql->SetQuery($query);
$esql->Execute();
if ($esql->GetTotalRow() == 0) {
    ShowMsg('非法调用参数,请重试', '-1');
    exit;
}
$row = $esql->GetOne($query);
$esql->close();
?>
<table width="100%" border="0" id="table_style_all" cellpadding="0" cellspacing="0">
  <tr>
    <td id="table_style" class="l_t">&nbsp;</td>
    <td>&nbsp;</td>
    <td id="table_style" class="r_t">&nbsp;</td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td>
Пример #3
0
function getadid($id)
{
    $s = new Dedesql(false);
    $query = "select * from #@__staff";
    $s->SetQuery($query);
    $s->Execute();
    $rowcount = $s->GetTotalRow();
    if ($rowcount == 0) {
        echo "<a href='system_worker.php?action=new'>请先添加员工</a>";
    } else {
        echo "<select name=\"staff\"><option value=''>=请选择业务员=</option>";
        while ($row1 = $s->GetArray()) {
            if ($id == '' || $row1['id'] != $id) {
                echo "<option value='" . $row1['s_name'] . "'>" . $row1['s_name'] . "</option>";
            } else {
                echo "<option value='" . $row1['s_name'] . "' selected>" . $row1['s_name'] . "</option>";
            }
        }
        echo "</select>";
    }
    $s->close();
}