protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
PerformanceBetterModel searchModel = new PerformanceBetterModel();
searchModel.PlanNo = txtSearchTask.Value.Trim();
//启用状态
searchModel.Title = inptSearchTitle.Value.Trim();
searchModel.CreateDate = txtStartDate.Text.Trim();
searchModel.EndDate = txtEndDate.Text.Trim();
searchModel.EmployeeId = txtSearchScoreEmployee.Value;
//启用状态
//查询数据
DataTable dtData = PerformanceBetterBus.SearchPlanInfo(searchModel);
//导出标题
string headerTitle = "计划编号|计划主题|创建人|创建时间";
string[] header = headerTitle.Split('|');
//导出标题所对应的列字段名称
string columnFiled = "PlanNo|Title|Creator|CreateDate";
string[] field = columnFiled.Split('|');
XBase.Common.OutputToExecl.ExportToTable(this.Page, dtData, header, field, "绩效改进列表");
}
private void InitRectPlanInfo(string planID)
{
//设置申请计划编号可见
divRectPalnNo.Attributes.Add("style", "display:block;");
//自动生成编号的控件设置为不可见
txtPerformTmNo.Attributes.Add("style", "display:none;");
//查询招聘计划信息
DataSet dsPlanInfos = PerformanceBetterBus.GetRectPlanInfoWithID(planID);
//获取招聘计划基本信息
DataTable dtBaseInfo = dsPlanInfos.Tables[0];
StringBuilder sbPublishInfo = new StringBuilder();
//基本信息存在时
if (dtBaseInfo != null && dtBaseInfo.Rows.Count > 0)
{
//设置申请计划编号
divRectPalnNo.InnerHtml = dtBaseInfo.Rows[0]["PlanNo"] == null ? "" : dtBaseInfo.Rows[0]["PlanNo"].ToString();
//主题
txtTitle.Value = dtBaseInfo.Rows[0]["Title"] == null ?"":dtBaseInfo.Rows[0]["Title"].ToString();
//创建时间
dvCreateDate.InnerHtml = dtBaseInfo.Rows[0]["CreateDate"] == null ? "" : dtBaseInfo.Rows[0]["CreateDate"].ToString();
divCreater.InnerHtml = dtBaseInfo.Rows[0]["Creator"] == null ? "" : dtBaseInfo.Rows[0]["Creator"].ToString();
txtPlanRemark.Value = dtBaseInfo.Rows[0]["Remark"] == null ? "" : dtBaseInfo.Rows[0]["Remark"].ToString();
for (int i = 0; i < dtBaseInfo.Rows.Count; i++)
{
//插入行开始标识
sbPublishInfo.AppendLine("<tr style='display:block;'>");
//选择框
sbPublishInfo.AppendLine("<td class='tdColInputCenter'><input type='checkbox' id='tbDetail_chkSelect_" + (i + 1).ToString() + "' ></td>");
//员工
sbPublishInfo.AppendLine("<td class='tdColInput'> <input id='UsertxtEmployeeID1" + (i + 1).ToString() + "' size='8' maxlength='50' readonly type='text' value='"
+ GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[i], "EmployeeName") + "' class='tdinput' onclick=alertdiv('UsertxtEmployeeID1" + (i + 1).ToString() + ",txtEmployeeID_" + (i + 1).ToString() + "') />" + "<input id='txtEmployeeID_" + (i + 1).ToString() + "' type='hidden' value='"
+ GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[i], "EmployeeID") + "' /></td>");
//有待改进计划
sbPublishInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='"
+ GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[i], "Content") + "' class='tdinput' id='txtContent_" + (i + 1).ToString() + "'></td>");
// 完成目标
sbPublishInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='"
+ GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[i], "CompleteAim") + "' class='tdinput' id='txtCompleteAim_" + (i + 1).ToString() + "'></td>");
//完成期限
sbPublishInfo.AppendLine("<td class='tdColInputCenter'><input type='text' maxlength = '10' value='"
+ GetSafeData.GetStringFromDateTime(dtBaseInfo.Rows[i], "CompleteDate", "yyyy-MM-dd")
+ "' class='tdinput' id='txtCompleteDate_" + (i + 1).ToString() + "' readonly='readonly' onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('txtCompleteDate_" + (i + 1).ToString() + "')})\"></td>");
//核查人
sbPublishInfo.AppendLine("<td class='tdColInput'><input id='UsertxtChecker1" + (i + 1).ToString() + "' maxlength='50' type='text' value='"
+ GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[i], "CheckerName") + "' class='tdinput' onclick=alertdiv('UsertxtChecker1" + (i + 1).ToString() + ",txtChecker_" + (i + 1).ToString() + "') />" + "<input id='txtChecker_" + (i + 1).ToString() + "' type='hidden' value='"
+ GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[i], "Checker") + "' /></td>");
//核查结果
sbPublishInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='"
+ GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[i], "CheckResult") + "' class='tdinput' id='txtCheckResult_" + (i + 1).ToString() + "'></td>");
//核查时间
sbPublishInfo.AppendLine("<td class='tdColInputCenter'><input type='text' maxlength = '10' value='"
+ GetSafeData.GetStringFromDateTime(dtBaseInfo.Rows[i], "CheckDate", "yyyy-MM-dd")
+ "' class='tdinput' id='txtCheckDate_" + (i + 1).ToString() + "' readonly='readonly' onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('txtCheckDate_" + (i + 1).ToString() + "')})\"></td>");
//备注
sbPublishInfo.AppendLine("<td class='tdColInput'><input type='text' maxlength = '50' value='"
+ GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[i], "Content") + "' class='tdinput' id='txtRemark_" + (i + 1).ToString() + "'></td>");
//插入行结束标识
sbPublishInfo.AppendLine("</tr>");
}
}
//信息发布设置到DIV中表示
//divRectPublishDetail.InnerHtml = CreatePublishTable() + sbPublishInfo.ToString() + EndTable();
divRectPublishDetail.InnerHtml = sbPublishInfo.ToString();
}
