webconfig.cs

大家一起研究研究,全部都是开源的CSHARP代码.带数据库的

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Text.RegularExpressions;

/// <summary>
/// WebConfig 的摘要说明
/// </summary>
public class WebConfig
{
    public static OleDbConnection con = new OleDbConnection();
	public WebConfig()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

    public static void CreateCon(){
        //string connString = HttpContext.Current.Application["connstr"].ToString();
        //string connString="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+HttpContext.Current.Server.MapPath(dbname)+"";
        if (con.State == ConnectionState.Closed)
        {
            con.ConnectionString = HttpContext.Current.Application["connstr"].ToString();
            con.Open();
        }
    }

    public static void CloseCon()
    {
        if (con.State == ConnectionState.Open)
        {
            con.Close();
            con.Dispose();
        }
    }

    public static bool ChkAdminSession()
    {
        bool re = false;
        if (HttpContext.Current.Session["userName"] != "")
        {
            re = true;
        }
        return re;
    }

    public static bool ChkMasterLogin()
    {
        bool re = false;
        string sql="Select * from [NcAdmin]";
        CreateCon();
        OleDbCommand cmd = new OleDbCommand(sql, con);
        OleDbDataReader dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            if (HttpContext.Current.Session["userPwd"] == null)
            {
                re = false;
            }
            else
            {
                if (HttpContext.Current.Session["userPwd"].ToString() != dr["adminPwd"].ToString())
                {
                    re = false;
                }
                else
                {
                    re = true;
                }
            }
        }
        else
        {
            re = false;
        }
        dr.Dispose();
        CloseCon();
        return re;
    }

    public static string IPAddress
    {
        get
        {
            string result = String.Empty;

            result = HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
            if (result != null && result != String.Empty)
            {
                //可能有代理 
                if (result.IndexOf(".") == -1)     //没有“.”肯定是非IPv4格式 
                    result = null;
                else
                {
                    if (result.IndexOf(",") != -1)
                    {
                        //有“,”，估计多个代理。取第一个不是内网的IP。 
                        result = result.Replace(" ", "").Replace("'", "");
                        string[] temparyip = result.Split(",;".ToCharArray());
                        for (int i = 0; i < temparyip.Length; i++)
                        {
                            if (WebConfig.IsIPAddress(temparyip[i])
                                && temparyip[i].Substring(0, 3) != "10."
                                && temparyip[i].Substring(0, 7) != "192.168"
                                && temparyip[i].Substring(0, 7) != "172.16.")
                            {
                                return temparyip[i];     //找到不是内网的地址 
                            }
                        }
                    }
                    else if (WebConfig.IsIPAddress(result)) //代理即是IP格式 
                        return result;
                    else
                        result = null;     //代理中的内容 非IP，取IP 
                }

            }

            string IpAddress = (HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != null && HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != String.Empty) ? HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"] : HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];



            if (null == result || result == String.Empty)
                result = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];

            if (result == null || result == String.Empty)
                result = HttpContext.Current.Request.UserHostAddress;

            return result;
        }
    }
    /// <summary>
    /// 判断是否是IP地址格式 0.0.0.0
    /// </summary>
    /// <param name="str1">待判断的IP地址</param>
    /// <returns>true or false</returns>
    public static bool IsIPAddress(string str1)
    {
        if (str1 == null || str1 == string.Empty || str1.Length < 7 || str1.Length > 15) return false;

        string regformat = @"^\d{1,3}[\.]\d{1,3}[\.]\d{1,3}[\.]\d{1,3}$";

        Regex regex = new Regex(regformat, RegexOptions.IgnoreCase);
        return regex.IsMatch(str1);
    }
   
}