public void Update(DemandProductModel model)
{
DbCommand Command = dbw.GetStoredProcCommand("UP_mwDemand_Update");
dbw.AddInParameter(Command,"@demandid",DbType.Int32,model.DemandID);
dbw.AddInParameter(Command,"@demandname",DbType.String,model.DemandName);
dbw.AddInParameter(Command,"@smallimage",DbType.String,model.SmallImage);
dbw.AddInParameter(Command,"@mediumimage",DbType.String,model.MediumImage);
dbw.AddInParameter(Command,"@categoryid",DbType.Int32,model.CategoryID);
dbw.AddInParameter(Command,"@categorypath",DbType.String,model.CategoryPath);
dbw.AddInParameter(Command,"@price",DbType.Decimal,model.Price);
dbw.AddInParameter(Command,"@count",DbType.Int32,model.Count);
dbw.AddInParameter(Command,"@usagecondition",DbType.Int16,model.UsageCondition);
dbw.AddInParameter(Command,"@expirationtime",DbType.DateTime,model.ExpirationTime);
dbw.AddInParameter(Command,"@brief",DbType.String,model.Brief);
dbw.AddInParameter(Command,"@userid",DbType.String,model.UserID);
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,"@status",DbType.Int16,model.Status);
dbw.AddInParameter(Command,"@inserttime",DbType.DateTime,model.InsertTime);
dbw.AddInParameter(Command,"@updatetime",DbType.DateTime,model.UpdateTime);
dbw.ExecuteNonQuery(Command);
}
public void Update(DemandProductModel model)
{
dal.Update(model);
}
public void Add(DemandProductModel 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_ExpireTime.Text) || !PageValidate.IsDate(TextBox_ExpireTime.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;
}
DemandProductModel model = new DemandProductModel();
MagicCategoryModel cate = new MagicCategoryBll().GetModel(CategoryID);
int DemandID = CommDataHelper.GetNewSerialNum(AppType.MagicWorld);
string[] ProductImages;
if (MagicWorldImageRule.SaveProductMainImage(DemandID, FileUpload_ProductImage.PostedFile, out ProductImages))
{
model.DemandID = DemandID;
model.DemandName = StringUtility.RemoveHtmlTags(TextBox_ProductName.Text);
model.Address = TextBox_Address.Text;
model.Brief = TextBox_Brief.Text ;
model.CategoryID = CategoryID;
model.CategoryPath = cate.CategoryPath;
model.CellPhone = TextBox_CellPhone.Text;
model.Count = Convert.ToInt32(TextBox_Count.Text);
model.ExpirationTime = Convert.ToDateTime(TextBox_ExpireTime.Text);
model.InsertTime = DateTime.Now;
model.SmallImage = ProductImages[0];
model.MediumImage = ProductImages[1];
model.Phone = TextBox_Phone.Text;
model.PostCode = TextBox_PostCode.Text;
model.Price = Convert.ToDecimal(TextBox_Price.Text);
model.Region = String.Format("{0} {1} {2}", regionInfo.Province, regionInfo.City, regionInfo.County);
model.Status = (int)DemandProductStatus.尚未审核;
model.TrueName = TextBox_TrueName.Text;
model.UpdateTime = DateTime.Now;
model.UsageCondition = Convert.ToInt32(DropDown_Usage.SelectedValue);
model.UserID = GetUserID();
bll.Add(model);
Response.Redirect("../SubmitSucc.aspx");
}
else
{
MessageBox.Show(this, "图片上传失败");
}
}