当前文件： DadaMVC/App_Code/BLL/User.cs[2K，2009-6-12 11:38:34]，打开代码结构图

		            
  1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Web;
  5using System.Web.Security;
  6using System.Web.UI;
  7using System.Web.UI.HtmlControls;
  8using System.Web.UI.WebControls;
  9using System.Web.UI.WebControls.WebParts;
 10
 11/**//// <summary>
 12///User
 13/// </summary>
 14public class User
 15...{
 16    public User()
 17    ...{
 18        //
 19        //TODO: 在此处添加构造函数逻辑
 20        //
 21    }
 22    
 23
 24    /**//// <summary>
 25    /// 添加
 26    /// </summary>
 27    /// <param name="User"></param>
 28    /// <returns></returns>
 29    public bool InsertUser(Model User)
 30    ...{
 31        string sql = "insert into Book(Name,QQ,Message) values('" + User.Name + "','" + User.QQ + "','" + User.Message + "')";
 32        DataBase Pn163 = new DataBase();
 33        if (Pn163.ExecuteCmd(sql) > 0)
 34            return true;
 35        else return false;
 36    }
 37
 38
 39    /**//// <summary>
 40    /// 显示
 41    /// </summary>
 42    /// <returns></returns>
 43    public DataSet DataSet()
 44    ...{
 45        DataBase Pn163 = new DataBase();
 46        string sql = "select * from Book order by id desc";
 47        return Pn163.GetDataSet(sql);
 48        
 49    }
 50
 51    /**//// <summary>
 52    /// 删除
 53    /// </summary>
 54    /// <param name="User"></param>
 55    /// <returns></returns>
 56    public bool Delete(Model User)
 57    ...{
 58        string sql = "delete from Book where id=" + User.id;
 59        DataBase Pn163 = new DataBase();
 60        if (Pn163.ExecuteCmd(sql) > 0)
 61            return true;
 62        else return false;
 63    }
 64
 65    /**//// <summary>
 66    /// 查询
 67    /// </summary>
 68    /// <param name="User"></param>
 69    /// <returns></returns>
 70    public bool Read(Admin User)
 71    ...{
 72        string sql = "select * from Admin where AdminName= '" 
 73        + User.AdminName + "'and AdminPwd = '" + User.AdminPwd + "'";
 74        DataBase Pn163 = new DataBase();
 75        if (Pn163.ExecuteRead(sql) > 0)
 76        ...{
 77            return true;
 78        }
 79        else return false;
 80    }
 81
 82    public DataTable EditTable(Model User)
 83    ...{
 84        string sql = "select * from Book where id=" + User.id;
 85        DataBase Pn163 = new DataBase();
 86        return Pn163.getDataTable(sql);
 87    }
 88
 89    /**//// <summary>
 90    /// 修改
 91    /// </summary>
 92    /// <param name="User"></param>
 93    /// <returns></returns>
 94    public bool Edit(Model User)
 95    ...{
 96        string sql = "update Book set Name='" + User.Name + "',QQ='"+User.QQ+"',Message='"+User.Message+"' where id="+User.id;
 97        DataBase Pn163 = new DataBase();
 98        if (Pn163.ExecuteCmd(sql) > 0)
 99        ...{
100            return true;
101        }
102        else return false;
103    }
104}
105