contract.aspx.cs

网络营销软件的源代码

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


namespace WebApplication8.firstPage
{
	/// <summary>
	/// contract 的摘要说明。
	/// </summary>
	public class contract : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox buyer;
		protected System.Web.UI.HtmlControls.HtmlInputText buyerName;
		protected System.Web.UI.WebControls.TextBox seller;
		protected System.Web.UI.HtmlControls.HtmlInputText sellerName;
		protected System.Web.UI.HtmlControls.HtmlInputText time;
		protected System.Web.UI.HtmlControls.HtmlTextArea body;
		protected System.Web.UI.HtmlControls.HtmlInputButton submit;
		protected System.Web.UI.WebControls.TextBox productName;

		protected System.Web.UI.HtmlControls.HtmlTableCell shop;
		protected System.Web.UI.HtmlControls.HtmlTableCell ads;
		protected System.Web.UI.WebControls.TextBox price;
		protected System.Web.UI.WebControls.Label count;
		protected System.Web.UI.WebControls.Button cancel;
		SqlDataReader reader;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(Session["userName"]==null)
				Response.Redirect("../login.aspx");


			if(Session["type"].Equals("个人"))
				shop.InnerHtml = "<div align='center'><A href='shopping.aspx'><IMG height='29' src='images/shopping.gif' width='157' border='0'></A></div>";
			else if(Session["type"].Equals("企业"))
				shop.InnerHtml = "<div align='center'><A href='enterprise.aspx'><IMG height='29' src='images/shopping.gif' width='157' border='0'></A></div>";
			
			if(Session["type"].ToString().Equals("个人"))
				ads.Visible = false;

			count.Text = Application["count"].ToString();

			buyer.Text = Session["comName"].ToString();
			buyerName.Value = Session["userName"].ToString();
			productName.Text = Session["title"].ToString();
			time.Value = System.DateTime.Now.ToString();
			price.Text = Session["price"].ToString();

			Connection connection = new Connection(Application["market"].ToString());
			reader = connection.execute("select * from company where studentNO='"+Session["comB"].ToString()+"'");

			if(reader.Read())
			{
				seller.Text = reader["comName"].ToString();
				sellerName.Value = reader["userName"].ToString();
				reader.Close();
			}

		}

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

		}
		#endregion

		private void submit_ServerClick(object sender, System.EventArgs e)
		{
			try
			{
				Connection connection = new Connection(Application["market"].ToString());

				reader = connection.execute("insert into Contract values ('"+Session["title"].ToString()+"','1','"+Session["price"].ToString()+"','"+Session["comB"].ToString()+"','"+Session["studentNO"].ToString()+"','"+System.DateTime.Now.ToString()+"','已确认')");
				reader.Close();

				reader = connection.execute("insert into AccountRecord(createTime,description,IO,money,studentNO,comB,productName) values ('"+System.DateTime.Now.ToString()+"','商贸交易','买','"+Session["price"].ToString()+"','"+Session["studentNO"].ToString()+"','"+Session["comB"].ToString()+"','"+Session["title"].ToString()+")");
				reader.Close();

				int account;
				Int32Converter converter = new Int32Converter();
				reader = connection.execute("select * from company where studentNO='"+Session["comB"].ToString()+"'");
				if(reader.Read())
				{
					account = (int)(converter.ConvertFromString(reader["account"].ToString()));

					account += (int)(converter.ConvertFromString(Session["price"].ToString()));
					reader.Close();
					reader = connection.execute("update Company set account='"+account+"' where studentNO='"+Session["comB"].ToString()+"'");
				}
				reader.Close();

				reader = connection.execute("select * from company where studentNO='"+Session["studentNO"].ToString()+"'");
				if(reader.Read())
				{
					account = (int)(converter.ConvertFromString(reader["account"].ToString()));

					account -= (int)(converter.ConvertFromString(Session["price"].ToString()));
					reader.Close();
					reader = connection.execute("update Company set account='"+account+"' where studentNO='"+Session["studentNO"].ToString()+"'");
				}
				reader.Close();
				Response.Write("<script language=javascript>alert('合同签订成功');this.location.href='enterprise.aspx';</script>");
			}
			catch(Exception o)
			{
				Response.Redirect("enterprise.aspx");
			}
		}

		private void cancel_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("enterprise.aspx");
		}
	}
}