5.3.6 实现产品详细信息服务的方法

SELECT Production.Product.ProductID,
Production.Product.Name,
Production.Product.ListPrice,
Production.ProductPhoto.LargePhoto
FROM Production.ProductProductPhoto
INNER JOIN Production.ProductPhoto
ON Production.ProductProductPhoto.ProductPhotoID =
Production.ProductPhoto.ProductPhotoID
INNER JOIN Production.Product
ON Production.ProductProductPhoto.ProductID =
Production.Product.ProductID
WHERE
(Production.Product.ProductID = @ID)

[DataContract()]
public class ProductRecord
{
[DataMember]
public int ID;
[DataMember]
public string Name;
[DataMember]
public string ListPrice;
[DataMember]
public byte[] Photo;
}

public ProductRecord GetProductDetails(string strID)
{
ProductDetailsTableAdapters.DataTable1TableAdapter da =
new Product DetailsTableAdapters.DataTable1TableAdapter();
ProductDetails.DataTable1DataTable dt =
da.GetData(Convert.ToInt16(strID));
ProductRecord pReturn = new ProductRecord();
ProductDetails.DataTable1Row theRow =
(ProductDetails.DataTable1Row)dt. Rows[0];
pReturn.ID = theRow.ProductID;
pReturn.ListPrice = theRow.ListPrice.ToString();
pReturn.Name = theRow.Name;
pReturn.Photo = theRow.LargePhoto;
return pReturn;
}

[ServiceContract()]
public interface IBikeService
{
[OperationContract]
string GetData();
[OperationContract]
ProductRecord GetProductDetails(string strID);
}