protected void Page_Load(object sender, EventArgs e)
{
if ("" == Request.QueryString["rid"] || null == Request.QueryString["rid"])
{
if (this.hidPrimary.Value == "-1")
{
this.LbTabName.Text = "添加角色"; //设置选项卡名称
this.LbHeadName.Text = "添加角色"; //设置标题头名称
}
else
{
this.LbTabName.Text = "编辑角色"; //设置选项卡名称
this.LbHeadName.Text = "编辑角色"; //设置标题头名称
int RoleID = Convert.ToInt32(this.hidPrimary.Value);
Entity.BASE_ROLE model = bll.GetEntity(RoleID);
SetEntity(model);
}
}
else
{
this.LbTabName.Text = "编辑角色"; //设置选项卡名称
this.LbHeadName.Text = "编辑角色"; //设置标题头名称
int RoleID = Convert.ToInt32(Request.QueryString["rid"]);
Entity.BASE_ROLE model = bll.GetEntity(RoleID);
SetEntity(model);
}
dataBindToRepeater();
}
/// <summary>
/// 更新角色
/// </summary>
/// <param name="model">角色实体类</param>
/// <returns></returns>
public bool UpdateRole(Entity.BASE_ROLE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Base_Role set ");
strSql.Append("RoleGroupID=@RoleGroupID,");
strSql.Append("RoleName=@RoleName,");
strSql.Append("RoleDescription=@RoleDescription,");
strSql.Append("RoleOrder=@RoleOrder");
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),
new SqlParameter("@RoleOrder", SqlDbType.Int, 4)
};
parameters[0].Value = model.RoleID;
parameters[1].Value = model.RoleGroupID;
parameters[2].Value = model.RoleName;
parameters[3].Value = model.RoleDescription;
parameters[4].Value = model.RoleOrder;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Entity.BASE_ROLE entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Base_Role(");
strSql.Append("RoleGroupID,RoleName,RoleDescription,RoleOrder");
strSql.Append(") values (");
strSql.Append("@RoleGroupID,@RoleName,@RoleDescription,@RoleOrder");
strSql.Append(") ");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@RoleGroupID", SqlDbType.Int, 4),
new SqlParameter("@RoleName", SqlDbType.NVarChar, 30),
new SqlParameter("@RoleDescription", SqlDbType.NVarChar, 50),
new SqlParameter("@RoleOrder", SqlDbType.Int, 4)
};
parameters[0].Value = entity.RoleGroupID;
parameters[1].Value = entity.RoleName;
parameters[2].Value = entity.RoleDescription;
parameters[3].Value = entity.RoleOrder;
object obj = SqlServerHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 增加角色
/// </summary>
/// <param name="model">角色实体类</param>
/// <returns></returns>
public int CreateRole(Entity.BASE_ROLE model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Base_Role(");
strSql.Append("RoleGroupID,RoleName,RoleDescription,RoleOrder)");
strSql.Append(" values (");
strSql.Append("@RoleGroupID,@RoleName,@RoleDescription,@RoleOrder)");
SqlParameter[] parameters =
{
new SqlParameter("@RoleGroupID", SqlDbType.Int, 4),
new SqlParameter("@RoleName", SqlDbType.NVarChar, 30),
new SqlParameter("@RoleDescription", SqlDbType.NVarChar, 50),
new SqlParameter("@RoleOrder", SqlDbType.Int, 4)
};
parameters[0].Value = model.RoleGroupID;
parameters[1].Value = model.RoleName;
parameters[2].Value = model.RoleDescription;
parameters[3].Value = model.RoleOrder;
if (SqlServerHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return(1);
}
else
{
return(0);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Entity.BASE_ROLE entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update BASE_ROLE set ");
strSql.Append(" ROLEID = :ROLEID , ");
strSql.Append(" ROLENAME = :ROLENAME , ");
strSql.Append(" ROLEINFO = :ROLEINFO ");
strSql.Append(" where ROLEID=:ROLEID ");
OracleParameter[] parameters =
{
new OracleParameter(":ROLEID", OracleType.Number, 4),
new OracleParameter(":ROLENAME", OracleType.VarChar, 50),
new OracleParameter(":ROLEINFO", OracleType.VarChar, 20)
};
parameters[0].Value = entity.ROLEID;
parameters[1].Value = entity.ROLENAME;
parameters[2].Value = entity.ROLEINFO;
int rows = OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_ROLE GetEntity(decimal ROLEID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ROLEID, ROLENAME, ROLEINFO ");
strSql.Append(" from BASE_ROLE ");
strSql.Append(" where ROLEID=:ROLEID ");
OracleParameter[] parameters =
{
new OracleParameter(":ROLEID", OracleType.Number, 4)
};
parameters[0].Value = ROLEID;
Entity.BASE_ROLE entity = new Entity.BASE_ROLE();
DataTable dt = OracleHelper.Query(CommandType.Text, strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["ROLEID"].ToString() != "")
{
entity.ROLEID = decimal.Parse(dt.Rows[0]["ROLEID"].ToString());
}
entity.ROLENAME = dt.Rows[0]["ROLENAME"].ToString();
entity.ROLEINFO = dt.Rows[0]["ROLEINFO"].ToString();
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 获得角色实体数据
/// </summary>
/// <returns></returns>
private Entity.BASE_ROLE GetEntity()
{
Entity.BASE_ROLE model = new Entity.BASE_ROLE();
model.ROLEID = Convert.ToDecimal(this.hidPrimary.Value); //id ，主键
model.ROLENAME = this.TxtRoleName.Text; //角色名称
model.ROLEINFO = this.txtdesc.Text; //角色描述
return(model);
}
/// <summary>
/// 添加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public override void BtnAdd_Click(object sender, EventArgs e)
{
//获取实体
Entity.BASE_ROLE model = GetEntity();
//添加数据
bll.Add(model);
//重新加载当前页
Response.Redirect(Request.Url.AbsoluteUri + "#tabs-2", true);
}
/// <summary>
/// 增加角色
/// </summary>
/// <param name="model">角色实体类</param>
/// <returns></returns>
public int CreateRole(Entity.BASE_ROLE model)
{
if (!RoleExists(model.RoleName, model.RoleGroupID))
{
return(dal.CreateRole(model));
}
else
{
return(2);
}
}
//修改
public override void BtnUpdate_Click(object sender, EventArgs e)
{
//获取实体
Entity.BASE_ROLE model = GetEntity();
//修改数据
if (bll.update(model))
{
//重新加载当前页
Response.Redirect("Role.aspx#tabs-2");
}
else
{
Response.Write("<script type='text/javascript'>alert('请检查数据是否填写完整！');</script>");
}
}
/// <summary>
/// 更新数据
/// </summary>
protected void RolesLists_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Entity.BASE_ROLE model = new Entity.BASE_ROLE();
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);
model.RoleOrder = int.Parse(((TextBox)RolesLists.Rows[e.RowIndex].FindControl("txt_order")).Text);
if (!bll.UpdateRole(model))
{
strinfo.InnerHtml = Smart.Utility.JScript.errinfo("记录更新失败!");
strinfo.Visible = true;
}
//返回浏览狀態
RolesLists.EditIndex = -1;
BindOrder();
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Entity.BASE_ROLE GetEntity(int RoleID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select RoleID, RoleGroupID, RoleName, RoleDescription, RoleOrder ");
strSql.Append(" from Base_Role ");
strSql.Append(" where RoleID=@RoleID");
SqlParameter[] parameters =
{
new SqlParameter("@RoleID", SqlDbType.Int, 4)
};
parameters[0].Value = RoleID;
Entity.BASE_ROLE entity = new Entity.BASE_ROLE();
DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["RoleID"].ToString() != "")
{
entity.RoleID = int.Parse(ds.Tables[0].Rows[0]["RoleID"].ToString());
}
if (ds.Tables[0].Rows[0]["RoleGroupID"].ToString() != "")
{
entity.RoleGroupID = int.Parse(ds.Tables[0].Rows[0]["RoleGroupID"].ToString());
}
entity.RoleName = ds.Tables[0].Rows[0]["RoleName"].ToString();
entity.RoleDescription = ds.Tables[0].Rows[0]["RoleDescription"].ToString();
if (ds.Tables[0].Rows[0]["RoleOrder"].ToString() != "")
{
entity.RoleOrder = int.Parse(ds.Tables[0].Rows[0]["RoleOrder"].ToString());
}
return(entity);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Entity.BASE_ROLE entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BASE_ROLE(");
strSql.Append("ROLEID,ROLENAME,ROLEINFO");
strSql.Append(") values (");
strSql.Append(":ROLEID,:ROLENAME,:ROLEINFO");
strSql.Append(") ");
OracleParameter[] parameters =
{
new OracleParameter(":ROLEID", OracleType.Number, 4),
new OracleParameter(":ROLENAME", OracleType.VarChar, 50),
new OracleParameter(":ROLEINFO", OracleType.VarChar, 20)
};
parameters[0].Value = entity.ROLEID;
parameters[1].Value = entity.ROLENAME;
parameters[2].Value = entity.ROLEINFO;
OracleHelper.ExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 添加数据
/// </summary>
protected void btn_add_Click(object sender, EventArgs e)
{
if (txt_Name.Text.Trim() != "")
{
if (GroupList.SelectedValue != "all")
{
Entity.BASE_ROLE model = new Entity.BASE_ROLE();
model.RoleName = txt_Name.Text.Trim();
model.RoleDescription = txt_Description.Text.Trim();
model.RoleGroupID = int.Parse(GroupList.SelectedValue.ToString());
model.RoleOrder = int.Parse(txt_order.Text.Trim());
switch (bll.CreateRole(model))
{
case 1:
txt_Name.Text = "";
txt_Description.Text = "";
BindOrder();
break;
case 2:
strinfo.InnerHtml = Smart.Utility.JScript.errinfo("分组已经存在，请更换后重试!");
strinfo.Visible = true;
break;
default:
strinfo.InnerHtml = Smart.Utility.JScript.errinfo("新增操作失败!");
strinfo.Visible = true;
break;
}
}
else
{
strinfo.InnerHtml = Smart.Utility.JScript.errinfo("请选择角色分组!");
strinfo.Visible = true;
}
}
}
/// <summary>
/// 更新角色
/// </summary>
/// <param name="model">角色实体类</param>
/// <returns></returns>
public bool UpdateRole(Entity.BASE_ROLE model)
{
return(dal.UpdateRole(model));
}
/// <summary>
/// 添加角色
/// </summary>
/// <param name="model"></param>
public void Add(Entity.BASE_ROLE model)
{
roleDal.Add(model);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
private void SetEntity(Entity.BASE_ROLE model)
{
this.TxtRoleName.Text = model.ROLENAME;
this.txtdesc.Text = model.ROLEINFO;
}
/// <summary>
/// 修改角色信息
/// </summary>
/// <param name="model">角色实体数据</param>
/// <returns></returns>
public bool update(Entity.BASE_ROLE model)
{
return(roleDal.Update(model));
}
