918博天堂

Server : Microsoft-IIS/10.0
System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586
User : jxgj ( 0)
PHP Version : 7.0.33
Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server
Directory :  D:/tmp_aspnet/root/6b11be23/e503b68d/
Upload File :
Current Directory [ Writeable ] Root Directory [ Writeable ]


Current File : D:/tmp_aspnet/root/6b11be23/e503b68d/App_Code.ronncair.0.cs
?#pragma checksum "D:\wwwroot\keman\wwwroot\App_Code\CoreClass.cs" "{406ea660-64cf-4c82-b6f0-42d48172a799}" "7D6B0377C074989F1CED538508F4279B"

#line 1 "D:\wwwroot\keman\wwwroot\App_Code\CoreClass.cs"
using System;
using System.Collections;
using System.Data;
using System.Data.OleDb;
using System.Text;
using System.Web;
using System.Web.UI;
using System.IO;
using System.Drawing;
using System.Drawing.Imaging;
using System.Security.Cryptography;
using System.Net;
using System.Web.UI.WebControls;
using System.Text.RegularExpressions;
using System.Web.Mail;
using System.Configuration;
using System.Web.UI.HtmlControls;

namespace CoreClass
{
	/// <summary>
	/// DBCommon 的提要注明。
	/// 数据库操作,衔接串取自Web.config文件的AppSettings的connectString
	/// </summary>	
	public class DBCommon
	{
      
		#region 域界说
		/// <summary>
		/// 衔接字符串
		/// </summary>
		public string strConnectstring;
		#endregion
		
