AdminManage/EditGoods.aspx.cs

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

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

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;
//该源码下载自www.51aspx.com(５１aｓｐｘ．ｃｏｍ)

public partial class AdminManage_EditGoods : System.Web.UI.Page
{
    SqlOperate sqloperate = new SqlOperate();
    SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
    protected void Page_Load(object sender, EventArgs e)
    {
        sqlconn.Open();
        if (!IsPostBack)
        {
            string sqlstr = "select * from tb_GoodsType";
            sqloperate.ddlDataBind(ddlGType, sqlstr, "GoodsTypeName");
            string sqlstrshow = "select * from tb_GoodsInfo where GoodsID='"+Request["GoodsID"].ToString()+"'";
            SqlDataAdapter myapter = new SqlDataAdapter(sqlstrshow,sqlconn);
            DataSet mydset = new DataSet();
            myapter.Fill(mydset,"tb_GoodsInfo");
            DataRowView mydrview=mydset.Tables["tb_GoodsInfo"].DefaultView[0];
            txtGName.Text = Convert.ToString(mydrview.Row["GoodsName"]);
            txtGPrice.Text = Convert.ToString(mydrview.Row["GoodsPrice"]);
            txtGIntroduce.Text = Convert.ToString(mydrview.Row["GoodsIntroduce"]);
            imgPhoto.ImageUrl = Convert.ToString(mydrview.Row["GoodsPhoto"]);
            string sqlstrimg = "select Image from tb_Image";
            sqloperate.ddlDataBind(ddlPhoto,sqlstrimg,"Image");
            string strGID;
            strGID = Convert.ToString(mydrview.Row["GoodsTypeID"]);
            string sqlstrbind = "select * from tb_GoodsType where GoodsTypeID='" + strGID + "'";
            SqlDataAdapter myda = new SqlDataAdapter(sqlstrbind, sqlconn);
            DataSet myds = new DataSet();
            myda.Fill(myds, "tb_GoodsType");
            DataRowView mydrv = myds.Tables["tb_GoodsType"].DefaultView[0];
            ddlGType.SelectedValue = Convert.ToString(mydrv.Row["GoodsTypeName"]);
            Session["Gid"] = strGID;
            if (Convert.ToString(mydrview.Row["GoodsIsNew"]).Trim() == "是")
            {
                cbIsNew.Checked = true;
            }
            else
                cbIsNew.Checked = false;
        }
        sqlconn.Close();
    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        string sqltest = "select * from tb_GoodsInfo where GoodsName='" + this.txtGName.Text + "'";
        sqlconn.Open();
        SqlCommand sqlcom = new SqlCommand(sqltest, sqlconn);
        SqlDataReader read = sqlcom.ExecuteReader();
        read.Read();