sell_return.aspx.cs

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

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

public partial class 销售管理_Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //对页面进行Session验证，防止非法用户直接通过URL进行登录 
        LoginCheck a = new LoginCheck();
        a.check();

        
        if (!IsPostBack)
        {
            //通过Session获取用户名
            this.Label2.Text = Convert.ToString(Session["username"]);
            //注册onchange事件
            Pirce.Attributes["onchange"] = Number.Attributes["onchange"] =  "javascript:getPrice();";
            Payment.Attributes["onchange"] = FactPayment.Attributes["onchange"] = "javascript:getPrice1();";
            //实现客户名与数据库的绑定
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["db_sellConnectionString"].ConnectionString);
            SqlCommand cmd = new SqlCommand();
            con.Open();
            SqlDataAdapter sda = new SqlDataAdapter("select id,CompanyName from tb_Company where CompanyType='用户'", con);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            ClientName.DataSource = ds;
            ClientName.DataTextField = "CompanyName";
            ClientName.DataValueField = "id";
            ClientName.DataBind();
            con.Close();
        }
    }
    //实现商品名称与数据库的绑定
    protected void CommodityName_SelectedIndexChanged(object sender, EventArgs e)
    {
        try
        {
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["db_sellConnectionString"].ConnectionString);
            SqlCommand cmd = new SqlCommand();
            string id = CommodityName.SelectedValue;
            cmd.CommandText = "SELECT tb_Company.id,tb_Company.CompanyName FROM tb_Commodity INNER JOIN tb_Company ON tb_Commodity.CompanyID = tb_Company.id WHERE tb_Commodity.id =" + id;
            cmd.Connection = con;
            con.Open();
            //读取从数据库中查询处理的第一行第一列的值
            SqlDataReader reader = cmd.ExecuteReader();
            if (reader.Read())
            {
                CompanyID.Text = reader["CompanyName"].ToString();
                Session["CompanyID"] = reader["id"].ToString();
            }
            getNumber();    //调用getNumber()方法
        }
        catch (Exception ex1) 
        {
            Response.Write(@"<script>alert('系统错误')</script>");
        }
    }

    protected void CommodityName_DataBound(object sender, EventArgs e)
    {
        CommodityName_SelectedIndexChanged(sender, e);
    }

    //点击添加按钮，把页面中的内容添加至数据库db_Sell中的tb_Stock表
    protected void AddButton_Click(object sender, EventArgs e)
    {
        string _connectString = ConfigurationManager.ConnectionStrings["db_sellConnectionString"].ConnectionString;
        try
        {
            using (SqlConnection connection = new SqlConnection(_connectString))
            {
                connection.Open();  //打开连接

                using (SqlCommand command = connection.CreateCommand())
                {

                    command.CommandType = CommandType.Text;
                    //获取参数
                    command.Parameters.Add("@CommodityID", SqlDbType.Int).Value = int.Parse(CommodityName.Text);
                    command.Parameters.Add("@CompanyID", SqlDbType.Int).Value = Session["CompanyID"].ToString();
                    command.Parameters.Add("@Pirce", SqlDbType.Int).Value = Pirce.Text;
                    command.Parameters.Add("@Number", SqlDbType.Int).Value = Number.Text;
                    command.Parameters.Add("@SettlementType", SqlDbType.VarChar, 50).Value = SettlementType.Text;
                    command.Parameters.Add("@Payment", SqlDbType.Int).Value = Request["Payment"];
                    command.Parameters.Add("@FactPayment", SqlDbType.Int).Value = FactPayment.Text;
                    command.Parameters.Add("@NoPayment", SqlDbType.Int).Value =Request["NoPayment"];
                    command.Parameters.Add("@StockDate", SqlDbType.DateTime).Value = StockDate.Text;
                    command.Parameters.Add("@ManageMan", SqlDbType.VarChar, 50).Value = ManageMan.Text;
                    command.Parameters.Add("@UserName", SqlDbType.VarChar, 50).Value = Session["UserName"];
                    command.Parameters.Add("@AddTime", SqlDbType.DateTime).Value = DateTime.Now;
                    command.Parameters.Add("@ClientID", SqlDbType.Int).Value = ClientName.SelectedValue;
                    command.Parameters.Add("@Type", SqlDbType.VarChar, 50).Value = "销售退货";
                    //用SQL语句将所以参数添加至数据库
                    command.CommandText = "Insert into tb_Stock(CommodityID,CompanyID,Pirce,Number,SettlementType,Payment,FactPayment,NoPayment,StockDate,ManageMan,UserName,AddTime,ClientID,Type)Values(@CommodityID,@CompanyID,@Pirce,@Number,@SettlementType,@Payment,@FactPayment,@NoPayment,@StockDate,@ManageMan,@UserName,@AddTime,@ClientID,@Type)";
                    command.ExecuteNonQuery();
                    Response.Write(@"<script>alert('添加成功');</script>"); //提示添加成功
                    // 添加成功时清空各个TextBox内容
                    getNumber();
                    Pirce.Text = "";
                    Payment.Text = "";
                    FactPayment.Text = "";
                    NoPayment.Text = "";
                    ManageMan.Text = "";
                }
            }
        }
        //如果出现异常，提示系统错误
        catch (Exception ex)
        {
            Response.Write(@"<script>alert('系统错误');</script>");
        }
    }

    protected void ClientName_SelectedIndexChanged1(object sender, EventArgs e)
    {
        getNumber();    //在选择客户名称时，调用getNumber()方法
    }
    //getNumber()方法
    private void getNumber()
    {
        using (SqlConnection conn = new SqlConnection(_connectString))
        {
            conn.Open();
            using (SqlCommand command = new SqlCommand())
            {
                command.Connection = conn;

                //从数据库中查询所需要的商品销售总数量
                command.Parameters.Add("@type1", SqlDbType.VarChar, 50).Value = "销售信息";
                command.Parameters.Add("@id", SqlDbType.Int).Value = CommodityName.SelectedValue;
                command.CommandText = "select isnull(sum(Number),0) from tb_Stock where Type=@type1 and CommodityID=@id";
                int saleNumber = Convert.ToInt32(command.ExecuteScalar());//获取返回值的第一行第一列
                int num = saleNumber;//最大销售退货数量等于销售数量
                Number.Text = Convert.ToString(num);
                Session["number"] = num;
                Label3.Text = Convert.ToString(num);//Label3也获取了number，Label3是实现功能的中介控件，用来与添加的数量进行比较


            }
        }
    }
    private static readonly string _connectString = System.Configuration.ConfigurationManager.ConnectionStrings["db_sellConnectionString"].ConnectionString;
}