?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 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();
        if (read.HasRows)
        {
            if (this.txtGName.Text.Trim() == read["GoodsName"].ToString().Trim())
            {
                Response.Write("<script language='javascript'>alert('該商品已經(jīng)存在');localtion='EditGoods.aspx'</script>");
                return;
            }
        }
        else
        {
            read.Close();
            goodsID();
            if (cbIsNew.Checked == true)
            {
                string sqlstr = "insert into tb_GoodsInfo"
                    + "(GoodsName,GoodsPrice,GoodsTypeID,GoodsIsNew,GoodsIntroduce,GoodsPhoto) "
                    + "values('" + txtGName.Text.Trim() + "','" + txtGPrice.Text.Trim()
                    + "','" + Session["Gid"].ToString() + "','是','" + txtGIntroduce.Text.Trim() + "','" + ddlPhoto.SelectedValue + "')";
                sqloperate.DataCom(sqlstr);
            }
            else
            {
                string sqlstr = "insert into tb_GoodsInfo"
                    + "(GoodsName,GoodsPrice,GoodsTypeID,GoodsIsNew,GoodsIntroduce,GoodsPhoto) "
                    + "values('" + txtGName.Text.Trim() + "','" + txtGPrice.Text.Trim()
                    + "','" + Session["Gid"].ToString() + "','否','" + txtGIntroduce.Text.Trim() + "','" + ddlPhoto.SelectedValue + "')";
                sqloperate.DataCom(sqlstr);
            }
        }
    }
    protected void btnEdit_Click(object sender, EventArgs e)
    {
        goodsID();
        if (cbIsNew.Checked == true)
        {
            string sqlstr = "update tb_GoodsInfo set GoodsName='"+txtGName.Text.Trim()
                +"',GoodsPrice='"+txtGPrice.Text.Trim()+"',GoodsTypeID='"
                +Session["Gid"].ToString()+"',GoodsIsNew='是',GoodsIntroduce='"
                + txtGIntroduce.Text.Trim() + "',GoodsPhoto='" + ddlPhoto.SelectedValue 
                + "' where GoodsID='" + Request["GoodsID"].ToString() + "'";
            sqloperate.DataCom(sqlstr);
        }
        else
        {
            string sqlstr = "update tb_GoodsInfo set GoodsName='" + txtGName.Text.Trim()
                + "',GoodsPrice='" + txtGPrice.Text.Trim() + "',GoodsTypeID='"
                + Session["Gid"].ToString() + "',GoodsIsNew='否',GoodsIntroduce='"
                + txtGIntroduce.Text.Trim() + "',GoodsPhoto='" + ddlPhoto.SelectedValue 
                + "'where GoodsID='" + Request["GoodsID"].ToString() + "'";
            sqloperate.DataCom(sqlstr);
        }
    }
    protected void btnBack_Click(object sender, EventArgs e)
    {
        Response.Redirect("GoodsManage.aspx");
    }
    protected void ddlPhoto_SelectedIndexChanged(object sender, EventArgs e)
    {
        imgPhoto.ImageUrl = ddlPhoto.SelectedValue;
    }
    public void goodsID()
    {
        string sqlstrbind = "select * from tb_GoodsType where GoodsTypeName='" + ddlGType.SelectedValue + "'";
        SqlDataAdapter myda = new SqlDataAdapter(sqlstrbind, sqlconn);
        DataSet myds = new DataSet();
        myda.Fill(myds, "tb_GoodsType");
        DataRowView mydrv = myds.Tables["tb_GoodsType"].DefaultView[0];
        Session["Gid"] = Convert.ToString(mydrv["GoodsTypeID"]);
    }
}