public string ModifyJobFunc(string pRequest) { var rd = new APIResponse <ModifyJobFuncRD>(); var rdData = new ModifyJobFuncRD(); var rp = pRequest.DeserializeJSONTo <APIRequest <ModifyJobFuncRP> >(); if (rp.Parameters == null) { throw new ArgumentException(); } if (rp.Parameters != null) { rp.Parameters.Validate(); } var loggingSessionInfo = new LoggingSessionManager().CurrentSession; try { JobFunctionBLL jobBll = new JobFunctionBLL(loggingSessionInfo); JobFunctionEntity entity = jobBll.GetByID(rp.Parameters.JobFunctionID); if (entity != null) { entity.Name = rp.Parameters.Name; entity.Description = rp.Parameters.Description; if (rp.Parameters.Status != null) { entity.Status = rp.Parameters.Status; } jobBll.Update(entity); rdData.IsSuccess = true; rd.ResultCode = 0; } else { rdData.IsSuccess = false; rd.ResultCode = 101; rd.Message = "职衔不存在"; } } catch (Exception ex) { rd.ResultCode = 103; rd.Message = ex.Message; } rd.Data = rdData; return(rd.ToJSON()); }
public string AddJobFunc(string pRequest) { var rd = new APIResponse <AddJobFuncRD>(); var rdData = new AddJobFuncRD(); var rp = pRequest.DeserializeJSONTo <APIRequest <AddJobFuncRP> >(); if (rp.Parameters == null) { throw new ArgumentException(); } if (rp.Parameters != null) { rp.Parameters.Validate(); } var loggingSessionInfo = Default.GetBSLoggingSession(rp.CustomerID, rp.UserID); try { JobFunctionBLL jobBll = new JobFunctionBLL(loggingSessionInfo); Guid guid = Guid.NewGuid(); JobFunctionEntity entity = new JobFunctionEntity { JobFunctionID = guid, Name = rp.Parameters.Name, Description = rp.Parameters.Description, Status = rp.Parameters.Status, CustomerID = rp.CustomerID }; jobBll.Create(entity); rdData.JobFunctionID = guid.ToString(); rd.ResultCode = 0; } catch (Exception ex) { rd.ResultCode = 103; rd.Message = ex.Message; } rd.Data = rdData; return(rd.ToJSON()); }
public string Export(LoggingSessionInfo pLoggingSessionInfo, string pPath) { try { string customerID = pLoggingSessionInfo.ClientID; string userID = pLoggingSessionInfo.CurrentUser.User_Id; ////下载保存获取本地路径 //string localPath = string.Empty; //DownloadFile(pPath, "", out localPath); //pPath = localPath; string path = HttpContext.Current.Server.MapPath(@"~"); pPath = path + pPath; #region 读取Excel数据并简单过滤 System.IO.FileInfo exporstFile = new System.IO.FileInfo(pPath); if (!exporstFile.Exists) { return("0|文件不存在"); } //读取Excel DataTable excelTable = ExcelReader.ReadExcelToDataTable(pPath); //return "0|" + excelTable.Rows[0][0]; //过滤空行 DataRow[] drs = excelTable.Select("邮箱<>''"); DataTable dtClone = excelTable.Clone(); foreach (var row in drs) { dtClone.ImportRow(row); } #endregion #region 获取职衔、部门、角色 DataView _dv = dtClone.DefaultView; DataTable jobFuncDT = _dv.ToTable(true, "职衔"); DataTable deptDT = _dv.ToTable(true, "部门"); DataTable roleDT = _dv.ToTable(true, "角色"); #endregion #region 职衔验证 var jobFuncBll = new JobFunctionBLL(pLoggingSessionInfo); var jobFuncList = jobFuncBll.Query(new IWhereCondition[] { new EqualsCondition { DateTimeAccuracy = null, FieldName = "CustomerID", Value = customerID }, new EqualsCondition { DateTimeAccuracy = null, FieldName = "IsDelete", Value = "0" }, new EqualsCondition { DateTimeAccuracy = null, FieldName = "Status", Value = "1" } }, null); foreach (DataRow row in jobFuncDT.Rows) { if (row["职衔"] == null || string.IsNullOrEmpty(row["职衔"].ToString())) { continue; } int count = jobFuncList.Count(job => job.Name == row["职衔"].ToString().Trim()); if (count <= 0) { JobFunctionEntity entity = new JobFunctionEntity { Name = row["职衔"].ToString().Trim(), Description = "", JobFunctionID = Guid.NewGuid(), Status = 1, IsDelete = 0, CustomerID = customerID }; jobFuncBll.Create(entity); //return "0|职衔不存在"; } } #endregion #region 部门验证 string typeID = System.Configuration.ConfigurationManager.AppSettings["TypeID"].ToString(); TUnitBLL deptBll = new TUnitBLL(pLoggingSessionInfo); var deptList = deptBll.Query(new IWhereCondition[] { new EqualsCondition { DateTimeAccuracy = null, FieldName = "customer_id", Value = customerID }, new EqualsCondition { DateTimeAccuracy = null, FieldName = "type_id", Value = typeID }, new EqualsCondition { DateTimeAccuracy = null, FieldName = "Status", Value = "1" } }, null); foreach (DataRow row in deptDT.Rows) { if (row["部门"] == null || string.IsNullOrEmpty(row["部门"].ToString())) { continue; } int count = deptList.Count(dept => dept.UnitName == row["部门"].ToString().Trim()); if (count <= 0) { TUnitEntity unitEntity = new TUnitEntity { UnitID = Guid.NewGuid().ToString().Replace("-", ""), UnitName = row["部门"].ToString().Trim(), UnitCode = "1", UnitContact = "", UnitRemark = "", TypeID = typeID, CreateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), CreateUserID = pLoggingSessionInfo.CurrentUser.User_Id, ModifyTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), ModifyUserID = pLoggingSessionInfo.CurrentUser.User_Id, CustomerID = pLoggingSessionInfo.CurrentUser.customer_id, CUSTOMERLEVEL = 0, Status = "1", StatusDesc = "正常", IfFlag = "1" }; deptBll.Create(unitEntity); //return "0|部门不存在"; } } #endregion #region 角色验证 RoleService rs = new RoleService(pLoggingSessionInfo); IList <RoleModel> roleList = rs.GetAllRoles(); foreach (DataRow row in roleDT.Rows) { if (row["角色"] == null || string.IsNullOrEmpty(row["角色"].ToString())) { continue; } int count = roleList.Count(role => role.Role_Name == row["角色"].ToString().Trim()); if (count <= 0) { return("0|角色不存在"); } } #endregion return(ExportData(customerID, pLoggingSessionInfo, dtClone, jobFuncList, deptList, roleList)); } catch (Exception ex) { return("0|" + ex.Message); } }
/// <summary> /// 更新 /// </summary> /// <param name="pEntity">实体实例</param> /// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param> public void Update(JobFunctionEntity pEntity, IDbTransaction pTran) { Update(pEntity, true, pTran); }
public void Update(JobFunctionEntity pEntity, bool pIsUpdateNullField, IDbTransaction pTran) { _currentDAO.Update(pEntity, pIsUpdateNullField, pTran); }
/// <summary> /// 创建一个新实例 /// </summary> /// <param name="pEntity">实体实例</param> public void Create(JobFunctionEntity pEntity) { _currentDAO.Create(pEntity); }
/// <summary> /// 在事务内创建一个新实例 /// </summary> /// <param name="pEntity">实体实例</param> /// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param> public void Create(JobFunctionEntity pEntity, IDbTransaction pTran) { _currentDAO.Create(pEntity, pTran); }
/// <summary> /// 分页根据实体条件查询实体 /// </summary> /// <param name="pQueryEntity">以实体形式传入的参数</param> /// <param name="pOrderBys">排序组合</param> /// <returns>符合条件的实体集</returns> public PagedQueryResult <JobFunctionEntity> PagedQueryByEntity(JobFunctionEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex) { return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex)); }
/// <summary> /// 根据实体条件查询实体 /// </summary> /// <param name="pQueryEntity">以实体形式传入的参数</param> /// <param name="pOrderBys">排序组合</param> /// <returns>符合条件的实体集</returns> public JobFunctionEntity[] QueryByEntity(JobFunctionEntity pQueryEntity, OrderBy[] pOrderBys) { return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys)); }
/// <summary> /// 删除 /// </summary> /// <param name="pEntity"></param> public void Delete(JobFunctionEntity pEntity) { _currentDAO.Delete(pEntity); }
public void Update(JobFunctionEntity pEntity, bool pIsUpdateNullField) { _currentDAO.Update(pEntity, pIsUpdateNullField); }
/// <summary> /// 更新 /// </summary> /// <param name="pEntity">实体实例</param> public void Update(JobFunctionEntity pEntity) { Update(pEntity, true); }