afgl_cy_dw_dj.asp

U盘身份识别软件

    <td align="left"><input name="CY_DW_DJ_phone3" type="text" id="CY_DW_DJ_phone3" size="15"></td>
  </tr>
  <tr align="center">
    <td>企业盖章</td>
    <td colspan="5" align="left"><input name="CY_DW_DJ_gaizh" type="text" id="CY_DW_DJ_gaizh" size="25"></td>
    </tr>
  <tr align="center">
    <td colspan="6"><input type="submit" name="Submit" value="提  交">
      &nbsp;&nbsp;
      <input type="reset" name="Submit" value="返  回" onClick="history.back();"></td>
    </tr>
</form>
</table>
<%
end sub
%>
<%
sub editIF()
sql="select * from AFGL_CY_DW_DJ where id="&trim(request.QueryString("id"))
rs.open sql,conn,1,1
if not rs.eof then
%>
<table width="760" border="1" align="center" cellpadding="5" cellspacing="0" class="FPtalbe">
<form name="form1" method="post" action="?action=saveMod&id=<%=rs("id")%>" onSubmit="return checkForm();">
  <tr align="center">
    <td height="30" colspan="6" class="blackTitle">陕西省安全技术防范从业单位登记备案表</td>
    </tr>
  <tr>
    <td width="100" align="center">企业名称</td>
    <td colspan="3"><input name="CY_DW_DJ_name" type="text" id="CY_DW_DJ_name" value="<%=rs("CY_DW_DJ_name")%>" size="25">
      <span style="color: #FF0000">*</span></td>
    <td>电话</td>
    <td><input name="CY_DW_DJ_phone" type="text" id="CY_DW_DJ_phone" value="<%=rs("CY_DW_DJ_phone")%>" size="25"></td>
  </tr>
  <tr>
    <td align="center">企业地址</td>
    <td colspan="3"><input name="CY_DW_DJ_add" type="text" id="CY_DW_DJ_add" value="<%=rs("CY_DW_DJ_add")%>" size="25"></td>
    <td>邮政编码</td>
    <td><input name="CY_DW_DJ_code" type="text" id="CY_DW_DJ_code" value="<%=rs("CY_DW_DJ_code")%>" size="25"></td>
  </tr>
  <tr>
    <td align="center">企业成立时间</td>
    <td><input name="CY_DW_DJ_addDate" type="text" id="CY_DW_DJ_addDate" value="<%=rs("CY_DW_DJ_addDate")%>" size="15"> </td>
    <td>注册资金</td>
    <td><input name="CY_DW_DJ_money" type="text" id="CY_DW_DJ_money" value="<%=rs("CY_DW_DJ_money")%>" size="15"></td>
    <td width="100" align="center">电子邮箱</td>
    <td><input name="CY_DW_DJ_email" type="text" id="CY_DW_DJ_email" value="<%=rs("CY_DW_DJ_email")%>" size="15"></td>
  </tr>
  <tr>
    <td align="center">企业职工人数</td>
    <td><input name="CY_DW_DJ_count_zg" type="text" id="CY_DW_DJ_count_zg" value="<%=rs("CY_DW_DJ_count_zg")%>" size="15"></td>
    <td>技术人员人数</td>
    <td><input name="CY_DW_DJ_count_js" type="text" id="CY_DW_DJ_count_js" value="<%=rs("CY_DW_DJ_count_js")%>" size="15"></td>
    <td align="center">经济性质</td>
    <td><input name="CY_DW_DJ_jjxz" type="text" id="CY_DW_DJ_jjxz" value="<%=rs("CY_DW_DJ_jjxz")%>" size="15"></td>
    </tr>
  <tr>
    <td align="center">营业执照发放机关</td>
    <td colspan="3"><input name="CY_DW_DJ_fzjg" type="text" id="CY_DW_DJ_fzjg" value="<%=rs("CY_DW_DJ_fzjg")%>" size="25"></td>
    <td align="center">营业执照编号</td>
    <td><input name="CY_DW_DJ_zzbh" type="text" id="CY_DW_DJ_zzbh" value="<%=rs("CY_DW_DJ_zzbh")%>" size="25"></td>
  </tr>
  <tr>
    <td align="center">机构代码证书编号</td>
    <td colspan="5"><input name="CY_DW_DJ_dmbh" type="text" id="CY_DW_DJ_dmbh" value="<%=rs("CY_DW_DJ_dmbh")%>" size="25">      </td>
    </tr>
  <tr>
    <td align="center">质量体系认证证书名称及编号</td>
    <td colspan="5"><input name="CY_DW_DJ_zlbh" type="text" id="CY_DW_DJ_zlbh" value="<%=rs("CY_DW_DJ_zlbh")%>" size="25"></td>
    </tr>
  <tr>
    <td align="center">技防工程部门名称</td>
    <td><input name="CY_DW_DJ_gcmc" type="text" id="CY_DW_DJ_gcmc" value="<%=rs("CY_DW_DJ_gcmc")%>" size="15"></td>
    <td>办公面积</td>
    <td><input name="CY_DW_DJ_bgmj" type="text" id="CY_DW_DJ_bgmj" value="<%=rs("CY_DW_DJ_bgmj")%>" size="15"></td>
    <td align="center">人数</td>
    <td><input name="CY_DW_DJ_bgCount" type="text" id="CY_DW_DJ_bgCount" value="<%=rs("CY_DW_DJ_bgCount")%>" size="15"></td>
  </tr>
  <tr>
    <td align="center">联系地址</td>
    <td><input name="CY_DW_DJ_add1" type="text" id="CY_DW_DJ_add1" value="<%=rs("CY_DW_DJ_add1")%>" size="15"></td>
    <td>负责人</td>
    <td><input name="CY_DW_DJ_master1" type="text" id="CY_DW_DJ_master1" value="<%=rs("CY_DW_DJ_master1")%>" size="15"></td>
    <td align="center">电话</td>
    <td><input name="CY_DW_DJ_phone1" type="text" id="CY_DW_DJ_phone1" value="<%=rs("CY_DW_DJ_phone1")%>" size="15"></td>
  </tr>
  <tr>
    <td align="center">工程部门主要合资、合作单位基本情况</td>
    <td colspan="5"><input name="CY_DW_DJ_otherUnit" type="text" id="CY_DW_DJ_otherUnit" value="<%=rs("CY_DW_DJ_otherUnit")%>" size="25"></td>
    </tr>
  <tr align="center">
    <td>申请项目</td>
    <td colspan="5" align="left"><input name="CY_DW_DJ_appPro" type="text" id="CY_DW_DJ_appPro" value="<%=rs("CY_DW_DJ_appPro")%>" size="25"></td>
  </tr>
  <tr align="center">
    <td>法定代表人签字</td>
    <td align="left"><input name="CY_DW_DJ_master2" type="text" id="CY_DW_DJ_master2" value="<%=rs("CY_DW_DJ_master2")%>" size="15"></td>
    <td align="left">电话</td>
    <td align="left"><input name="CY_DW_DJ_phone2" type="text" id="CY_DW_DJ_phone2" value="<%=rs("CY_DW_DJ_phone2")%>" size="15"></td>
    <td align="left">手机</td>
    <td align="left"><input name="CY_DW_DJ_phone3" type="text" id="CY_DW_DJ_phone3" value="<%=rs("CY_DW_DJ_phone3")%>" size="15"></td>
  </tr>
  <tr align="center">
    <td>企业盖章</td>
    <td colspan="5" align="left"><input name="CY_DW_DJ_gaizh" type="text" id="CY_DW_DJ_gaizh" value="<%=rs("CY_DW_DJ_gaizh")%>" size="25"></td>
    </tr>
  <tr align="center">
    <td colspan="6"><input type="submit" name="Submit" value="修  改">
    &nbsp;&nbsp;
    <input type="reset" name="Submit" value="返  回" onClick="history.back();"></td>
  </tr>
