config.cs

电力监控系统 实时告警处理程序

		}


		
		//**********************************>> 事务处理篇 <<**********************************//

		/// <summary>
		/// 开始事务
		/// </summary>
		public void TranBegin()
		{
			Open();
			tran=cn.BeginTransaction();
		}
		/// <summary>
		/// 结束事务
		/// </summary>
		public void TranEnd()
		{
			tran.Commit(); // 结束事务
			if (cn!=null)
			{
				cn.Dispose(); // 关闭数据库
				cn.Close(); // 关系数据库
			}
			if (ds!=null)
			{
				ds.Clear();
			}
		}

		public SqlDataReader TranGetDataReader(string str_Sql)
		{
			Open();
			SqlCommand cmd=new SqlCommand(str_Sql,cn);
			SqlDataReader dr=cmd.ExecuteReader();
			return dr;
		}

		public DataSet TranGetDs(string str_Sql) 
		{
			Open();
			SqlDataAdapter Ada = new SqlDataAdapter(str_Sql,cn);
			Ada.SelectCommand.Transaction=tran;
			DataSet ds = new DataSet();
			Ada.Fill(ds);
			//cn.Close();
			return ds;
		}

		public DataTable TranGetTable(string str_Sql)
		{
			return TranGetDs(str_Sql).Tables[0];
		}


		/// <summary>
		/// 获得表记录数
		/// </summary>
		/// <param name="table_name">表名或者表名+条件,GetRsCount("t_user where id="+Request["id"])</param>
		/// <returns></returns>
		public int TranGetRsCount(string table_name)
		{
			string strSql;
			int intCount;
			strSql="select count(*) from "+table_name;
			SqlCommand cmd=new SqlCommand(strSql,cn);
			cmd.Transaction=tran;
			intCount=(int)cmd.ExecuteScalar();
			return intCount;
		}

		/// <summary>
		/// 获得单个int类型字段总和
		/// </summary>
		/// <param name="field">字段</param>
		/// <param name="table_name">表名或者表名+条件,GetFiledSum("id","t_user where id="+Request["id"])</param>
		/// <returns></returns>
		public string TranGetFiledSum(string field,string table_name)
		{
			string SumValue;
			SqlCommand cmd=new SqlCommand("select sum("+field+") as s from "+table_name,cn);
			cmd.Transaction=tran;
			SumValue=cmd.ExecuteScalar().ToString();
			return SumValue;
		}

		/// <summary>
		/// 获得单个字段值
		/// </summary>
		/// <param name="str_Sql">Sql语句</param>
		/// <returns></returns>
		public string TranGetFiledValue(string str_Sql)
		{
			string str;
			SqlCommand cmd=new SqlCommand(str_Sql,cn);
			cmd.Transaction=tran;
			str=cmd.ExecuteScalar().ToString();
			return str;
		}

		/// <summary>
		/// 执行Sql语句
		/// </summary>
		/// <param name="str_Sql">Sql语句</param>
		public void TranRunSql(string str_Sql)
		{
			SqlCommand cmd = new SqlCommand(str_Sql,cn);
			cmd.Transaction=tran;
			cmd.ExecuteNonQuery();
		}

		/// <summary>
		/// 通过SqlCommandBuilder对象增加数据库记录
		/// </summary>
		/// <param name="sql">Select-SQL语句</param>
		public void TranBuilder(string str_Sql)
		{
			ada=new SqlDataAdapter(str_Sql,cn);
			ada.SelectCommand.Transaction=tran;
			SqlCommandBuilder myCommandBuilder=new SqlCommandBuilder(ada);
			ds=new DataSet();
			ada.Fill(ds);
			dr=ds.Tables[0].NewRow();
		}
		/// <summary>
		/// 关闭SqlCommandBuilder对象
		/// </summary>
		public void TranBuilderClose()
		{
			ds.Tables[0].Rows.Add(dr);
			ada.Update(ds);	 //　更新数据库					
		}
		/// <summary>
		/// 通过SqlCommandBuilder对象修改数据库记录
		/// </summary>
		/// <param name="sql">Select-SQL语句</param>
		public void TranBuilderEdit(string str_Sql)
		{
			ada=new SqlDataAdapter(str_Sql,cn);
			ada.SelectCommand.Transaction=tran;
			SqlCommandBuilder myCommandBuilder=new SqlCommandBuilder(ada);
			ds=new DataSet();
			ada.Fill(ds);
			dr=ds.Tables[0].Rows[0];
		}
		/// <summary>
		/// 关闭SqlCommandBuilder对象
		/// </summary>
		public void TranBuilderEditClose()
		{
			ada.Update(ds);	 //　更新数据库					
		}
		/// <summary>
		/// 事务回滚
		/// </summary>
		public void TranRollback()
		{
			tran.Rollback(); // 数据库回滚
			cn.Dispose(); // 关闭数据库
			cn.Close(); // 关系数据库
		}


		//**********************************>> 控件操作篇 <<**********************************//


        
		//**********************************>> 其他篇 <<**********************************//

		/// <summary>
		/// 获得某个字符串在另个字符串最后一次出现时后面所有字符
		/// </summary>
		/// <param name="strOriginal">要处理字符</param>
		/// <param name="strSymbol">符号</param>
		/// <returns>返回值</returns>
		public string GetLastStr(string strOriginal,string strSymbol)
		{
			int strPlace=strOriginal.LastIndexOf(strSymbol)+strSymbol.Length;
			strOriginal=strOriginal.Substring(strPlace);
			return strOriginal;
		}
		/// <summary>
		/// 获得某个字符串在另个字符串第一次出现时前面所有字符
		/// </summary>
		/// <param name="strOriginal">要处理字符</param>
		/// <param name="strSymbol">符号</param>
		/// <returns>返回值</returns>
		public string GetFirstStr(string strOriginal,string strSymbol)
		{
			int strPlace=strOriginal.IndexOf(strSymbol);
			if (strPlace!=-1)
				strOriginal=strOriginal.Substring(0,strPlace);
			return strOriginal;
		}

		/// <summary>
		/// 截取字符串
		/// </summary>
		/// <param name="Str">要处理字符串</param>
		/// <param name="StrLen">截取长度</param>
		/// <returns></returns>
		public string CutStr(string Str, int StrLen) 
		{ 
			if (Str != null && Convert.IsDBNull(StrLen) == false)
			{ 
				int t = 0; 
				for (int i = 0; i <= StrLen; i++)
				{ 
					if (t >= StrLen)
					{ 
						Str = Str.Substring(0,i) + "…"; 
						break; 
					}
					else
					{ 
						if (i >= Str.Length)
						{ 
							Str = Str.Substring(0,i); 
							break; 
						} 
					} 
					int c = Math.Abs((int)Str[i]); 
					if (c > 255)
					{ 
						t += 2; 
					}
					else
					{ 
						t++; 
					} 
				} 
			}
			else
			{ 
				Str = null; 
			} 
			return Str; 
		}
		/// <summary>
		/// 获得14位时间字符+。。。位的时间随机数
		/// </summary>
		/// <returns></returns>
		public string GetId()
		{
			return GetDateRandom(6);
		}
		public string GetDateRandom(int int_Count)
		{
			string strData=DateTime.Now.ToString("yyyyMMddhhmmss");
			strData=strData.Replace(":","");
			strData=strData.Replace("-","");
			strData=strData.Replace(" ","");
			strData=strData+GetRandom(int_Count);
			return strData;
		}
		public string GetRandom(int int_Count)
		{
			string str_RV="1";
			for (int i=0;i<int_Count-2;i++)
			{
				str_RV=str_RV+"0";
			}
			Random r=new Random();
			str_RV=r.Next(int.Parse(str_RV)).ToString();
			int int_Count1=int_Count-str_RV.Length;
			if (int_Count1>0)
			{
				for (int i=0;i<int_Count1;i++)
				{
					str_RV=str_RV+"0";
				}
			}
			return str_RV;
		}
		public string GetHtmlFormat(string strContent)
		{
			string val=strContent;
			if(val==null)
			{
				val="";
			}
			//val=val.Replace("\r","<br>");
			val=val.Replace("\n","<br>");
			val=val.Replace(" ","&nbsp;");
			return val;
		}

		/// <summary>
		/// 获得某个字符串在另个字符串第一次出现时前面所有字符
		/// </summary>
		/// <param name="strOriginal">要处理字符</param>
		/// <param name="strSymbol">符号</param>
		/// <returns>返回值</returns>
		public string GetSecondStr(string strOriginal,string strSymbol)
		{
			string[] arr=strOriginal.Split('_');
			
			strOriginal=arr[1];
			return strOriginal;
		}

		public int GetStrAppearTime(string strOriginal,string strSymbol)
		{
			return strOriginal.Length-strOriginal.Replace(strSymbol,"").Length;
		}
	

		//**********************************>> 本系统函数操作篇 <<**********************************//

		/// <summary>
		/// 获得手机适配表
		/// </summary>
		/// <param name="page"></param>
		/// <returns></returns>
		public string GetRingTypeId(Page page)
		{
			string val="";
			// ＝＝＝获得手机型号＝＝＝
			string HandSetModel=HttpContext.Current.Request.ServerVariables["HTTP_USER_AGENT"].Substring(0,HttpContext.Current.Request.ServerVariables["HTTP_USER_AGENT"].IndexOf("/"));
			if (GetRsCount("HandSetFit where UPPER(Match)='"+HandSetModel+"'")==0)
			{
				// ＝＝＝如果该手机没有做过适配，自动插入适配表中，铃声默认为4.mid,墙纸高度宽度设置为0
				int int_MaxId=GetMaxId("Id","HandSetFit");
				RunSql("insert into HandSetFit(Match,WallPaperHeight,WallPaperWidth,RingType_Id) values("+int_MaxId.ToString()+",'"+HandSetModel+"',50,50,1)");
				val="1"; // 如果没有适配，将返回4.mid
			}
			else
			{
				// ＝＝＝获得手机铃声类型＝＝＝
				string str_Sql="select RingType_Id from HandSetFit where UPPER(Match)='"+HandSetModel+"'";
				string[] ref_Fld={"RingType_Id"};
				string[] ref_Val={""};
				GetDetail(ref_Fld,ref ref_Val,str_Sql);
				val=ref_Val[0]; 
			}
			return val; // 返回铃声
		}
		/// <summary>
		/// 下载连接
		/// </summary>
		/// <param name="Url">目录名称</param>
		/// <param name="lbl_Name">歌曲名称</param>
		/// <param name="lnk_DownLoad">下载连接</param>
		/// <param name="lnk_Lyric">歌词连接</param>
		/// <param name="page"></param>
		public void GetRingUrl(string Url,System.Web.UI.MobileControls.Label lbl_Name,System.Web.UI.MobileControls.Link lnk_DownLoad,System.Web.UI.MobileControls.Link lnk_Lyric,Page page)
		{
			string Message="";
			string RingTypeId=GetRingTypeId(page); 
			string str_FileName="";
			// 1.＝＝＝获得该目录下所有文件名，4.midi,16.midi＝＝＝
			System.IO.DirectoryInfo dt=new System.IO.DirectoryInfo(Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["DownLoadUrl"]+Url));
			if (dt.Exists==true)
			{
				FileInfo[] ff=dt.GetFiles();
				for (int i=0;i<ff.Length;i++)
				{
					// ＝＝＝文件名为DonotCryForMeArgentina_maidangna0.amr转换为0.amr＝＝＝
					if (i==0)
					{
						str_FileName=Path.GetFileName(ff[i].FullName).Replace(Url,"").Replace(" ",""); 
					}
					else
					{
						str_FileName=str_FileName+","+Path.GetFileName(ff[i].FullName).Replace(Url,"").Replace(" ","");
					}
				}
				str_FileName="'"+str_FileName.Replace(",","','")+"'";

				// 2.＝＝＝获得目录下所有铃声文件在适配表中的Id值，比如1,2,3,4, 转化为,1,2,3,4,,好做比较＝＝＝
				string str_Id=","+GetFiledStr("Id","RingType where Name in ("+str_FileName+")")+",";
				string[] arr_RingType_Id=RingTypeId.Split(',');
				int int_Max_RingType_Id=0;
				for (int i=0;i<arr_RingType_Id.Length;i++)
				{
					if (str_Id.IndexOf(","+arr_RingType_Id[i]+",")!=-1)
					{
						if (int_Max_RingType_Id<int.Parse(arr_RingType_Id[i]))
						{
							int_Max_RingType_Id=int.Parse(arr_RingType_Id[i]); // 和最大RingType_Id做比较，获得适配最大RingType_Id
						}
					}
				}
				try
				{
					// 3.＝＝＝通过最大RingType_Id获得文件名＝＝＝
					string str_Max_FileName=GetFiledValue("Select Name from RingType where Id="+int_Max_RingType_Id.ToString());
					Message=System.Configuration.ConfigurationSettings.AppSettings["DownLoadUrl"]+Url+"/"+Url+str_Max_FileName;
					lnk_DownLoad.NavigateUrl=Message;
				}
				catch
				{
					lbl_Name.Text="该铃声文件不存在";
					lnk_DownLoad.Visible=false;
					lnk_Lyric.Visible=false;
				}
				// ＝＝＝搜索该铃声文件＝＝＝＝
				if (File.Exists(Server.MapPath(Message))==false)
				{
					lbl_Name.Text="该铃声文件不存在";
					lnk_DownLoad.Visible=false;
					lnk_Lyric.Visible=false;
				}
			}
			else
			{
				lbl_Name.Text="该铃声目录不存在";
				lnk_DownLoad.Visible=false;
				lnk_Lyric.Visible=false;
			}
		}
		public string GetFiledStr1(string count,string field,string table_name)
		{
			string val="";
			DataTable dt=GetDs("Select top "+count+" "+field+" from "+table_name).Tables[0];
			for (int i=0;i<dt.Rows.Count;i++)
			{
				if (i==0)
				{
					val=dt.Rows[i][field].ToString();
				}
				else
				{