ASP.NET-1

//命名空间
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Text;
using System.Text.RegularExpressions;
using System.Net;
using System.Net.Mail;

public class publicClass()
{
 //数据连接SQL
 public static SqlConnection createConn()
 {
  SqlConnection conn=new SqlConnection("server=.; database=DBName;uid=sa;pw=;");
  return conn;
 }

 //ACCESS
 public static OleDbConnection createConn()
 {
  OleDbConnection conn = new OleDbConnection();
  conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=" + HttpContext.Current.Server.MapPath("App_Data/db1.mdb");
  return conn;
 }

 //判断数字
 public static bool isNumber(string inputStr)
 {
  for (int i = 0; i < inputStr.Length; i++)
  {
   if (!Char.IsNumber(inputStr, i))
   {
    return false;
   }
  }
  return true;
 }
 public static bool isNumber(string inputStr)
 {
  try
  {
   Convert.ToInt32(inputStr);
   return true;
  }
  catch (Exception)
  {
   return false;
  }
 }

 //过滤HTML
 public static string formatHtml(string inputStr)
 {
  char enter = (char)65;
  inputStr = inputStr.Replace(">", "&gt;");
  inputStr = inputStr.Replace("<", "&lt;");
  inputStr = inputStr.Replace("[enter]", "<BR>");
  inputStr = inputStr.Replace(Convert.ToString((char)32), " ");
  inputStr = inputStr.Replace(Convert.ToString((char)9), "&nbsp;&nbsp;");
  inputStr = inputStr.Replace(Convert.ToString((char)34), "&quot;");
  inputStr = inputStr.Replace(Convert.ToString((char)39), "&#39;");
  inputStr = inputStr.Replace(Convert.ToString((char)13), "<BR>");
  //inputStr = inputStr.Replace(Convert.ToString((char)10), "<BR>");
  inputStr = inputStr.Replace(Convert.ToString((char)10) + Convert.ToString((char)10), "<p>");
  inputStr = inputStr.Replace(Convert.ToString((char)36), "&#36;");
  return inputStr;
 }

 //获取ASC码
 public static int getASC(string inputStr)
 {
  int strASC = 0;
  ASCIIEncoding ASC = new ASCIIEncoding();
  byte[] nArray = ASC.GetBytes(inputStr);
  for (int i = 0; i <= nArray.Length - 1; i++)
  {
   strASC = nArray[i];
  }
  return strASC;
 }

 //截取字符串
 public static string midStr(string inputStr, int midLen)
 {
  if (inputStr.Length > midLen)
  {
   int l = 0, i = 0;
   string newStr = "", nowStr = "";
   while (l < midLen)
   {
    nowStr = inputStr.Substring(i, 1);
    newStr = newStr + nowStr;
    if (getASC(nowStr) == 63)
    {
     l = l + 2;
    }
    else
    {
     l = l + 1;
    }
    i = i + 1;
   }
   return newStr + "..";
  }
  else
  {
   return inputStr;
  }
 }

 //过滤单引号
 public static string clearInput(string inputStr)
 {
  inputStr = inputStr.Replace("'", "''");
  return inputStr;
 }

 //提示窗口
 public static void outMsg(string inputStr)
 {
  HttpContext.Current.Response.Write("<script>alert(/"提示：" + inputStr + "/")</script>");
 }
}