918博天堂

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

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

public partial class platform : System.Web.UI.Page
{
    C c = new C();
    DataSet ds = new DataSet();
    public int mid, cid = 0;
    public string webSite, tagTitle,webTitle, contText, contImages, banner_url = "";

    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 == "cid")
            {
                var midStr = Request.QueryString["cid"].ToString();
                var isTrySuccess = int.TryParse(midStr, out cid);
                if (!isTrySuccess)
                {
                    Response.Redirect("/");
                }
            }
        }

        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)
            {
                tagTitle = ds.Tables[0].Rows[0]["MenuSys1"].ToString();
                webSite = ds.Tables[0].Rows[0]["Expr1"].ToString();
                banner_url = ds.Tables[0].Rows[0]["link2"].ToString();
            }
        }

        string classSQL = "SELECT * FROM ClassSys WHERE ClassSys4 = (SELECT TOP 1 c.ClassSys4 FROM ClassSys c INNER JOIN product p ON c.ClassSys0 = p.product5 WHERE p.product9 = " + mid + ") ORDER BY ClassSys3";
        ds = c.GetDs(classSQL);
        if (ds.Tables.Count > 0)
        {
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (cid == 0) cid = int.Parse(ds.Tables[0].Rows[0][0].ToString());
                Repeater1.DataSource = ds.Tables[0];
                Repeater1.DataBind();
            }
        }

        //新闻列表
        string sql = "select top 1 * from product where product9=@mid and product5=@cid order by product7 desc;";
        SqlParameter[] ps = new SqlParameter[]{
                    new SqlParameter("@mid",mid),
                    new SqlParameter("@cid",cid),
                };
        ds = MyFunction.Query(sql, ps);
        if (ds.Tables.Count > 0)
        {
            if (ds.Tables[0].Rows.Count > 0)
            {
                webTitle = ds.Tables[0].Rows[0]["product1"].ToString();
                contText = ds.Tables[0].Rows[0]["product8"].ToString();

                var imgs = ds.Tables[0].Rows[0]["product4"].ToString();
                if (!string.IsNullOrWhiteSpace(imgs))
                {
                    foreach (var item in imgs.Split('|'))
                    {
                        contImages += "<div class=\"img\"><img src=\"" + item + "\" alt=\"\"></div>";
                    }
                }
            }
        }

        this.Title = webTitle + " - " + Application["sysset1"].ToString();
    }

}

#line default
#line hidden