GridView的使用-3

 public List<Good> GetAllGood()
       {
           string sql = "select * from dbo.tb_Goods";
           SqlDataReader dr = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sql);
           List<Good> list = new List<Good>();
           while (dr.Read())
           {
               Good gd = new Good();
               gd.Id = Convert.ToInt32(dr["Id"]);
               gd.GoodName = Convert.ToString(dr["GoodName"]);
               gd.ChanDi = Convert.ToString(dr["ChanDi"]);
               gd.PiHao = Convert.ToString(dr["PiHao"]);
               gd.Company = new CompanyService().GetCompanyById(Convert.ToInt32(dr["GongYingShang"]));
               list.Add(gd);
           }
           dr.Close();
           return list;
       }
       public bool ModifyGood(Good gd)
       {
           string sql = string.Format("update dbo.tb_Goods set GoodName='{0}',ChanDi='{1}',PiHao='{2}',GongYingShang='{3}' where Id='{4}'", gd.GoodName, gd.ChanDi, gd.PiHao, gd.Company.Id, gd.Id);
           return DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql) > 0;
       }

        //公司信息一览表
        public List<Company> GetAllCompanys()
        {
            List<Company>  list=new List<Company> ();
            string sql = "select * from dbo.tb_Companys";
            SqlDataReader dr = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sql);
            while (dr.Read())
            {
                Company compan = new Company();
                compan.CompanyAddress = Convert.ToString(dr["CompanyAddress"]);
                compan.CompanyName = Convert.ToString(dr["CompanyName"]);
                compan.Email = Convert.ToString(dr["Email"]);
                compan.Fax = Convert.ToString(dr["Fax"]);
                compan.Id = Convert.ToInt32(dr["Id"]);
                compan.Linkman = Convert.ToString(dr["Linkman"]);
                compan.Postalcode = Convert.ToString(dr["Postalcode"]);
                compan.Tel = Convert.ToString(dr["Tel"]);
                list.Add(compan);
            }
            dr.Close();
            return list;
        }
        //添加公司信息
        public bool AddCompany(Company company)
        {
            string sql = string.Format("insert into dbo.tb_Companys(CompanyAddress,CompanyName,Email,Fax,Linkman,Postalcode,Tel) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", company.CompanyAddress, company.CompanyName, company.Email, company.Fax, company.Linkman, company.Postalcode, company.Tel);
            return DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql) > 0;
        }
        //删除公司信息
        public bool DeleteCompany(int id)
        {
            string sql = string.Format("delete dbo.tb_Companys where Id='{0}'", id);
            return DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql) > 0;
        }
        //修改公司信息
        public bool ModifyCompany(Company company)
        {
            string sql = string.Format("update dbo.tb_Companys set CompanyName='{0}',Email='{1}',Linkman='{2}',Tel='{3}' where Id='{4}'", company.CompanyName, company.Email, company.Linkman, company.Tel, company.Id);
            return DBHelper.ExecuteNonQuery(DBHelper.ConnectionString, CommandType.Text, sql) > 0;
        }
        //根据Id号获取公司信息
        public Company GetCompanyById(int id)
        { 
            Company compan = new Company();
            string sql = string.Format("select * from dbo.tb_Companys where Id='{0}'",id);
            SqlDataReader dr = DBHelper.ExecuteReader(DBHelper.ConnectionString, CommandType.Text, sql);
            while (dr.Read())
            {          
                compan.CompanyAddress = Convert.ToString(dr["CompanyAddress"]);
                compan.CompanyName = Convert.ToString(dr["CompanyName"]);
                compan.Email = Convert.ToString(dr["Email"]);
                compan.Fax = Convert.ToString(dr["Fax"]);
                compan.Id = Convert.ToInt32(dr["Id"]);
                compan.Linkman = Convert.ToString(dr["Linkman"]);
                compan.Postalcode = Convert.ToString(dr["Postalcode"]);
                compan.Tel = Convert.ToString(dr["Tel"]);
            }
            dr.Close();
            return compan;
        }