/// <summary> /// 查询仍在培训中的培训信息 /// </summary> /// <returns></returns> public static DataTable SearchOnTrainingInfo() { //获取公司代码 string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; //执行查询并返回查询值 return(TrainingDBHelper.SearchOnTrainingInfo(companyCD)); }
/// <summary> /// 查询培训的参与人员信息 /// </summary> /// <param name="traningNo">培训编号</param> /// <returns></returns> public static DataTable GetJionUserInfo(string traningNo) { //获取公司代码 string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; //执行查询并返回查询值 return(TrainingDBHelper.GetJionUserInfo(traningNo, companyCD)); }
/// <summary> /// 通过检索条件查询培训信息 /// </summary> /// <param name="model">查询条件</param> /// <returns></returns> public static DataTable SearchTrainingInfo(TrainingSearchModel model) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //设置公司代码 model.CompanyCD = userInfo.CompanyCD; //执行查询并返回查询值 return(TrainingDBHelper.SearchTrainingInfo(model)); }
/// <summary> /// 删除培训信息 /// </summary> /// <param name="trainingNo">培训编号</param> /// <returns></returns> public static bool DeleteTrainingInfo(string trainingNo) { //获取公司代码 string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; //执行删除操作 bool isSucc = TrainingDBHelper.DeleteTrainingInfo(trainingNo, companyCD); //定义变量 string remark; //成功时 if (isSucc) { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_SUCCESS; } else { //设置操作成功标识 remark = ConstUtil.LOG_PROCESS_FAILED; } //获取删除的编号列表 string[] noList = trainingNo.Split(','); //遍历所有编号,登陆操作日志 for (int i = 0; i < noList.Length; i++) { //获取编号 string no = noList[i]; //替换两边的 ' no = no.Replace("'", string.Empty); //操作日志 LogInfoModel logModel = InitLogInfo(no); //涉及关键元素 这个需要根据每个页面具体设置,本页面暂时设置为空 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 SaveTrainingPlanInfo(TrainingModel model) { //获取登陆用户信息 UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //设置公司代码 model.CompanyCD = userInfo.CompanyCD; model.ModifiedUserID = userInfo.UserID; //定义返回变量 bool isSucc = false; //操作日志 LogInfoModel logModel = InitLogInfo(model.TrainingNo); //更新 if (ConstUtil.EDIT_FLAG_UPDATE.Equals(model.EditFlag)) { try { logModel.Element = ConstUtil.LOG_PROCESS_UPDATE; //执行更新操作 isSucc = TrainingDBHelper.UpdateTrainingInfo(model); } catch (Exception ex) { //输出系统日志 WriteSystemLog(userInfo, ex); } } //插入 else { try { logModel.Element = ConstUtil.LOG_PROCESS_INSERT; //执行插入操作 isSucc = TrainingDBHelper.InsertTrainingInfo(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="OrderNo"></param> /// <returns></returns> public static DataTable GetRepOrderDetail(string OrderNo) { return(TrainingDBHelper.GetRepOrderDetail(OrderNo)); }
/// <summary> /// 获取培训人员 /// </summary> /// <param name="OrderNo"></param> /// <returns></returns> public static DataTable GetRepTrainingUser(string OrderNo) { return(TrainingDBHelper.GetRepTrainingUser(OrderNo)); }
/// <summary> /// 培训数量分析 /// </summary> /// <param name="CompanyCD"></param> /// <param name="DeptID"></param> /// <param name="JoinID"></param> /// <param name="BeginDate"></param> /// <param name="EndDate"></param> /// <param name="pageIndex"></param> /// <param name="pageCount"></param> /// <param name="ord"></param> /// <param name="TotalCount"></param> /// <returns></returns> public static DataTable GetTrainingCount(string CompanyCD, string DeptID, string JoinID, string BeginDate, string EndDate, string BDate, string EDate) { return(TrainingDBHelper.GetTrainingCount(CompanyCD, DeptID, JoinID, BeginDate, EndDate, BDate, EDate)); }
/// <summary> /// 根据培训编号查看是否有培训考核信息 /// </summary> /// <param name="trainingNo"></param> /// <returns></returns> public static bool GetAsseByTraNo(string trainingNo) { return(TrainingDBHelper.GetAsseByTraNo(trainingNo)); }
/// <summary> /// 查询培训信息 /// </summary> /// <param name="trainingID">培训ID</param> /// <returns></returns> public static DataSet GetTrainingInfoWithID(string trainingID) { return(TrainingDBHelper.GetTrainingInfoWithID(trainingID)); }