C# (CSharp) QPS.NEW.BLL.Room.GetDataTableListの例

コード例 #1

ファイル: MainPage.aspx.cs プロジェクト: lincoln56/robinerp

 private void GetRecommendRoom()
 {
     string tempstr = string.Empty;
     QPS.NEW.BLL.Room room = new QPS.NEW.BLL.Room();
     DataTable dt = room.GetDataTableList("select top 50 * from Room where IfRecommend=1 order by id desc");
     if (dt!=null)
     {
         for (int i = 0; i < dt.Rows.Count;i++ )
         {
             tempstr += "<li><span><a href=\"RoomDetail.aspx?id=" + dt.Rows[i]["id"].ToString() + "\"><img src=\"/" + dt.Rows[i]["ImagePath"].ToString() + "\" alt=\"" + dt.Rows[i]["Name"].ToString() + "\"></a></span><p><a href=\"RoomDetail.aspx?id=" + dt.Rows[i]["id"].ToString() + "\">" + dt.Rows[i]["Name"].ToString() + "</a></p></li>\r\n";
         }
     }
     this.RecommendRoom.Text = tempstr;
 }

コード例 #2

ファイル: MainPage.aspx.cs プロジェクト: hackerlank/robinerp

        private void GetRecommendRoom()
        {
            string tempstr = string.Empty;

            QPS.NEW.BLL.Room room = new QPS.NEW.BLL.Room();
            DataTable        dt   = room.GetDataTableList("select top 50 * from Room where IfRecommend=1 order by id desc");

            if (dt != null)
            {
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    tempstr += "<li><span><a href=\"RoomDetail.aspx?id=" + dt.Rows[i]["id"].ToString() + "\"><img src=\"/" + dt.Rows[i]["ImagePath"].ToString() + "\" alt=\"" + dt.Rows[i]["Name"].ToString() + "\"></a></span><p><a href=\"RoomDetail.aspx?id=" + dt.Rows[i]["id"].ToString() + "\">" + dt.Rows[i]["Name"].ToString() + "</a></p></li>\r\n";
                }
            }
            this.RecommendRoom.Text = tempstr;
        }