private void LoadProductDetail(Int32 ID)
{
try
{
DataTable dt = new DataTable();
DAProduct oData = new DAProduct();
// get data
dt.Load(oData.USP_Product_Client_GetByID(ID));
// Lay
if (dt.Rows.Count > 0)
{
imgLink.ImageUrl = "/assets/images/products/pro_M_001.png";
lblProductName.Text = dt.Rows[0]["ProductName"].ToString();
if (dt.Rows[0]["ImgLink1"].ToString() != "")
{
imgLink.ImageUrl = dt.Rows[0]["ImgLink1"].ToString();
}
lblPrice.Text = Convert.ToInt32(dt.Rows[0]["Price"]).ToString("#,##");
//if(dt.Rows[0]["SalePrice"].ToString() != "0")
//{
// lblSalePrice.Text = Convert.ToInt32(dt.Rows[0]["SalePrice"]).ToString("#,##") + " VNĐ";
//}
if (Convert.ToBoolean(dt.Rows[0]["IsHiddenWhenOutoff"]))
{
lblOutofStock.Text = "Hết hàng";
pnlOutofStock.Visible = false;
}
else
{
lblOutofStock.Text = "Còn hàng";
}
lblDescription.Text = dt.Rows[0]["Description"].ToString();
lblPID.Text = ID.ToString();
// Load product relate
DataTable dtDetail = new DataTable();
dtDetail.Load(oData.USP_Product_Client_GetRelatebyID(ID));
rptRelateProduct.DataSource = dtDetail;
rptRelateProduct.DataBind();
}
}
catch
{
}
}
// Hiển thị menu
private void LoadProductDetail(Int32 ID)
{
try
{
DataTable dt = new DataTable();
DAProduct oData = new DAProduct();
// get data
dt.Load(oData.USP_Product_Client_GetByID(ID));
// Lay
if (dt.Rows.Count > 0)
{
lblProductName.Text = dt.Rows[0]["ProductName"].ToString();
lblBrand.Text = dt.Rows[0]["ProducerName"].ToString();
lblSKU.Text = dt.Rows[0]["ProductCode"].ToString();
txtProductID.Text = dt.Rows[0]["ID"].ToString();
//if (dt.Rows[0]["Price"].ToString() == "0")
// lblPrice.Text = "Liên hệ";
//else
// lblPrice.Text = dt.Rows[0]["Price"].ToString() + " VNĐ";
// Load hinh
DataTable dtImg = new DataTable();
dtImg.Columns.Add("id", typeof(int));
dtImg.Columns.Add("Img", typeof(string));
if (dt.Rows[0]["ImgLink1"].ToString() != "")
{
dtImg.Rows.Add(1, dt.Rows[0]["ImgLink1"].ToString());
}
if (dt.Rows[0]["ImgLink2"].ToString() != "")
{
dtImg.Rows.Add(2, dt.Rows[0]["ImgLink2"].ToString());
}
if (dt.Rows[0]["ImgLink3"].ToString() != "")
{
dtImg.Rows.Add(3, dt.Rows[0]["ImgLink3"].ToString());
}
if (dt.Rows[0]["ImgLink4"].ToString() != "")
{
dtImg.Rows.Add(4, dt.Rows[0]["ImgLink4"].ToString());
}
if (dt.Rows[0]["ImgLink5"].ToString() != "")
{
dtImg.Rows.Add(5, dt.Rows[0]["ImgLink5"].ToString());
}
lblDescription.Text = dt.Rows[0]["Description"].ToString();
//sImgSlider = sSlider;
//sImgThumb = sThumb;
rptImgShow.DataSource = dtImg;
rptImgShow.DataBind();
rptImgThumb.DataSource = dtImg;
rptImgThumb.DataBind();
// Load product relate
DataTable dtDetail = new DataTable();
dtDetail.Load(oData.USP_Product_Client_GetRelatebyID(ID));
rptRelateProduct.DataSource = dtDetail;
rptRelateProduct.DataBind();
}
}
catch
{
}
}