/// <summary> /// 更新一条数据 /// </summary> public bool Update(XHD.Model.shop_cart model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update shop_cart set "); strSql.Append("user_id=@user_id,"); strSql.Append("goods_id=@goods_id,"); strSql.Append("goods_name=@goods_name,"); strSql.Append("goods_img=@goods_img,"); strSql.Append("goods_num=@goods_num,"); strSql.Append("goods_price=@goods_price,"); strSql.Append("is_shipping=@is_shipping,"); strSql.Append("goods_sn=@goods_sn,"); strSql.Append("shipping_fee_price=@shipping_fee_price,"); strSql.Append("goods_unit=@goods_unit,"); strSql.Append("goods_weight=@goods_weight,"); strSql.Append("goods_attr=@goods_attr"); strSql.Append(" where cart_id=@cart_id "); MySqlParameter[] parameters = { new MySqlParameter("@user_id", MySqlDbType.Int32, 11), new MySqlParameter("@goods_id", MySqlDbType.Int32, 11), new MySqlParameter("@goods_name", MySqlDbType.VarChar, 120), new MySqlParameter("@goods_img", MySqlDbType.VarChar, 255), new MySqlParameter("@goods_num", MySqlDbType.Int32, 11), new MySqlParameter("@goods_price", MySqlDbType.Decimal, 12), new MySqlParameter("@is_shipping", MySqlDbType.Int32, 4), new MySqlParameter("@goods_sn", MySqlDbType.VarChar, 55), new MySqlParameter("@shipping_fee_price", MySqlDbType.Decimal, 10), new MySqlParameter("@goods_unit", MySqlDbType.VarChar, 20), new MySqlParameter("@goods_weight", MySqlDbType.Double), new MySqlParameter("@goods_attr", MySqlDbType.Text), new MySqlParameter("@cart_id", MySqlDbType.Int32, 11) }; parameters[0].Value = model.user_id; parameters[1].Value = model.goods_id; parameters[2].Value = model.goods_name; parameters[3].Value = model.goods_img; parameters[4].Value = model.goods_num; parameters[5].Value = model.goods_price; parameters[6].Value = model.is_shipping; parameters[7].Value = model.goods_sn; parameters[8].Value = model.shipping_fee_price; parameters[9].Value = model.goods_unit; parameters[10].Value = model.goods_weight; parameters[11].Value = model.goods_attr; parameters[12].Value = model.cart_id; int rows = Shop_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(XHD.Model.shop_cart model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into shop_cart("); strSql.Append("cart_id,user_id,goods_id,goods_name,goods_img,goods_num,goods_price,is_shipping,goods_sn,shipping_fee_price,goods_unit,goods_weight,goods_attr)"); strSql.Append(" values ("); strSql.Append("@cart_id,@user_id,@goods_id,@goods_name,@goods_img,@goods_num,@goods_price,@is_shipping,@goods_sn,@shipping_fee_price,@goods_unit,@goods_weight,@goods_attr)"); MySqlParameter[] parameters = { new MySqlParameter("@cart_id", MySqlDbType.Int32, 11), new MySqlParameter("@user_id", MySqlDbType.Int32, 11), new MySqlParameter("@goods_id", MySqlDbType.Int32, 11), new MySqlParameter("@goods_name", MySqlDbType.VarChar, 120), new MySqlParameter("@goods_img", MySqlDbType.VarChar, 255), new MySqlParameter("@goods_num", MySqlDbType.Int32, 11), new MySqlParameter("@goods_price", MySqlDbType.Decimal, 12), new MySqlParameter("@is_shipping", MySqlDbType.Int32, 4), new MySqlParameter("@goods_sn", MySqlDbType.VarChar, 55), new MySqlParameter("@shipping_fee_price", MySqlDbType.Decimal, 10), new MySqlParameter("@goods_unit", MySqlDbType.VarChar, 20), new MySqlParameter("@goods_weight", MySqlDbType.Double), new MySqlParameter("@goods_attr", MySqlDbType.Text) }; parameters[0].Value = model.cart_id; parameters[1].Value = model.user_id; parameters[2].Value = model.goods_id; parameters[3].Value = model.goods_name; parameters[4].Value = model.goods_img; parameters[5].Value = model.goods_num; parameters[6].Value = model.goods_price; parameters[7].Value = model.is_shipping; parameters[8].Value = model.goods_sn; parameters[9].Value = model.shipping_fee_price; parameters[10].Value = model.goods_unit; parameters[11].Value = model.goods_weight; parameters[12].Value = model.goods_attr; int rows = Shop_DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XHD.Model.shop_cart GetModel(int cart_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select cart_id,user_id,goods_id,goods_name,goods_img,goods_num,goods_price,is_shipping,goods_sn,shipping_fee_price,goods_unit,goods_weight,goods_attr from shop_cart "); strSql.Append(" where cart_id=@cart_id "); MySqlParameter[] parameters = { new MySqlParameter("@cart_id", MySqlDbType.Int32, 11) }; parameters[0].Value = cart_id; XHD.Model.shop_cart model = new XHD.Model.shop_cart(); DataSet ds = Shop_DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public XHD.Model.shop_cart DataRowToModel(DataRow row) { XHD.Model.shop_cart model = new XHD.Model.shop_cart(); if (row != null) { if (row["cart_id"] != null && row["cart_id"].ToString() != "") { model.cart_id = int.Parse(row["cart_id"].ToString()); } if (row["user_id"] != null && row["user_id"].ToString() != "") { model.user_id = int.Parse(row["user_id"].ToString()); } if (row["goods_id"] != null && row["goods_id"].ToString() != "") { model.goods_id = int.Parse(row["goods_id"].ToString()); } if (row["goods_name"] != null) { model.goods_name = row["goods_name"].ToString(); } if (row["goods_img"] != null) { model.goods_img = row["goods_img"].ToString(); } if (row["goods_num"] != null && row["goods_num"].ToString() != "") { model.goods_num = int.Parse(row["goods_num"].ToString()); } if (row["goods_price"] != null && row["goods_price"].ToString() != "") { model.goods_price = decimal.Parse(row["goods_price"].ToString()); } if (row["is_shipping"] != null && row["is_shipping"].ToString() != "") { model.is_shipping = int.Parse(row["is_shipping"].ToString()); } if (row["goods_sn"] != null) { model.goods_sn = row["goods_sn"].ToString(); } if (row["shipping_fee_price"] != null && row["shipping_fee_price"].ToString() != "") { model.shipping_fee_price = decimal.Parse(row["shipping_fee_price"].ToString()); } if (row["goods_unit"] != null) { model.goods_unit = row["goods_unit"].ToString(); } if (row["goods_weight"] != null && row["goods_weight"].ToString() != "") { model.goods_weight = double.Parse(row["goods_weight"].ToString()); } if (row["goods_attr"] != null) { model.goods_attr = row["goods_attr"].ToString(); } } return(model); }