using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class 今天值班员 : System.Web.UI.Page
{
private int numrow = 3;
protected void Page_Load(object sender, EventArgs e)
{
if (Session["name"] == null && Session["pwd"] == null)
{
Response.Redirect("~/登录.aspx");
}
SqlConnection con = BD.createDB();
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
con.Open();
cmd.CommandText = "select id from yuangong where gzzt='在岗'order by id desc";
int i = 0;
System.Web.UI.WebControls.TableRow tr = new TableRow();
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
i = i + 1;
System.Web.UI.WebControls.TableCell tc = new TableCell(); //声明一个TableCell对象
yuangong yg = (yuangong)this.LoadControl("~/员工控件.ascx"); //声明一个员工类型对象
yg.id1 = sdr.GetString(0);
tc.Controls.Add(yg); //将声明的用户自定义控件的对象填充到单元格中
tr.Controls.Add(tc); //将声明的单元格对象填充到行中
if (i % numrow == 0)
{
Table1.Rows.Add(tr); //向动态表添加行
tr = new TableRow();
}
if (i % numrow != 0)
{
Table1.Rows.Add(tr);
}
}
sdr.Close();
con.Close();
}
}