EditFoods.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

using MyWeb.DBUtility;
using MyWeb.WebUtility;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;

namespace MyWeb
{
    public partial class EditFoods : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                DBHelper db = new DBHelper();
                string sql = "";
                //DataSet ds = db.Query(sql);
                //for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                //{
                //    DropDownList1.Items.Add(new ListItem(ds.Tables[0].Rows[i]["className"].ToString(), ds.Tables[0].Rows[i]["id"].ToString()));
                //}
                //DropDownList2.Items.Add(new ListItem("未选购", "0"));
                //DropDownList2.Items.Add(new ListItem("整理中", "1"));
                //DropDownList2.Items.Add(new ListItem("已选购", "2"));
                sql = "select * from Goods_Tbl a inner join Class_Tbl b on a.classID=b.id where a.del=0 and b.del=0 and a.id='"+Request["id"].ToString()+"'";
                DataSet ds = db.Query(sql);
                if(ds.Tables[0].Rows.Count>0){
                    TextBox1.Text = ds.Tables[0].Rows[0]["FoodsName"].ToString();
                    //TextBox2.Text = ds.Tables[0].Rows[0]["ShopName"].ToString();
                    TextBox3.Text = ds.Tables[0].Rows[0]["Price"].ToString();
                    TextBox4.Text = ds.Tables[0].Rows[0]["stock"].ToString();
                    TextBox5.Text = ds.Tables[0].Rows[0]["note"].ToString();
                    DropDownList1.Items.Add(new ListItem(ds.Tables[0].Rows[0]["className"].ToString(), ds.Tables[0].Rows[0]["id"].ToString()));

                }
                sql = "select * from Class_Tbl where del=0 and id<>'"+ds.Tables[0].Rows[0]["classID"]+"'";
                ds = db.Query(sql);
                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    DropDownList1.Items.Add(new ListItem(ds.Tables[0].Rows[i]["className"].ToString(), ds.Tables[0].Rows[i]["id"].ToString()));
                }
            }
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            DBHelper db = new DBHelper();
            //声明提示类
            WebHelper wb = new WebHelper();
            //非空判断
            if (TextBox1.Text == "")
            {
                wb.Alert("商品编号不能为空");
            }
            //else if (TextBox2.Text == "")
            //{
            //    wb.Alert("所属人不能为空");