我用到的三种SQLHelper(三)详细用法

using System;

using System.Data;

using System.Configuration;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using SQLConstructor.DAL;

using System.Collections;

/// <summary>

/// Test 的摘要说明

/// </summary>

namespace SQLConstructor.BLL

{

    public class Test

    {

        #region 私有成员

        private int _Id;

        private string _Name;

        private string _Pwd;

        private string _Title;

        private string _Content;

        private DateTime _TTime;

        private bool _Checkout;

        private float _Price;

        #endregion

        #region 属性

        public int Id

        {

            get

            {

                return this._Id;

            }

            set

            {

                this._Id = value;

            }

        }

        #endregion

        public Test()

        {

            //

            // TODO: 在此处添加构造函数逻辑

            //

        }

        #region 方法

        /// <summary>

        /// 取得全部

        /// </summary>

        public DataTable getAllUser()

        {

            string sql = "";

            sql = "select * from test";

            Database db = new Database();

            return db.GetDataTable(sql);

        }

        /// <summary>

        /// 取得信息

        /// </summary>

        public DataRow getUser(int Id)

        {

            string sql = "";

            sql = "select * from test where Id = '" + Id + "'";

            Database db = new Database();

            return db.GetDataRow(sql);

        }

        /// <summary>

        /// 插入记录

        /// </summary>

        /// <param name="userinfo">信息表</param>

        /// <returns></returns>

        public int createUser(Hashtable userinfo)

        {

            Database db = new Database();		//实例化一个Database类

            return db.Insert("[test]", userinfo);	//利用Database类的Inser方法，插入数据

        }

        #endregion

    }

}