<%@ Page CodeBehind="005.aspx.cs" Language="c#" AutoEventWireup="false" Inherits="yn165.admin._005" %>
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.SqlClient"%>
<HTML>
	<HEAD>
	<% if (Session["admin_yn165"]==null || Session["admin_yn165"]==""){
		Response.Redirect("../index.aspx");
		}
		%>
		<TITLE>创库网络(昆明)后台管理系统</TITLE>
		<META http-equiv="Content-Type" content="text/html; charset=gb2312">
		<META http-equiv="Pragma" content="no-cache">
		<STYLE type="text/css">INPUT {
	FONT-SIZE: 9pt; FONT-FAMILY: "宋体"; TEXT-DECORATION: none
}
.big {
	FONT-SIZE: 10.5pt; FONT-FAMILY: "宋体"; TEXT-DECORATION: none
}
A:hover {
	COLOR: #ff6666; FONT-FAMILY: "宋体"; TEXT-DECORATION: none
}
A {
	FONT-FAMILY: "宋体"; TEXT-DECORATION: none
}
TD {
	FONT-SIZE: 9pt; FONT-FAMILY: "宋体", "Arial", "Times New Roman"; TEXT-DECORATION: none
}
.big2 {
	FONT-SIZE: 10.5pt; LINE-HEIGHT: 13pt; FONT-FAMILY: "宋体"; TEXT-DECORATION: none
}
.unnamed1 {
	FONT-SIZE: 7pt; TEXT-DECORATION: none
}
.unnamed2 {
	FONT-SIZE: 12pt; TEXT-DECORATION: none
}
.botton {
	BORDER-RIGHT: 1px solid; BORDER-TOP: #cccccc 1px solid; FONT-SIZE: 9pt; BORDER-LEFT: #cccccc 1px solid; COLOR: #000000; BORDER-BOTTOM: 1px solid; BACKGROUND-COLOR: #deeaf3
}
.txt {
	BORDER-RIGHT: 1px inset; BORDER-TOP: 1px inset; FONT-SIZE: 8pt; VERTICAL-ALIGN: text-bottom; BORDER-LEFT: 1px inset; BORDER-BOTTOM: 1px inset; FONT-FAMILY: Tahoma
}
</STYLE>
		<!--web design:zheng guiwen E-mail:guiwen@zheng.com.cn -->
		<META content="Microsoft FrontPage 4.0" name="GENERATOR">
		<base target="bottom">
	</HEAD>
	<BODY text="#000000" vLink="#990000" aLink="#000000" link="#000000" bgColor="#f0f0f0" leftMargin="0" topMargin="10" onload="" marginheight="0" marginwidth="0">
		<form runat="server" target="_self">
			<%SqlConnection conn = new SqlConnection("server=211.155.254.117;database=yn165;uid=yn165;pwd=159753");
			conn.Open();
			string sql = "select * from shangping";
			SqlCommand cmd = new SqlCommand(sql,conn);
			SqlDataReader reader = cmd.ExecuteReader();
			
%>
			<table cellSpacing="3" cellPadding="3" width="100%" border="0">
				<tr>
					<td>
						<div class="unnamed2" align="center"><font color="#ff3300">商品录入</font></div>
					</td>
				</tr>
			</table>
			<table cellSpacing="1" cellPadding="4" width="98%" align="center" bgColor="#cccccc" border="0">
				<TBODY>
					<tr align="middle">
						<td width="59" bgColor="#f0f0f0">商品编号</td>
						<td width="132" bgColor="#f0f0f0">商品项目名</td>
						<td width="294" bgColor="#f0f0f0">说明</td>
						<td width="42" bgColor="#f0f0f0">单价</td>
						<td width="68" bgColor="#f0f0f0">单位</td>
						<td width="273" bgColor="#f0f0f0">价格类型</td>
						<td align="middle" width="60" bgColor="#f0f0f0">操 作</td>
					</tr>
					<tr align="middle">
						<td width="59" bgColor="#deeaf3"><asp:textbox class="txt" id="sp_code" runat="server" size="8"></asp:textbox></td>
						<td width="132" bgColor="#deeaf3"><asp:textbox class="txt" id="sp_name" runat="server" size="30"></asp:textbox></td>
						<td width="294" bgColor="#deeaf3"><asp:textbox class="txt" id="explain" runat="server" size="70"></asp:textbox></td>
						<td width="42" bgColor="#deeaf3"><asp:textbox class="txt" id="price" runat="server" size="8"></asp:textbox></td>
						<td width="68" bgColor="#deeaf3"><asp:textbox class="txt" id="p_unit" runat="server" size="12"></asp:textbox></td>
						<td width="273" bgColor="#deeaf3">&nbsp;
							<asp:dropdownlist id="type" runat="server" CssClass="botton">
								<asp:ListItem Value="普通会员价格">普通会员价格</asp:ListItem>
								<asp:ListItem Value="普通代理价格">普通代理价格</asp:ListItem>
								<asp:ListItem Value="中级代理价格">中级代理价格</asp:ListItem>
								<asp:ListItem Value="高级代理价格">高级代理价格</asp:ListItem>
								<asp:ListItem Value="特殊优惠价格">特殊优惠价格</asp:ListItem>
							</asp:dropdownlist></td>
						<td align="middle" width="60" bgColor="#deeaf3">
							<asp:Button id="Button1" runat="server" CssClass="botton" Text="增加"></asp:Button></td>
					</tr>
					<%  while (reader.Read())
			{ %>
					<tr align="middle">
						<td width="59" bgColor="#ffffff" height="22"><%=reader.GetValue(1) %></td>
						<td width="132" bgColor="#ffffff" height="22"><%=reader.GetValue(2) %></td>
						<td width="294" bgColor="#ffffff" height="22"><%=reader.GetValue(3) %></td>
						<td width="42" bgColor="#ffffff" height="22"><%=reader.GetValue(4) %></td>
						<td width="68" bgColor="#ffffff" height="22"><%=reader.GetValue(5) %></td>
						<td width="273" bgColor="#ffffff" height="22"><%=reader.GetValue(6)%></td>
						<td align="middle" width="60" bgColor="#ffffff" height="22"><A onclick=delete_confirm(this) href="del.aspx?id=<%=reader.GetValue(0)%>" target=_self >删 
								除</A></td>
					</tr>
					<% } 
			reader.Close();
			conn.Close();
			%>
				</TBODY></table>
			<table cellSpacing="3" cellPadding="3" width="98%" align="center" border="0">
				<tr>
					<td align="right" width="98%">首页 | 上一页 | 下一页 | 尾页</td>
					<td width="2%">&nbsp;</td>
				</tr>
			</table>
		</form>
	</BODY>
</HTML>
