访问DB

 /// <summary>
 /// 数据访问类C。
 /// </summary>
 public class C
 {
  public C()
  {}
  #region  成员方法

  /// <summary>
  /// 是否存在该记录
  /// </summary>
  public bool Exists(string CNO)
  {
   StringBuilder strSql=new StringBuilder();
   strSql.Append("select count(1) from C");
   strSql.Append(" where CNO=@CNO ");
   SqlParameter[] parameters = {
     new SqlParameter("@CNO", SqlDbType.VarChar,50)};
   parameters[0].Value = CNO;

   return DbHelperSQL.Exists(strSql.ToString(),parameters);
  }

  /// <summary>
  /// 增加一条数据
  /// </summary>
  public void Add(Maticsoft.Model.C model)
  {
   StringBuilder strSql=new StringBuilder();
   strSql.Append("insert into C(");
   strSql.Append("CNO,CNAME,CTEACHER)");
   strSql.Append(" values (");
   strSql.Append("@CNO,@CNAME,@CTEACHER)");
   SqlParameter[] parameters = {
     new SqlParameter("@CNO", SqlDbType.VarChar,50),
     new SqlParameter("@CNAME", SqlDbType.VarChar,50),
     new SqlParameter("@CTEACHER", SqlDbType.VarChar,50)};
   parameters[0].Value = model.CNO;
   parameters[1].Value = model.CNAME;
   parameters[2].Value = model.CTEACHER;

   DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
  }
  /// <summary>
  /// 更新一条数据
  /// </summary>
  public void Update(Maticsoft.Model.C model)
  {
   StringBuilder strSql=new StringBuilder();
   strSql.Append("update C set ");
   strSql.Append("CNAME=@CNAME,");
   strSql.Append("CTEACHER=@CTEACHER");
   strSql.Append(" where CNO=@CNO ");
   SqlParameter[] parameters = {
     new SqlParameter("@CNO", SqlDbType.VarChar,50),
     new SqlParameter("@CNAME", SqlDbType.VarChar,50),
     new SqlParameter("@CTEACHER", SqlDbType.VarChar,50)};
   parameters[0].Value = model.CNO;
   parameters[1].Value = model.CNAME;
   parameters[2].Value = model.CTEACHER;

   DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
  }

  /// <summary>
  /// 删除一条数据
  /// </summary>
  public void Delete(string CNO)
  {
   
   StringBuilder strSql=new StringBuilder();
   strSql.Append("delete C ");
   strSql.Append(" where CNO=@CNO ");
   SqlParameter[] parameters = {
     new SqlParameter("@CNO", SqlDbType.VarChar,50)};
   parameters[0].Value = CNO;

   DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
  }

  /// <summary>
  /// 得到一个对象实体
  /// </summary>
  public Maticsoft.Model.C GetModel(string CNO)
  {
   
   StringBuilder strSql=new StringBuilder();
   strSql.Append("select  top 1 CNO,CNAME,CTEACHER from C ");
   strSql.Append(" where CNO=@CNO ");
   SqlParameter[] parameters = {
     new SqlParameter("@CNO", SqlDbType.VarChar,50)};
   parameters[0].Value = CNO;

   Maticsoft.Model.C model=new Maticsoft.Model.C();
   DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
   if(ds.Tables[0].Rows.Count>0)
   {
    model.CNO=ds.Tables[0].Rows[0]["CNO"].ToString();
    model.CNAME=ds.Tables[0].Rows[0]["CNAME"].ToString();
    model.CTEACHER=ds.Tables[0].Rows[0]["CTEACHER"].ToString();
    return model;
   }
   else
   {
    return null;
   }
  }

  /// <summary>
  /// 获得数据列表
  /// </summary>
  public DataSet GetList(string strWhere)
  {
   StringBuilder strSql=new StringBuilder();
   strSql.Append("select CNO,CNAME,CTEACHER ");
   strSql.Append(" FROM C ");
   if(strWhere.Trim()!="")
   {
    strSql.Append(" where "+strWhere);
   }
   return DbHelperSQL.Query(strSql.ToString());
  }

  /*
  /// <summary>
  /// 分页获取数据列表
  /// </summary>
  public DataSet GetList(int PageSize,int PageIndex,string strWhere)
  {
   SqlParameter[] parameters = {
     new SqlParameter("@tblName", SqlDbType.VarChar, 255),
     new SqlParameter("@fldName", SqlDbType.VarChar, 255),
     new SqlParameter("@PageSize", SqlDbType.Int),
     new SqlParameter("@PageIndex", SqlDbType.Int),
     new SqlParameter("@IsReCount", SqlDbType.Bit),
     new SqlParameter("@OrderType", SqlDbType.Bit),
     new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
     };
   parameters[0].Value = "C";
   parameters[1].Value = "ID";
   parameters[2].Value = PageSize;
   parameters[3].Value = PageIndex;
   parameters[4].Value = 0;
   parameters[5].Value = 0;
   parameters[6].Value = strWhere; 
   return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
  }*/

  #endregion  成员方法
 }