product.aspx.cs

易想商城系统

        #region 绑定商品分类
        /// <summary>
        /// 绑定商品分类
        /// </summary>
        private void bindddlProU_ID()
        {
            YXShop.BLL.Pro_Unit pu = new YXShop.BLL.Pro_Unit();
            try
            {
                if (pu.GetAll().Count > 0)
                {
                    this.ddlProU_ID.DataSource = pu.GetAll();
                    this.ddlProU_ID.DataTextField = "ProU_Name";
                    this.ddlProU_ID.DataValueField = "ProU_ID";
                    this.ddlProU_ID.DataBind();
                }
                else
                {
                    ListItem li = new ListItem();
                    li.Text = "暂无商品单位";
                    li.Value = "0";
                    this.ddlProU_ID.Items.Add(li);
                    this.ddlProU_ID.DataBind();
                }
            }
            catch
            {

            }
        }
        #endregion

        #region 地区
        protected string fillArea(int id)
        {
            YXShop.BLL.Provinces datab = new YXShop.BLL.Provinces();
            List<YXShop.Model.Provinces> data = datab.GetListByColumn("ID", id);
            if (data.Count > 0)
            {
                return data[0].Province_city.ToString();
            }
            return string.Empty;
        }
        #endregion

        #region 修改商品信息时，初始化绑定数据
        /// <summary>
        /// 修改商品信息时，初始化绑定数据
        /// </summary>
        private void updateBind()
        {
            if (!string.IsNullOrEmpty(Request["ID"]))
            {
                //try
                //{
                int Pro_ID = Int32.Parse(Request["ID"]);

                List<YXShop.Model.Product> mp = BLL.GetId(Pro_ID);
                if (mp.Count > 0)
                {
                    commandName = "修 改";
                    this.btnAdd.Text = "修 改";
                    //model = mp[0];
                    model = BLL.GetIdModel(Pro_ID);
                    if (model.Pro_Area != string.Empty && model.Pro_Area != null)
                    {
                        string[] ProArea = model.Pro_Area.Split(',');
                        this.tbAddress.Text = fillArea(Convert.ToInt32(ProArea[ProArea.Length - 1]));
                        this.ClassID.Value = ProArea[ProArea.Length - 1];
                    }


                    #region 商品扩展属性
                    if (!string.IsNullOrEmpty(model.Pro_CID) && !string.IsNullOrEmpty(model.Pro_PValues))
                    {
                        bindPro_PValues(model.Pro_CID, model.Pro_PValues);
                    }
                    #endregion
                    #region 商品分类
                    proClass_ID = model.Pro_CID;
                    #endregion
                    //区域
                    Province_ID = model.Pro_Area;
                    #region 商品品牌
                    bindBrand_ID(Convert.ToString(model.Pro_CID), Convert.ToString(model.Brand_ID));
                    #endregion
                    this.txtPro_Name.Text = model.Pro_Name;//商品名称
                    this.txtPro_MOdel.Text = model.Pro_MOdel;//商品型号
                    this.txtPro_NO.Text = model.Pro_NO;//商品编码
                    this.txtPro_KeyWord.Text = model.Pro_KeyWord;//商品关键字
                    this.txtPro_Description.Text = model.Pro_Description;//商品简介                
                    this.txtPro_MarketPrice.Text = Convert.ToString(model.Pro_MarketPrice);//商品市场价
                    this.ddlSaleType.SelectedValue = Convert.ToString(model.Pro_SaleType);//商品出售方式：1：只能使用现金购买；2：只能使用积分购买；3：现金或积分均可
                    saleType = Convert.ToString(model.Pro_SaleType);
                    this.txtPro_ShopPrice.Text = Convert.ToString(model.Pro_ShopPrice);//商品商城价
                    this.txtPro_IntegralPrice.Text = Convert.ToString(model.Pro_IntegralPrice);//商品积分价

                    #region 会员等级价格折扣列表

                    YXShop.BLL.MemberRand MRBLL = new YXShop.BLL.MemberRand();
                    List<YXShop.Model.MemberRand> MRList = MRBLL.GetAll();
                    if (MRList.Count > 0)
                    {
                        StringBuilder rankPriceListStr = new StringBuilder();
                        rankPriceListStr.Append("<table>");
                        string[] Pro_RatingDiscount = model.Pro_RatingDiscount.Split(',');
                        int k = 0;
                        foreach (YXShop.Model.MemberRand MR in MRList)
                        {
                            try
                            {
                                if (k > Pro_RatingDiscount.Length - 1)
                                {
                                    rankPriceListStr.Append("<tr><td align=\"right\">" + Convert.ToString(MR.Rank_name) + "价：</td><td  align=\"left\"><input type=\"text\" value=\"-1\" name=\"txtPro_RatingDiscount\" /></td></tr>");
                                    k += 1;
                                }
                                else
                                {
                                    rankPriceListStr.Append("<tr><td align=\"right\">" + Convert.ToString(MR.Rank_name) + "价：</td><td  align=\"left\"><input type=\"text\" value=\"" + Pro_RatingDiscount[k] + "\" name=\"txtPro_RatingDiscount\" /></td></tr>");
                                    k += 1;
                                }
                            }
                            catch
                            {
                                rankPriceListStr.Append("<tr><td align=\"right\">" + Convert.ToString(MR.Rank_name) + "价：</td><td  align=\"left\"><input type=\"text\" value=\"-1\" name=\"txtPro_RatingDiscount\" /></td></tr>");
                                k += 1;
                            }
                        }
                        rankPriceListStr.Append("</table>");
                        rankPriceList = rankPriceListStr.ToString();
                    }
                    else
                    {
                        rankPriceList = "您尚未添加会员等级";
                    }

                    #endregion

                    this.txtPro_VirtualCurrencies.Text = Convert.ToString(model.Pro_VirtualCurrencies);//商品的虚拟币售价，为0表示不支持虚拟币购买
                    this.txtPro_Integral.Text = Convert.ToString(model.Pro_Integral);//赠送积分
                    ViewState["proSmallImg"] = model.Pro_SmallImages;//商品缩略图
                    ViewState["ProDetailImg"] = model.Pro_MarkPic;//商品详细图                        
                    this.txtPro_Content.Value = model.Pro_Content;//商品详细介绍
                    this.txtPro_MetaKeywords.Text = model.Pro_MetaKeywords;//商品SEO关键字
                    this.txtPro_MetaDescription.Text = model.Pro_MetaDescription;//商品SEO描述信息
                    this.txtPro_MetaTitle.Text = model.Pro_MetaTitle;//商品SEO标题
                    this.txtPro_Weight.Text = Convert.ToString(model.Pro_Weight);//商品重量
                    this.ddlPro_WeightUnit.SelectedValue = Convert.ToString(model.Pro_WeightUnit);//商品重量单位：0：克；1：千克。

                    this.txtPro_Stock.Text = Convert.ToString(model.Pro_Stock);//商品库存
                    this.ddlProU_ID.SelectedValue = Convert.ToString(model.ProU_ID);//商品单位
                    this.txtPro_Alarm.Text = Convert.ToString(model.Pro_Alarm);//报警数量
                    this.txtPro_AuditCount.Text = Convert.ToString(model.Pro_AuditCount);//上架数量
                    this.ddlPro_Audit.SelectedValue = Convert.ToString(model.Pro_Audit);//商品上下架状态：1：上架；2：下架；3：回收站                                               
                    #region 商品状态：推荐商品|热卖商品|特价商品|活动专区|最新商品|首页显示
                    string[] state = model.Pro_State.Split('|');
                    for (int i = 0; i < state.Length; i++)
                    {
                        if (state[i] == "1")
                        {
                            this.cblPro_State.Items[i].Selected = true;
                        }
                    }
                    #endregion

                    #region 商品标识：团购|拍卖|批发
                    string[] Designation = model.Pro_Designation.Split('|');
                    for (int j = 0; j < Designation.Length; j++)
                    {
                        if (Designation[j] == "1")
                        {
                            this.cblPro_Designation.Items[j].Selected = true;
                        }
                    }
                    #endregion

                    #region 相关商品
                    if (!string.IsNullOrEmpty(model.Pro_RelatingProID))
                    {
                        bindPro_RelatingProID(model.Pro_RelatingProID);
                    }
                    #endregion

                    #region 相关文章

                    bindPro_RelatingArtID(model.Pro_RelatingArtID);

                    #endregion

                    this.txtPro_onClicks.Text = Convert.ToString(model.Pro_onClicks);//商品查看次数
                    this.rblPro_IsAllowComment.SelectedValue = Convert.ToString(model.Pro_IsAllowComment);//是否允许评论                        
                    this.txtPro_CostPrice.Text = Convert.ToString(model.Pro_CostPrice);//商品成本价
                    this.txtPro_AutoUp.Date = (DateTime)model.Pro_AutoUp;//商品自动上架时间
                    this.txtPro_AutoDown.Date = (DateTime)model.Pro_AutoDown;//商品自动下架时间
                    this.rblPro_IsAuto.SelectedValue = Convert.ToString(model.Pro_IsAuto);//商品是否自动上下架
                }
                else
                {
                    Response.Redirect("../Succeed/Error.aspx?Key=对不起,该商品不存在", true);
                }
                //}
                //catch(Exception ex)
                //{
                //    Response.Redirect("../Succeed/Error.aspx?Key="+ex.Message+"", true);
                //}
            }
        }
        #endregion

        #region 绑定商品相关的相关商品
        /// <summary>
        /// 绑定商品相关的相关商品
        /// </summary>
        /// <returns></returns>
        public void bindPro_RelatingProID(string ProID)
        {
            StringBuilder proList = new StringBuilder();
            proList.Append("<select name=\"selPro_RelatingProIDSelect\" size=\"14\" multiple=\"multiple\" style=\"width: 98%\">");
            try
            {
                YXShop.BLL.Product BLL = new YXShop.BLL.Product();
                DataSet ds = BLL.GetSearchKey(0, "Pro_ID,Pro_Name", "YXShop_Product", "Pro_ID in (" + ProID + ")", "Pro_ID desc");
                DataTable dt = ds.Tables[0];
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        proList.Append("<option value=\"" + ds.Tables[0].Rows[i]["Pro_ID"].ToString() + "\">" + ds.Tables[0].Rows[i]["Pro_Name"].ToString() + "</option>");
                    }
                    proList.Append("</select>");
                    Pro_RelatingProID = proList.ToString();
                }
                else
                {
                    Pro_RelatingProID = proList.ToString();
                }
            }
            catch (Exception ex)
            {
                proList.Append("<option value=\"0\">程序出错，详细信息：" + ex.ToString() + "</option>");
                proList.Append("</select>");
                Pro_RelatingProID = proList.ToString();
            }
        }
        #endregion

        #region 绑定商品的相关文章
        /// <summary>
        /// 绑定商品的相关文章
        /// </summary>
        /// <returns></returns>
        public void bindPro_RelatingArtID(string ArtID)
        {
            StringBuilder articleList = new StringBuilder();
            articleList.Append("<select name=\"selPro_RelatingArtIDSelect\" size=\"14\" multiple=\"multiple\" style=\"width: 98%\">");
            try
            {
                string keyWord = Request.QueryString["keyWord"];
                YXShop.BLL.YixiangArticle BLL = new YXShop.BLL.YixiangArticle();
                DataSet ds = BLL.searchArticle("", ArtID, 0);
                DataTable dt = ds.Tables[0];
                if (dt.Rows.Count > 0)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        articleList.Append("<option value=\"" + ds.Tables[0].Rows[i][0].ToString() + "\">" + ds.Tables[0].Rows[i][1].ToString() + "</option>");
                    }
                    articleList.Append("</select>");
                    Pro_RelatingArtID = articleList.ToString();
                }
                else
                {
                    articleList.Append("</select>");
                    Pro_RelatingArtID = articleList.ToString();
                }
            }
            catch
            {
                articleList.Append("</select>");
                Pro_RelatingArtID = articleList.ToString();
            }
        }
        #endregion

        #region 绑定商品品牌
        /// <summary>
        /// 绑定商品品牌
        /// </summary>
        /// <param name="cID">商品分类ID</param>
        /// <param name="bID">商品品牌ID</param>
        public void bindBrand_ID(string cID, string bID)
        {
            if (bID == "0")
            {
                pro_Brand_ID = "该商品无品牌";
            }
            else
            {
                StringBuilder retrunSb = new StringBuilder();
                try
                {
                    YXShop.BLL.Pro_Brand pb = new YXShop.BLL.Pro_Brand();
                    List<YXShop.Model.Pro_Brand> PBList = pb.GetModelByClssID(cID);
                    if (PBList.Count > 0)
                    {
                        retrunSb.Append("<select name=\"ddlBrand_ID\" id=\"ddlBrand_ID\">");
                        foreach (YXShop.Model.Pro_Brand mPb in PBList)
                        {
                            retrunSb.Append("<option value=\"" + mPb.Brand_ID + "\"");
                            if (Convert.ToString(mPb.Brand_ID) == bID)
                            {
                                retrunSb.Append(" selected=\"selected\" ");
                            }
                            retrunSb.Append(">" + mPb.Brand_Name + "</option>");
                        }
                        retrunSb.Append("</select>");
                        pro_Brand_ID = retrunSb.ToString();
                    }
                    else
                    {