addgoods.aspx.cs

通过对现在流行的各种销售管理软件的分析

using System;
using System.Collections;
using System.ComponentModel;
using System.Configuration;
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;

namespace SellManageJane
{
	/// <summary>
	/// Addgoods 的摘要说明。
	/// </summary>
	public class Addgoods : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button Button7;
		protected System.Web.UI.WebControls.Button Button6;
		protected System.Web.UI.WebControls.Button Button5;
		protected System.Web.UI.WebControls.TextBox fm_remark;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.TextBox fm_images;
		protected System.Web.UI.WebControls.TextBox fm_remain;
		protected System.Web.UI.WebControls.TextBox fm_price;
		protected System.Web.UI.WebControls.TextBox fm_goods_unit;
		protected System.Web.UI.WebControls.TextBox fm_name;
		protected System.Web.UI.WebControls.TextBox fm_goods_id;
		protected System.Web.UI.WebControls.Button Button4;
		protected System.Web.UI.WebControls.TextBox goodsId;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox goodsName;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.TextBox goodsUnit;
		protected System.Web.UI.WebControls.TextBox price;
		protected System.Web.UI.WebControls.TextBox remain;
		protected System.Web.UI.WebControls.TextBox remark;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
		protected System.Web.UI.HtmlControls.HtmlForm Form1;
		protected System.Web.UI.HtmlControls.HtmlInputText DatePicker1;
		protected System.Web.UI.HtmlControls.HtmlInputFile File1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator5;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.HtmlControls.HtmlInputButton Reset1;

		SqlConnection conn;
		SqlDataAdapter ada;
		SqlCommand cmd;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator1;
		protected System.Web.UI.WebControls.RangeValidator RangeValidator2;
		DataSet ds;

		private void Page_Load(object sender, System.EventArgs e)
		{
			conn = new SqlConnection(ConfigurationSettings.AppSettings["connStr"].ToString()); //初始化数据库的连接；
			cmd = new SqlCommand(); //建立命令集对象；
		}

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

		}
		#endregion

		private void Button4_Click(object sender, System.EventArgs e)
		{
			try
			{
				cmd = new SqlCommand("addGoodsInfo",conn);  //执行名为addGoodsInfo的存储过程
				cmd.CommandType = CommandType.StoredProcedure;
            
				cmd.Parameters.Add("@goodsId",SqlDbType.VarChar,20);  //传第@goodsId参数
				cmd.Parameters["@goodsId"].Value = goodsId.Text.Trim().ToString(); //获取@goodsName参数的值;

				cmd.Parameters.Add("@goodsName",SqlDbType.VarChar,50); //传第 @goodsName参数
				cmd.Parameters["@goodsName"].Value = goodsName.Text.Trim().ToString();//获取@goodsName参数的值

				cmd.Parameters.Add("@goodsUnit",SqlDbType.VarChar,25); //传第@goodsUnit参数
				cmd.Parameters["@goodsUnit"].Value = goodsUnit.Text.Trim().ToString(); //获取@oodsUnit参数的值

				cmd.Parameters.Add("@price",SqlDbType.Float);//传第@price参数
				cmd.Parameters["@price"].Value = price.Text.Trim().ToString(); //获取@price参数的值;
			

				cmd.Parameters.Add("@remain",SqlDbType.Float); //传第@remain参数 
				cmd.Parameters["@remain"].Value = remain.Text.Trim().ToString();//获取@remain参数

				cmd.Parameters.Add("@images",SqlDbType.VarChar,255); //传第@images参数
				cmd.Parameters["@images"].Value = File1.Value; //获取@images参数的值

				cmd.Parameters.Add("@time",SqlDbType.DateTime,9); //传第@time参数的值
				cmd.Parameters["@time"].Value = DatePicker1.Value.ToString();//获取@time参数的值

				cmd.Parameters.Add("@remark",SqlDbType.VarChar,250);  //传第@remark参数的值
				cmd.Parameters["@remark"].Value = remark.Text.Trim().ToString();//获取@remark参数的值       

				conn.Open();

				SqlCommand Selcmd= new SqlCommand("select goodsId from Goods where goodsId='"+ goodsId.Text.ToString() +"' ",conn);
				ada = new SqlDataAdapter();
				ada.SelectCommand=Selcmd;
				ds = new DataSet();
				ada.Fill(ds,"Goods");
				if (ds.Tables["Goods"].Rows.Count!=0)
				{
					Page.RegisterStartupScript("msg ","<script>alert(\"添加信息失败！！！\")</script>");
					Server.Transfer("Editgoods.aspx");
				}
				else
				{
					cmd.ExecuteNonQuery();
					Page.RegisterStartupScript("msg","<script>alert(\"添加信息成功！！！\");</script>");
					Response.Redirect("editgoods.aspx");
					conn.Close();
				}
			}
			catch(Exception ex)
			{
				Response.Write(ex.Message);
			}
		
		}

		private void price_TextChanged(object sender, System.EventArgs e)
		{
			RegisterStartupScript("msg","<script>alter('只能输入数字！！！');</script>");
		}
	}
}