📄 phonemanager.aspx
字号:
<%@ Page Explicit="True" Language="VB" Debug="True" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.sqlclient" %>
<!--#include file="config.aspx" -->
<!--#include file="phone_manipulate.aspx" -->
<!--#include file="newPhone.aspx" -->
<script runat="server">
Sub Page_Load( s As Object, e As EventArgs )
if session("AdminID")="" then
session("adminlog")=true
response.Redirect("adminlogin.aspx")
else
lbladmin.text=session("adminID")
call filldata
end if
End Sub
sub addphone( sender As Object, e As System.Web.UI.ImageClickEventArgs)
dim strSQLquery as string
call dbcon
strSQLQuery = "select phoneID from phone_details where PhoneID='" & txtPhnID.Text & "'"
Bcon.open
bcmd = New SqlCommand(strSQLQuery, Bcon)
objreader = bcmd.ExecuteReader
If objreader.HasRows = true Then
lblstatus.text="the Phone already exists in the database."
lblstatus.visible=true
bcon.close
ElseIf Not IsDate(txtpub.text) then
lblerror.text="Invalid date"
lblerror.visible=true
else
lblerror.text=""
lblstatus.text=""
lblstatus.visible=false
call dbcon
insertSQL="insert into phone_details(phoneID,network,man_ID,date_pub,status,dimension,weight,Disp_type,Disp_size,rng_type,custamization,vibration,phn_book,call_rec,card_slot,GPRS,HSCSD,EDGE,status_3g,WLAN,Blootooth,Infrared,USB,OS,Messeging,Browser,Clock,Games,Colors,Lang_stat,Camara,Other_features,Bat_type,Bat_standby,bat_talk,Price,Quantity,Reorder_lvl,Hits,BigImg,Smallimg,Thumnail)values(@phoneID,@Network,@man_id,@date_pub,@status,@dimension,@weight,@Disp_type,@Disp_size,@rng_type,@custamization,@vibration,@phn_book,@call_rec,@card_slot,@GPRS,@HSCSD,@EDGE,@status_3g,@WLAN,@Blootooth,@Infrared,@USB,@OS,@Messeging,@Browser,@Clock,@Games,@Colors,@Lang_stat,@Camara,@Other_features,@Bat_type,@Bat_standby,@bat_talk,@Price,@Quantity,@Reorder_lvl,@Hits,@BigImg,@Smallimg,@Thumnail)"
call createparam
bcon.open
TCmd.ExecuteNonQuery
bcon.close
call updatenewphone
response.Redirect("dbsuccess.aspx")
end if
end sub
</script>
<html>
<head>
<title>GSMLanka - Phone Manager-Add New Phones</title>
<link href="stylesheet.css" rel="stylesheet" type="text/css" />
<SCRIPT language=JavaScript
src="javascript.js"></SCRIPT>
<style type="text/css">
<!--
.borderTable {padding: 0px 0px 0px 0px;
border: 1px solid #cccccc;
}
.borderTable {padding: 0px 0px 0px 0px;
border: 1px solid #CCCCCC;
}
-->
</style>
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
.style3 {color: #CC3300}
.style4 {color: #999999}
.style6 {color: #FF9900}
.style7 {
color: #000000;
font-size: 12px;
}
.style8 {color: #336699}
.style9 {color: #003366#336699}
.style11 {color: #FF6600}
-->
</style>
<script type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>
</head>
<body onLoad="MM_preloadImages('buttons/addnewphn2.gif','buttons/ModiyPhone2.gif','buttons/User-Management2.gif','buttons/Orders2.gif','buttons/sign_out1.gif')">
<form runat="server">
<table width="799" border="0" align="center" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="112" rowspan="2" valign="top"><img src="imagenew/sg_logo.jpg" alt="Logo" width="112" height="38" /></td>
<td width="269" height="25"> </td>
<td width="317"></td>
<td width="101" rowspan="2" valign="bottom"><span class="address"><span class="style3">GSM</span> <span class="style4">Lanka <span class="style6">Home</span> </span></span></td>
</tr>
<tr>
<td height="16" valign="top" class="redfont">Welcome Administrator:
<asp:Label ID="lblAdmin" runat="server" Font-Bold="true"/></td>
<td></td>
</tr>
</table>
<br>
<table width="799" border="0" align="center" cellpadding="0" cellspacing="0" background="buttons/Admin_bblank.jpg">
<!--DWLayoutTable-->
<tr>
<td width="4" height="39"> </td>
<td width="125" valign="top"><a href="phonemanager.aspx" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Add New Phone','','buttons/addnewphn2.gif',1)"><img src="buttons/addnewphn1.gif" alt="Add New Phone" name="Add New Phone" width="125" height="39" border="0"></a></td>
<td width="123" valign="top"><a href="selectphone.aspx" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Modiy Phone','','buttons/ModiyPhone2.gif',1)"><img src="buttons/ModiyPhone1.gif" alt="Modiy Phone" name="Modiy Phone" width="127" height="39" border="0"></a></td>
<td width="148" valign="top"><a href="usermanager.aspx" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('User Managemen','','buttons/User-Management2.gif',1)"><img src="buttons/User-Management1.gif" alt="User Managemen" name="User Managemen" width="148" height="39" border="0"></a></td>
<td width="97" valign="top"><a href="orderManagement.aspx" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Orders','','buttons/Orders2.gif',1)"><img src="buttons/Orders1.gif" alt="Orders" name="Orders" width="97" height="39" border="0"></a></td>
<td width="100" valign="top"><a href="eletter.aspx" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('E-letter','','buttons/eletter2.gif',0)"><img src="buttons/eletter1.gif" alt="E-letter" name="E-letter" width="100" height="39" border="0"></a></td>
<td width="89"> </td>
<td width="83" valign="top"><a href="signout.aspx" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Sign out','','buttons/sign_out1.gif',1)"><img src="buttons/sign_out.gif" alt="Sign out" name="Sign out" width="91" height="39" border="0"></a></td>
<td width="18"> </td>
</tr>
</table>
<br />
<table width="799" border="0" align="center" cellpadding="0" cellspacing="0" background="imagenew/already_have_id.jpg">
<!--DWLayoutTable-->
<tr>
<td width="275" height="39" align="left" class="address"><span class="style8"> <img src="imagenew/Phn_man_icn..png" alt="Phone Manger " width="48" height="34">Phone Manger </span><span class="style9"></span> : ADD NEW PHONE </td>
<td width="123"> </td>
<td width="401" align="left" valign="middle"><asp:Label ID="lblstatus" runat="server" Font-Bold="true" ForeColor="#CC0000" /></td>
</tr>
</table>
<br />
<table width="799" border="0" align="center" cellpadding="0" cellspacing="0" background="imagenew/phoneman_up.jpg">
<!--DWLayoutTable-->
<tr>
<td width="799" height="11"></td>
</tr>
</table>
<table width="799" border="0" align="center" cellpadding="0" cellspacing="0" class="border4">
<!--DWLayoutTable-->
<tr>
<td width="11" height="2"></td>
<td width="382"></td>
<td width="12"></td>
<td width="323"></td>
<td width="59"></td>
<td width="10"></td>
</tr>
<tr>
<td height="88"> </td>
<td rowspan="12" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="382" height="184" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" background="imagenew/sn_bk.jpg" class="border2">
<!--DWLayoutTable-->
<tr>
<td height="23" colspan="4" valign="middle" class="redfont"> <img src="imagenew/Phn_genrl_icn..png" alt="Gendrel Details" width="26" height="20"> Gendrel Details </td>
</tr>
<tr>
<td width="95" height="5"></td>
<td width="10"></td>
<td width="256"></td>
<td width="19"></td>
</tr>
<tr>
<td height="22" align="right" valign="middle" class="leftlink">Phone ID : </td>
<td> </td>
<td valign="top"><asp:TextBox ID="txtPhnID" MaxLength="100" runat="server" />
<asp:requiredfieldvalidator id="v1" errormessege="field cannot be blank" text="*" Font-Bold="true" Font-Size="12" controltovalidate="txtPhnID" runat="server"></asp:requiredfieldvalidator></td>
<td> </td>
</tr>
<tr>
<td height="10"></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="22" align="right" valign="middle" class="leftlink">Manufacture : </td>
<td></td>
<td valign="top"><asp:DropDownList ID="cboMan" runat="server"></asp:DropDownList></td>
<td></td>
</tr>
<tr>
<td height="10"></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="22" align="right" valign="middle"><span class="leftlink">Network : </span></td>
<td></td>
<td valign="top"><asp:TextBox ID="txtNet" MaxLength="100" runat="server" />
<asp:requiredfieldvalidator id="v2" errormessege="field cannot be blank" text="*" Font-Bold="true" Font-Size="12" controltovalidate="txtNet" runat="server"></asp:requiredfieldvalidator></td>
<td></td>
</tr>
<tr>
<td height="10"></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="22" align="right" valign="middle"><span class="leftlink">Status : </span></td>
<td></td>
<td valign="top"><asp:DropDownList ID="cboStatus" runat="server">
<asp:ListItem value="Available">Available</asp:ListItem>
<asp:ListItem value="Coming Soon">Coming Soon</asp:ListItem>
</asp:DropDownList></td>
<td></td>
</tr>
<tr>
<td height="9"></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="22" align="right" valign="middle"><span class="leftlink">Published : </span></td>
<td></td>
<td valign="top"><asp:TextBox ID="txtPub" MaxLength="20" runat="server" />
<asp:requiredfieldvalidator id="v3" errormessege="field cannot be blank" text="*" Font-Bold="true" Font-Size="12" controltovalidate="txtPub" runat="server"></asp:requiredfieldvalidator>
<asp:Label ID="lblerror" runat="server" Font-Bold="true" ForeColor="#CC0000" /></td>
<td></td>
</tr>
<tr>
<td height="5"></td>
<td></td>
<td></td>
<td></td>
</tr>
</table></td>
</tr>
<tr>
<td height="13"></td>
</tr>
<tr>
<td height="125" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" background="imagenew/sn_bk.jpg" class="border2">
<!--DWLayoutTable-->
<tr>
<td width="1" height="1"></td>
<td width="94"></td>
<td width="9"></td>
<td width="208"></td>
<td width="68"></td>
</tr>
<tr>
<td height="22"></td>
<td colspan="4" valign="middle" class="redfont"> <img src="imagenew/Phn_ring_icn..png" alt="Ringtones" width="26" height="20">Ringtones</td>
</tr>
<tr>
<td height="4"></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="22"></td>
<td align="right" valign="middle" class="leftlink">Type : </td>
<td> </td>
<td valign="top"><asp:TextBox ID="txtRtype" MaxLength="100" runat="server" />
<asp:requiredfieldvalidator id="v4" errormessege="field cannot be blank" text="*" Font-Bold="true" Font-Size="12" controltovalidate="txtRtype" runat="server"></asp:requiredfieldvalidator></td>
<td> </td>
</tr>
<tr>
<td height="10"></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="22"></td>
<td align="right" valign="middle" class="leftlink">Customization : </td>
<td></td>
<td valign="top"><asp:TextBox ID="txtCustom" MaxLength="100" runat="server" />
<asp:requiredfieldvalidator id="v5" errormessege="field cannot be blank" text="*" Font-Bold="true" Font-Size="12" controltovalidate="txtCustom" runat="server"></asp:requiredfieldvalidator></td>
<td></td>
</tr>
<tr>
<td height="10"></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td height="22"></td>
<td align="right" valign="middle"><span class="leftlink">Vibration : </span></td>
<td></td>
<td valign="top"><asp:DropDownList ID="cboVibtion" runat="server">
<asp:ListItem value="Yes">Yes</asp:ListItem>
<asp:ListItem value="No">No</asp:ListItem>
</asp:DropDownList></td>
<td></td>
</tr>
<tr>
<td height="9"></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</table></td>
</tr>
<tr>
<td height="12"></td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -