tools.cs

征服ASP.NET 2.0 Ajax 典型应用源码

using System;
using System.Text;
using System.IO;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data;
using System.Web;
using System.Collections.Generic;
using System.Security.Cryptography;
	public class Tools
	{
        /// <summary>
        /// 检查字符串是否合法不合法替换
        /// </summary>
        /// <param name="strInput"></param>
        /// <returns>替换后的字符串</returns>
        public static string StrConvert(string strInput)
        {
            if ((strInput != null) && (strInput != ""))
            {
                //定义需要过滤的字符。
                string[,] immit ={ { "'", "’" }, { "%20", " " }, { "%24", " " }, { "%27", " " }, { "%3a", " " }, { "%3b", " " }, { "%3c", " " }, { ";", "；" }, { ":", "：" }, { "%", "％" }, { "--", "－－" }, { "*", "*" }, { "\\", "、、" } };
                //遍历字符串，过滤掉需要过滤的字符
                for (int i = 0; i < (immit.Length / 2); i++)
                {
                    strInput = strInput.Replace(immit[i, 0], immit[i, 1]);
                }
            }
            return strInput;//返回替换后的字符串
        }
        /// <summary>
        /// 得到加密字符串
        /// </summary>
        /// <param name="strText">要加密字符串</param>
        /// <param name="strEncrKey">密钥</param>
        /// <returns>加密后字符串</returns>
        public static string Encrypt(string strText, string strEncrKey)//加密函数
        {
            byte[] byKey = null;//初始化密钥
            byte[] IV = { 0x56, 0x78, 0x90, 0xAB, 0xCD, 0xEF, 0x11, 0x12 };
            try
            {
                byKey = System.Text.Encoding.UTF8.GetBytes(strEncrKey);//获取密钥
                DESCryptoServiceProvider des = new DESCryptoServiceProvider();
                byte[] inputByteArray = Encoding.UTF8.GetBytes(strText);//输入的字符串转化成字节型
                MemoryStream ms = new MemoryStream();
                CryptoStream cs = new CryptoStream(ms, des.CreateEncryptor(byKey, IV), CryptoStreamMode.Write);
                cs.Write(inputByteArray, 0, inputByteArray.Length);//输出加密流
                cs.FlushFinalBlock();
                return Convert.ToBase64String(ms.ToArray());


            }
            catch (System.Exception error)
            {
                return "error:" + error.Message + "\r";
            }
        }
        //绘制用户控件
        public static  string  RenderUserControl(string UserControlName)
        {
            StringBuilder sb = new StringBuilder();
            System.IO.StringWriter sw = new System.IO.StringWriter(sb);//定义变量
            HtmlTextWriter writer = new HtmlTextWriter(sw);

            UserControl uc = new UserControl();//初始化一个用户控件
            Control d = uc.LoadControl(UserControlName);//加载需要加载的用户控件
            d.RenderControl(writer);//把用户控件绘制出来
            return sb.ToString();//返回用户控件字符串
        }
        static string path = HttpContext.Current.Server.MapPath(HttpContext.Current.Request.ApplicationPath + "/app_data/db.mdb");//数据库存放的物理路径
        static string str = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Persist Security Info=False";//数据库连接字符串
        //数据库连接
        static OleDbConnection conn = new OleDbConnection(str);
       //得到用户的密码
        public static string GetUserPwd(string username)
        {
            string sql = "select password from myuser where [username]='"+username +"'";//构成sql语句
            OleDbCommand  dc = new  OleDbCommand (sql, conn);//初始化command对象
            object o;
            try
            {
                conn.Open();
              o =  dc.ExecuteScalar();//执行查询
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                dc.Dispose();
                conn.Close();
            }
            return o==null?"":o.ToString();//如果o不为空返回o的字符串形式，否则返回空
        
        }
       //用户注册，向数据库插入一条数据
        public static bool InsertUser(string username,string password,string mail,string name)
        {
            bool b = false;//操作成功与否的标志，初始化为不成功
            string sql = "INSERT INTO myUser (username, [password], mail, name) VALUES ('";//sql语句
            sql += username + "','" + password + "','" + mail + "','" + name + "')";
            OleDbCommand cmd = new OleDbCommand(sql, conn);
            conn.Open();
            try
            {
                cmd.ExecuteNonQuery();//执行
                b = true;
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                cmd.Dispose();
                conn.Close();
            }
            return b;
        
        }
	}