using System;
using System.Data;
using System.Data.SqlClient;
using System.Text;
using System.IO;
using System.Web;
using System.Text.RegularExpressions;

public partial class index_index : System.Web.UI.Page
{
    protected string ln = "";
    protected string cln = "";
    protected string CityName = "";
    protected void Page_Load(object sender, EventArgs e)
    {
        ln = BLLhelp.LanguageNull();
        cln = BLLhelp.Language();
        CityName = OtherPublic.GetCityName();
        BindBanner();
        BindPartner();
        BindPro();
        BindComp();
        BindCase();
        BindNews();
        BindFAQ();
    }

    protected readonly Maticsoft.BLL.publicHelp BLLhelp = new Maticsoft.BLL.publicHelp();
    protected readonly Maticsoft.BLL.XMLHelper XMLhelp = new Maticsoft.BLL.XMLHelper();

    protected StringBuilder lt_Banner = new StringBuilder();
    protected void BindBanner()
    {
        SqlParameter[] parameters = { 
                       new SqlParameter("@fshow",true),
                       new SqlParameter("@cln",cln),
                       new SqlParameter("@ftype","banner")
                                       };
        SqlDataReader odr = BLLhelp.GetList("focus", "fimage,ID,forder,flink,fname", "fshow=@fshow and cln=@cln and ftype=@ftype order by forder asc, ID asc", parameters);
        while (odr.Read())
        {
            lt_Banner.Append("<div class=\"swiper-slide\">");
            lt_Banner.Append("<img class=\"bg\" src=\"" + odr["fimage"].ToString() + "\" />");
            lt_Banner.Append("</div>");
        }
        odr.Dispose();
        odr.Close();
    }

    protected StringBuilder lt_Partner = new StringBuilder();
    protected void BindPartner()
    {
        SqlParameter[] parameters = { 
                       new SqlParameter("@ashow",true),
                       new SqlParameter("@aid","12")
                                       };
        SqlDataReader odr = BLLhelp.GetList("advantage", "aname,aimage", "ashow=@ashow and aid=@aid order by aorder asc, ID asc", parameters);
        while (odr.Read())
        {
            lt_Partner.Append("<li>");
            lt_Partner.Append("<a>");
            lt_Partner.Append("<span><img class=\"trans\" src=\"" + odr["aimage"].ToString() + "\" alt=\"" + odr["aname"].ToString() + "\" /></span>");
            lt_Partner.Append(odr["aname"].ToString());
            lt_Partner.Append("</a>");
            lt_Partner.Append("</li>");
        }
        odr.Dispose();
        odr.Close();
    }

    protected StringBuilder lt_ProTitle = new StringBuilder();
    protected StringBuilder lt_ProNav = new StringBuilder();
    protected StringBuilder lt_ProList = new StringBuilder();
    protected void BindPro()
    {
        string strProTitle = BLLhelp.GetOneField("hlclass", "ctitle", "ID=3", null);
        lt_ProTitle.Append("<a " + OtherPublic.Gethref("3", "pc", OtherPublic.GetCompanyUrl()) + " title=\"" + strProTitle + "\">" + strProTitle + "");
        lt_ProTitle.Append("<span>PRODUCTS</span>");
        lt_ProTitle.Append("</a>");
        SqlParameter[] parameters = { 
                    new SqlParameter("@cshow",true),
                    new SqlParameter("@pid","3"),
                    new SqlParameter("@ctitle" + ln,"")
                                    };
        SqlDataReader odr = BLLhelp.GetList("hlclass", "top 9 ctitle,cclass,ID,ctype,ctarget,cid,(select tpath from pagetype where ttype=hlclass.ctype) as tpath", "cshow=@cshow and pid=@pid and ctitle" + ln + "<>@ctitle" + ln + " order by corder asc,ID asc", parameters);
        while (odr.Read())
        {
            lt_ProNav.Append("<li><a " + BLLhelp.GetClmUrl(odr["ID"].ToString(), odr["ctype"].ToString(), odr["tpath"].ToString(), OtherPublic.GetCompanyUrl()) + " title=\"" + odr["ctitle"].ToString() + "\" target=\"" + odr["ctarget"].ToString() + "\">" + odr["ctitle"].ToString() + "</a></li>");
        }
        odr.Dispose();
        odr.Close();
        string allson = BLLhelp.hlclassGetTypeAllSon("3");
        SqlParameter[] parameters2 = { 
                         new SqlParameter("@pshow",true),
                         new SqlParameter("@cln",cln)
                                     };
        SqlDataReader odr2 = BLLhelp.GetList("product", "top 9 ID,pname,cclass,urlkey,pthumb1", "cclass in (3" + allson + ") and pshow=@pshow and cln=@cln order by porder asc, ID desc", parameters2);
        string strName = "";
        while (odr2.Read())
        {
            strName = OtherPublic.GetArea(odr2["pname"].ToString(), CityName);
            lt_ProList.Append("<li class=\"smove\">\n");
            lt_ProList.Append("<a " + BLLhelp.GetSubUrl(odr2["cclass"].ToString(), "picshow", OtherPublic.GetStrName((odr2["urlkey"].ToString() == "" ? OtherPublic.Pseudo_static(odr2["cclass"].ToString()) : odr2["urlkey"].ToString())), odr2["ID"].ToString(), "pic", OtherPublic.GetCompanyUrl()) + " class=\"smove\" title=\"" + strName + "\">");
            lt_ProList.Append("<span class=\"Pic\"><img class=\"trans\" src=\"" + odr2["pthumb1"].ToString() + "\" alt=\"" + strName + "\" /></span>\n");
            lt_ProList.Append("<span class=\"Tit\">" + strName + "</span>");
            lt_ProList.Append("</a>");
            lt_ProList.Append("</li>\n");
        }
        odr2.Dispose();
        odr2.Close();
    }

