private void SetupAdminPage()
{
RoleSelect.DataSource = RoleUtil.GetRoles();
RoleSelect.DataTextField = "roleName";
RoleSelect.DataValueField = "roleId";
RoleSelect.DataBind();
RoleSelect.SelectedIndex = 0;
UserRole.DataSource = RoleUtil.GetRoles();
UserRole.DataTextField = "roleName";
UserRole.DataValueField = "roleId";
UserRole.DataBind();
CompanySelect.DataSource = CompanyUtil.GetCompanies();
CompanySelect.DataTextField = "companyName";
CompanySelect.DataValueField = "companyId";
CompanySelect.DataBind();
CompanySelect.SelectedIndex = 0;
LockedAccountSelect.DataSource = UserUtil.GetLockedUsers();
LockedAccountSelect.DataTextField = "Identity";
LockedAccountSelect.DataValueField = "UserId";
LockedAccountSelect.DataBind();
LockedAccountSelect.SelectedIndex = 0;
MakeUserTable();
MakeCompanyTable();
}
protected void Dropdownlistbind()
{
string strsql = "select * from Role";
DbHelp dbmanage = new DbHelp(EnumDbType.DbSqlServer, "server=NOLAN-DEBUG-PC\\SQLEXPRESS1;database=test;Trusted_Connection=SSPI;");
//OleDbConnection cn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath("..//..//DataBase//AccountInf.accdb"));
//cn.Open();
//OleDbCommand myCmd = new OleDbCommand(strsql, cn);
//OleDbDataAdapter oda = new OleDbDataAdapter(myCmd);
DataSet ds = dbmanage.QueryToDs(strsql);
//oda.Fill(ds, "Role");
RoleSelect.DataSource = ds.Tables[0].DefaultView;
RoleSelect.DataTextField = "Authority";
RoleSelect.DataValueField = "Authority";
RoleSelect.DataBind();
ListItem item = new ListItem("请选择");
RoleSelect.Items.Insert(0, item);
}
