/// summary>
 /// 類型轉換類
 /// 處理數據庫獲取字段為空的情況
 /// /summary>
 public static class DBConvert
 {
  #region------------------ToInt32類型轉換------------------
  /// summary>
  /// 讀取數據庫中字符串并轉換成Int32
  /// 為空時返回0
  /// /summary>
  /// param name="obj">object類型的值/param>
  /// returns>Int32類型/returns>
  public static int ToInt32(object obj)
  {
   int result = 0;
   if (IsInt(Convert.ToString(obj)))
   {
    result = Convert.ToInt32(obj);
   }
   else if (obj != null  obj is Enum) //處理非null值類型時(或者枚舉)
   {
    result = ((IConvertible)obj).ToInt32(null);
   }
   return result;
  }
  /// summary>
  /// 讀取數據庫中字符串并轉換成Int32
  /// 為空時返回0
  /// /summary>
  /// param name="str">string類型的值/param>
  /// returns>Int32類型/returns>
  public static int ToInt32(string str)
  {
   int result = 0;
   if (IsInt(str))
   {
    result = Convert.ToInt32(str);
   }
   return result;
  }
  /// summary>
  /// 判斷一個字符串是否屬于Int類型
  /// 如果是的返回true，如果不是返回false
  /// /summary>
  /// param name="str">string類型的值/param>
  /// returns>true：是Int的字符串(即可以轉換成Int類型)，false：不是Int類型的字符串/returns>
  public static bool IsInt(string str)
  {
   bool result = false;
   if (str != ""  str!=null)
   {
    Regex reg = new Regex("^[0-9]*$");
    if (reg.IsMatch(str))
    {
     result = true;
    }
   }
   return result;
  }
  #endregion
  #region------------------ToString類型轉換------------------
  /// summary>
  /// 讀取數據庫中字符串并轉換成string
  /// /summary>
  /// param name="obj">object類型的值/param>
  /// returns>string類型/returns>
  public static string ToString(object obj)
  {
   string result = "";
   if (obj != null)
   {
    result = Convert.ToString(obj);
   }
   return result;
  }
  #endregion
  #region------------------ToDouble類型轉換------------------
  /// summary>
  /// 判斷一個字符串是否屬于Double類型(包括負浮點型)
  /// 如果是的返回true，如果不是返回false
  /// /summary>
  /// param name="str">string類型的值/param>
  /// returns>true：是Double的字符串(即可以轉換成Double類型)，false：不是Double類型的字符串/returns>
  public static bool IsDouble(string str)
  {
   bool result = false;
   if (str != ""  str != null)
   {
    Regex reg = new Regex(@"^(-?\d+)(\.\d+)?$");
    if (reg.IsMatch(str))
    {
     result = true;
    }
   }
   return result;
  }
  /// summary>
  /// 讀取數據庫中字符串并轉換成Int32
  /// 為空時返回0
  /// /summary>
  /// param name="obj">object類型的值/param>
  /// returns>Int32類型/returns>
  public static double ToDouble(object obj)
  {
   double result = 0.0;
   if (IsDouble(Convert.ToString(obj)))
   {
    result = Convert.ToDouble(obj);
   }
   else if (obj != null  obj is Enum) //處理枚舉
   {
    result = ((IConvertible)obj).ToDouble(null);
   }
   return result;
  }
  /// summary>
  /// 讀取數據庫中字符串并轉換成Int32
  /// 為空時返回0
  /// /summary>
  /// param name="str">string類型的值/param>
  /// returns>Int32類型/returns>
  public static double ToDouble(string str)
  {
   double result = 0.0;
   if (IsDouble(str))
   {
    result = Convert.ToDouble(str);
   }
   return result;
  }
  #endregion
  #region------------------ToDateTime類型轉換------------------
  /// summary>
  /// 判斷時間格式是否是時間類型
  /// 如23:10
  /// /summary>
  /// param name="str">要判斷的字符串/param>
  /// returns>true：是時間類型的字符串(即可以轉換成時間類型)，false：不是時間類型的字符串/returns>
  public static bool isDateTime(string str)
  {
   bool result = false;
   if (str != ""  str != null)
   {
    Regex reg = new Regex("(([01]\\d)|(2[0-3])):[0-5]\\d");
    if (reg.IsMatch(str))
    {
     result = true;
    }
   }
   return result;
  }
  #endregion
 }
}
//"^\d+(\.\d+)?$"　　//非負浮點數（正浮點數 + 0）
//"^(([0-9]+\.[0-9]*[1-9][0-9]*)|([0-9]*[1-9][0-9]*\.[0-9]+)|([0-9]*[1-9][0-9]*))$"　　//正浮點數
//"^((-\d+(\.\d+)?)|(0+(\.0+)?))$"　　//非正浮點數（負浮點數 + 0）
//"^(-(([0-9]+\.[0-9]*[1-9][0-9]*)|([0-9]*[1-9][0-9]*\.[0-9]+)|([0-9]*[1-9][0-9]*)))$"　　//負浮點數
//"^(-?\d+)(\.\d+)?$"　　//浮點數