    protected StringBuilder lt_Comp = new StringBuilder();
    protected void BindComp()
    {
        string allson = BLLhelp.hlclassGetTypeAllSon("6");
        SqlParameter[] parameters = { 
                         new SqlParameter("@pshow",true),
                         new SqlParameter("@cln",cln)
                                     };
        SqlDataReader odr = BLLhelp.GetList("product", "top 12 ID,pname,cclass,urlkey,pthumb1", "cclass in (6" + allson + ") and pshow=@pshow and cln=@cln order by porder asc, ID desc", parameters);
        string strName = "";
        while (odr.Read())
        {
            strName = OtherPublic.GetArea(odr["pname"].ToString(), CityName);
            lt_Comp.Append("<li class=\"smove\">\n");
            lt_Comp.Append("<a " + BLLhelp.GetSubUrl(odr["cclass"].ToString(), "photoshow", OtherPublic.GetStrName((odr["urlkey"].ToString() == "" ? OtherPublic.Pseudo_static(odr["cclass"].ToString()) : odr["urlkey"].ToString())), odr["ID"].ToString(), "img", OtherPublic.GetCompanyUrl()) + " class=\"smove\" title=\"" + strName + "\">");
            lt_Comp.Append("<span class=\"Pic\"><img class=\"trans\" src=\"" + odr["pthumb1"].ToString() + "\" alt=\"" + strName + "\" /></span>\n");
            lt_Comp.Append("<span class=\"Tit\">" + strName + "</span>");
            lt_Comp.Append("</a>");
            lt_Comp.Append("</li>\n");
        }
        odr.Dispose();
        odr.Close();
    }

    protected StringBuilder lt_Case = new StringBuilder();
    protected void BindCase()
    {
        string allson = BLLhelp.hlclassGetTypeAllSon("5");
        SqlParameter[] parameters = { 
                         new SqlParameter("@pshow",true),
                         new SqlParameter("@cln",cln)
                                     };
        SqlDataReader odr = BLLhelp.GetList("product", "top 5 ID,pname,cclass,urlkey,pthumb1,pkey", "cclass in (5" + allson + ") and pshow=@pshow and cln=@cln order by porder asc, ID desc", parameters);
        string strName = "";
        while (odr.Read())
        {
            strName = OtherPublic.GetArea(odr["pname"].ToString(), CityName);
            lt_Case.Append("<li class=\"iCaseList smove\">\n");
            lt_Case.Append("<a " + BLLhelp.GetSubUrl(odr["cclass"].ToString(), "photoshow", OtherPublic.GetStrName((odr["urlkey"].ToString() == "" ? OtherPublic.Pseudo_static(odr["cclass"].ToString()) : odr["urlkey"].ToString())), odr["ID"].ToString(), "img", OtherPublic.GetCompanyUrl()) + " class=\"smove\" title=\"" + strName + "\">");
            lt_Case.Append("<span class=\"Pic\"><img class=\"trans\" src=\"" + odr["pthumb1"].ToString() + "\" alt=\"" + strName + "\" /></span>\n");
            lt_Case.Append("<p>");
            lt_Case.Append("<span class=\"Tit\">" + strName + "</span>");
            lt_Case.Append("<span class=\"Key\">" + OtherPublic.GetArea(odr["pkey"].ToString(), CityName) + "</span>");
            lt_Case.Append("<span class=\"more smove\">了解详情</span>");
            lt_Case.Append("</p>");
            lt_Case.Append("</a>");
            lt_Case.Append("</li>\n");
        }
        odr.Dispose();
        odr.Close();
    }

