dictionarycodedao.cs

改程序能够查询课程表

using System; 
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Collections;
namespace StudentTest
{
    public class DictionaryCodeDAO
    {
        OleDbConnection ConDB;
        OleDbCommand DbCommand;
        OleDbDataReader DataReader;
        OleDbDataAdapter oleDbDataAdapter;
        public DictionaryCodeDAO()
        {
            ConDB = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db2.mdb");
        }
        
        public IList<DictionaryCode> FindAll()
        {
            String SQL;
            SQL = "select * from DictionaryCode";
            List<DictionaryCode> entities = new List<DictionaryCode>();
          
            DbCommand = new OleDbCommand(SQL, ConDB);
            DbCommand.Connection.Open();
            DataReader = DbCommand.ExecuteReader();
            while (DataReader.Read())
            {
                DictionaryCode DictionaryCode = new DictionaryCode();
                DictionaryCode.Code = DataReader["Code"].ToString();
                DictionaryCode.DictionaryName = DataReader["DictionaryName"].ToString();
                DictionaryCode.Value = DataReader["Value"].ToString();
                entities.Add(DictionaryCode);
            }
            DataReader.Close();
            ConDB.Close();
            return entities;
        }

        public DictionaryCode FindByNameAndCode(string name,string code)
        {
            String SQL;
            SQL = "select * from DictionaryCode  where DictionaryName=@DictionaryName and Code=@Code";
            List<DictionaryCode> entities = new List<DictionaryCode>();
            DbCommand = new OleDbCommand(SQL, ConDB);
            DbCommand.Parameters.Add(new OleDbParameter("@DictionaryName", name));
            DbCommand.Parameters.Add(new OleDbParameter("@Code", code));
            DbCommand.Connection.Open();
            DataReader = DbCommand.ExecuteReader();
            while (DataReader.Read())
            {
                DictionaryCode DictionaryCode = new DictionaryCode();
                DictionaryCode.Code = DataReader["Code"].ToString();
                DictionaryCode.DictionaryName = DataReader["DictionaryName"].ToString();
                DictionaryCode.Value = DataReader["Value"].ToString();
                entities.Add(DictionaryCode);
            }
            DataReader.Close();
            ConDB.Close();
            return entities[0];
        }

        public IList<DictionaryCode> FindByName(string name)
        {
            String SQL;
            SQL = "select * from DictionaryCode  where DictionaryName=@DictionaryName ";
            List<DictionaryCode> entities = new List<DictionaryCode>();
            DbCommand = new OleDbCommand(SQL, ConDB);
            DbCommand.Parameters.Add(new OleDbParameter("@DictionaryName", name));
       
            DbCommand.Connection.Open();
            DataReader = DbCommand.ExecuteReader();
            while (DataReader.Read())
            {
                DictionaryCode DictionaryCode = new DictionaryCode();
                DictionaryCode.Code = DataReader["Code"].ToString();
                DictionaryCode.DictionaryName = DataReader["DictionaryName"].ToString();
                DictionaryCode.Value = DataReader["Value"].ToString();
                entities.Add(DictionaryCode);
            }
            DataReader.Close();
            ConDB.Close();
            return entities;
        }
        public Boolean AddDictionaryCode(DictionaryCode DictionaryCode)
        {
            String SQL;
            try
            {
                SQL = "insert into DictionaryCode ([Code],[DictionaryName],[Value]) values (@Code,@DictionaryName,@Value)";
                DbCommand = new OleDbCommand(SQL, ConDB);
                DbCommand.Connection.Open();
                DbCommand.Parameters.Add("@Code", DictionaryCode.Code);
                DbCommand.Parameters.Add("@DictionaryName", DictionaryCode.DictionaryName);
                DbCommand.Parameters.Add("@Value", DictionaryCode.Value);
                DataReader = DbCommand.ExecuteReader();
                DataReader.Close();
                ConDB.Close();
                return true;
            }
            catch (System.Exception ex)
            {
                return false;
            }
        }
        public Boolean DelDictionaryCodeByPK(Int32 id)
        {
            String SQL;
            SQL = "delete from DictionaryCode where id=@id";
            DbCommand = new OleDbCommand(SQL, ConDB);
            DbCommand.Connection.Open();
            DataReader = DbCommand.ExecuteReader();
            if (DataReader.RecordsAffected == 1)
            {
                DataReader.Close();
                ConDB.Close();
                return true;
            }
            else
            {
                DataReader.Close();
                ConDB.Close();
                return false;
            }
        }
        public Boolean UpdateDictionaryCode(DictionaryCode DictionaryCode)
        {
            String SQL;
            SQL = "update  DictionaryCode  set  [Value]=@Value  where [Code]=@Code,[DictionaryName]=@DictionaryName";
            DbCommand = new OleDbCommand(SQL, ConDB);
            DbCommand.Connection.Open();
            DbCommand.Parameters.Add("@Value", DictionaryCode.Value);
            DbCommand.Parameters.Add("@Code", DictionaryCode.Code);
            DbCommand.Parameters.Add("@DictionaryName", DictionaryCode.DictionaryName);
           
          
            DataReader = DbCommand.ExecuteReader();
            if (DataReader.RecordsAffected == 1)
            {
                DataReader.Close();
                ConDB.Close();
                return true;
            }
            else
            {
                DataReader.Close();
                ConDB.Close();
                return false;
            }
        }
    }

}