protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString.Count > 0)
{
string name = Request.QueryString["name"].ToString().Trim();
if (name.Equals("Edit"))
{
if (Request.QueryString["RoleID"].ToString().Trim() != null)
{
string roleGroupId = Request.QueryString["RoleID"].ToString().Trim();
RoleGroupTab roleGroup = new RoleGroupTab();
roleGroup = roleGroupBLL.GetRoleGroupById(roleGroupId);
if (roleGroup != null)
{
this.txtRoleGroupID.Text = roleGroup.MemberGradeID.ToString();
this.txtRoleGroupName.Text = roleGroup.MemberGradeName.ToString();
this.txtGroupRemark.Text = roleGroup.Remark.ToString();
this.txtRoleGroupID.ReadOnly = true;
this.Button1.Enabled = false;
}
}
}
}
}
}
/// <summary>
/// 添加角色组
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
string roleId = Request.QueryString["RoleID"].ToString();
RoleGroupTab roleGroup = new RoleGroupTab();
if (this.txtRoleGroupName.Text.ToString().Trim() == null || this.txtRoleGroupName.Text.ToString().Trim() == "")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('请输入角色组名称！');location.href='AddRoleGrop.aspx'", true);
return;
}
if (this.txtRoleGroupName.Text == "普通会员")
{
roleGroup.MemberGradeID = "1";
}
else if (this.txtRoleGroupName.Text == "银牌会员")
{
roleGroup.MemberGradeID = "2";
}
else if (this.txtRoleGroupName.Text == "金牌会员")
{
roleGroup.MemberGradeID = "3";
}
else if (this.txtRoleGroupName.Text == "钻石会员")
{
roleGroup.MemberGradeID = "4";
}
else
{
roleGroup.MemberGradeID = this.txtRoleGroupID.Text.ToString().Trim();
}
roleGroup.ManageTypeID = roleId;
roleGroup.MemberGradeName = this.txtRoleGroupName.Text.ToString().Trim();
roleGroup.SDate = DateTime.Now;
roleGroup.SCheck = 0;
roleGroup.IsVip = 0;
roleGroup.Remark = this.txtGroupRemark.Text.ToString().Trim();
if (IsExist(roleGroup.MemberGradeID, roleGroup.MemberGradeName))
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('角色组名称或角色组ID已存在！');location.href='AddRole.aspx'", true);
return;
}
try
{
if (roleGroupBLL.AddRoleGroup(roleGroup))
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加角色组成功！');location.href='ShowRoleList.aspx'", true);
return;
}
}
catch (Exception ex)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加角色组失败！');location.href='AddRoleGrop.aspx'", true);
return;
}
}
/// <summary>
/// 修改角色组信息
/// </summary>
/// <param name="roleTab"></param>
/// <returns></returns>
public bool UPdateRoleGroupInfo(RoleGroupTab roleTab)
{
bool flag = false;
SqlParameter[] para = new SqlParameter[] { new SqlParameter("@MemberGradeID", SqlDbType.NVarChar, 20),
new SqlParameter("@SName", SqlDbType.NVarChar, 50),
new SqlParameter("@Remark", SqlDbType.NVarChar, 200) };
para[0].Value = roleTab.MemberGradeID;
para[1].Value = roleTab.MemberGradeName;
para[2].Value = roleTab.Remark;
flag = DbHelperSQL.RunProcLob("Pro_UpdateRoleGroupInfo", para);
return(flag);
}
/// <summary>
/// 修改角色信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button2_Click1(object sender, EventArgs e)
{
RoleGroupTab roleGroup = new RoleGroupTab();
roleGroup.MemberGradeName = this.txtRoleGroupName.Text.ToString().Trim();
roleGroup.Remark = this.txtGroupRemark.Text.ToString().Trim();
roleGroup.MemberGradeID = this.txtRoleGroupID.Text.ToString().Trim();
if (roleGroupBLL.UPdateRoleGroupInfo(roleGroup))
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('角色组信息修改成功！');location.href='ShowRoleList.aspx'", true);
return;
}
else
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('角色组信息修改失败！');location.href='ShowRoleList.aspx'", true);
return;
}
}
/// <summary>
/// 根据角色组ID获取信息
/// </summary>
/// <param name="roleGroupId"></param>
/// <returns></returns>
public RoleGroupTab GetRoleGroupById(string roleGroupId)
{
RoleGroupTab roleGroup = null;
SqlParameter[] para = new SqlParameter[] { new SqlParameter("@roleGroupId", roleGroupId) };
para[0].Value = roleGroupId;
SqlDataReader reader = DbHelperSQL.RunProcedure("Pro_GetRoleGroupByID", para);
if (reader.Read())
{
roleGroup = new RoleGroupTab();
roleGroup.MemberGradeID = reader["MemberGradeID"].ToString();
roleGroup.MemberGradeName = reader["MemberGradeName"].ToString().Trim();
roleGroup.Remark = reader["Remark"].ToString().Trim();
roleGroup.SCheck = Convert.ToInt32(reader["SCheck"].ToString().Trim());
}
reader.Close();
reader.Dispose();
return(roleGroup);
}
/// <summary>
/// 添加角色组
/// </summary>
/// <param name="RoleGroup"></param>
/// <returns></returns>
public bool AddRoleGroup(RoleGroupTab RoleGroup)
{
bool flag = false;
SqlParameter[] para = { new SqlParameter("@RoleID", SqlDbType.Int, 4),
new SqlParameter("@SName", SqlDbType.NVarChar, 100),
new SqlParameter("@SCheck", SqlDbType.Int, 4),
new SqlParameter("@SDate", SqlDbType.SmallDateTime, 50),
new SqlParameter("@SysID", SqlDbType.NVarChar, 50),
new SqlParameter("@IsVIP", SqlDbType.BigInt, 4),
new SqlParameter("@Remark", SqlDbType.NVarChar, 500),
new SqlParameter("@Pcode", SqlDbType.NVarChar, 3000) };
para[0].Value = RoleGroup.ManageTypeID;
para[1].Value = RoleGroup.MemberGradeName;
para[2].Value = RoleGroup.SCheck;
para[3].Value = RoleGroup.SDate;
para[4].Value = RoleGroup.MemberGradeID;
para[5].Value = RoleGroup.IsVip;
para[6].Value = RoleGroup.Remark;
para[7].Value = "暂无";
flag = DbHelperSQL.RunProcLob("Pro_AddGroupRole", para);
return(flag);
}
/// <summary>
/// 修改角色组信息
/// </summary>
/// <param name="roleTab"></param>
/// <returns></returns>
public bool UPdateRoleGroupInfo(RoleGroupTab roleTab)
{
return(RGDale.UPdateRoleGroupInfo(roleTab));
}
/// <summary>
/// 添加角色组
/// </summary>
/// <param name="RoleGroup"></param>
/// <returns></returns>
public bool AddRoleGroup(RoleGroupTab RoleGroup)
{
return(RGDale.AddRoleGroup(RoleGroup));
}
