动态生成Panel

来源：互联网发布：网络虚拟超市怎么开编辑：程序博客网时间：2024/04/29 02:50
            string sql = "select a.*,b.name from room a,roomtype b where a.typeids=b.ids";            DataTable dt = DBUtil.dbutil.huoqu(sql);            string sql_check = "select * from room_check";            DataTable dt_check = DBUtil.dbutil.huoqu(sql_check);            Panel panel = null;            foreach (DataRow row in dt.Rows)            {                //定义panel                panel = new Panel();                panel.Height = 80;                panel.Width = 80;                //定义房间ID                Label lbRoomid = new Label();                lbRoomid.Width = 80;                lbRoomid.Top = 10;                lbRoomid.TextAlign = ContentAlignment.MiddleCenter;                lbRoomid.Text = row["roomid"].ToString();                //定义房间类型                Label lbRoomType = new Label();                lbRoomType.Width = 80;                lbRoomType.Top = 35;                lbRoomType.TextAlign = ContentAlignment.MiddleCenter;                lbRoomType.Text = row["name"].ToString();                //定义入住人姓名                Label lbUsername = new Label();                lbUsername.Width = 80;                lbUsername.Top = 35;                lbUsername.TextAlign = ContentAlignment.MiddleCenter;                panel.Tag = row["ids"].ToString();                if (row["status"].ToString() == "0")                {                    panel.BackColor = Color.Green;                    panel.Controls.Add(lbRoomid);                    panel.Controls.Add(lbRoomType);                }                if (row["status"].ToString() == "1")                {                    panel.BackColor = Color.Red;                    panel.Controls.Add(lbRoomid);                    DataRow[] rows = dt_check.Select("roomids = '" + row["ids"].ToString() + "'");                    if (rows.Count() > 0)                    {                        lbUsername.Text = rows[0]["username"].ToString();                    }                    panel.Controls.Add(lbUsername);                }                if (row["status"].ToString() == "2")                {                    panel.BackColor = Color.Yellow;                    panel.Controls.Add(lbRoomid);                    panel.Controls.Add(lbRoomType);                }                if (row["status"].ToString() == "3")                {                    panel.BackColor = Color.LawnGreen;                    panel.Controls.Add(lbRoomid);                    panel.Controls.Add(lbRoomType);                }                panel.ContextMenuStrip = contextMenuStrip1;                flowLayoutPanel1.Controls.Add(panel);            }
0 0