918博天堂

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

#line 1 "D:\wwwroot\klbttc\wwwroot\join.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;

public partial class _Default : System.Web.UI.Page
{
    C c = new C();
    DataSet ds = new DataSet();
    public int mid = 0;
    public int id = 0;
    public int menuid = 0;
    public string webSite, webSite1, layer = "";
    public string ewm_url = string.Empty;//二维码
    public string[] aboutvars = new string[10];

    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (Request.Url.AbsolutePath.Length > 30)
            {
                Response.End();
            }
            if (Request.Url.Query.Length > 15)
            {
                Response.Redirect("/");
            }
            else
            {
                if (Request.QueryString["mid"].ToString().Length > 4)
                {
                    Response.Redirect("/");
                }
                else
                {
                    mid = int.Parse(SqlKey.ReplaceUrlBadChar(Request.QueryString["mid"].ToString()));
                }
            }
        }
        catch
        {
            Response.Redirect("/");
        }

        ds = MyFunction.Query("SELECT MenuSys_1.MenuSys1 AS Expr1, MenuSys.*,MenuSys_1.MenuSys0 AS Expr3 FROM MenuSys INNER JOIN     MenuSys MenuSys_1 ON     MenuSys.MenuSys3 = MenuSys_1.MenuSys0 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]["MenuSys1"].ToString();
                menuid = int.Parse(ds.Tables[0].Rows[0][4].ToString());
            }
        }
         
        //人才理想                                                                                 
        string sql = "select * from about where about5=@mid";
        SqlParameter[] ps = new SqlParameter[]{
                    new SqlParameter("@mid",63),
                };
        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[6] = ds.Tables[0].Rows[0][6].ToString();
                aboutvars[7] = ds.Tables[0].Rows[0][7].ToString();
            }
        }

        //人才引进
        MyFunction.repeater(0, "position", "position9 = 113", " order by position4 desc", list);

        //员工风采
        MyFunction.repeater(0, "project", "project9 = 134", " order by isnull(project10,9999) asc,project6 desc", rep_prolist);

        //在线留言
        if (Request.Form["type"] == "msg" && Request.Form.Count > 0)
        {
            string CheckCode = Request["CheckCode"] ?? "";
            if (Session["CheckCode"] != null && Session["CheckCode"].ToString().ToLower() == CheckCode.ToLower())
            {
                string sql2 = "insert into guestbook(guestbook1,guestbook2,guestbook3,guestbook4,guestbook5,guestbook8)values(@g1,@g2,@g3,@g4,@g5,@g8)";
                SqlParameter[] ps2 = new SqlParameter[]{
                    new SqlParameter("@g1",SqlKey.ReplaceUrlBadChar(Request.Form["msg_name"])),
                    new SqlParameter("@g2",SqlKey.ReplaceUrlBadChar(Request.Form["tel"])),
                    new SqlParameter("@g3",Request.Form["email"]),
                    new SqlParameter("@g4",DateTime.Now),
                    new SqlParameter("@g5",SqlKey.ReplaceUrlBadChar(Request.Form["Msg"])),
                    new SqlParameter("@g8",124),
                };
                var s = MyFunction.ExecuteSql(sql2, ps2);
                if (s > 0)
                {
                    layer = "layer.confirm('留言提交成功，请期待回应！', {btn: ['确定']}, function () {window.location.href='/contact.aspx?mid=" + mid + "';});";
                }
                else
                {
                    layer = "layer.confirm('留言提交失败，请沉试！', {btn: ['确定']}, function () {history.back();});";
                }
            }
            else
            {
                layer = "layer.confirm('验证码谬误！', {btn: ['确定']}, function () {history.back();});";
            }
        }

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

#line default
#line hidden