ShowMsg('请输入账户的名称', '-1'); exit; } if ($b_money == '' || !is_numeric($b_money) || $b_money < 0) { ShowMsg('请确保输入了正确的初始金额', '-1'); exit; } $addsql = "insert into #@__bank(bank_name,bank_money,bank_account,bank_default,bank_text) values('{$b_name}','{$b_money}','{$b_account}','{$b_default}','{$b_text}')"; $message = "添加银行账户" . $b_name . "成功"; $loginip = getip(); $logindate = getdatetimemk(time()); $username = str_replace($cfg_cookie_encode, '', $_COOKIE['VioomaUserID']); $asql = new Dedesql(false); $asql->ExecuteNoneQuery($addsql); $asql->close(); WriteNote($message, $logindate, $loginip, $username); showmsg('成功添加了银行账户', 'bank.php'); exit; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <link href="style/main.css" rel="stylesheet" type="text/css" /> <title><?php echo $cfs_softname; ?> 账户管理</title> </head> <body>
echo "<script language='javascript'>alert('产品进价与建议零售价为必填项!');history.go(-1)</script>"; } if (!(is_numeric($cp_jj) && is_numeric($cp_sale))) { echo "<script language='javascript'>alert('价格必须为数字!');history.go(-1)</script>"; } if ($cp_jj > $cp_sale) { 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(); ?>
<head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <title>会员删除</title> </head> <body> <?php require_once dirname(__FILE__) . "/include/config_base.php"; require_once dirname(__FILE__) . "/include/config_rglobals.php"; if ($id == '') { ShowMsg('非法的执行操作', 'guest_group.php'); } //检测分类的等级 $username = str_replace($cfg_cookie_encode, '', $_COOKIE["VioomaUserID"]); $dsql = new Dedesql(false); $query = "select * from #@__group where id='{$id}'"; $dsql->Setquery($query); $dsql->Execute(); $rowcount = $dsql->GetTotalRow(); if ($rowcount == 0) { //非法ID ShowMsg('执行了非法的操作', '-1'); } else { $dsql->ExecuteNoneQuery("delete from #@__group where id='{$id}'"); WriteNote('成功删除会员分组资料(ID为' . $id . ')', getdatetimemk(time()), getip(), $username); ShowMsg('成功删除会员分组资料', 'guest_group.php'); } $dsql->close(); ?> </body> </html>
//非法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'); $msql->close(); } $dsql->close(); } ?> </body> </html>
exit; } $bsql = new Dedesql(false); $query = "select * from #@__mainkc where p_id='{$pid}'"; $bsql->SetQuery($query); $bsql->Execute(); $rowcount = $bsql->GetTotalRow(); if ($rowcount == 0) { ShowMsg('非法参数或没有此产品信息!', '-1'); exit; } else { $bsql->executenonequery("update #@__mainkc set number='{$kc_number}',l_id='{$labid}' where p_id='" . $pid . "'"); $loginip = getip(); $logindate = getdatetimemk(time()); $username = str_replace($cfg_cookie_encode, '', $_COOKIE['VioomaUserID']); WriteNote('修改产品' . get_name($pid, 'name') . '资料成功', $logindate, $loginip, $username); ShowMsg('产品信息已成功修改', 'system_kc.php'); $bsql->close(); exit; } } else { if ($pid == '' || $lid == '') { echo "<script language='javascript'>alert('非法参数');history.go(-1);</script>"; exit; } ?> <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>
//非法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'); $msql->close(); } $dsql->close(); } ?> </body> </html>
$money = 0; while ($row = $bsql->getArray()) { $money += $row['number'] * getsale($row['productid']); $csql = new dedesql(false); $csql->setquery("select * from #@__mainkc where p_id='" . $row['productid'] . "'"); $csql->execute(); $totalrec = $csql->gettotalrow(); if ($totalrec != 0) { $csql->executenonequery("update #@__mainkc set number=number-" . $row['number'] . " where p_id='" . $row['productid'] . "'"); } } $csql->close(); $loginip = getip(); $logindate = getdatetimemk(time()); $username = str_replace($cfg_cookie_encode, '', $_COOKIE['VioomaUserID']); WriteNote('退货单' . $r_dh . '成功保存', $logindate, $loginip, $username); $newsql = new dedesql(false); $newsql->executenonequery("insert into #@__reportsale(r_dh,r_people,r_date,r_status,r_adid) values('" . $r_dh . "','" . $r_people . "','" . $r_date . "','1','" . $staff . "')"); //写入财务记录 $newsql->executenonequery("insert into #@__accounts(atype,amoney,abank,dtime,apeople,atext) values('收入','" . $money . "','" . BANKID . "','" . $r_date . "','" . $r_people . "','销售产品收入现金,对应销售单号为:" . $r_dh . "')"); //更新银行金额 $newsql->executenonequery("update #@__bank set bank_money=bank_money+" . $money . " where id='" . BANKID . "'"); $newsql->close(); ShowMsg('产品已销售,系统自动跳转到打印界面.', 'sale.php'); $bsql->close(); exit; } } else { if ($action == 'seek') { //列表 ?>
<head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312" /> <title>职工删除</title> </head> <body> <?php require_once dirname(__FILE__) . "/include/config_base.php"; require_once dirname(__FILE__) . "/include/config_rglobals.php"; if ($id == '') { ShowMsg('非法的执行操作', 'system_worker.php'); } //检测分类的等级 $username = str_replace($cfg_cookie_encode, '', $_COOKIE["VioomaUserID"]); $dsql = new Dedesql(false); $query = "select * from #@__basic where id='{$id}'"; $dsql->Setquery($query); $dsql->Execute(); $rowcount = $dsql->GetTotalRow(); if ($rowcount == 0) { //非法ID ShowMsg('执行了非法的操作', '-1'); } else { $dsql->ExecuteNoneQuery("delete from #@__basic where id='{$id}'"); WriteNote('成功删除产品基本信息(ID为' . $id . ')', getdatetimemk(time()), getip(), $username); ShowMsg('成功删除产品基本信息', 'system_basic_cp.php?action=seek'); } $dsql->close(); ?> </body> </html>