sitereg.aspx.cs

网络营销软件的源代码

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using WebApplication8.firstPage;
using System.Data.SqlClient;
using System.Configuration;

namespace WebApplication8.company
{
	/// <summary>
	/// Summary description for siteReg.
	/// </summary>
	public class siteReg : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.TextBox TextBox2;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected Connection conn;
		protected System.Web.UI.WebControls.Label hint;
		protected System.Web.UI.WebControls.Label count;
		protected System.Web.UI.WebControls.DropDownList type;
		protected SqlDataReader reader;

		private void Page_Load(object sender, System.EventArgs e)
		{
			conn = new Connection(Application["market"].ToString());		
			if(Session["type"] == null || !Session["type"].Equals("企业"))
				Response.Redirect("../login.aspx");
			count.Text = Application["count"].ToString();

			SqlDataReader reader = conn.execute("select * from Company where studentNO = '" + Session["studentNO"] + "'");
			if( reader.Read() )
			{
				Label1.Text = reader["comName"].ToString();
				Label2.Text = reader["realName"].ToString();
				Label3.Text = reader["userName"].ToString();
				reader.Close();
			}
			// Put user code to initialize the page here
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Button1_Click(object sender, System.EventArgs e)
		{
			string input = TextBox2.Text;
			if ( input.Length == 0 )
			{
				hint.Text = "*";
			}
			else 
			{
				Connection conn = new Connection(Application["market"].ToString());
				SqlDataReader reader = conn.execute("select * from Site where address ='" 
					+ input + "'");
				if( reader.HasRows )
				{
					reader.Close();
					hint.Text = "域名已存在";
				}
				else
				{
					try
					{
						SqlConnection connection= new SqlConnection(Application["market"].ToString());
						SqlCommand cmd = connection.CreateCommand();
						cmd.CommandText = "insert into Site (studentNO,address,visitCount,description,price,type) values ('"
							+ Session["studentNO"] + "','" + input + "','0','" + TextBox1.Text + "','300','"+type.SelectedValue+"');" + 
							"insert into AccountRecord (createTime,description,IO,money,studentNO) values ('" + 
							System.DateTime.Today + "','域名申请','买',300,'" + Session["studentNO"] + "');";
						connection.Open();
						cmd.ExecuteNonQuery();
						
						cmd.CommandText = "select * from Company where studentNO='"+Session["studentNO"]+"'";
						SqlDataReader rdr = cmd.ExecuteReader();
						if(rdr.Read())
						{
							int account = (int)(new Int32Converter().ConvertFromString(rdr["account"].ToString()));
							int profit = (Convert.ToInt32(rdr["profit"])) - 300;
							rdr.Close();
							cmd.CommandText = "update Company set account='" +(account-300)+ "',profit = " + profit + "where studentNO='"+Session["studentNO"]+"'";
							cmd.ExecuteNonQuery();
							connection.Close();
						}
						Response.Write("<script language=javascript>alert('注册成功');this.location.href='service.aspx';</script>");
					}
					catch( Exception E )
					{}
					
					Response.Redirect("comInfo.aspx");
				}
			}
		}
	}
}