918博天堂

?#pragma checksum "D:\wwwroot\ldxynb\wwwroot\App_Code\Zhongbiao.cs" "{406ea660-64cf-4c82-b6f0-42d48172a799}" "FA0D7909D90C5C21D4AD3AE3F9E1F927"

#line 1 "D:\wwwroot\ldxynb\wwwroot\App_Code\Zhongbiao.cs"
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;

/// <summary>
///Zhongbiao 的提要注明
/// </summary>
public class Zhongbiao
{
    //private static readonly string Connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath("/App_Data/ycdata.mdb");
   
    #region 域界说
    public string Connectionstring;
		#endregion
		
		#region 机关函数
      public Zhongbiao()
		{
			//
			// TODO: 在此处增长机关函数逻辑
			//
            this.Connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["strConn"].ConnectionString);
            if (HttpContext.Current.Request.Url.ToString().ToLower().IndexOf("/en/") > -1)
            {
                this.Connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["strConnEn"].ConnectionString);
            }
        }
		#endregion
    
    OleDbConnection cn;
    OleDbCommand cmd;
    OleDbDataAdapter da;
    OleDbDataReader read;
    /// <summary>
    /// 对用户表的增,删,改,操作
    /// </summary>
    /// <param name="sql">要执行的sql语句</param>
    public void user(string sql)
    {
        cn = new OleDbConnection(Connectionstring);
        cmd = new OleDbCommand(sql, cn);
        cn.Open();
        cmd.ExecuteNonQuery();
        cn.Close();
    }
    /// <summary>
    /// 对datalist的绑定
    /// </summary>
    /// <param name="sql">要执行的查问sql语句</param>
    /// <returns>返回了局集</returns>
    public DataSet chaxun(string sql)
    {
        cn = new OleDbConnection(Connectionstring);
        da = new OleDbDataAdapter(sql, cn);
        DataSet dt = new DataSet();
        da.Fill(dt);
        return dt;
    }
    /// <summary>
    /// 对表的读去
    /// </summary>
    /// <param name="sql">执行的sql语句</param>
    /// <returns>返回的了局</returns>
    public OleDbDataReader charead(string sql)
    {
        cn = new OleDbConnection(Connectionstring);
        cmd = new OleDbCommand(sql, cn);
        cn.Open();
        read = cmd.ExecuteReader();
        return read;

    }
    /// <summary>
    /// 绑定gridview
    /// </summary>
    /// <param name="sql">查问语句sql语句</param>
    /// <param name="gridview">绑定的内容</param>
    public void bind(string sql, GridView gridview)
    {
        cn = new OleDbConnection(Connectionstring);
        da = new OleDbDataAdapter(sql, cn);
        DataSet dt = new DataSet();
        da.Fill(dt);
        gridview.DataSource = dt.Tables[0].DefaultView;
        gridview.DataBind();
    }
    /// <summary>
    /// 弹出对话信息
    /// </summary>
    /// <param name="ss">弹出的对话内容</param>
    public void MSG(string ss)
    {
        HttpContext.Current.Response.Write("<script>alert('" + ss + "')</script>");
    }
    /// <summary>
    /// 绑定dropdownlist
    /// </summary>
    /// <param name="dropdownlist">绑定的控件的名称</param>
    public void bingding(string sql,DropDownList dropdownlist,string id,string title)
    {
        cn = new OleDbConnection(Connectionstring);
        da = new OleDbDataAdapter(sql, cn);
        DataSet dt = new DataSet();
        da.Fill(dt);
        dropdownlist.DataSource = dt.Tables[0].DefaultView;
        dropdownlist.DataValueField =id;
        dropdownlist.DataTextField =title;
        dropdownlist.DataBind();
    }

    public string MD5(string pwd)
    {

        return FormsAuthentication.HashPasswordForStoringInConfigFile(pwd, "md5");

    }

    public void javascript(string font)
    {

        HttpContext.Current.Response.Write("<script>alert('" + font + "')</script>");
    }

    public void java(string font,string yemian)
    {

        HttpContext.Current.Response.Write("<script>alert('" + font + "');location.href='" + yemian + "'</script>");
    }

    //写成一个步骤,以便多处挪用:
    public void Alert(Page page, string msg)
    {
        page.ClientScript.RegisterClientScriptBlock(GetType(), "_error", " <script language=javascript>window.alert('" + msg + "') </script>");
    }
    //判断是否整型
    public bool checkIsNum(string TestString)
    {
        string SpecSign = "0123456789";
        for (int i = 0; i < TestString.Length; i++)
        {
            while (SpecSign.IndexOf(TestString[i]) == -1)
                return false;
        }
        return true;
    }
}


#line default
#line hidden