public static GroupProductModel GetImageUrl(GroupProductModel Product) { Product.SmallImage = config.UrlRoot + Product.SmallImage; Product.MediumImage = config.UrlRoot + Product.MediumImage; Product.LargeImage = config.UrlRoot + Product.LargeImage; return Product; }
protected void Button_Add_Click(object sender, EventArgs e) { string ErrorMessage = String.Empty; if (String.IsNullOrEmpty(TextBox_ProductName.Text.Trim())) ErrorMessage += "产品名称不能为空\\n"; if (String.IsNullOrEmpty(TextBox_MarketPrice.Text.Trim()) || !PageValidate.IsDecimal(TextBox_MarketPrice.Text.Trim())) ErrorMessage += "市场价输入有误\\n"; if (String.IsNullOrEmpty(TextBox_GroupPrice.Text.Trim()) || !PageValidate.IsDecimal(TextBox_GroupPrice.Text.Trim())) ErrorMessage += "团购价输入有误\\n"; if (String.IsNullOrEmpty(TextBox_PrePaidPrice.Text.Trim()) || !PageValidate.IsDecimal(TextBox_PrePaidPrice.Text.Trim())) ErrorMessage += "预付金额输入有误\\n"; if (String.IsNullOrEmpty(TextBox_SuccedLine.Text.Trim()) || !PageValidate.IsNumber(TextBox_SuccedLine.Text.Trim())) ErrorMessage += "成团人数输入有误"; if (String.IsNullOrEmpty(TextBox_Brief.Text.Trim())) ErrorMessage += "产品简介不能为空\\n"; if (String.IsNullOrEmpty(FileUpload_Image.FileName.Trim())) ErrorMessage += "产品图片不能为空\\n"; if (!String.IsNullOrEmpty(ErrorMessage)) { MessageBox.Show(this, ErrorMessage); return; } int GroupProductID = CommDataHelper.GetNewSerialNum(AppType.GroupShopping); string[] FileNames = new string[3]; if (GroupShoppingImageRule.SaveImage(GroupProductID, FileUpload_Image.PostedFile, out FileNames)) { GroupProductModel model = new GroupProductModel(); model.ProductID = GroupProductID; model.ProductName = TextBox_ProductName.Text.Trim(); model.ProductType = Convert.ToInt32(DropDown_ProductType.SelectedValue); model.ProductCode = TextBox_ProductCode.Text.Trim(); model.MarketPrice = Convert.ToDecimal(TextBox_MarketPrice.Text.Trim()); model.GroupPrice = Convert.ToDecimal(TextBox_GroupPrice.Text.Trim()); model.PrePaidPrice = Convert.ToDecimal(TextBox_PrePaidPrice.Text.Trim()); model.SuccedLine = Convert.ToInt32(TextBox_SuccedLine.Text.Trim()); model.IsRecommend = CheclBox_Recommend.Checked; model.Detail = TextBox_Detail.Text.Trim(); model.Description = TextBox_Brief.Text; model.SmallImage = FileNames[0]; model.MediumImage = FileNames[1]; model.LargeImage = FileNames[2]; model.InsertTime = DateTime.Now; model.ChangeTime = DateTime.Now; model.Status = (int)GroupShoppingProductStatus.正在团购; new GroupProductBll().Add(model); Response.Redirect("List.aspx"); } else { MessageBox.Show(this, "图片上传失败,请检查后重新选择!"); return; } }
public void Add(GroupProductModel model) { DbCommand Command = dbw.GetStoredProcCommand("UP_gsProduct_ADD"); dbw.AddInParameter(Command,"@ProductID",DbType.Int32,model.ProductID); dbw.AddInParameter(Command,"@ProductName",DbType.String,model.ProductName); dbw.AddInParameter(Command, "@ProductCode", DbType.String, model.ProductCode); dbw.AddInParameter(Command, "@MarketPrice", DbType.Decimal, model.MarketPrice); dbw.AddInParameter(Command,"@GroupPrice",DbType.Decimal,model.GroupPrice); dbw.AddInParameter(Command, "@PrePaidPrice", DbType.Decimal, model.PrePaidPrice); dbw.AddInParameter(Command, "@succedline", DbType.Int32, model.SuccedLine); dbw.AddInParameter(Command,"@SmallImage",DbType.String,model.SmallImage); dbw.AddInParameter(Command,"@MediumImage",DbType.String,model.MediumImage); dbw.AddInParameter(Command,"@LargeImage",DbType.String,model.LargeImage); dbw.AddInParameter(Command,"@Detail",DbType.String,model.Detail); dbw.AddInParameter(Command,"@Description",DbType.String,model.Description); dbw.AddInParameter(Command,"@InsertTime",DbType.DateTime,model.InsertTime); dbw.AddInParameter(Command,"@ChangeTime",DbType.DateTime,model.ChangeTime); dbw.AddInParameter(Command,"@Status",DbType.Int16,model.Status); dbw.AddInParameter(Command, "@ProductType", DbType.Int16, model.ProductType); dbw.AddInParameter(Command, "@isrecommend", DbType.Boolean, model.IsRecommend); dbw.ExecuteNonQuery(Command); }
private GroupProductModel GetModel(DataRow row) { GroupProductModel model = new GroupProductModel(); model.ProductID = Convert.ToInt32(row["ProductID"]); model.ProductName = Convert.ToString(row["ProductName"]); model.ProductCode = Convert.ToString(row["ProductCode"]); model.Description = Convert.ToString(row["Description"]); model.Detail = Convert.ToString(row["Detail"]); model.PrePaidPrice = Convert.ToDecimal(row["PrePaidPrice"]); model.GroupPrice = Convert.ToDecimal(row["GroupPrice"]); model.InsertTime = Convert.ToDateTime(row["InsertTime"]); model.ChangeTime = Convert.ToDateTime(row["ChangeTime"]); model.SmallImage = Convert.ToString(row["SmallImage"]); model.MediumImage = Convert.ToString(row["MediumImage"]); model.LargeImage = Convert.ToString(row["LargeImage"]); model.ProductType = Convert.ToInt16(row["ProductType"]); model.Status = Convert.ToInt16(row["Status"]); model.MarketPrice = Convert.ToDecimal(row["MarketPrice"]); model.SuccedLine = Convert.ToInt32(row["SuccedLine"]); model.IsRecommend = Convert.ToBoolean(row["IsRecommend"]); return model; }