|
Server : Microsoft-IIS/10.0 System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586 User : jxgj ( 0) PHP Version : 7.0.33 Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server Directory : D:/tmp_aspnet/root/54f3ceba/6be944cd/ |
?#pragma checksum "D:\wwwroot\klbttc\wwwroot\aboutUs.aspx.cs" "{ff1816ec-aa5e-4d10-87f7-6f4963833460}" "FDD97318EF75A2AC28EAF3D5D5BDD5F7A34515B3"
#line 1 "D:\wwwroot\klbttc\wwwroot\aboutUs.aspx.cs"
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
public partial class aboutUs : System.Web.UI.Page
{
C c = new C();
DataSet ds = new DataSet();
public int mid = 0;
public string webSite, webTitle, layer, banner_url = string.Empty;
public string htmlTeamTitle, htmlTeamList = string.Empty;
public string[] aboutvars = new string[17];
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("/");
}
}
}
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)
{
webSite = ds.Tables[0].Rows[0]["Expr1"].ToString();
webTitle = ds.Tables[0].Rows[0]["MenuSys1"].ToString();
banner_url = ds.Tables[0].Rows[0]["link2"].ToString();
}
}
string sql = "select * from about where about5=@mid";
SqlParameter[] ps = new SqlParameter[] { new SqlParameter("@mid", 17) };
ds = MyFunction.Query(sql, ps);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
aboutvars[1] = ds.Tables[0].Rows[0][1].ToString();
aboutvars[2] = ds.Tables[0].Rows[0][2].ToString();
aboutvars[3] = ds.Tables[0].Rows[0][3].ToString();
aboutvars[4] = ds.Tables[0].Rows[0][4].ToString();
aboutvars[5] = ds.Tables[0].Rows[0][5].ToString();
aboutvars[6] = ds.Tables[0].Rows[0][6].ToString();
aboutvars[7] = ds.Tables[0].Rows[0][7].ToString();
aboutvars[8] = ds.Tables[0].Rows[0][8].ToString();
aboutvars[9] = ds.Tables[0].Rows[0][9].ToString();
aboutvars[10] = ds.Tables[0].Rows[0][10].ToString();
aboutvars[11] = ds.Tables[0].Rows[0][11].ToString();
}
}
//发展过程
ds = c.GetDs("SELECT c.*,p.project7 FROM ClassSys c INNER JOIN project p ON c.classSys0 = p.project8 WHERE ClassSys4 = 158 AND project9 = 92 ORDER BY ClassSys3");//ClassSys1
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
Rep_ClassSys_158.DataSource = ds.Tables[0];
Rep_ClassSys_158.DataBind();
Rep_ClassSys_158_2.DataSource = ds.Tables[0];
Rep_ClassSys_158_2.DataBind();
}
}
//ds = c.GetDs("SELECT p.project7,ClassSys1 FROM project p INNER JOIN ClassSys c ON p.project8 = c.classSys0 WHERE project9 = 92 AND ClassSys4 = 158 ORDER BY ClassSys1");
//if (ds.Tables.Count > 0)
//{
// if (ds.Tables[0].Rows.Count > 0)
// {
// Rep_Project_92.DataSource = ds.Tables[0];
// Rep_Project_92.DataBind();
// }
//}
//治理团队
//ds = c.GetDs("SELECT * FROM project WHERE project9 = 98 AND project5=9 ORDER BY ISNULL(project10, 9999),project6 DESC");
//if (ds.Tables.Count > 0)
//{
// if (ds.Tables[0].Rows.Count > 0)
// {
// Rep_Project_mid98_cid9.DataSource = ds.Tables[0];
// Rep_Project_mid98_cid9.DataBind();
// }
//}
//ds = c.GetDs("SELECT * FROM project WHERE project9 = 98 AND project5=10 ORDER BY ISNULL(project10, 9999),project6 DESC");
//if (ds.Tables.Count > 0)
//{
// if (ds.Tables[0].Rows.Count > 0)
// {
// Rep_Project_mid98_cid10.DataSource = ds.Tables[0];
// Rep_Project_mid98_cid10.DataBind();
// }
//}
#region 治理团队
ds = c.GetDs("SELECT * FROM ClassSys WHERE ClassSys4 = 196 ORDER BY ClassSys3;");
if (ds.Tables.Count > 0)
{
var table = ds.Tables[0];
var count = table.Rows.Count;
if (count > 0)
{
//获取治理团队
DataSet teamDS = c.GetDs("SELECT * FROM project WHERE project9 = 98 ORDER BY ISNULL(project10, 9999),project6 DESC");
var teamTable = teamDS.Tables[0];
StringBuilder builder = new StringBuilder();
StringBuilder @string = new StringBuilder();
for (int i = 0; i < count; i++)
{
builder.AppendLine("<div class=\"tab-item " + (i == 0 ? "active" : "") + "\">");
builder.AppendLine("<i class=\"icon\"></i>");
builder.AppendLine("<span class=\"tt\">" + table.Rows[i]["ClassSys1"].ToString() + "</span>");
builder.AppendLine("</div>");
//查找对于的团队
var classid = int.Parse(table.Rows[i]["ClassSys0"].ToString());
var taamList = teamTable.AsEnumerable().Where(t => t.Field<int>("project5") == classid).ToList();
@string.AppendLine("<div class=\"list-box\" " + (i == 0 ? "style=\"display: block\"" : "") + ">");
@string.AppendLine("<div class=\"box\">");
foreach (var item in taamList)
{
@string.AppendLine("<div class=\"item hrefPro LeaderInfo\">");
if (table.Rows[i]["ClassSys1"].ToString() == "治理团队")
{
@string.AppendLine("<div class=\"img\"><img src=\"" + item.Field<string>("project4") + "\" alt=\"\"></div>");
}
@string.AppendLine("<div class=\"text\">");
@string.AppendLine("<p class=\"tit\">" + item.Field<string>("project1") + "</p>");
@string.AppendLine("<p class=\"ms\">" + item.Field<string>("project2") + "</p>");
@string.AppendLine("</div>");
@string.AppendLine("<div class=\"contens\" style=\"display: none;\">" + item.Field<string>("project7") + "</div>");
@string.AppendLine("</div>");
}
@string.AppendLine("</div>");
@string.AppendLine("</div>");
}
htmlTeamTitle = builder.ToString();
htmlTeamList = @string.ToString();
}
}
#endregion
//公司荣誉
ds = c.GetDs("SELECT * FROM project WHERE project9 = 162 ORDER BY ISNULL(project10, 9999),project6 DESC");
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
Rep_Project_162.DataSource = ds.Tables[0];
Rep_Project_162.DataBind();
}
}
this.Title = webSite + " - " + Application["sysset1"].ToString();
}
}
#line default
#line hidden