prodetail.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 System.Data.SqlClient;
using System.Configuration;
using WebApplication8.firstPage;
using System.IO;

namespace WebApplication8.company
{
	/// <summary>
	/// Summary description for addServ.
	/// </summary>
	public class proDetail: System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox TextBox2;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Label count;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label Label4;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.Label Label5;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator1;
		protected System.Web.UI.WebControls.Label Label6;
		protected System.Web.UI.WebControls.Image Image1;
		string id;
		string materialID;
		string total;
		string cost;

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

			//if( !Page.IsPostBack )
			//{
				id = Request.QueryString["id"];
				if( id != "" )
				{
					Connection conn = new Connection(Application["market"].ToString());
					SqlDataReader reader = conn.execute("select * from Product where productid = " + id);
					if( reader.Read() )
					{
						Label3.Text = reader["productName"].ToString();
						TextBox2.Text = reader["description"].ToString();
						Label1.Text = reader["material"].ToString();
						Label2.Text = reader["cost"].ToString();
						Label4.Text = reader["price"].ToString();
				
						if( File.Exists("../firstpage/ShoppingPic/" + id + ".bmp") )
						{
							Label5.Visible = false;
							Image1.ImageUrl = "../firstpage/ShoppingPic/" + id + ".bmp";
						}
						else
						{
							Image1.Visible = false;
						}

						materialID = reader["materialID"].ToString();
						total = reader["number"].ToString();
						cost = reader["cost"].ToString();
					}
				}
				else
					Response.Redirect("product.aspx");
			//}
			// 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)
		{
			Connection conn = new Connection(Application["market"].ToString());
			SqlDataReader reader = conn.execute("select * from Material where id =" + materialID);
			if( reader.Read())
			{
				int number = Convert.ToInt32(reader["totalNumber"].ToString());
				int input = Convert.ToInt32(TextBox1.Text);
				if ( input > number )
				{
					Label6.Text = "系统原料不足";
					return;
				}
				
				reader.Close();

				int no = input + Convert.ToInt32(total);
				reader = conn.execute("update Product set number = '" + no + "' where productid =" + id);
				
				reader.Close();
				reader = conn.execute("update Material set totalNumber = '" + (number-input) + "' where id=" + materialID);
				reader.Close();

				int pay = (Convert.ToInt32(cost))*input;
				reader = conn.execute("insert into AccountRecord(createTime,description,IO,money,studentNO) values ('"+System.DateTime.Now.ToString()
						+ "','生产产品','买','"	+ pay + "','" + Session["studentNO"]+"')");
				reader.Close();
				
				reader = conn.execute("select * from Company where studentNO='"+Session["studentNO"]+"'");
				if(reader.Read())
				{
					int account =(Convert.ToInt32(reader["account"])) - pay;
					int profit = (Convert.ToInt32(reader["profit"])) - pay;
					reader.Close();
					
					conn.execute("update Company set account='" + account + "',profit = " + profit + "where studentNO='"+Session["studentNO"]+"'");
				}
				Response.Redirect("product.aspx");
			}
		}
	}
}