accesscode.cs

来自「3D游戏编程入门经典.」· CS 代码 · 共 109 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Data;

namespace CodeSW
{
    class AccessCode
    {
        public List<EntityClass> CSharp_Reader()
        {
            try
            {
                string Name;
                string CSselect = "SELECT CSharp.Name FROM CSharp";
                OleDbConnection SelectNameconn = CodeSW.DBA.DBAccess.GetOleDBconnObject("");
                SelectNameconn.Open();
                OleDbDataReader CSreader = CodeSW.DBA.DBAccess.ExecuteReader(CSselect, SelectNameconn);
                List<EntityClass> li = new List<EntityClass>();

                while (CSreader.Read())
                {
                    Name = CSreader[0].ToString();
                    EntityClass ec = new EntityClass(Name, null, 0);
                    li.Add(ec);
                }
                SelectNameconn.Close();
                return li;
            }
            catch
            {
                return null;
            }
            
        }

        public EntityClass CSharp_OneCode_Select(string GetName)
        {
            try
            {
                string Code;
                int ID;
                string CSselectOne = "SELECT * FROM CSharp WHERE Name='" + GetName + "'";
                OleDbConnection CSselectOnecnn = CodeSW.DBA.DBAccess.GetOleDBconnObject("");
                CSselectOnecnn.Open();

                OleDbDataReader CSselectOneReader = CodeSW.DBA.DBAccess.ExecuteReader(CSselectOne, CSselectOnecnn);
                if (CSselectOneReader.Read())
                {
                    Code = CSselectOneReader[2].ToString();
                    ID = Convert.ToInt32(CSselectOneReader[0]);
                    EntityClass ec = new EntityClass(null, Code, ID);
                    CSselectOnecnn.Close();
                    return ec;

                }
                else
                    return null;
            }
            catch
            {
                return null;
            }
        }

        public int CSharp_Add(EntityClass ec)
        {
            try
            {
                string Addstring = "INSERT INTO CSharp ( Name, Code ) VALUES ('" + ec.Name + "','" + ec.Code + "')";
                return CodeSW.DBA.DBAccess.ExecuteNonQuery(Addstring);
            }
            catch
            {
                return 0;
            }
        }

        public int CSharp_Del(string DelName)
        {
            try
            {
                string Delstring = "DELETE * FROM CSharp WHERE Name='" + DelName + "'";
                return CodeSW.DBA.DBAccess.ExecuteNonQuery(Delstring);
            }
            catch
            {
                return 0;
            }
            
        }

        public int CSharp_Update(EntityClass ec)
        {
            try
            {
                string Updatestring = "UPDATE CSharp SET Name = '" + ec.Name + "',Code = '" + ec.Code + "' WHERE ID = " + ec.ID;
                return CodeSW.DBA.DBAccess.ExecuteNonQuery(Updatestring);
            }
            catch
            {
                return 0;
            }
        }
    }
}