/// <summary> /// 获取公司岗位信息 /// </summary> /// <returns></returns> public static DataTable GetQuarterInfoWithCompanyCD() { //公司代码 string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; return(DeptQuarterDBHelper.GetQuarterInfoWithCompanyCD(companyCD)); }
/// <summary> /// 通过机构ID获取岗位信息 /// </summary> /// <param name="deptID"></param> /// <returns></returns> public static string GetQuarterInfoWithDeptID(string deptID, string quarterID) { //变量定义 StringBuilder sbDeptQuarterInfo = new StringBuilder(); //获取公司代码 string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; //获取机构岗位信息 DataTable dtDeptQuarterInfo = DeptQuarterDBHelper.GetQuarterInfoWithDeptID(deptID, quarterID, companyCD); //机构岗位数据存在时 if (dtDeptQuarterInfo != null && dtDeptQuarterInfo.Rows.Count > 0) { //生成岗位信息 sbDeptQuarterInfo.Append(GetQuarterTreeInfo(dtDeptQuarterInfo)); } //机构岗位信息不存在时 else { //生成子树代码 sbDeptQuarterInfo.Append("<table border='0' cellpadding='0' cellspacing='0'><tr><td>"); sbDeptQuarterInfo.Append("<div id='divDQuarterName_" + deptID + "' onclick=\"SetSelectValue('','','','" + deptID + "');\"> </div>"); sbDeptQuarterInfo.Append("</td></tr></table>"); } //返回机构岗位信息 return(sbDeptQuarterInfo.ToString()); }
/// <summary> /// 查询机构岗位信息 /// </summary> /// <param name="quarterID">机构岗位ID</param> /// <returns></returns> public static DataTable GetDeptQuarterInfoWithID(string quarterID) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //设置公司代码 string CompanyCD = userInfo.CompanyCD; return(DeptQuarterDBHelper.GetDeptQuarterInfoWithID(quarterID, CompanyCD)); }
public static DataTable GetQuarterModelSet(string DeptID, string QuarterNo) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //设置公司代码 string CompanyCD = userInfo.CompanyCD; return(DeptQuarterDBHelper.GetQuarterModelSet(DeptID, QuarterNo, CompanyCD)); }
/// <summary> /// 查询机构岗位信息 /// </summary> /// <param name="quarterID">机构岗位ID</param> /// <returns></returns> public static DataTable GetSubQuarterInfoWithID(string quarterID) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //设置公司代码 string CompanyCD = userInfo.CompanyCD; //执行查询 DataTable dtQuarterInfo = DeptQuarterDBHelper.SearchQuarterInfo(quarterID, CompanyCD); //返回 return(dtQuarterInfo); }
public static bool SaveQuarterSet(IList <QuterModuleSetModel> QuterModuleSetList) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //定义返回变量 bool isSucc = false; //执行插入操作 isSucc = DeptQuarterDBHelper.SaveQuarterSet(QuterModuleSetList); return(isSucc); }
/// <summary> /// 删除机构岗位信息 /// </summary> /// <param name="quarterID">组织机构ID</param> /// <returns></returns> public static bool DeleteDeptQuarterInfo(string quarterID) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //设置公司代码 string CompanyCD = userInfo.CompanyCD; //执行删除操作 bool isSucc = DeptQuarterDBHelper.DeleteQuarterInfo(quarterID, CompanyCD); //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } //操作日志 LogInfoModel logModel = InitLogInfo(quarterID); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 logModel.Element = ConstUtil.LOG_PROCESS_DELETE; //设置操作成功标识 logModel.Remark = remark; //登陆日志 LogDBHelper.InsertLog(logModel); return(isSucc); }
/// <summary> /// 获取机构岗位分类的方法 /// </summary> /// <param name="CompanyCD"></param> /// <returns></returns> public static DataTable GetQuarterType() { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; return(DeptQuarterDBHelper.GetQuarterType(userInfo.CompanyCD)); }
/// <summary> /// 编辑机构岗位信息 /// </summary> /// <param name="model">保存信息</param> /// <returns></returns> public static bool SaveDeptQuarterInfo(DeptQuarterModel model) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //设置公司代码 model.CompanyCD = userInfo.CompanyCD; model.ModifiedUserID = userInfo.UserID; //定义返回变量 bool isSucc = false; //操作日志 LogInfoModel logModel = InitLogInfo(model.QuarterNo); //更新 if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag)) { try { logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //执行更新操作 isSucc = DeptQuarterDBHelper.UpdateDeptQuarterInfo(model); } catch (Exception ex) { //输出系统日志 WriteSystemLog(userInfo, ex); } } //插入 else { try { logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //执行插入操作 isSucc = DeptQuarterDBHelper.InsertDeptQuarterInfo(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); }
public static DataTable selectQuarterSet(string DescibleID) { return(DeptQuarterDBHelper.selectQuarterSet(DescibleID)); }
public static DataTable GetQuarterDescrible( ) { return(DeptQuarterDBHelper.GetQuarterDescrible()); }