public void Add(SecondhandProductModel model)
        {
            DbCommand Command = dbw.GetStoredProcCommand("UP_mwSecondhandProduct_ADD");

            dbw.AddInParameter(Command, "@SeProductID", DbType.Int32, model.SecondhandProductID);
            dbw.AddInParameter(Command, "@SeProductName", DbType.String, model.SecondhandProductName);
            dbw.AddInParameter(Command, "@SmallImage", DbType.String, model.SmallImage);
            dbw.AddInParameter(Command, "@MediumImage", DbType.String, model.MediumImage);
            dbw.AddInParameter(Command, "@CateID", DbType.Int32, model.CateID);
            dbw.AddInParameter(Command, "@CatePath", DbType.String, model.CatePath);
            dbw.AddInParameter(Command, "@Price", DbType.Decimal, model.Price);
            dbw.AddInParameter(Command, "@Stock", DbType.Int32, model.Stock);
            dbw.AddInParameter(Command, "@usagecondition", DbType.Int32, model.UsageCondition);
            dbw.AddInParameter(Command, "@Brief", DbType.String, model.Brief);
            dbw.AddInParameter(Command, "@UserID", DbType.String, model.UserID);
            dbw.AddInParameter(Command, "@Status", DbType.Int32, model.Status);
            dbw.AddInParameter(Command, "@SortValue", DbType.Int32, model.SortValue);
            dbw.AddInParameter(Command, "@truename", DbType.String, model.TrueName);
            dbw.AddInParameter(Command, "@phone", DbType.String, model.Phone);
            dbw.AddInParameter(Command, "@cellphone", DbType.String, model.CellPhone);
            dbw.AddInParameter(Command, "@postcode", DbType.String, model.PostCode);
            dbw.AddInParameter(Command, "@region", DbType.String, model.Region);
            dbw.AddInParameter(Command, "@address", DbType.String, model.Address);
            dbw.AddInParameter(Command, "@InsertTime", DbType.DateTime, model.InsertTime);
            dbw.AddInParameter(Command, "@UpdateTime", DbType.DateTime, model.UpdateTime);

            dbw.ExecuteNonQuery(Command);
        }
 public void Update(SecondhandProductModel model)
 {
     dal.Update(model);
 }
 public void Add(SecondhandProductModel model)
 {
     dal.Add(model);
 }
        protected void Button_Add_Click(object sender, EventArgs e)
        {
            string ErrorMessage = String.Empty;
            if (String.IsNullOrEmpty(TextBox_ProductName.Text)) { ErrorMessage += "产品名称不能为空\\n"; }
            if (String.IsNullOrEmpty(FileUpload_ProductImage.FileName)) { ErrorMessage += "产品图片不能为空\\n"; }
            if (String.IsNullOrEmpty(TextBox_Price.Text) || !PageValidate.IsDecimal(TextBox_Price.Text)) { ErrorMessage += "请输入正确的产品价格\\n"; }
            if (String.IsNullOrEmpty(TextBox_Count.Text) || !PageValidate.IsNumber(TextBox_Count.Text)) { ErrorMessage += "请输入正确的产品数量\\n"; }
            if (String.IsNullOrEmpty(TextBox_Brief.Text)) { ErrorMessage += "请输入产品简介\\n"; }
            if (String.IsNullOrEmpty(TextBox_TrueName.Text)) { ErrorMessage += "请输入您的姓名\\n"; }
            if (String.IsNullOrEmpty(TextBox_Phone.Text) && String.IsNullOrEmpty(TextBox_CellPhone.Text)) { ErrorMessage += "请输入您的电话号码或者手机号码\\n"; }
            else { /* validate */}
            if (String.IsNullOrEmpty(TextBox_PostCode.Text)/* validate */) { ErrorMessage += "请输入正确的邮政编码\\n"; }
            if (String.IsNullOrEmpty(TextBox_Address.Text)) { ErrorMessage += "请输入您的地址\\n"; }

            RegionInfo regionInfo = ucRegion.GetSelectedRegionInfo();
            if (String.IsNullOrEmpty(regionInfo.Province) || String.IsNullOrEmpty(regionInfo.City))
            {
                ErrorMessage += "所在地选择不完整\\n";
            }

            if (!String.IsNullOrEmpty(ErrorMessage))
            {
                MessageBox.Show(this, ErrorMessage);
                return;
            }

            int SecondhandProductID = CommDataHelper.GetNewSerialNum(AppType.MagicWorld);

            string[] ProductImages;

            if (MagicWorldImageRule.SaveProductMainImage(SecondhandProductID, FileUpload_ProductImage.PostedFile, out ProductImages))
            {
                SecondhandProductModel model = new SecondhandProductModel();
                MagicCategoryModel cate = new MagicCategoryBll().GetModel(CategoryID);

                model.SecondhandProductID = SecondhandProductID;
                model.SecondhandProductName = StringUtility.RemoveHtmlTags(TextBox_ProductName.Text);
                model.CateID = CategoryID;
                model.CatePath = cate.CategoryPath;
                model.Price = Convert.ToDecimal(TextBox_Price.Text);
                model.SmallImage = ProductImages[0];
                model.MediumImage = ProductImages[1];
                model.UsageCondition = Convert.ToInt32(DropDown_Usage.SelectedValue);
                model.Stock = Convert.ToInt32(TextBox_Count.Text);
                model.Brief = TextBox_Brief.Text;

                model.InsertTime = DateTime.Now;
                model.UpdateTime = DateTime.Now;

                model.UserID = GetUserID();
                model.TrueName = TextBox_TrueName.Text;
                model.CellPhone = TextBox_CellPhone.Text;
                model.Phone = TextBox_Phone.Text;
                model.PostCode = TextBox_PostCode.Text;
                model.Region = String.Format("{0} {1} {2}", regionInfo.Province, regionInfo.City, regionInfo.County);
                model.Address = TextBox_Address.Text;

                model.Status = (int)SecondhandProductStatus.尚未审核;
                model.SortValue = SecondhandProductID;

                bll.Add(model);

                Response.Redirect("../SubmitSucc.aspx");
            }
            else
            {
                MessageBox.Show(this,"图片上传失败");
            }
        }
        private SecondhandProductModel BindModel(DataRow row)
        {
            SecondhandProductModel model = new SecondhandProductModel()
            {
                Address = Convert.ToString(row["Address"]),
                Brief = Convert.ToString(row["Brief"]),
                CateID = Convert.ToInt32(row["CateID"]),
                CatePath = Convert.ToString(row["CatePath"]),
                CellPhone = Convert.ToString(row["CellPhone"]),
                InsertTime = Convert.ToDateTime(row["InsertTime"]),
                MediumImage = Convert.ToString(row["MediumImage"]),
                Phone = Convert.ToString(row["Phone"]),
                PostCode = Convert.ToString(row["PostCode"]),
                Price = Convert.ToDecimal(row["Price"]),
                Region = Convert.ToString(row["region"]),
                SecondhandProductID = Convert.ToInt32(row["SeProductID"]),
                SecondhandProductName = Convert.ToString(row["SeProductName"]),
                SmallImage = Convert.ToString(row["SmallImage"]),
                SortValue = Convert.ToInt32(row["SortValue"]),
                Status = Convert.ToInt32(row["Status"]),
                Stock = Convert.ToInt32(row["Stock"]),
                TrueName = Convert.ToString(row["truename"]),
                UpdateTime = Convert.ToDateTime(row["UpdateTime"]),
                UsageCondition = Convert.ToInt32(row["usagecondition"]),
                UserID = Convert.ToString(row["UserID"])
            };

            return model;
        }