求：一个VB.net写的类，有读、增、修、删的功能。在线等，急。

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using whb147.IDAL;
namespace whb147.SQLServerDAL
{
    /// <summary>
    /// 数据访问类SMR_Educate。
    /// </summary>
    public class SMR_Educate : ISMR_Educate
    {
        public SMR_Educate()
        { }
        #region  成员方法        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(whb147.Entity.SMR_Educate entity)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into SMR_Educate(Educate_Title,Educate_Content,CityName,Educate_SDate,Educate_EDate,Educate_Address,Educate_Number,Educate_Equipment,Create_Date,IsFinish,Member_ID");
            strSql.Append(")");
            strSql.Append(" values (");
            strSql.Append("'" + entity.Educate_Title + "',");
            strSql.Append("'" + entity.Educate_Content + "',");
            strSql.Append("'" + entity.CityName + "',");
            strSql.Append("'" + entity.Educate_SDate + "',");
            strSql.Append("'" + entity.Educate_EDate + "',");
            strSql.Append("'" + entity.Educate_Address + "',");
            strSql.Append("'" + entity.Educate_Number + "',");
            strSql.Append("'" + entity.Educate_Equipment + "',");
            strSql.Append("'" + entity.Create_Date + "',");
            strSql.Append("'" + entity.IsFinish + "',");
            strSql.Append("'" + entity.Member_ID + "'");
            strSql.Append(")");
            DbHelperSQL.ExecuteSql(strSql.ToString());
            return entity.ID;
        }        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(whb147.Entity.SMR_Educate entity)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update SMR_Educate set ");
            strSql.Append("Educate_Title='" + entity.Educate_Title + "',");
            strSql.Append("Educate_Content='" + entity.Educate_Content + "',");
            strSql.Append("CityName='" + entity.CityName + "',");
            strSql.Append("Educate_SDate='" + entity.Educate_SDate + "',");
            strSql.Append("Educate_EDate='" + entity.Educate_EDate + "',");
            strSql.Append("Educate_Address='" + entity.Educate_Address + "',");
            strSql.Append("Educate_Number='" + entity.Educate_Number + "',");
            strSql.Append("Educate_Equipment='" + entity.Educate_Equipment + "',");
            strSql.Append("Create_Date='" + entity.Create_Date + "',");
            strSql.Append("IsFinish='" + entity.IsFinish + "',");
            strSql.Append("Member_ID='" + entity.Member_ID + "'");
            strSql.Append(" where ID=" + entity.ID + "");
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }        /// <summary>
        /// 删除一条数据
        /// </summary>
        public void Delete(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete SMR_Educate ");
            strSql.Append(" where ID=" + id);
            DbHelperSQL.ExecuteSql(strSql.ToString());
        }        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public whb147.Entity.SMR_Educate GetEntity(int id)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from SMR_Educate ");
            strSql.Append(" where id=" + id);
            whb147.Entity.SMR_Educate entity = new whb147.Entity.SMR_Educate();
            DataSet ds = DbHelperSQL.Query(strSql.ToString());
            entity.ID = id;
            if (ds.Tables[0].Rows.Count > 0)
            {
                entity.Educate_Title = ds.Tables[0].Rows[0]["Educate_Title"].ToString();
                entity.Educate_Content = ds.Tables[0].Rows[0]["Educate_Content"].ToString();
                entity.CityName = ds.Tables[0].Rows[0]["CityName"].ToString();
                entity.Educate_SDate = DateTime.Parse(ds.Tables[0].Rows[0]["Educate_SDate"].ToString());
                entity.Educate_EDate = DateTime.Parse(ds.Tables[0].Rows[0]["Educate_EDate"].ToString());
                entity.Educate_Address = ds.Tables[0].Rows[0]["Educate_Address"].ToString();
                entity.Educate_Number = int.Parse(ds.Tables[0].Rows[0]["Educate_Number"].ToString());
                entity.Educate_Equipment = ds.Tables[0].Rows[0]["Educate_Equipment"].ToString();
                entity.Create_Date = DateTime.Parse(ds.Tables[0].Rows[0]["Create_Date"].ToString());
                entity.IsFinish = bool.Parse(ds.Tables[0].Rows[0]["IsFinish"].ToString()) ? 1 : 0;//int.Parse(ds.Tables[0].Rows[0]["IsFinish"].ToString());
                entity.Member_ID = ds.Tables[0].Rows[0]["Member_ID"].ToString();
                return entity;
            }
            else
            {
                return null;
            }
        }        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select * from SMR_Educate ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            strSql.Append(" order by ID ");
            return DbHelperSQL.Query(strSql.ToString());
        }
        #endregion  成员方法
    }
}C#的，你看看就明白了