|
|
| Тема |
 obekt za pazene na nyakakvo sustoyanie |
|
| Автор | zono (Нерегистриран) | |
| Публикувано | 03.04.03 17:52 |
|
|
|
Zdraveite znachi imam nyakolko formi vuv edin asp fail osushtestvyava se tursene v edna baza po razlichni pokazateli (Queri-tata se obrabotvat dinamichno v zavisimost ot tova koeto se zadade ) znachi iskam da setna fokusa na nyakoi buton ot tazi forma koyato e izpratila querito ima li nyakakub nachin da zapazya promenliva sled dinamichnata obrabotka na querito ?
znachi eto go cyaloto asp "
<%@ Language=JavaScript %>
<!-- #include file="global.inc"-->
<HTML>
<HEAD>
<TITLE>Tursene v bazata</TITLE>
</HEAD>
<BODY>
<%
function NS(s)
{
if (s.valueOf()=='undefined')
return new String();
return s.valueOf();
}
%>
<H2>Mojete da tursite v ukazatelya po nyakolko priznaka</H2>
<H2>Hora koito sa abonati na BTC v momenta</H2>
<FORM action="" method=post id=form1 name=form1>
Ime<INPUT id=txtName name=txtName value='<%=NS(new String(Request("txtName")))%>'><BR>
EGN<INPUT id=txtEGN name=txtEGN value='<%=NS(new String(Request("txtEGN")))%>'><BR>
Telefon<INPUT id=txtPhone name=txtPhone value='<%=NS(new String(Request("txtPhone")))%>'><BR>Adres
<INPUT id=txtAdr name=txtAdr value='<%=NS(new String(Request("txtAdr")))%>'>
<INPUT type="submit" value="Tursi" id=submit1 name=submit1><INPUT type="reset" value="Izchisti" id=reset1 name=reset1>
</FORM>
<%
var bQuery=false;
sName=NS(new String(Request("txtName")));
sEGN=NS(new String(Request("txtEGN")));
sTel=NS(new String(Request("txtPhone")));
sAdr=NS(new String(Request("txtAdr")));
if ( sName.valueOf()!="" || sEGN.valueOf()!="" || sTel.valueOf()!="" || sAdr.valueOf()!="" )
{
bQuery=true;
}
%>
<%
var bQuery1=false;
sNamebez=NS(new String(Request("txtNamebez")));
sEGNbez=NS(new String(Request("txtEGNbez")));
if ( sNamebez.valueOf()!="" || sEGNbez.valueOf()!="" )
{
bQuery1=true;
}
%>
<%
var bQuery2=false;
sNamebez2=NS(new String(Request("txtNamebez2")));
sEGNbez2=NS(new String(Request("txtEGNbez2")));
if ( sNamebez2.valueOf()!="" || sEGNbez2.valueOf()!="" )
{
bQuery2=true;
}
%>
<INPUT type="button" value="Obratno v menuto" id=button1 name=button1 onClick="window.location='Default.asp'"><BR><BR>
<TABLE WIDTH="75%" BORDER=1 CELLSPACING=1 CELLPADDING=1>
<TR>
<TD>
<P align=center>Ime</P></TD>
<TD>
<P align=center>EGN</P></TD>
<TD>
<P align=center>Adres</P></TD>
<TD>
<P align=center>Telefon</P></TD></TR>
<%
bNeedAND=false;
sQuery="SELECT TPerson.IDPer, TPerson.Name, TPerson.EGN, TPhone.IDPho, TPhone.Phone, TPhone.Address FROM TPhone INNER JOIN (TPerson INNER JOIN Tindex ON TPerson.IDPer = Tindex.IDPer) ON TPhone.IDPho = Tindex.IDPho";
if(bQuery){
sQuery+=" WHERE";
if (sName.valueOf()!="") {
if (bNeedAND) {
sQuery+=" AND";
}
sQuery+=" TPerson.Name like '%"+sName.valueOf()+"%'";
bNeedAND=true;
}
if (sEGN.valueOf()!="") {
if (bNeedAND) {
sQuery+=" AND";
}
sQuery+=" TPerson.EGN like '%"+sEGN.valueOf()+"%'";
bNeedAND=true;
}
if (sTel.valueOf()!="") {
if (bNeedAND) {
sQuery+=" AND";
}
sQuery+=" TPhone.Phone like '%"+sTel.valueOf()+"%'";
bNeedAND=true;
}
if (sAdr.valueOf()!="") {
if (bNeedAND) {
sQuery+=" AND";
}
sQuery+=" TPhone.Address like '%"+sAdr.valueOf()+"%'";
bNeedAND=true;
}
}
else {
sQuery += " ORDER BY TPerson.Name";
}
conn = OpenConnection();
rs = conn.Execute(sQuery);
while(!rs.EOF) {
%>
<TR>
<TD><P align=center><%=rs("Name").Value%></P></TD>
<TD><P align=center><%=rs("EGN").Value%></P></TD>
<TD><P align=center><%=rs("Address").Value%></P></TD>
<TD><P align=center><%=rs("Phone").Value%></P></TD></TR>
<%
rs.MoveNext();
}
%>
</TABLE>
<DIV><H2>Hora podali molbi za telefon</H2>
<FORM action="" method=post id=form2 name=form2>Ime<INPUT id=txtNamebez name=txtNamebez value='<%=NS(new String(Request("txtNamebez")))%>'><BR>
EGN<INPUT id=txtEGNbez name=txtEGNbez value='<%=NS(new String(Request("txtEGNbez")))%>'><BR><BR><INPUT type="submit" value="Tursi" id=submit2 name=submit2><INPUT type="reset" value="Izchisti" id=reset2 name=reset2>
</FORM><TABLE cellSpacing=1 cellPadding=1 width=%"25" border=1>
<TR>
<TD>
<P align=center>Ime</P></TD>
<TD>
<P align=center>EGN</P></TD></TR>
<%
bNeedANDbez=false;
sQuery1="SELECT TPerson.IDPer, TPerson.Name, TPerson.EGN FROM TPerson LEFT JOIN Tindex ON TPerson.IDPer = Tindex.IDPer WHERE (((Tindex.IDind) Is Null))";
if(bQuery1){
sQuery1+=" AND";
if (sNamebez.valueOf()!="") {
if (bNeedANDbez) {
sQuery1+=" AND";
}
sQuery1+=" TPerson.Name like '%"+sNamebez.valueOf()+"%'";
bNeedANDbez=true;
}
if (sEGNbez.valueOf()!="") {
if (bNeedANDbez) {
sQuery1+=" AND";
}
sQuery1+=" TPerson.EGN like '%"+sEGNbez.valueOf()+"%'";
bNeedANDbez=true;
}
}
conn1 = OpenConnection();
rs1 = conn.Execute(sQuery1);
while(!rs1.EOF) {
%>
<TR>
<TD><P align=center><%=rs1("Name").Value%></P></TD>
<TD><P align=center><%=rs1("EGN").Value%></P></TD></TR>
<%
rs1.MoveNext();
}
%>
</TABLE></DIV>
<P></P>
<DIV><H2>Svobodni postove</H2>
<FORM action="search.asp" method=post id=form4 name=form4>Nomer<INPUT id=txtNamebez2 name=txtNamebez2 value='<%=NS(new String(Request("txtNamebez2")))%>'><BR>
Adres<INPUT id=txtEGNbez2 name=txtEGNbez2 value='<%=NS(new String(Request("txtEGNbez2")))%>'><BR><BR><INPUT type="submit" value="Tursi" id=submit2 name=submit2><INPUT type="reset" value="Izchisti" id=reset2 name=reset2>
</FORM>
<TABLE cellSpacing=1 cellPadding=1 width="25%" border=1>
<TR>
<TD>
<P align=center>Nomer</P></TD>
<TD>
<P align=center>Adres</P></TD></TR>
<%
bNeedANDbez2=false;
sQuery2="SELECT TPhone.IDPho, TPhone.Phone, TPhone.Address FROM TPhone LEFT JOIN Tindex ON TPhone.IDPho = Tindex.IDPho WHERE (((Tindex.IDind) Is Null))";
if(bQuery2){
sQuery2+=" AND";
if (sNamebez2.valueOf()!="") {
if (bNeedANDbez2) {
sQuery2+=" AND";
}
sQuery2+=" TPhone.Phone like '%"+sNamebez2.valueOf()+"%'";
bNeedANDbez2=true;
}
if (sEGNbez2.valueOf()!="") {
if (bNeedANDbez2) {
sQuery2+=" AND";
}
sQuery2+=" TPhone.Address like '%"+sEGNbez2.valueOf()+"%'";
bNeedANDbez2=true;
}
}
conn2 = OpenConnection();
rs2 = conn.Execute(sQuery2);
while(!rs2.EOF) {
%>
<TR>
<TD><P align=center><%=rs2("Phone").Value%></P></TD>
<TD><P align=center><%=rs2("Address").Value%></P></TD></TR>
<%
rs2.MoveNext();
}
%>
</TABLE>
</P></DIV>
</BODY>
</HTML>
| |
| |
| 
|
|
