918博天堂

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

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

public partial class product : System.Web.UI.Page
{
    C c = new C();
    DataSet ds = new DataSet();
    public int mid, cid = 0;
    public int menuid, firstmid = 0;
    public string webSite, webTitel, banner_url, NavHtml, ProHtml = "";
    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 == "cid")
            {
                var midStr = Request.QueryString["cid"].ToString();
                var isTrySuccess = int.TryParse(midStr, out cid);
                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", 165) });
        if (ds.Tables.Count > 0)
        {
            if (ds.Tables[0].Rows.Count > 0)
            {
                webTitel = 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 = webSite + " - " + Application["sysset1"].ToString();

        //菜单导航
        string classSQL = "select * from menusys where menusys3=185 and MenuSys11=0 and (MenuSys13<>'none' or MenuSys13 is null) and MenuSys9< >'resume' and MenuSys2 <> N'classsys/' order by menusys4";
        ds = c.GetDs(classSQL);
        if (ds.Tables.Count > 0)
        {
            var table = ds.Tables[0];
            var count = table.Rows.Count;
            if (count > 0)
            {
                StringBuilder @string = new StringBuilder();

                for (int i = 0; i < count; i++)
                {
                    var currentMid = table.Rows[i]["menusys0"].ToString();
                    if ((mid == 165 && i == 0) || mid.ToString() == currentMid)
                        @string.AppendLine("<div class=\"button active\"><a href=\"product.aspx?mid=" + currentMid + "\">" + table.Rows[i]["menusys1"].ToString() + "</a></div>");
                    else
                        @string.AppendLine("<div class=\"button\"><a href=\"product.aspx?mid=" + currentMid + "\">" + table.Rows[i]["menusys1"].ToString() + "</a></div>");
                }

                NavHtml = @string.ToString();
            }
        }


        //患者关系 
        if (mid == 198)
        {
            if (string.IsNullOrWhiteSpace(serachVal))
                ds = MyFunction.Query("SELECT * FROM product WHERE product9 = @mid ORDER BY ISNULL(product10, 0) DESC,product7 DESC;", new SqlParameter[] { new SqlParameter("@mid", mid) });
            else
                ds = MyFunction.Query("SELECT * FROM product WHERE product9 = @mid and (charindex(@key, product1)> 0 or charindex(@key, product3)> 0 or charindex(@key, product4)> 0) ORDER BY ISNULL(product10, 0) DESC,product7 DESC;", new SqlParameter[] {
                    new SqlParameter("@mid", mid),
                    new SqlParameter("@key",serachVal)
                });

            if (ds.Tables.Count > 0)
            {
                if (ds.Tables[0].Rows.Count > 0)
                {
                    Rep_Product_198.DataSource = ds.Tables[0];
                    Rep_Product_198.DataBind();
                }
            }
        }
        else
        {

            ProHtml = MyFunction.gerProductInfo("");

        }
    }



}

#line default
#line hidden