		#region 机关函数
		public DBCommon()
		{
			//
			// TODO: 在此处增长机关函数逻辑
			//
            this.strConnectstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["strConn"].ConnectionString);
            if (HttpContext.Current.Request.Url.ToString().ToLower().IndexOf("/en/") > -1)
            {
                this.strConnectstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["strConnEn"].ConnectionString);
            }
        }
		#endregion

		#region 执行sql返回数据集
		/// <summary>
		/// 执行sql返回数据集
		/// </summary>
		/// <param name="strSql">要执行的SQL语句</param>
		/// <returns>存放执行了局的DataSet对象</returns>
		public DataSet GetDataSetBySql(string strSql)
		{
            OleDbConnection sqlCon = new OleDbConnection(this.strConnectstring);	//衔接对象
            OleDbCommand sqlCmd = new OleDbCommand(strSql, sqlCon);					//sql号令
			sqlCmd.CommandType = CommandType.Text;
            OleDbDataAdapter sqlData = new OleDbDataAdapter();						//适配器
			sqlData.SelectCommand = sqlCmd;
			DataSet ds = new DataSet();
			sqlData.Fill(ds);
			return ds;            
		}
		#endregion

		#region 执行一查问SQL语句,返回DataTable对象
		/// <summary>
		/// 执行一查问SQL语句,返回DataTable对象
		/// </summary>
		/// <param name="sql">要执行的SQL语句</param>
		/// <returns>存放了局的DataTable对象</returns>
		public DataTable GetDataTableBySql(string sql)
		{
            OleDbConnection conn = new OleDbConnection(this.strConnectstring);	//衔接对象
            OleDbCommand cmd = new OleDbCommand(sql, conn);						//号令对象
            OleDbDataAdapter da = new OleDbDataAdapter(cmd);					//创建适配器
            DataTable dt = new DataTable();									//创建DataTable
            da.Fill(dt);													//填充DataTable
            da.Dispose();
            cmd.Dispose();
            conn.Close();
            conn.Dispose();
            return dt;														//返回
        }

		/// <summary>
		///  执行一查问SQL语句,返回DataTable对象
		/// </summary>
		/// <param name="sql">要执行的SQL语句</param>
		/// <param name="start">肇始纪录号</param>
		/// <param name="count">返回纪录总数</param>
		/// <returns>存放了局的DataTable对象</returns>
		public DataTable GetDataTableBySql(string sql,int start,int count,string tablename)
		{
            OleDbConnection conn = new OleDbConnection(this.strConnectstring);	//衔接对象
            OleDbCommand cmd = new OleDbCommand(sql, conn);						//号令对象
            OleDbDataAdapter da = new OleDbDataAdapter(cmd);					//创建适配器
            DataSet ds = new DataSet();										//创建DataSet
            da.Fill(ds, start, count, tablename);								//填充DataTable
            da.Dispose();
            cmd.Dispose();
            conn.Close();
            conn.Dispose();
            return ds.Tables[tablename];									//返回
        }
		#endregion

		#region 执行一查问SQL语句,返回OleDbDataReader对象,自动关关Connection
		/// <summary>
		/// 执行一查问SQL语句,返回OleDbDataReader对象,自动关关Connection
		/// </summary>
		/// <param name="sql">查问Sql语句</param>
		/// <returns>OleDbDataReader</returns>
        public OleDbDataReader GetDataReaderBySql(string sql)
		{
            OleDbConnection conn = new OleDbConnection(this.strConnectstring);	//衔接对象
            OleDbCommand cmd = new OleDbCommand(sql, conn);						//号令对象
			cmd.Connection.Open();
			OleDbDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
			return dr;
		}
		#endregion


        #region 执行一查问SQL语句,返回dataset
        /// <summary>
        /// 对datalist的绑定
        /// </summary>
        /// <param name="sql">要执行的查问sql语句</param>
        /// <returns>返回了局集</returns>
        public DataSet chaxun(string sql)
        {


            OleDbConnection conn = new OleDbConnection(this.strConnectstring);	//衔接对象
            OleDbCommand cmd = new OleDbCommand(sql, conn);						//号令对象
            OleDbDataAdapter da = new OleDbDataAdapter(cmd);					//创建适配器
            DataSet dt = new DataSet();									//创建DataSet
            da.Fill(dt);													//填充DataTable
            da.Dispose();
            cmd.Dispose();
            conn.Close();
            conn.Dispose();
            return dt;		
 
        }

        #endregion


        #region 返回一个OleDbDataAdapter对象
        /// <summary>
		/// 返回一个OleDbDataAdapter对象
		/// </summary>
		/// <param name="strSql">要执行的SQL语句</param>
		/// <returns></returns>
        public OleDbDataAdapter GetDataAdapterBySql(string strSql)
		{
			//衔接对象
            OleDbConnection sqlCon = new OleDbConnection();
			sqlCon.ConnectionString = strConnectstring;
			//sql号令
            OleDbCommand sqlCmd = new OleDbCommand();
			sqlCmd.CommandType = CommandType.Text;
			sqlCmd.CommandText = strSql;
			sqlCmd.Connection = sqlCon;
			//适配器
            OleDbDataAdapter sqlData = new OleDbDataAdapter();
			sqlData.SelectCommand = sqlCmd;
			return sqlData;            
		}
		#endregion

		#region 返回一个Command对象(commandType为默认)
		/// <summary>
		/// 返回一个Command对象
		/// </summary>
		/// <returns>返回Command对象</returns>
        public OleDbCommand GetCommandBySql()
		{
            OleDbConnection conn = new OleDbConnection(this.strConnectstring);	//衔接对象
            OleDbCommand cmd = new OleDbCommand();								//号令对象
			cmd.Connection = conn;
			return cmd;														//返回
		}

		/// <summary>
		/// 返回一个Command对象
		/// </summary>
		/// <param name="sql">为Command对象指定CommandText属性</param>
		/// <returns>返回Command对象</returns>
        public OleDbCommand GetCommandBySql(string sql)
		{
            OleDbCommand cmd = this.GetCommandBySql();//获取Command对象
			cmd.CommandType = CommandType.Text;		//指定Command对象的号令类型
			cmd.CommandText = sql;					//指定Command对象的执行文本
			return cmd;								//返回
		}
		#endregion

		#region 执行sql不返回数据集
		/// <summary>
		/// 执行sql不返回数据集
		/// </summary>
		/// <param name="strSql">执行sql语句</param></param>
		public void ExcuteSql(string strSql)
		{

            //衔接对象
            OleDbConnection sqlCon = new OleDbConnection();
            sqlCon.ConnectionString = strConnectstring;
            //sql号令
            OleDbCommand sqlCmd = new OleDbCommand();
            sqlCmd.CommandType = CommandType.Text;
            sqlCmd.CommandText = strSql;
            sqlCmd.Connection = sqlCon;
            //sqlCon.Mode = 3'3 = adModeReadWrite;
            sqlCon.Open();
            sqlCmd.ExecuteNonQuery();
            sqlCon.Close();
        }
		#endregion

		#region 执行Insert,Update,Delete类型的SQL语句,返回影响行数
		/// <summary>
		/// 执行Insert,Update,Delete类型的SQL语句,返回影响行数
		/// </summary>
		/// <param name="strSql">要执行的SQL语句</param>
		/// <returns>影响行数</returns>
		public int ExcuteSqlCount(string strSql)
		{
            //衔接对象
            OleDbConnection sqlCon = new OleDbConnection();
            sqlCon.ConnectionString = strConnectstring;
            //sql号令
            OleDbCommand sqlCmd = new OleDbCommand();
            sqlCmd.CommandType = CommandType.Text;
            sqlCmd.CommandText = strSql;
            sqlCmd.Connection = sqlCon;
            int intCount;
            sqlCmd.Connection.Open();
            intCount = sqlCmd.ExecuteNonQuery();
            sqlCmd.Connection.Close();
            sqlCmd.Connection.Dispose();
            sqlCmd.Dispose();
            return intCount;   
        
		}
		#endregion

		#region 读取数据表的一行
		/// <summary>
		/// 读取数据表的一行
		/// </summary>
		/// <param name="TableName">数据表名</param>
		/// <param name="where">选择前提</param>
		/// <returns>一行数据</returns>
		public DataRow ReadOneRow(string TableName,string where)
		{
            OleDbConnection conn = new OleDbConnection(this.strConnectstring);								//衔接对象
            OleDbCommand cmd = new OleDbCommand("select top 1 * from " + TableName + " Where " + where, conn);		//号令对象
            OleDbDataAdapter da = new OleDbDataAdapter(cmd);					//创建适配器
            DataTable dt = new DataTable();									//创建DataTable
            da.Fill(dt);													//填充DataTable
            da.Dispose();
            cmd.Dispose();
            conn.Close();
            conn.Dispose();
            DataRow row = null;
            if (dt.Rows.Count > 0)
            {
                row = dt.Rows[0];
            }
            dt.Dispose();
            return row;														//返回
        }
		#endregion

	}

 


	public class PublicFunction
	{
		#region MD5加密
		public string MD5(string old)
		{
			return System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(old,"md5");
		}
		public string MD5_16(string old)
		{
			string md5str = this.MD5(old);
			return md5str.Substring(8,16);
		}
		#endregion

		#region 天生随机字串
		/// <summary>
		/// 天生指定长度的随机字串
		/// </summary>
		/// <param name="len">长度</param>
		/// <returns>随机字串</returns>
		public string GetRandomizedString(int len)
		{
			return this.GetRandomizedString(len,"all");
		}
		/// <summary>
		/// 天生指定长度的随机字串
		/// </summary>
		/// <param name="len">长度</param>
		/// <param name="codes">字串取值领域</param>
		/// <returns>随机字串</returns>
		public string GetRandomizedString(int len,string codes)
		{
			string series;
			switch(codes)
			{
 
				case "number":
					series = "01234567890123456789";
					break;
				case "lower":
					series = "abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz";
					break;
				case "upper":
					series = "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ";
					break;
				case "alpha":
					series = "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz";
					break;
				default:
					series = "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890123456789abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz";
					break;
			}
			if(len < 1)return "";
			int olen = series.Length;
			StringBuilder sb = new StringBuilder();
			Random rnd = new Random();
			for(int i = 0;i<len;i++)
			{
				sb.Append(series.Substring(rnd.Next(0,olen-1),1));
			}
			return sb.ToString();
		}
		#endregion

		#region 删除特定字符
		/// <summary>
		/// 断根字符串的非数字、字母(含下划线)和汉字字符
		/// </summary>
		/// <param name="txt">传入参数</param>
		/// <returns>了局字串</returns>
		public string delNonePassportAllowChar(string txt)
		{
			System.Text.RegularExpressions.Regex reg = new System.Text.RegularExpressions.Regex("[\x00-\x2F\x3A-\x40\x5B-\x5E\x60\x7B-\xFF]");
			return reg.Replace(txt,"");
		}
		public bool hasIllegalPassportChar(string txt)
		{
			System.Text.RegularExpressions.Regex reg = new System.Text.RegularExpressions.Regex("[\x00-\x2F\x3A-\x40\x5B-\x5E\x60\x7B-\xFF]{1,}");
			return reg.IsMatch(txt);
		}
		public string onlyAlphaAndDigit(string txt)
		{
			System.Text.RegularExpressions.Regex reg = new System.Text.RegularExpressions.Regex("[^a-zA-Z0-9]");
			return reg.Replace(txt,"");
		}
		public bool hasNoneAlphaAndDigit(string txt)
		{
			System.Text.RegularExpressions.Regex reg = new System.Text.RegularExpressions.Regex("[^a-zA-Z0-9]{1,}");
			return reg.IsMatch(txt);
		}
		#endregion

		#region 返回文件扩大名
		/// <summary>
		/// 返回文件扩大名
		/// </summary>
		/// <param name="filename">文件名</param>
		/// <returns>幼写扩大名</returns>
		public string getFileExt(string filename)
		{
			int lidx = filename.LastIndexOf(".");
			if(lidx == filename.Length-1)return "";
			string ext = "";
			if(lidx>-1)
			{
				ext = filename.Substring(lidx+1).ToLower();
			}
			return ext;
		}
		#endregion

		#region 截字处置(按字节算)
		/// <summary>
		/// 截字处置(按字节算)
		/// </summary>
		/// <param name="str">原始字串</param>
		/// <param name="len">字节长度</param>
		/// <returns>了局字串</returns>
		public string SubStringByByte(string str,int len)
		{
			char[] cc=str.ToCharArray();
			int i=0,j=0,code;
			for(i=0,j=0;i<cc.Length && j<len;i++)
			{
				code = (int)cc[i];
				if(code >=0 && code <= 255)
				{
					j++;
				}
				else
				{
					j += 2;
				}
			}
			if(i>0)
			{
				return str.Substring(0,i);
			}
			else
			{
				return "";
			}
		}

		/// <summary>
		/// 返回字节长度
		/// </summary>
		/// <param name="str">推算字串</param>
		/// <returns>长度</returns>
		public int CalcByteLength(string str)
		{
			char[] cc=str.ToCharArray();
			int i=0,j=0,code;
			for(i=0,j=0;i<cc.Length;i++)
			{
				code = (int)cc[i];
				if(code >=0 && code <= 255)
				{
					j++;
				}
				else
				{
					j += 2;
				}
			}
			return j;
		}
		#endregion

		#region 检测字串是否是电子邮件地址体式
		/// <summary>
		/// 检测字串是否是电子邮件地址体式
		/// </summary>
		/// <param name="email">必要检测的电子邮件地址字串</param>
		/// <returns>是否是电子邮件地址体式</returns>
		public bool IsEmail(string email)
		{
			System.Text.RegularExpressions.Regex reg = new System.Text.RegularExpressions.Regex(@"\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*");
			return reg.IsMatch(email);
		}
		#endregion	

		#region 正则匹配检测

		/// <summary>
		/// 正则匹配检测
		/// </summary>
		/// <param name="txt">必要检测的字串</param>
		/// <param name="reg">正则表白式</param>
		/// <returns>了局</returns>
		public bool RegIsMatch(string txt,string reg)
		{
			System.Text.RegularExpressions.Regex regex = new System.Text.RegularExpressions.Regex(reg);
			return regex.IsMatch(txt);
		} 


		#endregion


		#region 获取字符串字节数
		public int GetStringByteLength(string str)
		{
			char[] cc=str.ToCharArray();
			int i=0,j=0,code;
			for(i=0,j=0;i<cc.Length;i++)
			{
				code = (int)cc[i];
				if(code >=0 && code <= 255)
				{
					j++;
				}
				else
				{
					j += 2;
				}
			}
			return j;
		}
		#endregion

		#region 天生以日期功夫为基础的不沉复数字字串
		private Random rnd = new Random();
		/// <summary>
		/// 天生以日期功夫为基础的不沉复数字字串
		/// </summary>
		/// <returns>字串</returns>
		public string getIdenticalStringBaseDateTime()
		{
			return DateTime.Now.ToString("yyMMdd")+rnd.Next(1000,9999).ToString();
		}
		/// <summary>
		/// 天生以日期功夫为基础的不沉复数字字串
		/// </summary>
		/// <returns>字串</returns>
		public string getIdenticalStringBaseDateTime2()
		{
			return DateTime.Now.ToString("yyMMddHHmmss")+rnd.Next(10000,99999).ToString();
		}
		#endregion

		#region 天生以日期功夫为基的SHA1加密字串
		/// <summary>
		/// 天生以日期功夫为基的SHA1加密字串
		/// </summary>
		/// <returns>40位的加密字串</returns>
		public string GetSHA1StringBasedDateTime()
		{
			string source = DateTime.Now.ToString("yyyyMMddHHss")+rnd.Next(10000,99999).ToString();
			return System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(source,"sha1");
		}
		#endregion

		#region 表单提交前的处置
		/// <summary>
		/// 表单提交前的处置
		/// </summary>
		/// <param name="str">处置字串</param>
		/// <returns>了局字串</returns>
		public string TextareaStringToDatabase(string str)
		{
			StringBuilder sb = new StringBuilder(System.Web.HttpUtility.HtmlEncode(str));
			sb = sb.Replace(" ","&nbsp;");
			sb = sb.Replace("\n","<br />");
			return sb.ToString();
		}
		public string DatabaseStringToTextarea(string str)
		{
			StringBuilder sb = new StringBuilder(System.Web.HttpUtility.HtmlDecode(str));
			sb = sb.Replace("&nbsp;"," ");
			sb = sb.Replace("<br />","\n");
			return sb.ToString();
		}
		#endregion

		#region 检测MIME字串是否是图片性质
		/// <summary>
		/// 检测MIME字串是否是图片性质
		/// </summary>
		/// <param name="mime"></param>
		/// <returns></returns>
		public bool testMimeIsImage(string mime)
		{
			if(mime.Length < 7)return false;
			string begin = mime.Substring(0,6).ToLower();
			return begin == "image/";
		}
		#endregion

		#region 检测MIME字串是否是音频性质
		/// <summary>
		/// 检测MIME字串是否是音频性质
		/// </summary>
		/// <param name="mime"></param>
		/// <returns></returns>
		public bool testMimeIsAudio(string mime)
		{
			if(mime.Length < 7)return false;
			string begin = mime.Substring(0,6).ToLower();
			return begin == "audio/";
		}
		#endregion

		#region 检测MIME字串是否是视频性质
		/// <summary>
		/// 检测MIME字串是否是礼频性质
		/// </summary>
		/// <param name="mime"></param>
		/// <returns></returns>
		public bool testMimeIsVideo(string mime)
		{
			if(mime.Length < 7)return false;
			string begin = mime.Substring(0,6).ToLower();
			return begin == "video/";
		}
		#endregion

		#region 检测是否是支持的文件扩大名
		/// <summary>
		/// 检测是否是支持的文件扩大名
		/// </summary>
		/// <param name="ext">扩大名,若是是空字串,则默认都是不能通过检测</param>
		/// <param name="extcoll">扩大句列表,用|分隔,若是是空字串,则默认都是通过检测</param>
		/// <returns>了局</returns>
		public bool testIsSupportFileExtent(string ext,string extcoll)
		{
			if(ext == "") return false;
			if(extcoll == "") return true;
			ext = ext.Trim().ToLower();
			char[] sep = {','};
			string[] extarr = extcoll.Split(sep);
			for(int i=0;i<extarr.Length;i++)
			{
				if(extarr[i].Trim().ToLower()==ext)return true;
			}
			return false;
		}
		#endregion

		#region 图片按比例缩幼到指定领域
		/// <summary>
		/// 图片按比例缩幼到指定领域
		/// </summary>
		/// <param name="standard_width">尺度宽度</param>
		/// <param name="standard_height">尺度高度</param>
		/// <param name="input_ImgUrl">要处置图片蹊径</param>
		/// <param name="out_ImgUrl">处置结束图片蹊径,jpg扩大名</param>
		public bool ImgLimitedSize(int standard_width,int standard_height,string input_ImgUrl,string out_ImgUrl)
		{
			int Reduce_Width=0; // 缩幼的宽度
			int Reduce_Height=0; // 缩幼的高度

			// ===通过衔接创建Image对象===
			System.Drawing.Image oldimage = System.Drawing.Image.FromFile(input_ImgUrl);
			int oldWidth = oldimage.Size.Width;//原始宽度
			int oldHeight = oldimage.Size.Height;//原始高度
			System.Guid guid = oldimage.RawFormat.Guid;
		
			if(oldWidth < standard_width && oldHeight < standard_height)
			{
				oldimage.Dispose();
				if(input_ImgUrl!=out_ImgUrl)
				{
					System.IO.FileInfo file = new FileInfo(input_ImgUrl);
					file.CopyTo(out_ImgUrl,true);
				}
				return true;
			}
			else
			{
				//凭据指标大幼调整缩幼后高宽
				float aimpp = (float)standard_width/(float)standard_height;
				float oldpp = (float)oldWidth/(float)oldHeight;
				float reducepp;
				if(aimpp == oldpp)
				{
					Reduce_Width = standard_width;
					Reduce_Height = standard_height;
				}
				else if(aimpp>oldpp)
				{
					reducepp = (float)standard_height/(float)oldHeight;
					Reduce_Width = Convert.ToInt32(reducepp*oldWidth);
					Reduce_Height = standard_height;
				}
				else
				{
					reducepp = (float)standard_width/(float)oldWidth;
					Reduce_Width = standard_width;
					Reduce_Height = Convert.ToInt32(reducepp*oldHeight);
				}
			}

			//新建一个bmp图片   
			System.Drawing.Image bitmap = new System.Drawing.Bitmap(Reduce_Width,Reduce_Height);   
    
			//新建一个画板   
			Graphics g = System.Drawing.Graphics.FromImage(bitmap);   
    
			//设置高质量插值法   
			g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.High;   
    
			//设置高质量,低快率出现滑润水平   
			g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;   
    
			//清空画布并以通明布景致填充   
			g.Clear(Color.Transparent);                   
    
			//按指定的高宽领域比例缩幼图片   
			g.DrawImage(oldimage, new Rectangle(0,0,Reduce_Width,Reduce_Height),new Rectangle(0, 0, oldWidth, oldHeight),GraphicsUnit.Pixel);   
    
			try   
			{                           
				ImageFormat saveformat = oldimage.RawFormat;
				oldimage.Dispose();
				//以原始体式保留缩略图   
				bitmap.Save(out_ImgUrl, saveformat);   
			}   
			catch(System.Exception e)   
			{   
				throw e;   
			}   
			finally
			{   
				bitmap.Dispose();                                                   
				g.Dispose();   
			}
			return true;
		}
		#endregion

		#region 缩放图片到指定大幼
		/// <summary>
		/// 缩放图片到指定大幼(必要裁剪)
		/// </summary>
		/// <param name="standard_width">尺度宽度</param>
		/// <param name="standard_height">尺度高度</param>
		/// <param name="input_ImgUrl">要处置图片蹊径</param>
		/// <param name="out_ImgUrl">处置结束图片蹊径,jpg扩大名</param>
		/// <returns>是否成功</returns>
		public bool ImgFixedSize(int standard_width,int standard_height,string input_ImgUrl,string out_ImgUrl)
		{
			int CutX=0;//裁剪X坐标
			int CutY=0;//裁剪Y坐标
			int CutWidth;//裁剪宽度
			int CutHeight;//裁剪调试

			// ===通过衔接创建Image对象===
			System.Drawing.Image oldimage = System.Drawing.Image.FromFile(input_ImgUrl);
			int oldWidth = oldimage.Size.Width;//图片原始宽度
			int oldHeight = oldimage.Size.Height;//图片原始高度
			System.Guid guid = oldimage.RawFormat.Guid;

			float aimpp = (float)standard_width/(float)standard_height;
			float oldpp = (float)oldWidth/(float)oldHeight;

			if(aimpp == oldpp)
			{
				CutWidth = oldWidth;
				CutHeight = oldHeight;
			}
			else if(aimpp > oldpp)
			{
				CutWidth = oldWidth;
				CutHeight = Convert.ToInt32((float)standard_height * ((float)oldWidth/(float)standard_width));
				CutX = 0;
				CutY = (oldHeight-CutHeight)/2;
			}
			else
			{
				CutWidth = Convert.ToInt32((float)standard_width * ((float)oldHeight/(float)standard_height));
				CutHeight = oldHeight;
				CutX = (oldWidth-CutWidth)/2;
				CutY = 0;
			}

			//新建一个bmp图片   
			System.Drawing.Image bitmap = new System.Drawing.Bitmap(standard_width,standard_height);   
    
			//新建一个画板   
			Graphics g = System.Drawing.Graphics.FromImage(bitmap);   
    
			//设置高质量插值法   
			g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.High;   
    
			//设置高质量,低快率出现滑润水平   
			g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;   
    
			//清空画布并以通明布景致填充   
			g.Clear(Color.Transparent);                   
    
			//在指定地位并且按指定大幼绘造原图片的指定部门   
			g.DrawImage(oldimage, new Rectangle(0,0,standard_width,standard_height), new Rectangle(CutX, CutY, CutWidth, CutHeight), GraphicsUnit.Pixel);   
    
			try   
			{                           
				ImageFormat saveformat = oldimage.RawFormat;
				oldimage.Dispose();
				//以原始体式保留缩略图   
				bitmap.Save(out_ImgUrl, saveformat);   
			}   
			catch(System.Exception e)   
			{   
				throw e;   
			}   
			finally
			{   
				bitmap.Dispose();                                                   
				g.Dispose();   
			}

			return true;

		}
		#endregion

		#region 缩放图片到指定的宽或高
		public bool ImgLimitWidthOrHeight(int standard,string input_ImgUrl,string out_ImgUrl)
		{
			return ImgLimitWidthOrHeight(standard,input_ImgUrl,out_ImgUrl,"width");
		}
		/// <summary>
		/// 缩放图片到指定的宽或高
		/// </summary>
		/// <param name="standard">尺度宽度</param>
		/// <param name="input_ImgUrl">要处置图片蹊径</param>
		/// <param name="out_ImgUrl">处置结束图片蹊径</param>
		/// <param name="WidthOrHeight">指定以长或宽为尺度,width或height</param>
		/// <returns>是否成功</returns>
		public bool ImgLimitWidthOrHeight(int standard,string input_ImgUrl,string out_ImgUrl,string WidthOrHeight)
		{
			int Reduce_Width=0; // 缩幼的宽度
			int Reduce_Height=0; // 缩幼的高度

			// ===通过衔接创建Image对象===
			System.Drawing.Image oldimage = System.Drawing.Image.FromFile(input_ImgUrl);
			int oldWidth = oldimage.Size.Width;//原始宽度
			int oldHeight = oldimage.Size.Height;//原始高度
			System.Guid guid = oldimage.RawFormat.Guid;

			float aimpp;

			WidthOrHeight = WidthOrHeight.ToLower().Trim();
			if(WidthOrHeight=="width")
			{
				aimpp = (float)standard/(float)oldWidth;
				Reduce_Width = standard;
				Reduce_Height = (int)((float)oldHeight*aimpp);
			}
			else
			{
				aimpp = (float)standard/(float)oldHeight;
				Reduce_Width = (int)((float)oldWidth*aimpp);
				Reduce_Height = standard;
			}
		
			//新建一个bmp图片   
			System.Drawing.Image bitmap = new System.Drawing.Bitmap(Reduce_Width,Reduce_Height);   
    
			//新建一个画板   
			Graphics g = System.Drawing.Graphics.FromImage(bitmap);   
    
			//设置高质量插值法   
			g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.High;   
    
			//设置高质量,低快率出现滑润水平   
			g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality;   
    
			//清空画布并以通明布景致填充   
			g.Clear(Color.Transparent);                   
    
			//按指定的高宽领域比例缩幼图片   
			g.DrawImage(oldimage, new Rectangle(0,0,Reduce_Width,Reduce_Height),new Rectangle(0, 0, oldWidth, oldHeight),GraphicsUnit.Pixel);   
    
			try   
			{                           
				ImageFormat saveformat = oldimage.RawFormat;
				oldimage.Dispose();
				//以原始体式保留缩略图   
				bitmap.Save(out_ImgUrl, saveformat);   
			}   
			catch(System.Exception e)   
			{   
				throw e;   
			}   
			finally
			{   
				bitmap.Dispose();                                                   
				g.Dispose();   
			}
			return true;
		}
		#endregion

		#region 获取图片文件长宽
		/// <summary>
		/// 获取图片文件长宽
		/// </summary>
		/// <param name="filepath">图片蹊径</param>
		/// <returns>蕴含长宽数据的ArrayList</returns>
		public ArrayList getImageWidthAndHeight(string filepath)
		{
			ArrayList arr = new ArrayList(2);
			try
			{
				System.Drawing.Image img = System.Drawing.Image.FromFile(filepath);
				arr[0] = img.Width;
				arr[1] = img.Height;
				img.Dispose();
			}
			catch
			{
				arr[0]=-1;
				arr[1]=-1;
			}
			return arr;
		}
		#endregion

		#region 测试图片是否超过指定大幼
		/// <summary>
		/// 测试图片是否超过指定大幼
		/// </summary>
		/// <param name="filepath">图片文件地址(磁盘绝对地址)</param>
		/// <param name="width">指定宽</param>
		/// <param name="height">指定高</param>
		/// <returns>了局</returns>
		public bool testImageOverSize(string filepath,int width,int height)
		{
			ArrayList wh = this.getImageWidthAndHeight(filepath);
			int w = (int)wh[0];
			int h = (int)wh[1];
			if(w<1 || h<1)
			{
				return true;
			}
			else
			{
				return w>width || h>height;
			}
		}
		#endregion

		#region 创建文件夹名
		/// <summary>
		/// 职能:创建文件名
		/// 返回:文件夹名foldername
		/// 编写人:简清舟
		/// </summary>
		/// <returns></returns>
		public  string CreateFolderName()
		{
			DateTime time=System.DateTime.Now;//取功夫
			string foldername=time.Year.ToString()+time.Month.ToString();//创建文件夹名
			return foldername;//返回文件名
		}
		#endregion

		#region 创建文件夹
		/// <summary>
		/// 职能:创建文件夹
		/// 参数:path是文件的蹊径
		/// 编写人:简清舟
		/// </summary>
		/// <param name="path">文件蹊径</param>
		public bool CreateFolder(string path,Page page)
		{
			
			try 
			{
				path=page.Server.MapPath(path);//
				// 查抄目录是否存在
				if (Directory.Exists(path)) 
				{
					//Response.Write("目录已经存在.");
					return true;
				}
                    
				// 创建目录
				DirectoryInfo di = Directory.CreateDirectory(path);
				//Response.Write("目录应创建成功");

				// 删除目录
				//di.Delete();
				//Console.WriteLine("目录已经删除.");
				return true;
			} 
			catch
			{
				return false;
				//Response.Write("<script>alert('z8系统提醒您:目录创建失败!')</script>");
			} 
				
		}
		#endregion

		#region 删除HTML标签"<...>"
		/// <summary>
		///  删除字串中的HTML标签
		/// </summary>
		/// <param name="txt">原始字串</param>
		/// <returns>了局字串</returns>
		public string DeleteHtmlTag(string txt)
		{
			System.Text.RegularExpressions.Regex reg = new System.Text.RegularExpressions.Regex("<[^>]{1,}>");
			return reg.Replace(txt,"");
		}
		#endregion		
		

		#region 把数字转换为以Kb或Mb或T暗示的容量
		/// <summary>
		/// 把数字转换为以Kb或Mb或T暗示的容量
		/// </summary>
		/// <param name="size">数字(字节)</param>
		/// <returns>暗示步骤</returns>
		public string ConvertLongToVolumeString(long size)
		{
			double rtnvol = 0;
			if(size < 1024)
			{
				return size.ToString()+"Bit";
			}
			else if(size < 1048576)
			{
				rtnvol = (double)size / 1024.0;
				return rtnvol.ToString("f2")+"KB";
			}
			else if(size < 1073741824)
			{
				rtnvol = (double)size / 1048576.0;
				return rtnvol.ToString("f2")+"MB";
			}
			else if(size < 1099511627776)
			{
				rtnvol = (double)size / 1073741824.0;
				return rtnvol.ToString("f2")+"GB";
			}
			else
			{
				rtnvol = (double)size / 1099511627776.0;
				return rtnvol.ToString("f2")+"T";
			}
		}
		#endregion
		
		#region 输出MediaPlayer播放器代码
		/// <summary>
		/// 输出MediaPlayer播放器代码
		/// </summary>
		/// <param name="url">URL</param>
		/// <param name="auto">是否自动播放</param>
		/// <returns>代码</returns>
		public string GetMediaPlayCodes(string url,bool auto)
		{
			return this.GetMediaPlayCodes(url,auto,true);
		}

		public string GetMediaPlayCodes(string url,bool auto,bool withSkin)
		{
			StringBuilder sbframe = new StringBuilder();
			if(withSkin)
			{
				sbframe.Append("<table width=\"350\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\"><tr><td colspan=\"3\"><img src=\"player_imgs/1_13.gif\" width=\"350\" height=\"17\" /></td></tr><tr><td width=\"19\" height=\"0\"><img src=\"player_imgs/1_14.gif\" width=\"19\" height=\"210\" /></td><td style=\"width:312px;height:210px;background-color:#000000;\">{$PlayerCode}</td><td width=\"19\" align=\"right\"><img src=\"player_imgs/1_15.gif\" width=\"19\" height=\"210\" /></td></tr></table>");
				sbframe.Append("<table width=\"350\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\"><tr><td width=\"20\" rowspan=\"4\"><img src=\"player_imgs/1_16.gif\" width=\"20\" height=\"58\" /></td><td height=\"7\" valign=\"bottom\" bgcolor=\"#999999\"></td><td width=\"17\" rowspan=\"4\"><img src=\"player_imgs/1_17.gif\" width=\"17\" height=\"58\" /></td></tr><tr><td height=\"3\" valign=\"bottom\" bgcolor=\"#FFFFFF\"></td></tr><tr><td height=\"6\" valign=\"bottom\" bgcolor=\"#FFFFFF\"><img src=\"player_imgs/1_18.gif\" width=\"313\" height=\"7\" /></td></tr><tr><td height=\"41\" background=\"player_imgs/1_27.gif\">");
				sbframe.Append("<img src=\"player_imgs/pause.gif\" style=\"cursor:pointer;\" onclick=\"javascript:PlayerPause();\" />");
				sbframe.Append("<img src=\"player_imgs/play.gif\" style=\"cursor:pointer;\" onclick=\"javascript:PlayerPlay();\" />");
				sbframe.Append("<img src=\"player_imgs/stop.gif\" style=\"cursor:pointer;\" onclick=\"javascript:PlayerStop();\" />");
				sbframe.Append("<img src=\"player_imgs/fullscreen.gif\" style=\"cursor:pointer;\" onclick=\"javascript:PlayerFullscreen();\" />");
				sbframe.Append("</td></tr></table>");
			}
			else
			{
				sbframe.Append("{$PlayerCode}");
			}
			StringBuilder sb = new StringBuilder();
			sb.Append("\n<script>\n");
			sb.Append("document.write(\"<object id=\\\"mediaplayer\\\" name=\\\"mediaplayer\\\" classid=\\\"clsid:6BF52A52-394A-11d3-B153-00C04F79FAA6\\\" codebase=\\\"http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=6,1,5,217\\\" type=\\\"application/x-oleobject\\\" width=\\\"100%\\\" height=\\\"100%\\\">\");\n");
			sb.Append("document.write(\"<param name=\\\"uiMode\\\" value=\\\"none\\\">\");\n");
			sb.Append("document.write(\"<param name=\\\"AutoStart\\\" value=\\\"");
			if(auto)
			{
				sb.Append("-1");
			}
			else
			{
				sb.Append("0");
			}
			sb.Append("\\\">\");\n");
			sb.Append("document.write(\"<param name=\\\"StretchToFit\\\" value=\\\"1\\\">\");\n");
			sb.Append("document.write(\"<param name=\\\"EnableContextMenu\\\" value=\\\"0\\\">\");\n");
			sb.Append("document.write(\"<param name=\\\"url\\\" value=\\\""+url+"\\\">\");\n");
			sb.Append("if(!window.ActiveXObject)");
			sb.Append("document.write(\"<embed id=\\\"mediaplayer2\\\" name=\\\"mediaplayer_2\\\" type=\\\"application/x-mplayer2\\\" pluginspage=\\\"http://www.microsoft.com/Windows/Downloads/Contents/Products/MediaPlayer/\\\" filename=\\\""+url+"\\\" src=\\\""+url+"\\\" autostart=\\\"1\\\" ShowControls=1 ShowDisplay=0 ShowStatusBar=0 autosize=0 width=\\\"100%\\\" height=\\\"100%\\\" uiMode=\\\"full\\\" StretchToFit=\\\"1\\\" EnableContextMenu=\\\"1\\\"></embed>\");\n");
			sb.Append("document.write(\"</object>\");\n");
			sb.Append("var _player = document.getElementById(\"mediaplayer\");\n");
			sb.Append("var _controls = _player.controls;\n");
			sb.Append("function PlayerPlay(){if(_player.playState == 3){return;}_controls.play();}\n");
			sb.Append("function PlayerPause(){_controls.pause();}\n");
			sb.Append("function PlayerStop(){_player.autoStart=false;_player.URL = _player.URL;_controls.stop();}\n");
			sb.Append("function PlayerFullscreen(){if(_player.playState == 3){_player.fullscreen=true;}else{return;}}\n");
			sb.Append("</script>\n");
			sbframe.Replace("{$PlayerCode}",sb.ToString());
			return sbframe.ToString();
		}

		public string GetMediaPlayCodes(string url,bool auto,string mode)
		{
			StringBuilder sb = new StringBuilder();
			sb.Append("\n<object id=\"mediaplayer\" name=\"mediaplayer\" classid=\"clsid:6BF52A52-394A-11d3-B153-00C04F79FAA6\" codebase=\"http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=6,1,5,217\" type=\"application/x-oleobject\" width=\"100%\" height=\"100%\">\n");
			sb.Append("<param name=\"uiMode\" value=\""+mode.Trim()+"\">\n");
			sb.Append("<param name=\"AutoStart\" value=\"");
			if(auto)
			{
				sb.Append("-1");
			}
			else
			{
				sb.Append("0");
			}
			sb.Append(">\n");
			sb.Append("<param name=\"StretchToFit\" value=\"1\">\n");
			sb.Append("<param name=\"EnableContextMenu\" value=\"0\">\n");
			sb.Append("<param name=\"url\" value=\""+url+"\">\n");
			sb.Append("<embed type=\"application/x-mplayer2\" pluginspage=\"http://www.microsoft.com/Windows/Downloads/Contents/Products/MediaPlayer/\" filename=\""+url+"\" src=\""+url+"\" Name=\"mediaplayer\" autostart=\""+auto.ToString()+"\" ShowControls=1 ShowDisplay=0 ShowStatusBar=0 autosize=0 width=\"100%\" height=\"100%\" uiMode=\""+mode+"\" StretchToFit=\"1\" EnableContextMenu=\"0\"></embed>\n");
			sb.Append("</object>\n");
			return sb.ToString();
		}
		#endregion

		#region 传入一字符串,返回拼音首字母
		/// <summary>
		/// 传入一字符串,返回字串第一个字符的拼音首字母
		/// </summary>
		/// <param name="str">传入字串</param>
		/// <returns>首字母</returns>
		public string GetStringCapital(string str)
		{
			if(str.Length < 1)return "";
			string _Temp= str.Substring(0,1);
			if(Convert.ToChar(_Temp)>=0 && Convert.ToChar(_Temp)<256)	return _Temp;

			if(_Temp.CompareTo("吖")<0)
			{
				return str;
			}
			if(_Temp.CompareTo("八")<0)
			{
				return "A";
			}

			if(_Temp.CompareTo("嚓")<0)
			{
				return "B";
			}

			if(_Temp.CompareTo("咑")<0)
			{
				return "C";
			}
			if(_Temp.CompareTo("妸")<0)
			{
				return "D";
			}
			if(_Temp.CompareTo("发")<0)
			{
				return "E";
			}
			if(_Temp.CompareTo("旮")<0)
			{
				return "F";
			}
			if(_Temp.CompareTo("铪")<0)
			{
				return "G";
			}
			if(_Temp.CompareTo("讥")<0)
			{
				return "H";
			}
			if(_Temp.CompareTo("咔")<0)
			{
				return "J";
			}
			if(_Temp.CompareTo("垃")<0)
			{
				return "K";
			}
			if(_Temp.CompareTo("嘸")<0)
			{
				return "L";
			}
			if(_Temp.CompareTo("拏")<0)
			{
				return "M";
			}
			if(_Temp.CompareTo("噢")<0)
			{
				return "N";
			}
			if(_Temp.CompareTo("妑")<0)
			{
				return "O";
			}
			if(_Temp.CompareTo("七")<0)
			{
				return "P";
			}
			if(_Temp.CompareTo("亽")<0)
			{
				return "Q";
			}
			if(_Temp.CompareTo("仨")<0)
			{
				return "R";
			}
			if(_Temp.CompareTo("他")<0)
			{
				return "S";
			}
			if(_Temp.CompareTo("哇")<0)
			{
				return "T";
			}
			if(_Temp.CompareTo("夕")<0)
			{
				return "W";
			}
			if(_Temp.CompareTo("丫")<0)
			{
				return "X";
			}
			if(_Temp.CompareTo("帀")<0)
			{
				return "Y";
			}
			if(_Temp.CompareTo("咗")<0)
			{
				return "Z";
			}
			return _Temp;
		}
		#endregion 

        #region 治理员登录及权限验证
        /// <summary>
        /// 治理登录及权限验证
        /// </summary>
        /// <param name="page">WebForm</param>
        /// <param name="right">权限字串</param>
        public void checkAdminAccessRights(System.Web.UI.Page page, string right)
        {
            right = right.ToLower();
            //if (page.Session["AdminLogId"] == null || page.Session["AdminLogId"].ToString().Trim() != page.Session.SessionID)
            //{
            //    page.Response.Write("<script>alert('您长功夫没有操作身份失效请沉新登录!');top.location.href='/Back/admin-login.aspx';</script>");
            //    page.Response.End();
            //    return;
            //}


            if (page.Session["AdminLogId"] == null || page.Session["AdminLogId"].ToString().Trim() != page.Session.SessionID)
            {
                page.Response.Write("<script>top.location.href='/Back/admin-login.aspx';</script>");
                page.Response.End();
                return;
            }


            if (Convert.ToBoolean(page.Session["AdminIsAdmin"].ToString()))
            {
                return;
            }
            System.Collections.Hashtable righttable = (System.Collections.Hashtable)page.Session["AdminRights"];
            if (righttable.ContainsKey(right) == false)
            {
                page.Response.Write(GetShowMessage(""));
                page.Response.End();
                return;
            }
            return;
        }

        /// <summary>
        /// 治理登录及权限验证(所有登录治理都可接见)
        /// </summary>
        /// <param name="page">WebForm</param>
        public void checkAdminAccessRights(System.Web.UI.Page page)
        {
            if (page.Session["AdminLogId"] == null || page.Session["AdminLogId"].ToString().Trim() != page.Session.SessionID)
            {

                //page.Response.Write("<script>alert('您长功夫没有操作身份失效请沉新登录!');top.location.href='/Back/admin-login.aspx';</script>");

                page.Response.Write("<script>top.location.href='/Back/admin-login.aspx';</script>");
                page.Response.End();
                return;
            }

            return;
        }

        /// <summary>
        /// 治理登录及权限验证(权限名从web.config中获取AccessRightsName)
        /// </summary>
        /// <param name="page">WebForm</param>
        public void chekAdminAccessRightsFromWebConfig(System.Web.UI.Page page)
        {
            string right = System.Configuration.ConfigurationSettings.AppSettings["AccessRightsName"].ToString().Trim();

            if (page.Session["AdminLogId"] == null || page.Session["AdminLogId"].ToString().Trim() != page.Session.SessionID)
            {
                //page.Response.Write("<script>alert('您长功夫没有操作身份失效请沉新登录!');top.location.href='/Back/admin-login.aspx';</script>");
                page.Response.Write("<script>top.location.href='/Back/admin-login.aspx';</script>");
                
                
                
                page.Response.End();
                return;
            }
            if (Convert.ToBoolean(page.Session["AdminIsAdmin"].ToString()))
            {
                return;
            }
            System.Collections.Hashtable righttable = (System.Collections.Hashtable)page.Session["AdminRights"];
            if (righttable.ContainsKey(right) == false)
            {
                page.Response.Write(GetShowMessage(""));
                page.Response.End();
                return;
            }
            return;
        }

        /// <summary>
        /// 返回是否拥有指定的权限
        /// </summary>
        /// <param name="page">WebForm</param>
        /// <param name="right">权限名称</param>
        /// <returns>了局</returns>
        public bool hasAccessRights(System.Web.UI.Page page, string right)
        {
            right = right.ToLower();
            if (page.Session["AdminLogId"] == null || page.Session["AdminLogId"].ToString().Trim() != page.Session.SessionID)
            {
                return false;
            }
            if (Convert.ToBoolean(page.Session["AdminIsAdmin"].ToString()))
            {
                return true;
            }
            System.Collections.Hashtable righttable = (System.Collections.Hashtable)page.Session["AdminRights"];
            if (righttable.ContainsKey(right) == false)
            {
                return false;
            }
            return true;
        }
        /// <summary>
        /// 返回是否登录
        /// </summary>
        /// <param name="page">WebForm</param>
        /// <returns>了局</returns>
        public bool hasAccessRights(System.Web.UI.Page page)
        {
            if (page.Session["AdminLogId"] == null || page.Session["AdminLogId"].ToString().Trim() != page.Session.SessionID)
            {
                return false;
            }
            else
            {
                return true;
            }
        }
        /// <summary>
        /// 返回是否是超等治理员
        /// </summary>
        /// <param name="page">WebForm</param>
        /// <returns>是否是超管</returns>
        public bool IsSuperAdmin(System.Web.UI.Page page)
        {
            if (page.Session["AdminLogId"] == null || page.Session["AdminLogId"].ToString().Trim() != page.Session.SessionID)
            {
                return false;
            }
            return Convert.ToBoolean(page.Session["AdminIsAdmin"].ToString());
        }



        /// <summary>
        /// 返回角色名称
        /// </summary>
        /// <param name="code">角色编号</param>
        /// <returns>角色名称</returns>
        public string GetRoleName(int code)
        {
            return this.GetRoleName(code, this.GetRolesTable());
        }
        /// <summary>
        /// 返回角色名称
        /// </summary>
        /// <param name="code">角色编号</param>
        /// <param name="dt">角色编号对应表</param>
        /// <returns>角色名称</returns>
        public string GetRoleName(int code, DataTable dt)
        {
            foreach (DataRow row in dt.Rows)
            {
                if (Int32.Parse(row["id"].ToString()) == code)
                {
                    return row["Name"].ToString();
                }
            }
            return "";
        }
        /// <summary>
        /// 返回角色表
        /// </summary>
        /// <returns>数据表</returns>
        public DataTable GetRolesTable()
        {
            DataTable dt = new DBCommon().GetDataTableBySql("select Id,Name From AdminRoles");
            return dt;
        }
        #endregion

		#region 将System.Web.HttpPostedFile 转化为byte[] 
		/// <summary>
		///函数名称:PostedFileToBytes
		///函数机能职能描述:将System.Web.HttpPostedFile 转化为byte[] 
		///本函数挪用的类与函数清单:
		/// </summary>
		/// <returns>byte[]</returns>
		public byte[] PostedFileToBytes(System.Web.HttpPostedFile PostFile)
		{
			int FileSize=PostFile.ContentLength;	//大幼
			byte[] fileContent;//现实文件的数据.
			string FileType=PostFile.ContentType;//发送文件的MIME内容类型
			BinaryReader AttContent=new BinaryReader(PostFile.InputStream);//获得文件的流
			AttContent.BaseStream.Seek(0,SeekOrigin.Begin);
			return fileContent=AttContent.ReadBytes(FileSize);//获得文件的字节流
		}
		#endregion 

		#region 从蹊径大局的字串中提取文件名
		/// <summary>
		/// 从蹊径大局的字串中提取文件名
		/// </summary>
		/// <param name="path">蹊径</param>
		/// <param name="withext">是否带扩大名</param>
		/// <returns>文件名</returns>
		public string GetFileName(string path,bool withext)
		{
			int last = path.LastIndexOf("\\");
			if(last>=0)
			{
				path = path.Substring(last+1);
			}
			last = path.LastIndexOf(".");
			if(withext||last<0)
			{
				return path;
			}
			else
			{
				return path.Substring(0,last);
			}
		}

		/// <summary>
		/// 从蹊径大局的字串中提取文件名
		/// </summary>
		/// <param name="path">蹊径</param>
		/// <returns>文件名</returns>
		public string GetFileName(string path)
		{
			return this.GetFileName(path,true);
		}
		#endregion		

		#region 要求internet页面Html源码

		/// <summary>
		/// 要求并下载页面
		/// </summary>
		/// <returns>The data downloaded from the page</returns>
		
		public string GetPageHTML(string url)
		{
			string m_uri=url;
			WebResponse response = null;
			Stream stream = null;
			StreamReader reader = null;

			try
			{
				//----------返回被要求的internet上的资源---------
				HttpWebRequest request = (HttpWebRequest)WebRequest.Create(m_uri);			
				response = request.GetResponse();
				stream = response.GetResponseStream();	
				//------------------------------
				if( !response.ContentType.ToLower().StartsWith("text/") )//若是类型不是text 就挪用SaveBinaryFile写成二近造文件
				{
					//SaveBinaryFile(response);//写二进造文件
					return null;
				}

				string buffer = "",line;

				reader = new StreamReader(stream,Encoding.GetEncoding("gb2312"));
			
				while( (line = reader.ReadLine())!=null )
				{
					buffer+=line+"\r\n";
				}
				return buffer;
			}
				//catch(WebException e)
			catch
			{
				return "";
			}
				//catch(IOException e)
		 
			finally
			{
				if( reader!=null ) reader.Close();
				if( stream!=null ) stream.Close();
				if( response!=null ) response.Close();
			}
		}
		 
		/// <summary>
		/// 信息写入磁盘
		/// </summary>
		/// <param name="buffer">写入内容</param>
		/// <param name="Path">写入的现实地址和齐全的文件名称</param>
		/// <returns></returns>
		public  bool SaveTextFile(string buffer,string Path)// 保留文本文件
		{
			if(Path=="")
				return false;

			string filename = Path;//创建文件名和文件目录
			try
			{
				StreamWriter outStream = new StreamWriter(filename,false,Encoding.GetEncoding("gb2312"));
				//写磁盘
				outStream.Write(buffer);
				outStream.Close();
				return true;
			}
			catch
			{
				return false;
			}
		}

		/// <summary>
		/// 天生静态页面
		/// </summary>
		/// <param name="url">资源页面URL地址</param>
		/// <param name="htmlfileAbsPath">天生的目录html文件绝对蹊径</param>
		/// <returns>是否天生成功</returns>
		public bool GenHTML(string url,string htmlfileAbsPath,Page page)
		{
			try
			{
				string source = this.GetPageHTML(url);

				if(source.ToString()!="")
				{
					this.SaveTextFile(source,htmlfileAbsPath);
				
					return true;
				}
				else
				{
					return false;
				}
			}
			catch
			{
				return false;
			}
		}
		#endregion

		#region 批改DataGrid导航的形状,加“页码:”
		/// <summary>
		/// 批改DataGrid导航的形状
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		public void DataGridItemCreatedPager(object sender,System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemType==ListItemType.Pager)
			{
				Label  lab=new Label();
				lab.Text="页码:";
				e.Item.Cells[0].Controls.AddAt(0,lab);
				e.Item.Font.Bold=true;
				e.Item.Attributes.Add("style","color:red");
			}
		}
		/// <summary>
		/// 批改DataGrid导航的形状
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		public void DataGridItemCreatedPager(object sender,System.Web.UI.WebControls.DataGridItemEventArgs e,int TotalRow)
		{
			if(e.Item.ItemType==ListItemType.Pager)
			{
				Label  lab=new Label();
				lab.Text="页码:";
				Label  lab2=new Label();
				lab2.Text="&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;共"+TotalRow.ToString()+"笔纪录";
				e.Item.Cells[0].Controls.AddAt(0,lab);
				e.Item.Cells[0].Controls.Add(lab2);
				e.Item.Font.Bold=true;
				e.Item.Attributes.Add("style","color:red");
			}
		}
		#endregion		

		#region 使用正则方式代替字串
		/// <summary>
		/// 使用正则方式代替字串
		/// </summary>
		/// <param name="txt">要进行操作的字串</param>
		/// <param name="reg">正则字串</param>
		/// <param name="replace">代替字串</param>
		/// <returns>了局字串</returns>
		public string RegReplace(string txt,string reg,string replace)
		{
			System.Text.RegularExpressions.Regex regex = new System.Text.RegularExpressions.Regex(reg);
			return regex.Replace(txt,replace);
		}
		#endregion

		#region 焦点新闻Flash图片
		/// <summary>
		/// 焦点新闻图片
		/// </summary>
		/// <param name="pics">图片(体式:imgUrl1+"|"+imgUrl2+"|"+imgUrl3)</param>
		/// <param name="links">链接(体式:imgLink1+"|\"+imgLink2+"|"+imgLink3)</param>
		/// <param name="texts">文字(体式:imgtext1+"|"+imgtext2+"|"+imgtext3)</param>
		/// <returns></returns>
		public string GetNewsFocusPhoto(string pics,string links,string texts,int focus_width,int focus_height,int text_height,string bgcolor)
		{
			string str="";

			str+="<div>";
			str+="<!-- flash滚动焦点图 begin -->";
			str+="<!--焦点图起头-->";
			str+="<a target=\"_self\" href=\"javascript:goUrl()\">";
			str+="<span class=\"f14b\">";
			str+="<script type=\"text/javascript\">";
	

			str+="var focus_width="+focus_width.ToString()+";";
			str+="var focus_height="+focus_height.ToString()+";";
			str+="var text_height="+text_height.ToString()+";";
			int flashheight=focus_height+text_height;
			str+="var swf_height ="+flashheight.ToString()+";";

			str+="var pics=\""+pics.ToString()+"\";";
			str+="var links=\""+links.ToString()+"\";";
			str+="var texts=\""+texts.ToString()+"\";";
			str+="var bgcolor=\""+bgcolor.ToString()+"\";";

			str+="document.write('<object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" codebase=\"http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0\" width=\"'+ focus_width +'\" height=\"'+ swf_height +'\">');";
			str+="document.write('<param name=\"allowScriptAccess\" value=\"sameDomain\"><param name=\"movie\" value=\"/images/focus.swf\"><param name=\"quality\" value=\"high\"><param name=\"bgcolor\" value=\"'+bgcolor+'\">');";
			str+="document.write('<param name=\"menu\" value=\"false\"><param name=wmode value=\"opaque\">');";
			str+="document.write('<param name=\"FlashVars\" value=\"pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'\">');";
			str+="document.write('<embed src=\"/images/focus.swf\" wmode=\"opaque\" FlashVars=\"pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'\" menu=\"false\" bgcolor=\"'+bgcolor+'\" quality=\"high\" width=\"'+ focus_width +'\" height=\"'+ focus_height +'\" allowScriptAccess=\"sameDomain\" type=\"application/x-shockwave-flash\" pluginspage=\"http://www.macromedia.com/go/getflashplayer\" />');  document.write('</object>');";


			str+="</script>";
			str+="</span></a><span id=\"focustext\" class=\"f14b\"></span>";
			str+="<!--焦点图实现-->";
			str+="<!-- flash滚动焦点图 end -->";
			str+="</div>";
			return str;

		}
		#endregion

		#region 天生页码导航
		/// <summary>
		/// 天生页码导航字串
		/// </summary>
		/// <param name="PagerType">导航大局</param>
		/// <param name="CurrentPage">当前页</param>
		/// <param name="TotalPages">总页数</param>
		/// <param name="GroupSize">页码分组大幼</param>
		/// <param name="OtherParam">其它链接参数</param>
		/// <returns>导航html字串</returns>
		public string GenPager(int PagerType,int CurrentPage,int TotalPages,int GroupSize,string OtherParam)
		{
			if(OtherParam.Length>0 && OtherParam.Substring(0,1)!="&")OtherParam = "&"+OtherParam;

			StringBuilder sb = new StringBuilder();
			int GroupStart;
			int PageEnd;
			switch(PagerType)
			{
				default:
					//style:上一页 ...2,3,4,5,6,7...下一页
					if(CurrentPage>1)
					{
						sb.Append("<a href=\"?page="+Convert.ToString(CurrentPage-1)+OtherParam+"\">上一页</a>&nbsp;");
					}
					else
					{
						sb.Append("<a href=\"javascript:void(0);\">上一页</a>&nbsp;");
					}


					//天生主体部门
					if(CurrentPage % GroupSize == 0)
					{
						GroupStart = (CurrentPage/GroupSize)-1;
					}
					else
					{
						GroupStart = (int)(CurrentPage/GroupSize);
					}
					if(GroupStart<0)GroupStart = 0;
					PageEnd = (GroupStart+1)*GroupSize;
					if(PageEnd>TotalPages)PageEnd = TotalPages;

					///前一组
					if(GroupStart>0) sb.Append(" <a href=\"?page="+Convert.ToString((GroupStart-1)*GroupSize+1)+OtherParam+"\">...</a> ");
					for(int i=GroupStart*GroupSize+1;i<=PageEnd;i++)
					{
						if(i!=CurrentPage)
						{
							sb.Append(" <a href=\"?page="+i.ToString()+OtherParam+"\">"+i.ToString()+"</a> ");
						}
						else
						{
							sb.Append(" <span class=\"numbernolink\">"+i.ToString()+"</span> ");
						}
					}
					///后一组
					if(TotalPages>PageEnd) sb.Append(" <a href=\"?page="+Convert.ToString(PageEnd+1)+OtherParam+"\">...</a> ");

					//天生[>]
					if(CurrentPage<TotalPages)
					{
						sb.Append("&nbsp;<a href=\"?page="+Convert.ToString(CurrentPage+1)+OtherParam+"\">下一页</a>");
					}
					else
					{
						sb.Append("&nbsp;<a href=\"javascript:void(0);\">下一页</a>");
					}
					break;
			}
			return sb.ToString();
		}


		/// <summary>
		/// 天生页码导航字串
		/// </summary>
		/// <param name="PagerType">导航大局</param>
		/// <param name="CurrentPage">当前页</param>
		/// <param name="TotalPages">总页数</param>
	    /// <param name="TotalRecord">纪录总数</param>
		/// <param name="GroupSize">页码分组大幼</param>
		/// <param name="OtherParam">其它链接参数</param>
		/// <returns>导航html字串</returns>
		public string GenPager(int PagerType,int CurrentPage,int TotalPages,int TotalRecord,int GroupSize,string OtherParam)
		{
			if(OtherParam.Length>0 && OtherParam.Substring(0,1)!="&")OtherParam = "&"+OtherParam;

			StringBuilder sb = new StringBuilder();
			int GroupStart;
			int PageEnd;
			switch(PagerType)
			{
				case 1:
					//style:共477页 总计18748笔纪录  上一页 ...2,3,4,5,6,7...下一页
					sb.Append("共"+TotalPages.ToString()+"页 "+"总计"+TotalRecord.ToString()+"笔纪录  ");
					if(CurrentPage>1)
					{
						sb.Append("<a href=\"?page="+Convert.ToString(CurrentPage-1)+OtherParam+"\">上一页</a>&nbsp;");
					}
					else
					{
						sb.Append("<a href=\"javascript:void(0);\">上一页</a>&nbsp;");
					}


					//天生主体部门
					if(CurrentPage % GroupSize == 0)
					{
						GroupStart = (CurrentPage/GroupSize)-1;
					}
					else
					{
						GroupStart = (int)(CurrentPage/GroupSize);
					}
					if(GroupStart<0)GroupStart = 0;
					PageEnd = (GroupStart+1)*GroupSize;
					if(PageEnd>TotalPages)PageEnd = TotalPages;

					///前一组
					if(GroupStart>0) sb.Append(" <a href=\"?page="+Convert.ToString((GroupStart-1)*GroupSize+1)+OtherParam+"\">...</a> ");
					for(int i=GroupStart*GroupSize+1;i<=PageEnd;i++)
					{
						if(i!=CurrentPage)
						{
							sb.Append(" <a href=\"?page="+i.ToString()+OtherParam+"\">"+i.ToString()+"</a> ");
						}
						else
						{
							sb.Append(" <span class=\"numbernolink\">"+i.ToString()+"</span> ");
						}
					}
					///后一组
					if(TotalPages>PageEnd) sb.Append(" <a href=\"?page="+Convert.ToString(PageEnd+1)+OtherParam+"\">...</a> ");

					//天生[>]
					if(CurrentPage<TotalPages)
					{
						sb.Append("&nbsp;<a href=\"?page="+Convert.ToString(CurrentPage+1)+OtherParam+"\">下一页</a>");
					}
					else
					{
						sb.Append("&nbsp;<a href=\"javascript:void(0);\">下一页</a>");
					}
					break;
				default:
					//style:上一页 ...2,3,4,5,6,7...下一页
					if(CurrentPage>1)
					{
						sb.Append("<a href=\"?page="+Convert.ToString(CurrentPage-1)+OtherParam+"\">上一页</a>&nbsp;");
					}
					else
					{
						sb.Append("<a href=\"javascript:void(0);\">上一页</a>&nbsp;");
					}


					//天生主体部门
					if(CurrentPage % GroupSize == 0)
					{
						GroupStart = (CurrentPage/GroupSize)-1;
					}
					else
					{
						GroupStart = (int)(CurrentPage/GroupSize);
					}
					if(GroupStart<0)GroupStart = 0;
					PageEnd = (GroupStart+1)*GroupSize;
					if(PageEnd>TotalPages)PageEnd = TotalPages;

					///前一组
					if(GroupStart>0) sb.Append(" <a href=\"?page="+Convert.ToString((GroupStart-1)*GroupSize+1)+OtherParam+"\">...</a> ");
					for(int i=GroupStart*GroupSize+1;i<=PageEnd;i++)
					{
						if(i!=CurrentPage)
						{
							sb.Append(" <a href=\"?page="+i.ToString()+OtherParam+"\">"+i.ToString()+"</a> ");
						}
						else
						{
							sb.Append(" <span class=\"numbernolink\">"+i.ToString()+"</span> ");
						}
					}
					///后一组
					if(TotalPages>PageEnd) sb.Append(" <a href=\"?page="+Convert.ToString(PageEnd+1)+OtherParam+"\">...</a> ");

					//天生[>]
					if(CurrentPage<TotalPages)
					{
						sb.Append("&nbsp;<a href=\"?page="+Convert.ToString(CurrentPage+1)+OtherParam+"\">下一页</a>");
					}
					else
					{
						sb.Append("&nbsp;<a href=\"javascript:void(0);\">下一页</a>");
					}
					break;
			}
			return sb.ToString();
		}


		/// <summary>
		/// 返回总也数
		/// </summary>
		/// <param name="GroupSize">页码分组大幼</param>
		/// <param name="TotalRecord">总纪录数</param>
		/// <returns></returns>
		public int  GetTotalPages(int GroupSize ,int TotalRecord)
		{
			int TotalPages=0;
			if(TotalRecord==0)
			{
				return 0;
			}
			if(TotalRecord%GroupSize==0)
			{
				TotalPages=TotalRecord/GroupSize;
			}
			else
			{
				TotalPages=TotalRecord/GroupSize+1;
			}
			return TotalPages;
		}
		#endregion 

		#region IP部门保密处置
		public string IPSafe(string ip)
		{
			int dotStart = ip.LastIndexOf(".")+1;
			if(dotStart<1)return "未知";
			int dotEnd = ip.Length;
			return ip.Remove(dotStart,dotEnd-dotStart)+"*";
		}
		#endregion		

		#region 读取配置节
		/// <summary>
		/// 读取配置节内容
		/// </summary>
		/// <param name="key">配置标识</param>
		/// <returns>了局字串</returns>
		public string GetAppsetting(string key)
		{
			try
			{
				return System.Configuration.ConfigurationSettings.AppSettings[key];
			}
			catch
			{
				return null;
			}
		}
		#endregion

		#region  删除磁盘文件
		/// <summary>
		/// 删除磁盘文件
		/// </summary>
		/// <param name="Path">文件蹊径</param>
		/// <returns></returns>
		public bool DeleteFile(string Path)
		{
			try
			{
				System.IO.File.Delete(Path);
				return true;
			}
			catch
			{
				return false;
			}			
		}
		#endregion

		#region 读取父分类所有的根分类
		public string  GetClsss_Gen(int Pid)
		{
			string Chid="";
			DBCommon DB=new DBCommon();
			//产品分类 
			DataTable DT=DB.GetDataTableBySql("select * from Class where Tid="+Pid.ToString());		
			if(DT!=null&&DT.Rows.Count>0)
			{		
				for(int i=0;i<DT.Rows.Count;i++)
				{					
					Chid+=GetClsss_Gen(Convert.ToInt32(DT.Rows[i]["Classid"]))+",";					
				}
			}
			else
			{
				Chid=Pid.ToString()+",";
			}

			if(Chid!="")
			{
				int wz = Chid.Length - 1;
				Chid = Chid.Substring(0, wz);
			}
			return Chid;
		}	
		#endregion

		#region 产品分类
		/// <summary>
		/// 返回子分类
		/// </summary>
		/// <param name="pid">父id</param>
		/// <returns>返回子分类</returns>
		public DataTable GetPClassDT(int pid)
		{
			DBCommon DB=new DBCommon();
			DataTable DT=DB.GetDataTableBySql("select * from Class where tid="+pid+" and channelId=1 order by  OrderNum asc");
			return DT;
		}
		#endregion

		# region 邵峰注

        #region 代替犯法字符
        public string Sqlstring(string str)
        {
            if (str != null && str != "")
            {
                str = str.Replace("'", "");
                str = str.Replace("\"", "");
                str = str.Replace(";", "");
                str = str.Replace("<", "");
                str = str.Replace(">", "");
                str = str.Replace("(", "");
                str = str.Replace(")", "");
                str = str.Replace("*", "");
                str = str.Replace("select", "");
                str = str.Replace("SELECT", "");
                str = str.Replace("insert", "");
                str = str.Replace("INSERT", "");
                str = str.Replace("update", "");
                str = str.Replace("UPDATE", "");
                str = str.Replace("delete", "");
                str = str.Replace("DELETE", "");
                str = str.Replace("create", "");
                str = str.Replace("CREATE", "");
                str = str.Replace("drop", "");
                str = str.Replace("DROP", "");
                str = str.Replace("delcare", "");
                str = str.Replace("DELCARE", "");
                str = str.Replace("truncate", "");
                str = str.Replace("TRUNCATE", "");
                str = str.Replace("script", "");
                str = str.Replace("SCRIPT", "");
                str = str.Replace("and", "");
                str = str.Replace("AND", "");
                str = FilterXSS(str);
            }
            return str;
        }

        public string Sqlstring(string str, int id)
        {
            if (str != null && str != "")
            {
                str = str.Replace("'", "’");
                str = str.Replace("\"", "”");
                str = str.Replace(";", ";");
                str = str.Replace("<", "[");
                str = str.Replace(">", "]");
                str = str.Replace("(", "(");
                str = str.Replace(")", ")");
                str = str.Replace("*", "×");
                str = str.Replace("\r\n", "<br>");
                str = str.Replace("\n", "<br>");
                str = str.Replace(" ", "&nbsp;");
                str = str.Replace("select", "");
                str = str.Replace("SELECT", "");
                str = str.Replace("insert", "");
                str = str.Replace("INSERT", "");
                str = str.Replace("update", "");
                str = str.Replace("UPDATE", "");
                str = str.Replace("delete", "");
                str = str.Replace("DELETE", "");
                str = str.Replace("create", "");
                str = str.Replace("CREATE", "");
                str = str.Replace("drop", "");
                str = str.Replace("DROP", "");
                str = str.Replace("delcare", "");
                str = str.Replace("DELCARE", "");
                str = str.Replace("truncate", "");
                str = str.Replace("TRUNCATE", "");
                str = str.Replace("script", "");
                str = str.Replace("SCRIPT", "");
                str = str.Replace("and", "");
                str = str.Replace("AND", "");
                str = FilterXSS(str);
            }
            return str;
        }
        #endregion;

        #region 过滤xss攻击剧本
        /// <summary>    
        /// 过滤xss攻击剧本    
        /// </summary>    
        /// <param name="input">传入字符串</param>    
        /// <returns>过滤后的字符串</returns>    
        public string FilterXSS(string html)
        {
            if (string.IsNullOrEmpty(html)) return string.Empty;

            // CR(0a) ,LF(0b) ,TAB(9) 之表,过滤掉所有的不打印出来字符.     
            // 主张预防这样大局的入侵 <java\0script>    
            // 把稳:\n, \r,  \t 可能必要单独处置,由于可能会要用到    
            string ret = System.Text.RegularExpressions.Regex.Replace(
                html, "([\x00-\x08][\x0b-\x0c][\x0e-\x20])", string.Empty);

            //代替所有可能的16进造构建的恶意代码    
            //<IMG SRC=&#X40&#X61&#X76&#X61&#X73&#X63&#X72&#X69&#X70&#X74&#X3A&#X61&_#X6C&#X65&#X72&#X74&#X28&#X27&#X58&#X53&#X53&#X27&#X29>    
            string chars = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890!@#$%^&*()~`;:?+/={}[]-_|'\"\\";
            for (int i = 0; i < chars.Length; i++)
            {
                ret = System.Text.RegularExpressions.Regex.Replace(ret, string.Concat("(&#[x|X]0{0,}", Convert.ToString((int)chars[i], 16).ToLower(), ";?)"),
                    chars[i].ToString(), System.Text.RegularExpressions.RegexOptions.IgnoreCase);
            }

            //过滤\t, \n, \r构建的恶意代码   
            string[] keywords = {"javascript", "vbscript", "expression", "applet", "meta", "xml", "blink", "link", "style", "script", "embed", "object", "iframe", "frame", "frameset", "ilayer", "layer", "bgsound", "title", "base"   
        ,"onabort", "onactivate", "onafterprint", "onafterupdate", "onbeforeactivate", "onbeforecopy", "onbeforecut", "onbeforedeactivate", "onbeforeeditfocus", "onbeforepaste", "onbeforeprint", "onbeforeunload", "onbeforeupdate", "onblur", "onbounce", "oncellchange", "onchange", "onclick", "oncontextmenu", "oncontrolselect", "oncopy", "oncut", "ondataavailable", "ondatasetchanged", "ondatasetcomplete", "ondblclick", "ondeactivate", "ondrag", "ondragend", "ondragenter", "ondragleave", "ondragover", "ondragstart", "ondrop", "onerror", "onerrorupdate", "onfilterchange", "onfinish", "onfocus", "onfocusin", "onfocusout", "onhelp", "onkeydown", "onkeypress", "onkeyup", "onlayoutcomplete", "onload", "onlosecapture", "onmousedown", "onmouseenter", "onmouseleave", "onmousemove", "onmouseout", "onmouseover", "onmouseup", "onmousewheel", "onmove", "onmoveend", "onmovestart", "onpaste", "onpropertychange", "onreadystatechange", "onreset", "onresize", "onresizeend", "onresizestart", "onrowenter", "onrowexit", "onrowsdelete", "onrowsinserted", "onscroll", "onselect", "onselectionchange", "onselectstart", "onstart", "onstop", "onsubmit", "onunload"};

            bool found = true;
            while (found)
            {
                string retBefore = ret;
                for (int i = 0; i < keywords.Length; i++)
                {
                    string pattern = "/";
                    for (int j = 0; j < keywords[i].Length; j++)
                    {
                        if (j > 0)
                            pattern = string.Concat(pattern, '(', "(&#[x|X]0{0,8}([9][a][b]);?)?", "|(&#0{0,8}([9][10][13]);?)?",
                                ")?");
                        pattern = string.Concat(pattern, keywords[i][j]);
                    }
                    string replacement = string.Concat(keywords[i].Substring(0, 2), "<x>", keywords[i].Substring(2));
                    ret = System.Text.RegularExpressions.Regex.Replace(ret, pattern, replacement, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
                    if (ret == retBefore)
                        found = false;
                }

            }

            return ret;
        }
        #endregion

		#region 是否空
		/// <summary>是否空</summary>
		/// <param name="strInput">输入字符串</param>
		/// <returns>true/false</returns>
		private Regex RegNumber = new Regex("^[0-9]+$");
		public bool IsBlank(string strInput)
		{
			if (strInput==null || strInput.Trim()=="") 
			{
				return true;
			}
			else
			{
				return false;
			}
			
		}
		#endregion

		#region 是否数字
		/// <summary>是否数字</summary>
		/// <param name="strInput">输入字符串</param>
		/// <returns>true/false</returns>
		public bool IsNumeric(string strInput)
		{  
		
			if(strInput!=null && strInput!="")
			{
				Match m = RegNumber.Match(strInput);
				return m.Success;
			}
			else
			{
				return false;
			}
			
		}
		#endregion

		#region 是否日期
		/// <summary>是否日期</summary>
		/// <param name="strInput">输入字符串</param>
		/// <returns>true/false</returns>
		public bool isDate(string strInput)
		{
			try
			{
				if(strInput!=null && strInput!="" && strInput.Length>=8)
				{
					string s=strInput.Substring(0,4);
					if(!IsNumeric(s) || int.Parse(s) < 1950)
					{
						return false;
					}
					else
					{
						DateTime t=Convert.ToDateTime(strInput);
						return true;
					}
				}
				else
				{
					return false;
				}
			}
			catch
			{
				return false;
			}
		}
		#endregion

		#region 是否为合法的手机号码
		/// <summary>是否为合法的手机号码</summary>
		/// <param name="strInput">输入字符串</param>
		/// <returns>true/false</returns>
		private Regex RegMobile=new Regex(@"(^(13\d{9})$)|(^(15\d{9})$)");
		public bool isMobile(string strInput)
		{
			if(strInput!=null && strInput!="")
			{
				Match m = RegMobile.Match(strInput);
				return m.Success;
			}
			else
			{
				return false;
			}
		}
		#endregion

		#region 是否为合法的电话号码

		/// <summary>是否为合法的电话号码</summary>
		/// <param name="strInput">输入字符串</param>
		/// <returns>true/false</returns>
		private Regex RegTEL=new Regex(@"(^(\d{7,8})$)|(^(0\d{2,3}\-\d{6,8}(\-\d{1,4})?)$)");
		public bool isTel(string strInput)
		{
			if(strInput!=null && strInput!="")
			{
				Match m = RegTEL.Match(strInput);
				return m.Success;
			}
			else
			{
				return false;
			}
		}
		#endregion

		#region 邮政编码
		/// <summary>
		/// 是否是邮政编码
		/// </summary>
		/// <param name="inputData">输入字符串</param>
		/// <returns></returns>
		private Regex RegZip = new Regex(@"^(\d{6})$");
		public bool IsZip(string inputData)
		{
			if(inputData!=null && inputData!="")
			{
				Match m = RegZip.Match(inputData);
				return m.Success;
			}
			else
			{
				return false;
			}
		}

		#endregion

		#region 是否为身份证号
		/// <summary>
		/// 是否为身份证号
		/// </summary>
		/// <param name="strInput">输入字符串</param>
		/// <returns></returns>
		private  Regex RegIDCard=new Regex("^[1-9]([0-9]{17}|[0-9]{14}|[0-9]{16}[0-9,X,x])$");
		public bool IsIDCard(string strInput)
		{
			if(strInput!=null && strInput!="")
			{
				Match m = RegIDCard.Match(strInput);
				return m.Success;
			}
			else
			{
				return false;
			}
		}
		#endregion

        #region js剧本
        public void Alert(string message, int ID)
        {
            message = this.Sqlstring(message);
            string js = @"<Script language='JavaScript' defer>
                    alert('" + message + "');history.go(" + ID + ");</Script>";
            HttpContext.Current.Response.Write(js);
        }
        public void Alert(string message)
        {
            message = this.Sqlstring(message);
            string js = @"<Script language='JavaScript' defer>
                    alert('" + message + "');</Script>";
            HttpContext.Current.Response.Write(js);
        }
        public void Alert(System.Web.UI.Page page, string message, int ID)
        {
            message = this.Sqlstring(message);
            string js = @"<Script language='JavaScript' defer>
                    alert('" + message + "');history.go(" + ID + ");</Script>";
            page.ClientScript.RegisterStartupScript(this.GetType(), "提醒", js);
        }
        public void Alert(System.Web.UI.Page page, string message)
        {
            message = this.Sqlstring(message);
            string js = @"<Script language='JavaScript' defer>
                    alert('" + message + "');</Script>";
            page.ClientScript.RegisterStartupScript(this.GetType(), "提醒", js);
        }

        /// <summary>
        /// 弹出窗口,转向Url造订的页面
        /// </summary>
        /// <param name="url"></param>
        public void Location(string message, string url)
        {
            message = this.Sqlstring(message);
            string js = @"<Script language='JavaScript' defer>
                   alert('" + message + "'); window.location.replace('{0}');</Script>";
            js = string.Format(js, url);
            HttpContext.Current.Response.Write(js);
        }

        public void Location(System.Web.UI.Page page, string message, string url)
        {
            message = this.Sqlstring(message);
            string js = @"<Script language='JavaScript' defer>
                   alert('" + message + "'); window.location.replace('{0}');</Script>";
            js = string.Format(js, url);
            page.ClientScript.RegisterStartupScript(this.GetType(), "提醒", js);
        }

        /// <summary>
        /// 输出自界说剧本信息
        /// </summary>
        /// <param name="page">当前页面指针,通常为this</param>
        /// <param name="script">输出剧本</param>
        public void ResponseScript(System.Web.UI.Page page, string script)
        {
            page.ClientScript.RegisterStartupScript(this.GetType(), "message", "<script language='javascript' defer>" + script + "</script>");
        }
        #endregion

		#region 按字节截取字符串省略
		/// <summary>
		/// 获取字符串长度,中文为两个字符
		/// </summary>
		/// <param name="str">测试的字符串</param>
		/// <returns></returns>
		public int GetStrLen(string str)
		{
			String pattern = @"[^\x00-\xff]";
			string s=Regex.Replace(str,pattern,"aa");
			return s.Length;
		}

		/// <summary>
		/// 代替html代码为控件中可见字符
		/// </summary>
		/// <param name="str"></param>
		/// <returns></returns>
		public string DecBrSql(string str)
		{
			if(str!=null && str!="")
			{
				str = str.Replace("&nbsp;"," ");
				str = str.Replace("<br>"," ");
			}
			return str;
		}

		#region 凭据指定字符串长度获取字符串
		/// <summary>
		/// 凭据指定字符串长度获取字符串
		/// </summary>
		/// <param name="s">要截取的字符串</param>
		/// <param name="len">字符串长度</param>
		/// <returns></returns>
		public string GetStrLen(string s,int len)
		{
			string ss=DecBrSql(s);
			int l=GetStrLen(ss);
			int i=l/2;
			int m=l%2;
			if(i>len || (i==len && m>0))
			{
				return ss.Substring(0,len)+"..";
			}
			else
			{
				return ss;
			}
		}
		#endregion
		#endregion

		#region 留言分页
		public string GenPagerbook(int PagerType,int CurrentPage,int TotalPages,int GroupSize,string OtherParam,string leftname,string rightname)
		{
			if(OtherParam.Length>0 && OtherParam.Substring(0,1)!="&")OtherParam = "&"+OtherParam;

			StringBuilder sb = new StringBuilder();
			int GroupStart;
			int PageEnd;
			switch(PagerType)
			{
				default:
					//style:上一页 ...2,3,4,5,6,7...下一页
					if(CurrentPage>1)
					{
						sb.Append("<a href=\"?page="+Convert.ToString(CurrentPage-1)+OtherParam+"\" class=hei>"+leftname+"</a>&nbsp;");
					}
					else
					{
						sb.Append("<a href=\"javascript:void(0);\"  class=hei>"+leftname+"</a>&nbsp;");
					}


					//天生主体部门
					if(CurrentPage % GroupSize == 0)
					{
						GroupStart = (CurrentPage/GroupSize)-1;
					}
					else
					{
						GroupStart = (int)(CurrentPage/GroupSize);
					}
					if(GroupStart<0)GroupStart = 0;
					PageEnd = (GroupStart+1)*GroupSize;
					if(PageEnd>TotalPages)PageEnd = TotalPages;

					///前一组
					if(GroupStart>0) sb.Append(" <a href=\"?page="+Convert.ToString((GroupStart-1)*GroupSize+1)+OtherParam+"\" class=hei>...</a> ");
					for(int i=GroupStart*GroupSize+1;i<=PageEnd;i++)
					{
						if(i!=CurrentPage)
						{
							sb.Append(" <a href=\"?page="+i.ToString()+OtherParam+"\" class=hei>"+i.ToString()+"</a> ");
						}
						else
						{
							sb.Append(" <span class=hei>"+i.ToString()+"</span> ");
						}
					}
					///后一组
					if(TotalPages>PageEnd) sb.Append(" <a href=\"?page="+Convert.ToString(PageEnd+1)+OtherParam+"\" class=hei>...</a> ");

					//天生[>]
					if(CurrentPage<TotalPages)
					{
						sb.Append("&nbsp;<a href=\"?page="+Convert.ToString(CurrentPage+1)+OtherParam+"\" class=hei>"+rightname+"</a>");
					}
					else
					{
						sb.Append("&nbsp;<a href=\"javascript:void(0);\" class=hei>"+rightname+"</a>");
					}
					break;

				case 1:
					//style:上一页 下一页
					
					if(CurrentPage>1)
					{
						sb.Append("<a href=\"?page="+Convert.ToString(CurrentPage-1)+OtherParam+"\" class=hei>"+leftname+"</a>&nbsp;");
					}

					//天生[>]
					if(CurrentPage<TotalPages)
					{
						sb.Append("&nbsp;<a href=\"?page="+Convert.ToString(CurrentPage+1)+OtherParam+"\" class=hei>"+rightname+"</a>");
					}
					break;
			}
			return sb.ToString();
		}

		#endregion

		#region 分页
		public string GenPagerpro(int PagerType,int CurrentPage,int TotalPages,int GroupSize,string OtherParam,string leftname,string rightname,int input,string url,int classid)
		{
            //if(OtherParam.Length>0 && OtherParam.Substring(0,1)!="&")OtherParam = "&"+OtherParam;

			StringBuilder sb = new StringBuilder();
			int GroupStart;
			int PageEnd;
			switch(PagerType)
			{
				default:

                    //显示页数
                    sb.Append("Page " + CurrentPage + " of " + TotalPages + "&nbsp; &nbsp; &nbsp;");

                    sb.Append("<a href=\"" + url + "-" + classid + "-1" + OtherParam + "\" class=page>" + "<<" + "</a>&nbsp;&nbsp;");
                    
                    //style:上一页 ...2,3,4,5,6,7...下一页
					if(CurrentPage>1)
					{
                        sb.Append("<a href=\"" + url + "-" + classid + "-" + Convert.ToString(CurrentPage - 1) + OtherParam + "\" class=page>" + leftname + "</a>&nbsp;");
					}
					else
					{
						sb.Append("<a href=\"javascript:void(0);\"  class=page>"+leftname+"</a>&nbsp;");
					}


					//天生主体部门
					if(CurrentPage % GroupSize == 0)
					{
						GroupStart = (CurrentPage/GroupSize)-1;
					}
					else
					{
						GroupStart = (int)(CurrentPage/GroupSize);
					}
					if(GroupStart<0)GroupStart = 0;
					PageEnd = (GroupStart+1)*GroupSize;
					if(PageEnd>TotalPages)PageEnd = TotalPages;

					///前一组
                    if (GroupStart > 0) sb.Append(" <a href=\"" + url + "-" + classid + "-" + Convert.ToString((GroupStart - 1) * GroupSize + 1) + OtherParam + "\" class=page>...</a> ");
					for(int i=GroupStart*GroupSize+1;i<=PageEnd;i++)
					{
						if(i!=CurrentPage)
						{
                            sb.Append(" <a href=\"" + url + "-" + classid + "-" + i.ToString() + OtherParam + "\"  class=page>" + i.ToString() + "</a> ");
						}
						else
						{
                            sb.Append(" <span  class=page >" + i.ToString() + "</span> ");
						}
					}
					///后一组
                    if (TotalPages > PageEnd) sb.Append(" <a href=\"" + url + "-" + classid + "-" + Convert.ToString(PageEnd + 1) + OtherParam + "\"  class=page>...</a> ");
					//显示全数
					//sb.Append("&nbsp;|&nbsp;&nbsp;<a href='?"+quanbuurl+"' class=hei>显示全数</a> ");

					//天生[>]
					if(CurrentPage<TotalPages)
					{
                        sb.Append("&nbsp;<a href=\"" + url + "-" + classid + "-" + Convert.ToString(CurrentPage + 1) + OtherParam + "\" class=page>" + rightname + "</a> ");
					}
					else
					{
                        sb.Append("&nbsp;<a href=\"javascript:void(0);\" class=page>" + rightname + "</a> ");
					}

                    sb.Append("&nbsp;<a href=\"" + url + "-" + classid + "-" + TotalPages + OtherParam + "\" class=page>" + ">>" + "</a>&nbsp;");

					if (input==1)
					{
                        sb.Append("&nbsp; &nbsp; &nbsp;<input name='textfield2' type='text' class='bot' size='1' style='HEIGHT:18px;width:25px' id='page'>&nbsp;<input type='button' value='Go' class='bot' name='B1' onclick='return checkinfopage(\"" + url + "\"," + classid + ")' style='HEIGHT:21px'>&nbsp;&nbsp;");
					}
					break;
			}
			return sb.ToString();
		}

        public string GenPagerpro(int PagerType, int CurrentPage, int TotalPages, int GroupSize, string OtherParam, string leftname, string rightname, int input, string url, string url1)
        {
            if (OtherParam.Length > 0 && OtherParam.Substring(0, 1) != "&") OtherParam = "&" + OtherParam;

            StringBuilder sb = new StringBuilder();
            int GroupStart;
            int PageEnd;
            switch (PagerType)
            {
                default:
                    //style:上一页 ...2,3,4,5,6,7...下一页
                    if (CurrentPage > 1)
                    {
                        sb.Append("<td><a href=\"?page=" + Convert.ToString(CurrentPage - 1) + OtherParam + "\" class=pre>" + leftname + "</a></td>");
                    }
                    else
                    {
                        sb.Append("<td><a href=\"javascript:void(0);\"  class=pre>" + leftname + "</a></td>");
                    }


                    //天生主体部门
                    //if (CurrentPage % GroupSize == 0)
                    //{
                    //    GroupStart = (CurrentPage / GroupSize) - 1;
                    //}
                    //else
                    //{
                    //    GroupStart = (int)(CurrentPage / GroupSize);
                    //}
                    //if (GroupStart < 0) GroupStart = 0;
                    //PageEnd = (GroupStart + 1) * GroupSize;
                    //if (PageEnd > TotalPages) PageEnd = TotalPages;

                    /////前一组
                    //if (GroupStart > 0) sb.Append(" <a href=\"?page=" + Convert.ToString((GroupStart - 1) * GroupSize + 1) + OtherParam + "\" class=page>...</a> ");
                    //for (int i = GroupStart * GroupSize + 1; i <= PageEnd; i++)
                    //{
                    //    if (i != CurrentPage)
                    //    {
                    //        sb.Append(" <a href=\"?page=" + i.ToString() + OtherParam + "\"  class=page>" + i.ToString() + "</a> ");
                    //    }
                    //    else
                    //    {
                    //        sb.Append(" <span  class=page >" + i.ToString() + "</span> ");
                    //    }
                    //}
                    /////后一组
                    //if (TotalPages > PageEnd) sb.Append(" <a href=\"?page=" + Convert.ToString(PageEnd + 1) + OtherParam + "\"  class=page>...</a> ");
                    ////显示全数
                    ////sb.Append("&nbsp;|&nbsp;&nbsp;<a href='?"+quanbuurl+"' class=hei>显示全数</a> ");

                    //天生[>]
                    if (CurrentPage < TotalPages)
                    {
                        sb.Append("<td><a href=\"?page=" + Convert.ToString(CurrentPage + 1) + OtherParam + "\" class=next>" + rightname + "</a> </td>");
                    }
                    else
                    {
                        sb.Append("<td><a href=\"javascript:void(0);\" class=next>" + rightname + "</a> </td>");
                    }

                    //显示页数
                    //sb.Append("&nbsp; 共" + TotalPages + "页&nbsp; ");

                    //if (input == 1)
                    //{
                    //    sb.Append(" <input name='textfield2' type='text' class='bot' size='1' style='HEIGHT:20px;width:25px;' id='page' runat='server'>页&nbsp;<input type='button' value='转到' class='bot' name='B1' onclick='return checkinfopage1(\"" + url + "\",\"" + url1 + "\")' style='HEIGHT:22px'>&nbsp;&nbsp;");
                    //}
                    break;
            }
            return sb.ToString();
        }
        #endregion

		#region 得到分类名称
		public string Gettname(int ID)
		{
			DBCommon dbc = new DBCommon();
			string tname="";
			OleDbDataReader dr = dbc.GetDataReaderBySql("Select classname From class Where classId="+ID);
			if(dr.Read())
			{
				tname=dr["classname"].ToString();
			}
			dr.Close();
			return tname;
		}
		#endregion


        #region 得到分类 大类的 名称
        public string Gettnamebigname(int ID)
        {
            DBCommon dbc = new DBCommon();
            string tname = "";
            OleDbDataReader dr = dbc.GetDataReaderBySql("Select title From ClassChannel Where ChannelId=" + ID);
            if (dr.Read())
            {
                tname = dr["title"].ToString();
            }
            dr.Close();
            return tname;
        }
        #endregion

		#region 得到父ID
		public int Gettid(int ID)
		{
			DBCommon dbc = new DBCommon();
			int tid=0;
			OleDbDataReader dr = dbc.GetDataReaderBySql("Select tid From class Where classId="+ID);
			if(dr.Read())
			{
				tid=Int32.Parse(dr["tid"].ToString());
			}
			else
			{
				tid=0;
			}
			dr.Close();
			return tid;
		}
		#endregion

        #region 得到CID
        public int Getcid(int ID)
        {
            DBCommon dbc = new DBCommon();
            int cid = 0;
            OleDbDataReader dr = dbc.GetDataReaderBySql("Select cid From class Where classId=" + ID);
            if (dr.Read())
            {
                cid = Int32.Parse(dr["cid"].ToString());
            }
            else
            {
                cid = 0;
            }
            dr.Close();
            return cid;
        }
        #endregion

        #region 得到子ID
        public string Getzid(int ID)
        {
            DBCommon dbc = new DBCommon();
            string classtree = "";
            DataTable DT = dbc.GetDataTableBySql("select classname,classid from class where tid=" + ID + " order by ordernum desc");
            for (int i = 0; i < DT.Rows.Count; i++)
            {
                if (classtree == "")
                {
                    classtree += DT.Rows[i]["classid"].ToString();
                }
                else
                {
                    classtree += "," + DT.Rows[i]["classid"].ToString();
                }
            }
            DT.Clear();
            return classtree;
        }

        #region 得到子ID
        public string Getzid(int YX_ID,int type)
        {
            DBCommon dbc = new DBCommon();
            string strid = "";
            int child = 0;

            OleDbDataReader dr = dbc.GetDataReaderBySql("select classid from Class where classid=" + YX_ID);
            if (dr.Read())
            {
                child = Convert.ToInt32(dr["classid"]);
            }
            dr.Close();
            if (child != 0)
            {
                OleDbDataReader dr1 = dbc.GetDataReaderBySql("select classid from Class where tid=" + YX_ID);
                while (dr1.Read())
                {

                    strid += dr1["classid"].ToString() + "," + Getzid(Convert.ToInt32(dr1["classid"].ToString())) + ",";
                }
                if (strid != "")
                {

                    strid = strid.Replace(",,", ",");
                    ///去点最后的,
                    int wz = strid.Length - 1;
                    strid = strid.Substring(0, wz);
                }
                dr1.Close();
            }
            else
            {
                strid = YX_ID.ToString();
            }
            return strid;
        }
        #endregion
        #endregion

		#region 取品牌导航
		public string Getppname(int ppid,string url)
		{
			DBCommon dbc = new DBCommon();
			string ppname="<a href='"+url+"'><u>所有品牌</u></a>";
			if (ppid>0)
			{
				OleDbDataReader dr = dbc.GetDataReaderBySql("Select cid,classname,tid From class Where classID="+ppid);
				if(dr.Read())
				{
					if (Convert.ToInt32(dr["cid"].ToString())==0)
					{
						ppname+="><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())>0)
					{
						ppname+="><a href='"+url+"&ppid="+Convert.ToInt32(dr["tid"].ToString())+"'><u>"+this.Gettname(Convert.ToInt32(dr["tid"].ToString()))+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
				}
				dr.Close();
			}
			return ppname;
		}
		#endregion

		#region 取分类导航
		public string Getclassname(int classid,string url)
		{
			DBCommon dbc = new DBCommon();
			string classname="<a href='"+url+"'><u>所有类别</u></a>";
			if (classid>0)
			{
				OleDbDataReader dr = dbc.GetDataReaderBySql("Select cid,classname,tid From class Where classID="+classid);
				if(dr.Read())
				{
					int tid=Convert.ToInt32(dr["tid"].ToString());
					if (Convert.ToInt32(dr["cid"].ToString())==0)
					{
						classname+="><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==1)
					{
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==2)
					{
						int ttid=this.Gettid(tid);
						classname+="><a href='"+url+"&classid="+ttid+"'><u>"+this.Gettname(ttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==3)
					{
						int ttid=this.Gettid(tid);
						int tttid=this.Gettid(ttid);
						classname+="><a href='"+url+"&classid="+tttid+"'><u>"+this.Gettname(tttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+ttid+"'><u>"+this.Gettname(ttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==4)
					{
						int ttid=this.Gettid(tid);
						int tttid=this.Gettid(ttid);
						int ttttid=this.Gettid(tttid);
						classname+="><a href='"+url+"&classid="+ttttid+"'><u>"+this.Gettname(ttttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tttid+"'><u>"+this.Gettname(tttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+ttid+"'><u>"+this.Gettname(ttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
				}
				dr.Close();
			}
			return classname;
		}


		public string Getclassname(int classid,string url,int id,string ass)
		{
			DBCommon dbc = new DBCommon();
			string classname="<a href='"+url+"'><u>商品选购中心</u></a>";
			if (classid>0)
			{
				OleDbDataReader dr = dbc.GetDataReaderBySql("Select cid,classname,tid From class Where classID="+classid);
				if(dr.Read())
				{
					int tid=Convert.ToInt32(dr["tid"].ToString());
					if (Convert.ToInt32(dr["cid"].ToString())==0)
					{
						classname+="><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==1)
					{
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==2)
					{
						int ttid=this.Gettid(tid);
						classname+="><a href='"+url+"&classid="+ttid+"'><u>"+this.Gettname(ttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==3)
					{
						int ttid=this.Gettid(tid);
						int tttid=this.Gettid(ttid);
						classname+="><a href='"+url+"&classid="+tttid+"'><u>"+this.Gettname(tttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+ttid+"'><u>"+this.Gettname(ttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==4)
					{
						int ttid=this.Gettid(tid);
						int tttid=this.Gettid(ttid);
						int ttttid=this.Gettid(tttid);
						classname+="><a href='"+url+"&classid="+ttttid+"'><u>"+this.Gettname(ttttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tttid+"'><u>"+this.Gettname(tttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+ttid+"'><u>"+this.Gettname(ttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
				}
				dr.Close();
			}
			return classname;
		}

		public string Getclassname(int classid,string url,int id)
		{
			DBCommon dbc = new DBCommon();
			string classname="";
			if (classid>0)
			{
				OleDbDataReader dr = dbc.GetDataReaderBySql("Select cid,classname,tid From class Where classID="+classid);
				if(dr.Read())
				{
					int tid=Convert.ToInt32(dr["tid"].ToString());
					if (Convert.ToInt32(dr["cid"].ToString())==0)
					{
						classname+="><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==1)
					{
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==2)
					{
						int ttid=this.Gettid(tid);
						classname+="><a href='"+url+"&classid="+ttid+"'><u>"+this.Gettname(ttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==3)
					{
						int ttid=this.Gettid(tid);
						int tttid=this.Gettid(ttid);
						classname+="><a href='"+url+"&classid="+tttid+"'><u>"+this.Gettname(tttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+ttid+"'><u>"+this.Gettname(ttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==4)
					{
						int ttid=this.Gettid(tid);
						int tttid=this.Gettid(ttid);
						int ttttid=this.Gettid(tttid);
						classname+="><a href='"+url+"&classid="+ttttid+"'><u>"+this.Gettname(ttttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tttid+"'><u>"+this.Gettname(tttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+ttid+"'><u>"+this.Gettname(ttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
				}
				dr.Close();
			}
			return classname;
		}


		public string Getclassname(int classid,string url,string classtree)
		{
			DBCommon dbc = new DBCommon();
			string classname="";
			if (classid>0)
			{
				OleDbDataReader dr = dbc.GetDataReaderBySql("Select cid,classname,tid From class Where classID="+classid);
				if(dr.Read())
				{
					int tid=Convert.ToInt32(dr["tid"].ToString());
					if (Convert.ToInt32(dr["cid"].ToString())==0)
					{
						classname+="<u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==1)
					{
						classname+="<a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==2)
					{
						int ttid=this.Gettid(tid);
						classname+="<a href='"+url+"&classid="+ttid+"'><u>"+this.Gettname(ttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==3)
					{
						int ttid=this.Gettid(tid);
						int tttid=this.Gettid(ttid);
						classname+="<a href='"+url+"&classid="+tttid+"'><u>"+this.Gettname(tttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+ttid+"'><u>"+this.Gettname(ttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==4)
					{
						int ttid=this.Gettid(tid);
						int tttid=this.Gettid(ttid);
						int ttttid=this.Gettid(tttid);
						classname+="<a href='"+url+"&classid="+ttttid+"'><u>"+this.Gettname(ttttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tttid+"'><u>"+this.Gettname(tttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+ttid+"'><u>"+this.Gettname(ttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
				}
				dr.Close();
			}
			return classname;
		}


		public string Getclassname(int classid,string url,string classurl,string classtree)
		{
			DBCommon dbc = new DBCommon();
			string classname="<a href='"+url+"'><u>"+classtree+"</u></a>";
			if (classid>0)
			{
				OleDbDataReader dr = dbc.GetDataReaderBySql("Select cid,classname,tid From class Where classID="+classid);
				if(dr.Read())
				{
					int tid=Convert.ToInt32(dr["tid"].ToString());
					if (Convert.ToInt32(dr["cid"].ToString())==0)
					{
						classname+="><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==1)
					{
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==2)
					{
						int ttid=this.Gettid(tid);
						classname+="><a href='"+url+"&classid="+ttid+"'><u>"+this.Gettname(ttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==3)
					{
						int ttid=this.Gettid(tid);
						int tttid=this.Gettid(ttid);
						classname+="><a href='"+url+"&classid="+tttid+"'><u>"+this.Gettname(tttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+ttid+"'><u>"+this.Gettname(ttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
					if (Convert.ToInt32(dr["cid"].ToString())==4)
					{
						int ttid=this.Gettid(tid);
						int tttid=this.Gettid(ttid);
						int ttttid=this.Gettid(tttid);
						classname+="><a href='"+url+"&classid="+ttttid+"'><u>"+this.Gettname(ttttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tttid+"'><u>"+this.Gettname(tttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+ttid+"'><u>"+this.Gettname(ttid)+"</u></a>";
						classname+="><a href='"+url+"&classid="+tid+"'><u>"+this.Gettname(tid)+"</u></a>><u>"+dr["classname"].ToString()+"</u>";
					}
				}
				dr.Close();
			}
			return classname;
		}

		#endregion

		#region 去掉最后一个逗号
		/// <summary>
		/// 去掉最后一个逗号
		/// </summary>
		/// <param name="origin"></param>
		/// <returns></returns>
		public string DelLastComma(string origin)
		{
			if(origin.IndexOf(",") == -1)
			{
				return origin;
			}
			return origin.Substring(0,origin.LastIndexOf(","));
		}
		#endregion

		#region 代替html代码为控件中可见字符
		public string DecSql(string str)
		{
			if(str!=null && str!="")
			{
				str = str.Replace("&nbsp;"," ");
				str = str.Replace("<br>","\r\n");
			}
			return str;
		}
		#endregion

		#region 获取拆分符右边的字符串
		public string RightSplit(string sourceString, char splitChar)
		{
			string result=null;
			string[] tempString = sourceString.Split(splitChar);
			if(tempString.Length >0)
			{
				result = tempString[tempString.Length-1].ToString();
			}
			return result;
		}
		#endregion

		#endregion

        #region 导航菜单
        public string Getclasstree(int classid)
        {
            string tree = "首页 &gt;&gt; ";
            if (HttpContext.Current.Request.Url.ToString().ToLower().IndexOf("/en/") > -1)
            {
                tree = "Home &gt;&gt; ";
            }
            DBCommon dbc = new DBCommon();
            DataTable dt = dbc.GetDataTableBySql("select Title from ClassChannel where ChannelId=(select top 1 ChannelId from class where classid=" + classid + ")");
            if (dt.Rows.Count > 0)
            {
                tree += dt.Rows[0]["Title"].ToString() + " &gt;&gt; ";
            }
            dt.Dispose();

            if (!this.IsBlank(HttpContext.Current.Request["keyword"]))
            {
                if (HttpContext.Current.Request.Url.ToString().ToLower().IndexOf("/en/") > -1)
                {
                    tree += "Product Search &gt;&gt; " + HttpContext.Current.Request["keyword"];
                }
                else
                {
                    tree += "产品搜索 &gt;&gt; " + HttpContext.Current.Request["keyword"];
                }
            }
            else
            {
                if (Getcid(classid) == 0) tree += Gettname(classid);
                if (Getcid(classid) == 1) tree += Gettname(Gettid(classid)) + " &gt;&gt; " + Gettname(classid);
                if (Getcid(classid) == 2) tree += Gettname(Gettid(Gettid(classid))) + " &gt;&gt; " + Gettname(Gettid(classid)) + " &gt;&gt; " + Gettname(classid);
            }
            return tree;
        }
        #endregion

        #region 得到分类第一个zid
        public int Gettopzclassid(int tclassid)
        {
            int classid = 0;
            DBCommon dbc = new DBCommon();
            OleDbDataReader dr = dbc.GetDataReaderBySql("select top 1 classid from class where tid=" + tclassid + " order by ordernum");
            if (dr.Read())
            {
                classid = Convert.ToInt32(dr["classid"]);
            }
            dr.Close();
            return classid;
        }
        #endregion

        #region 得到频路第一个classid
        public int Gettopclassid(int channelid)
        {
            int classid = 0;
            DBCommon dbc = new DBCommon();
            OleDbDataReader dr = dbc.GetDataReaderBySql("select top 1 classid from class where channelid=" + channelid+" and cid=0 order by ordernum");
            if (dr.Read())
            {
                classid = Convert.ToInt32(dr["classid"]);
            }
            dr.Close();
            return classid;
        }
        #endregion

        #region 得到频路名称
        public string Getchannelname(int channelid)
        {
            string Title = "";
            DBCommon dbc = new DBCommon();
            OleDbDataReader dr = dbc.GetDataReaderBySql("select top 1 Title from ClassChannel where channelid=" + channelid);
            if (dr.Read())
            {
                Title = dr["Title"].ToString();
            }
            dr.Close();
            return Title;
        }
        #endregion

        #region 设相信息表
        public string GetCol(int channelid)
        {
            string Col = "Info";
            if (channelid == 2000000) Col = "NEWS";
            if (channelid == 2000000 || channelid == 31) Col = "Industry";
            if (channelid == 2000000) Col = "Cased";
            return Col;
        }
        #endregion

        #region 设相信息表
        public string GetclassUrl(int channelid)
        {
            string Col = "Info";
            if (channelid == 1) Col = "aboutList";
            if (channelid == 2) Col = "InfoList";
            if (channelid == 4) Col = "Case";

            return Col;
        }
        #endregion
    

        #region 设置分类表
        public string GetClassCol(int channelid)
        {
            string Col = "class";
            return Col;
        }
        #endregion

        #region 通用取值
        public string GetValue(string biao, string lie, string where)
        {
            DBCommon dbc = new DBCommon();
            string value = "";
            DataTable dt = dbc.GetDataTableBySql("select top 1 " + lie + "  from " + biao + " where " + where);
            if (dt.Rows.Count > 0) value = dt.Rows[0][lie].ToString();
            dt.Dispose();
            return value;
        }
        #endregion

        #region 绑定控件
        public void Bind(object lstCmp, string sql)
        {
            DBCommon dbc = new DBCommon();
            DataTable DT = dbc.GetDataTableBySql(sql);
            DT.Columns.Add("ii", typeof(string));
            for (int i = 0; i < DT.Rows.Count; i++)
            {
                DT.Rows[i]["ii"] = (i + 1).ToString();
            }
            if (lstCmp.GetType().ToString() == "System.Web.UI.WebControls.DataList")
            {
                ((DataList)lstCmp).DataSource = DT.DefaultView;
                ((DataList)lstCmp).DataBind();
            }
            if (lstCmp.GetType().ToString() == "System.Web.UI.WebControls.Repeater")
            {
                ((Repeater)lstCmp).DataSource = DT.DefaultView;
                ((Repeater)lstCmp).DataBind();
            }
            if (lstCmp.GetType().ToString() == "System.Web.UI.WebControls.DataGrid")
            {
                ((DataGrid)lstCmp).DataSource = DT.DefaultView;
                ((DataGrid)lstCmp).DataBind();
            }
            DT.Dispose();
        }
        #endregion

        #region 提醒
        public string GetShowMessage(string str)
        {
            string stringStr = "您没有权限查看当前页面,请联系治理员或者沉新分配权限!";
            if (!IsBlank(str)) stringStr = str;
            string message = "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">";
            message += "<html xmlns=\"http://www.w3.org/1999/xhtml\"><head><title>您没有权限运行当前法式!</title><meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">";
            message += "<link href=\"../styles/default.css\" type=\"text/css\" rel=\"stylesheet\"></head><body><br><br><br><br><div style=\"width:100%\" align=\"center\">";
            message += "<div align=\"center\" style=\"width:660px; border:1px dotted #FF6600; background-color:#FFFCEC; margin:auto; padding:20px;\"><img src=\"/back/images/hint.gif\" border=\"0\" alt=\"提醒:\" align=\"absmiddle\" width=\"11\" height=\"13\" /> &nbsp;";
            message += stringStr + "</div></div></body></html>";
            return message;
        }


        public void LoadRegisterStartupScript(System.Web.UI.Page page, string key, string scriptstr)
        {
            string message = "法式执行中... <BR /> 当前操作可能要运行一段功夫.<BR />您可在此期间进行其它操作<BR /><BR />";

            string script = "<script> \r\n" +
                "var bar=0;\r\n success.style.display = \"block\";  \r\n" +
                "document.getElementById('Layer5').innerHTML ='" + message + "';  \r\n" +
                "count() ; \r\n" +
                "function count(){ \r\n" +
                "bar=bar+2; \r\n" +
                "if (bar<99) \r\n" +
                "{setTimeout(\"count()\",100);} \r\n" +
                "else { \r\n" +
                "	document.getElementById('success').style.display = \"none\";HideOverSels('success'); \r\n" +
                scriptstr + "} \r\n" +
                "} \r\n" +
                "</script> \r\n" +
                "<script> window.onload = function(){HideOverSels('success')};</script>\r\n";

            CallBaseRegisterStartupScript(page, key, script);

        }

        /// <summary>
        /// 注册提醒信息JS剧本
        /// </summary>
        public void RegisterAdminPageClientScriptBlock(System.Web.UI.Page page)
        {
            string script = "<div id=\"success\" style=\"position:absolute;z-index:300;height:120px;width:284px;left:50%;top:50%;margin-left:-150px;margin-top:-80px;\">\r\n" +
                "	<div id=\"Layer2\" style=\"position:absolute;z-index:300;width:270px;height:90px;background-color: #FFFFFF;border:solid #000000 1px;font-size:14px;\">\r\n" +
                "		<div id=\"Layer4\" style=\"height:26px;background:#f1f1f1;line-height:26px;padding:0px 3px 0px 3px;font-weight:bolder;\">操作提醒</div>\r\n" +
                "		<div id=\"Layer5\" style=\"height:64px;line-height:150%;padding:0px 3px 0px 3px;\" align=\"center\"><BR /><table><tr><td valign=top><img border=\"0\" src=\"../images/ajax_loading.gif\"  /></td><td valign=middle style=\"font-size: 14px;\" >在执行当前操作, 请稍等...<BR /></td></tr></table><BR /></div>\r\n" +
                "	</div>\r\n" +
                "	<div id=\"Layer3\" style=\"position:absolute;width:270px;height:90px;z-index:299;left:4px;top:5px;background-color: #E8E8E8;\"></div>\r\n" +
                "</div>\r\n" +
                "<script> \r\n" +
                "document.getElementById('success').style.display = \"none\"; \r\n" +
                "</script> \r\n" +
                "<script type=\"text/javascript\" src=\"../js/divcover.js\"></script>\r\n";

            page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Page", script);
        }

        public new void RegisterStartupScript(System.Web.UI.Page page, string key, string scriptstr)
        {
            key = key.ToLower();
            if ((key == "pagetemplate") || (key == "page"))
            {
                string script = "";

                if (key == "page")
                {
                    script = "<script> \r\n" +
                        "var bar=0;\r\n" +
                        "document.getElementById('success').style.display = \"block\";  \r\n" +
                        "document.getElementById('Layer5').innerHTML ='<BR>操作成功执行<BR>';  \r\n" +
                        "count() ; \r\n" +
                        "function count(){ \r\n" +
                        "bar=bar+4; \r\n" +
                        "if (bar<99) \r\n" +
                        "{setTimeout(\"count()\",50);} \r\n" +
                        "else { \r\n" +
                        "document.getElementById('success').style.display = \"none\";HideOverSels('success'); \r\n" +
                        scriptstr + "} \r\n" +
                        "} \r\n" +
                        "</script> \r\n" +
                        "<script> window.onload = function(){HideOverSels('success')};</script>\r\n";
                }

                if (key == "pagetemplate")
                {
                    script = "<script> \r\n" +
                        "var bar=0;\r\n success.style.display = \"block\";  \r\n" +
                        "document.getElementById('Layer5').innerHTML = '<BR>" + scriptstr + "<BR>';  \r\n" +
                        "count() ; \r\n" +
                        "function count(){ \r\n" +
                        "bar=bar+4; \r\n" +
                        "if (bar<99) \r\n" +
                        "{setTimeout(\"count()\",100);} \r\n" +
                        "else { \r\n" +
                        "document.getElementById('success').style.display = \"none\";HideOverSels('success'); \r\n" +
                        "}} \r\n" +
                        "</script> \r\n" +
                        "<script> window.onload = function(){HideOverSels('success')};</script>\r\n";
                }
                page.ClientScript.RegisterStartupScript(this.GetType(), key, script);

            }
            else
            {
                page.ClientScript.RegisterStartupScript(this.GetType(), key, scriptstr);
            }
        }


        public void CallBaseRegisterStartupScript(System.Web.UI.Page page, string key, string scriptstr)
        {
            page.ClientScript.RegisterStartupScript(this.GetType(), key, scriptstr);
        }
        #endregion

        #region 得到分类频路
        public int GetClassChannelid(int classid)
        {
            int Channelid = 0;
            DataTable DT = new DBCommon().GetDataTableBySql("Select top 1 Channelid From class Where classId=" + classid);
            if (DT.Rows.Count > 0)
            {
                Channelid = Int32.Parse(DT.Rows[0]["Channelid"].ToString());
            }
            DT.Dispose();
            return Channelid;
        }
        #endregion

        #region 参数classidsql
        public string GetClassSql(int classid)
        {
            string sql = "";
            if (classid > 0)
            {
                sql += " and (";
                if (Getzid(classid, 0).Trim() != "")
                {
                    sql += " classid in (" + Getzid(classid, 0) + ") or";
                }
                sql += " classid=" + classid + ")";
            }
            return sql;
        }
        #endregion

        #region 绑定下拉框
        public void GetDropDownList(DropDownList DropDownListid, string sql, int isva, string value)
        {
            if (DropDownListid.Items.Count < 1)
            {
                DataTable dt = new DBCommon().GetDataTableBySql(sql);
                foreach (DataRow row in dt.Rows)
                {
                    if (isva == 1)
                    {
                        DropDownListid.Items.Add(new ListItem(row[0].ToString(), row[0].ToString()));
                    }
                    else
                    {
                        DropDownListid.Items.Add(new ListItem(row[0].ToString(), row[1].ToString()));
                    }
                }
                dt.Dispose();
                if (value != null && value != "") DropDownListid.SelectedValue = value;
            }
        }

        public void GetDropDownList(DropDownList DropDownListid, string sql, int isva, string value, string defaulttxt, string defaultvalue)
        {
            if (DropDownListid.Items.Count < 1)
            {
                DataTable dt = new DBCommon().GetDataTableBySql(sql);
                DropDownListid.Items.Add(new ListItem(defaulttxt, defaultvalue));
                foreach (DataRow row in dt.Rows)
                {
                    if (isva == 1)
                    {
                        DropDownListid.Items.Add(new ListItem(row[0].ToString(), row[0].ToString()));
                    }
                    else
                    {
                        DropDownListid.Items.Add(new ListItem(row[0].ToString(), row[1].ToString()));
                    }
                }
                dt.Dispose();
                if (value != null && value != "") DropDownListid.SelectedValue = value;
            }
        }
        #endregion

        #region 查问数量
        public int GetCount(string sql)
        {
            OleDbCommand cmd = new DBCommon().GetCommandBySql(sql);
            cmd.Connection.Open();
            int result = 0;
            try
            {
                result = Int32.Parse(cmd.ExecuteScalar().ToString());
            }
            catch { }
            cmd.Connection.Close();
            cmd.Connection.Dispose();
            cmd.Dispose();
            return result;
        }
        public decimal GetCountPrice(string sql)
        {
            OleDbCommand cmd = new DBCommon().GetCommandBySql(sql);
            cmd.Connection.Open();
            decimal result = 0;
            try
            {
                result = Convert.ToDecimal(cmd.ExecuteScalar().ToString());
            }
            catch { }
            cmd.Connection.Close();
            cmd.Connection.Dispose();
            cmd.Dispose();
            return result;
        }
        #endregion

        #region 设置分类编号
        public int GetAjaxClassId(string hidClass1, string hidClass2, string hidClass3, string hidClass4, string hidClass5)
        {
            int id1, id2, id3, id4, id5;
            int classid = 0;
            try
            {
                id1 = Int32.Parse(hidClass1);
                if (id1 < 0) id1 = 0;
            }
            catch
            {
                id1 = 0;
            }
            try
            {
                id2 = Int32.Parse(hidClass2);
                if (id2 < 0) id2 = 0;
            }
            catch
            {
                id2 = 0;
            }
            try
            {
                id3 = Int32.Parse(hidClass3);
                if (id3 < 0) id3 = 0;
            }
            catch
            {
                id3 = 0;
            }
            try
            {
                id4 = Int32.Parse(hidClass4);
                if (id4 < 0) id4 = 0;
            }
            catch
            {
                id4 = 0;
            }
            try
            {
                id5 = Int32.Parse(hidClass5);
                if (id5 < 0) id5 = 0;
            }
            catch
            {
                id5 = 0;
            }

            if (id5 > 0)
            {
                classid = id5;
            }
            else
            {
                if (id4 > 0)
                {
                    classid = id4;
                }
                else
                {
                    if (id3 > 0)
                    {
                        classid = id3;
                    }
                    else
                    {
                        if (id2 > 0)
                        {
                            classid = id2;
                        }
                        else
                        {
                            if (id1 > 0)
                            {
                                classid = id1;
                            }
                        }
                    }
                }
            }
            return classid;
        }
        public int GetAjaxClassIds(HtmlInputHidden hidClass1, HtmlInputHidden hidClass2, HtmlInputHidden hidClass3, HtmlInputHidden hidClass4, HtmlInputHidden hidClass5)
        {
            int id1, id2, id3, id4, id5;
            int classid = 0;
            try
            {
                id1 = Int32.Parse(hidClass1.Value);
                if (id1 < 0) id1 = 0;
            }
            catch
            {
                id1 = 0;
            }
            try
            {
                id2 = Int32.Parse(hidClass2.Value);
                if (id2 < 0) id2 = 0;
            }
            catch
            {
                id2 = 0;
            }
            try
            {
                id3 = Int32.Parse(hidClass3.Value);
                if (id3 < 0) id3 = 0;
            }
            catch
            {
                id3 = 0;
            }
            try
            {
                id4 = Int32.Parse(hidClass4.Value);
                if (id4 < 0) id4 = 0;
            }
            catch
            {
                id4 = 0;
            }
            try
            {
                id5 = Int32.Parse(hidClass5.Value);
                if (id5 < 0) id5 = 0;
            }
            catch
            {
                id5 = 0;
            }

            if (id5 > 0)
            {
                classid = id5;
            }
            else
            {
                if (id4 > 0)
                {
                    classid = id4;
                }
                else
                {
                    if (id3 > 0)
                    {
                        classid = id3;
                    }
                    else
                    {
                        if (id2 > 0)
                        {
                            classid = id2;
                        }
                        else
                        {
                            if (id1 > 0)
                            {
                                classid = id1;
                            }
                        }
                    }
                }
            }
            return classid;
        }
        public void putAjaxClassId(HtmlInputHidden hidClass1, HtmlInputHidden hidClass2, HtmlInputHidden hidClass3, HtmlInputHidden hidClass4, HtmlInputHidden hidClass5, string value)
        {
            int classid = Int32.Parse(value);
            int ccid = Getcid(classid) + 1;
            if (ccid == 1)
            {
                hidClass1.Value = classid.ToString();
            }
            if (ccid == 2)
            {
                hidClass1.Value = Gettid(classid).ToString();
                hidClass2.Value = classid.ToString();
            }
            if (ccid == 3)
            {
                hidClass1.Value = Gettid(Gettid(classid)).ToString();
                hidClass2.Value = Gettid(classid).ToString();
                hidClass3.Value = classid.ToString();
            }
            if (ccid == 4)
            {
                hidClass1.Value = Gettid(Gettid(Gettid(classid))).ToString();
                hidClass2.Value = Gettid(Gettid(classid)).ToString();
                hidClass3.Value = Gettid(classid).ToString();
                hidClass4.Value = classid.ToString();
            }
            if (ccid == 5)
            {
                hidClass1.Value = Gettid(Gettid(Gettid(Gettid(classid)))).ToString();
                hidClass2.Value = Gettid(Gettid(Gettid(classid))).ToString();
                hidClass3.Value = Gettid(Gettid(classid)).ToString();
                hidClass4.Value = Gettid(classid).ToString();
                hidClass5.Value = classid.ToString();
            }
        }
        public void putAjaxClassId(out int class1, out int class2, out int class3, out int class4, out int class5, string value)
        {
            class1 = 0; class2 = 0; class3 = 0; class4 = 0; class5 = 0;
            int classid = Int32.Parse(value);
            int ccid = Getcid(classid) + 1;
            if (ccid == 1)
            {
                class1 = classid;
            }
            if (ccid == 2)
            {
                class1 = Gettid(classid);
                class2 = classid;
            }
            if (ccid == 3)
            {
                class1 = Gettid(Gettid(classid));
                class2 = Gettid(classid);
                class3 = classid;
            }
            if (ccid == 4)
            {
                class1 = Gettid(Gettid(Gettid(classid)));
                class2 = Gettid(Gettid(classid));
                class3 = Gettid(classid);
                class4 = classid;
            }
            if (ccid == 5)
            {
                class1 = Gettid(Gettid(Gettid(Gettid(classid))));
                class2 = Gettid(Gettid(Gettid(classid)));
                class3 = Gettid(Gettid(classid));
                class4 = Gettid(classid);
                class5 = classid;
            }
        }
        public void putAjaxPPClassId(HtmlInputHidden hidClass11, HtmlInputHidden hidClass12, string value)
        {
            int classid = Int32.Parse(value);
            int ccid = Convert.ToInt32(GetValue("ppclass", "cid", "classid=" + classid.ToString())) + 1;
            if (ccid == 1)
            {
                hidClass11.Value = classid.ToString();
            }
            if (ccid == 2)
            {
                hidClass11.Value = GetValue("ppclass", "tid", "classid=" + classid.ToString());
                hidClass12.Value = classid.ToString();
            }
        }
        #endregion

        #region 播放器
        public string Getplayer(string src, string width, int height)
        {
            string list = "";
            if (src == "") return "";
            if (this.getFileExt(src) == "rm" || this.getFileExt(src) == "rmvb" || this.getFileExt(src) == "ram")
            {
                int theight = height - 50;
                list += "<object classid=\"clsid:CFCDAA03-8BE4-11cf-B84B-0020AFBBCCFA\" name=\"player\" width=\"" + width + "\" height=\"" + theight + "\" d=\"player\"> ";
                list += "<param name=\"_ExtentX\" value=\"10001\"> ";
                list += "<param name=\"_ExtentY\" value=\"6879\"> ";
                list += "<param name=\"AUTOSTART\" value=\"-1\"> ";
                list += "<param name=\"SHUFFLE\" value=\"0\"> ";
                list += "<param name=\"PREFETCH\" value=\"0\"> ";
                list += "<param name=\"NOLABELS\" value=\"-1\"> ";
                list += "<param name=\"SRC\" value=\"" + src + "\"> ";
                list += "<param name=\"CONTROLS\" value=\"Imagewindow\"> ";
                list += "<param name=\"CONSOLE\" value=\"clip1\"> ";
                list += "<param name=\"LOOP\" value=\"true\"> ";
                list += "<param name=\"NUMLOOP\" value=\"0\"> ";
                list += "<param name=\"CENTER\" value=\"0\"> ";
                list += "<param name=\"MAINTAINASPECT\" value=\"0\"> ";
                list += "<param name=\"BACKGROUNDCOLOR\" value=\"#000000\"></object><BR>";
                list += "<object classid=\"clsid:CFCDAA03-8BE4-11cf-B84B-0020AFBBCCFA\" width=\"" + width + "\" height=\"50\" id=\"RP2\">";
                list += "<param name=\"_ExtentX\" value=\"10001\">";
                list += "<param name=\"_ExtentY\" value=\"1270\">";
                list += "<param name=\"AUTOSTART\" value=\"-1\">";
                list += "<param name=\"SHUFFLE\" value=\"0\">";
                list += "<param name=\"PREFETCH\" value=\"0\">";
                list += "<param name=\"NOLABELS\" value=\"-1\">";
                list += "<param name=\"SRC\" value=\"" + src + "\">";
                list += "<param name=\"CONTROLS\" value=\"controlpanel\">";
                list += "<param name=\"CONSOLE\" value=\"clip1\">";
                list += "<param name=\"LOOP\" value=\"true\">";
                list += "<param name=\"NUMLOOP\" value=\"0\">";
                list += "<param name=\"CENTER\" value=\"0\">";
                list += "<param name=\"MAINTAINASPECT\" value=\"0\">";
                list += "<param name=\"BACKGROUNDCOLOR\" value=\"#000000\"></object>";
            }
            else if (this.getFileExt(src) == "flv" || this.getFileExt(src) == "swf" || this.getFileExt(src) == "fla")
            {
                list += "<embed src=\"/images/flashplayer/FlvPlayer.swf?id=" + src + "\" type=\"application/x-shockwave-flash\" wmode=\"transparent\" quality=\"high\" width=\"" + width + "\" height=\"" + height + "\"></embed>";
                //list += "<embed src=\"/images/vcastr22.swf\" allowFullScreen=\"true\" FlashVars=\"vcastr_file=" + src + "\" quality=\"high\" ";
                //list += "pluginspage=\"http://www.macromedia.com/go/getflashplayer\" type=\"application/x-shockwave-flash\" width=\"" + width + "\" height=\"" + height + "\"> </embed>";
            }
            else if (this.getFileExt(src) == "wmv" || this.getFileExt(src) == "asf" || this.getFileExt(src) == "avi" || this.getFileExt(src) == "mpeg")
            {
                list += "<object id=\"mPlayer1\" style=\"FILTER: xray()\" width=" + width + " height=" + height + " classid=\"CLSID:6BF52A52-394A-11D3-B153-00C04F79FAA6\">";
                list += "<param name=\"URL\" value=\"" + src + "\">";
                list += "<param name=\"rate\" value=\"1\">";
                list += "<param name=\"balance\" value=\"0\">";
                list += "<param name=\"currentPosition\" value=\"0\">";
                list += "<param name=\"defaultFrame\" value>";
                list += "<param name=\"playCount\" value=\"100\">";
                list += "<param name=\"autoStart\" value=\"1\">";
                list += "<param name=\"currentMarker\" value=\"0\">";
                list += "<param name=\"invokeURLs\" value=\"1\">";
                list += "<param name=\"baseURL\" value>";
                list += "<param name=\"volume\" value=\"100\">";
                list += "<param name=\"mute\" value=\"0\">";
                list += "<param name=\"uiMode\" value=\"full\">";
                list += "<param name=\"stretchToFit\" value=\"0\">";
                list += "<param name=\"windowlessVideo\" value=\"0\">";
                list += "<param name=\"enabled\" value=\"1\">";
                list += "<param name=\"enableContextMenu\" value=\"1\">";
                list += "<param name=\"fullScreen\" value=\"0\">";
                list += "<param name=\"SAMIStyle\" value>";
                list += "<param name=\"SAMILang\" value>";
                list += "<param name=\"SAMIFilename\" value>";
                list += "<param name=\"captioningID\" value>";
                list += "<param name=\"enableErrorDialogs\" value=\"0\"></object>";
            }
            else
            {
                list += "<embed src=\"" + src + "\" quality=\"high\" pluginspage=\"http://www.adobe.com/support/documentation/zh-CN/flashplayer/help/settings_manager04a.html\" type=\"application/x-shockwave-flash\" width=\"" + width + "\" height=\"" + height + "\" id=\"cfplay\"></embed>";
            }
            return list;
        }
        #endregion

        #region flash推荐
        public string GetFlashTxt(int classid, int width, int height, int txtHeight, string txtBgColor)
        {
            string str = "";
            DataTable DT = new DBCommon().GetDataTableBySql("select top 5 infoid,title,url,pic from info where classid=" + classid + " and Inspect=true and pic<>'' order by ordernum desc,addtime desc");
            string pics = "";
            string links = "";
            string texts = "";
            for (int i = 0; i < DT.Rows.Count; i++)
            {
                if ((i + 1) < DT.Rows.Count)
                {
                    pics += DT.Rows[i]["pic"].ToString() + "\"+\"|\"+\"";
                    links += DT.Rows[i]["url"].ToString() + "\"+\"|\"+\"";
                    texts += new PublicFunction().SubStringByByte(DT.Rows[i]["title"].ToString(), 36) + "\"+\"|\"+\"";
                }
                else
                {
                    pics += DT.Rows[i]["pic"].ToString().Replace("../", "/");
                    links += DT.Rows[i]["url"].ToString();
                    texts += new PublicFunction().SubStringByByte(DT.Rows[i]["title"].ToString(), 36);

                }
            }
            str = new PublicFunction().GetNewsFocusPhoto(pics, links, texts, width, height, txtHeight, txtBgColor);
            DT.Dispose();
            return str;
        }

        /// <summary></summary>
        /// <param name="classid">分类</param>
        /// <param name="count">图片数量</param>
        /// <param name="width">宽</param>
        /// <param name="height">高</param>
        /// <param name="roundCorner">图片的圆角 10</param>
        /// <param name="titleBgColor">标题布景的色彩</param>
        /// <param name="titleTextColor">标题文字的色彩</param>
        /// <param name="isShowTitle">是否显示标题</param>
        /// <param name="transform">图片放缩模式 “alpha”: 通明度淡入淡出;“blur”: 吞吐淡入淡出;“left”: 左方图片滚动;“right”: 右方图片滚动;“top”: 上方图片滚动;“bottom”: 下方图片滚动;“breathe”: 有一点点地放缩的淡入淡出;“breatheBlur”: 有一点点地放缩的吞吐淡入淡出</param>
        /// <returns>了局字串</returns>
        public string GetFlashTxt(int channelid, int classid, int count, int width, int height, int roundCorner, string titleBgColor, string titleTextColor, bool isShowTitle, string transform, bool isborder)
        {
            string str = "";
            string itemstr = "";
            string sql = "";
            if (channelid > 0) sql += " and channelid=" + channelid;
            if (classid > 0) sql += " and classid=" + classid;
            DataTable DT = new DBCommon().GetDataTableBySql("select top " + count + " infoid,title,url,pic from info where Inspect=true " + sql + " and pic<>'' order by ordernum desc,addtime desc");
            itemstr += "<data>\n";
            itemstr += "<channel>\n";
            for (int i = 0; i < DT.Rows.Count; i++)
            {
                itemstr += "<item>\n";
                itemstr += "<link>" + DT.Rows[i]["url"].ToString() + "</link>\n";
                itemstr += "<image>" + DT.Rows[i]["pic"].ToString() + "</image>\n";
                itemstr += "<title>" + DT.Rows[i]["title"].ToString() + "</title>\n";
                itemstr += "</item>\n";
            }
            itemstr += "</channel>\n";
            itemstr += "<config>\n";
            itemstr += "  <roundCorner>" + roundCorner + "</roundCorner>\n";
            itemstr += "  <titleBgColor>" + titleBgColor + "</titleBgColor>\n";
            itemstr += "  <titleTextColor>" + titleTextColor + "</titleTextColor>\n";
            itemstr += "  <isShowTitle>" + isShowTitle.ToString().ToLower() + "</isShowTitle>\n";
            itemstr += "  <transform>" + transform + "</transform>\n";
            itemstr += "  <titleFont>宋体</titleFont>\n";
            itemstr += "  <windowOpen>_blank</windowOpen>\n";
            itemstr += "</config>\n";
            itemstr += "</data>\n";
            if (isborder) str = "<div style=\"border:1px solid #666;width:" + width + "px\">\n";
            str += "<object type=\"application/x-shockwave-flash\" data=\"/images/flashplayer/bcastr4.swf?xml=\n";
            str += itemstr;
            str += " \" width=\"" + width + "\" height=\"" + height + "\" id=\"vcastr3\">\n";
            str += "<param name=\"movie\" value=\"/images/flashplayer/bcastr4.swf?xml=\n";
            str += itemstr + "\"/>";
            str += "</object>\n";
            if (isborder) str += "</div>";
            DT.Dispose();
            return str;
        }
        #endregion
    }
}


#line default
#line hidden