public List<tbBilldetail> tbBilldetail_GetByTop(string Top, string Where, string Order)
 {
     List<Data.tbBilldetail> list = new List<Data.tbBilldetail>();
     using (SqlCommand dbCmd = new SqlCommand("sp_tbBilldetail_GetByTop", GetConnection()))
     {
         Data.tbBilldetail obj = new Data.tbBilldetail();
         dbCmd.CommandType = CommandType.StoredProcedure;
         dbCmd.Parameters.Add(new SqlParameter("@Top", Top));
         dbCmd.Parameters.Add(new SqlParameter("@Where", Where));
         dbCmd.Parameters.Add(new SqlParameter("@Order", Order));
         SqlDataReader dr = dbCmd.ExecuteReader();
         if (dr.HasRows)
         {
             while (dr.Read())
             {
                 list.Add(obj.tbBilldetailIDataReader(dr));
             }
             dr.Close();
             //conn.Close();
         }
         else
         {
             dr.Close();
         }
     }
     return list;
 }
 public List<tbBilldetail> tbBilldetail_GetByAll()
 {
     List<Data.tbBilldetail> list = new List<Data.tbBilldetail>();
     using (SqlCommand dbCmd = new SqlCommand("sp_tbBilldetail_GetByAll", GetConnection()))
     {
         Data.tbBilldetail obj = new Data.tbBilldetail();
         dbCmd.CommandType = CommandType.StoredProcedure;
         SqlDataReader dr = dbCmd.ExecuteReader();
         if (dr.HasRows)
         {
             while (dr.Read())
             {
                 list.Add(obj.tbBilldetailIDataReader(dr));
             }
             dr.Close();
             //conn.Close();
         }
         else
         {
             dr.Close();
         }
     }
     return list;
 }
        public tbBilldetail tbBilldetailIDataReader(IDataReader dr)
        {
            Data.tbBilldetail obj = new Data.tbBilldetail();
			obj.id = (dr["id"] is DBNull) ? string.Empty : dr["id"].ToString();
			obj.bilid = (dr["bilid"] is DBNull) ? string.Empty : dr["bilid"].ToString();
			obj.proid = (dr["proid"] is DBNull) ? string.Empty : dr["proid"].ToString();
 public List<tbBilldetail> tbBilldetail_Paging(string CurentPage, string PageSize)
 {
     List<Data.tbBilldetail> list = new List<Data.tbBilldetail>();
     using (SqlCommand dbCmd = new SqlCommand("sp_tbBilldetail_Paging", GetConnection()))
     {
         Data.tbBilldetail obj = new Data.tbBilldetail();
         dbCmd.CommandType = CommandType.StoredProcedure;
         dbCmd.Parameters.Add(new SqlParameter("@CurentPage", CurentPage));
         dbCmd.Parameters.Add(new SqlParameter("@PageSize", PageSize));
         SqlDataReader dr = dbCmd.ExecuteReader();
         if (dr.HasRows)
         {
             while (dr.Read())
             {
                 list.Add(obj.tbBilldetailIDataReader(dr));
             }
             dr.Close();
             //conn.Close();
         }
         else
         {
             dr.Close();
         }
     }
     return list;
 }