util.cs

usb-com for sms 自己开发的类 可以借鉴下

using System;
using System.Data;
using System.Text;
using System.Collections;
using System.Security.Cryptography;

namespace IPP.SMS
{
	/// <summary>
	/// Summary description for Util.
	/// </summary>
	public class Util
	{
		public Util()
		{
		}

		public static bool IsDate(string date)
		{
			try
			{
				DateTime.Parse(date);
				return true;
			}
			catch
			{
				return false;
			}
		}

		public static bool HasMoreRow(DataSet ds)
		{
			if ( ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
			{
				return false;
			}
			else
			{
				return true;
			}
		}

		//整理字符串到安全格式
		public static string SafeFormat(string strInput)
		{
			return strInput.Trim().Replace("'","''");
		}

		public static string ToSqlString(string paramStr)
		{
			return "'" + SafeFormat(paramStr) + "'";
		}

		public static string ToSqlLikeString(string paramStr)
		{
			return "'%" + SafeFormat(paramStr) + "%'";
		}
		/// <summary>
		/// 传入的参数必须是'yyyy-MM-dd' 格式. 不另外检查
		/// </summary>
		/// <param name="paramDate"></param>
		/// <returns></returns>
		public static string ToSqlEndDate(string paramDate)
		{
			return ToSqlString(paramDate + " 23:59:59");
		}

		
		public static string TrimNull(Object obj)
		{
			if(obj is System.DBNull)
			{
				return AppConst.StringNull;
			}
			else
			{
				return obj.ToString().Trim();
			}
		}

		public static int TrimIntNull(Object obj)
		{
			if(obj is System.DBNull)
			{
				return AppConst.IntNull;
			}
			else
			{
				return Int32.Parse(obj.ToString());
			}
		}

		public static decimal TrimDecimalNull(Object obj)
		{
			if(obj is System.DBNull)
			{
				return AppConst.DecimalNull;
			}
			else
			{
				return decimal.Parse(obj.ToString());
			}
		}
		public static DateTime TrimDateNull(Object obj)
		{
			if(obj is System.DBNull)
			{
				return AppConst.DateTimeNull;
			}
			else
			{
				return DateTime.Parse(obj.ToString());
			}
		}
		public static string  GetMD5(String str) 
		{
			byte[] data = Encoding.Unicode.GetBytes(str);
			MD5 md = new MD5CryptoServiceProvider();
			byte[] result = md.ComputeHash(data);
			return Encoding.Unicode.GetString(result);
		}

	}
}