addproduct.aspx.cs

来自「前台首页：users/index.aspx 后台首页：login.aspx 」· CS 代码 · 共 74 行

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;

public partial class addproduct : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

        Random rnd = new Random();
        TextBox7.Text = rnd.Next(1000, 8000).ToString();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection sqlcon = new SqlConnection("Data source=localhost;uid=sa;pwd=;database=Ebusiness");
        SqlCommand objsqlcomm = new SqlCommand();
        objsqlcomm.Connection = sqlcon;
        objsqlcomm.CommandType = CommandType.StoredProcedure;
        objsqlcomm.CommandText = "insert_product";
        objsqlcomm.Parameters.Add("@num", SqlDbType.Int).Value = TextBox1.Text;
        objsqlcomm.Parameters.Add("@petname", SqlDbType.Char, 20).Value = TextBox2.Text;
        objsqlcomm.Parameters.Add("@petmoney", SqlDbType.Money).Value = TextBox3.Text;
        objsqlcomm.Parameters.Add("@petlocal", SqlDbType.Char,50).Value = TextBox4.Text;
        objsqlcomm.Parameters.Add("@aboutpet", SqlDbType.Char, 2000).Value = TextBox5.Text;
        objsqlcomm.Parameters.Add("@date", SqlDbType.DateTime).Value = DateTime.Now.ToString();
        objsqlcomm.Parameters.Add("@return_value", SqlDbType.Int);
        objsqlcomm.Parameters["@return_value"].Direction = ParameterDirection.ReturnValue;

        int i_ret = -100;
        try
        {
            sqlcon.Open();
            objsqlcomm.ExecuteNonQuery();
            i_ret = (int)objsqlcomm.Parameters["@return_value"].Value;
        }

        catch (Exception ex)
        {
            Label1.Text = ex.Message;
        }
        finally
        {
            sqlcon.Close();
            Label1.Text = "添加成功，点击此处进入产品管理";
        }
        clean();

    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        clean();

    }
    private void clean()
    {
        TextBox1.Text = "";
        TextBox2.Text = "";
        TextBox3.Text = "";
        TextBox4.Text = "";
        TextBox5.Text = "";
        TextBox6.Text = "";
    }
}