/// <summary> /// 查询组织机构信息 /// </summary> /// <param name="deptID">组织机构ID</param> /// <returns></returns> public static DataTable GetDeptInfoWithID(string deptID) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //获取公司代码 string companyCD = userInfo.CompanyCD; return(DeptInfoDBHelper.GetDeptInfoWithID(deptID, companyCD)); }
/// <summary> /// 判断此部门是否有人员 /// </summary> /// <param name="deptID"></param> /// <returns></returns> public static int ISHavePerson(string deptID) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //获取公司代码 string companyCD = userInfo.CompanyCD; //执行查询 return(DeptInfoDBHelper.ISHavePerson(companyCD, deptID)); }
/// <summary> /// 是否被岗位表里引用 /// </summary> /// <param name="deptID"></param> /// <returns></returns> public static DataTable ISDequter(string deptID) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //获取公司代码 string companyCD = userInfo.CompanyCD; //执行查询 return(DeptInfoDBHelper.ISDequter(companyCD, deptID)); }
/// <summary> /// 根据主键获取部门名称 /// </summary> /// <param name="ID">主键</param> /// <returns>部门名称</returns> public static string GetDeptNameByID(string ID) { if (string.IsNullOrEmpty(ID)) { return(""); } DataTable dt = DeptInfoDBHelper.GetDeptNameByID(ID); string DeptName = ""; if (dt != null && dt.Rows.Count > 0) { DeptName = dt.Rows[0]["DeptName"].ToString(); } return(DeptName); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { hidModuleID.Value = ConstUtil.MODULE_ID_HUMAN_PERFORMANCEGRADELIST; string requestParam = Request.QueryString.ToString(); //通过参数个数来判断是否从菜单过来 int firstIndex = requestParam.IndexOf("&"); //从列表过来时 if (firstIndex > 0) { //返回按钮可见 //获取列表的查询条件 string searchCondition = requestParam.Substring(firstIndex); //设置检索条件 hidSearchCondition.Value = searchCondition; } else { //返回按钮不可见 } if (Request.QueryString["hidIsliebiao"] != null) { hidIsliebiao.Value = "1"; } if (Request.QueryString["TaskNo"] != null && Request.QueryString["EmployeeID"] != null && Request.QueryString["TemplateNo"] != null) { hidElemID.Value = Request.QueryString["TaskNo"].ToString(); hiEmpl.Value = Request.QueryString["EmployeeID"].ToString(); hidTemplateNo.Value = Request.QueryString["TemplateNo"].ToString(); DataTable dt = DeptInfoDBHelper.GetEmployeeByID(Request.QueryString["EmployeeID"].ToString()); string s = string.Empty; if (dt.Rows.Count > 0) { s = "被考核人:" + dt.Rows[0]["EmployeeName"].ToString() + " 所在部门:" + dt.Rows[0]["DeptName"].ToString(); } Emp.InnerHtml = s; } } }
/// <summary> /// 删除组织机构信息 /// </summary> /// <param name="deptID">组织机构ID</param> /// <returns></returns> public static bool DeleteDeptInfo(string deptID) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //设置公司代码 string CompanyCD = userInfo.CompanyCD; //执行删除操作 bool isSucc = DeptInfoDBHelper.DeleteDeptInfo(deptID, CompanyCD); //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } //操作日志 LogInfoModel logModel = InitLogInfo(deptID); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_DELETE; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return(isSucc); }
/// <summary> /// 编辑组织机构信息 /// </summary> /// <param name="model">保存信息</param> /// <returns></returns> public static bool SaveDeptInfo(DeptModel model) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //设置公司代码 model.CompanyCD = userInfo.CompanyCD; model.ModifiedUserID = userInfo.UserID; //定义返回变量 bool isSucc = false; //操作日志 LogInfoModel logModel = InitLogInfo(model.DeptNO); //更新 if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag)) { try { logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //执行更新操作 isSucc = DeptInfoDBHelper.UpdateDeptInfo(model); } catch (Exception ex) { //输出系统日志 WriteSystemLog(userInfo, ex); } } //插入 else { try { logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //执行插入操作 isSucc = DeptInfoDBHelper.InsertDeptInfo(model); } catch (Exception ex) { //输出系统日志 WriteSystemLog(userInfo, ex); } } //更新成功时 if (isSucc) { //设置操作成功标识 logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS; } //更新不成功 else { //设置操作成功标识 logModel.Remark = ConstUtil.LOG_PROCESS_FAILED; } //登陆日志 LogDBHelper.InsertLog(logModel); return(isSucc); }
/// <summary> /// 根据主键获取部门名称 /// </summary> /// <param name="ID">主键</param> /// <returns>部门名称</returns> public static DataTable GetDeptinfoByNo(string deptNo) { return(DeptInfoDBHelper.GetDeptinfoByNo(deptNo)); }