⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 web_educate_update.asp

📁 直接附加数据库! 修改 Include/ Class_Main.asp 为自己信息 后台admin admin 绍兴人才网程序
💻 ASP
📖 第 1 页 / 共 2 页
字号:
                            <option value="2" <% If Currencytype = 2 Then Response.write "Selected" %>>美元</option>
                            <option value="3" <% If Currencytype = 3 Then Response.write "Selected" %>>欧元</option>
                            <option value="4" <% If Currencytype = 4 Then Response.write "Selected" %>>英镑</option>
                            <option value="5" <% If Currencytype = 5 Then Response.write "Selected" %>>港币</option>
                            <option value="6" <% If Currencytype = 6 Then Response.write "Selected" %>>台币</option>
                          </select></td>
                      </tr>
                      <tr> 
                        <td height="25" align="right" bgcolor="f9f9f9"><STRONG><FONT 
                  color=#ff6600>*</FONT></STRONG> 教职工人数:</td>
                        <td height="25" bgcolor="f9f9f9"><select name="workers" id="workers" style="width:100px;">
                            <OPTION value=9 <% If Workers = 9 Then Response.write "Selected" %>>10人以下</OPTION>
                            <OPTION value=49 <% If Workers = 49 Then Response.write "Selected" %>>10~50人</OPTION>
                            <OPTION value=199 <% If Workers = 199 Then Response.write "Selected" %>>50~200人</OPTION>
                            <OPTION value=499 <% If Workers = 499 Then Response.write "Selected" %>>200~500人</OPTION>
                            <OPTION value=999 <% If Workers = 999 Then Response.write "Selected" %>>500~1000人</OPTION>
                            <OPTION value=1000 <% If Workers = 1000 Then Response.write "Selected" %>>1000人以上</OPTION>
                          </select></td>
                      </tr>
                      <tr> 
                        <td height="25" align="right"><STRONG><FONT 
                  color=#ff6600>*</FONT></STRONG> 所在地区:</td>
                        <td height="25">
                          <!--#include file="../Include/Class_Locus2.asp" -->
                        </td>
                      </tr>
                      <tr> 
                        <td height="25" align="right" bgcolor="f9f9f9"><STRONG><FONT 
                  color=#ff6600>*</FONT></STRONG> 机构简介:</td>
                        <td height="25" bgcolor="f9f9f9"><table width="99%" border="0" cellspacing="0" cellpadding="0">
                            <tr> 
                              <td width="75%"> <textarea name="school_memo" cols="45" rows="8" id="school_memo"><%= school_memo %></textarea></td>
                              <td><font color="#50463d">最大字符数5000,请尽可能详细填写资料,以确保贵院校资料顺利通过本网审核!包括:院校基本资料+招生和就业情况等</font></td>
                            </tr>
                          </table></td>
                      </tr>
                    </table>
                    <table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
                      <tr> 
                        <td height="2"></td>
                      </tr>
                    </table>
                    <table width="99%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="eeeeee">
                      <tr> 
                        <td height="25" bgcolor="f5f5f5"><b><font color="#000000">&nbsp;联系方式</font></b></td>
                      </tr>
                    </table>
                    <table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
                      <tr> 
                        <td width="18%" height="25" align="right"><STRONG><FONT 
                  color=#ff6600>*</FONT></STRONG> 联系人:</td>
                        <td height="25"><input name="contactperson" type="text" size="30" maxlength="30" style="width:120px;" value="<%= Contactperson %>"> 
                          <font color="#50463d">请输入正确联系人,以方便可以及时联系</font></td>
                      </tr>
                      <tr> 
                        <td width="18%" height="25" align="right" bgcolor="f9f9f9"><STRONG><FONT 
                  color=#ff6600>*</FONT></STRONG> 联系电话:</td>
                        <td height="25" bgcolor="f9f9f9"><input name="phone" type="text" id="phone" style="width:120px;" size="30" maxlength="30" value="<%= Phone %>"> 
                          <font color="#50463d"> [固定电话号码,如:010-82615888] </font></td>
                      </tr>
                      <tr> 
                        <td height="25" align="right">传真号码:</td>
                        <td height="25"><input name="fax" type="text" id="fax" style="width:120px;" size="30" maxlength="30" value="<%= Fax %>"></td>
                      </tr>
                      <tr> 
                        <td height="25" align="right" bgcolor="f9f9f9"><STRONG><FONT 
                  color=#ff6600>*</FONT></STRONG> 电子邮件:</td>
                        <td height="25" bgcolor="f9f9f9"><input name="email" type="text" id="email"  style="width:200px;" value="<%= Email %>" size="50"></td>
                      </tr>
                      <tr> 
                        <td height="25" align="right">网站地址:</td>
                        <td height="25"><input name="webhome" type="text" size="50" style="width:200px;" value="<%= Webhome %>"></td>
                      </tr>
                      <tr> 
                        <td height="25" align="right" bgcolor="f9f9f9"><STRONG><FONT 
                  color=#ff6600>*</FONT></STRONG> 邮政编码:</td>
                        <td height="25" bgcolor="f9f9f9"><input name="zipcode" type="text" size="6" maxlength="6" style="width:120px;"  value="<%= Zipcode %>"></td>
                      </tr>
                      <tr> 
                        <td height="25" align="right"><STRONG><FONT 
                  color=#ff6600>*</FONT></STRONG> 通讯地址:</td>
                        <td height="25"><input name="address" type="text" size="100" style="width:260px;" value="<%= Address %>">
                          如:北京市海淀区成府路××号 </td>
                      </tr>
                    </table>
                    <table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
                      <tr> 
                        <td height="2"></td>
                      </tr>
                    </table></td>
                </tr>
              </table></td>
          </tr>
          <tr> 
            <td height="40" align="center"> 
			<input name="Schid" type="hidden" value="<%= Schid %>">
			<input name="PageNo" type="hidden" value="<%= PageNo %>">
			<input type="submit" name="Submit" value=" 保存信息 " style="height:35px;"> 
            </td>
          </tr>
        </form>
      </table></td>
