shop.aspx.cs

ASP.NET构建的笑傲江湖社区(C#,全源码提供)

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace xajh
{
	/// <summary>
	/// shop 的摘要说明。
	/// </summary>
	public class shop : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label showtitle;
		protected System.Web.UI.WebControls.DataGrid shopview;
		protected System.Web.UI.HtmlControls.HtmlInputHidden buyid;
		protected System.Web.UI.HtmlControls.HtmlInputHidden buynum;
		protected System.Web.UI.WebControls.Button byts_buy;
		protected System.Web.UI.WebControls.Label showmsg;
		protected System.Web.UI.WebControls.Label byts_copyright;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if (this.Session["info"] == null)
			{
				this.Server.Transfer ("error.aspx?v=relogin");
			}
			if (!this.Page.IsPostBack)
			{
				string MyType = this.Request.QueryString["type"];
				if (MyType == null)
				{
					this.Server.Transfer ("error.aspx?v=请指定分类名称!");
				}
				MyType = MyType.Replace("|", "");
				if (("|" + var.public_shoptype + "|").IndexOf("|" + MyType + "|") == -1)
				{
					this.Server.Transfer ("error.aspx?v=不存在该分类!");
				}
				this.byts_copyright.Text = "授权给：<font class=\"byts\">" + var.public_user + "</font> 序列号：<font class=\"byts\">" + var.public_sn + "</font><br />作者<font class=\"byts\"><a target=_blank href=http://9diy.net/go.aspx?type=aboutme>变异天使</a></font>保留所有权利";
				this.showtitle.Text = "『" + MyType + "』商店";
				this.shopview.DataSource = var.public_shopthing.Select("类型='" + MyType + "'");
				this.shopview.DataBind();
			}
			else
			{
				this.shopview.Visible = false;
			}
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.byts_buy.Click += new System.EventHandler(this.byts_buy_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void byts_buy_Click(object sender, System.EventArgs e)
		{
			string butstr = "<br /><br /><input class=\"but\" type=\"button\" value=\" 返回 \" onclick=\"history.go(-1)\" /> <input class=\"but\" type=\"button\" value=\" 关闭 \" onclick=\"window.close()\" /><br /><br /><br /><br />";
			x.UserInfo info = (x.UserInfo) this.Session["info"];
			int buyid = int.Parse(this.buyid.Value);
			int buynum = int.Parse(this.buynum.Value);
			DataRow myrow = var.public_shopthing.Rows.Find(buyid);
			int buymoney = (int)myrow["价格"] * buynum;
			OleDbConnection MyConn = new OleDbConnection(var.public_conn);
			MyConn.Open();
			OleDbCommand MyComm = new OleDbCommand();
			MyComm.Connection = MyConn;
			MyComm.CommandText = @"update [注册用户] set [银两]=[银两]-" + buymoney + " where [id]=" + info.DataID + " and [银两]>=" + buymoney;
			if (MyComm.ExecuteNonQuery() != 1)
			{
				MyConn.Close();
				MyConn.Dispose();
				this.showmsg.Text = "你的钱不够!" + butstr;
				return;
			}
			MyComm.CommandText = @"select null from [拥有物品] where [名称]=? and [拥有]='" + info.UserName + "'";
			MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("名称", System.Data.OleDb.OleDbType.VarWChar, 10, "名称"));
			MyComm.Parameters["名称"].Value = myrow["名称"].ToString();
			OleDbDataReader dr = MyComm.ExecuteReader();
			if (dr.Read())
			{
				dr.Close();
				MyComm.CommandText = @"update [拥有物品] set [数量]=[数量]+" + buynum;
				MyComm.ExecuteNonQuery();
			}
			else
			{
				dr.Close();
				MyComm.Parameters.Clear();
				System.Random MyRan = new System.Random();
				MyComm.CommandText = "insert into [拥有物品]([等级最大], [等级最小], [会员最大], [会员最小], [价格], [简介], [类型], [名称], [其他限制], [数量], [数值结束1], [数值结束2], [数值结束3], [数值开始1], [数值开始2], [数值开始3], [随机依据], [性别限制], [拥有], [战级最大], [战级最小], [针对别人], [针对自己], [字段名称1], [字段名称2], [字段名称3]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("等级最大", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "等级最大", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("等级最小", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "等级最小", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("会员最大", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "会员最大", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("会员最小", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "会员最小", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("价格", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "价格", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("简介", System.Data.OleDb.OleDbType.VarWChar, 255, "简介"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("类型", System.Data.OleDb.OleDbType.VarWChar, 10, "类型"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("名称", System.Data.OleDb.OleDbType.VarWChar, 10, "名称"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("其他限制", System.Data.OleDb.OleDbType.VarWChar, 255, "其他限制"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("数量", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "数量", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("数值结束1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "数值结束1", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("数值结束2", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "数值结束2", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("数值结束3", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "数值结束3", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("数值开始1", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "数值开始1", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("数值开始2", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "数值开始2", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("数值开始3", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "数值开始3", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("随机依据", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "随机依据", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("性别限制", System.Data.OleDb.OleDbType.VarWChar, 4, "性别限制"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("拥有", System.Data.OleDb.OleDbType.VarWChar, 10, "拥有"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("战级最大", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "战级最大", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("战级最小", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "战级最小", System.Data.DataRowVersion.Current, null));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("针对别人", System.Data.OleDb.OleDbType.Boolean, 2, "针对别人"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("针对自己", System.Data.OleDb.OleDbType.Boolean, 2, "针对自己"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("字段名称1", System.Data.OleDb.OleDbType.VarWChar, 10, "字段名称1"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("字段名称2", System.Data.OleDb.OleDbType.VarWChar, 10, "字段名称2"));
				MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("字段名称3", System.Data.OleDb.OleDbType.VarWChar, 10, "字段名称3"));
				MyComm.Parameters["等级最大"].Value = (int) myrow["等级最大"];
				MyComm.Parameters["等级最小"].Value = (int) myrow["等级最小"];
				MyComm.Parameters["会员最大"].Value = (int) myrow["会员最大"];
				MyComm.Parameters["会员最小"].Value = (int) myrow["会员最小"];
				MyComm.Parameters["价格"].Value = (int) myrow["价格"];
				MyComm.Parameters["简介"].Value = myrow["简介"].ToString();
				MyComm.Parameters["类型"].Value = myrow["类型"].ToString();
				MyComm.Parameters["名称"].Value = myrow["名称"].ToString();
				MyComm.Parameters["其他限制"].Value = myrow["其他限制"].ToString();
				MyComm.Parameters["数量"].Value = buynum;
				MyComm.Parameters["数值结束1"].Value = (int) myrow["数值结束1"];
				MyComm.Parameters["数值结束2"].Value = (int) myrow["数值结束2"];
				MyComm.Parameters["数值结束3"].Value = (int) myrow["数值结束3"];
				MyComm.Parameters["数值开始1"].Value = (int) myrow["数值开始1"];
				MyComm.Parameters["数值开始2"].Value = (int) myrow["数值开始2"];
				MyComm.Parameters["数值开始3"].Value = (int) myrow["数值开始3"];
				MyComm.Parameters["随机依据"].Value = MyRan.Next(0, 100);
				MyComm.Parameters["性别限制"].Value = myrow["性别限制"].ToString();
				MyComm.Parameters["拥有"].Value = info.UserName;
				MyComm.Parameters["战级最大"].Value = (int) myrow["战级最大"];
				MyComm.Parameters["战级最小"].Value = (int) myrow["战级最小"];
				MyComm.Parameters["针对别人"].Value = (bool) myrow["针对别人"];
				MyComm.Parameters["针对自己"].Value = (bool) myrow["针对自己"];
				MyComm.Parameters["字段名称1"].Value = myrow["字段名称1"].ToString();
				MyComm.Parameters["字段名称2"].Value = myrow["字段名称2"].ToString();
				MyComm.Parameters["字段名称3"].Value = myrow["字段名称3"].ToString();
				MyComm.ExecuteNonQuery();
			}
			MyConn.Close();
			MyConn.Dispose();
			this.showmsg.Text = "成功地购买了<font class=\"byts\">" + buynum + "</font>件<font class=\"byts\">" + myrow["名称"] + "</font>!" + butstr;
		}
	}
}