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; } }