/// <summary>
/// 添加角色
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAddRoleForUser_Click(object sender, EventArgs e)
{
LabMS.BLL.UserRole BUR = new LabMS.BLL.UserRole();
LabMS.Model.UserRole MUR = new LabMS.Model.UserRole();
int UserID = int.Parse(Request.QueryString["UserID"].ToString());
CheckBox chk;
bool success = false;
for (int i = 0; i < gvRole.Rows.Count; i++)
{
chk = (CheckBox)gvRole.Rows[i].FindControl("chk");
if (chk.Checked)
{
int RoleID =int.Parse(gvRole.DataKeys[i].Value.ToString());
MUR.RoleID = RoleID;
MUR.UserID = UserID;
BUR.Add(MUR);
success = true;
}
}
if (success == true)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "", "<script type='text/javascript'>alert('增加角色信息成功！');window.opener.location.href=window.opener.location.href;self.close();</script>");
}
else
{
Common.JShelper.JSAlert(this.Page, "", "增加角色信息失败！");
}
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public LabMS.Model.UserRole GetModel(int ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ID,RoleID,UserID from UserRole ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = ID;
LabMS.Model.UserRole model=new LabMS.Model.UserRole();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["ID"].ToString()!="")
{
model.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if(ds.Tables[0].Rows[0]["RoleID"].ToString()!="")
{
model.RoleID=int.Parse(ds.Tables[0].Rows[0]["RoleID"].ToString());
}
if(ds.Tables[0].Rows[0]["UserID"].ToString()!="")
{
model.UserID=int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString());
}
return model;
}
else
{
return null;
}
}