当前位置:编程学习 > C#/ASP.NET >>

最近在学习C#有好多知识都不了解,请各路高手帮忙指点(FeatureModel.cs)

请高手帮忙添加注释!
using System;
using System.Data.SqlClient;
using System.Data;
using System.Collections.Generic;

namespace kms.Models
{
    public class FeatureModel:BaseModel
    {
        protected string tablename = "feature";

        public int id;

        public string feature_name;

        public List<FeatureModel> list()
        {
            string sql = "SELECT id,feature_name FROM " + this.tablename + " ORDER BY id DESC";
            SqlDataReader sdr = getReader(sql, null);
            List<FeatureModel> flist = new List<FeatureModel>();
            if (sdr.HasRows)
            {
                while (sdr.Read())
                {
                    FeatureModel mm = new FeatureModel();
                    mm.id = Convert.ToInt32(sdr["id"].ToString());
                    mm.feature_name = sdr["feature_name"].ToString();
                    flist.Add(mm);
                }
            }
            sdr.Close();
            return flist;
        }

        public void delete(int id)
        {
            string sql = "DELETE FROM "+this.tablename+" WHERE id=@id";
            SqlParameter[] parArray = { 
                CommonLb.makeParam("@id",SqlDbType.Int,id)
            };
            excuteQuery(sql, parArray);
        }

        public int add(string feature_name)
        {
            string sql = "INSERT INTO " + this.tablename + "(feature_name) VALUES(@feature_name)";
            SqlParameter[] parArray = { 
                CommonLb.makeParam("@feature_name",SqlDbType.NVarChar,feature_name)
            };
            return excuteQuery(sql, parArray);
        }
        public FeatureModel getOne(int id)
        {
            if (id <= 0)
                return null;
            FeatureModel mm = new FeatureModel();
            SqlParameter[] parArray = { 
                CommonLb.makeParam("@id",SqlDbType.Int,id)
            };
            string sql = "SELECT TOP 1 id,feature_name FROM " + this.tablename + " WHERE id=@id";
            SqlDataReader sdr = getReader(sql, parArray);
            if (sdr.HasRows)
            {
                sdr.Read();
                mm.feature_name = sdr["feature_name"].ToString();
                mm.id = Convert.ToInt32(sdr["id"].ToString());
            }
            sdr.Close();
            return mm;
        }

        public int update(int id, string feature_name)
        {
            string sql = "UPDATE " + this.tablename + " SET feature_name=@feature_name WHERE id=@id";
            SqlParameter[] parArray = { 
                CommonLb.makeParam("@feature_name",SqlDbType.NVarChar,feature_name),
                CommonLb.makeParam("@id",SqlDbType.Int,id)
            };
            return excuteQuery(sql, parArray);
        }
    }
} --------------------编程问答-------------------- using System;
using System.Data.SqlClient;
using System.Data;
using System.Collections.Generic;引入命令空间

namespace kms.Models
{
  public class FeatureModel:BaseModel定义类
  {
  protected string tablename = "feature";定义成员

  public int id;
定义成员
  public string feature_name;定义成员

  public List<FeatureModel> list()定义方法
  {
  string sql = "SELECT id,feature_name FROM " + this.tablename + " ORDER BY id DESC";
  SqlDataReader sdr = getReader(sql, null);
  List<FeatureModel> flist = new List<FeatureModel>();
  if (sdr.HasRows)
  {
  while (sdr.Read())
  {
  FeatureModel mm = new FeatureModel();
  mm.id = Convert.ToInt32(sdr["id"].ToString());
  mm.feature_name = sdr["feature_name"].ToString();
  flist.Add(mm);
  }
  }
  sdr.Close();
  return flist;
  }

  public void delete(int id)定义方法
  {
  string sql = "DELETE FROM "+this.tablename+" WHERE id=@id";
  SqlParameter[] parArray = { 
  CommonLb.makeParam("@id",SqlDbType.Int,id)操作数据库
  };
  excuteQuery(sql, parArray);
  }

  public int add(string feature_name)
  {
  string sql = "INSERT INTO " + this.tablename + "(feature_name) VALUES(@feature_name)";
  SqlParameter[] parArray = { 
  CommonLb.makeParam("@feature_name",SqlDbType.NVarChar,feature_name)操作数据库
  };
  return excuteQuery(sql, parArray);
  }
  public FeatureModel getOne(int id)
  {
  if (id <= 0)
  return null;
  FeatureModel mm = new FeatureModel();
  SqlParameter[] parArray = { 
  CommonLb.makeParam("@id",SqlDbType.Int,id)
  };
  string sql = "SELECT TOP 1 id,feature_name FROM " + this.tablename + " WHERE id=@id";
  SqlDataReader sdr = getReader(sql, parArray);操作数据库
  if (sdr.HasRows)
  {
  sdr.Read();
  mm.feature_name = sdr["feature_name"].ToString();
  mm.id = Convert.ToInt32(sdr["id"].ToString());
  }
  sdr.Close();
  return mm;
  }

  public int update(int id, string feature_name)
  {
  string sql = "UPDATE " + this.tablename + " SET feature_name=@feature_name WHERE id=@id";
  SqlParameter[] parArray = { 
  CommonLb.makeParam("@feature_name",SqlDbType.NVarChar,feature_name),
  CommonLb.makeParam("@id",SqlDbType.Int,id)操作数据库
  };
  return excuteQuery(sql, parArray);
  }
  }
}
补充:.NET技术 ,  C#
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,