<tr>
<td id="row_style"> 是否默认仓库:</td>
<td>
<select name="l_default"><option value="1">是</option><option value="0" selected>否</option></select> 只能保留一个默认仓库</td>
</tr>
<tr>
<td id="row_style"> </td>
<td> <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 #@__lab");
$csql->Execute();
$rowcount = $csql->GetTotalRow();
if ($rowcount == 0) {
echo "<tr><td> 还没添加仓库,请先<a href=system_lab.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></tr>";
while ($row = $csql->GetArray()) {
if ($row['l_default'] == 1) {
$default_yes = "<img src=images/yes.png>";
} else {
$default_yes = " ";
}
echo "<tr><td>ID号:" . $row['id'] . "</td><td> " . $row['l_name'] . "</td><td> " . $row['l_city'] . "</td><td> " . $row['l_mang'] . "</td><td> " . $default_yes . "</td><td><a href=system_lab_edit.php?id=" . $row['id'] . ">修改</a> | <a href=system_lab_del.php?id=" . $row['id'] . ">删除</a></td></tr>";
}
}
}
?>
<table width="100%" border="0" cellpadding="0" cellspacing="2">
<tr>
<td><strong> 客户退货详细产品</strong></td>
</tr>
<form method="post" name="sel">
<tr>
<td bgcolor="#FFFFFF">
<?php
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">";
$csql = new Dedesql(false);
if ($pid == '') {
//初始状态
if ($action == 'normal') {
$csql->SetQuery("select * from #@__saleback where rdh='{$did}'");
} else {
$csql->SetQuery("select * from #@__saleback where id<0");
}
} else {
if ($action == '' && $did != '') {
//写入产品记录
$wsql = new Dedesql(false);
$writesql = "select * from #@__basic where cp_number='{$pid}'";
$wsql->Setquery($writesql);
$wsql->Execute();
$wrs = $wsql->GetOne();
$wsql->ExecuteNoneQuery("insert into #@__saleback(productid,number,rdh,dtime,r_text) values('" . $pid . "','" . $num . "','" . $did . "','" . GetDateTimeMk(time()) . "','" . $r_text . "')");
$wsql->close();
}
$csql->SetQuery("select * from #@__saleback where rdh='{$did}'");
}
</SCRIPT>
<META content="MSHTML 6.00.2900.5583" name=GENERATOR></HEAD>
<BODY leftMargin=0 topMargin=0 onload=document.form1.username.focus() MARGINHEIGHT="0" MARGINWIDTH="0">
<?php
require_once dirname(__FILE__) . "/include/config_rglobals.php";
require_once dirname(__FILE__) . "/include/config_base.php";
if ($action == 'login') {
if (GetCkVdValue() == $code) {
//登陆处理
$username = eregi_replace("['\"\$ \r\n\t;<>\\*%\\?]", '', $username);
$loginip = getip();
$logindate = getdatetimemk(time());
$lsql = new Dedesql(false);
$sql = str_replace('#@__', $cfg_dbprefix, "select * from #@__boss where boss='{$username}' and password='******'");
$lsql->SetQuery($sql);
$lsql->Execute();
$rowcount = $lsql->GetTotalRow();
if ($rowcount == 0) {
$message = '用户或密码错误被系统拒绝登陆！';
WriteNote($message, $logindate, $loginip, $username);
showmsg($message, -1);
} else {
//可以正常登陆，写登陆数据
$message = "正常登入进销存系统！";
setcookie('VioomaUserID', $username . $cfg_cookie_encode, time() + $cfg_keeptime * 3600);
WriteNote($message, $logindate, $loginip, $username);
$loginsql = str_replace('#@__', $cfg_dbprefix, "update #@__boss set logindate='{$logindate}',loginip='{$loginip}' where boss='{$username}'");
mysql_query($loginsql);
header("Location:index.php");
}
echo "<script language='javascript'>alert('零售价不能小于进价!');history.go(-1)</script>";
}
$bsql = new Dedesql(false);
$query = "update #@__basic set cp_number='" . $cp_number . "',cp_tm='" . $cp_tm . "',cp_name='" . $cp_name . "',cp_gg='" . $cp_gg . "',cp_categories='" . $cp_categories . "',cp_categories_down='" . $cp_categories_down . "',cp_dwname='" . $cp_dwname . "',cp_jj='" . $cp_jj . "',cp_sale='" . $cp_sale . "',cp_saleall='" . $cp_saleall . "',cp_sdate='" . $cp_sdate . "',cp_edate='" . $cp_edate . "',cp_gys='" . $cp_gys . "',cp_helpword='" . $cp_helpword . "',cp_bz='" . $cp_bz . "' where id='{$id}'";
$bsql->ExecuteNoneQuery($query);
showmsg('成功修改了产品基本信息', 'system_basic_cp.php?action=seek');
$loginip = getip();
$logindate = getdatetimemk(time());
$username = str_replace($cfg_cookie_encode, '', $_COOKIE['VioomaUserID']);
WriteNote('修改产品基本信息' . $cp_name . ' 成功', $logindate, $loginip, $username);
$bsql->close();
exit;
}
$seekrs = new Dedesql(falsh);
$squery = "select * from #@__basic where id='{$id}'";
$seekrs->SetQuery($squery);
$seekrs->Execute();
$rowcount = $seekrs->gettotalrow();
if ($rowcount == 0) {
Showmsg('非法的参数', '-1');
exit;
}
$row = $seekrs->GetOne();
$seekrs->close();
?>
<body onload="form1.cp_tm.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>
<td id="row_style"> 即时联系(QQ):</td>
<td>
<input type="text" name="g_qq" size="20"></td>
</tr>
<tr>
<td id="row_style"> </td>
<td> <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 #@__gys");
$csql->Execute();
$rowcount = $csql->GetTotalRow();
if ($rowcount == 0) {
echo "<tr><td> 系统里还没有任何供应商,请先<a href=system_gys.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>QQ</td><td>操作</td></tr>";
while ($row = $csql->GetArray()) {
echo "<tr><td>ID号:" . $row['id'] . "</td><td> " . $row['g_name'] . "</td><td> " . $row['g_people'] . "</td><td> " . $row['g_address'] . "</td><td> " . $row['g_phone'] . "</td><td> " . $row['g_qq'] . "</td><td><a href=system_gys_edit.php?id=" . $row['id'] . ">修改</a> | <a href=system_gys_del.php?id=" . $row['id'] . ">删除</a></td></tr>";
}
}
echo "</table>";
$csql->close();
}
?>
</td>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link href="style/main.css" rel="stylesheet" type="text/css" />
<title><?php
echo $cfg_softname;
?>
系统库存</title>
<script language = "JavaScript">
var onecount;
onecount = 0;
subcat = new Array();
<?php
$count = 0;
$rsql = new Dedesql(false);
$rsql->SetQuery("select * from #@__categories where reid!=0");
$rsql->Execute();
while ($rs = $rsql->GetArray()) {
?>
subcat[<?php
echo $count;
?>
] = new Array("<?php
echo $rs['categories'];
?>
","<?php
echo $rs['reid'];
?>
","<?php
echo $rs['id'];
?>
<td>
<?php
echo getDatetimeMk(time());
?>
</td>
</tr>
<tr>
<td id="row_style"> </td>
<td> <input type="submit" name="submit" value=" 添加会员 "></td>
</tr>
</table></form>
<?php
} else {
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">";
$csql = new Dedesql(false);
$csql->SetQuery("select * from #@__guest");
$csql->Execute();
$rowcount = $csql->GetTotalRow();
if ($rowcount == 0) {
echo "<tr><td> 没有任何会员,请先<a href=system_guest.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>QQ/MSN</td><td>生日</td><td>会员卡号</td><td>分组</td><td>操作员</td><td>入会时间</td><td>操作</td></tr>";
while ($row = $csql->GetArray()) {
echo "<tr><td>" . $row['id'] . "</td><td> " . $row['g_name'] . "</td><td>" . $row['g_sex'] . "</td><td> " . $row['g_address'] . "</td><td> " . $row['g_phone'] . "</td><td>" . $row['g_qq'] . "</td><td> " . $row['g_birthday'] . "</td><td> " . $row['g_card'] . "</td><td> " . getgroup($row['g_group'], 'group') . "</td><td>" . $row['g_people'] . "</td><td>" . $row['g_dtime'] . "</td><td><a href=guest_edit.php?id=" . $row['id'] . ">改</a> | <a href=guest_del.php?id=" . $row['id'] . ">删</a></td></tr>";
}
}
echo "</table>";
$csql->close();
}
?>
</td>
$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 #@__kcbackgys where rdh='" . $row['r_dh'] . "'");
$csql1->Execute();
$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_jj'] . "</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";
}
//检测分类的等级
$username = str_replace($cfg_cookie_encode, '', $_COOKIE["VioomaUserID"]);
$dsql = new Dedesql(false);
$query = "select * from #@__dw where id='{$id}'";
$dsql->Setquery($query);
$dsql->Execute();
$rowcount = $dsql->GetTotalRow();
if ($rowcount == 0) {
//非法ID
ShowMsg('执行了非法的操作', '-1');
} else {
$row = $dsql->GetArray();
if ($row['reid'] == 0) {
//删除顶级分类
$msql = new Dedesql(false);
$msql->SetQuery("select * from #@__dw where reid='" . $row['id'] . "'");
$msql->Execute();
if ($msql->GetTotalRow() >= 1) {
echo "<script language='javascript'>alert('你要删除的单位下有子单位,请先删除其子单位!');history.go(-1);</script>";
} else {
$msql->ExecuteNoneQuery("delete from #@__dw where id='{$id}'");
WriteNote('成功删除基本单位' . $row['dwname'], getdatetimemk(time()), getip(), $username);
ShowMsg('删除计量单位成功', 'system_dw.php');
}
$msql->close();
} else {
//删除子分类
$msql = new Dedesql(false);
$msql->ExecuteNoneQuery("delete from #@__dw where id='{$id}'");
WriteNote('成功删除子计量单位' . $row['dwname'], getdatetimemk(time()), getip(), $username);
ShowMsg('成功删除子计量单位', 'system_dw.php');
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();
}
$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();
$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";
}
</tr>
<tr>
<td id="row_style"> 此分组折扣:</td>
<td>
<input type="text" name="sub" size="2" value="10">折</td>
</tr>
<tr>
<td id="row_style"> </td>
<td> <input type="submit" name="submit" value=" 添加会员分组 "></td>
</tr>
</table></form>
<?php
} else {
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">";
$csql = new Dedesql(false);
$csql->SetQuery("select * from #@__group");
$csql->Execute();
$rowcount = $csql->GetTotalRow();
if ($rowcount == 0) {
echo "<tr><td> 系统里还没有任何会员分组,请先<a href=guest_group.php?action=new>添加分组</a>。</td></tr>";
} else {
echo "<tr class='row_color_head'><td>ID</td><td>分组名称</td><td>折扣</td><td>操作</td></tr>";
while ($row = $csql->GetArray()) {
echo "<tr><td>ID号:" . $row['id'] . "</td><td><img src=images/cate.gif align=absmiddle> " . $row['groupname'] . "</td><td>" . $row['sub'] . "折</td><td><a href=group_edit.php?id=" . $row['id'] . ">修改</a> | <a href=group_del.php?id=" . $row['id'] . ">删除</a></td></tr>";
}
}
echo "</table>";
$csql->close();
}
?>
</td>
<?php
getusertype('', 0);
?>
</td>
</tr>
<tr>
<td id="row_style"> </td>
<td> <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 #@__staff");
$csql->Execute();
$rowcount = $csql->GetTotalRow();
if ($rowcount == 0) {
echo "<tr><td> 公司里还没有任何职员,请先<a href=system_worker.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><td>操作</td></tr>";
while ($row = $csql->GetArray()) {
echo "<tr><td>ID号:" . $row['id'] . "</td><td> " . $row['s_name'] . "</td><td> " . $row['s_address'] . "</td><td> " . $row['s_phone'] . "</td><td> " . $row['s_part'] . "</td><td> " . $row['s_duty'] . "</td><td> " . getusertype($row['s_utype']) . "</td><td><a href=system_worker_edit.php?id=" . $row['id'] . ">修改</a> | <a href=system_worker_del.php?id=" . $row['id'] . ">删除</a></td></tr>";
}
}
echo "</table>";
$csql->close();
}
?>
</td>
</tr>
<tr>
<td id="row_style"> 是否默认银行:</td>
<td>
<select name="b_default"><option value="1">是</option><option value="0" selected>否</option></select> 只能保留一个默认银行</td>
</tr>
<tr>
<td id="row_style"> </td>
<td> <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> 还没添加银行账户,请先<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 = " ";
$delstring = " | <a href=bank_del.php?id=" . $row['id'] . ">删除</a>";
}
echo "<tr><td>ID号:" . $row['id'] . "</td><td> " . $row['bank_name'] . "</td><td> " . $row['bank_account'] . "</td><td> ￥" . $row['bank_money'] . "</td><td> " . $default_yes . "</td><td>" . $row['bank_text'] . "</td><td><a href=bank_edit.php?id=" . $row['id'] . ">修改</a>" . $delstring . "</td></tr>";
}
//检测分类的等级
$username = str_replace($cfg_cookie_encode, '', $_COOKIE["VioomaUserID"]);
$dsql = new Dedesql(false);
$query = "select * from #@__categories where id='{$id}'";
$dsql->Setquery($query);
$dsql->Execute();
$rowcount = $dsql->GetTotalRow();
if ($rowcount == 0) {
//非法ID
ShowMsg('执行了非法的操作', '-1');
} else {
$row = $dsql->GetArray();
if ($row['reid'] == 0) {
//删除顶级分类
$msql = new Dedesql(false);
$msql->SetQuery("select * from #@__categories where reid='" . $row['id'] . "'");
$msql->Execute();
if ($msql->GetTotalRow() >= 1) {
echo "<script language='javascript'>alert('你要删除的顶级分类下有子分类,请先删除其子分类!');history.go(-1);</script>";
} else {
$msql->ExecuteNoneQuery("delete from #@__categories where id='{$id}'");
WriteNote('成功删除顶级分类' . $row['categories'], getdatetimemk(time()), getip(), $username);
ShowMsg('删除分类成功', 'system_class.php');
}
$msql->close();
} else {
//删除子分类
$msql = new Dedesql(false);
$msql->ExecuteNoneQuery("delete from #@__categories where id='{$id}'");
WriteNote('成功删除子分类' . $row['categories'], getdatetimemk(time()), getip(), $username);
ShowMsg('成功删除子分类', 'system_class.php');
?>
职工管理</title>
<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"> </td>
<td> </td>
<td id="table_style" class="r_t"> </td>
</tr>
<tr>
}
?>
<table width="100%" border="0" cellpadding="0" cellspacing="2">
<tr>
<td><strong> 退回供应商详细产品</strong></td>
</tr>
<form method="post" name="sel">
<tr>
<td bgcolor="#FFFFFF">
<?php
echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" id=\"table_border\">";
$csql = new Dedesql(false);
if ($pid == '') {
//初始状态
if ($action == 'normal') {
$csql->SetQuery("select * from #@__kcbackgys where rdh='{$did}'");
} else {
$csql->SetQuery("select * from #@__kcbackgys where id<0");
}
} else {
if ($action == '' && $did != '') {
//写入产品记录
$wsql = new Dedesql(false);
$writesql = "select * from #@__basic where cp_number='{$pid}'";
$wsql->Setquery($writesql);
$wsql->Execute();
$wrs = $wsql->GetOne();
$wsql->ExecuteNoneQuery("insert into #@__kcbackgys(productid,number,labid,rdh,dtime) values('" . $pid . "','" . $num . "','','" . $did . "','" . GetDateTimeMk(time()) . "')");
$wsql->close();
}
$csql->SetQuery("select * from #@__kcbackgys where rdh='{$did}'");
