/*绑定主表信息*/
protected void BindMainInfo()
{
/*接受参数*/
string OrderNo = Request.QueryString["no"].ToString();
/*读取数据*/
DataTable dt = TrainingBus.GetRepOrder(OrderNo);
string strEmployee = string.Empty;//参与培训的人员
DataTable dtEmployee = TrainingBus.GetRepTrainingUser(OrderNo);
for (int i = 0; i < dtEmployee.Rows.Count; i++)
{
strEmployee += dtEmployee.Rows[i]["EmployeeName"].ToString() + ",";
}
if (strEmployee.Length > 0)
{
strEmployee = strEmployee.Remove(strEmployee.Length - 1, 1);
}
if (dt.Rows.Count > 0)
{
dt.Rows[0]["ModifiedUserID"] = strEmployee;
}
DataTable dtDetail = TrainingBus.GetRepOrderDetail(OrderNo);
/*绑定RPT*/
if (dt != null)
{
/*加载主报表*/
rd.Load(Server.MapPath(@"~/PrinttingModel/HumanManager/EmployeeTraining.rpt"));
crViewer.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.EmployeeTraining"));
/*加载子报表*/
ReportDocument rdDetail = rd.Subreports["TrainingSchedule.rpt"];
rdDetail.SetDataSource(dtDetail);
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//绑定数据
rd.SetDataSource(dt);
rd.Refresh();
this.crViewer.ReportSource = rd;
rd.SetParameterValue("Today", "制表人：" + userInfo.EmployeeName);
}
}
protected void btnImport_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "asc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ID"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "desc";//排序：降序
}
string ord = " ORDER BY " + orderBy + " " + order;
//获取数据
TrainingSearchModel searchModel = new TrainingSearchModel();
//设置查询条件
//培训编号
searchModel.TrainingNo = txtTrainingNo.Value.Trim();
//培训名称
searchModel.TrainingName = txtTrainingName.Value.Trim();
//培训方式
searchModel.TrainingWayID = ddlTrainingWay.SelectedValue;
//开始时间
searchModel.StartDate = txtStartDate.Text.Trim();
searchModel.StartToDate = txtAsseEndDate.Text.Trim();
//查询数据
DataTable dt = TrainingBus.SearchTrainingInfo(searchModel);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "培训编号", "培训名称", "培训方式", "培训老师", "开始时间", "结束时间", "培训地点" },
new string[] { "TrainingNo", "TrainingName", "TrainingWayName", "TrainingTeacher", "StartDate", "EndDate", "TrainingPlace" },
"培训列表");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
/// <summary>
/// 类名：TrainingAsse_Edit
/// 描述：新建培训考核处理
///
/// 作者：吴志强
/// 创建时间：2009/04/03
/// 最后修改时间：2009/04/03
/// </summary>
///
#region Page_Load
protected void Page_Load(object sender, EventArgs e)
{
//页面初期表示
if (!IsPostBack)
{
#region 新建、修改共通处理
//ddlCheckWay.TypeFlag = ConstUtil.CODE_TYPE_HUMAN;
//ddlCheckWay.TypeCode = ConstUtil.CODE_TYPE_CHECK_WAY;
//获取培训信息
DataTable dtTraning = TrainingBus.SearchOnTrainingInfo();
//设定培训信息控件的数据源
ddlTraining.DataSource = dtTraning;
//指定培训信息控件的Value值
ddlTraining.DataValueField = "TrainingNo";
//指定培训信息控件的Text表示值
ddlTraining.DataTextField = "TrainingName";
//绑定培训信息控件
ddlTraining.DataBind();
//添加一请选择选项
//ListItem Item = new ListItem(ConstUtil.CODE_TYPE_INSERT_TEXT, ConstUtil.CODE_TYPE_INSERT_VALUE);
//ddlTraining.Items.Insert(0, Item);
//给控件添加onchange事件
ddlTraining.Attributes.Add("onchange", "GetJoinUserInfo();");
//设置模块ID
hidModuleID.Value = ConstUtil.MODULE_ID_HUMAN_TRAININGASSE_INFO;
//获取请求参数
string requestParam = Request.QueryString.ToString();
//通过参数个数来判断是否从菜单过来
int firstIndex = requestParam.IndexOf("&");
string from = string.Empty;
//从列表过来时
if (firstIndex > 0)
{
//返回按钮可见
btnBack.Visible = true;
//获取列表的查询条件
string searchCondition = requestParam.Substring(firstIndex);
//设置检索条件
hidSearchCondition.Value = searchCondition;
//获取跳转前页面
from = Request.QueryString["From"];
//链接过来的页面
hidFrom.Value = from;
//培训列表页面过来时
if (!string.IsNullOrEmpty(from) && "1".Equals(from))
{
//设置培训列表模块ID
hidModuleIDTraining.Value = ConstUtil.MODULE_ID_HUMAN_TRAINING_INFO;
//设置培训编号
ddlTraining.SelectedValue = Request.QueryString["SelectTrainingNo"];
}
}
else
{
//返回按钮不可见
btnBack.Visible = false;
}
//设置当前日期
hidTodayDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
#endregion
//获取培训考核ID
string trainingAsseID = Request.QueryString["TrainingAsseID"];
//培训考核ID为空，为新建模式
if (string.IsNullOrEmpty(trainingAsseID))
{
#region 新建时初期处理
//编号初期处理
codruleTrainingAsse.CodingType = ConstUtil.CODING_TYPE_HUMAN;
codruleTrainingAsse.ItemTypeID = ConstUtil.CODING_HUMAN_ITEM_RTRAININGASSE;
//设置培训考核编号不可见
divTrainingAsseNo.Attributes.Add("style", "display:none;");
//自动生成编号的控件设置为可见
divCodeRule.Attributes.Add("style", "display:block;");
//填写人
//从session中获取登陆用户信息
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
//设置用户名
txtFillUserName.Text = userInfo.EmployeeName;
//设置用户ID
hidFillUserID.Value = userInfo.EmployeeID.ToString();
//考核结果
divRsseResultDetail.InnerHtml = CreateResultTable() + EndTable();
//设置编辑模式
hidEditFlag.Value = ConstUtil.EDIT_FLAG_INSERT;
if (!"1".Equals(from))
{
ddlTraining.SelectedIndex = 0;
}
ClientScript.RegisterStartupScript(this.GetType(), "GetJoinUserInfo"
, "<script language=javascript>GetJoinUserInfo();</script>");
#endregion
}
else
{
#region 修改时初期处理
//设置标题
divTitle.InnerText = "培训考核";
//设置培训考核编号可见
divTrainingAsseNo.Attributes.Add("style", "display:block;");
//自动生成编号的控件设置为不可见
divCodeRule.Attributes.Add("style", "display:none;");
//获取并设置培训信息
InitTrainingAsseInfo(trainingAsseID);
//设置编辑模式
hidEditFlag.Value = ConstUtil.EDIT_FLAG_UPDATE;
#endregion
}
}
}
/// <summary>
/// 根据培训ID，获取培训信息，并设置到页面显示
/// </summary>
/// <param name="trainingID">培训ID</param>
private void InitTrainingInfo(string trainingID)
{
//设置培训编号可见
divTrainingNo.Attributes.Add("style", "display:block;");
//自动生成编号的控件设置为不可见
divCodeRule.Attributes.Add("style", "display:none;");
//查询培训信息
DataSet dsTrainingInfo = TrainingBus.GetTrainingInfoWithID(trainingID);
//获取培训基本信息
DataTable dtBaseInfo = dsTrainingInfo.Tables[0];
//基本信息存在时
if (dtBaseInfo != null && dtBaseInfo.Rows.Count > 0)
{
#region 设置培训基本信息
//培训编号
divTrainingNo.InnerHtml = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TrainingNo");
//培训名称
txtTrainingName.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TrainingName");
//发起时间
txtApplyDate.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "ApplyDate");
//发起人
UserCreaterName.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "EmployeeName");
txtCreateID.Value = GetSafeData.GetStringFromInt(dtBaseInfo.Rows[0], "EmployeeID");
//项目编号
txtProjectNo.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "ProjectNo");
//项目名称
txtProjectName.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "ProjectName");
//培训机构
txtTrainingOrgan.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TrainingOrgan");
//预算费用
txtPlanCost.Text = GetSafeData.GetStringFromDecimal(dtBaseInfo.Rows[0], "PlanCost");
//培训天数
txtTrainingCount.Text = GetSafeData.GetStringFromInt(dtBaseInfo.Rows[0], "TrainingCount");
//培训地点
txtTrainingPlace.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TrainingPlace");
//培训方式
ddlTrainingWay.SelectedValue = GetSafeData.GetStringFromInt(dtBaseInfo.Rows[0], "TrainingWay");
//培训老师
txtTrainingTeacher.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TrainingTeacher");
//开始时间
txtStartDate.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "StartDate");
//结束时间
txtEndDate.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "EndDate");
//考核人
txtCheckPerson.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "CheckPerson");
//附件
string attatchment = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Attachment");
hfAttachment.Value = attatchment;
hfPageAttachment.Value = attatchment;
//设置下载 上传的显示
if (string.IsNullOrEmpty(attatchment))
{
//简历处理不显示
divDealAttachment.Attributes.Add("style", "display:none;");
//上传简历显示
divUploadAttachment.Attributes.Add("style", "display:block;");
}
else
{
//上传简历不显示
divUploadAttachment.Attributes.Add("style", "display:none;");
//简历处理显示
divDealAttachment.Attributes.Add("style", "display:block;");
}
spanAttachmentName.InnerHtml = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "AttachmentName");
//目的
txtGoal.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Goal");
//培训备注
txtTrainingRemark.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TrainingRemark");
#endregion
//设置参与人员
InitJionUserInfo(dsTrainingInfo.Tables[1]);
//设置招聘目标
InitScheduleInfo(dsTrainingInfo.Tables[2]);
}
}
