protected void Page_Load(object sender, EventArgs e)
{
News.getPics(ref pics, ref texts, ref links);
LanMu.getLanMuIdAndName(ref Id, ref Name);
gvNews.DataSource = SqlHelper.excuteDataSet("select * from t_news order by addTime DESC");
gvNews.DataBind();
gvLanmu1.DataSource = SqlHelper.excuteDataSet("select * from t_news order by addTime DESC");
gvLanmu1.DataBind();
gvLanmu2.DataSource = SqlHelper.excuteDataSet("select * from t_news order by addTime DESC");
gvLanmu2.DataBind();
gvLanmu3.DataSource = SqlHelper.excuteDataSet("select * from t_news order by addTime DESC");
gvLanmu3.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
string url = Request.RawUrl;
int begin = url.IndexOf("=") + 1;
int last = url.Length + 1;
int lanMuiId = Convert.ToInt32(url.Substring(begin, last - begin - 1));
LanMu lan = new LanMu();
lan = LanMu.getLanMuNameById(lanMuiId);
llanMuName.Text = "您现在观看的栏目是：" + lan.lanMuName;
gvLanMuNews.DataSource = SqlHelper.excuteDataSet("select * from t_news where lanMuId=" + lanMuiId + "order by addTime DESC");
gvLanMuNews.DataBind();
}
public static LanMu getLanMuNameById(int id)
{
LanMu l = new LanMu();
string sqlString = "select lanMuName from t_lanMu where lanMuId=" + id;
SqlConnection con = SqlHelper.createCon();
con.Open();
SqlCommand cmd = new SqlCommand(sqlString, con);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
l.lanMuName = Convert.ToString(sdr[0]);
}
con.Close();
return(l);
}
