Admin/AddFoodInfo.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

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;

public partial class Admin_AddFoodInfo : System.Web.UI.Page
{
    SqlHelper data = new SqlHelper();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            ddlGType.DataSource = data.GetDataReader("select * from GoodsBigType");
            ddlGType.DataTextField = "GoodsTypeName";
            ddlGType.DataValueField = "GoodsTypeID";
            ddlGType.DataBind();
            DropDownList1.DataSource = data.GetDataReader("select * from GoodsSamllType where BigId='" + ddlGType.SelectedValue + "'");
            DropDownList1.DataTextField = "Name";
            DropDownList1.DataValueField = "id";
            DropDownList1.DataBind();
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string res;
        upload up = new upload();
        res = up.Up(file1, "../uploads/");
        this.Label1.Visible = true;
        this.Label1.Text = up.Resup[Convert.ToInt32(res)];
        this.pic.Text = up.s;
        Image1.ImageUrl = "../uploads/" + pic.Text;
    }
    protected void Button1_Click1(object sender, EventArgs e)
    {
        string sql = "insert into  GoodsInfo(GoodsTypeName,GoodsTypeID,GoodsSmallTypeId,GoodsSmallTypeName,GoodsName,GoodsIntroduce,GoodsPrice,GoodsPhoto,GoodsIsTeJia,GoodsIsTuiJian,GoodsZheKou,GoodsTPrice)values('" + ddlGType.SelectedItem.Text + "','" + ddlGType.SelectedValue + "','" + DropDownList1.SelectedValue + "','" + DropDownList1.SelectedItem.Text + "','" + txtGName.Text + "','" + txtGIntroduce.Text + "','0','" + pic.Text + "','" + DropDownList2.SelectedValue + "','" + DropDownList3.SelectedValue + "','100','0')";
        data.RunSql(sql);
        Alert.AlertAndRedirect("添加成功","GoodsInfoManger.aspx");

    }
    protected void ddlGType_SelectedIndexChanged(object sender, EventArgs e)
    {
        DropDownList1.DataSource = data.GetDataReader("select * from GoodsSamllType where BigId='"+ddlGType.SelectedValue+"'");
        DropDownList1.DataTextField = "Name";
        DropDownList1.DataValueField = "id";
        DropDownList1.DataBind();

    }
}