?? 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"> 銷售狀態(tài)審核</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"> 退貨狀態(tài)審核</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"> 報廢狀態(tài)審核</td>
<td><input type="checkbox" name="quanxian28" value="1"> 報廢記錄刪除</td>
</tr>
<tr><td colspan="4" class="category">統(tǒng)計報表</td></tr>
<tr>
<td><input type="checkbox" name="quanxian29" value="1" checked="checked"> 進貨統(tǒng)計</td>
<td><input type="checkbox" name="quanxian30" value="1" checked="checked"> 銷售統(tǒng)計</td>
<td><input type="checkbox" name="quanxian31" value="1" checked="checked"> 公司退貨統(tǒng)計</td>
<td><input type="checkbox" name="quanxian32" value="1" checked="checked"> 銷售退貨統(tǒng)計</td>
</tr>
<tr>
<td><input type="checkbox" name="quanxian33" value="1" checked="checked"> 報廢統(tǒng)計</td>
<td><input type="checkbox" name="quanxian34" value="1" checked="checked"> 員工工資統(tǒng)計</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">系統(tǒng)設置</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"> 數(shù)據備份</td>
<td><input type="checkbox" name="quanxian61" value="1"> 數(shù)據還原</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("您輸入的姓名已經存在，如果有同名員工，請加以區(qū)分！")
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 + -