public void dataload()
{
//商品信息
molgoodsinfo = bllgoodsinfo.GetModel(int.Parse(Request["id"]));
Label1.Text = molgoodsinfo.Goods_name;
lblgoods_name.Text = molgoodsinfo.Goods_name;
lblgoods_info.Text = molgoodsinfo.Goods_info;
lblgoods_Marketprice.Text = molgoodsinfo.Market_price.ToString();
lblgoods_Stock.Text = molgoodsinfo.Stock.ToString();
lblgoods_GBprice.Text = molgoodsinfo.In_store_price.ToString();
lblgoods_salesnum.Text = molgoodsinfo.Sales_volume.ToString();
lblgoods_id.Text = molshopcar.Goods_ID.ToString();
Goods_img.ImageUrl = molgoodsinfo.Goods_pic;
Goods_img_small.ImageUrl = molgoodsinfo.Goods_pic;
lblgoods_status.Text = molgoodsinfo.GB_Status;
lblgoods_status2.Text = molgoodsinfo.GB_Status;
lblgoods_status3.Text = molgoodsinfo.GB_Status;
if (lblgoods_status2.Text == "火热进行中")
{
string data1 = molgoodsinfo.FinishTime.ToString();
data1 = data1.Replace(" 0:00:00", "");
lblGBSoptime.Text = data1;
lblGBPerNum.Text = molgoodsinfo.GroupPerNum.ToString();
lblNowNum.Text = molgoodsinfo.NowPerNum.ToString();
GBinfoboxcon.Visible = true;
constatusbox2.Visible = true;
Button1.Text = "参与团购";
}
else if (lblgoods_status.Text == "正在热卖中")
{
GBinfoboxcon.Visible = false;
constatusbox.Visible = true;
constatusbox2.Visible = false;
Button1.Text = "加入购物车";
}
else if (lblgoods_status3.Text == "团购已完成")
{
funboxcon.Visible = false;
Button1.Visible = false;
constatusbox.Visible = false;
constatusbox2.Visible = false;
constatusbox3.Visible = true;
}
//商品详细图片
moldetailimg = blldetailimg.GetModel(int.Parse(Request["id"]));
Image1.ImageUrl = moldetailimg.Img_1.ToString();
Image2.ImageUrl = moldetailimg.Img_2.ToString();
lblgoods_noticename.Text = molgoodsinfo.Goods_name;
lblgoods_brand.Text = molgoodsinfo.Good_Brand;
//lblgoods_color.Text = molgoodsinfo.Color;
lblgoods_qqp.Text = molgoodsinfo.Qqp;
lblgoods_size.Text = molgoodsinfo.Size;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TtNum1.Model.SPECIFICATION DataRowToModel(DataRow row)
{
TtNum1.Model.SPECIFICATION model=new TtNum1.Model.SPECIFICATION();
if (row != null)
{
if(row["SPECIFICATION_id"]!=null && row["SPECIFICATION_id"].ToString()!="")
{
model.SPECIFICATION_id=int.Parse(row["SPECIFICATION_id"].ToString());
}
if(row["Img_1"]!=null)
{
model.Img_1=row["Img_1"].ToString();
}
if(row["Img_2"]!=null)
{
model.Img_2=row["Img_2"].ToString();
}
if(row["Img_3"]!=null)
{
model.Img_3=row["Img_3"].ToString();
}
if(row["G_id"]!=null && row["G_id"].ToString()!="")
{
model.G_id=int.Parse(row["G_id"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TtNum1.Model.SPECIFICATION GetModel(int SPECIFICATION_id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ");
strSql.Append(" SPECIFICATION_id,Img_1,Img_2,Img_3,G_id ");
strSql.Append(" from SPECIFICATION ");
strSql.Append(" where G_id="+SPECIFICATION_id+"" );
TtNum1.Model.SPECIFICATION model=new TtNum1.Model.SPECIFICATION();
DataSet ds=DbHelperSQL.Query(strSql.ToString());
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["SPECIFICATION_id"]!=null && ds.Tables[0].Rows[0]["SPECIFICATION_id"].ToString()!="")
{
model.SPECIFICATION_id=int.Parse(ds.Tables[0].Rows[0]["SPECIFICATION_id"].ToString());
}
if(ds.Tables[0].Rows[0]["Img_1"]!=null && ds.Tables[0].Rows[0]["Img_1"].ToString()!="")
{
model.Img_1=ds.Tables[0].Rows[0]["Img_1"].ToString();
}
if(ds.Tables[0].Rows[0]["Img_2"]!=null && ds.Tables[0].Rows[0]["Img_2"].ToString()!="")
{
model.Img_2=ds.Tables[0].Rows[0]["Img_2"].ToString();
}
if(ds.Tables[0].Rows[0]["Img_3"]!=null && ds.Tables[0].Rows[0]["Img_3"].ToString()!="")
{
model.Img_3=ds.Tables[0].Rows[0]["Img_3"].ToString();
}
if(ds.Tables[0].Rows[0]["G_id"]!=null && ds.Tables[0].Rows[0]["G_id"].ToString()!="")
{
model.G_id=int.Parse(ds.Tables[0].Rows[0]["G_id"].ToString());
}
return model;
}
else
{
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TtNum1.Model.SPECIFICATION GetModel(int SPECIFICATION_id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ");
strSql.Append(" SPECIFICATION_id,Img_1,Img_2,Img_3,G_id ");
strSql.Append(" from SPECIFICATION ");
strSql.Append(" where SPECIFICATION_id="+SPECIFICATION_id+"" );
TtNum1.Model.SPECIFICATION model=new TtNum1.Model.SPECIFICATION();
DataSet ds=DbHelperSQL.Query(strSql.ToString());
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
