/// <summary> /// 增加一条数据 /// </summary> public int Add(Shop.Model.Goods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_goods("); strSql.Append("smallid,gname,descript,goodsphoto,goodsprice,hot,hottime,specialprice,specialpricetime,bigname,smallname,stock,gview,gcount,gtime)"); strSql.Append(" values ("); strSql.Append("@smallid,@gname,@descript,@goodsphoto,@goodsprice,@hot,@hottime,@specialprice,@specialpricetime,@bigname,@smallname,@stock,@gview,@gcount,@gtime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@smallid", SqlDbType.Int, 4), new SqlParameter("@gname", SqlDbType.VarChar, 50), new SqlParameter("@descript", SqlDbType.VarChar, 100), new SqlParameter("@goodsphoto", SqlDbType.VarChar, 100), new SqlParameter("@goodsprice", SqlDbType.Float, 8), new SqlParameter("@hot", SqlDbType.Int, 4), new SqlParameter("@hottime", SqlDbType.DateTime), new SqlParameter("@specialprice", SqlDbType.Int, 4), new SqlParameter("@specialpricetime", SqlDbType.DateTime), new SqlParameter("@bigname", SqlDbType.VarChar, 20), new SqlParameter("@smallname", SqlDbType.VarChar, 20), new SqlParameter("@stock", SqlDbType.Int, 4), new SqlParameter("@gview", SqlDbType.Int, 4), new SqlParameter("@gcount", SqlDbType.Int, 4), new SqlParameter("@gtime", SqlDbType.DateTime) }; parameters[0].Value = model.smallid; parameters[1].Value = model.gname; parameters[2].Value = model.descript; parameters[3].Value = model.goodsphoto; parameters[4].Value = model.goodsprice; parameters[5].Value = model.hot; parameters[6].Value = model.hottime; parameters[7].Value = model.specialprice; parameters[8].Value = model.specialpricetime; parameters[9].Value = model.bigname; parameters[10].Value = model.smallname; parameters[11].Value = model.stock; parameters[12].Value = model.gview; parameters[13].Value = model.gcount; parameters[14].Value = model.gtime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
///三表查询结果转实体 public Shop.Model.Goods DataRowToGoodsModel(DataRow row) { Shop.Model.Goods model = new Shop.Model.Goods(); if (row != null) { if (row["gid"] != null && row["gid"].ToString() != "") { model.gid = int.Parse(row["gid"].ToString()); } if (row["gname"] != null) { model.gname = row["gname"].ToString(); } if (row["descript"] != null) { model.descript = row["descript"].ToString(); } if (row["goodsphoto"] != null) { model.goodsphoto = row["goodsphoto"].ToString(); } if (row["goodsprice"] != null && row["goodsprice"].ToString() != "") { model.goodsprice = decimal.Parse(row["goodsprice"].ToString()); } if (row["specialprice"] != null && row["specialprice"].ToString() != "") { model.specialprice = int.Parse(row["specialprice"].ToString()); } if (row["hot"] != null && row["hot"].ToString() != "") { model.hot = int.Parse(row["hot"].ToString()); } if (row["smallname"] != null) { model.smallname = row["smallname"].ToString(); } if (row["bigname"] != null) { model.bigname = row["bigname"].ToString(); } if (row["stock"] != null && row["stock"].ToString() != "") { model.stock = int.Parse(row["stock"].ToString()); } if (row["gview"] != null && row["gview"].ToString() != "") { model.gview = int.Parse(row["gview"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Shop.Model.Goods GetModel(int gid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 gid,smallid,gname,descript,goodsphoto,goodsprice,hot,hottime,specialprice,specialpricetime,bigname,smallname,stock,gview,gcount,gtime from t_goods "); strSql.Append(" where gid=@gid"); SqlParameter[] parameters = { new SqlParameter("@gid", SqlDbType.Int, 4) }; parameters[0].Value = gid; Shop.Model.Goods model = new Shop.Model.Goods(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Shop.Model.Goods model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_goods set "); strSql.Append("gname=@gname,"); strSql.Append("descript=@descript,"); strSql.Append("goodsphoto=@goodsphoto,"); strSql.Append("goodsprice=@goodsprice,"); strSql.Append("hot=@hot,"); strSql.Append("hottime=@hottime,"); strSql.Append("specialprice=@specialprice,"); strSql.Append("specialpricetime=@specialpricetime,"); strSql.Append("bigname=@bigname,"); strSql.Append("smallname=@smallname,"); strSql.Append("stock=@stock,"); strSql.Append("gview=@gview,"); strSql.Append("gcount=@gcount,"); strSql.Append("gtime=@gtime"); strSql.Append(" where gid=@gid"); SqlParameter[] parameters = { new SqlParameter("@gname", SqlDbType.VarChar, 50), new SqlParameter("@descript", SqlDbType.VarChar, 100), new SqlParameter("@goodsphoto", SqlDbType.VarChar, 100), new SqlParameter("@goodsprice", SqlDbType.Float, 8), new SqlParameter("@hot", SqlDbType.Int, 4), new SqlParameter("@hottime", SqlDbType.DateTime), new SqlParameter("@specialprice", SqlDbType.Int, 4), new SqlParameter("@specialpricetime", SqlDbType.DateTime), new SqlParameter("@bigname", SqlDbType.VarChar, 20), new SqlParameter("@smallname", SqlDbType.VarChar, 20), new SqlParameter("@stock", SqlDbType.Int, 4), new SqlParameter("@gview", SqlDbType.Int, 4), new SqlParameter("@gcount", SqlDbType.Int, 4), new SqlParameter("@gtime", SqlDbType.DateTime), new SqlParameter("@gid", SqlDbType.Int, 4), new SqlParameter("@smallid", SqlDbType.Int, 4) }; parameters[0].Value = model.gname; parameters[1].Value = model.descript; parameters[2].Value = model.goodsphoto; parameters[3].Value = model.goodsprice; parameters[4].Value = model.hot; parameters[5].Value = model.hottime; parameters[6].Value = model.specialprice; parameters[7].Value = model.specialpricetime; parameters[8].Value = model.bigname; parameters[9].Value = model.smallname; parameters[10].Value = model.stock; parameters[11].Value = model.gview; parameters[12].Value = model.gcount; parameters[13].Value = model.gtime; parameters[14].Value = model.gid; parameters[15].Value = model.smallid; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }