public JsonResult Delete(string id)
{
if (!string.IsNullOrWhiteSpace(id))
{
string usid = LoginUser.User.UserName;
EAP_Role m = new EAP_Role()
{
ID = int.Parse(id)
};
CommandResult r = DeleteObj <EAP_Role>(m);
// if (m_BLL.Delete(ref errors, id))
if (r.IntResult > 0)
{
LogHandler.WriteServiceLog(usid, "Id:" + id, "成功", "删除", "SysRole");
return(Json(JsonHandler.CreateMessage(1, Suggestion.DeleteSucceed)));
}
else
{
string ErrorCol = r.Message;
LogHandler.WriteServiceLog(usid, "Id" + id + "," + ErrorCol, "失败", "删除", "SysRole");
return(Json(JsonHandler.CreateMessage(0, Suggestion.DeleteFail + ErrorCol)));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Suggestion.DeleteFail)));
}
}
public CommandResult UpdateRole(EAP_Role role)
{
CommandResult result = new CommandResult();
/*
* string sSql = "UPDATE EAP_Role SET ";
* role.Items.ForEach(e =>
* {
* if (e.S == EntityStatus.Modified && !string.IsNullOrEmpty(e.K))
* {
* sSql += string.Format("[{0}]='{1}',", e.K, e.V);
* }
* });
*
* sSql = sSql.Trim().TrimEnd(',');
* sSql += " WHERE ID='" + role.ID.ToString() + "'";
*
* int iRows = DataProvider.ExecuteNonQuery(sSql);
*/
int iRows = DataProvider.DoUpdate(role, "EAP_Role", "ID", null);
result.Result = iRows > 0 ? true : false;
result.Message = iRows > 0 ? "更新成功。" : "更新失败。";
return(result);
}
public ActionResult Details(string id)
{
ViewBag.Perm = GetPermission();
EAP_Role entity = GetObjByID <EAP_Role>(id);
return(View(entity));
}
public ActionResult Create()
{
ViewBag.Perm = GetPermission();
EAP_Role m = new EAP_Role();
return(View(m));
}
public ActionResult Edit(string id)
{
ViewBag.Perm = GetPermission();
EAP_Role entity = GetObjByID <EAP_Role>(id);
//SysRoleModel entity = m_BLL.GetById(id);
return(View("Create", entity));
}
public JsonResult Create(EAP_Role model)
{
if (model != null && ModelState.IsValid)
{
LoginInfo _login = LoginUser;
CommandResult r = SaveObj <EAP_Role>(model);
if (r.IntResult > 0)
{
LogHandler.WriteServiceLog(_login.User.UserID.ToString(), "Id:" + model.ID + ",Name:" + model.RoleName, "成功", "保存", "组织结构");
return(Json(JsonHandler.CreateMessage(1, Suggestion.Save), JsonRequestBehavior.AllowGet));
}
else
{
string ErrorCol = r.Message;
LogHandler.WriteServiceLog(_login.User.UserID.ToString(), "Id:" + model.ID + ",Name:" + model.RoleName + "," + ErrorCol, "失败", "保存", "组织结构");
return(Json(JsonHandler.CreateMessage(0, Suggestion.SaveFail + ErrorCol), JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(JsonHandler.CreateMessage(0, Suggestion.SaveFail), JsonRequestBehavior.AllowGet));
}
/*
* model.Id = ResultHelper.NewId;
* model.CreateTime = ResultHelper.NowTime;
* model.CreatePerson = GetUserId();
* if (model != null && ModelState.IsValid)
* {
*
* if (m_BLL.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 void UpdateRole(DataRequest request, DataResponse result, DataProvider datasource)
{
EAP_Role role = TJson.Parse <EAP_Role>(request["P0"]);
result.Value = ToJson(new AccountOP(request.LogIn).UpdateRole(role));
}
public CommandResult AddRole(EAP_Role role)
{
CommandResult result = new CommandResult();
result.Result = false;
string sFields = "";
string sValues = "";
if (role.Items.Count <= 0)
{
return(result);
}
/*
* role.Items.ForEach(e =>
* {
* if (!string.IsNullOrEmpty(e.K) && e.S == EntityStatus.New)
* {
* sFields += string.Format("[{0}],", e.K);
* sValues += string.Format("'{0}',", e.V);
* }
* });
* */
string sql = string.Format("select count(*) from EAP_Role where RoleName='{0}'", role.RoleName);
/*
* string sSql = string.Format(
* "INSERT INTO EAP_Role({0}) VALUES({1});SELECT CAST(scope_identity() AS int);",
* sFields.Trim().TrimEnd(','),
* sValues.Trim().TrimEnd(','));
* int count = DataProvider.ExecuteScalar<int>(sql);
*/
int count = (int)DataProvider.ExecuteScalar <decimal>(sql);
if (count <= 0)
{
// int iPID = DataProvider.ExecuteScalar<int>(sSql);
int iPID = DataProvider.DoInsert(role, "EAP_Role", true, null);
if (iPID > 0)
{
result.Result = true;
result.ReturnValue.Add(new LookupDataItem()
{
K = "ID", V = iPID.ToString()
});
result.Message = "新增成功。";
}
else
{
result.Result = false;
result.Message = "新增失败。";
}
}
else
{
result.Result = false;
result.IntResult = 1;
result.Message = "该角色已经存在。";
}
return(result);
}
