/// <summary>
/// 更新角色
/// </summary>
/// <param name="model">角色实体类</param>
/// <returns></returns>
public bool UpdateRole(RedGlovePermission.Model.RGP_Roles model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update RGP_Roles set ");
strSql.Append("RoleGroupID=@RoleGroupID,");
strSql.Append("RoleName=@RoleName,");
strSql.Append("RoleDescription=@RoleDescription");
strSql.Append(" where RoleID=@RoleID ");
SqlParameter[] parameters =
{
new SqlParameter("@RoleID", SqlDbType.Int, 4),
new SqlParameter("@RoleGroupID", SqlDbType.Int, 4),
new SqlParameter("@RoleName", SqlDbType.NVarChar, 30),
new SqlParameter("@RoleDescription", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.RoleID;
parameters[1].Value = model.RoleGroupID;
parameters[2].Value = model.RoleName;
parameters[3].Value = model.RoleDescription;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加数据
/// </summary>
protected void btn_add_Click(object sender, EventArgs e)
{
if (txt_Name.Text.Trim() != "")
{
RedGlovePermission.Model.RGP_Roles model = new RedGlovePermission.Model.RGP_Roles();
model.RoleName = txt_Name.Text.Trim();
model.RoleDescription = txt_Description.Text.Trim();
model.RoleGroupID = int.Parse(GroupList.SelectedValue);
switch (bll.CreateRole(model))
{
case 1:
txt_Name.Text = "";
txt_Description.Text = "";
BindOrder();
ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_true") + "')", true);
break;
case 2:
ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_Isgroup") + "')", true);
break;
default:
ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_false") + "')", true);
break;
}
}
}
/// <summary>
/// 增加角色
/// </summary>
/// <param name="model">角色实体类</param>
/// <returns></returns>
public int CreateRole(RedGlovePermission.Model.RGP_Roles model)
{
int ret = 0;
if (!RoleExists(model.RoleName, model.RoleGroupID))
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into RGP_Roles(");
strSql.Append("RoleGroupID,RoleName,RoleDescription)");
strSql.Append(" values (");
strSql.Append("@RoleGroupID,@RoleName,@RoleDescription)");
SqlParameter[] parameters =
{
new SqlParameter("@RoleGroupID", SqlDbType.Int, 4),
new SqlParameter("@RoleName", SqlDbType.NVarChar, 30),
new SqlParameter("@RoleDescription", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.RoleGroupID;
parameters[1].Value = model.RoleName;
parameters[2].Value = model.RoleDescription;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
ret = 1;
}
}
else
{
ret = 2;
}
return(ret);
}
/// <summary>
/// 获取角色实体
/// </summary>
/// <param name="RoleID">角色ID</param>
/// <returns></returns>
public RedGlovePermission.Model.RGP_Roles GetRoleModel(int RoleID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from RGP_Roles ");
strSql.Append(" where RoleID=@RoleID ");
SqlParameter[] parameters =
{
new SqlParameter("@RoleID", SqlDbType.Int, 4)
};
parameters[0].Value = RoleID;
RedGlovePermission.Model.RGP_Roles model = new RedGlovePermission.Model.RGP_Roles();
DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
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]["RoleRoleID"].ToString() != "")
{
model.RoleGroupID = int.Parse(ds.Tables[0].Rows[0]["RoleGroupID"].ToString());
}
model.RoleName = ds.Tables[0].Rows[0]["RoleName"].ToString();
model.RoleDescription = ds.Tables[0].Rows[0]["RoleDescription"].ToString();
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新数据
/// </summary>
protected void RolesLists_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
RedGlovePermission.Model.RGP_Roles model = new RedGlovePermission.Model.RGP_Roles();
model.RoleID = int.Parse(RolesLists.DataKeys[e.RowIndex].Values[0].ToString());
model.RoleName = ((TextBox)RolesLists.Rows[e.RowIndex].FindControl("txt_name")).Text.Trim();
model.RoleDescription = ((TextBox)RolesLists.Rows[e.RowIndex].FindControl("txt_Description")).Text.Trim();
model.RoleGroupID = int.Parse(((DropDownList)RolesLists.Rows[e.RowIndex].FindControl("GroupID")).SelectedValue);
if (!bll.UpdateRole(model))
{
ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_update_false") + "')", true);
}
//返回浏览狀態
RolesLists.EditIndex = -1;
BindOrder();
}
/// <summary>
/// 获取角色实体
/// </summary>
/// <param name="RoleID">角色ID</param>
/// <returns></returns>
public RedGlovePermission.Model.RGP_Roles GetRoleModel(int RoleID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 * from RGP_Roles ");
strSql.Append(" where RoleID=@RoleID ");
SqlParameter[] parameters = {
new SqlParameter("@RoleID", SqlDbType.Int,4)};
parameters[0].Value = RoleID;
RedGlovePermission.Model.RGP_Roles model=new RedGlovePermission.Model.RGP_Roles();
DataSet ds=SqlServerHelper.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
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]["RoleRoleID"].ToString()!="")
{
model.RoleGroupID = int.Parse(ds.Tables[0].Rows[0]["RoleGroupID"].ToString());
}
model.RoleName=ds.Tables[0].Rows[0]["RoleName"].ToString();
model.RoleDescription=ds.Tables[0].Rows[0]["RoleDescription"].ToString();
return model;
}
else
{
return null;
}
}
/// <summary>
/// 添加数据
/// </summary>
protected void btn_add_Click(object sender, EventArgs e)
{
if (txt_Name.Text.Trim() != "")
{
RedGlovePermission.Model.RGP_Roles model = new RedGlovePermission.Model.RGP_Roles();
model.RoleName = txt_Name.Text.Trim();
model.RoleDescription = txt_Description.Text.Trim();
model.RoleGroupID = int.Parse(GroupList.SelectedValue);
switch (bll.CreateRole(model))
{
case 1:
txt_Name.Text = "";
txt_Description.Text = "";
BindOrder();
ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_true") + "')", true);
break;
case 2:
ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_Isgroup") + "')", true);
break;
default:
ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_add_false") + "')", true);
break;
}
}
}
/// <summary>
/// 更新数据
/// </summary>
protected void RolesLists_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
RedGlovePermission.Model.RGP_Roles model = new RedGlovePermission.Model.RGP_Roles();
model.RoleID = int.Parse(RolesLists.DataKeys[e.RowIndex].Values[0].ToString());
model.RoleName = ((TextBox)RolesLists.Rows[e.RowIndex].FindControl("txt_name")).Text.Trim();
model.RoleDescription = ((TextBox)RolesLists.Rows[e.RowIndex].FindControl("txt_Description")).Text.Trim();
model.RoleGroupID = int.Parse(((DropDownList)RolesLists.Rows[e.RowIndex].FindControl("GroupID")).SelectedValue);
if (!bll.UpdateRole(model))
{
ScriptManager.RegisterClientScriptBlock(CustomPanel1, this.GetType(), "MsgBox", "alert('" + ResourceManager.GetString("Pub_Msg_update_false") + "')", true);
}
//返回浏览狀態
RolesLists.EditIndex = -1;
BindOrder();
}