</form>
</table>
<%
rs.close
else
rs.close
  response.Write("<script language=javascript>alert('没有相关记录！');history.back();</script>")
end if
end sub
%>
<%
sub saveMod()
  CY_DW_DJ_name = trim(request.Form("CY_DW_DJ_name"))
  if CY_DW_DJ_name ="" then
    response.Write("<script language=javascript>alert('企业名称不能为空！');history.back();</script>")
  end if
  CY_DW_DJ_name = trim(request.Form("CY_DW_DJ_name"))
  CY_DW_DJ_phone = trim(request.Form("CY_DW_DJ_phone"))
  CY_DW_DJ_add = trim(request.Form("CY_DW_DJ_add"))
  CY_DW_DJ_code = trim(request.Form("CY_DW_DJ_code"))
  CY_DW_DJ_addDate = trim(request.Form("CY_DW_DJ_addDate"))
  CY_DW_DJ_money = trim(request.Form("CY_DW_DJ_money"))
  CY_DW_DJ_email = trim(request.Form("CY_DW_DJ_email"))
  CY_DW_DJ_count_zg = trim(request.Form("CY_DW_DJ_count_zg"))
  CY_DW_DJ_count_js = trim(request.Form("CY_DW_DJ_count_js"))
  CY_DW_DJ_jjxz = trim(request.Form("CY_DW_DJ_jjxz"))
  CY_DW_DJ_fzjg = trim(request.Form("CY_DW_DJ_fzjg"))
  CY_DW_DJ_zzbh = trim(request.Form("CY_DW_DJ_zzbh"))
  CY_DW_DJ_dmbh = trim(request.Form("CY_DW_DJ_dmbh"))
  CY_DW_DJ_zlbh = trim(request.Form("CY_DW_DJ_zlbh"))
  CY_DW_DJ_gcmc = trim(request.Form("CY_DW_DJ_gcmc"))
  CY_DW_DJ_bgmj = trim(request.Form("CY_DW_DJ_bgmj"))
  CY_DW_DJ_bgCount = trim(request.Form("CY_DW_DJ_bgCount"))
  CY_DW_DJ_add1 = trim(request.Form("CY_DW_DJ_add1"))
  CY_DW_DJ_master1 = trim(request.Form("CY_DW_DJ_master1"))
  CY_DW_DJ_phone1 = trim(request.Form("CY_DW_DJ_phone1"))
  CY_DW_DJ_otherUnit = trim(request.Form("CY_DW_DJ_otherUnit"))
  CY_DW_DJ_appPro = trim(request.Form("CY_DW_DJ_appPro"))
  CY_DW_DJ_master2 = trim(request.Form("CY_DW_DJ_master2"))
  CY_DW_DJ_phone2 = trim(request.Form("CY_DW_DJ_phone2"))
  CY_DW_DJ_phone3 = trim(request.Form("CY_DW_DJ_phone3"))
  CY_DW_DJ_gaizh = trim(request.Form("CY_DW_DJ_gaizh"))
  CY_DW_DJ_date = date()

  sql = "select * from AFGL_CY_DW_DJ where CY_DW_DJ_name = '"&CY_DW_DJ_name&"' and id<>"&trim(request.QueryString("id"))
  rs.open sql,conn,1,1
  if not rs.eof then
    rs.close
	response.Write("<script language=javascript>alert('名称重复！');location.href='?';</script>")
  else

    rs.close
    sql = "select * from AFGL_CY_DW_DJ where id="&trim(request.QueryString("id"))
    rs.open sql,conn,1,3
    if CY_DW_DJ_name <> "" then
      rs("CY_DW_DJ_name") = CY_DW_DJ_name
	end if
    if CY_DW_DJ_phone <> "" then
      rs("CY_DW_DJ_phone") = CY_DW_DJ_phone
	end if
    if CY_DW_DJ_add <> "" then
      rs("CY_DW_DJ_add") = CY_DW_DJ_add
	end if
    if CY_DW_DJ_code <> "" then
      rs("CY_DW_DJ_code") = CY_DW_DJ_code
	end if
    if CY_DW_DJ_addDate <> "" then
      rs("CY_DW_DJ_addDate") = CY_DW_DJ_addDate
	end if
    if CY_DW_DJ_money <> "" then
      rs("CY_DW_DJ_money") = CY_DW_DJ_money
	end if
    if CY_DW_DJ_email <> "" then
      rs("CY_DW_DJ_email") = CY_DW_DJ_email
	end if
    if CY_DW_DJ_count_zg <> "" then
      rs("CY_DW_DJ_count_zg") = CY_DW_DJ_count_zg
	end if
    if CY_DW_DJ_count_js <> "" then
      rs("CY_DW_DJ_count_js") = CY_DW_DJ_count_js
	end if
    if CY_DW_DJ_jjxz <> "" then
      rs("CY_DW_DJ_jjxz") = CY_DW_DJ_jjxz
	end if
    if CY_DW_DJ_fzjg <> "" then
      rs("CY_DW_DJ_fzjg") = CY_DW_DJ_fzjg
	end if
    if CY_DW_DJ_zzbh <> "" then
      rs("CY_DW_DJ_zzbh") = CY_DW_DJ_zzbh
	end if
    if CY_DW_DJ_dmbh <> "" then
      rs("CY_DW_DJ_dmbh") = CY_DW_DJ_dmbh
	end if
    if CY_DW_DJ_zlbh <> "" then
      rs("CY_DW_DJ_zlbh") = CY_DW_DJ_zlbh
	end if
    if CY_DW_DJ_gcmc <> "" then
      rs("CY_DW_DJ_gcmc") = CY_DW_DJ_gcmc
	end if
    if CY_DW_DJ_bgmj <> "" then
      rs("CY_DW_DJ_bgmj") = CY_DW_DJ_bgmj
	end if
    if CY_DW_DJ_bgCount <> "" then
      rs("CY_DW_DJ_bgCount") = CY_DW_DJ_bgCount
	end if
    if CY_DW_DJ_add1 <> "" then
      rs("CY_DW_DJ_add1") = CY_DW_DJ_add1
	end if
    if CY_DW_DJ_master1 <> "" then
      rs("CY_DW_DJ_master1") = CY_DW_DJ_master1
	end if
    if CY_DW_DJ_phone1 <> "" then
      rs("CY_DW_DJ_phone1") = CY_DW_DJ_phone1
	end if
    if CY_DW_DJ_otherUnit <> "" then
      rs("CY_DW_DJ_otherUnit") = CY_DW_DJ_otherUnit
	end if
    if CY_DW_DJ_appPro <> "" then
      rs("CY_DW_DJ_appPro") = CY_DW_DJ_appPro
	end if
    if CY_DW_DJ_master2 <> "" then
      rs("CY_DW_DJ_master2") = CY_DW_DJ_master2
	end if
    if CY_DW_DJ_phone2 <> "" then
      rs("CY_DW_DJ_phone2") = CY_DW_DJ_phone2
	end if
    if CY_DW_DJ_phone3 <> "" then
      rs("CY_DW_DJ_phone3") = CY_DW_DJ_phone3
	end if
    if CY_DW_DJ_gaizh <> "" then
      rs("CY_DW_DJ_gaizh") = CY_DW_DJ_gaizh
	end if
    if CY_DW_DJ_date <> "" then
      rs("CY_DW_DJ_date") = CY_DW_DJ_date
	end if
    rs.update
    rs.close
	response.Redirect("?")
  end if
end sub
%>
<%
sub delItem()
	sql="delete from AFGL_CY_DW_DJ where id="&trim(request.QueryString("id"))
	conn.execute(sql)
	response.Write("<script language=javascript>alert('删除成功！');location.href='?';</script>")
end sub
%>
<!-- 页面流程 -->
<%
action = request.QueryString("action")
Select Case action
	Case "addIF"
		call addIF()
	Case "saveAdd"
		call saveAdd()
	Case "edit"
		call editIF()
	Case "saveMod"
		call saveMod()
	Case "delItem"
		call delItem()
	Case Else
		call listAll()
End Select
%>
</body>
</html>