/// <summary> /// 初始化 /// </summary> protected void chushi() { DataSet dstid = bll2.GetAllList(); ddltid.DataSource = dstid; ddltid.DataTextField = "tname"; ddltid.DataValueField = "tid"; ddltid.DataBind(); //根据编号得到相应的记录 DataSet ds = bll.GetList(" nid=" + Request.QueryString["id"]); if (ds.Tables[0].Rows.Count > 0) { txt_title.Text = ds.Tables[0].Rows[0]["title"].ToString(); ddltid.SelectedValue = ds.Tables[0].Rows[0]["tid"].ToString(); Labelbgpic.Text = ds.Tables[0].Rows[0]["bgpic"].ToString(); if (Labelbgpic.Text != "" && Labelbgpic.Text.Length > 3) { Imagepic.ImageUrl = "../../uploads/" + Labelbgpic.Text; Imagepic.Visible = true; } Textarea1.Value = ds.Tables[0].Rows[0]["memo"].ToString(); } }
//初始化 private void ShowInfo() { if (Request.QueryString["id"] != null) { SP.BLL.news bll = new SP.BLL.news(); //根据编号得到相应的记录 DataSet ds = bll.GetList(" nid=" + Request.QueryString["id"]); if (ds.Tables[0].Rows.Count > 0) { DataRow sdr = ds.Tables[0].Rows[0]; lbltitle.Text = sdr["title"].ToString(); lblmemo.Text = sdr["memo"].ToString(); lblatime.Text = sdr["atime"].ToString(); } } }
/// <summary> /// 绑定 /// </summary> private void bind() { string where = " 1=1 "; if (txt_title.Text != "") { where += " and title like '%" + txt_title.Text + "%' "; } if (ddltid.SelectedValue != "") { where += " and a.tid=" + ddltid.SelectedValue + ""; } GridView1.DataSource = bll.GetList(where + " order by nid desc"); GridView1.DataBind(); }
//初始化 private void ShowInfo() { if (Request.QueryString["id"] != null) { SP.BLL.news bll = new SP.BLL.news(); //根据编号得到相应的记录 DataSet ds = bll.GetList(" nid=" + Request.QueryString["id"]); SP.Model.news model = bll.GetModel(int.Parse(Request.QueryString["id"])); if (ds.Tables[0].Rows.Count > 0) { DataRow sdr = ds.Tables[0].Rows[0]; lblnid.Text = sdr["nid"].ToString(); lbltitle.Text = sdr["title"].ToString(); lbltid.Text = sdr["tname"].ToString(); imgbgpic.ImageUrl = "../../uploads/" + model.bgpic; lblmemo.Text = sdr["memo"].ToString(); lblatime.Text = sdr["atime"].ToString(); } } }