CommonClass类中方法

CommonClass类中方法

机数

it

分类： 编程代码

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;

/// <summary>
/// CommonClass 的摘要说明
/// </summary>
public class CommonClass
{
 public CommonClass()
 {
  //
  // TODO: 在此处添加构造函数逻辑
  //
 }
    //返回数sqlconnection对象
    //public SqlConnection GetConnection()//SQL Server数据库
    //{
    //    string mystr = ConfigurationManager.AppSettings["ConnectionString"].ToString();
    //    SqlConnection conn = new SqlConnection(mystr);
    //    return conn;
    //}
    public OleDbConnection GetConnection()//OleDb数据库
    {
        string mystr = ConfigurationManager.AppSettings["ConnectionString"].ToString();
        OleDbConnection conn = new OleDbConnection(mystr);
        return conn;
    }
    //MessageBox方法(用来接受跳转页面的地址)
    public string MessageBox(string TxtMessage, string url)
    {
        string str;
        str = "<script>alert('" + TxtMessage + "');location='" + url + "'</script>";
        return str;
    }
    /// <summary>
    /// 说明：MessageBoxPage用来在客户端弹出对话框，关闭对话框返回原页。
    /// 参数：TxtMessage 对话框中显示的内容。
    /// </summary>
    public string MessageBoxPage(string TxtMessage)
    {
        string str;
        str = "<script language=javascript>alert('" + TxtMessage + "');location='javascript:history.go(-1)';</script>";
        return str;
    }
    /// <summary>
    /// 说明：MessageBox用来在客户端弹出对话框。
    /// 参数：TxtMessage 对话框中显示的内容。
    /// </summary>
    public string MessageBox(string TxtMessage)
    {
        string str;
        str = "<script language=javascript>alert('" + TxtMessage + "')</script>";
        return str;
    }
    ///<summary>
    ///说明：ExecSQL用来执行SQL语句
    /// 返回值：操作是否成功(true/false)
    /// 参数：sqlstr SQL字符串
    ///</summary>
    //ExecSQL方法(用来实现对数据库中的数据进行添加、修改、删除等功能)
    public Boolean ExecSQL(string sqlstr)
    {
        OleDbConnection conn = GetConnection();
        conn.Open();
        OleDbCommand cmd = new OleDbCommand(sqlstr, conn);

        try
        {
            cmd.ExecuteNonQuery();
            conn.Close();
        }
        catch
        {
            conn.Close();
            return false;
        }
        return true;
    }
    //GetDataSet方法
    public System.Data.DataSet GetDataSet(string sqlstr, string TableName)
    {
        OleDbConnection conn = GetConnection();
        conn.Open();
        OleDbDataAdapter dt = new OleDbDataAdapter(sqlstr, conn);
        DataSet ds = new DataSet();
        dt.Fill(ds, TableName);

        return ds;
    }
    //防止SQL注入式攻击
    public int checkLogin(string loginName, string loginPwd)
    {
        OleDbConnection conn = GetConnection();
        OleDbCommand cmd = new OleDbCommand("select * from tb_User where Name=@loginName  and PassWord=@loginPwd", conn);
        cmd.Parameters.Add(new OleDbParameter("@loginName", OleDbType.VarChar, 20));
        cmd.Parameters["@loginName"].Value = loginName;
        cmd.Parameters.Add(new OleDbParameter("@loginPwd",OleDbType.VarChar, 50));
        cmd.Parameters["@loginPwd"].Value = loginPwd;
        conn.Open();
        int i = (int)cmd.ExecuteScalar();
        cmd.Dispose();
        conn.Close();

        return i;
    }
    //randomNum方法
    public string RandomNum(int x)
    {
        //定义
        string strChar = "0,1,2,3,4,5,6,7,8,9,a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z";
        //将strchar字符串转化为数组
        //string.split方法返回包含此实列中的子字符串的string数组
        string[] VcArray = strChar.Split(',');
        string VNum = "";
        //记录上次随机数值，尽量避免产生几个一样的随机数
        int temp = -1;
        //采用一个简单的算法以保证生成随机数的不同
        Random rand = new Random();

        for (int i = 1; i < x + 1; i++)
        {
            if (temp != 1)
            {
                //unchecked关键字用于取消整型算术运算和转换的溢出检查
                //DataTime.Ticks属性获取表示此实列的日期和时间的刻度数
                rand = new Random(i * temp * unchecked((int)DateTime.Now.Ticks));
            }
            int t = rand.Next(61);
            if (temp != -1 && temp == t)
            {
                return RandomNum(x);
            }
            temp = t;
            VNum += VcArray[t];
        }
        return VNum;//返回生成随机数
    }

//用来返回查询结果中的第一行第一列的值，并获取

public string ExecScalar(string strsql)
    {
        try
        {
            conn = GetCon();
            cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = strsql;
            if (cmd.Connection.State != ConnectionState.Open)
            {
                cmd.Connection.Open();
            }
            strsql = Convert.ToString(cmd.ExecuteScalar);
            return strsql;
        }
        catch (Exception ex)
        {
            throw new Exception(ex.Message, ex);
        }
        finally
        {
            if (cmd.Connection.State == ConnectionState.Open)
            {
                conn.Dispose();
                cmd.Connection.Close();
                cmd.Dispose();
            }
        }
    }