productadd.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.OleDb;
using System.Configuration;
using System.IO;

namespace SCard.admin
{
	/// <summary>
	/// productAdd 的摘要说明。
	/// </summary>
	public class productAdd : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox txtName;
		protected System.Web.UI.WebControls.TextBox txtCPrice;
		protected System.Web.UI.WebControls.TextBox txtFPrice;
		protected System.Web.UI.WebControls.TextBox txtNPrice;
		protected System.Web.UI.WebControls.TextBox txtBewrite;
		protected System.Web.UI.WebControls.TextBox txtUseMode;
		protected System.Web.UI.WebControls.TextBox txtValidity;
		protected System.Web.UI.HtmlControls.HtmlInputFile uploadFile;
        protected System.Web.UI.WebControls.DropDownList ddlCategory;
		protected System.Web.UI.WebControls.Button btnAdd;
        protected System.Web.UI.WebControls.Button btnReset;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
            //权限检查
            if( Session["adminName"]==null || Session["adminName"].ToString() == String.Empty )
            {
                Response.Write("<font color=#ff0000 style='FONT-SIZE: 12px'>对不起,您没足够权限访问此页!!</font><br>");
                Response.Write("<a href=index.aspx target=_top style='FONT-SIZE: 12px'>重新登陆</a><br>");
                Response.End();
                return;
            }

			if( !IsPostBack )
			{
                getCategory();//绑定类别下拉列表
			}
		}

        private void getCategory()//绑定类别下拉列表
        {
            DBConn myDB = new DBConn();
			string sql="select * from Category";
			ddlCategory.DataSource  = myDB.getDataReader(sql);
			ddlCategory.DataTextField = "CName";
			ddlCategory.DataValueField = "CID";
			ddlCategory.DataBind();
            myDB.Close();
        }

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

        }
		#endregion

		private void btnAdd_Click(object sender, System.EventArgs e)
		{
			string strName = txtName.Text.Trim();
			string strCID = ddlCategory.SelectedValue;
			string strCPrice = txtCPrice.Text.Trim();
			string strFPrice = txtFPrice.Text.Trim();
			string strNPrice = txtNPrice.Text.Trim();
			string strBewrite = txtBewrite.Text.Trim();
			string strUseMode = txtUseMode.Text.Trim();
			string strValidity = txtValidity.Text.Trim();

			if( strName == String.Empty || strCPrice == String.Empty || strCID == String.Empty ||
                strFPrice == String.Empty || strNPrice == String.Empty)
			{
				Response.Write("<script>");
				Response.Write("alert('必选项不能为空!!!');");
				Response.Write("</script>");
				return;
			}
			else if( strName.Length > 35 )
			{
				Response.Write("<script>");
				Response.Write("alert('输入商品名称太长了!!!');");
				Response.Write("</script>");
				return;
			}

            try
            {
                double.Parse(strCPrice);
            }
            catch
            {
                Response.Write("<script>");
                Response.Write("alert('请检查 成本价 的格式!!!');");
                Response.Write("</script>");
                return;
            }
            try
            {
                double.Parse(strFPrice);
            }
            catch
            {
                Response.Write("<script>");
                Response.Write("alert('请检查 原价 的格式!!!');");
                Response.Write("</script>");
                return;
            }
            try
            {
                double.Parse(strNPrice);
            }
            catch
            {
                Response.Write("<script>");
                Response.Write("alert('请检查 现价 的格式!!!');");
                Response.Write("</script>");
                return;
            }

            if(uploadFile.PostedFile.FileName.Trim() != String.Empty && (Path.GetExtension(uploadFile.PostedFile.FileName)!=".gif" && Path.GetExtension(uploadFile.PostedFile.FileName)!=".jpg"))
            {
                Response.Write("<Script>alert('上传的图片格式必须为.gif或.jpg!!')</Script>");
                return;
            }

			strBewrite  = CleanString.htmlInputText( strBewrite );
			strUseMode  = CleanString.htmlInputText( strUseMode );
			strValidity = CleanString.htmlInputText( strValidity );


			string sql="insert into Products(PName,CID,PCPrice,PFPrice,PNPrice,PBewrite,PUseMode,PValidity) values('" + 
					strName + "'," + strCID +  "," + strCPrice + "," + strFPrice + "," + 
					strNPrice + ",'" + strBewrite + "','" + strUseMode + "','" + strValidity + "')";

			DBConn myDB = new DBConn();
			myDB.ExecuteNonQuery(sql);
			myDB.Close();

			if ( uploadFile.PostedFile.FileName.Trim() != String.Empty )
			{
				//----------- update图片
				Stream imagedatastream;
				string DBPath = ConfigurationSettings.AppSettings["DataBasePath"];
				string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + Server.MapPath(DBPath);
				OleDbConnection myConn=new OleDbConnection(connStr);
				imagedatastream = Request.Files["uploadFile"].InputStream ;
				int imagedatalen = Request.Files["uploadFile"].ContentLength ;
				string imagedatatype = Request.Files["uploadFile"].ContentType ;

				byte[] image = new byte[imagedatalen];
				imagedatastream.Read(image,0,imagedatalen);

				String Psql="update Products set PPicture=@imgdata where PID=(select MAX(PID) from products)";

				OleDbCommand Pcommand=new OleDbCommand(Psql,myConn);

				OleDbParameter imgdata = new OleDbParameter("@imgdata",SqlDbType.Image);
				imgdata.Value=image;
				Pcommand.Parameters.Add (imgdata);

				myConn.Open();
				Pcommand.ExecuteReader();
				myConn.Close();
				//-----------
			}

            //==
            txtName.Text = "";
            txtCPrice.Text = "";
            txtFPrice.Text = "";
            txtNPrice.Text = "";
            txtBewrite.Text = "";
            txtUseMode.Text = "";
            txtValidity.Text = "";
            ddlCategory.SelectedIndex = 0;
            //==

            Response.Write("<script>");
            Response.Write("alert('成功添加!!!');");
            Response.Write("</script>");
			
		}

        private void btnReset_Click(object sender, System.EventArgs e)
        {
            txtName.Text = "";
		    txtCPrice.Text = "";
		    txtFPrice.Text = "";
		    txtNPrice.Text = "";
		    txtBewrite.Text = "";
		    txtUseMode.Text = "";
		    txtValidity.Text = "";
		    ddlCategory.SelectedIndex = 0;
        }
	}
}