</tr>
</table>
</body>
</html>
<% 

Sub Submit() '保存企业基本数据

 Schid                   = Replace_Text(Request.Form("Schid"))
 SchoolName              = Replace_Text(Request.Form("SchoolName"))
 Properity				 = Replace_Text(Request.Form("Properity"))
 Set_Year                = Replace_Text(Request.Form("Set_Year"))
 Reg_Currency            = Replace_Text(Request.Form("Reg_Currency"))
 CurrencyType            = Replace_Text(Request.Form("CurrencyType"))
 Workers                 = Replace_Text(Request.Form("Workers"))
 School_Memo             = Replace_Text(Request.Form("School_Memo"))
 ContactPerson           = Replace_Text(Request.Form("ContactPerson"))
 Phone                   = Replace_Text(Request.Form("Phone"))
 Fax                     = Replace_Text(Request.Form("Fax"))
 WebHome                 = Replace_Text(Request.Form("WebHome"))
 ZipCode                 = Replace_Text(Request.Form("ZipCode"))
 Email                   = Replace_Text(Request.Form("Email"))
 Address                 = Replace_Text(Request.Form("Address"))
 Locus_Area              = Replace_Text(Request.Form("x_suozaidi"))
 Locus_City              = Replace_Text(Request.Form("x_suozaidi1"))
 PageNo					 = Replace_Text(Request.Form("PageNo"))

 If School_Memo <> "" Then School_Memo = Replace(School_Memo,Chr(13),"<br>")
 
 SQL = "Update [pH_Educate_Base] Set SchoolName='"&SchoolName&"',Properity="&Properity&",Set_Year="&Set_Year&",Reg_Currency="&Reg_Currency&",CurrencyType="&CurrencyType&",Workers="&Workers&",School_Memo='"&School_Memo&"',ContactPerson='"&ContactPerson&"',Phone='"&Phone&"',Fax='"&Fax&"',WebHome='"&WebHome&"',ZipCode='"&ZipCode&"',Email='"&Email&"',Address='"&Address&"',Locus_Area='"&Locus_Area&"',Locus_City='"&Locus_City&"',LastUpdate_Time='"&Now()&"' Where Schid='"&Schid&"'"
 Conn.Execute(SQL)
 
 Response.Write "<script>alert('编辑完成');location.href='"&PageNo&"';</script>"
 Response.End()
End Sub


'//关闭数据库连接
CloseDB

 %>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -