private void LegalPowerEditForm_Load(object sender, EventArgs e)
{
this.bindingSourceRole.DataSource = this.roleManager.Select();
Model.Role r = this.bindingSourceRole.Current as Model.Role;
if (r != null)
{
this.checkEditIsCOCount.Checked = r.IsCOCount == null ? false : r.IsCOCount.Value;
this.checkEditIsCOPrice.Checked = r.IsCOPrice == null ? false : r.IsCOPrice.Value;
this.checkEditIsXOPrice.Checked = r.IsXOPrice == null ? false : r.IsXOPrice.Value;
this.checkEditIsXOQuantity.Checked = r.IsXOQuantity == null ? false : r.IsXOQuantity.Value;
this.checkEditIsStockCount.Checked = r.IsStockCount == null ? false : r.IsStockCount.Value;
this.checkEditIsProductCost.Checked = r.IsProductCost == null ? false : r.IsProductCost.Value;
this.checkEditIsEmployeeBasicInfo.Checked = r.IsEmployeeBasicInfo == null ? false : r.IsEmployeeBasicInfo.Value;
this.checkEditIsSalaryViewCalc.Checked = r.IsSalaryViewCalc == null ? false : r.IsSalaryViewCalc.Value;
this.checkEditIsCOJiaoYiMingXi.Checked = r.IsCOJiaoYiMingXi.HasValue ? r.IsCOJiaoYiMingXi.Value : false;
this.checkEditIsCOFaPiaoZiLiao.Checked = r.IsCOFaPiaoZiLiao.HasValue ? r.IsCOFaPiaoZiLiao.Value : false;
this.checkEditIsCOZhangKuanZiLiao.Checked = r.IsCOZhangKuanZiLiao.HasValue ? r.IsCOZhangKuanZiLiao.Value : false;
this.checkEditIsCOXiangGuanZiLiao.Checked = r.IsCOXiangGuanZiLiao.HasValue ? r.IsCOXiangGuanZiLiao.Value : false;
this.checkEditIsCOJinHuoJinE.Checked = r.IsCOJinHuoJinE.HasValue ? r.IsCOJinHuoJinE.Value : false;
this.checkEditIsXOJiaoYiMingXi.Checked = r.IsXOJiaoYiMingXi.HasValue ? r.IsXOJiaoYiMingXi.Value : false;
this.checkEditIsXOFaPiaoZiLiao.Checked = r.IsXOFaPiaoZiLiao.HasValue ? r.IsXOFaPiaoZiLiao.Value : false;
this.checkEditIsXOZhangKuanZiLiao.Checked = r.IsXOZhangKuanZiLiao.HasValue ? r.IsXOZhangKuanZiLiao.Value : false;
this.checkEditIsXOXiangGuanZiLiao.Checked = r.IsXOXiangGuanZiLiao.HasValue ? r.IsXOXiangGuanZiLiao.Value : false;
this.checkEditIsXOJinHuoJinE.Checked = r.IsXOJinHuoJinE.HasValue ? r.IsXOJinHuoJinE.Value : false;
}
treeLoad2();
}
private void bindingSourceRole_CurrentChanged(object sender, EventArgs e)
{
_roleid = (this.bindingSourceRole.Current as Model.Role).RoleId;
if (treeList2.Selection[0] != null)
{
ds = this.roleOperationManager.SelectByType(treeList2.Selection[0].Tag.ToString(), _roleid);
this.bindingSourceGrid.DataSource = ds.Tables[0];
}
Model.Role r = this.bindingSourceRole.Current as Model.Role;
if (r != null)
{
this.checkEditIsCOCount.Checked = r.IsCOCount == null ? false : r.IsCOCount.Value;
this.checkEditIsCOPrice.Checked = r.IsCOPrice == null ? false : r.IsCOPrice.Value;
this.checkEditIsXOPrice.Checked = r.IsXOPrice == null ? false : r.IsXOPrice.Value;
this.checkEditIsXOQuantity.Checked = r.IsXOQuantity == null ? false : r.IsXOQuantity.Value;
this.checkEditIsStockCount.Checked = r.IsStockCount == null ? false : r.IsStockCount.Value;
this.checkEditIsProductCost.Checked = r.IsProductCost == null ? false : r.IsProductCost.Value;
this.checkEditIsEmployeeBasicInfo.Checked = r.IsEmployeeBasicInfo == null ? false : r.IsEmployeeBasicInfo.Value;
this.checkEditIsSalaryViewCalc.Checked = r.IsSalaryViewCalc == null ? false : r.IsSalaryViewCalc.Value;
this.checkEditIsCOJiaoYiMingXi.Checked = r.IsCOJiaoYiMingXi.HasValue ? r.IsCOJiaoYiMingXi.Value : false;
this.checkEditIsCOFaPiaoZiLiao.Checked = r.IsCOFaPiaoZiLiao.HasValue ? r.IsCOFaPiaoZiLiao.Value : false;
this.checkEditIsCOZhangKuanZiLiao.Checked = r.IsCOZhangKuanZiLiao.HasValue ? r.IsCOZhangKuanZiLiao.Value : false;
this.checkEditIsCOXiangGuanZiLiao.Checked = r.IsCOXiangGuanZiLiao.HasValue ? r.IsCOXiangGuanZiLiao.Value : false;
this.checkEditIsCOJinHuoJinE.Checked = r.IsCOJinHuoJinE.HasValue ? r.IsCOJinHuoJinE.Value : false;
this.checkEditIsXOJiaoYiMingXi.Checked = r.IsXOJiaoYiMingXi.HasValue ? r.IsXOJiaoYiMingXi.Value : false;
this.checkEditIsXOFaPiaoZiLiao.Checked = r.IsXOFaPiaoZiLiao.HasValue ? r.IsXOFaPiaoZiLiao.Value : false;
this.checkEditIsXOZhangKuanZiLiao.Checked = r.IsXOZhangKuanZiLiao.HasValue ? r.IsXOZhangKuanZiLiao.Value : false;
this.checkEditIsXOXiangGuanZiLiao.Checked = r.IsXOXiangGuanZiLiao.HasValue ? r.IsXOXiangGuanZiLiao.Value : false;
this.checkEditIsXOJinHuoJinE.Checked = r.IsXOJinHuoJinE.HasValue ? r.IsXOJinHuoJinE.Value : false;
}
}
public static void UpdateRoleClaims(this model.Role dbRole, Model.Role role)
{
var securityClaimIds = role.SecurityClaims.Select(o => o.SecurityClaimId).ToArray();
var remove = (from c in dbRole.SecurityClaims
where !securityClaimIds.Contains(c.SecurityClaimId)
select c).ToList();
remove.ForEach(o => dbRole.SecurityClaims.Remove(o));
var add = (from c in role.SecurityClaims
where !dbRole.SecurityClaims.Any(o => o.SecurityClaimId == c.SecurityClaimId)
select c).ToList();
add.ForEach(o =>
{
dbRole.SecurityClaims.Add(new model.RoleSecurityClaim()
{
SecurityClaimId = o.SecurityClaimId,
Value = o.Value
});
});
var update = role.SecurityClaims.Except(add).ToList();
update.ForEach(claim =>
{
var match = dbRole.SecurityClaims.Single(o => o.SecurityClaimId == claim.SecurityClaimId);
match.Value = claim.Value;
});
}
public Guid Create(Model.Role station)
{
Domain.Role domainRole = this.mapper.Map <Domain.Role>(station);
roleRepository.Create(domainRole);
roleRepository.SaveChanges();
return(domainRole.Id);
}
/// <summary>
/// 修改角色
/// </summary>
public bool EditRole(Model.Role role)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbRole set ");
strSql.Append("RoleName=@RoleName,Description=@Description,ModifyDate=@ModifyDate");
strSql.Append(" where Id=@Id");
SqlParameter[] paras =
{
new SqlParameter("@RoleName", role.RoleName),
new SqlParameter("@Description", role.Description),
new SqlParameter("@ModifyDate", DateTime.Now), //修改时间就是当前时间
new SqlParameter("@Id", role.Id)
};
object obj = DriveMgr.Common.SqlHelper.ExecuteNonQuery(DriveMgr.Common.SqlHelper.connStr, CommandType.Text, strSql.ToString(), paras);
if (Convert.ToInt32(obj) > 0)
{
return(true);
}
else
{
return(false);
}
}
public async Task <ActionResult <Model.Role> > Update(int id, Model.Role role)
{
if (id != role.Id)
{
return(BadRequest());
}
try
{
var input = _mapper.Map <AuthoAPI.Models.Role>(role);
_context.Entry(input).State = EntityState.Modified;
var result = await _context.Role.FindAsync(id);
await _context.SaveChangesAsync();
return(_mapper.Map <Model.Role>(result));
}
catch (DbUpdateConcurrencyException)
{
if (!RoleExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
}
public bool RoleExists(string currentUser, Model.Role role, out int errorNumber, out string errorDescription)
{
errorDescription = null;
errorNumber = 0;
base.ExecuteNonQuery(CommandType.StoredProcedure, "Framework_RoleExists",
true, _currentUser,
base.Parameters.Create("@ReturnValue", DbType.Int32, ParameterDirection.ReturnValue, null),
base.Parameters.Create("@ApplicationName", DbType.String, _applicationName),
base.Parameters.Create("@RoleName", DbType.String, role.RoleName)
);
errorNumber = base.ExecutionStatus.ErrorNumber;
errorDescription = base.ExecutionStatus.ErrorDescription;
int result = Convert.ToInt32(base.ExecutionStatus.Command.Parameters["@ReturnValue"].Value);
if (result == 0)
{
return(false);
}
else
{
return(true);
}
}
public bool ExistsExcept(Model.Role e)
{
Hashtable paras = new Hashtable();
paras.Add("newId", e.Id);
paras.Add("oldId", Get(e.RoleId).Id);
return(sqlmapper.QueryForObject <bool>("Role.existsexcept", paras));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Model.Role role = BLL.Role.GetRole(Request.QueryString["roleID"]);
role.RoleName = txt_roleName.Text.Trim();
role.Remark = txt_remark.Text.Trim();
BLL.Role.Update(role);
Message.Alert(this, "操作成功", "null");
}
/// <summary>
/// 修改角色
/// </summary>
public bool EditRole(Model.Role role, string originalRoleName)
{
if (role.RoleName != originalRoleName && dal.GetRoleByRoleName(role.RoleName) != null)
{
throw new Exception("已经存在此角色！");
}
return(dal.EditRole(role));
}
private bool CheckIsExist(Model.Role role)
{
//if (role.Id > 0)
//{
// if (this.roleService.GetRole(role.Id).Name == role.Name) return false;
//}
return(this.roleService.CheckIsExist(role));
}
public ActionResult Add(Model.Role role)
{
role.DelFlag = (short)Model.Enum.DelFlagEnum.Normal;
role.SubBy = 0;// this.LoginUserInso.Id;
role.SubTime = DateTime.Now;
roleService.Add(role);
roleService.Savechanges();
return(Content("ok"));
}
/// <summary>
/// 添加角色
/// </summary>
public int AddRole(Model.Role role)
{
DriveMgr.Model.Role roleCompare = dal.GetRoleByRoleName(role.RoleName);
if (roleCompare != null)
{
throw new Exception("已经存在此角色！");
}
return(dal.AddRole(role));
}
public Boolean AddUsers(int roleId, int[] userIds)
{
Model.Role role = GetRoleById(roleId);
foreach (int userId in userIds)
{
role.AddUser(userId);
}
return(true);
}
public ActionResult Update(Model.Role mr)
{
bool issuccess = BLL.CommonBLL.Update <Model.Role>(mr);
var ret = new
{
messagecode = issuccess ? 1 : 0,
};
return(Json(ret, JsonRequestBehavior.AllowGet));
}
protected override void MovePrev()
{
Model.Role role = this.roleManager.GetPrev(this.role);
if (role == null)
{
throw new InvalidOperationException(Properties.Resources.ErrorNoMoreRows);
}
this.role = role;
}
void Validate(Model.Role role)
{
// if (string.IsNullOrEmpty(role.Id))
// throw new Helper.RequireValueException(Model.Role.PROPERTY_ID);
if (string.IsNullOrEmpty(role.RoleName))
{
throw new Helper.RequireValueException(Model.Role.PRO_RoleName);
}
}
public static RoleViewModel ToViewModel(this Model.Role rolePOCO)
{
var roleViewModel = new RoleViewModel();
return(new RoleViewModel()
{
roleID = rolePOCO.roleID,
roleName = rolePOCO.roleName,
});
}
private void DatagridSelectedview(object sender, DataGridViewCellEventArgs e)
{
if (dgDetails.Rows.Count > 0 && e.RowIndex >= 0)
{
oMRole = new Model.Role();
oMRole.ID = dgDetails.Rows[e.RowIndex].Cells[0].Value.ToString();
oMRole.ROLE = dgDetails.Rows[e.RowIndex].Cells[1].Value.ToString();
oMRole.STATUS = dgDetails.Rows[e.RowIndex].Cells[2].Value.ToString();
}
}
public bool AddUpdateRole(Model.Role role)
{
if (role != null && !string.IsNullOrEmpty(role.RoleName))
{
return(dal.AddUpdateRole(role));
}
else
{
return(false);
}
}
public int UptRole(Model.Role role)
{
try
{
string sql = $"update Role set RName='{role.RName}' where RId={role.RId}";
return(DapperHelper.Execute(sql));
}
catch (Exception)
{
throw;
}
}
private string HandleNprintingRole(Model.Role role)
{
RoleListResponse nPrintingRole = _rolesApi.RolesGet(role.Name);
//Role must exists NPrinting
if (nPrintingRole.Data.Items != null && nPrintingRole.Data.Items.Count > 0)
{
RoleResponseDataItem npRole = nPrintingRole.Data.Items[0];
return(npRole.Id.ToString());
}
return(null);
}
void load()
{
string roleID = Request.QueryString["roleID"];
Model.Role role = BLL.Role.GetRole(roleID);
if (role != null)
{
lbl_roleCode.Text = role.RoleID;
txt_remark.Text = role.Remark;
txt_roleName.Text = role.RoleName;
}
}
/// <summary>
/// Update a Role.
/// </summary>
public void Update(Model.Role role)
{
//
// todo: add other logic here.
//
Validate(role);
//if (this.ExistsExcept(role))
//{
// throw new Helper.InvalidValueException(Model.Role.PROPERTY_ID);
//}
role.UpdateTime = DateTime.Now;
accessor.Update(role);
}
/// <summary>
/// 该数据访问对象的属性值装载到数据库更新参数数组
/// </summary>
/// <remarks></remarks>
public IDbDataParameter[] ValueParas(Model.Role model)
{
SqlParameter[] paras = new SqlParameter[3];
paras[0] = new SqlParameter("@ID", model.ID);
paras[1] = new SqlParameter("@Name", model.Name == string.Empty ? DBNull.Value : (object)model.Name);
paras[2] = new SqlParameter("@Description", model.Description == string.Empty ? DBNull.Value : (object)model.Description);
paras[0].DbType = DbType.Int32;
paras[1].DbType = DbType.String;
paras[2].DbType = DbType.String;
return(paras);
}
public static bool Update(string strRoleId, string strRoleName, string strRoleRemark, int strRoleState, string strUpUsrId)
{
Model.Role roleModel = new Model.Role()
{
roleId = strRoleId,
roleName = strRoleName,
roleState = strRoleState,
roleRemark = strRoleRemark,
updt = DateTime.Now,
upUsrId = strUpUsrId
};
return(Repository.Role.Update(roleModel));
}
/// <summary>
/// Insert a Role.
/// </summary>
public void Insert(Model.Role role)
{
//
// todo:add other logic here
//
Validate(role);
if (this.Exists(role.Id))
{
throw new Helper.InvalidValueException(Model.Role.PRO_Id);
}
role.RoleId = Guid.NewGuid().ToString();
role.InsertTime = DateTime.Now;
accessor.Insert(role);
}
private void LoadPermission()
{
string roleID = Request.QueryString["RoleID"];
Model.Role role = BLL.Role.GetRole(roleID);
if (role != null)
{
hf_roleID.Value = role.RoleID;
lbl_roleName.Text = role.RoleName;
}
this.DataListSysModule.DataSource = GetSysModules();
this.DataBind();
RolePermissionLoad();
}
/// <summary>
/// 添加角色
/// </summary>
public int AddRole(Model.Role role)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbRole(RoleName,Description)");
strSql.Append(" values ");
strSql.Append("(@RoleName,@Description)");
strSql.Append(";SELECT @@IDENTITY"); //返回插入用户的主键
SqlParameter[] paras =
{
new SqlParameter("@RoleName", role.RoleName),
new SqlParameter("@Description", role.Description)
};
return(Convert.ToInt32(DriveMgr.Common.SqlHelper.ExecuteScalar(DriveMgr.Common.SqlHelper.connStr, CommandType.Text, strSql.ToString(), paras)));
}
public List <Model.Role> GetRoles(int PersonID)
{
List <Model.Role> roles = new List <Model.Role>();
DAL.Role dalrole = new Role();
string sql = "SELECT [PersonId],[RoleId] FROM [PersonRole] WHERE [PersonID]=" + PersonID;
DataTable dt = DbHelperSQL.Query(sql).Tables[0];
foreach (DataRow item in dt.Rows)
{
Model.Role role = dalrole.GetModel(Convert.ToInt32(item["RoleId"]));
roles.Add(role);
}
return(roles);
}
public override void CreateRole(string roleName)
{
Model.Role role=new Model.Role();
role.Name=roleName;
iRole.CreateRole(role);
}
