/// <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);
}
}
