public IHttpActionResult UpdateRole(RoleTab model)
{
try
{
if (model != null)
{
var effectRow = Db.Context(APP.DB_DEFAULT_CONN_NAME).Update("RoleTab").
Column("rolename", model.rolename).
Column("isclosed", model.isclosed).
Column("roledescription", model.roledescription).Where("roleId", model.roleId).Execute();
if (effectRow > 0)
{
return(Success("操作成功!"));
}
else
{
return(Error("操作失败!"));
}
}
else
{
return(Error("未能查询到角色!"));
}
}
catch (Exception e)
{
return(Exception(e.Message));
}
}
/// <summary>
/// 修改角色
/// </summary>
/// <param name="roleTab"></param>
/// <returns></returns>
public bool UPdateRoleInfo(RoleTab roleTab)
{
bool flag = false;
SqlParameter[] para = new SqlParameter[] { new SqlParameter("@RoleId", SqlDbType.NVarChar, 20),
new SqlParameter("@RoleName", SqlDbType.NVarChar, 50),
new SqlParameter("@Remark", SqlDbType.NVarChar, 200) };
para[0].Value = roleTab.ManageTypeID;
para[1].Value = roleTab.ManageTypeName;
para[2].Value = roleTab.Remark;
flag = DbHelperSQL.RunProcLob("Pro_UpdateRoleInfo", para);
return(flag);
}
/// <summary>
/// 添加角色
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public bool AddRole(RoleTab role)
{
bool flag = false;
SqlParameter[] para = { new SqlParameter("@RName", SqlDbType.NVarChar, 100),
new SqlParameter("@RDoc", SqlDbType.NVarChar, 200),
new SqlParameter("@RDate", SqlDbType.SmallDateTime, 50),
new SqlParameter("@RoleID", SqlDbType.NVarChar, 50),
new SqlParameter("IsCheck", SqlDbType.Int, 4) };
para[0].Value = role.ManageTypeName;
para[1].Value = role.Remark;
para[2].Value = role.RDate;
para[3].Value = role.ManageTypeID;
para[4].Value = role.IsCheck;
flag = DbHelperSQL.RunProcLob("Pro_AddRole", para);
return(flag);
}
/// <summary>
/// 修改角色信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button2_Click(object sender, EventArgs e)
{
RoleTab roleTab = new RoleTab();
roleTab.ManageTypeName = this.txtRoleName.Text.ToString().Trim();
roleTab.Remark = this.txtRemark.Text.ToString().Trim();
roleTab.ManageTypeID = this.txtRoleID.Text.ToString().Trim();
if (roleTabBLL.UPdateRoleInfo(roleTab))
{
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>
/// 查询出所有角色
/// </summary>
/// <returns></returns>
public IList <RoleTab> SelectAllRoles()
{
RoleTab role = null;
IList <RoleTab> listRole = new List <RoleTab>();
SqlDataReader reader = DbHelperSQL.dataReader("Pro_SelectAllRoles", null);
while (reader.Read())
{
role = new RoleTab();
role.ManageTypeID = reader["ManageTypeID"].ToString();
role.ManageTypeName = reader["ManageTypeName"].ToString().Trim();
role.Remark = reader["Remark"].ToString().Trim();
role.RDate = Convert.ToDateTime(reader["RData"]);
role.IsCheck = Convert.ToInt32(reader["IsCheck"]);
listRole.Add(role);
}
reader.Close();
reader.Dispose();
return(listRole);
}
public IHttpActionResult CreateRole(RoleTab model)
{
try
{
if (model != null)
{
string roleId = Guid.NewGuid().ToString().ToLower();
model.roleId = roleId;
if (Db.Context(APP.DB_DEFAULT_CONN_NAME).Sql(string.Format(@"select top 1 * from roletab where rolecode ='{0}'", model.rolecode)).QuerySingle <dynamic>() == null)
{
var effectRow = Db.Context(APP.DB_DEFAULT_CONN_NAME).Insert("RoleTab").
Column("roleId", model.roleId).
Column("rolename", model.rolename).
Column("rolecode", model.rolecode).
Column("isclosed", model.isclosed).
Column("roledescription", model.roledescription).Execute();
if (effectRow > 0)
{
return(Success("success", model));
}
else
{
return(Error("新增角色失败!"));
}
}
else
{
return(Error("当前角色名已经存在!"));
}
}
else
{
return(Error("未能查询到角色!"));
}
}
catch (Exception e)
{
return(Exception(e.Message));
}
}
/// <summary>
/// 根据角色ID得到角色信息
/// </summary>
/// <param name="roleId"></param>
/// <returns></returns>
public RoleTab GetRoleById(string roleId)
{
RoleTab role = null;
SqlParameter[] para = new SqlParameter[] { new SqlParameter("@RoleID", roleId) };
para[0].Value = roleId;
SqlDataReader reader = DbHelperSQL.RunProcedure("Pro_GetRoleByID", para);
if (reader.Read())
{
role = new RoleTab();
role.ManageTypeID = reader["ManageTypeID"].ToString();
role.ManageTypeName = reader["ManageTypeName"].ToString().Trim();
role.Remark = reader["Remark"].ToString().Trim();
role.RDate = Convert.ToDateTime(reader["RData"]);
role.IsCheck = Convert.ToInt32(reader["IsCheck"]);
}
reader.Close();
reader.Dispose();
return(role);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString.Count > 0)
{
if (Request.QueryString["RoleID"].ToString().Trim() != null)
{
string roleId = Request.QueryString["RoleID"].ToString().Trim();
RoleTab roleTab = new RoleTab();
roleTab = roleTabBLL.GetRoleById(roleId);
if (roleTab != null)
{
this.txtRoleID.Text = roleTab.ManageTypeID.ToString();
this.txtRoleName.Text = roleTab.ManageTypeName.ToString();
this.txtRemark.Text = roleTab.Remark.ToString();
this.txtRoleID.ReadOnly = true;
this.Button1.Enabled = false;
}
}
}
}
}
/// <summary>
/// 添加角色
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
RoleTab role = new RoleTab();
if (this.txtRoleName.Text.ToString().Trim() == null || this.txtRoleName.Text.ToString().Trim() == "")
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('请输入角色名称！');location.href='AddRole.aspx'", true);
return;
}
try
{
int id = Convert.ToInt32(this.txtRoleID.Text.ToString().Trim());
}
catch (Exception a)
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('角色ID请输入数字类型！');location.href='AddRole.aspx'", true);
return;
}
role.ManageTypeName = this.txtRoleName.Text.ToString().Trim();
role.Remark = this.txtRemark.Text.ToString().Trim();
role.RDate = DateTime.Now;
role.ManageTypeID = this.txtRoleID.Text.ToString().Trim();
role.IsCheck = 0;
if (IsExist(role.ManageTypeID, role.ManageTypeName))
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('角色名称或角色ID已存在！');location.href='AddRole.aspx'", true);
return;
}
if (roleTabBLL.AddRole(role))
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加角色成功！');location.href='ShowRoleList.aspx'", true);
}
else
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加角色失败！');location.href='AddRole.aspx'", true);
}
}
/// <summary>
/// 修改角色信息
/// </summary>
/// <param name="roleTab"></param>
/// <returns></returns>
public bool UPdateRoleInfo(RoleTab roleTab)
{
return(roleDal.UPdateRoleInfo(roleTab));
}
/// <summary>
/// 添加角色
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public bool AddRole(RoleTab role)
{
return(roleDal.AddRole(role));
}
