dbutil.cs

超市管理系统的完整版文档

using System;
using System.Data.SqlClient;
using System.Data.SqlTypes;

namespace SupDataBase
{
	/// <summary>
	/// DBUtil 的摘要说明。
	/// </summary>
	public class DBUtil
	{
		
		static  System.Data.SqlClient.SqlConnection conn;
		static  int EmployeeId = -1;
		static  int Priority = 0;
        static  string username = "";
		static  bool isLogin = false;
		
		public DBUtil()
		{
			//
			// TODO: 在此处添加构造函数逻辑
			//
		 //  conn = new SqlConnection(((string)("workstation id=CZF911;packet size=4096;user id=supermarket;Password=supermarket;data source=CZF911;persist security info=False;initial catalog=supermarket")));
			
		}
		static public SqlConnection GetConnection()
		{
//			conn = new SqlConnection(
//				"workstation id=CZF911;"+
//				"user id =sa;"+
//				"password=123456;"+
//				"data source=CZF911;"+
//				"initial catalog=supermarket "
//				);

			conn = new SqlConnection(
			    "user id =sa;"+
				"password=123456;"+
				"initial catalog=supermarket "
				);
			                                  
			return conn;
		}
       
		static public void SetEmployeeID(int i)
		{
		   EmployeeId = i;
		
		}

		static public int GetEmployeeID()
		{
		  return EmployeeId;
		
		}

		static public void SetPriority(int i)
		{
		  Priority=i;
		   
		}

		static public int GetPriority()
		{
		
		  return Priority;
		}

		static public void SetUserName(string u)
		{
		    username =u;
		
		}

		static public string  GetUserName()
		{
		    return username;
		}
        
		static public void SetLoginStatus(bool u)
		{
			isLogin = u;
		
		}

		static public bool  GetLoginStatus()
		{
			return isLogin;
		}


	}
}