/// <summary>
/// 产品详情页
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ProductDetail GetProDetail(string id, int ptype = 0)
{
ProductDetail proDetail = new ProductDetail();
// string sql = "select a.*,c.CategoryName,b.BrandName,b.Describe as BrandDescribe from Parts a left join PartsCategory c on a.CategoryID=c.ID left join PartBrand b on a.PartBrand=b.ID where a.ID={0} ";
string sql = "select a.*,b.BrandName,b.Describe as BrandDescribe from Parts a left join PartBrand b on a.PartBrand=b.ID where a.ID={0} and a.ProType={1} ";
ProDetail model = db.Database.SqlQuery <ProDetail>(string.Format(sql, id, ptype)).FirstOrDefault();
proDetail.proDetail = model;
string PartComm = " select s.mentsname,m.wxHeadimgurl,m.LoginName from comments s left join MemberBase m on s.userID= m.ID where ProductID={0}";
List <CommList> commlists = db.Database.SqlQuery <CommList>(string.Format(PartComm, id)).ToList();
proDetail.commList = commlists;
string imgSql = " select * from ImgStock where PartID={0} ";
List <DAO.ImgStock> imgList = db.Database.SqlQuery <DAO.ImgStock>(string.Format(imgSql, id)).ToList();
proDetail.imgStock = imgList;
//string attSql = " select * from PartsExtend where PartID={0} and State=1 ";
//List<DAO.PartsExtend> attList = db.Database.SqlQuery<DAO.PartsExtend>(string.Format(attSql, id)).ToList();
//proDetail.partExt = attList;
string CSql = " select * from PartsCategory where ID={0} and IsShow=1 ";
DAO.PartsCategory pc = db.Database.SqlQuery <DAO.PartsCategory>(string.Format(CSql, model.CategoryID)).FirstOrDefault();
proDetail.partCate = pc;
string PartStockSql = " select * from PartStock where PartID={0}";
DAO.PartStock PartStockList = db.Database.SqlQuery <DAO.PartStock>(string.Format(PartStockSql, id)).FirstOrDefault();
proDetail.partStockList = PartStockList;
List <PartAttrOutModel> attlist = GetExtends(int.Parse(id));
proDetail.partExt = attlist;
string carSql = "select * from CarM where id in ({0}) ";
if (model.ToCars != "*")
{
string strTocar = model.ToCars.Replace(",,", ",");
strTocar = strTocar.Substring(1, strTocar.Length - 2);
List <DAO.CarM> carList = db.Database.SqlQuery <DAO.CarM>(string.Format(carSql, strTocar)).ToList();
proDetail.carList = carList;
}
else
{
proDetail.carList = null;
}
//partBrand
return(proDetail);
}
public DAO.PartStock getPartStock(int id)
{
DAO.PartStock opList = db.PartStock.Where(m => m.PartID == id).FirstOrDefault();
return(opList);
}