public class PageValidate
{
private static Regex RegPhone = new Regex("^[0-9]+[-]?[0-9]+[-]?[0-9]$");
private static Regex RegNumber = new Regex("^[0-9]+$");
private static Regex RegNumberSign = new Regex("^[+-]?[0-9]+$");
private static Regex RegDecimal = new Regex("^[0-9]+[.]?[0-9]+$");
private static Regex RegDecimalSign = new Regex("^[+-]?[0-9]+[.]?[0-9]+$"); //等價于^[+-]?\d+[.]?\d+$
private static Regex RegEmail = new Regex("^[\\w-]+@[\\w-]+\\.(com|net|org|edu|mil|tv|biz|info)$");//w 英文字母或數字的字符串，和 [a-zA-Z0-9] 語法一樣
private static Regex RegCHZN = new Regex("[\u4e00-\u9fa5]");
public PageValidate()
{
}
//數字字符串檢查#region 數字字符串檢查
public static bool IsPhone(string inputData)
{
Match m = RegPhone.Match(inputData);
return m.Success;
}
/**//// summary>
/// 檢查Request查詢字符串的鍵值，是否是數字，最大長度限制
/// /summary>
/// param name="req">Request/param>
/// param name="inputKey">Request的鍵值/param>
/// param name="maxLen">最大長度/param>
/// returns>返回Request查詢字符串/returns>
public static string FetchInputDigit(HttpRequest req, string inputKey, int maxLen)
{
string retVal = string.Empty;
if(inputKey != null  inputKey != string.Empty)
{
retVal = req.QueryString[inputKey];
if(null == retVal)
retVal = req.Form[inputKey];
if(null != retVal)
{
retVal = SqlText(retVal, maxLen);
if(!IsNumber(retVal))
retVal = string.Empty;
}
}
if(retVal == null)
retVal = string.Empty;
return retVal;
}
/**//// summary>
/// 是否數字字符串
/// /summary>
/// param name="inputData">輸入字符串/param>
/// returns>/returns>
public static bool IsNumber(string inputData)
{
Match m = RegNumber.Match(inputData);
return m.Success;
}
/**//// summary>
/// 是否數字字符串 可帶正負號
/// /summary>
/// param name="inputData">輸入字符串/param>
/// returns>/returns>
public static bool IsNumberSign(string inputData)
{
Match m = RegNumberSign.Match(inputData);
return m.Success;
}
/**//// summary>
/// 是否是浮點數
/// /summary>
/// param name="inputData">輸入字符串/param>
/// returns>/returns>
public static bool IsDecimal(string inputData)
{
Match m = RegDecimal.Match(inputData);
return m.Success;
}
/**//// summary>
/// 是否是浮點數 可帶正負號
/// /summary>
/// param name="inputData">輸入字符串/param>
/// returns>/returns>
public static bool IsDecimalSign(string inputData)
{
Match m = RegDecimalSign.Match(inputData);
return m.Success;
}
#endregion
//中文檢測#region 中文檢測
/**//// summary>
/// 檢測是否有中文字符
/// /summary>
/// param name="inputData">/param>
/// returns>/returns>
public static bool IsHasCHZN(string inputData)
{
Match m = RegCHZN.Match(inputData);
return m.Success;
}
#endregion
//郵件地址#region 郵件地址
/**//// summary>
/// 是否是浮點數 可帶正負號
/// /summary>
/// param name="inputData">輸入字符串/param>
/// returns>/returns>
public static bool IsEmail(string inputData)
{
Match m = RegEmail.Match(inputData);
return m.Success;
}
#endregion
//其他#region 其他
/**//// summary>
/// 檢查字符串最大長度，返回指定長度的串
/// /summary>
/// param name="sqlInput">輸入字符串/param>
/// param name="maxLength">最大長度/param>
/// returns>/returns>
public static string SqlText(string sqlInput, int maxLength)
{
if(sqlInput != null  sqlInput != string.Empty)
{
sqlInput = sqlInput.Trim();
if(sqlInput.Length > maxLength)//按最大長度截取字符串
sqlInput = sqlInput.Substring(0, maxLength);
}
return sqlInput;
}
/**//// summary>
/// 字符串編碼
/// /summary>
/// param name="inputData">/param>
/// returns>/returns>
public static string HtmlEncode(string inputData)
{
return HttpUtility.HtmlEncode(inputData);
}
/**//// summary>
/// 設置Label顯示Encode的字符串
/// /summary>
/// param name="lbl">/param>
/// param name="txtInput">/param>
public static void SetLabel(Label lbl, string txtInput)
{
lbl.Text = HtmlEncode(txtInput);
}
public static void SetLabel(Label lbl, object inputObj)
{
SetLabel(lbl, inputObj.ToString());
}
//字符串清理
public static string InputText(string inputString, int maxLength)
{
StringBuilder retVal = new StringBuilder();
// 檢查是否為空
if ((inputString != null)  (inputString != String.Empty))
{
inputString = inputString.Trim();
//檢查長度
if (inputString.Length > maxLength)
inputString = inputString.Substring(0, maxLength);
//替換危險字符
for (int i = 0; i  inputString.Length; i++)
{
switch (inputString[i])
{
case '"':
retVal.Append("quot;");
break;
case '':
retVal.Append("lt;");
break;
case '>':
retVal.Append("gt;");
break;
default:
retVal.Append(inputString[i]);
break;
}
}
retVal.Replace("'", " ");// 替換單引號
}
return retVal.ToString();
}
/**//// summary>
/// 轉換成 HTML code
/// /summary>
/// param name="str">string/param>
/// returns>string/returns>
public static string Encode(string str)
{
str = str.Replace("","");
str = str.Replace("'","''");
str = str.Replace("\"","quot;");
str = str.Replace(" ","nbsp;");
str = str.Replace("","lt;");
str = str.Replace(">","gt;");
str = str.Replace("\n","br>");
return str;
}
/**//// summary>
///解析html成 普通文本
/// /summary>
/// param name="str">string/param>
/// returns>string/returns>
public static string Decode(string str)
{
str = str.Replace("br>","\n");
str = str.Replace("gt;",">");
str = str.Replace("lt;","");
str = str.Replace("nbsp;"," ");
str = str.Replace("quot;","\"");
return str;
}
public static string SqlTextClear(string sqlText)
{
if (sqlText == null)
{
return null;
}
if (sqlText == "")
{
return "";
}
sqlText = sqlText.Replace(",", "");//去除,
sqlText = sqlText.Replace("", "");//去除
sqlText = sqlText.Replace(">", "");//去除>
sqlText = sqlText.Replace("--", "");//去除--
sqlText = sqlText.Replace("'", "");//去除'
sqlText = sqlText.Replace("\"", "");//去除"
sqlText = sqlText.Replace("=", "");//去除=
sqlText = sqlText.Replace("%", "");//去除%
sqlText = sqlText.Replace(" ", "");//去除空格
return sqlText;
}
#endregion
//是否由特定字符組成#region 是否由特定字符組成
public static bool isContainSameChar(string strInput)
{
string charInput = string.Empty;
if (!string.IsNullOrEmpty(strInput))
{
charInput = strInput.Substring(0, 1);
}
return isContainSameChar(strInput, charInput, strInput.Length);
}
public static bool isContainSameChar(string strInput, string charInput, int lenInput)
{
if (string.IsNullOrEmpty(charInput))
{
return false;
}
else
{
Regex RegNumber = new Regex(string.Format("^([{0}])+$", charInput));
//Regex RegNumber = new Regex(string.Format("^([{0}]{{1}})+$", charInput,lenInput));
Match m = RegNumber.Match(strInput);
return m.Success;
}
}
#endregion
//檢查輸入的參數是不是某些定義好的特殊字符：這個方法目前用于密碼輸入的安全檢查#region 檢查輸入的參數是不是某些定義好的特殊字符：這個方法目前用于密碼輸入的安全檢查
/**//// summary>
/// 檢查輸入的參數是不是某些定義好的特殊字符：這個方法目前用于密碼輸入的安全檢查
/// /summary>
public static bool isContainSpecChar(string strInput)
{
string[] list = new string[] { "123456", "654321" };
bool result = new bool();
for (int i = 0; i  list.Length; i++)
{
if (strInput == list[i])
{
result = true;
break;
}
}
return result;
}
#endregion
}