📄 user_add.asp
字号:
<td><input type="checkbox" name="quanxian17" value="1" checked="checked"> 产品销售</td>
<td><input type="checkbox" name="quanxian18" value="1" checked="checked"> 销售记录查询</td>
<td><input type="checkbox" name="quanxian19" value="1" checked="checked"> 销售状态审核</td>
<td><input type="checkbox" name="quanxian20" value="1"> 销售记录删除</td>
</tr>
<tr>
<td><input type="checkbox" name="quanxian21" value="1" checked="checked"> 销售退货</td>
<td><input type="checkbox" name="quanxian22" value="1" checked="checked"> 退货记录查询</td>
<td><input type="checkbox" name="quanxian23" value="1" checked="checked"> 退货状态审核</td>
<td><input type="checkbox" name="quanxian24" value="1"> 退货记录删除</td>
</tr>
<tr>
<td><input type="checkbox" name="quanxian25" value="1" checked="checked"> 产品报废</td>
<td><input type="checkbox" name="quanxian26" value="1" checked="checked"> 报废记录查询</td>
<td><input type="checkbox" name="quanxian27" value="1" checked="checked"> 报废状态审核</td>
<td><input type="checkbox" name="quanxian28" value="1"> 报废记录删除</td>
</tr>
<tr><td colspan="4" class="category">统计报表</td></tr>
<tr>
<td><input type="checkbox" name="quanxian29" value="1" checked="checked"> 进货统计</td>
<td><input type="checkbox" name="quanxian30" value="1" checked="checked"> 销售统计</td>
<td><input type="checkbox" name="quanxian31" value="1" checked="checked"> 公司退货统计</td>
<td><input type="checkbox" name="quanxian32" value="1" checked="checked"> 销售退货统计</td>
</tr>
<tr>
<td><input type="checkbox" name="quanxian33" value="1" checked="checked"> 报废统计</td>
<td><input type="checkbox" name="quanxian34" value="1" checked="checked"> 员工工资统计</td>
<td> </td>
<td> </td>
</tr>
<tr><td colspan="4" class="category">会员管理</td></tr>
<tr>
<td><input type="checkbox" name="quanxian35" value="1" checked="checked"> 添加会员</td>
<td><input type="checkbox" name="quanxian36" value="1" checked="checked"> 会员查询</td>
<td><input type="checkbox" name="quanxian37" value="1"> 修改会员</td>
<td><input type="checkbox" name="quanxian38" value="1"> 删除会员</td>
</tr>
<tr>
<td><input type="checkbox" name="quanxian78" value="1"> 添加会员组</td>
<td><input type="checkbox" name="quanxian79" value="1"> 会员组查询</td>
<td><input type="checkbox" name="quanxian80" value="1"> 修改会员组</td>
<td><input type="checkbox" name="quanxian81" value="1"> 删除会员组</td>
</tr>
<tr><td colspan="4" class="category">系统设置</td></tr>
<tr>
<td><input type="checkbox" name="quanxian39" value="1" checked="checked"> 添加员工</td>
<td><input type="checkbox" name="quanxian40" value="1" checked="checked"> 员工查询</td>
<td><input type="checkbox" name="quanxian41" value="1"> 修改员工</td>
<td><input type="checkbox" name="quanxian42" value="1"> 删除员工</td>
</tr>
<tr>
<td><input type="checkbox" name="quanxian74" value="1"> 添加员工部门</td>
<td><input type="checkbox" name="quanxian75" value="1"> 员工部门查询</td>
<td><input type="checkbox" name="quanxian76" value="1"> 修改员工部门</td>
<td><input type="checkbox" name="quanxian77" value="1"> 删除员工部门</td>
</tr>
<tr>
<td><input type="checkbox" name="quanxian43" value="1" checked="checked"> 添加仓库</td>
<td><input type="checkbox" name="quanxian44" value="1" checked="checked"> 仓库查询</td>
<td><input type="checkbox" name="quanxian45" value="1"> 修改仓库</td>
<td><input type="checkbox" name="quanxian46" value="1"> 删除仓库</td>
</tr>
<tr>
<td><input type="checkbox" name="quanxian47" value="1" checked="checked"> 添加产品大类</td>
<td><input type="checkbox" name="quanxian48" value="1" checked="checked"> 产品大类查询</td>
<td><input type="checkbox" name="quanxian49" value="1"> 修改产品大类</td>
<td><input type="checkbox" name="quanxian50" value="1"> 删除产品大类</td>
</tr>
<tr>
<td><input type="checkbox" name="quanxian51" value="1" checked="checked"> 添加产品小类</td>
<td><input type="checkbox" name="quanxian52" value="1" checked="checked"> 产品小类查询</td>
<td><input type="checkbox" name="quanxian53" value="1"> 修改产品小类</td>
<td><input type="checkbox" name="quanxian54" value="1"> 删除产品小类</td>
</tr>
<tr>
<td><input type="checkbox" name="quanxian55" value="1" checked="checked"> 添加计量单位</td>
<td><input type="checkbox" name="quanxian56" value="1" checked="checked"> 计量单位查询</td>
<td><input type="checkbox" name="quanxian57" value="1"> 修改计量单位</td>
<td><input type="checkbox" name="quanxian58" value="1"> 删除计量单位</td>
</tr>
<tr>
<td><input type="checkbox" name="quanxian59" value="1"> 基本信息设置</td>
<td><input type="checkbox" name="quanxian60" value="1"> 数据备份</td>
<td><input type="checkbox" name="quanxian61" value="1"> 数据还原</td>
<td><input type="checkbox" name="quanxian86" value="1"> 登陆日志</td>
</tr>
<tr><td colspan="4" class="category">帐务管理</td></tr>
<tr>
<td><input type="checkbox" name="quanxian82" value="1"> 添加银行</td>
<td><input type="checkbox" name="quanxian83" value="1"> 银行查询</td>
<td><input type="checkbox" name="quanxian84" value="1"> 修改银行</td>
<td><input type="checkbox" name="quanxian85" value="1"> 删除银行</td>
</tr>
<tr>
<td><input type="checkbox" name="quanxian62" value="1" checked="checked"> 添加帐务大类</td>
<td><input type="checkbox" name="quanxian63" value="1" checked="checked"> 帐务大类查询</td>
<td><input type="checkbox" name="quanxian64" value="1"> 修改帐务大类</td>
<td><input type="checkbox" name="quanxian65" value="1"> 删除帐务大类</td>
</tr>
<tr>
<td><input type="checkbox" name="quanxian66" value="1" checked="checked"> 添加帐务小类</td>
<td><input type="checkbox" name="quanxian67" value="1" checked="checked"> 帐务小类查询</td>
<td><input type="checkbox" name="quanxian68" value="1"> 修改帐务小类</td>
<td><input type="checkbox" name="quanxian69" value="1"> 删除帐务小类</td>
</tr>
<tr>
<td><input type="checkbox" name="quanxian70" value="1" checked="checked"> 添加帐务</td>
<td><input type="checkbox" name="quanxian71" value="1" checked="checked"> 帐务查询</td>
<td><input type="checkbox" name="quanxian72" value="1"> 修改帐务</td>
<td><input type="checkbox" name="quanxian73" value="1"> 删除帐务</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="30"> </td>
<td class="category"><input type="submit" value=" 确认添加 " onClick="return check()" class="button">
<input type="hidden" name="hid1" value="ok">
<input type="reset" value=" 重新填写 " class="button"> </td>
</tr>
</table>
</td>
<td></td>
</tr>
<tr>
<td><img src="../images/r_4.gif" alt="" /></td>
<td></td>
<td><img src="../images/r_3.gif" alt="" /></td>
</tr>
</table>
</form>
<%
else
nowbianhao=request("bianhao")
nowqq=request("qq")
nowemail=request("email")
nowid_zu=request("id_zu")
nowusername=request("username")
nowpwd=request("pwd")
nowgongzi=request("gongzi")
nowxinbie=request("xinbie")
nowtel=request("tel")
nowaddress=request("address")
nowsfz=request("sfz")
nowquanxian=""
if request("quanxian1")="1" then
nowquanxian=nowquanxian&"1"
else
nowquanxian=nowquanxian&"0"
end if
for x=2 to 90
if request("quanxian"&x)="1" then
nowquanxian=nowquanxian&",1"
else
nowquanxian=nowquanxian&",0"
end if
next
sql="select * from login where bianhao='"&nowbianhao&"'"
set rs=conn.execute(sql)
if rs.eof=false then
%>
<script language="javascript">
alert("您输入的编号已经存在,请重新输入！")
window.history.go(-1)
</script>
<%
response.end
end if
sql="select * from login where username='"&nowusername&"'"
set rs=conn.execute(sql)
if rs.eof=false then
%>
<script language="javascript">
alert("您输入的姓名已经存在，如果有同名员工，请加以区分！")
window.history.go(-1)
</script>
<%
response.end
end if
sql="insert into login(bianhao,username,pwd,gongzi,quanxian,xinbie,tel,address,sfz,qq,email,id_zu) values('"&nowbianhao&"','"&nowusername&"','"&md5(nowpwd)&"',"&nowgongzi&",'"&nowquanxian&"','"&nowxinbie&"','"&nowtel&"','"&nowaddress&"','"&nowsfz&"','"&nowqq&"','"&nowemail&"',"&nowid_zu&")"
conn.execute(sql)
%>
<script language="javascript">
alert("员工添加成功！")
window.location.href="user.asp"
</script>
<%
end if
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -