commodity_add.aspx.cs

该商品销售管理系统是一个基于WEB的适应于小型企业的管理系统！可以实现商品基本信息的查询。添加

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Text;
using LoginCheckClass;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)    //验证当前页面是否已经过登陆操作
    {
        LoginCheck a = new LoginCheck();
        a.check();

    }
    
    protected void CompanyID_SelectedIndexChanged(object sender, EventArgs e)
    {

    }

    protected void btnAdd_Click(object sender, EventArgs e) //定义btnadd添加按钮得click事件
    {
        try
        {
            using (SqlConnection connection = new SqlConnection(_connectString))    //连接数据库
            {
                connection.Open();
                using (SqlCommand command = new SqlCommand())
                {
                    command.Connection = connection;
                    command.CommandType = CommandType.Text;
                    command.Parameters.Add("@CommodityName", SqlDbType.VarChar, 100).Value = CommodityName.Text;    //读取textbox中得数据
                    command.Parameters.Add("@ShortName", SqlDbType.VarChar, 50).Value = ShortName.Text;
                    command.Parameters.Add("@ProducePlace", SqlDbType.VarChar, 100).Value = ProducePlace.Text;
                    command.Parameters.Add("@Unit", SqlDbType.VarChar, 20).Value = Unit.Text;
                    command.Parameters.Add("@Specs", SqlDbType.VarChar, 50).Value = Specs.Text;
                    command.Parameters.Add("@PassNumber", SqlDbType.VarChar, 50).Value = PassNumber.Text;
                    command.Parameters.Add("@PassList", SqlDbType.VarChar, 50).Value = PassList.Text;
                    command.Parameters.Add("@CompanyID", SqlDbType.Int).Value = int.Parse(CompanyID.SelectedValue);
                    command.Parameters.Add("@Remark", SqlDbType.VarChar, 500).Value = Remark.Text;
                    command.Parameters.Add("@UserName", SqlDbType.VarChar, 50).Value = Session["UserName"];
                    command.Parameters.Add("AddTime", SqlDbType.VarChar, 50).Value = DateTime.Now;
                    //将从textbox中读取得数据插入数据库commdoity表中
                    command.CommandText = "Insert into tb_Commodity(CommodityName,ShortName,ProducePlace,Unit,Specs,PassNumber,PassList,CompanyID,Remark,UserName,AddTime) Values(@CommodityName,@ShortName,@ProducePlace,@Unit,@Specs,@PassNumber,@PassList,@CompanyID,@Remark,@UserName,@AddTime)";
                    command.ExecuteNonQuery();
                    Response.Write(@"<script>alert('添加成功');</script>");
                    CommodityName.Text = "";  //自动清空textbox中得信息
                    ShortName.Text="";
                    ProducePlace.Text="";
                    Unit.Text="";
                    Specs.Text="";
                    PassNumber.Text="";
                    PassList.Text="";
                    Remark.Text = "";


                }
            }
        }
        catch(Exception ex)
        {
            Response.Write(@"<script>alert('系统错误');</script>");
        }
    }
    private static readonly string _connectString = System.Configuration.ConfigurationManager.ConnectionStrings["db_sellConnectionString"].ConnectionString;
    protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {

    }
    //protected void btnCancel_Click(object sender, EventArgs e)
    //{
    //    CommodityName.Text = "";
    //    ShortName.Text = "";
    //    ProducePlace.Text = "";
    //    Unit.Text = "";
    //    Specs.Text = "";
    //    PassNumber.Text = "";
    //    PassList.Text = "";
    //    Remark.Text = "";





    //}
}