protected void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(this.txtTitle.Text.Trim().Length==0) { strErr+="商品名称不能为空!\\n"; } if (this.ddrCat.SelectedValue == "0") { strErr += "请选择所属分类!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } string picSmall = "", picNormal = "", picBig = ""; if (flPic.HasFile) { string result = Common.CommonHelper.Imageupload(flPic, "goods"); if (result.IndexOf('|') > -1) { picSmall = result.Split('|')[3]; picNormal = result.Split('|')[2]; picBig = result.Split('|')[1]; } } int isShow = 0, isNew = 0, isRecommend = 0, isHot = 0; foreach (ListItem item in cbl.Items) { if (item.Value == "show" & item.Selected == true) { isShow = 1; } if (item.Value == "new" & item.Selected == true) { isNew = 1; } if (item.Value == "recommend" & item.Selected == true) { isRecommend = 1; } if (item.Value == "hot" & item.Selected == true) { isHot = 1; } } hm.Model.goods model = new hm.Model.goods(); model.storeId = 1; model.storeName = "测试商家"; model.name = txtTitle.Text; model.sn = txtSn.Text; model.catId = int.Parse(this.ddrCat.SelectedValue); model.catName = this.ddrCat.Items[ddrCat.SelectedIndex].Text; model.marketPrice = decimal.Parse(txtMarketPrice.Text); model.storePrice = decimal.Parse(txtStorePrice.Text); model.freightPrice = decimal.Parse(txtFreightPrice.Text); model.buyScore = int.Parse(txtBuyScore.Text); model.giveScore = 0;///TODO 赠送积分待完善 model.picSmall = picSmall; model.picNormal = picNormal; model.picBig = picBig; model.summary = txtSummary.Text; model.remark = content.Value; model.favCount = 0; model.stock = int.Parse(txtStock.Text); model.clickNum = 0; model.saleNum = 0; model.isSku = 0; model.isShow = isShow; model.isNew = isNew; model.isRecommend = isRecommend; model.isHot = isHot; model.addTime = DateTime.Now; model.updateTime = DateTime.Now; model.orders = 1000; model.status = StatusHelpercs.Goods_Status_Normal; int goodsId = bll.Add(model); //录入默认图片 BLL.goodsPic pbll = new BLL.goodsPic(); Model.goodsPic gmodel = new Model.goodsPic(); gmodel.goodsId = goodsId; gmodel.goodsName = txtTitle.Text; gmodel.picBig = picBig; gmodel.picNormal = picNormal; gmodel.picSmall = picSmall; gmodel.orders = 1; gmodel.isShow = 1; gmodel.isDefault = 1; gmodel.addTime = DateTime.Now; pbll.Add(gmodel); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public hm.Model.goods GetModel(int id) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 id,storeId,storeName,name,sn,catId,catName,marketPrice,storePrice,freightPrice,buyScore,giveScore,picSmall,picNormal,picBig,summary,remark,favCount,stock,clickNum,saleNum,isSku,isShow,isNew,isRecommend,isHot,addTime,updateTime,orders,status from goods "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4) }; parameters[0].Value = id; hm.Model.goods model=new hm.Model.goods(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["id"]!=null && ds.Tables[0].Rows[0]["id"].ToString()!="") { model.id=int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } if(ds.Tables[0].Rows[0]["storeId"]!=null && ds.Tables[0].Rows[0]["storeId"].ToString()!="") { model.storeId=int.Parse(ds.Tables[0].Rows[0]["storeId"].ToString()); } if(ds.Tables[0].Rows[0]["storeName"]!=null && ds.Tables[0].Rows[0]["storeName"].ToString()!="") { model.storeName=ds.Tables[0].Rows[0]["storeName"].ToString(); } if(ds.Tables[0].Rows[0]["name"]!=null && ds.Tables[0].Rows[0]["name"].ToString()!="") { model.name=ds.Tables[0].Rows[0]["name"].ToString(); } if(ds.Tables[0].Rows[0]["sn"]!=null && ds.Tables[0].Rows[0]["sn"].ToString()!="") { model.sn=ds.Tables[0].Rows[0]["sn"].ToString(); } if(ds.Tables[0].Rows[0]["catId"]!=null && ds.Tables[0].Rows[0]["catId"].ToString()!="") { model.catId=int.Parse(ds.Tables[0].Rows[0]["catId"].ToString()); } if(ds.Tables[0].Rows[0]["catName"]!=null && ds.Tables[0].Rows[0]["catName"].ToString()!="") { model.catName=ds.Tables[0].Rows[0]["catName"].ToString(); } if(ds.Tables[0].Rows[0]["marketPrice"]!=null && ds.Tables[0].Rows[0]["marketPrice"].ToString()!="") { model.marketPrice=decimal.Parse(ds.Tables[0].Rows[0]["marketPrice"].ToString()); } if(ds.Tables[0].Rows[0]["storePrice"]!=null && ds.Tables[0].Rows[0]["storePrice"].ToString()!="") { model.storePrice=decimal.Parse(ds.Tables[0].Rows[0]["storePrice"].ToString()); } if(ds.Tables[0].Rows[0]["freightPrice"]!=null && ds.Tables[0].Rows[0]["freightPrice"].ToString()!="") { model.freightPrice=decimal.Parse(ds.Tables[0].Rows[0]["freightPrice"].ToString()); } if(ds.Tables[0].Rows[0]["buyScore"]!=null && ds.Tables[0].Rows[0]["buyScore"].ToString()!="") { model.buyScore=int.Parse(ds.Tables[0].Rows[0]["buyScore"].ToString()); } if(ds.Tables[0].Rows[0]["giveScore"]!=null && ds.Tables[0].Rows[0]["giveScore"].ToString()!="") { model.giveScore=int.Parse(ds.Tables[0].Rows[0]["giveScore"].ToString()); } if(ds.Tables[0].Rows[0]["picSmall"]!=null && ds.Tables[0].Rows[0]["picSmall"].ToString()!="") { model.picSmall=ds.Tables[0].Rows[0]["picSmall"].ToString(); } if(ds.Tables[0].Rows[0]["picNormal"]!=null && ds.Tables[0].Rows[0]["picNormal"].ToString()!="") { model.picNormal=ds.Tables[0].Rows[0]["picNormal"].ToString(); } if(ds.Tables[0].Rows[0]["picBig"]!=null && ds.Tables[0].Rows[0]["picBig"].ToString()!="") { model.picBig=ds.Tables[0].Rows[0]["picBig"].ToString(); } if(ds.Tables[0].Rows[0]["summary"]!=null && ds.Tables[0].Rows[0]["summary"].ToString()!="") { model.summary=ds.Tables[0].Rows[0]["summary"].ToString(); } if(ds.Tables[0].Rows[0]["remark"]!=null && ds.Tables[0].Rows[0]["remark"].ToString()!="") { model.remark=ds.Tables[0].Rows[0]["remark"].ToString(); } if(ds.Tables[0].Rows[0]["favCount"]!=null && ds.Tables[0].Rows[0]["favCount"].ToString()!="") { model.favCount=int.Parse(ds.Tables[0].Rows[0]["favCount"].ToString()); } if(ds.Tables[0].Rows[0]["stock"]!=null && ds.Tables[0].Rows[0]["stock"].ToString()!="") { model.stock=int.Parse(ds.Tables[0].Rows[0]["stock"].ToString()); } if(ds.Tables[0].Rows[0]["clickNum"]!=null && ds.Tables[0].Rows[0]["clickNum"].ToString()!="") { model.clickNum=int.Parse(ds.Tables[0].Rows[0]["clickNum"].ToString()); } if(ds.Tables[0].Rows[0]["saleNum"]!=null && ds.Tables[0].Rows[0]["saleNum"].ToString()!="") { model.saleNum=int.Parse(ds.Tables[0].Rows[0]["saleNum"].ToString()); } if(ds.Tables[0].Rows[0]["isSku"]!=null && ds.Tables[0].Rows[0]["isSku"].ToString()!="") { model.isSku=int.Parse(ds.Tables[0].Rows[0]["isSku"].ToString()); } if(ds.Tables[0].Rows[0]["isShow"]!=null && ds.Tables[0].Rows[0]["isShow"].ToString()!="") { model.isShow=int.Parse(ds.Tables[0].Rows[0]["isShow"].ToString()); } if(ds.Tables[0].Rows[0]["isNew"]!=null && ds.Tables[0].Rows[0]["isNew"].ToString()!="") { model.isNew=int.Parse(ds.Tables[0].Rows[0]["isNew"].ToString()); } if(ds.Tables[0].Rows[0]["isRecommend"]!=null && ds.Tables[0].Rows[0]["isRecommend"].ToString()!="") { model.isRecommend=int.Parse(ds.Tables[0].Rows[0]["isRecommend"].ToString()); } if(ds.Tables[0].Rows[0]["isHot"]!=null && ds.Tables[0].Rows[0]["isHot"].ToString()!="") { model.isHot=int.Parse(ds.Tables[0].Rows[0]["isHot"].ToString()); } if(ds.Tables[0].Rows[0]["addTime"]!=null && ds.Tables[0].Rows[0]["addTime"].ToString()!="") { model.addTime=DateTime.Parse(ds.Tables[0].Rows[0]["addTime"].ToString()); } if(ds.Tables[0].Rows[0]["updateTime"]!=null && ds.Tables[0].Rows[0]["updateTime"].ToString()!="") { model.updateTime=DateTime.Parse(ds.Tables[0].Rows[0]["updateTime"].ToString()); } if(ds.Tables[0].Rows[0]["orders"]!=null && ds.Tables[0].Rows[0]["orders"].ToString()!="") { model.orders=int.Parse(ds.Tables[0].Rows[0]["orders"].ToString()); } if(ds.Tables[0].Rows[0]["status"]!=null && ds.Tables[0].Rows[0]["status"].ToString()!="") { model.status=int.Parse(ds.Tables[0].Rows[0]["status"].ToString()); } return model; } else { return null; } }