addcustomer.aspx.cs

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

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
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 SellManageJane
{
	/// <summary>
	/// Addcustomer 的摘要说明。
	/// </summary>
	public class Addcustomer : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button Button5;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.TextBox fm_remark;
		protected System.Web.UI.WebControls.TextBox fm_department;
		protected System.Web.UI.WebControls.TextBox fm_address;
		protected System.Web.UI.WebControls.TextBox fm_telephone;
		protected System.Web.UI.WebControls.TextBox fm_city;
		protected System.Web.UI.WebControls.TextBox fm_name;
		protected System.Web.UI.WebControls.TextBox fm_customer_id;
		protected System.Web.UI.WebControls.Button Button6;
		protected System.Web.UI.HtmlControls.HtmlInputText DatePicker1;
		protected System.Web.UI.HtmlControls.HtmlInputButton Reset1;
		protected System.Web.UI.WebControls.HyperLink HyperLink1;
		protected System.Web.UI.WebControls.TextBox TxtCustomerID;
		protected System.Web.UI.WebControls.TextBox TxtCustomerName;
		protected System.Web.UI.WebControls.TextBox TxtRemark;
		protected System.Web.UI.WebControls.TextBox TxtCity;
		protected System.Web.UI.WebControls.TextBox TxtPhone;
		protected System.Web.UI.WebControls.TextBox TxtDepartment;
		protected System.Web.UI.WebControls.TextBox TxtAddress;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.HtmlControls.HtmlForm Form1;
		SqlConnection conn;
		SqlDataAdapter ada;
		SqlCommand cmd;
		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.Button6.Click += new System.EventHandler(this.Button6_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Button6_Click(object sender, System.EventArgs e)
		{
			try
			{
				cmd = new SqlCommand("addCustomerInfo",conn);
				cmd.CommandType = CommandType.StoredProcedure;

				cmd.Parameters.Add("@customerId",SqlDbType.VarChar,30);
				cmd.Parameters["@customerId"].Value=TxtCustomerID.Text.Trim().ToString();

				cmd.Parameters.Add("@customerName",SqlDbType.VarChar,50);
				cmd.Parameters["@customerName"].Value=TxtCustomerName.Text.Trim().ToString();

				cmd.Parameters.Add("@visistedTime",SqlDbType.DateTime,9);
				cmd.Parameters["@visistedTime"].Value=DatePicker1.Value.ToString();

				cmd.Parameters.Add("@city",SqlDbType.VarChar,20);
				cmd.Parameters["@city"].Value=TxtCity.Text.ToString();

				cmd.Parameters.Add("@telephone",SqlDbType.VarChar,20);
				cmd.Parameters["@telephone"].Value=TxtPhone.Text.ToString();

				cmd.Parameters.Add("@address",SqlDbType.VarChar,255);
				cmd.Parameters["@address"].Value=TxtAddress.Text.ToString();

				cmd.Parameters.Add("@department",SqlDbType.VarChar,255);
				cmd.Parameters["@department"].Value=TxtDepartment.Text.ToString();

				cmd.Parameters.Add("@remark",SqlDbType.VarChar,255);
				cmd.Parameters["@remark"].Value=TxtRemark.Text.ToString();

				conn.Open();

				SqlCommand Selcmd= new SqlCommand("select customerId,customerName from Customer where customerId='"+ TxtCustomerID.Text.ToString() +"' and customerName='"+ TxtCustomerName.Text.ToString() +"'",conn);
				ada = new SqlDataAdapter();
				ada.SelectCommand=Selcmd;
				DataSet ds = new DataSet();
				ada.Fill(ds,"Customer");
				if (ds.Tables["Customer"].Rows.Count!=0)
				{
					Page.RegisterStartupScript("msg ","<script>alert(\"添加客户信息失败！！！\")</script>");
				}
				else
				{
					cmd.ExecuteNonQuery();
					Page.RegisterStartupScript("msg","<script>alert(\"添加客户信息成功！！！\");location.href='Editcustomer.aspx'</script>");
					Response.Redirect("Editcustomer.aspx");
					conn.Close();
				}
			}
			catch(Exception ex)
			{
				Response.Write(ex.Message);
			}
		}
	}
}