/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.Sys_RoleInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Sys_RoleInfo(");
strSql.Append("RoleName,RoleDesc,WriteRight,AddTime,AddUser)");
strSql.Append(" values (");
strSql.Append("@RoleName,@RoleDesc,@WriteRight,@AddTime,@AddUser)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@RoleName", SqlDbType.NVarChar, 50),
new SqlParameter("@RoleDesc", SqlDbType.NVarChar, 200),
new SqlParameter("@WriteRight", SqlDbType.NVarChar, 250),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@AddUser", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.RoleName;
parameters[1].Value = model.RoleDesc;
parameters[2].Value = model.WriteRight;
parameters[3].Value = model.AddTime;
parameters[4].Value = model.AddUser;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strWhere = " RoleName='" + txtRoleName.Text + "'";
string adduser = Session["uLoginName"].ToString();
int roleId = 0;
DataSet ds = bll_ri.GetRoleList(strWhere, roleId);
if (ds.Tables[0].Rows.Count > 0)
{
lblMsg.InnerHtml = "<script type='text/javascript'>alert('该角色名称已经存在!');</script>";
}
else
{
Model.Sys_RoleInfo model_ri = new Model.Sys_RoleInfo();
model_ri.RoleName = txtRoleName.Text;
model_ri.RoleDesc = getCheckBoxListValue();
model_ri.WriteRight = "1";
model_ri.AddTime = DateTime.Now;
model_ri.AddUser = adduser;
if (bll_ri.AddNewRole(model_ri) > 0)
{
lblMsg.InnerHtml = "<script type='text/javascript'>alert('添加成功!');window.location='Manage_Role.aspx'</script>";
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Sys_RoleInfo DataRowToModel(DataRow row)
{
Model.Sys_RoleInfo model = new Model.Sys_RoleInfo();
if (row != null)
{
if (row["RoleID"] != null && row["RoleID"].ToString() != "")
{
model.RoleID = int.Parse(row["RoleID"].ToString());
}
if (row["RoleName"] != null)
{
model.RoleName = row["RoleName"].ToString();
}
if (row["RoleDesc"] != null)
{
model.RoleDesc = row["RoleDesc"].ToString();
}
if (row["WriteRight"] != null)
{
model.WriteRight = row["WriteRight"].ToString();
}
if (row["AddTime"] != null && row["AddTime"].ToString() != "")
{
model.AddTime = DateTime.Parse(row["AddTime"].ToString());
}
if (row["AddUser"] != null)
{
model.AddUser = row["AddUser"].ToString();
}
}
return(model);
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strWhere = " RoleName='" + txtRoleName.Text + "'";
string adduser = Session["uLoginName"].ToString();
int rid = 0;
DataSet ds = bll_ri.GetRoleList(strWhere, rid);
if (ds.Tables[0].Rows.Count > 0)
{
Model.Sys_RoleInfo model_ri = new Model.Sys_RoleInfo();
model_ri.RoleID = int.Parse(Request.QueryString["RoleID"].ToString());
model_ri.RoleName = txtRoleName.Text;
model_ri.RoleDesc = getCheckBoxListValue();
if (bll_ri.EditRole(model_ri) > 0)
{
lblMsg.InnerHtml = "<script type='text/javascript'>alert('修改成功!');window.location='RoleList.aspx'</script>";
}
else
{
lblMsg.InnerHtml = "<script type='text/javascript'>alert('修改失败!');</script>";
}
}
else
{
lblMsg.InnerHtml = "<script type='text/javascript'>alert('该角色名称不存在!');</script>";
}
}
/// <summary>
/// 编辑角色
/// </summary>
public int EditRole(Model.Sys_RoleInfo model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RoleName", SqlDbType.NVarChar, 50),
new SqlParameter("@RoleDesc", SqlDbType.NVarChar, 200),
new SqlParameter("@RoleID", SqlDbType.Int, 4)
};
parameters[0].Value = model.RoleName;
parameters[1].Value = model.RoleDesc;
parameters[2].Value = model.RoleID;
int result = 0;
return(DbHelperSQL.RunProcedure("EditRole", parameters, out result));
}
/// <summary>
/// 新增角色
/// </summary>
public int AddNewRole(Model.Sys_RoleInfo model)
{
SqlParameter[] parameters =
{
new SqlParameter("@RoleName", SqlDbType.NVarChar, 50),
new SqlParameter("@RoleDesc", SqlDbType.NVarChar, 200),
new SqlParameter("@WriteRight", SqlDbType.NVarChar, 250),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@AddUser", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.RoleName;
parameters[1].Value = model.RoleDesc;
parameters[2].Value = model.WriteRight;
parameters[3].Value = model.AddTime;
parameters[4].Value = model.AddUser;
int result = 0;
return(DbHelperSQL.RunProcedure("AddNewRole", parameters, out result));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.Sys_RoleInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Sys_RoleInfo set ");
strSql.Append("RoleName=@RoleName,");
strSql.Append("RoleDesc=@RoleDesc,");
strSql.Append("WriteRight=@WriteRight,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("AddUser=@AddUser");
strSql.Append(" where RoleID=@RoleID");
SqlParameter[] parameters =
{
new SqlParameter("@RoleName", SqlDbType.NVarChar, 50),
new SqlParameter("@RoleDesc", SqlDbType.NVarChar, 200),
new SqlParameter("@WriteRight", SqlDbType.NVarChar, 250),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@AddUser", SqlDbType.NVarChar, 50),
new SqlParameter("@RoleID", SqlDbType.Int, 4)
};
parameters[0].Value = model.RoleName;
parameters[1].Value = model.RoleDesc;
parameters[2].Value = model.WriteRight;
parameters[3].Value = model.AddTime;
parameters[4].Value = model.AddUser;
parameters[5].Value = model.RoleID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 初始该角色的小类菜单
/// </summary>
private void DataBindRole()
{
if (Request.QueryString["RoleID"].ToString() == null || !Common.PositiveInt.IsPositiveInt(Request.QueryString["RoleID"].ToString()))
{
return;
}
int roleID = int.Parse(Request.QueryString["RoleID"]);
Model.Sys_RoleInfo model_ri = new Model.Sys_RoleInfo();
model_ri = bll_ri.GetModel(roleID);
if (model_ri == null)
{
return;
}
this.txtRoleName.Text = model_ri.RoleName;
int rid = -1;
string strWhere = " RoleID=" + roleID + "";
BLL.Sys_RoleMenuMappingBLL bll_rmm = new BLL.Sys_RoleMenuMappingBLL();
DataSet ds = bll_rmm.GetRoleList(strWhere, rid);
if (ds.Tables[0].Rows.Count > 0)
{
//初始化CheckBoxList选中项
foreach (RepeaterItem DataItem in rpt_RoleList.Items)
{
foreach (ListItem item in ((CheckBoxList)DataItem.FindControl("cbList")).Items)
{
DataRow[] dr = ds.Tables[0].Select("MenuID=" + item.Value + "");
if (dr.Length > 0)
{
item.Selected = true;
}
}
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Sys_RoleInfo GetModel(int RoleID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RoleID,RoleName,RoleDesc,WriteRight,AddTime,AddUser from Sys_RoleInfo ");
strSql.Append(" where RoleID=@RoleID");
SqlParameter[] parameters =
{
new SqlParameter("@RoleID", SqlDbType.Int, 4)
};
parameters[0].Value = RoleID;
Model.Sys_RoleInfo model = new Model.Sys_RoleInfo();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
