918博天堂

?#pragma checksum "D:\wwwroot\klbttc\wwwroot\newsCenter.aspx.cs" "{ff1816ec-aa5e-4d10-87f7-6f4963833460}" "06EF73B818717723672113B6EA91C1D813462BD0"

#line 1 "D:\wwwroot\klbttc\wwwroot\newsCenter.aspx.cs"
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class newsCenter : System.Web.UI.Page
{
    C c = new C();
    DataSet ds = new DataSet();
    public int mid = 18;
    public string webSite, webTitle, banner_url, EngName = "";
    public string serachVal = string.Empty;
    public bool flag1 = true;

    protected void Page_Load(object sender, EventArgs e)
    {
        var reqParam = Request.QueryString;
        foreach (var item in reqParam.AllKeys)
        {
            if (item == "mid")
            {
                var midStr = Request.QueryString["mid"].ToString();
                var isTrySuccess = int.TryParse(midStr, out mid);
                if (!isTrySuccess)
                {
                    Response.Redirect("/");
                }
            }
            if (item == "sv")
            {
                serachVal = Request.QueryString["sv"].ToString();
            }
        }

        ds = MyFunction.Query("SELECT MenuSys_1.MenuSys1 AS Expr1, MenuSys.*,MenuSys_1.MenuSys0 AS Expr3,l.link2 FROM MenuSys INNER JOIN     MenuSys MenuSys_1 ON     MenuSys.MenuSys3 = MenuSys_1.MenuSys0 LEFT JOIN link l ON l.link1 = MenuSys_1.MenuSys1 AND l.link5 = 67 WHERE  (MenuSys.MenuSys0 =@mid)", new SqlParameter[] { new SqlParameter("@mid", mid) });
        if (ds.Tables.Count > 0)
        {
            if (ds.Tables[0].Rows.Count > 0)
            {
                webTitle = ds.Tables[0].Rows[0]["MenuSys1"].ToString();
                webSite = ds.Tables[0].Rows[0]["Expr1"].ToString();
                banner_url = ds.Tables[0].Rows[0]["link2"].ToString();
            }
        }
        this.Title = (mid != 1 ? webSite : "搜索列表") + " - " + Application["sysset1"].ToString();

        //新闻中心
        if (string.IsNullOrWhiteSpace(serachVal))
        {
            string sql = @"select top 9 * from news where news9=@mid and news4<>'' order by isnull(news10,0) desc,news7 desc";
            SqlParameter[] ps = new SqlParameter[] { new SqlParameter("@mid", mid) };
            ds = MyFunction.Query(sql, ps);
            if (ds.Tables.Count > 0)
            {
                if (ds.Tables[0].Rows.Count > 0)
                {
                    Rep_NewsImg_18.DataSource = ds.Tables[0];
                    Rep_NewsImg_18.DataBind();
                }
            }
        }
        else
        {
            this.search_news_close_img.Visible = false;
        }

        if (string.IsNullOrWhiteSpace(serachVal))
            ds = MyFunction.Query("select * from news where news9=@mid order by news7 desc", new SqlParameter[] { new SqlParameter("@mid", mid) });
        else
            ds = MyFunction.Query("select * from news where news9=@mid and charindex(@key, news1)> 0 order by news7 desc", new SqlParameter[] { new SqlParameter("@mid", mid), new SqlParameter("@key", serachVal) });

        if (ds.Tables.Count > 0)
        {
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows.Count < Pager.PageSize)
                {
                    Pager.Visible = false;
                }
                Pager.TableSource = ds.Tables[0];
                Rep_News_List_18.DataSource = Pager.DataSource;
                Rep_News_List_18.DataBind();
            }
            else
            {
                Pager.Visible = false;
            }
        }
    }

}

#line default
#line hidden