protected void Page_Load(object sender, EventArgs e)
{
//init
LoginedMember = (Member)Session["MEMBER"];
dbManager = (DBManager)Session["DBadmin"];
int ColCount = 4;
TableRow tr = new TableRow();
TableCell td = new TableCell();
tr.Cells.Add(td);
List <string> TableNames = Theater.GetMemberNameToSting();
//테이블 제목열
//개선필요(isjeong 7. 27)
for (int i = 0; i < ColCount; i++)
{
td = new TableCell();
switch (i)
{
case 0:
td.Text = "ID";
break;
case 1:
td.Text = "이름";
break;
case 2:
td.Text = "나이";
break;
case 3:
td.Text = "잔여포인트";
break;
}
tr.Cells.Add(td);
}
tr.BackColor = Color.FromName("#ccccff");
Table1.Rows.Add(tr);
//멤버 목록 호출
string Command = "SELECT * FROM Member WHERE ID <> @id";
List <Tuple <string, object> > Params = new List <Tuple <string, object> >();
Params.Add(new Tuple <string, object>("@ID", "admin"));
SqlDataReader reader = dbManager.GetDataList(Command, Params);
List <dataSet.Member> Members = dataSet.Member.SqlDataReaderToMember(reader);
foreach (var member in Members)
{
tr = new TableRow();
td = new TableCell();
//테이블의 열마다 체크박스를 추가하고 ID를 열의 ID와 매핑시킨다.
CheckBox chkbox = new CheckBox();
chkbox.ID = member.ID.ToString();
td.Controls.Add(chkbox);
tr.Cells.Add(td);
// 루프를 돌면서 각 셀을 설정한다.
for (int j = 0; j < ColCount; j++)
{
td = new TableCell();
//임시
switch (j)
{
case 0:
td.Text = member.ID;
break;
case 1:
td.Text = member.Name;
break;
case 2:
td.Text = member.Age;
break;
case 3:
td.Text = member.Point;
break;
}
tr.Cells.Add(td);
}
tr.BackColor = Color.White;
Table1.Rows.Add(tr);
}
}
protected void Page_Load(object sender, EventArgs e)
{
//init
LoginedMember = (Member)Session["MEMBER"];
dbManager = (DBManager)Session["DBadmin"];
int ColCount = 4;
//Table 셋팅
TableRow tr = new TableRow();
TableCell td = new TableCell();
tr.Cells.Add(td);
List <string> TableNames = Theater.GetMemberNameToSting();
//테이블 제목열
for (int i = 0; i < ColCount; i++)
{
td = new TableCell();
td.Text = TableNames[i];
tr.Cells.Add(td);
}
tr.BackColor = Color.FromName("#ccccff");
Table1.Rows.Add(tr);
//기존 생성된 상영관 목록을 불러와 테이블에 입력한다.
string Command = "SELECT * FROM Theater ORDER BY TheaterID ASC";
SqlDataReader reader = dbManager.GetDataList(Command, new List <Tuple <string, object> >());
List <dataSet.Theater> Theaters = dataSet.Theater.SqlDataReaderToMember(reader);
foreach (var theater in Theaters)
{
tr = new TableRow();
td = new TableCell();
//테이블의 열마다 체크박스를 추가하고 ID를 열의 ID와 매핑시킨다.
CheckBox chkbox = new CheckBox();
chkbox.ID = theater.TheaterID.ToString();
td.Controls.Add(chkbox);
tr.Cells.Add(td);
// 루프를 돌면서 각 셀을 설정한다.
for (int j = 0; j < ColCount; j++)
{
td = new TableCell();
//임시
switch (j)
{
case 0:
td.Text = theater.TheaterID;
break;
case 1:
td.Text = theater.Seatcount;
break;
case 2:
td.Text = theater.Seatrowcount;
break;
case 3:
td.Text = theater.Seatnumbercount;
break;
}
tr.Cells.Add(td);
}
tr.BackColor = Color.White;
Table1.Rows.Add(tr);
}
}