Duvida !
Pergunta
Respostas
Todas as Respostas
-
codigo da tela funcionario1.asp !!
<!--#include file="conexao.asp"-->
<%
'----Executando a procedure getsequencial-------------DIM SENHA
Session("SENHA") = "login.asp"
IF Session("SENHA")<>"" THEN
Response.Redirect(Session("SENHA"))
ELSE
Response.Redirect("login.asp")
END IFIF session("ID_FUNCIONARIO")="" THEN
Set cmGetID = Server.CreateObject("ADODB.Command")
Set cmGetID.ActiveConnection = conexao
cmGetID.CommandText = "dbo.sp_getsequencial"
cmGetID.CommandType = 4 ' adCmdStoredProcSet objParam = cmGetID.CreateParameter("@pr_nom_table", 200, 1,50,"FUNCIONARIO")
cmGetID.Parameters.Append objParam
Set objParam = cmGetID.CreateParameter("@ID_FUNCIONARIO", 19 , 1, 1, 1)
cmGetID.Parameters.Append objParam
Set objParam = cmGetID.CreateParameter("@pr_nom_field", 200, 1,50,"")
cmGetID.Parameters.Append objParam
Set objParam = cmGetID.CreateParameter("@pr_sequencial", 19 , 2,,null)
cmGetID.Parameters.Append objParam
cmGetID.Execute
session ("ID_FUNCIONARIO")= cmGetID("@pr_sequencial")'recuperando valor @pr_sequencial e passa para variarvel ID_OPERADOR
'----------------------------------------------------------------------------------------------------------
END IF
%>
<!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=iso-8859-1" />
<title>:: Briefing _________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________</title>
<style type="text/css">body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
A.menu_sup {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
color: #ffffff;
}A.menu_sup:link {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
color: #ffffff;
}A.menu_sup:hover {
text-decoration: none;
color: #dadada;}
.campo {BACKGROUND: #f8f8f8;
COLOR: #265490;
BORDER-BOTTOM: #265490 1px solid;
BORDER-LEFT: #EFEFEF 1px solid;
BORDER-RIGHT: #265490 1px solid;
BORDER-TOP: #EFEFEF 1px solid;
FONT-SIZE: 10px;
height : 20;
}a {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
color: #265490;
}a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
color: #999999;
}
a:active {
text-decoration: none;
}.style5 {color: #FFFFFF}
.style8 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 10px;
color: #255691;
}
.style7 {font-size: 10px; color: #1C406C; font-family: Verdana, Arial, Helvetica, sans-serif;}
.botao {BACKGROUND: #f8f8f8;
COLOR: #265490;
BORDER-BOTTOM: #265490 1px solid;
BORDER-LEFT: #EFEFEF 1px solid;
BORDER-RIGHT: #265490 1px solid;
BORDER-TOP: #EFEFEF 1px solid;
FONT-SIZE: 10px;
width:80px;
height : 20;
}
</style></head><body>
<script language="javascript">
window.name = "janela";
function valida(){
Funcionario.txt_nome.focus(document.Funcionario.txt_nome.style.background ="");
Funcionario.Empresa.focus(document.Funcionario.Empresa.style.background ="");
Funcionario.text_email.focus(document.Funcionario.text_email.style.background ="");
Funcionario.text_login.focus(document.Funcionario.text_login.style.background ="");
Funcionario.text_senha.focus(document.Funcionario.text_senha.style.background ="");
Funcionario.text_hora_ini.focus(document.Funcionario.text_hora_ini.style.background ="");
Funcionario.text_hora_fim.focus(document.Funcionario.text_hora_fim.style.background ="");
if (Funcionario.txt_nome.value ==""){
alert('Por preencha o campo Nome!');
Funcionario.txt_nome.focus(document.Funcionario.txt_nome.style.background ="#FFFFCC");
return false;
}
if (Funcionario.Empresa.value ==""){
alert('Por favor preencha o campo Empresa!');
Funcionario.Empresa.focus(document.Funcionario.Empresa.style.background ="#FFFFCC");
return false;
}
if (Funcionario.text_email.value ==""){
alert('POR FAVOR PREENCHA O CAMPO E_MAIL!');
Funcionario.text_email.focus(document.Funcionario.text_email.style.background ="#FFFFCC");
return false;
}if (Funcionario.text_login.value ==""){
alert('POR FAVOR PREENCHA O CAMPO LOGIN!');
Funcionario.text_login.focus(document.Funcionario.text_login.style.background ="#FFFFCC");
return false;
}
if (Funcionario.text_senha.value ==""){
alert('POR FAVOR PREENCHA O CAMPO SENHA!');
Funcionario.text_senha.focus(document.Funcionario.text_senha.style.background ="#FFFFCC");
return false;
}
if (Funcionario.text_hora_ini.value ==""){
alert('POR FAVOR PREENCHA O CAMPO HORA INICIAL!');
Funcionario.text_hora_ini.focus(document.Funcionario.text_hora_ini.style.background ="#FFFFCC");
return false;
}
if (Funcionario.text_hora_fim.value ==""){
alert('POR FAVOR PREENCHA O CAMPO HORA FIM!');
Funcionario.text_hora_fim.focus(document.Funcionario.text_hora_fim.style.background ="#FFFFCC");
return false;
}
if (Funcionario.text_valor_hora.value ==""){
alert('POR FAVOR PREENCHA O CAMPO VALOR DA HORA!');
Funcionario.text_valor_hora.focus(document.Funcionario.text_valor_hora.style.background ="#FFFFCC");
return false;
}
document.Funcionario.action="incluir_funcionario.asp";
document.Funcionario.submit();
}
</script><script language="javascript">
function valor(){}
</script><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="502" height="100" background="images/topo_01.jpg"><img src="images/chamado_2_01.jpg" width="502" height="99" /></td>
<td width="100%" background="images/topo_01.jpg"></td>
<td width="271"><img src="images/chamado_2_03.jpg" width="271" height="100" /></td>
</tr>
<tr>
<td height="1" colspan="3" bgcolor="#F8f8f8"></td>
</tr>
<tr>
<td height="1" colspan="3" bgcolor="#F8f8f8"></td>
</tr>
<tr>
<td colspan="3" valign="top" bgcolor="#FFFFFF"><table width="100%" border="0" align="right" cellpadding="0" cellspacing="0">
<tr>
<td width="1%" bgcolor="#265490"> </td>
<td width="100%" height="22" valign="top" bgcolor="#265490"><a href="empresa1.asp" class="menu_sup"> Cadastro</a><span class="style5"> | </span><a href="processos.html" class="menu_sup">Processos</a> <span class="style5">| </span><a href="seguranca.html" class="menu_sup">Segurança</a> <span class="style5">|</span> <a href="relatorios.html" class="menu_sup">Relatórios</a> <span class="style5">|</span> <a href="gerenciamento.html" class="menu_sup">Gerenciamento</a> <span class="style5">|</span> <a href="login.asp" class="menu_sup">Sair</a></td>
</tr>
</table></td>
</tr>
<tr>
<td height="1" colspan="3" bgcolor="#ffffff"></td>
</tr>
<tr>
<td height="430" colspan="3"><table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="20%" valign="top" bgcolor="#FFFFFF"><br />
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="2">
<tr>
<td bgcolor="#FFFFFF"><img src="images/cadastro.jpg" width="136" height="28" /><br />
<img src="images/menuMiniBullet.gif" width="4" height="4" /> <a href="empresa1.asp">Empresas </a><br />
<img src="images/menuMiniBullet.gif" width="4" height="4" /> <a href="funcionario1.asp">Funcionários</a><br />
<img src="images/menuMiniBullet.gif" width="4" height="4" /> <a href="Cliente.asp">Clientes</a><br />
<img src="images/menuMiniBullet.gif" width="4" height="4" /> <a href="Cargo.asp">Cargos</a><br />
<img src="images/menuMiniBullet.gif" width="4" height="4" /> <a href="Tipo_telefone.asp">Tipos de telefone </a></td>
</tr>
<tr>
<td> </td>
</tr>
</table></td><td width="1" background="images/fd.jpg" bgcolor="#CCCCCC"></td>
<td width="79%" valign="top" bgcolor="#FFFFFF">
<form action="" method="post" name="Funcionario;" id="Funcionario" onsubmit="funcao();";onSubmit="return valida();" >
<table width="" border="0" cellspacing="2">
<br />
<tr>
<td></td>
</tr>
</table>
<table>
<tr>
<td class="style7"> Codigo:<br />
<div id="chamaCod">
<input name="txt_codigo" type="text" class="campo" id="txt_codigo" value="<%=session ("ID_FUNCIONARIO")%>" size="13" />
</div> </td>
</tr>
</table>
<table>
<tr>
<td class="style7"> Nome: <br />
<input name="txt_nome" type="text" class="campo" id="txt_nome" size="35" maxlength="100"/></td>
<td class="style7">Empresa<br />
<select name="Empresa" size="1" class="style7" onChange="recupera_cargo1(this.value);chamaId(this.value);">
<option><-- Selecione Empresa --></option>
<%
SQL = "SELECT id_empresa, Razao_Social FROM EMPRESA ORDER BY Razao_Social "
SET rs1 = conexao.execute(SQL)
Do while rs1.eof = false
%>
<option value = "<%=rs1("id_empresa")%>"><%=rs1("Razao_Social")%></option>
<%
rs1.movenext
Loop
%>
</select></td>
</tr>
</table>
<table>
<tr>
<td><div id="cargo"><span class="style7">Cargo:</span><br />
<select name="Cargo" class="style7" id="Cargo">
<option><--Selecione o Cargo --></option>
</select>
<img src="images/icon_lupa.jpg" width="20" height="20" border="0" onclick="window.open('cadastrar_Cargo.asp','Departamentos','scrollbars=yes, resiseable=no, width=765, height=400,left=150, top=90');" /></div> </td>
<td class="style7">E_mail: <br />
<input name="text_email" type="text" class="campo" id="text_email" size="35" maxlength="100"/></td>
<td class="style7">Login: <br />
<input name="text_login" type="text" class="campo" id="text_login" size="20" maxlength="10"/></td>
<td class="style7">Senha: <br />
<input name="text_senha" type="password" class="campo" id="text_senha" size="15" maxlength="100"/> </td>
</tr>
</table>
<table>
<tr>
<td class="style7">Hora Inical :<br />
<input name="text_hora_ini" type="text" class="campo" id="text_hora_ini" size="20" maxlength="50" /></td>
<td class="style7">Hora Fim :<br />
<input name="text_hora_fim" type="text" class="campo" id="text_hora_fim" size="20" maxlength="50" /></td>
<td><span class="style7">Valor da Hora:<br />
</span><span class="style7">
<input name="text_valor_hora" type="text" class="campo" id="text_valor_hora" size="20" maxlength="50" />
</span></td>
</tr>
</table>
<table>
<tr>
<td class="style7">Flag Temporario:
<input name="check_temp" type="checkbox" id="check_temp" value="check_temp" checked="checked" /></td>
</tr>
</table>
<table>
<tr>
<td class="style7" colspan="5"><div align="left"><br />
<input name="Gravar" type="button" class="botao" id="Gravar" value="Gravar" onclick="valida();"/>
<input name="Consultar" type="button" class="botao" id="Consulta" value="Consultar" onclick="window.open('consu_funcionario.asp','Departamentos','scrollbars=yes, resiseable=no, width=765, height=570,left=150, top=90');" />
<input name="Limpar" type="reset" class="botao" id="Limpar" value="Limpar" />
<input name="acao" type="hidden" id="acao" value="gravar"/>
</div></td>
</tr>
</table>
</form></td>
</tr>
</table></td>
</tr>
<tr>
<td height="15" colspan="3" bgcolor="#265490"></td>
</tr>
</table>
</body>
</html>
<script language="javascript">
function createXMLHTTP(){
try{
ajax = new ActiveXObject("Microsoft.XMLHTTP");
}
catch(e){
try{
ajax = new ActiveXObject("Msxml2.XMLHTTP");
alert(ajax);
}
catch(ex)
{
try{
ajax = new XMLHttpRequest();
}
catch(exc){
alert("Esse browser não tem recursos para uso do Ajax");
ajax = null;
}
}
return ajax;
}
var arrSignatures = ["MSXML2.XMLHTTP.5.0", "MSXML2.XMLHTTP.4.0","MSXML2.XMLHTTP.3.0", "MSXML2.XMLHTTP","Microsoft.XMLHTTP"];
for (var i=0; i < arrSignatures.length; i++) {
try {var oRequest = new ActiveXObject(arrSignatures
);
return oRequest;
} catch (oError) {
}
}
throw new Error("MSXML is not installed on your system.");
}
function recupera_cargo1(sTipo){
var oHTTPRequest = createXMLHTTP();
oHTTPRequest.open("post", "recupera_cargo1.asp", true);
// Para solicitações utilizando o método post, deve ser acrescentado este cabecalho HTTP
oHTTPRequest.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
oHTTPRequest.onreadystatechange=function() {
if (oHTTPRequest.readyState==4){
document.all.cargo.innerHTML = oHTTPRequest.responseText;
}
}
oHTTPRequest.send("tipo=" + sTipo);
}
function chamaId(sTipo){
var oHTTPRequest = createXMLHTTP();
oHTTPRequest.open("post", "recupera_id1.asp", true);
// Para solicitações utilizando o método post, deve ser acrescentado este cabecalho HTTP
oHTTPRequest.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
oHTTPRequest.onreadystatechange=function() {
if (oHTTPRequest.readyState==4){
document.all.chamaCod.innerHTML = oHTTPRequest.responseText;
}
}
oHTTPRequest.send("tipo=" + sTipo);
}
</script>Abraço.
Emerson Sobral
