public string delete(SysRoleModel model)
{
var a = roleBLL.Delete(model.Id);
var jsondata = js.Serialize(new { flag = a });
return(jsondata);
}
public ActionResult Edit(string id)
{
ViewBag.Perm = GetPermission();
SysRoleModel entity = RoleBLL.GetById(id);
return(View(entity));
}
public List <SysRoleModel> GetRoleList(SysRoleModel model)
{
List <SysRoleModel> List = new List <SysRoleModel>();
string[] strPar = new string[] { "@RoleID", "@RoleName", "@DeleteFlag", "@OUTTotalCount" };
ParameterMapper mapper = new ParameterMapper(strPar);
var ObjectModel = db.CreateSprocAccessor <SysRoleModel>("PROC_T_SYS_GetRoleList", mapper, MapBuilder <SysRoleModel> .MapNoProperties()
.Map(p => p.RoleID).ToColumn("RoleID")
.Map(p => p.RoleName).ToColumn("RoleName")
.Map(p => p.RoleRemark).ToColumn("RoleRemark")
.Map(p => p.AllowEdit).ToColumn("AllowEdit")
.Map(p => p.AllowDelete).ToColumn("AllowDelete")
.Map(p => p.SortCode).ToColumn("SortCode")
.Map(p => p.DeleteFlag).ToColumn("DeleteFlag")
.Map(p => p.CreateDate).ToColumn("CreateDate")
.Map(p => p.CreatorID).ToColumn("CreatorID")
.Map(p => p.ModifyDate).ToColumn("ModifyDate")
.Map(p => p.ModifierID).ToColumn("ModifierID")
.Build()
);
object[] param = { model.RoleID, model.RoleName, model.DeleteFlag, model.OUTTotalCount };
List = ObjectModel.Execute(param).ToList <SysRoleModel>();
model.OUTTotalCount = int.Parse(mapper.GetParameterValue("@OUTTotalCount").ToString());
return(List);
}
public JsonResult Create(SysRoleModel model)
{
model.Id = ResultHelper.NewId;
model.CreateTime = ResultHelper.NowTime;
model.CreatePerson = GetUserId();
if (model != null && ModelState.IsValid)
{
if (RoleBLL.Create(ref errors, model))
{
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",Name" + model.Name, "成功", "创建", "SysRole");
return(Json(JsonHandler.CreateMessage(1, Suggestion.InsertSucceed)));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",Name" + model.Name + "," + ErrorCol, "失败", "创建", "SysRole");
return(Json(JsonHandler.CreateMessage(0, Suggestion.InsertFail + ErrorCol)));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Suggestion.InsertFail)));
}
}
public bool Create(ref ValidationErrors errors, SysRoleModel model)
{
try
{
SysRole entity = m_Rep.GetById(model.Id);
if (entity != null)
{
errors.Add(Suggestion.PrimaryRepeat);
return(false);
}
entity = new SysRole();
entity.Id = model.Id;
entity.Name = model.Name;
entity.Description = model.Description;
entity.CreateTime = model.CreateTime;
entity.CreatePerson = model.CreatePerson;
if (m_Rep.Create(entity) == 1)
{
//分配给角色
db.P_Sys_InsertSysRight();
//清理无用的项
db.P_Sys_ClearUnusedRightOperate();
return(true);
}
errors.Add(Suggestion.InsertFail);
return(false);
}
catch (Exception ex)
{
errors.Add(ex.Message);
ExceptionHandler.WriteException(ex);
return(false);
}
}
/// <summary>
/// 更新信息
/// </summary>
public int UpdateInfo(SqlTransaction trans, SysRoleModel sysModel, int SysRoleId)
{
string key = "Cache_SysRole_Model_" + SysRoleId;
CacheHelper.RemoveCache(key);
return(sysDAL.UpdateInfo(trans, sysModel, SysRoleId));
}
public ActionResult Details(int id)
{
ViewBag.Perm = GetPermission();
SysRoleModel model = roleBLL.GetEntityById(id);
return(View("Details", model));
}
public virtual bool Create(ref ValidationErrors errors, SysRoleModel model)
{
try
{
SysRole entity = m_Rep.GetById(model.Id);
if (entity != null)
{
errors.Add(Resource.PrimaryRepeat);
return false;
}
entity = new SysRole();
entity.Id = model.Id;
entity.Name = model.Name;
entity.Description = model.Description;
entity.CreateTime = model.CreateTime;
entity.CreatePerson = model.CreatePerson;
if (m_Rep.Create(entity))
{
return true;
}
else
{
errors.Add(Resource.Insert + Resource.Fail);
return false;
}
}
catch (Exception ex)
{
errors.Add(ex.Message);
ExceptionHander.WriteException(ex);
return false;
}
}
/// <summary>
/// 修改一个实体
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public bool Edit(SysRoleModel model)
{
try
{
SysRole entity = roleRepository.GetEntityById(model.Id);
if (entity == null)
{
return(false);
}
entity.RoleName = model.RoleName;
entity.Description = model.Description;
entity.IsDelete = model.IsDelete;
entity.Created = model.Created;
entity.Creator = model.Creator;
if (roleRepository.Edit(entity) == 1)//成功
{
return(true);
}
else
{
return(false);
}
}
catch (Exception)
{
return(false);
}
}
public ActionResult Edit(string id)
{
ViewBag.perm = GetPermission();
SysRoleModel model = roleBLL.GetById(id);
return(View(model));
}
public int AddSysUser(Model_SysUser Model_SysUser, SysRoleModel SysRoleModel, string sType)
{
List <string> sQLStringList = new List <string>();
string item = string.Empty;
if (sType == "1")
{
string str2 = string.Empty;
str2 = string.Format("insert into SysUser(SysUser_ID,SysUser_Name,SysUser_LoginName,SysUser_PassWord,SysUser_Tel,SysDepartment_ID,SysUser_Enable,SysUser_Remark,CreateTime,CreateUser) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}') ;", new object[] { Model_SysUser.SysUser_ID, Model_SysUser.SysUser_Name, Model_SysUser.SysUser_LoginName, Model_SysUser.SysUser_PassWord, Model_SysUser.SysUser_Tel, Model_SysUser.SysDepartment_ID, Model_SysUser.SysUser_Enable, Model_SysUser.SysUser_Remark, Model_SysUser.CreateTime, Model_SysUser.CreateUser });
sQLStringList.Add(str2);
}
else
{
string str3 = string.Empty;
string str4 = string.Empty;
string str5 = string.Empty;
str3 = string.Format("update SysUser set SysUser_Name='{0}',SysUser_LoginName='{1}',SysUser_PassWord='******',SysUser_Tel='{3}',SysUser_Enable='{4}',[UpdateTime]='{5}',[UpdateUser]='{6}' where sysUser_ID='{7}'", new object[] { Model_SysUser.SysUser_Name, Model_SysUser.SysUser_LoginName, Model_SysUser.SysUser_PassWord, Model_SysUser.SysUser_Tel, Model_SysUser.SysUser_Enable, Model_SysUser.UpdateTime, Model_SysUser.UpdateUser, Model_SysUser.SysUser_ID });
str5 = string.Format(" delete from SysUserRoleRelation where SysUser_ID='{0}'", Model_SysUser.SysUser_ID);
sQLStringList.Add(str3);
sQLStringList.Add(str4);
sQLStringList.Add(str5);
}
foreach (SysUserRoleRelationModel model in SysRoleModel.SysUserRoleList)
{
item = string.Format("insert into SysUserRoleRelation(SysUser_ID,SysRole_ID,CreateTime,CreateUser) values('{0}','{1}','{2}','{3}');", new object[] { model.SysUser_ID, model.SysRole_ID, model.CreateTime, model.CreateUser });
sQLStringList.Add(item);
}
return(DbHelperSQL.ExecuteSqlTran(sQLStringList));
}
public JsonResult Create(SysRoleModel model)
{
model.Id = ResultHelper.NewId;
model.CreateTime = ResultHelper.NowTime;
string userId = OpeCur.AccountNow.Id;
model.CreatePerson = userId;
if (model != null && ModelState.IsValid)
{
if (model.Name.IsNullOrEmpty() || model.Description.IsNullOrEmpty())
{
return(OpeCur.AjaxMsgNOOK("用户名和描述都不能为空！"));
}
OpeCur.ServiceSession.SysRole.Create(ref errors, model);
if (OpeCur.ServiceSession.SaveChange() > 0)
{
LogHandler.WriteServiceLog(userId, "Id" + model.Id + ",Name" + model.Name, "成功", "创建", "SysRole");
//return Json(JsonHandler.CreateMessage(1, Resource.InsertSucceed));
return(OpeCur.AjaxMsgOK(Resource.InsertSucceed));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(userId, "Id" + model.Id + ",Name" + model.Name + "," + ErrorCol, "失败", "创建", "SysRole");
//return Json(JsonHandler.CreateMessage(0, Resource.InsertFail + ErrorCol));
return(OpeCur.AjaxMsgOK(Resource.InsertFail + ErrorCol));
}
}
else
{
return(OpeCur.AjaxMsgNOOK(Resource.ModelStateValidFail));
}
}
public string EditModule(SysRoleModel model)
{
var a = moduleBLL.Edit(model);
var jsondata = js.Serialize(new { flag = a });
return(jsondata);
}
public virtual bool Create(SysRoleModel model)
{
try
{
tbl_SysRole entity = m_Rep.GetById(model.Id);
if (entity != null)
{
return(false);
}
entity = new tbl_SysRole();
entity.Id = model.Id;
entity.RoleId = model.RoleId;
entity.RoleName = model.RoleName;
entity.IsShow = model.IsShow;
if (m_Rep.Create(entity))
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
public ActionResult Edit(int?id)
{
ViewBag.Perm = GetPermission();
SysRoleModel model = roleBLL.GetEntityById(id ?? 0);
return(View("Edit", model));
}
public virtual bool Edit(ref ValidationErrors errors, SysRoleModel model)
{
try
{
SysRole entity = m_Rep.GetById(model.Id);
if (entity == null)
{
errors.Add(Resource.Disable);
return(false);
}
entity.Id = model.Id;
entity.Name = model.Name;
entity.Description = model.Description;
entity.CreateTime = model.CreateTime;
entity.CreatePerson = model.CreatePerson;
if (m_Rep.Edit(entity))
{
return(true);
}
else
{
errors.Add(Resource.NoDataChange);
return(false);
}
}
catch (Exception ex)
{
errors.Add(ex.Message);
ExceptionHander.WriteException(ex);
return(false);
}
}
public bool Edit(ref ValidationErrors errors, SysRoleModel model)
{
try
{
SysRole entity = SysRoleRep.GetById(model.Id);
if (entity == null)
{
errors.Add(Suggestion.Disable);
return(false);
}
entity.Id = model.Id;
entity.Name = model.Name;
entity.Description = model.Description;
entity.CreateTime = model.CreateTime;
entity.CreatePerson = model.CreatePerson;
if (SysRoleRep.Edit(entity) == 1)
{
return(true);
}
else
{
errors.Add(Suggestion.EditFail);
return(false);
}
}
catch (Exception ex)
{
errors.Add(ex.Message);
ExceptionHander.WriteException(ex);
return(false);
}
}
public bool ModifyRoleModel(string oldRoleName, UserRole role)
{
List <SysUserModel> userList = bllUser.GetModelListByRoleName(oldRoleName);
SysRoleModel roleModel = bllRole.GetModel(oldRoleName);
if (roleModel != null)
{
bllRole.Delete(oldRoleName);
}
roleModel = new SysRoleModel();
roleModel.SysRole_Name = role.RoleName;
roleModel.SysRole_Desc = role.RoleDesc;
roleModel.SysRole_Level = role.RoleLevel;
roleModel.SysRole_Remark = role.RoleRemark;
if (!(bllRole.Add(roleModel)))
{
return(false);
}
if (userList != null && userList.Count != 0)
{
for (int i = 0; i < userList.Count; i++)
{
userList[i].SysRole_Name = role.RoleName;
bllUser.Add(userList[i]);
}
}
return(true);
}
/// <summary>
/// 创建一个实体
/// </summary>
/// <param name="errors">持久的错误信息</param>
/// <param name="model">模型</param>
/// <returns>是否成功</returns>
public virtual bool Create(ref ValidationErrors errors, SysRoleModel model)
{
try
{
SysRole entity = m_Rep.GetById(model.Id);
if (entity != null)
{
errors.add(Suggestion.PrimaryRepeat);
return(false);
}
entity = new SysRole();
entity.Id = model.Id;
entity.Name = model.Name;
entity.Description = model.Description;
entity.CreateTime = model.CreateTime;
entity.CreatePerson = model.CreatePerson;
if (m_Rep.Create(entity))
{
return(true);
}
else
{
errors.add("插入失败");
return(false);
}
}
catch (Exception ex)
{
errors.add(ex.Message);
ExceptionHandler.WriteException(ex);
//ExceptionHander.WriteException(ex);
return(false);
}
}
public JsonResult Edit(SysRoleModel model)
{
if (roleBLL.Edit(model))
{
return(Json(new { type = 1 }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { type = 0 }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// 插入新纪录
/// 请勿删除
/// </summary>
/// <returns></returns>
public bool InsertData(SysRoleModel newModel)
{
string sql = @"INSERT INTO S_Role(RoleName) VALUES(@RoleName) ";
SqlParameter[] parmes =
{
new SqlParameter("@RoleName", newModel.RoleName)
};
DataBase dbase = new DataBase();
return(dbase.updateData(sql, parmes) > 0 ? true : false);
}
public bool UpData(SysRoleModel newModel)
{
string sql = @"UPDATE S_Role SET RoleName=@RoleName WHERE RowID=@RowID ";
SqlParameter[] parmes =
{
new SqlParameter("@RoleName", newModel.RoleName),
new SqlParameter("@RowID", newModel.RowID),
};
DataBase dbase = new DataBase();
return(dbase.updateData(sql, parmes) > 0 ? true : false);
}
/// <summary>
/// 获取一个实体
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public SysRoleModel GetEntityById(int id)
{
SysRole entity = roleRepository.GetEntityById(id);
SysRoleModel model = new SysRoleModel();
model.Id = entity.Id;
model.RoleName = entity.RoleName;
model.Description = entity.Description;
model.IsDelete = entity.IsDelete;
model.Created = entity.Created;
model.Creator = entity.Creator;
return(model);
}
/// <summary>
/// 校验Excel数据,这个方法一般用于重写校验逻辑
/// </summary>
public virtual bool CheckImportData(string fileName, List <SysRoleModel> list, ref ValidationErrors errors)
{
var targetFile = new FileInfo(fileName);
if (!targetFile.Exists)
{
errors.Add("导入的数据文件不存在");
return(false);
}
var excelFile = new ExcelQueryFactory(fileName);
//对应列头
excelFile.AddMapping <SysRoleModel>(x => x.Name, "Name");
excelFile.AddMapping <SysRoleModel>(x => x.Description, "Description");
excelFile.AddMapping <SysRoleModel>(x => x.CreateTime, "CreateTime");
excelFile.AddMapping <SysRoleModel>(x => x.CreatePerson, "CreatePerson");
//SheetName
var excelContent = excelFile.Worksheet <SysRoleModel>(0);
int rowIndex = 1;
//检查数据正确性
foreach (var row in excelContent)
{
var errorMessage = new StringBuilder();
var entity = new SysRoleModel();
entity.Id = row.Id;
entity.Name = row.Name;
entity.Description = row.Description;
entity.CreateTime = row.CreateTime;
entity.CreatePerson = row.CreatePerson;
//=============================================================================
if (errorMessage.Length > 0)
{
errors.Add(string.Format(
"第 {0} 列发现错误：{1}{2}",
rowIndex,
errorMessage,
"<br/>"));
}
list.Add(entity);
rowIndex += 1;
}
if (errors.Count > 0)
{
return(false);
}
return(true);
}
public List <SysRoleModel> GetRoleList()
{
var query = Dc.SYS_ROLE_INFO;
List <SysRoleModel> listRole = new List <SysRoleModel>();
foreach (SYS_ROLE_INFO sui in query)
{
SysRoleModel mRole = new SysRoleModel();
mRole.RoleId = sui.ROLE_ID;
mRole.RoleName = sui.ROLE_NAME;
listRole.Add(mRole);
}
return(listRole);
}
public IList <SysRoleModel> GetListDistinctName()
{
DataTable dt = _roleRep.GetListDistinctName();
IList <SysRoleModel> list = ConverHelper.ToList <SysRoleModel>(dt);
if (list.Count > 0)
{
SysRoleModel model = new SysRoleModel();
model.ROLE_ID = "";
model.ROLE_NAME = "--ALL--";
list.Insert(0, model);
}
return(list);
}
public JsonResult Edit(SysRoleModel model)
{
if (m_BLL.Edit(ref errors, model))
{
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",Name" + model.Name, "成功", "修改", "系统菜单");
return(Json(1, JsonRequestBehavior.AllowGet));
}
else
{
string ErrorCol = errors.Error;
LogHandler.WriteServiceLog(GetUserId(), "Id" + model.Id + ",Name" + model.Name + "," + ErrorCol, "失败", "修改", "系统菜单");
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
//从页面上获取模板数据
private SysRoleModel sysUserLoginFromPage()
{
SysRoleModel SysRole = new SysRoleModel();
SysUserRoleRelationModel SysUserRoleRelation = null;
string selectedRoleIDs = Rc.Cloud.Web.Common.pfunction.GetCblCheckedValue(cblRole, ",");
string[] arryselectedRoleIDs = selectedRoleIDs.Split(',');
switch (actionType)
{
case SysUser.Add:
#region 用户角色实例
//选择了角色
if (selectedRoleIDs != string.Empty)
{
foreach (string selectedRoleID in arryselectedRoleIDs)
{
SysUserRoleRelation = new SysUserRoleRelationModel();
SysUserRoleRelation.SysUser_ID = sysUser_IDs;
SysUserRoleRelation.SysRole_ID = selectedRoleID;
SysUserRoleRelation.CreateTime = DateTime.Now;
SysUserRoleRelation.CreateUser = loginUser.SysUser_ID;
SysRole.SysUserRoleList.Add(SysUserRoleRelation);
}
}
#endregion
break;
case SysUser.Edit:
if (selectedRoleIDs != string.Empty)
{
foreach (string selectedRoleID in arryselectedRoleIDs)
{
SysUserRoleRelation = new SysUserRoleRelationModel();
SysUserRoleRelation.SysUser_ID = sysUser_ID;
SysUserRoleRelation.SysRole_ID = selectedRoleID;
SysUserRoleRelation.UpdateUser = loginUser.SysUser_ID;
SysUserRoleRelation.CreateTime = DateTime.Now;
SysRole.SysUserRoleList.Add(SysUserRoleRelation);
}
}
break;
}
return(SysRole);
}
public bool AddRoleModel(UserRole role)
{
SysRoleModel roleModel = bllRole.GetModel(role.RoleName);
if (roleModel != null)
{
bllRole.Delete(role.RoleName);
}
roleModel = new SysRoleModel();
roleModel.SysRole_Name = role.RoleName;
roleModel.SysRole_Desc = role.RoleDesc;
roleModel.SysRole_Level = role.RoleLevel;
roleModel.SysRole_Remark = role.RoleRemark;
return(bllRole.Add(roleModel));
}
public async Task <IHttpActionResult> Update([FromBody] SysRoleModel role)
{
return(await ResultFactory.Create(ModelState, async arg =>
{
var result = await sysRoleService.UpdateAsync(new SysRoleDto
{
Url = role.Url,
Name = role.Name,
UpdateTime = DateTime.Now
}) > 0;
return new ApiResult(result ? ExceptionCode.Success : ExceptionCode.InternalError, "",
null);
}, role, "success", "请检查请求参数"));
}
