public void Save(UserRole objUserRole)
{
string sql = null;
List<DbParameter> parameterList = new List<DbParameter>();
if (objUserRole.PkId == 0)
{
sql = " insert into tbl_user_role(RoleName, DataFilter, RoleStatus) " +
" values(@RoleName, @DataFilter, @RoleStatus); " +
" select LAST_INSERT_ID(); ";
parameterList.Add(new MySqlParameter("@RoleName", objUserRole.RoleName));
parameterList.Add(new MySqlParameter("@DataFilter", objUserRole.DataFilter));
parameterList.Add(new MySqlParameter("@RoleStatus", objUserRole.RoleStatus));
objUserRole.PkId = DbHelper.ExecuteScalar(sql, CommandType.Text, parameterList.ToArray()).ToString().ToInt();
}
else
{
sql = " update tbl_user_role set RoleName=@RoleName, DataFilter=@DataFilter, RoleStatus=@RoleStatus where PkId=@PkId ";
parameterList.Add(new MySqlParameter("@RoleName", objUserRole.RoleName));
parameterList.Add(new MySqlParameter("@DataFilter", objUserRole.DataFilter));
parameterList.Add(new MySqlParameter("@RoleStatus", objUserRole.RoleStatus));
parameterList.Add(new MySqlParameter("@PkId", objUserRole.PkId));
DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray());
}
}
public void Save(UserRole objUserRole)
{
string sql = null;
List<DbParameter> parameterList = new List<DbParameter>();
if (objUserRole.PkId == 0)
{
sql = " insert into tbl_user_role(PkId, RoleName, DataFilter, RoleStatus) " +
" values(TUR_PKID.NEXTVAL, :RoleName, :DataFilter, :RoleStatus) " +
" RETURNING PkId INTO :PkId ";
parameterList.Add(new OracleParameter(":RoleName", objUserRole.RoleName));
parameterList.Add(new OracleParameter(":DataFilter", objUserRole.DataFilter));
parameterList.Add(new OracleParameter(":RoleStatus", objUserRole.RoleStatus));
var p = new OracleParameter(":PkId", OracleDbType.Int32, 0, ParameterDirection.Output);
parameterList.Add(p);
DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray());
objUserRole.PkId = Convert.ToInt32(((OracleDecimal)p.Value).Value);
}
else
{
sql = " update tbl_user_role set RoleName=:RoleName, DataFilter=:DataFilter, RoleStatus=:RoleStatus where PkId=:PkId ";
parameterList.Add(new OracleParameter(":RoleName", objUserRole.RoleName));
parameterList.Add(new OracleParameter(":DataFilter", objUserRole.DataFilter));
parameterList.Add(new OracleParameter(":RoleStatus", objUserRole.RoleStatus));
parameterList.Add(new OracleParameter(":PkId", objUserRole.PkId));
DbHelper.ExecuteNonQuery(sql, CommandType.Text, parameterList.ToArray());
}
}
public bool CheckExists(UserRole objUserRole)
{
string sql = null;
List<DbParameter> parameterList = new List<DbParameter>();
sql = " select count(*) from tbl_user_role where RoleName=@RoleName ";
parameterList.Add(new MySqlParameter("@RoleName", objUserRole.RoleName));
return int.Parse(DbHelper.ExecuteScalar(sql, CommandType.Text, parameterList.ToArray()).ToString()) > 0;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (this.IsValid)
{
IUserService service = ServiceFactory.GetService<IUserService>();
UserRole entity = null;
List<UserRolePermission> rolePermissionList = new List<UserRolePermission>();
if (this.IsInsert)
{
entity = new UserRole()
{
RoleName = this.txtRoleName.Text.Trim(),
DataFilter = this.ddlDataFilter.SelectedValue.ToByte(0),
RoleStatus = this.ddlRoleStatus.SelectedValue.ToByte(0)
};
if (service.CheckExists_Role(entity))
{
this.JscriptMsg("角色名称已存在", null, "Error");
return;
}
}
else
{
entity = service.GetObject_Role(this.PkId);
if (entity != null)
{
entity.DataFilter = this.ddlDataFilter.SelectedValue.ToByte(0);
entity.RoleStatus = this.ddlRoleStatus.SelectedValue.ToByte(0);
}
}
service.Save_Role(entity);
foreach (TreeNode tnOne in this.tvPermission.Nodes)
{
if (tnOne.Checked)
{
rolePermissionList.Add(new UserRolePermission() { RoleId = entity.PkId, PermCode = tnOne.Value });
}
foreach (TreeNode tnTwo in tnOne.ChildNodes)
{
if (tnTwo.Checked)
{
rolePermissionList.Add(new UserRolePermission() { RoleId = entity.PkId, PermCode = tnTwo.Value });
}
}
}
service.Delete_RolePermission(entity.PkId);
service.Save_RolePermission(rolePermissionList);
if (this.IsInsert && (sender as Button).CommandName == "SubmitContinue")
{
this.ReturnUrl = this.Request.Url.PathAndQuery;
}
this.JscriptMsg("数据保存成功", this.ReturnUrl, "Success");
}
UserConvert.ClearCache();
}
public bool CheckExists_Role(UserRole objUserRole)
{
var repository = ServiceFactory.GetService<IUserRoleRepository>();
return repository.CheckExists(objUserRole);
}
public void Save_Role(UserRole objUserRole)
{
var repository = ServiceFactory.GetService<IUserRoleRepository>();
repository.Save(objUserRole);
}