/// <summary>
/// 跟据ProductId查询规格
/// </summary>
/// <param name="ProductId">商品ID</param>
/// <returns></returns>
public List<ShowShop.Model.Product.ProductSparepart> GetSparepart(int ProductId)
{
List<ShowShop.Model.Product.ProductSparepart> list = new List<ShowShop.Model.Product.ProductSparepart>();
StringBuilder strSql = new StringBuilder();
strSql.Append(this.SelectSequel);
strSql.Append(" where ProductId=@ProductId");
SqlParameter[] parameters ={
new SqlParameter("@ProductId", SqlDbType.Int,4)};
parameters[0].Value = ProductId;
DataSet ds = ChangeHope.DataBase.SQLServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count;i++ )
{
ShowShop.Model.Product.ProductSparepart model = new ShowShop.Model.Product.ProductSparepart();
if (ds.Tables[0].Rows[i]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[i]["Id"].ToString());
}
if (ds.Tables[0].Rows[i]["ProductId"].ToString() != "")
{
model.ProductId = int.Parse(ds.Tables[0].Rows[i]["ProductId"].ToString());
}
model.SparepartName = ds.Tables[0].Rows[i]["SparepartName"].ToString();
if (ds.Tables[0].Rows[i]["BuyMinCount"].ToString() != "")
{
model.BuyMinCount = int.Parse(ds.Tables[0].Rows[i]["BuyMinCount"].ToString());
}
if (ds.Tables[0].Rows[i]["BuyMaxCount"].ToString() != "")
{
model.BuyMaxCount = int.Parse(ds.Tables[0].Rows[i]["BuyMaxCount"].ToString());
}
if (ds.Tables[0].Rows[i]["FavourableType"].ToString() != "")
{
model.FavourableType = int.Parse(ds.Tables[0].Rows[i]["FavourableType"].ToString());
}
if (ds.Tables[0].Rows[i]["FavourableLimit"].ToString() != "")
{
model.FavourableLimit = decimal.Parse(ds.Tables[0].Rows[i]["FavourableLimit"].ToString());
}
model.SparepartProduct = ds.Tables[0].Rows[i]["SparepartProduct"].ToString();
list.Add(model);
}
}
return list;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ShowShop.Model.Product.ProductSparepart GetModelID(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(this.SelectSequel);
strSql.Append(this.UpdateWhereSequel);
SqlParameter[] parameters = (SqlParameter[])this.ValueIDPara(id);
ShowShop.Model.Product.ProductSparepart model = new ShowShop.Model.Product.ProductSparepart();
DataSet ds = ChangeHope.DataBase.SQLServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["ProductId"].ToString() != "")
{
model.ProductId = int.Parse(ds.Tables[0].Rows[0]["ProductId"].ToString());
}
model.SparepartName = ds.Tables[0].Rows[0]["SparepartName"].ToString();
if (ds.Tables[0].Rows[0]["BuyMinCount"].ToString() != "")
{
model.BuyMinCount = int.Parse(ds.Tables[0].Rows[0]["BuyMinCount"].ToString());
}
if (ds.Tables[0].Rows[0]["BuyMaxCount"].ToString() != "")
{
model.BuyMaxCount = int.Parse(ds.Tables[0].Rows[0]["BuyMaxCount"].ToString());
}
if (ds.Tables[0].Rows[0]["FavourableType"].ToString() != "")
{
model.FavourableType = int.Parse(ds.Tables[0].Rows[0]["FavourableType"].ToString());
}
if (ds.Tables[0].Rows[0]["FavourableLimit"].ToString() != "")
{
model.FavourableLimit = decimal.Parse(ds.Tables[0].Rows[0]["FavourableLimit"].ToString());
}
model.SparepartProduct = ds.Tables[0].Rows[0]["SparepartProduct"].ToString();
return model;
}
else
{
return null;
}
}
