staddproduct.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;

namespace STcontract.Manager
{
	/// <summary>
	/// AddProduct 的摘要说明。
	/// </summary>
	public class AddProduct : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox STProPrice;
		protected System.Web.UI.WebControls.TextBox STProInfo;
		protected System.Web.UI.WebControls.Button STProd_add;
		protected System.Web.UI.WebControls.Button STProd_reset;
		protected System.Web.UI.WebControls.Label STProd_warn;
		protected System.Web.UI.WebControls.TextBox STProdName;
		protected System.Web.UI.WebControls.DataGrid STmyGrid;
		protected System.Web.UI.WebControls.Label STStat;
		protected System.Web.UI.WebControls.DropDownList ST_Prod;
		protected System.Web.UI.WebControls.Button ST_ok;
		protected System.Web.UI.WebControls.Label ST_Warn;

		SqlConnection STconn;
		protected System.Web.UI.WebControls.DropDownList ST_Dep;
		protected System.Web.UI.WebControls.TextBox STDepNum;
		protected System.Web.UI.WebControls.TextBox STProdBZ;
		protected System.Web.UI.WebControls.TextBox STProdSH;
		private string STmysql;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if(Session["STNickName"] != null)
			{
				//获得数据库连接字符串
				string STconnection = ConfigurationSettings.AppSettings["strconnection"];
				STconn = new SqlConnection(STconnection);			
		
				if(!IsPostBack)
				{
					//自定义BindGrid ()方法，加载向连锁分店添加产品的信息
					BindGrid();
					STconn.Open ();
					//创建查询产品信息的sql语句
					string STmysql1 = "select * from STProd";
					//创建数据库的SqlCommand对象
					SqlCommand STcmd1 =new SqlCommand(STmysql1,STconn);
					//通过调用ExecuteReader()从数据库中检索行，创建SqlDataReader实例
					SqlDataReader STdr1 = STcmd1.ExecuteReader ();
					//初始化产品下拉列表框
					ST_Prod.Items.Add(new ListItem("","-1"));
					while(STdr1.Read ())
					{
						//向下拉列表框添加产品名字，ID
						ST_Prod.Items.Add(new ListItem(STdr1["STProdName"].ToString() ,STdr1["STProdID"].ToString()) );
					
					}
					STconn.Close ();
					STconn.Open();
					//创建查询连锁店信息的sql语句
					string STmysql = "select * from STDep";
					//创建数据库的SqlCommand对象
					SqlCommand STcmd =new SqlCommand(STmysql,STconn);
					//通过调用ExecuteReader()从数据库中检索行，创建SqlDataReader实例
					SqlDataReader STdr = STcmd.ExecuteReader ();
					//初始化连锁分店下拉列表框
					ST_Prod.Items.Add(new ListItem("","-1") );
					while(STdr.Read())
					{
						//向下拉列表框添加连锁分店名字，ID
						ST_Dep.Items.Add(new ListItem(STdr["STDepName"].ToString() ,STdr["STDepID"].ToString()) );
					}
					STconn.Close();

				}
			}
			else
			{
				Response.Redirect("../Index.aspx");
			}
			
		}
		

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.STmyGrid.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.STmyGrid_cancel);
			this.STmyGrid.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.STmyGrid_edit);
			this.STmyGrid.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.STmyGrid_update);
			this.STmyGrid.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.STmyGrid_delete);
			this.ST_ok.Click += new System.EventHandler(this.ST_ok_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		//加载向连锁分店添加产品的信息
		public void BindGrid()
		{
			
			STmysql = "select STProDe.ID,STProDe.STProdID,STDep.STDepName,STProDe.STProdName,STProDe.STProdNum,STProDe.STProdPrice,STProDe.STProdBZ,STProDe.STProdSH,STProDe.STProdInfo from STProDe,STDep where STProDe.STDepID = STDep.STDepID";
			SqlDataAdapter STsda=new SqlDataAdapter(STmysql,STconn);
			DataSet STds=new DataSet();
			STsda.Fill(STds);
			STmyGrid.DataSource = STds;
			
			STmyGrid.DataBind();


		}
		//处理分页
		public void STmyGrid_Page(object sender,DataGridPageChangedEventArgs e)
		{
			//获取DataGrid的当前显示页的索引
			STmyGrid.CurrentPageIndex=e.NewPageIndex;
			BindGrid();
		}
		private void STProd_reset_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("STAddProduct.aspx");
		}

		public void STmyGrid_cancel(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			STmyGrid.EditItemIndex=-1;
			BindGrid();
		}

		public void STmyGrid_delete(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string STstrsql = "delete from STProDe  where ID = @ID";
			SqlCommand STcmd = new SqlCommand(STstrsql,STconn);
			STcmd.Parameters.Add(new SqlParameter("@ID",SqlDbType.Int,4));
			STcmd.Parameters["@ID"].Value = STmyGrid.DataKeys[(int)e.Item.ItemIndex];
			STcmd.Connection.Open();
			try
			{
				STcmd.ExecuteNonQuery();
			}
			catch(SqlException)
			{

			}
//			STmysql = "select STProDe.ID,STProd.* from STProDe,STProd,STDep where STProDe.STDepID = STDep.STDepID and STProDe.STProdID = STProd.STProdID";
			STcmd.Connection.Close();			
//			BindGrid();
//			return ;
			Response.Redirect("STAddProduct.aspx");
		}

		public void STmyGrid_edit(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{

		}

		public void STmyGrid_update(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
	
	
		}

		private void ST_ok_Click(object sender, System.EventArgs e)
		{
			if(ST_Dep.SelectedItem.Value != "-1")
			{
				if(ST_Prod.SelectedItem.Value != "-1")
				{																						
					SqlCommand STcmd =new SqlCommand("insert_STProDe_1",STconn);
					STcmd.CommandType=CommandType.StoredProcedure;
					STcmd.Parameters.Add(new SqlParameter("@STProdID",SqlDbType.Int,4));
					STcmd.Parameters.Add(new SqlParameter("@STDepID",SqlDbType.Int,4));
					STcmd.Parameters.Add(new SqlParameter("@STProdName",SqlDbType.VarChar,50));
					STcmd.Parameters.Add(new SqlParameter("@STProdInfo",SqlDbType.VarChar,200));
					STcmd.Parameters.Add(new SqlParameter("@STProdPrice",SqlDbType.Decimal,9));
					STcmd.Parameters.Add(new SqlParameter("@STProdNum",SqlDbType.Decimal,9));
					STcmd.Parameters.Add(new SqlParameter("@STProdBZ",SqlDbType.Decimal,9));
					STcmd.Parameters.Add(new SqlParameter("@STProdSH",SqlDbType.DateTime,8));
					STcmd.Parameters["@STProdID"].Value = ST_Prod.SelectedItem.Value;
					STcmd.Parameters["@STDepID"].Value = ST_Dep.SelectedItem.Value;
					STcmd.Parameters["@STProdName"].Value = ST_Prod.SelectedItem.Text;
					STcmd.Parameters["@STProdInfo"].Value = ST_Prod.SelectedItem.Text;
					STcmd.Parameters["@STProdPrice"].Value = STDepNum.Text;
					STcmd.Parameters["@STProdNum"].Value = STDepNum.Text;
					STcmd.Parameters["@STProdBZ"].Value = STProdBZ.Text;
					STcmd.Parameters["@STProdSH"].Value = STProdSH.Text;
					STcmd.Connection.Open();
				try
					{
						STcmd.ExecuteNonQuery();
						ST_Warn.Text="添加失败";
						ST_Warn.Style["color"]="red";
						Response.Redirect("STAddProduct.aspx");
					}
					catch(SqlException)
					{
						ST_Warn.Text="添加失败";
						ST_Warn.Style["color"]="red";
					}
					STcmd.Connection.Close();
																														

				}
			}
		}
		
	}
}