/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public int Insert(BPMS_DataPermission entity)
{
int IsOk = DataFactory.DbUtils().Insert(entity);
#region 写日操作日志
if (IsOk > 0)
{
BPMS_SysLogDAL.Instance.AddTaskLog <BPMS_DataPermission>(entity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName);
}
#endregion
return(IsOk);
}
/// <summary>
/// 新建的项目数据，默认把数据权限设置了，，这样就别必要要去数据权限管理里面去打钩
/// </summary>
/// <param name="RoleId">角色</param>
/// <param name="ResourceId">对象</param>
/// <param name="key">数据ID</param>
/// <param name="UserId">当前用户</param>
/// <param name="key"></param>
public void AddItemDefault(string RoleId, string ResourceId, string key, string UserId)
{
Hashtable ht_Where = new Hashtable();
ht_Where["RoleId"] = RoleId;
ht_Where["ResourceId"] = ResourceId;
BPMS_DataPermission entity = DataFactory.DbUtils().GetModelById <BPMS_DataPermission>(ht_Where);
entity.ObjectId = entity.ObjectId + ",'" + key + "'";
int IsOk = DataFactory.DbUtils().Update(entity, "DataPermissionId");
CacheHelper.RemoveAllCache("Data" + UserId);
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public int Update(BPMS_DataPermission entity)
{
#region 获取旧值
var oldEntity = this.GetEntity(BPMS_SysLogDAL.Instance.GetKeyFieldValue <BPMS_DataPermission>(entity).ToString());
#endregion
int IsOk = DataFactory.DbUtils().Update(entity, "DataPermissionId");
#region 写日操作日志
if (IsOk > 0)
{
BPMS_SysLogDAL.Instance.UpdateTaskLog <BPMS_DataPermission>(oldEntity, entity, RequestSession.GetSessionUser().UserId, RequestSession.GetSessionUser().UserName);
}
#endregion
return(IsOk);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="KeyValue">主键</param>
/// <returns></returns>
public BPMS_DataPermission GetEntity(StringBuilder where, SqlParam[] param)
{
BPMS_DataPermission entity = new BPMS_DataPermission();
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM BPMS_DataPermission WHERE 1=1");
strSql.Append(where);
DataTable dt = DataFactory.SqlHelper().GetDataTableBySQL(strSql, param);
if (dt.Rows.Count > 0)
{
return(DbReader.ReaderToModel <BPMS_DataPermission>(dt.Rows[0]));
}
else
{
return(entity);
}
}
/// <summary>
/// 员工列表
/// </summary>
/// <returns></returns>
public string GetEmployeeList(string RoleId, string AuthorizationItemValue)
{
BPMS_DataPermission datapermission = bpms_datapermissionibll.GetEntity(RoleId, AuthorizationItemValue);
string[] array = new string[0];
if (!string.IsNullOrEmpty(datapermission.ObjectId))
{
array = datapermission.ObjectId.Replace("'", "").Split(',');
}
StringBuilder strHtml = new StringBuilder();
IList list = bpms_datapermissionibll.GetEmployeeList();
strHtml.Append("<li>");
strHtml.Append("<input style='vertical-align: middle;margin-bottom:2px;' type=\"checkbox\" name=\"checkbox\" /><img src='/Themes/images/16/spellcheck.png' style='vertical-align: middle;' alt=''/>所有员工");
if (list.Count > 0)
{
strHtml.Append("<ul>");
foreach (BPMS_Employee entity in list)
{
bool exists = ((IList)array).Contains(entity.EmployeeId);
string Genderimg = "user_red.png";
var Gender = entity.Gender;
if (Gender == "男")
{
Genderimg = "user_mature.png";
}
strHtml.Append("<li>");
strHtml.Append("<input " + GetChecked(exists) + " style='vertical-align: middle;margin-bottom:2px;' type=\"checkbox\" value=\"" + entity.EmployeeId + "\" name=\"checkbox\" /><img src='/Themes/images/16/" + Genderimg + "' style='vertical-align: middle;' alt=''/>" + entity.Code + " - " + entity.RealName + "");
strHtml.Append("</li>");
}
strHtml.Append("</ul>");
}
else
{
strHtml.Append("<li><div><span style='color:red;'>暂无员工</span></div>");
}
strHtml.Append("</li>");
return(strHtml.ToString());
}
/// <summary>
/// 组织机构
/// </summary>
public string GetOrgTree(string RoleId, string AuthorizationItemValue)
{
BPMS_DataPermission datapermission = bpms_datapermissionibll.GetEntity(RoleId, AuthorizationItemValue);
string[] array = new string[0];
if (!string.IsNullOrEmpty(datapermission.ObjectId))
{
array = datapermission.ObjectId.Replace("'", "").Split(',');
}
StringBuilder strHtml = new StringBuilder();
IList list = bpms_datapermissionibll.GetOrganizationList();
List <BPMS_Organization> itemNode = IListHelper.IListToList <BPMS_Organization>(list).FindAll(t => t.ParentId == "0");
foreach (BPMS_Organization entity in itemNode)
{
strHtml.Append("<li>");
bool exists = ((IList)array).Contains(entity.OrganizationId);
strHtml.Append("<input " + GetChecked(exists) + " style='vertical-align: middle;margin-bottom:2px;' type=\"checkbox\" value=\"" + entity.OrganizationId + "\" name=\"checkbox\" /><img src='/Themes/images/16/house.png' style='vertical-align: middle;' alt=''/>" + entity.FullName + "");
//创建子节点
strHtml.Append(GeOrgtTreeNode(entity.OrganizationId, list, array));
strHtml.Append("</li>");
}
return(strHtml.ToString());
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public bool Update(BPMS_DataPermission entity)
{
return(dal.Update(entity) >= 0 ? true : false);
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="entity">实体类</param>
/// <returns></returns>
public bool Insert(BPMS_DataPermission entity)
{
return(dal.Insert(entity) >= 0 ? true : false);
}
public void LoadAction()
{
Response.Buffer = true;
Response.ExpiresAbsolute = System.DateTime.Now.AddSeconds(-1);
Response.Expires = 0;
Response.CacheControl = "no-cache";
Response.AddHeader("Pragma", "No-Cache");
string active = HttpContext.Current.Request["action"]; //提交类型
string RoleId = HttpContext.Current.Request["RoleId"]; //角色主键
string AuthorizationItemValue = HttpContext.Current.Request["AuthorizationItemValue"]; //授权项目
string itemId = HttpContext.Current.Request["itemId"]; //授权项目对象Id
switch (active)
{
case "LoadOrgTree": //组织机构
Response.Write(GetOrgTree(RoleId, AuthorizationItemValue));
Response.End();
break;
case "LoadUserList": //用户列表
Response.Write(GetUserList(RoleId, AuthorizationItemValue));
Response.End();
break;
case "LoadEmployeeList": //员工列表
Response.Write(GetEmployeeList(RoleId, AuthorizationItemValue));
Response.End();
break;
case "AddDataPermission": //添加数据权限
bool IsOk = false;
entity = bpms_datapermissionibll.GetEntity(RoleId, AuthorizationItemValue);
if (entity.DataPermissionId == null)
{
entity.DataPermissionId = CommonHelper.GetGuid;
entity.RoleId = RoleId;
entity.ResourceId = AuthorizationItemValue;
entity.ObjectId = itemId;
entity.CreateUserId = RequestSession.GetSessionUser().UserId;
entity.CreateUserName = RequestSession.GetSessionUser().UserName;
IsOk = bpms_datapermissionibll.Insert(entity);
}
else
{
entity.RoleId = RoleId;
entity.ResourceId = AuthorizationItemValue;
entity.ObjectId = itemId;
entity.CreateUserId = RequestSession.GetSessionUser().UserId;
entity.CreateUserName = RequestSession.GetSessionUser().UserName;
IsOk = bpms_datapermissionibll.Update(entity);
}
CacheHelper.RemoveAllCache();
Response.Write(IsOk);
Response.End();
break;
default:
break;
}
}