    protected StringBuilder lt_NewsNav = new StringBuilder();
    protected StringBuilder lt_NewsList = new StringBuilder();
    protected void BindNews()
    {
        SqlParameter[] parameters = { 
                    new SqlParameter("@cshow",true),
                    new SqlParameter("@pid","4"),
                    new SqlParameter("@ctitle" + ln,"")
                                    };
        SqlDataReader odr = BLLhelp.GetList("hlclass", "top 3 ctitle,cclass,ID,ctype,ctarget,cid,(select tpath from pagetype where ttype=hlclass.ctype) as tpath", "cshow=@cshow and pid=@pid and ctitle" + ln + "<>@ctitle" + ln + " order by corder asc,ID asc", parameters);
        int i = 0;
        string href = "", strNullPic = "", strTitle = "";
        while (odr.Read())
        {
            lt_NewsNav.Append("<li class=\"" + (i < 1 ? "on" : "") + "\"><a " + BLLhelp.GetClmUrl(odr["ID"].ToString(), odr["ctype"].ToString(), odr["tpath"].ToString(), OtherPublic.GetCompanyUrl()) + " title=\"" + odr["ctitle"].ToString() + "\" target=\"" + odr["ctarget"].ToString() + "\">" + odr["ctitle"].ToString() + "</a></li>");
            lt_NewsList.Append("<div class=\"iNewsCt\"><ul>");
            SqlParameter[] parameters2 = { 
                         new SqlParameter("@cclass",odr["ID"].ToString()),
                         new SqlParameter("@nshow",true),
                         new SqlParameter("@cln",cln)
                                     };
            SqlDataReader odr2 = BLLhelp.GetList("news", "top 11 ID,ntitle,cclass,urlkey,npic,nkey,ndate", "cclass=@cclass and nshow=@nshow and cln=@cln order by norder asc, ID desc", parameters2);
            int j = 0;
            while (odr2.Read())
            {
                strTitle = OtherPublic.GetArea(odr2["ntitle"].ToString(), CityName);
                href = BLLhelp.GetSubUrl(odr2["cclass"].ToString(), "newsshow", OtherPublic.GetStrName((odr2["urlkey"].ToString() == "" ? OtherPublic.Pseudo_static(odr2["cclass"].ToString()) : odr2["urlkey"].ToString())), odr2["ID"].ToString(), "news", OtherPublic.GetCompanyUrl());
                strNullPic = odr2["npic"].ToString() == "" ? "<img class=\"trans\"  src=\"/images/style/sNullPic.jpg\" alt=\"" + strTitle + "\" />" : "<img class=\"trans\"  src=\"" + odr2["npic"].ToString() + "\" alt=\"" + strTitle + "\" />";
                if (j < 1)
                {
                    lt_NewsList.Append("<li class=\"iNewsFirst\">");
                    lt_NewsList.Append("<a class=\"Pic\" " + href + " title=\"" + strTitle + "\" rel=\"nofollow\">" + strNullPic + "</a>");
                    lt_NewsList.Append("<p>");
                    lt_NewsList.Append("<a class=\"Tit\" " + href + " title=\"" + strTitle + "\">" + strTitle + "</a>");
                    lt_NewsList.Append("<span class=\"Date\">[" + DateTime.Parse(odr2["ndate"].ToString()).ToString("yyyy-MM-dd") + "]</span>");
                    lt_NewsList.Append("<span class=\"Key\">" + OtherPublic.GetArea(odr2["nkey"].ToString(), CityName) + "</span>");
                    lt_NewsList.Append("</p>");
                    lt_NewsList.Append("</li>");
                }
                else
                {
                    lt_NewsList.Append("<li class=\"iNewsList\">");
                    lt_NewsList.Append("<a class=\"Tit\" " + href + " title=\"" + strTitle + "\">" + strTitle + "</a>");
                    lt_NewsList.Append("<span class=\"Date\">[" + DateTime.Parse(odr2["ndate"].ToString()).ToString("yyyy-MM-dd") + "]</span>"); lt_NewsList.Append("");
                    lt_NewsList.Append("</li>");
                }
                j++;
            }
            lt_NewsList.Append("</ul></div>");
            odr2.Dispose();
            odr2.Close();
            i++;
        }
        odr.Dispose();
        odr.Close();
    }

    protected StringBuilder lt_FAQ = new StringBuilder();
    protected void BindFAQ()
    {
        string href = "", strTitle = "", strKey = "";
        SqlParameter[] parameters = { 
                         new SqlParameter("@cclass","7"),
                         new SqlParameter("@nshow",true),
                         new SqlParameter("@cln",cln)
                                     };
        SqlDataReader odr = BLLhelp.GetList("news", "top 12 ID,ntitle,cclass,urlkey,npic,nkey,nkey", "cclass=@cclass and nshow=@nshow and cln=@cln order by norder asc, ID desc", parameters);
        while (odr.Read())
        {
            href = BLLhelp.GetSubUrl(odr["cclass"].ToString(), "newsshow", OtherPublic.GetStrName((odr["urlkey"].ToString() == "" ? OtherPublic.Pseudo_static(odr["cclass"].ToString()) : odr["urlkey"].ToString())), odr["ID"].ToString(), "news", OtherPublic.GetCompanyUrl());
            strTitle = OtherPublic.GetArea(odr["ntitle"].ToString(), CityName);
            strKey = OtherPublic.GetArea(odr["nkey"].ToString(), CityName);
            lt_FAQ.Append("<li>");
            lt_FAQ.Append("<a " + href + " title=\"" + strTitle + "\"><i class=\"Q\">Q</i><span class=\"Tit\">" + strTitle + "</span></a>");
            lt_FAQ.Append("<a " + href + " title=\"" + strKey + "\"><i class=\"A\">A</i><span class=\"Key\">" + strKey + "</span></a>");
            lt_FAQ.Append("</li>");
        }
        odr.Dispose();
        odr.Close();
    }
}