/// <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));
}
