/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (Application["GalleryInt"] != null) //删除相册临时数据 { GalleryBll.Delete("Rid=" + Application["GalleryInt"]); } else { Application["GalleryInt"] = ROYcms.Common.StringPlus.GetRamTimeCode();//修改相册时用到 } //绑定输出相册数据 if (ROYcms.Common.Request.GetQueryInt("Id") != 0) { GalleryBind(ROYcms.Common.Request.GetQueryInt("Id")); AppendixBind(ROYcms.Common.Request.GetQueryInt("Id")); } DdClass_bind(); brand_id_bind(); goods_type.SelectedValue = ROYcms.Common.Request.GetQueryInt("Class").ToString(); brand_id.SelectedValue = ROYcms.Common.Request.GetQueryInt("Brand").ToString(); if (ROYcms.Common.Request.GetQueryInt("Id") > 0)//编辑 { Model = BLL.GetModel(ROYcms.Common.Request.GetQueryInt("Id")); } }
/// <summary> /// 将购物车数据插入到数据库 /// </summary> /// <param name="OrderId">订单号</param> /// <returns></returns> public bool InsertOrderGoods(string OrderId) { //try //{ DataTable DT = ROYcms.Common.ShopCooksCar.GetAllChoppingCar(); //获取购物车数据 foreach (DataRow Dr in DT.Rows) { Goods_Model = Goods_BLL.GetModel(Convert.ToInt32(Dr["Id"])); Order_Detail_Model.goods_id = Goods_Model.Id; Order_Detail_Model.order_id = OrderId; //订单商品信息对应的详细信息id,取值order_info的order_id Order_Detail_Model.goods_number = Convert.ToInt32(Dr["num"]); //商品的购买数量 Order_Detail_Model.goods_id = Goods_Model.Id; //商品的的id,取值表ecs_goods 的 goods_id Order_Detail_Model.goods_name = Goods_Model.goods_name; //商品的名称,取值表ecs_goods Order_Detail_Model.goods_sn = Goods_Model.goods_sn; //商品的唯一货号,取值ecs_goods Order_Detail_Model.market_price = Goods_Model.market_price; //商品的市场售价,取值ecs_goods Order_Detail_Model.goods_price = Goods_Model.shop_price; //商品的本店售价,取值ecs_goods Order_Detail_Model.send_number = Goods_Model.goods_number; //是否已发货,0 ,否;1,是 Order_Detail_Model.is_real = Goods_Model.is_real; //是否是实物 Order_Detail_Model.extension_code = Goods_Model.extension_code; //商品的扩展属性,比如像虚拟卡 Order_Detail_Model.goods_attr = null; //购买该商品时所选择的属性; Order_Detail_Model.parent_id = 0; //父商品id,取值于ecs_cart的 parent_id;如果有该值则是值多代表的物品的配件 Order_Detail_Model.is_gift = 0; //是参加的优惠活动的id Order_Detail_BLL.Add(Order_Detail_Model); } return(true); //} //catch { return false; } }
/// <summary> /// Page_Load /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { int PRE = 0; Model.Id = ROYcms.Common.Request.GetFormInt("Id"); if (Model.Id > 0)//编辑 { Model = BLL.GetModel(Model.Id); } Model.goods_type = ROYcms.Common.Request.GetFormInt("goods_type"); Model.goods_sn = ROYcms.Common.Request.GetFormString("goods_sn"); Model.goods_name = ROYcms.Common.Request.GetFormString("goods_name"); Model.goods_name_style = ROYcms.Common.Request.GetFormString("goods_name_style"); Model.brand_id = ROYcms.Common.Request.GetFormInt("brand_id"); Model.provider_name = ROYcms.Common.Request.GetFormString("provider_name"); Model.goods_number = ROYcms.Common.Request.GetFormInt("goods_number"); Model.goods_weight = ROYcms.Common.Request.GetFormInt("goods_weight"); Model.market_price = ROYcms.Common.Request.GetFormInt("market_price"); Model.shop_price = ROYcms.Common.Request.GetFormInt("shop_price"); Model.promote_price = ROYcms.Common.Request.GetFormInt("promote_price"); Model.promote_start_date = Convert.ToDateTime(ROYcms.Common.Request.GetFormString("promote_start_date") == ""?DateTime.Now.ToString():ROYcms.Common.Request.GetFormString("promote_start_date")); Model.promote_end_date = Convert.ToDateTime(ROYcms.Common.Request.GetFormString("promote_end_date") == "" ? DateTime.Now.ToString(): ROYcms.Common.Request.GetFormString("promote_end_date")); Model.warn_number = ROYcms.Common.Request.GetFormInt("warn_number"); Model.keywords = ROYcms.Common.Request.GetFormString("keywords"); Model.goods_brief = ROYcms.Common.Request.GetFormString("goods_brief"); Model.goods_desc = ROYcms.Common.Request.GetFormString("goods_desc"); Model.goods_thumb = ROYcms.Common.Request.GetFormString("goods_thumb"); Model.goods_img = ROYcms.Common.Request.GetFormString("goods_img"); Model.original_img = ROYcms.Common.Request.GetFormString("original_img"); Model.is_real = ROYcms.Common.Request.GetFormInt("is_real"); Model.extension_code = ROYcms.Common.Request.GetFormString("extension_code"); Model.is_on_sale = ROYcms.Common.Request.GetFormInt("is_on_sale"); Model.is_alone_sale = ROYcms.Common.Request.GetFormInt("is_alone_sale"); Model.integral = ROYcms.Common.Request.GetFormInt("integral"); Model.is_delete = ROYcms.Common.Request.GetFormInt("is_delete"); Model.is_best = ROYcms.Common.Request.GetFormInt("is_best"); Model.is_hot = ROYcms.Common.Request.GetFormInt("is_hot"); Model.is_promote = ROYcms.Common.Request.GetFormInt("is_promote"); Model.give_integral = ROYcms.Common.Request.GetFormInt("give_integral"); Model.classkind = ROYcms.Common.Request.GetFormInt("ClassKind"); Model.last_update = DateTime.Now; Model.click_count = 1; Model.add_time = DateTime.Now; if (Model.Id == 0)//添加 { PRE = this.BLL.Add(this.Model); try //将相册的图片数据关联到文章来 { new ROYcms.Sys.BLL.ROYcms_Gallery().ZUpdate(PRE, Convert.ToInt32(Application["GalleryInt"] == null ? 0 : Application["GalleryInt"])); } catch { new ROYcms.Sys.BLL.ROYcms_Log().InsertSystemLog("3", "将相册的图片数据关联到文章失败", "将相册的图片数据关联到文章失败");//写入日志 } } else //编辑 { PRE = this.BLL.Update(this.Model) == true ? 1 : 0; } Response.ContentType = "text/plain"; Response.Write(PRE); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { Model = BLL.GetModel(ROYcms.Common.Request.GetQueryInt("Id")); GalleryBind(ROYcms.Common.Request.GetQueryInt("Id")); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ROYcms.Sys.Model.ROYcms_Goods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ROYcms_Goods("); strSql.Append("goods_type,goods_sn,goods_name,goods_name_style,click_count,brand_id,provider_name,goods_number,goods_weight,market_price,shop_price,promote_price,promote_start_date,promote_end_date,warn_number,keywords,goods_brief,goods_desc,goods_thumb,goods_img,original_img,is_real,extension_code,is_on_sale,is_alone_sale,integral,add_time,is_delete,is_best,is_hot,is_promote,last_update,give_integral,ClassKind)"); strSql.Append(" values ("); strSql.Append("@goods_type,@goods_sn,@goods_name,@goods_name_style,@click_count,@brand_id,@provider_name,@goods_number,@goods_weight,@market_price,@shop_price,@promote_price,@promote_start_date,@promote_end_date,@warn_number,@keywords,@goods_brief,@goods_desc,@goods_thumb,@goods_img,@original_img,@is_real,@extension_code,@is_on_sale,@is_alone_sale,@integral,@add_time,@is_delete,@is_best,@is_hot,@is_promote,@last_update,@give_integral,@ClassKind)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@goods_type", SqlDbType.Int, 4), new SqlParameter("@goods_sn", SqlDbType.VarChar, 100), new SqlParameter("@goods_name", SqlDbType.VarChar, 500), new SqlParameter("@goods_name_style", SqlDbType.VarChar, 100), new SqlParameter("@click_count", SqlDbType.Int, 4), new SqlParameter("@brand_id", SqlDbType.Int, 4), new SqlParameter("@provider_name", SqlDbType.VarChar, 100), new SqlParameter("@goods_number", SqlDbType.Int, 4), new SqlParameter("@goods_weight", SqlDbType.Int, 4), new SqlParameter("@market_price", SqlDbType.Int, 4), new SqlParameter("@shop_price", SqlDbType.Int, 4), new SqlParameter("@promote_price", SqlDbType.Int, 4), new SqlParameter("@promote_start_date", SqlDbType.DateTime), new SqlParameter("@promote_end_date", SqlDbType.DateTime), new SqlParameter("@warn_number", SqlDbType.Int, 4), new SqlParameter("@keywords", SqlDbType.VarChar, 500), new SqlParameter("@goods_brief", SqlDbType.VarChar, 500), new SqlParameter("@goods_desc", SqlDbType.Text), new SqlParameter("@goods_thumb", SqlDbType.VarChar, 500), new SqlParameter("@goods_img", SqlDbType.VarChar, 500), new SqlParameter("@original_img", SqlDbType.VarChar, 500), new SqlParameter("@is_real", SqlDbType.Int, 4), new SqlParameter("@extension_code", SqlDbType.VarChar, 100), new SqlParameter("@is_on_sale", SqlDbType.Int, 4), new SqlParameter("@is_alone_sale", SqlDbType.Int, 4), new SqlParameter("@integral", SqlDbType.Int, 4), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@is_delete", SqlDbType.Int, 4), new SqlParameter("@is_best", SqlDbType.Int, 4), new SqlParameter("@is_hot", SqlDbType.Int, 4), new SqlParameter("@is_promote", SqlDbType.Int, 4), new SqlParameter("@last_update", SqlDbType.DateTime), new SqlParameter("@give_integral", SqlDbType.Int, 4), new SqlParameter("@ClassKind", SqlDbType.Int, 4) }; parameters[0].Value = model.goods_type; parameters[1].Value = model.goods_sn; parameters[2].Value = model.goods_name; parameters[3].Value = model.goods_name_style; parameters[4].Value = model.click_count; parameters[5].Value = model.brand_id; parameters[6].Value = model.provider_name; parameters[7].Value = model.goods_number; parameters[8].Value = model.goods_weight; parameters[9].Value = model.market_price; parameters[10].Value = model.shop_price; parameters[11].Value = model.promote_price; parameters[12].Value = model.promote_start_date; parameters[13].Value = model.promote_end_date; parameters[14].Value = model.warn_number; parameters[15].Value = model.keywords; parameters[16].Value = model.goods_brief; parameters[17].Value = model.goods_desc; parameters[18].Value = model.goods_thumb; parameters[19].Value = model.goods_img; parameters[20].Value = model.original_img; parameters[21].Value = model.is_real; parameters[22].Value = model.extension_code; parameters[23].Value = model.is_on_sale; parameters[24].Value = model.is_alone_sale; parameters[25].Value = model.integral; parameters[26].Value = model.add_time; parameters[27].Value = model.is_delete; parameters[28].Value = model.is_best; parameters[29].Value = model.is_hot; parameters[30].Value = model.is_promote; parameters[31].Value = model.last_update; parameters[32].Value = model.give_integral; parameters[33].Value = model.classkind; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ROYcms.Sys.Model.ROYcms_Goods GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,goods_type,goods_sn,goods_name,goods_name_style,click_count,brand_id,provider_name,goods_number,goods_weight,market_price,shop_price,promote_price,promote_start_date,promote_end_date,warn_number,keywords,goods_brief,goods_desc,goods_thumb,goods_img,original_img,is_real,extension_code,is_on_sale,is_alone_sale,integral,add_time,is_delete,is_best,is_hot,is_promote,last_update,give_integral,ClassKind from ROYcms_Goods "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; ROYcms.Sys.Model.ROYcms_Goods model = new ROYcms.Sys.Model.ROYcms_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]["goods_type"] != null && ds.Tables[0].Rows[0]["goods_type"].ToString() != "") { model.goods_type = int.Parse(ds.Tables[0].Rows[0]["goods_type"].ToString()); } if (ds.Tables[0].Rows[0]["goods_sn"] != null && ds.Tables[0].Rows[0]["goods_sn"].ToString() != "") { model.goods_sn = ds.Tables[0].Rows[0]["goods_sn"].ToString(); } if (ds.Tables[0].Rows[0]["goods_name"] != null && ds.Tables[0].Rows[0]["goods_name"].ToString() != "") { model.goods_name = ds.Tables[0].Rows[0]["goods_name"].ToString(); } if (ds.Tables[0].Rows[0]["goods_name_style"] != null && ds.Tables[0].Rows[0]["goods_name_style"].ToString() != "") { model.goods_name_style = ds.Tables[0].Rows[0]["goods_name_style"].ToString(); } if (ds.Tables[0].Rows[0]["click_count"] != null && ds.Tables[0].Rows[0]["click_count"].ToString() != "") { model.click_count = int.Parse(ds.Tables[0].Rows[0]["click_count"].ToString()); } if (ds.Tables[0].Rows[0]["brand_id"] != null && ds.Tables[0].Rows[0]["brand_id"].ToString() != "") { model.brand_id = int.Parse(ds.Tables[0].Rows[0]["brand_id"].ToString()); } if (ds.Tables[0].Rows[0]["provider_name"] != null && ds.Tables[0].Rows[0]["provider_name"].ToString() != "") { model.provider_name = ds.Tables[0].Rows[0]["provider_name"].ToString(); } if (ds.Tables[0].Rows[0]["goods_number"] != null && ds.Tables[0].Rows[0]["goods_number"].ToString() != "") { model.goods_number = int.Parse(ds.Tables[0].Rows[0]["goods_number"].ToString()); } if (ds.Tables[0].Rows[0]["goods_weight"] != null && ds.Tables[0].Rows[0]["goods_weight"].ToString() != "") { model.goods_weight = int.Parse(ds.Tables[0].Rows[0]["goods_weight"].ToString()); } if (ds.Tables[0].Rows[0]["market_price"] != null && ds.Tables[0].Rows[0]["market_price"].ToString() != "") { model.market_price = int.Parse(ds.Tables[0].Rows[0]["market_price"].ToString()); } if (ds.Tables[0].Rows[0]["shop_price"] != null && ds.Tables[0].Rows[0]["shop_price"].ToString() != "") { model.shop_price = int.Parse(ds.Tables[0].Rows[0]["shop_price"].ToString()); } if (ds.Tables[0].Rows[0]["promote_price"] != null && ds.Tables[0].Rows[0]["promote_price"].ToString() != "") { model.promote_price = int.Parse(ds.Tables[0].Rows[0]["promote_price"].ToString()); } if (ds.Tables[0].Rows[0]["promote_start_date"] != null && ds.Tables[0].Rows[0]["promote_start_date"].ToString() != "") { model.promote_start_date = DateTime.Parse(ds.Tables[0].Rows[0]["promote_start_date"].ToString()); } if (ds.Tables[0].Rows[0]["promote_end_date"] != null && ds.Tables[0].Rows[0]["promote_end_date"].ToString() != "") { model.promote_end_date = DateTime.Parse(ds.Tables[0].Rows[0]["promote_end_date"].ToString()); } if (ds.Tables[0].Rows[0]["warn_number"] != null && ds.Tables[0].Rows[0]["warn_number"].ToString() != "") { model.warn_number = int.Parse(ds.Tables[0].Rows[0]["warn_number"].ToString()); } if (ds.Tables[0].Rows[0]["keywords"] != null && ds.Tables[0].Rows[0]["keywords"].ToString() != "") { model.keywords = ds.Tables[0].Rows[0]["keywords"].ToString(); } if (ds.Tables[0].Rows[0]["goods_brief"] != null && ds.Tables[0].Rows[0]["goods_brief"].ToString() != "") { model.goods_brief = ds.Tables[0].Rows[0]["goods_brief"].ToString(); } if (ds.Tables[0].Rows[0]["goods_desc"] != null && ds.Tables[0].Rows[0]["goods_desc"].ToString() != "") { model.goods_desc = ds.Tables[0].Rows[0]["goods_desc"].ToString(); } if (ds.Tables[0].Rows[0]["goods_thumb"] != null && ds.Tables[0].Rows[0]["goods_thumb"].ToString() != "") { model.goods_thumb = ds.Tables[0].Rows[0]["goods_thumb"].ToString(); } if (ds.Tables[0].Rows[0]["goods_img"] != null && ds.Tables[0].Rows[0]["goods_img"].ToString() != "") { model.goods_img = ds.Tables[0].Rows[0]["goods_img"].ToString(); } if (ds.Tables[0].Rows[0]["original_img"] != null && ds.Tables[0].Rows[0]["original_img"].ToString() != "") { model.original_img = ds.Tables[0].Rows[0]["original_img"].ToString(); } if (ds.Tables[0].Rows[0]["is_real"] != null && ds.Tables[0].Rows[0]["is_real"].ToString() != "") { model.is_real = int.Parse(ds.Tables[0].Rows[0]["is_real"].ToString()); } if (ds.Tables[0].Rows[0]["extension_code"] != null && ds.Tables[0].Rows[0]["extension_code"].ToString() != "") { model.extension_code = ds.Tables[0].Rows[0]["extension_code"].ToString(); } if (ds.Tables[0].Rows[0]["is_on_sale"] != null && ds.Tables[0].Rows[0]["is_on_sale"].ToString() != "") { model.is_on_sale = int.Parse(ds.Tables[0].Rows[0]["is_on_sale"].ToString()); } if (ds.Tables[0].Rows[0]["is_alone_sale"] != null && ds.Tables[0].Rows[0]["is_alone_sale"].ToString() != "") { model.is_alone_sale = int.Parse(ds.Tables[0].Rows[0]["is_alone_sale"].ToString()); } if (ds.Tables[0].Rows[0]["integral"] != null && ds.Tables[0].Rows[0]["integral"].ToString() != "") { model.integral = int.Parse(ds.Tables[0].Rows[0]["integral"].ToString()); } if (ds.Tables[0].Rows[0]["add_time"] != null && ds.Tables[0].Rows[0]["add_time"].ToString() != "") { model.add_time = DateTime.Parse(ds.Tables[0].Rows[0]["add_time"].ToString()); } if (ds.Tables[0].Rows[0]["is_delete"] != null && ds.Tables[0].Rows[0]["is_delete"].ToString() != "") { model.is_delete = int.Parse(ds.Tables[0].Rows[0]["is_delete"].ToString()); } if (ds.Tables[0].Rows[0]["is_best"] != null && ds.Tables[0].Rows[0]["is_best"].ToString() != "") { model.is_best = int.Parse(ds.Tables[0].Rows[0]["is_best"].ToString()); } if (ds.Tables[0].Rows[0]["is_hot"] != null && ds.Tables[0].Rows[0]["is_hot"].ToString() != "") { model.is_hot = int.Parse(ds.Tables[0].Rows[0]["is_hot"].ToString()); } if (ds.Tables[0].Rows[0]["is_promote"] != null && ds.Tables[0].Rows[0]["is_promote"].ToString() != "") { model.is_promote = int.Parse(ds.Tables[0].Rows[0]["is_promote"].ToString()); } if (ds.Tables[0].Rows[0]["last_update"] != null && ds.Tables[0].Rows[0]["last_update"].ToString() != "") { model.last_update = DateTime.Parse(ds.Tables[0].Rows[0]["last_update"].ToString()); } if (ds.Tables[0].Rows[0]["give_integral"] != null && ds.Tables[0].Rows[0]["give_integral"].ToString() != "") { model.give_integral = int.Parse(ds.Tables[0].Rows[0]["give_integral"].ToString()); } if (ds.Tables[0].Rows[0]["ClassKind"] != null && ds.Tables[0].Rows[0]["ClassKind"].ToString() != "") { model.classkind = int.Parse(ds.Tables[0].Rows[0]["ClassKind"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ROYcms.Sys.Model.ROYcms_Goods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ROYcms_Goods set "); strSql.Append("goods_type=@goods_type,"); strSql.Append("goods_sn=@goods_sn,"); strSql.Append("goods_name=@goods_name,"); strSql.Append("goods_name_style=@goods_name_style,"); strSql.Append("click_count=@click_count,"); strSql.Append("brand_id=@brand_id,"); strSql.Append("provider_name=@provider_name,"); strSql.Append("goods_number=@goods_number,"); strSql.Append("goods_weight=@goods_weight,"); strSql.Append("market_price=@market_price,"); strSql.Append("shop_price=@shop_price,"); strSql.Append("promote_price=@promote_price,"); strSql.Append("promote_start_date=@promote_start_date,"); strSql.Append("promote_end_date=@promote_end_date,"); strSql.Append("warn_number=@warn_number,"); strSql.Append("keywords=@keywords,"); strSql.Append("goods_brief=@goods_brief,"); strSql.Append("goods_desc=@goods_desc,"); strSql.Append("goods_thumb=@goods_thumb,"); strSql.Append("goods_img=@goods_img,"); strSql.Append("original_img=@original_img,"); strSql.Append("is_real=@is_real,"); strSql.Append("extension_code=@extension_code,"); strSql.Append("is_on_sale=@is_on_sale,"); strSql.Append("is_alone_sale=@is_alone_sale,"); strSql.Append("integral=@integral,"); strSql.Append("add_time=@add_time,"); strSql.Append("is_delete=@is_delete,"); strSql.Append("is_best=@is_best,"); strSql.Append("is_hot=@is_hot,"); strSql.Append("is_promote=@is_promote,"); strSql.Append("last_update=@last_update,"); strSql.Append("ClassKind=@ClassKind,"); strSql.Append("give_integral=@give_integral"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@goods_type", SqlDbType.Int, 4), new SqlParameter("@goods_sn", SqlDbType.VarChar, 100), new SqlParameter("@goods_name", SqlDbType.VarChar, 500), new SqlParameter("@goods_name_style", SqlDbType.VarChar, 100), new SqlParameter("@click_count", SqlDbType.Int, 4), new SqlParameter("@brand_id", SqlDbType.Int, 4), new SqlParameter("@provider_name", SqlDbType.VarChar, 100), new SqlParameter("@goods_number", SqlDbType.Int, 4), new SqlParameter("@goods_weight", SqlDbType.Int, 4), new SqlParameter("@market_price", SqlDbType.Int, 4), new SqlParameter("@shop_price", SqlDbType.Int, 4), new SqlParameter("@promote_price", SqlDbType.Int, 4), new SqlParameter("@promote_start_date", SqlDbType.DateTime), new SqlParameter("@promote_end_date", SqlDbType.DateTime), new SqlParameter("@warn_number", SqlDbType.Int, 4), new SqlParameter("@keywords", SqlDbType.VarChar, 500), new SqlParameter("@goods_brief", SqlDbType.VarChar, 500), new SqlParameter("@goods_desc", SqlDbType.Text), new SqlParameter("@goods_thumb", SqlDbType.VarChar, 500), new SqlParameter("@goods_img", SqlDbType.VarChar, 500), new SqlParameter("@original_img", SqlDbType.VarChar, 500), new SqlParameter("@is_real", SqlDbType.Int, 4), new SqlParameter("@extension_code", SqlDbType.VarChar, 100), new SqlParameter("@is_on_sale", SqlDbType.Int, 4), new SqlParameter("@is_alone_sale", SqlDbType.Int, 4), new SqlParameter("@integral", SqlDbType.Int, 4), new SqlParameter("@add_time", SqlDbType.DateTime), new SqlParameter("@is_delete", SqlDbType.Int, 4), new SqlParameter("@is_best", SqlDbType.Int, 4), new SqlParameter("@is_hot", SqlDbType.Int, 4), new SqlParameter("@is_promote", SqlDbType.Int, 4), new SqlParameter("@last_update", SqlDbType.DateTime), new SqlParameter("@ClassKind", SqlDbType.Int, 4), new SqlParameter("@give_integral", SqlDbType.Int, 4), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.goods_type; parameters[1].Value = model.goods_sn; parameters[2].Value = model.goods_name; parameters[3].Value = model.goods_name_style; parameters[4].Value = model.click_count; parameters[5].Value = model.brand_id; parameters[6].Value = model.provider_name; parameters[7].Value = model.goods_number; parameters[8].Value = model.goods_weight; parameters[9].Value = model.market_price; parameters[10].Value = model.shop_price; parameters[11].Value = model.promote_price; parameters[12].Value = model.promote_start_date; parameters[13].Value = model.promote_end_date; parameters[14].Value = model.warn_number; parameters[15].Value = model.keywords; parameters[16].Value = model.goods_brief; parameters[17].Value = model.goods_desc; parameters[18].Value = model.goods_thumb; parameters[19].Value = model.goods_img; parameters[20].Value = model.original_img; parameters[21].Value = model.is_real; parameters[22].Value = model.extension_code; parameters[23].Value = model.is_on_sale; parameters[24].Value = model.is_alone_sale; parameters[25].Value = model.integral; parameters[26].Value = model.add_time; parameters[27].Value = model.is_delete; parameters[28].Value = model.is_best; parameters[29].Value = model.is_hot; parameters[30].Value = model.is_promote; parameters[31].Value = model.last_update; parameters[32].Value = model.classkind; parameters[33].Value = model.give_integral; parameters[34].Value = model.Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }