public int InsertGoodsClass(TaoBaoGoodsClassInfo info, string nick)
{
SqlParameter[] param = new[]
{
new SqlParameter("@CateId", info.cid),
new SqlParameter("@CateName", info.name),
new SqlParameter("@ParentId", info.parent_cid),
new SqlParameter("@Nick", nick)
};
return(DBHelper.ExecuteNonQuery(SQL_INSERT, param));
}
public TaoBaoGoodsClassInfo SelectGoodsClass(string cid)
{
TaoBaoGoodsClassInfo info = null;
DataTable dt = DBHelper.ExecuteDataTable(SQL_SELECT_GOODSCLASS_BYID, new SqlParameter("@cid", cid));
foreach (DataRow dr in dt.Rows)
{
info = new TaoBaoGoodsClassInfo();
info.name = dr["name"].ToString();
info.is_parent = (bool)dr["is_parent"];
info.parent_cid = dr["parent_cid"].ToString();
}
return(info);
}
public IList <TaoBaoGoodsClassInfo> SelectAllGoodsClass(string parid)
{
IList <TaoBaoGoodsClassInfo> list = new List <TaoBaoGoodsClassInfo>();
DataTable dt = DBHelper.ExecuteDataTable(SQL_SELECT_GOODSCLASS_BYPARENTID, new SqlParameter("@cid", parid));
foreach (DataRow dr in dt.Rows)
{
TaoBaoGoodsClassInfo info = new TaoBaoGoodsClassInfo();
info = new TaoBaoGoodsClassInfo();
info.name = dr["name"].ToString();
info.is_parent = (bool)dr["is_parent"];
info.parent_cid = dr["parent_cid"].ToString();
info.cid = dr["CId"].ToString();
list.Add(info);
}
return(list);
}
