products/products_Add.aspx.cs

（完整代码） 1KB 

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

public partial class products_Add : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
        
        }
    }
    protected void btnSave_Click(object sender, EventArgs e)
    {
        
        StringBuilder strSql = new StringBuilder();
         strSql.Append(@"insert into Products ( pname,stand,pack,units,iprice,oprice,memo ) ");
        strSql.Append(@" values (@pname,@stand,@pack,@units,@iprice,@oprice,@memo)");

        //设置参数
        SqlParameter[] parameters = new SqlParameter[] {
            new SqlParameter("@pname", SqlDbType.VarChar,50),
            new SqlParameter("@stand", SqlDbType.VarChar,50),
            new SqlParameter("@pack", SqlDbType.VarChar,50),
            new SqlParameter("@units", SqlDbType.VarChar,20),
            new SqlParameter("@iprice", SqlDbType.Decimal,9),
            new SqlParameter("@oprice", SqlDbType.Decimal,9),
            new SqlParameter("@memo", SqlDbType.VarChar,500)        };

        parameters[0].Value =txt_pname.Text;
        parameters[1].Value =txt_stand.Text;
        parameters[2].Value =txt_pack.Text;
        parameters[3].Value =ddlunits.SelectedValue;
        parameters[4].Value =decimal.Parse (txt_iprice.Text);
        parameters[5].Value =decimal.Parse (txt_oprice.Text);
        parameters[6].Value =txt_memo.Text;

        SqlHelper.ExecuteNonQuery(strSql.ToString(), CommandType.Text, parameters);
        MessageBox.ShowAndRedirect(this, "保存成功！", "products_Add.aspx");

    }
}

24 小时内免费解锁 3 个项目，之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用，每次 10 算力，解读结果公开显示在下面。

还没有人解读过这个文件。