myclass.cs

客户关系管理系统

using System;
using System.Data.OleDb;
using System.Configuration;
using System.Data;

using System.Web.UI.WebControls;
using System.IO;
namespace HKeBookshop
{
	/// <summary>
	/// myclass 的摘要说明。
	/// </summary>
	public class myclass:System.Web.UI.Page
	{
		String dsn;
		
		public myclass()
		{
			string str;
			str  = ConfigurationSettings.AppSettings["connStr"];//读出webconfig 中的字符串
			dsn  = "provider=microsoft.jet.oledb.4.0;data source=" + Server.MapPath("/HKeBookshop").ToString() + str; 
			
		}

		public DataSet Readdate(string strSql)
		{
					
			DataSet dd=new DataSet();//创建一个数据集dd
			OleDbConnection dbconn=new OleDbConnection(dsn);//定义新的数据连接控件并初始化
			dbconn.Open();//打开连接
			OleDbDataAdapter adapter = new OleDbDataAdapter(strSql, dbconn);//定义并初始化数据适配器
			adapter.Fill(dd,"myDB");								//将数据适配器中的数据填充到数据集dd中
			dbconn.Close();//关闭连接
			return dd;
		}
		
		
		//读出用户的权限
		public string Readcode(string strSql)
		{
			try
			{
				string ret_str="none";
				//读出webconfig 中的字符串　（2）
				DataSet dd=new DataSet();												//创建一个数据集dd
				OleDbConnection dbconn=new OleDbConnection(dsn);						//定义新的数据连接控件并初始化
				dbconn.Open();//打开连接
				OleDbCommand adapter = new OleDbCommand(strSql, dbconn);				//定义并初始化数据适配器
				OleDbDataReader rr=adapter.ExecuteReader();								//将数据适配器中的数据填充到数据集dd中

				if (rr.HasRows==true)
				{
					if(rr.Read())
						ret_str=rr.GetString(3);
				}

				dbconn.Close();//关闭连接
				return ret_str;
			}
			catch(Exception err)
			{
				
				return "false";
				Response.Redirect("error.aspx");
			}
			
		}
		
		
		//读出各个子页的权限是否存在
		public string Readpower(string strin,string power)
		{
			string s1,str="none";
			int i,j=0,good=0;
			i=power.Length;
			while((j<i)&&(good==0))
			{
				s1=power.Substring(j,2);
				if (s1==strin)
					good=1;
				j=j+3;
			}
			if (good==1)
				str="good";
			return str;
		}

		public void changedata(string strSql)
		{
			
			OleDbConnection dbconn=new OleDbConnection(dsn);//定义新的数据连接控件并初始化
			OleDbCommand comm=new OleDbCommand(strSql,dbconn);//定义并初始化命令对象
			dbconn.Close();//关闭连接
			dbconn.Open();//打开连接

			comm.ExecuteNonQuery();//执行命令
			dbconn.Close();//关闭连接
		}

		public void Readdata(string sql,DataGrid dg)
		{
			DataSet ds=new DataSet();
			try
			{
				ds.Clear();
				OleDbConnection dbcon = new OleDbConnection(dsn);
				dbcon.Close();
				dbcon.Open();
				OleDbDataAdapter ada = new OleDbDataAdapter(sql,dbcon);
				ada.Fill(ds);
				dg.DataSource = ds;
				dg.DataBind();
				ds.Clear();
				dbcon.Close();
			}
			catch(Exception ex)
			{
				Response.Write("<script>alert('数据库读取出现异常！')</script>");
			}
			
		}

		public void ReadList(string sql,DataList dl)
		{
			DataSet ds=new DataSet();
			try
			{
				ds.Clear();
				OleDbConnection dbcon = new OleDbConnection(dsn);
				dbcon.Close();
				dbcon.Open();
				OleDbDataAdapter ada = new OleDbDataAdapter(sql,dbcon);
				ada.Fill(ds);
				dl.DataSource = ds;
				dl.DataBind();
				ds.Clear();
				dbcon.Close();
			}
			catch(Exception ex)
			{
				Response.Write("<script>alert('数据库读取出现异常！')</script>");
			}
			
		}

		public void Update(string sql,DataSet ds)
		{
			
			try
			{
				OleDbConnection dbcon = new OleDbConnection(dsn);
				OleDbCommand com = new OleDbCommand(sql,dbcon);
				dbcon.Close();
				dbcon.Open();
				com.ExecuteNonQuery();
				ds.Clear();
				dbcon.Close();
				//Response.Write("<script>alert('已经更新！')</script>");
			}

			catch(Exception ex)
			{
				Response.Write(ex);
				//Response.Redirect("error.aspx");
			}
		}

		public void delete(string sql,DataSet ds)
		{
			
			try
			{
				OleDbConnection dbcon = new OleDbConnection(dsn);
				OleDbCommand com = new OleDbCommand(sql,dbcon);
				dbcon.Close();
				dbcon.Open();
				com.ExecuteNonQuery();
				ds.Clear();
				dbcon.Close();
				//Response.Write("<script>alert('已经更新！')</script>");
			}

			catch(Exception ex)
			{
				Response.Write(ex);
				//Response.Redirect("error.aspx");
			}
		}

		public void Insert(string sql)
		{
			try
			{
				OleDbConnection dbcon = new OleDbConnection(dsn);
				OleDbCommand com = new OleDbCommand(sql,dbcon);
				dbcon.Close();
				dbcon.Open();
				com.ExecuteNonQuery();
				dbcon.Close();
				//Response.Write("<script>alert('该用户信息已经被插入！')</script>");
			}
			catch(Exception ex)
			{
				Response.Write(ex);
				//Response.Redirect("error.aspx");
			}
			
		}

		public void read(string sql,string t,DataSet ds)
		{
			
			try
			{
				OleDbConnection dbcon = new OleDbConnection(dsn);
				dbcon.Open();
				ds.Clear();
				OleDbDataAdapter ada = new OleDbDataAdapter(sql,dbcon);
				ada.Fill(ds,t);
				dbcon.Close();
				
			}
			catch(Exception ex)
			{
				//MessageBox.Show("出现错误,"+ex.Message);
				//Response.Redirect("error.aspx");
			}
		}

		public int countdays(DateTime t1,DateTime t2)
		{
			TimeSpan ts = new TimeSpan();
			ts = t2.Subtract(t1);
			return ts.Days;
		}


		public string md5(string str)
		{
			return System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(str,"MD5").ToLower().Substring(8,16) ; 
		}

	}
}