/// <summary> /// 列表 /// </summary> /// <param name="dp"></param> /// <returns></returns> public DataTable GetList(int logUserId, string logUserName, DateTime startDate, DateTime endDate, int pageIndex, int pageSize, out int count) { count = 0; try { DateTime tmpStartDate = ConvertHelper.ObjectToDateTime(startDate.ToShortDateString() + " 00:00:00"); DateTime tmpEndDate = ConvertHelper.ObjectToDateTime(endDate.AddDays(1).ToShortDateString() + " 00:00:00"); Expression <Func <SystemExceptionLog, bool> > condition = t => t.CreateDate >= tmpStartDate && t.CreateDate <= endDate; List <SystemExceptionLog> list = dal.GetList(pageIndex, pageSize, out count, condition, t => t.CreateDate, false).Cast <SystemExceptionLog>().ToList(); #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "SystemExceptionLog"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.访问.GetHashCode(); this.BLLProvider.SysLogBLL.Add(null, sysLogModel, null); #endregion return(ConvertHelper.ToDataTable <SystemExceptionLog>(list)); } catch (Exception ex) { this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } return(null); }
/// <summary> /// 列表 /// </summary> /// <param name="searchType"> /// 1=编号、2=账号、3=姓名 /// </param> /// <returns></returns> public DataTable GetList(int logUserId, string logUserName, int searchType, string keyWord, int isEnable, int pageIndex, int pageSize, out int count) { count = 0; try { #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "UserInfo"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.访问.GetHashCode(); this.BLLProvider.SysLogBLL.Add(null, sysLogModel, null); #endregion DataTable rltDt = dal.GetList(searchType, keyWord, isEnable, pageIndex, pageSize, out count); var datas = this.BLLProvider.DataDictionaryBLL.AllDictionary; rltDt.Columns.Add("DutyName"); rltDt.Columns.Add("TitleName"); foreach (DataRow item in rltDt.Rows) { item["DutyName"] = datas.Find(t => t.ID == int.Parse(item["DutyId"].ToString())).Name; item["TitleName"] = datas.Find(t => t.ID == int.Parse(item["TitleId"].ToString())).Name; } return(rltDt); } catch (Exception ex) { this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } return(null); }
/// <summary> /// 删除 /// </summary> /// <returns> /// 0操作失败,请联系管理员 /// 1操作成功 /// 11当前对象已不存在 /// 14当前数据已经使用,不允许删除 /// </returns> public int Delete(int logUserId, string logUserName, int id) { int rlt = 1; using (var ctx = TranContext.BeginTran()) { try { var model = dal.GetModel(ctx, t => t.ID == id); if (model == null) { rlt = 11; } if (rlt == 1 && (this.BLLProvider.RolePurviewBLL.GetCount(t => t.PurviewId == id) > 0 || this.BLLProvider.UserPurviewBLL.GetCount(t => t.PurviewId == id) > 0)) { rlt = 14; } if (rlt == 1) { #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "PurviewInfo"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.ObjectId = id; sysLogModel.OperationType = EOperationType.除.GetHashCode(); var entry = ctx.Entry(model); if (rlt == 1 && !this.BLLProvider.SysLogBLL.Add(ctx, sysLogModel, entry)) { rlt = 0; } #endregion if (!dal.Delete(ctx, model)) { rlt = 0; } } if (rlt == 1) { TranContext.Commit(ctx); } else { TranContext.Rollback(ctx); } } catch (Exception ex) { rlt = 0; TranContext.Rollback(ctx); this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } } return(rlt); }
/// <summary> /// 列表 /// </summary> /// <param name="dp"></param> /// <returns></returns> public DataTable GetList(int logUserId, string logUserName, int systemId) { try { DataTable rlt = dal.GetList(systemId); DataColumn col = new DataColumn("CategoryName"); foreach (DataRow item in rlt.Rows) { item["CategoryName"] = this.BLLProvider.DataDictionaryBLL.AllDictionary.First(t => t.ID == int.Parse(item["Category"].ToString())).Name; } #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "RoleInfo"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.访问.GetHashCode(); this.BLLProvider.SysLogBLL.Add(null, sysLogModel, null); #endregion } catch (Exception ex) { this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } return(null); }
/// <summary> /// 列表 /// </summary> /// <param name="dp"></param> /// <returns></returns> public DataTable GetList(int logUserId, string logUserName) { try { #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "IPBlacklist"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.访问.GetHashCode(); this.BLLProvider.SysLogBLL.Add(null, sysLogModel, null); #endregion var list = dal.GetList(t => true).Cast <IPBlacklist>().ToList(); DataTable rltDt = ConvertHelper.ToDataTable(list); DataColumn col = new DataColumn("CategoryName"); rltDt.Columns.Add(col); foreach (DataRow item in rltDt.Rows) { item["CategoryName"] = (EIPBlacklistCategory)int.Parse(item["Category"].ToString()); } } catch (Exception ex) { this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } return(null); }
/// <summary> /// 操作列表 /// </summary> public DataTable GetActionList(int logUserId, string logUserName, int systemId, int moduleId, int functionId, string actionName, string actionCode, int isEnable, int pageIndex, int pageSize, out int count) { count = 0; try { DataTable rlt = dal.GetActionList(systemId, moduleId, functionId, actionName, actionCode, isEnable, pageIndex, pageSize, out count); DataColumn col = new DataColumn("PurviewTypeName"); foreach (DataRow item in rlt.Rows) { item["PurviewTypeName"] = (EPurviewType)int.Parse(item["PurviewType"].ToString()); } #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "PurviewInfo"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.访问.GetHashCode(); this.BLLProvider.SysLogBLL.Add(null, sysLogModel, null); #endregion } catch (Exception ex) { this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } return(null); }
/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns> /// 0 失败 /// 1 成功 /// 12 名称重复 /// 13 编码重复 /// </returns> public int Add(MenuInfo model) { int rlt = 1; if (IsRepeatName(model.SystemId, model.Name, model.ID)) { rlt = 12; } if (rlt == 1 && IsRepeatCode(model.SystemId, model.Code, model.ID)) { rlt = 13; } if (rlt == 1) { using (var ctx = TranContext.BeginTran()) { try { model.ID = this.GetNewID(); model.CreateDate = DateTime.Now; #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "MenuInfo"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = model.ModifyUserId; sysLogModel.CreateUserName = model.ModifyUserName; sysLogModel.ObjectId = model.ID; sysLogModel.OperationType = EOperationType.新增.GetHashCode(); var entry = ctx.Entry(model); if (rlt == 1 && !this.BLLProvider.SysLogBLL.Add(ctx, sysLogModel, entry)) { rlt = 0; } #endregion if (rlt == 1 && !dal.Insert(ctx, model)) { rlt = 0; } if (rlt == 1) { TranContext.Commit(ctx); } else { TranContext.Rollback(ctx); } } catch (Exception ex) { rlt = 0; TranContext.Rollback(ctx); this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } } } return(rlt); }
/// <summary> /// 设置用户角色 /// </summary> /// <returns> /// 0操作失败,请联系管理员 /// 1操作成功 /// </returns> public int UserRoleSet(int logUserId, string logUserName, int systemId, int userId, List <int> lstRoleId) { int rlt = 1; using (var ctx = TranContext.BeginTran()) { try { #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "DataDictionary"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.修改.GetHashCode(); if (rlt == 1 && !this.BLLProvider.SysLogBLL.Add(ctx, sysLogModel, null)) { rlt = 0; } #endregion dal.Delete(ctx, systemId, userId); List <UserRole> modeList = new List <UserRole>(); foreach (var item in lstRoleId) { UserRole model = new UserRole(); model.ID = GetNewID(); model.CreateDate = DateTime.Now; model.CreateUserId = logUserId; model.CreateUserName = logUserName; model.RoleId = item; model.UserId = userId; modeList.Add(model); } if (rlt == 1 && !dal.Insert(ctx, modeList)) { rlt = 0; } if (rlt == 1) { TranContext.Commit(ctx); } else { TranContext.Rollback(ctx); } } catch (Exception ex) { rlt = 0; TranContext.Rollback(ctx); this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } } return(rlt); }
/// <summary> /// 角色成员添加 /// </summary> /// <param name="xmlCredentials"></param> /// <param name="roleId"></param> /// <param name="userIdList"></param> /// <returns> /// 0 成功 /// 1 失败 /// </returns> public int Add(int logUserId, string logUserName, int roleId, List <int> userIdList) { int rlt = 1; using (var ctx = TranContext.BeginTran()) { try { List <UserRole> list = new List <UserRole>(); foreach (var item in userIdList) { UserRole model = new UserRole(); model.ID = dal.GetNewID("UserRole"); model.UserId = item; model.RoleId = roleId; model.CreateDate = DateTime.Now; model.CreateUserId = logUserId; model.CreateUserName = logUserName; list.Add(model); #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "UserRole"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.新增.GetHashCode(); var entry = ctx.Entry(model); if (rlt == 1 && !this.BLLProvider.SysLogBLL.Add(ctx, sysLogModel, entry)) { rlt = 0; } #endregion } if (rlt == 1 && !this.BLLProvider.UserRoleBLL.Insert(ctx, list)) { rlt = 0; } if (rlt == 1) { TranContext.Commit(ctx); } else { TranContext.Rollback(ctx); } } catch (Exception ex) { rlt = 0; TranContext.Rollback(ctx); this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } } return(rlt); }
/// <summary> /// 角色成员删除 /// </summary> /// <returns> /// 0 /// 1 /// 15 该成员不能删除,因为该成员只有一个角色 /// </returns> public int Delete(int logUserId, string logUserName, int roleId, int userId) { int rlt = 1; using (var ctx = TranContext.BeginTran()) { try { int count = this.BLLProvider.UserRoleBLL.GetCount(t => t.UserId == userId); if (count == 1) { rlt = 15; } var model = this.BLLProvider.UserRoleBLL.GetModel(ctx, t => t.UserId == userId && t.RoleId == roleId); if (rlt == 1 && !this.BLLProvider.UserRoleBLL.Delete(ctx, model)) { rlt = 0; } if (rlt == 1 && !this.BLLProvider.UserPurviewBLL.Delete(ctx, t => t.RoleId == roleId && t.UserId == userId)) { rlt = 0; } #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "UserRole"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.除.GetHashCode(); var entry = ctx.Entry(model); if (rlt == 1 && !this.BLLProvider.SysLogBLL.Add(ctx, sysLogModel, entry)) { rlt = 0; } #endregion if (rlt == 1) { TranContext.Commit(ctx); } else { TranContext.Rollback(ctx); } } catch (Exception ex) { rlt = 0; TranContext.Rollback(ctx); this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } } return(rlt); }
/// <summary> /// 重置密码 /// </summary> /// <param name="id"></param> /// <returns></returns> public bool PasswordReset(int logUserId, string logUserName, int id) { int rlt = 1; using (var ctx = TranContext.BeginTran()) { try { var model = dal.GetModel(ctx, t => t.ID == id); string md5Pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(model.Account, "MD5").Substring(0, 20); model.Password = md5Pwd; #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "UserInfo"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.ObjectId = model.ID; sysLogModel.OperationType = EOperationType.修改.GetHashCode(); sysLogModel.Remark = "重置用户密码"; if (rlt == 1 && !this.BLLProvider.SysLogBLL.Add(ctx, sysLogModel, null)) { rlt = 0; } #endregion if (rlt == 1 && !dal.Update(ctx, model)) { rlt = 0; } if (rlt == 1) { TranContext.Commit(ctx); } else { TranContext.Rollback(ctx); } return(rlt == 1 ? true : false); } catch (Exception ex) { rlt = 0; TranContext.Rollback(ctx); this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } } return(rlt == 1 ? true : false); }
/// <summary> /// 设置用户权限 /// </summary> /// <returns> /// 0 失败 /// 1 成功 /// </returns> public int UserPurviewSet(int logUserId, string logUserName, List <UserPurview> modelList) { int rlt = 1; using (var ctx = TranContext.BeginTran()) { try { #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "UserPurview"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.修改.GetHashCode(); sysLogModel.Remark = "分配用户权限"; if (rlt == 1 && !this.BLLProvider.SysLogBLL.Add(ctx, sysLogModel, null)) { rlt = 0; } #endregion if (rlt == 1 && !dal.Delete(ctx, t => t.UserId == modelList.First().UserId&& t.RoleId == modelList.First().RoleId)) { rlt = 0; } if (rlt == 1 && !dal.Insert(ctx, modelList)) { rlt = 0; } if (rlt == 1) { TranContext.Commit(ctx); } else { TranContext.Rollback(ctx); } } catch (Exception ex) { rlt = 0; TranContext.Rollback(ctx); this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } } return(rlt); }
/// <summary> /// 删除 /// </summary> /// <param name="idList"></param> /// <returns> /// 0操作失败,请联系管理员 /// 1操作成功 /// </returns> public int Delete(int logUserId, string logUserName, int systemId, int roleId, int userId) { int rlt = 1; using (var ctx = TranContext.BeginTran()) { try { if (rlt == 1) { #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "UserPurview"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.除.GetHashCode(); sysLogModel.Remark = "重置用户权限"; if (rlt == 1 && !this.BLLProvider.SysLogBLL.Add(ctx, sysLogModel, null)) { rlt = 0; } #endregion dal.Delete(ctx, systemId, roleId, userId); } if (rlt == 1) { TranContext.Commit(ctx); } else { TranContext.Rollback(ctx); } } catch (Exception ex) { rlt = 0; TranContext.Rollback(ctx); this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } } return(rlt); }
/// <summary> /// 用户权限列表 /// </summary> /// <returns></returns> public DataTable GetList(int logUserId, string logUserName, int systemId, int roleId, int userId) { try { #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "UserPurview"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.访问.GetHashCode(); this.BLLProvider.SysLogBLL.Add(null, sysLogModel, null); #endregion return(GetUserPurview(systemId, roleId, userId)); } catch (Exception ex) { this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } return(null); }
/// <summary> /// 删除 将在此时间之前的日志删除 /// </summary> /// <param name="endDate">截止日期</param> /// <returns></returns> public int Delete(int logUserId, string logUserName, int systemId, DateTime endDate) { int rlt = 1; using (var ctx = TranContext.BeginTran()) { try { #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "SysLoginLog"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.除.GetHashCode(); this.BLLProvider.SysLogBLL.Add(ctx, sysLogModel, null); #endregion if (!dal.Delete(ctx, t => t.SystemId == systemId && t.CreateDate <= endDate)) { rlt = 0; } if (rlt == 1) { TranContext.Commit(ctx); } else { TranContext.Rollback(ctx); } } catch (Exception ex) { rlt = 0; TranContext.Rollback(ctx); this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } } return(rlt); }
/// <summary> /// 列表 /// </summary> /// <param name="dp"></param> /// <returns></returns> public DataTable GetList(int logUserId, string logUserName, DateTime startDate, DateTime endDate, int systemId, string account, int pageIndex, int pageSize, out int count) { count = 0; try { #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "SysLoginLog"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.访问.GetHashCode(); this.BLLProvider.SysLogBLL.Add(null, sysLogModel, null); #endregion return(dal.GetList(startDate, endDate, systemId, account, pageIndex, pageSize, out count)); } catch (Exception ex) { this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } return(null); }
/// <summary> /// 列表 /// </summary> /// <returns></returns> public DataTable GetList(int logUserId, string logUserName, int systemId, int dictType) { try { var list = dal.GetList(t => t.SystemId == systemId && t.DictType == dictType).Cast <DataDictionary>() .Select(t => new { t.ID, t.DictType, t.Name, t.Code, t.ParentId, t.IsEnable, t.Remark, t.SortIndex, t.AllowDelete, t.AllowEdit }); #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "DataDictionary"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.访问.GetHashCode(); this.BLLProvider.SysLogBLL.Add(null, sysLogModel, null); #endregion return(ConvertHelper.ToDataTable(list.Cast <object>().ToArray())); } catch (Exception ex) { this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } return(null); }
/// <summary> /// 列表 /// </summary> /// <param name="dp"></param> /// <returns></returns> public DataTable GetList(int logUserId, string logUserName) { try { var list = dal.GetList(t => true).Cast <DataDictionary>().ToList(); #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "SystemInfo"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.访问.GetHashCode(); this.BLLProvider.SysLogBLL.Add(null, sysLogModel, null); #endregion return(ConvertHelper.ToDataTable(list)); } catch (Exception ex) { this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } return(null); }
/// <summary> /// 列表 /// </summary> /// <param name="category"></param> /// <param name="searchType">1=工号、2=姓名</param> /// <param name="keyWord"></param> /// <returns></returns> public DataTable GetList(int logUserId, string logUserName, EOrgaCategory category, int orgaId, int searchType, string keyWord, int pageIndex, int pageSize, out int count) { count = 0; try { #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "Employee"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.访问.GetHashCode(); this.BLLProvider.SysLogBLL.Add(null, sysLogModel, null); #endregion Expression <Func <Employee, bool> > condition = t => true; if (category == EOrgaCategory.集团) { condition.And(t => t.SubCompanyId == orgaId); } else if (category == EOrgaCategory.公司) { condition.And(t => t.CompanyId == orgaId); } else if (category == EOrgaCategory.部门) { condition.And(t => t.DepartmentId == orgaId); } else if (category == EOrgaCategory.工作组) { condition.And(t => t.WorkgroupId == orgaId); } if (searchType == 1) { condition.And(t => t.Code == keyWord); } if (searchType == 2) { condition.And(t => t.Name == keyWord); } List <Employee> list = dal.GetList(pageIndex, pageSize, out count, condition, t => t.Code, true).Cast <Employee>().ToList(); DataTable rltDt = ConvertHelper.ToDataTable(list); rltDt.Columns.AddRange(new DataColumn[] { new DataColumn("DutyName"), new DataColumn("EducationName"), new DataColumn("DegreeName"), new DataColumn("TitleName"), new DataColumn("TitleLevelName"), new DataColumn("PartyName"), new DataColumn("NationName"), new DataColumn("NationalityName"), new DataColumn("WorkingPropertyName"), new DataColumn("CompetencyName"), }); var dict = this.BLLProvider.DataDictionaryBLL.AllDictionary; foreach (DataRow item in rltDt.Rows) { item["DutyName"] = dict.Find(t => t.ID == int.Parse(item["DutyId"].ToString())).Name; item["EducationName"] = dict.Find(t => t.ID == int.Parse(item["Education"].ToString())).Name; item["DegreeName"] = dict.Find(t => t.ID == int.Parse(item["Degree"].ToString())).Name; item["TitleName"] = dict.Find(t => t.ID == int.Parse(item["TitleId"].ToString())).Name; item["TitleLevelName"] = dict.Find(t => t.ID == int.Parse(item["DutyId"].ToString())).Name; item["PartyName"] = dict.Find(t => t.ID == int.Parse(item["DutyId"].ToString())).Name; item["NationName"] = dict.Find(t => t.ID == int.Parse(item["DutyId"].ToString())).Name; item["NationalityName"] = dict.Find(t => t.ID == int.Parse(item["DutyId"].ToString())).Name; item["WorkingPropertyName"] = dict.Find(t => t.ID == int.Parse(item["DutyId"].ToString())).Name; item["CompetencyName"] = dict.Find(t => t.ID == int.Parse(item["DutyId"].ToString())).Name; } return(rltDt); } catch (Exception ex) { this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } return(null); }
/// <summary> /// 设置权限 /// </summary> /// <param name="roleId"></param> /// <param name="purviewIdList"></param> /// <returns> /// 0 失败 /// 1 成功 /// </returns> public int PurviewSet(int logUserId, string logUserName, int roleId, List <int> purviewIdList) { int rlt = 1; using (var ctx = TranContext.BeginTran()) { try { if (!dal.Delete(ctx, t => t.RoleId == roleId)) { rlt = 0; } if (rlt == 1) { List <RolePurview> list = new List <RolePurview>(); foreach (var item in purviewIdList) { RolePurview model = new RolePurview(); model.ID = GetNewID(); model.RoleId = roleId; model.PurviewId = item; list.Add(model); } if (!dal.Insert(ctx, list)) { rlt = 0; } } if (rlt == 1) { #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "RolePurview"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.OperationType = EOperationType.修改.GetHashCode(); if (rlt == 1 && !this.BLLProvider.SysLogBLL.Add(ctx, sysLogModel, null)) { rlt = 0; } #endregion } if (rlt == 1) { TranContext.Commit(ctx); } else { TranContext.Rollback(ctx); } } catch (Exception ex) { rlt = 0; TranContext.Rollback(ctx); this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } } return(rlt); }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns> /// 0操作失败,请联系管理员 /// 1操作成功 /// 11当前对象已不存在 /// </returns> public int Edit(IPBlacklist model) { int rlt = 1; using (var ctx = TranContext.BeginTran()) { try { var oldModel = dal.GetModel(ctx, t => t.ID == model.ID); if (oldModel == null) { rlt = 11; } if (rlt == 1) { oldModel.StartIp = model.StartIp; oldModel.EndIp = model.EndIp; oldModel.Failuretime = model.Failuretime; oldModel.Remark = model.Remark; oldModel.IsEnable = model.IsEnable; oldModel.SortIndex = model.SortIndex; oldModel.ModifyDate = DateTime.Now; oldModel.ModifyUserId = model.ModifyUserId; oldModel.ModifyUserName = model.ModifyUserName; #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "IPBlacklist"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = model.ModifyUserId; sysLogModel.CreateUserName = model.ModifyUserName; sysLogModel.ObjectId = model.ID; sysLogModel.OperationType = EOperationType.修改.GetHashCode(); var entry = ctx.Entry(oldModel); if (rlt == 1 && !this.BLLProvider.SysLogBLL.Add(ctx, sysLogModel, entry)) { rlt = 0; } #endregion if (rlt == 1 && !dal.Insert(ctx, oldModel)) { rlt = 0; } } if (rlt == 1) { TranContext.Commit(ctx); } else { TranContext.Rollback(ctx); } } catch (Exception ex) { rlt = 0; TranContext.Rollback(ctx); this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } } return(rlt); }
/// <summary> /// 删除 /// </summary> /// <param name="idList"></param> /// <returns> /// 0操作失败,请联系管理员 /// 1操作成功 /// 11当前对象已不存在 /// 14当前数据已经使用,不允许删除 /// </returns> public int Delete(int logUserId, string logUserName, int id) { int rlt = 1; using (var ctx = TranContext.BeginTran()) { try { var model = dal.GetModel(ctx, t => t.ID == id); if (model == null) { rlt = 11; } if (rlt == 1) { #region 判断当前数据是否使用 int count = 0; switch ((EDictType)model.DictType) { case EDictType.国籍: count = this.BLLProvider.EmployeeBLL.GetCount(t => t.NationId == id); break; case EDictType.角色分类: count = this.BLLProvider.RoleInfoBLL.GetCount(t => t.Category == id); break; case EDictType.民族: count = this.BLLProvider.EmployeeBLL.GetCount(t => t.NationalityId == id); break; case EDictType.学历: count = this.BLLProvider.EmployeeBLL.GetCount(t => t.EducationId == id); break; case EDictType.学位: count = this.BLLProvider.EmployeeBLL.GetCount(t => t.DegreeId == id); break; case EDictType.用工性质: count = this.BLLProvider.EmployeeBLL.GetCount(t => t.WorkingPropertyId == id); break; case EDictType.政治面貌: count = this.BLLProvider.EmployeeBLL.GetCount(t => t.PartyId == id); break; case EDictType.职称: count = this.BLLProvider.EmployeeBLL.GetCount(t => t.TitleId == id); break; case EDictType.职称等级: count = this.BLLProvider.EmployeeBLL.GetCount(t => t.TitleLevelId == id); break; case EDictType.职位: count = this.BLLProvider.EmployeeBLL.GetCount(t => t.DutyId == id); break; } if (count > 0) { rlt = 14; } #endregion } if (rlt == 1) { #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "DataDictionary"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = logUserId; sysLogModel.CreateUserName = logUserName; sysLogModel.ObjectId = id; sysLogModel.OperationType = EOperationType.除.GetHashCode(); var entry = ctx.Entry(model); if (rlt == 1 && !this.BLLProvider.SysLogBLL.Add(ctx, sysLogModel, entry)) { rlt = 0; } #endregion if (!dal.Delete(ctx, model)) { rlt = 0; } } if (rlt == 1) { TranContext.Commit(ctx); } else { TranContext.Rollback(ctx); } } catch (Exception ex) { rlt = 0; TranContext.Rollback(ctx); this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } } return(rlt); }
/// <summary> /// 添加 /// </summary> /// <param name="model"></param> /// <returns> /// 0 失败 /// 1 成功 /// 17 账号重复 /// 13 编码重复 /// </returns> public int Add(UserInfo model) { int rlt = 1; if (IsRepeatAccount(model.Account, model.ID)) { rlt = 17; } if (rlt == 1 && IsRepeatCode(model.Code, model.ID)) { rlt = 13; } if (rlt == 1) { using (var ctx = TranContext.BeginTran()) { try { model.ID = this.GetNewID(); string md5Pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(model.Account, "MD5").Substring(0, 20); model.Password = md5Pwd; #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "UserInfo"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = model.ModifyUserId; sysLogModel.CreateUserName = model.ModifyUserName; sysLogModel.ObjectId = model.ID; sysLogModel.OperationType = EOperationType.新增.GetHashCode(); var entry = ctx.Entry(model); if (rlt == 1 && !this.BLLProvider.SysLogBLL.Add(ctx, sysLogModel, entry)) { rlt = 0; } #endregion if (rlt == 1 && !dal.Insert(ctx, model)) { rlt = 0; } if (rlt == 1) { TranContext.Commit(ctx); } else { TranContext.Rollback(ctx); } } catch (Exception ex) { rlt = 0; TranContext.Rollback(ctx); this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } } } return(rlt); }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns> /// 0操作失败,请联系管理员 /// 1操作成功 /// 11当前对象已不存在 /// 17账号重复 /// 13编码重复 /// </returns> public int Edit(UserInfo model) { int rlt = 1; using (var ctx = TranContext.BeginTran()) { try { var oldModel = dal.GetModel(ctx, t => t.ID == model.ID); if (oldModel == null) { rlt = 11; } if (rlt == 1 && IsRepeatAccount(model.Account, model.ID)) { rlt = 17; } if (rlt == 1 && IsRepeatCode(model.Code, model.ID)) { rlt = 13; } if (rlt == 1) { #region Model oldModel.Name = model.Name; oldModel.Spell = model.Spell; oldModel.Alias = model.Alias; oldModel.RoleId = model.RoleId; oldModel.Gender = model.Gender; oldModel.Mobile = model.Mobile; oldModel.Telephone = model.Telephone; oldModel.Birthday = model.Birthday; oldModel.Email = model.Email; oldModel.OICQ = model.OICQ; oldModel.DutyId = model.DutyId; oldModel.TitleId = model.TitleId; oldModel.CompanyId = model.CompanyId; oldModel.DepartmentId = model.DepartmentId; oldModel.WorkgroupId = model.WorkgroupId; oldModel.Remark = model.Remark; oldModel.IsEnable = model.IsEnable; oldModel.SortIndex = model.SortIndex; oldModel.ModifyDate = DateTime.Now; oldModel.ModifyUserId = model.ModifyUserId; oldModel.ModifyUserName = model.ModifyUserName; #endregion #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "UserInfo"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = model.ModifyUserId; sysLogModel.CreateUserName = model.ModifyUserName; sysLogModel.ObjectId = model.ID; sysLogModel.OperationType = EOperationType.修改.GetHashCode(); var entry = ctx.Entry(oldModel); if (rlt == 1 && !this.BLLProvider.SysLogBLL.Add(ctx, sysLogModel, entry)) { rlt = 0; } #endregion if (rlt == 1 && !dal.Insert(ctx, oldModel)) { rlt = 0; } } if (rlt == 1) { TranContext.Commit(ctx); } else { TranContext.Rollback(ctx); } } catch (Exception ex) { rlt = 0; TranContext.Rollback(ctx); this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } } return(rlt); }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns> /// 0操作失败,请联系管理员 /// 1操作成功 /// 11当前对象已不存在 /// 12名称重复 /// 13编码重复 /// </returns> public int Edit(MenuInfo model) { int rlt = 1; using (var ctx = TranContext.BeginTran()) { try { var oldModel = dal.GetModel(ctx, t => t.ID == model.ID); if (oldModel == null) { rlt = 11; } if (rlt == 1 && IsRepeatName(model.SystemId, model.Name, model.ID)) { rlt = 12; } if (rlt == 1 && IsRepeatCode(model.SystemId, model.Code, model.ID)) { rlt = 13; } if (rlt == 1) { oldModel.Name = model.Name; oldModel.Code = model.Code; oldModel.ParentId = model.ParentId; oldModel.Category = model.Category; oldModel.PurviewId = model.PurviewId; oldModel.Icon = model.Icon; oldModel.IconUrl = model.IconUrl; oldModel.NavigateUrl = model.NavigateUrl; oldModel.FormName = model.FormName; oldModel.IsSplit = model.IsSplit; oldModel.Remark = model.Remark; oldModel.IsEnable = model.IsEnable; oldModel.SortIndex = model.SortIndex; oldModel.ModifyDate = DateTime.Now; oldModel.ModifyUserId = model.ModifyUserId; oldModel.ModifyUserName = model.ModifyUserName; #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "MenuInfo"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = model.ModifyUserId; sysLogModel.CreateUserName = model.ModifyUserName; sysLogModel.ObjectId = model.ID; sysLogModel.OperationType = EOperationType.修改.GetHashCode(); var entry = ctx.Entry(oldModel); if (rlt == 1 && !this.BLLProvider.SysLogBLL.Add(ctx, sysLogModel, entry)) { rlt = 0; } #endregion if (rlt == 1 && !dal.Insert(ctx, oldModel)) { rlt = 0; } } if (rlt == 1) { TranContext.Commit(ctx); } else { TranContext.Rollback(ctx); } } catch (Exception ex) { rlt = 0; TranContext.Rollback(ctx); this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } } return(rlt); }
/// <summary> /// 修改 /// </summary> /// <param name="model"></param> /// <returns> /// 0操作失败,请联系管理员 /// 1操作成功 /// 13编码重复</returns> public int Edit(Employee model) { int rlt = 1; using (var ctx = TranContext.BeginTran()) { try { var oldModel = dal.GetModel(ctx, t => t.ID == model.ID); if (rlt == 1 && IsRepeatCode(model.Code, model.ID)) { rlt = 13; } if (rlt == 1) { #region RegionName oldModel.Name = model.Name; oldModel.Code = model.Code; oldModel.Spell = model.Spell; oldModel.Alias = model.Alias; oldModel.Age = model.Age; oldModel.Birthday = model.Birthday; oldModel.Gender = model.Gender; oldModel.SubCompanyId = model.SubCompanyId; oldModel.CompanyId = model.CompanyId; oldModel.DepartmentId = model.DepartmentId; oldModel.WorkgroupId = model.WorkgroupId; oldModel.DutyId = model.DutyId; oldModel.IDCard = model.IDCard; oldModel.BankCode = model.BankCode; oldModel.Email = model.Email; oldModel.Mobile = model.Mobile; oldModel.ShortNumber = model.ShortNumber; oldModel.Telephone = model.Telephone; oldModel.OICQ = model.OICQ; oldModel.OfficePhone = model.OfficePhone; oldModel.OfficeZipCode = model.OfficeZipCode; oldModel.OfficeAddress = model.OfficeAddress; oldModel.OfficeFax = model.OfficeFax; oldModel.EducationId = model.EducationId; oldModel.School = model.School; oldModel.GraduationDate = model.GraduationDate; oldModel.Major = model.Major; oldModel.DegreeId = model.DegreeId; oldModel.TitleId = model.TitleId; oldModel.TitleDate = model.TitleDate; oldModel.TitleLevelId = model.TitleLevelId; oldModel.WorkingDate = model.WorkingDate; oldModel.JoinInDate = model.JoinInDate; oldModel.HomeZipCode = model.HomeZipCode; oldModel.HomeAddress = model.HomeAddress; oldModel.HomePhone = model.HomePhone; oldModel.HomeFax = model.HomeFax; oldModel.Province = model.Province; oldModel.City = model.City; oldModel.Area = model.Area; oldModel.NativePlace = model.NativePlace; oldModel.PartyId = model.PartyId; oldModel.NationId = model.NationId; oldModel.NationalityId = model.NationalityId; oldModel.WorkingPropertyId = model.WorkingPropertyId; oldModel.Competency = model.Competency; oldModel.EmergencyContact = model.EmergencyContact; oldModel.IsDimission = model.IsDimission; oldModel.DimissionDate = model.DimissionDate; oldModel.DimissionCause = model.DimissionCause; oldModel.DimissionWhither = model.DimissionWhither; oldModel.Remark = model.Remark; oldModel.SortIndex = model.SortIndex; oldModel.ModifyDate = DateTime.Now; oldModel.ModifyUserId = model.ModifyUserId; oldModel.ModifyUserName = model.ModifyUserName; #endregion #region 系统日志 SysLog sysLogModel = new SysLog(); sysLogModel.TableName = "DataDictionary"; sysLogModel.BusinessName = DatabasePDMHelper.GetDataTableName(sysLogModel.TableName); sysLogModel.CreateUserId = model.ModifyUserId; sysLogModel.CreateUserName = model.ModifyUserName; sysLogModel.ObjectId = model.ID; sysLogModel.OperationType = EOperationType.修改.GetHashCode(); var entry = ctx.Entry(oldModel); if (rlt == 1 && !this.BLLProvider.SysLogBLL.Add(ctx, sysLogModel, entry)) { rlt = 0; } #endregion if (rlt == 1 && !dal.Insert(ctx, oldModel)) { rlt = 0; } } if (rlt == 1) { TranContext.Commit(ctx); } else { TranContext.Rollback(ctx); } } catch (Exception ex) { rlt = 0; TranContext.Rollback(ctx); this.BLLProvider.SystemExceptionLogBLL.Add(ex.Source, ex.InnerException.Message, ex.Message); } } return(rlt); }