addmsg_4.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.chat
{
	/// <summary>
	/// 赠送物品。
	/// </summary>
	public class addmsg_4 : System.Web.UI.Page
	{
		private void Page_Load(object sender, System.EventArgs e)
		{
			if (this.Session["info"] == null)
			{
				this.Response.Write ("<script language=javascript type=text/javascript>top.location.href='../error.aspx?v=relogin'</script>");
				return;
			}
			x.UserInfo info = (x.UserInfo) this.Session["info"];
			xajh.chat.msg chat = new xajh.chat.msg();
			chat.Start(info.UserName, info.RoomID, info.LastSaid);
			string v1 = this.Request.Form["v1"].Trim();//对谁
			string v2 = this.Request.Form["v2"].Trim();//名称
			int v3 = int.Parse(this.Request.Form["v3"]);//数量
			if (v1 == "" || v1 == info.UserName || v1 == "大家" || v2 == "" || v3 <= 0)
			{
				return;
			}
			if (info.CloseDoor == true)
			{
				this.Response.Write ("<script language=javascript type=text/javascript>alert('你目前处于闭关状态，无法赠送物品！')</script>");
				return;
			}
			if (((ArrayList) this.Application["byts_xajh_chat_online_" + info.RoomID]).IndexOf(v1) == -1)
			{
				this.Response.Write ("<script language=javascript type=text/javascript>alert('该聊友不在本聊天室内，无法对其赠送物品！')</script>");
				return;
			}
			string[] toinfo = var.public_onlineinfo[v1].ToString().Split('|');
			if (toinfo[7] == "true")
			{
				this.Response.Write ("<script language=javascript type=text/javascript>alert('" + v1 + " 目前处于闭关状态，无法对其赠送物品！')</script>");
				return;
			}
			OleDbConnection MyConn = new OleDbConnection(var.public_conn);
			MyConn.Open();
			OleDbCommand MyComm = new OleDbCommand(@"select * from [拥有物品] where [名称]=? and [拥有]='" + info.UserName + "'", MyConn);
			MyComm.Parameters.Add(new System.Data.OleDb.OleDbParameter("名称", System.Data.OleDb.OleDbType.VarWChar, 10, "名称"));
			MyComm.Parameters["名称"].Value = v2;
			OleDbDataReader dr = MyComm.ExecuteReader();
			if (dr.Read())
			{
				int thingno = (int) dr["数量"];//自己有的数量
				if (v3 > thingno)
				{
					this.Response.Write ("<script language=javascript type=text/javascript>alert('你只有 " + thingno + " 件 " + v2 + ",不能赠送 " + v3 + " 件!')</script>");
					dr.Close();
					MyConn.Close();
					MyConn.Dispose();
					return;
				}
				string thingid = dr["id"].ToString();
				string bak_memo = dr["简介"].ToString();
				string bak_othercheck = dr["其他限制"].ToString();
				bool bak_toself = (bool) dr["针对自己"];;
				bool bak_toother = (bool) dr["针对别人"];
				string sql_insert = dr["等级最大"] + "," + dr["等级最小"] + "," + dr["会员最大"] + "," + dr["会员最小"] + "," + dr["价格"] + ",'" + dr["类型"] + "'," + v3 + "," + dr["数值结束1"] + "," + dr["数值结束2"] + "," + dr["数值结束3"] + "," + dr["数值开始1"] + "," + dr["数值开始2"] + "," + dr["数值开始3"] + "," + dr["随机依据"] + ",'" + dr["性别限制"] + "','" + v1 + "'," + dr["战级最大"] + "," + dr["战级最小"] + ",'" + dr["字段名称1"] + "','" + dr["字段名称2"] + "','" + dr["字段名称3"] + "'";
				dr.Close();
				MyComm.CommandText = @"select [id] from [拥有物品] where [名称]=? and [拥有]='" + v1 + "'";
				dr = MyComm.ExecuteReader();
				if (dr.Read())
				{
					string heid = dr["id"].ToString();
					dr.Close();
					if (thingno == v3)
					{
						MyComm.CommandText = @"delete from [拥有物品] where [id]=" + thingid;
						MyComm.ExecuteNonQuery();
					}
					else
					{
						MyComm.CommandText = @"update [拥有物品] set [数量]=[数量]-" + v3 + " where [id]=" + thingid;
						MyComm.ExecuteNonQuery();
					}
					MyComm.CommandText = @"update [拥有物品] set [数量]=[数量]+" + v3 + " where [id]=" + heid;
					MyComm.ExecuteNonQuery();
				}
				else
				{
					dr.Close();
					if (thingno == v3)
					{
						MyComm.CommandText = @"update [拥有物品] set [拥有]='" + v1 + "' where [id]=" + thingid;
						MyComm.ExecuteNonQuery();
					}
					else
					{
						MyComm.Parameters.Clear();
						MyComm.CommandText = @"update [拥有物品] set [数量]=[数量]-" + v3 + " where [id]=" + thingid;
						MyComm.ExecuteNonQuery();
						MyComm.CommandText = @"INSERT INTO [拥有物品]([名称], [简介], [其他限制], [针对别人], [针对自己], [等级最大], [等级最小], [会员最大], [会员最小], [价格], [类型], [数量], [数值结束1], [数值结束2], [数值结束3], [数值开始1], [数值开始2], [数值开始3], [随机依据], [性别限制], [拥有], [战级最大], [战级最小], [字段名称1], [字段名称2], [字段名称3]) VALUES (?, ?, ?," + sql_insert + ")";
						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.VarWChar, 255, "其他限制"));
						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["名称"].Value = v2;
						MyComm.Parameters["简介"].Value = bak_memo;
						MyComm.Parameters["其他限制"].Value = bak_othercheck;
						MyComm.Parameters["针对别人"].Value = bak_toother;
						MyComm.Parameters["针对自己"].Value = bak_toself;
						MyComm.ExecuteNonQuery();
					}
				}
				MyConn.Close();
				MyConn.Dispose();
				string[] aword = new string[9];
				aword[0] = "ran";
				aword[1] = info.UserName;
				aword[2] = v1;
				aword[3] = "sys.gif";
				aword[4] = "";
				aword[5] = "";
				aword[6] = "今年过节不收礼，收礼只收<font class=\\\"byts\\\">" + v2 + "</font>。##送给%%<font style=\\\"color:#FF0000\\\">" + v3 + "</font>件<font class=\\\"byts\\\">" + v2 + "</font>。";
				aword[7] = "送礼";
				aword[8] = DateTime.Now.ToLongTimeString();
				chat.Add(aword, info);
			}
			else
			{
				dr.Close();
				MyConn.Close();
				MyConn.Dispose();
				this.Response.Write ("<script language=javascript type=text/javascript>alert('不存在此物品!')</script>");
			}

		}
		#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.Load += new System.EventHandler(this.Page_Load);
		}
		#endregion
	}
}