<div class="tleft">
可访问的角色
</div>
<div class="tright">
<hw:DropDownCheckList id="DropDownCheckList1" runat="server" DataTextField="RESP_DESC_TEXT" DisplayTextWidth=300 DataValueField="roleID" TextWhenNoneChecked=" -------------------请选择----------------" DisplayTextList=Labels ClientCodeLocation="DropDownCheckList.js"></hw:DropDownCheckList>
</div>
</div>
string sql = "select RESP_DESC_TEXT from UCML_RESPONSIBILITY,SystemRoleRegistor where UCML_RESPONSIBILITY.roleID=SystemRoleRegistor.RoleID and SystemID='" + Convert.ToInt32(flag) + "'";
DataTable dtrid = new DataTable();
dtrid = db.SelectInfo(sql);
this.DropDownCheckList1.TextWhenNoneChecked = "";
for (int i = 0; i < dtrid.Rows.Count; i++)
{
this.DropDownCheckList1.TextWhenNoneChecked += dtrid.Rows[i][0].ToString() + ",";
}
DropDownCheckList1.DataSource = GetRoles();
DropDownCheckList1.DataBind();
DropDownCheckList1.DataValueField = "roleID";
DropDownCheckList1.DataTextField = "RESP_DESC_TEXT";
public DataTable GetRoles()
{
DBHelper db = new DBHelper();
DataTable dt = new DataTable();
DataTable newtable = new DataTable();
string sql = string.Empty;
sql = "select roleID,RESP_DESC_TEXT from UCML_RESPONSIBILITY";
dt = db.SelectInfo(sql);
newtable = dt.Clone();
foreach (DataRow dr in dt.Rows)
{
DataRow newrow = newtable.NewRow();
newrow["roleID"] = dr["roleID"];
newrow["RESP_DESC_TEXT"] = dr["RESP_DESC_TEXT"];
newtable.Rows.Add(newrow);
}
return newtable;
}
string roleIDs = this.DropDownCheckList1.SelectedValuesToString(",").ToString().Trim() + ",";
string[] splitID = roleIDs.Split(',');
//权限
string newsysid = "select SystemID from SystemRegistor order by SystemRegistorTime desc";
DataTable dtt = new DataTable();
dtt = db.SelectInfo(newsysid);
string sysid = dtt.Rows[0][0].ToString();
for (int i = 0; i < splitID.Length-1;i++ )
{
string insertsql = "insert into SystemRoleRegistor(SystemID,RoleID)values('" + sysid + "','" + splitID[i]+ "');";
db.Excute(insertsql);
}