public void GetTempalte(string quarterID, string templateNo)
{
DataTable dtTemplate = RectInterviewBus.GetTemplateInfo(quarterID);
StringBuilder sbTemplateInfo = new StringBuilder();
//数据存在的时候
if (dtTemplate != null && dtTemplate.Rows.Count > 0)
{
//遍历所有模板信息
for (int i = 0; i < dtTemplate.Rows.Count; i++)
{
//获取模板编号
string no = GetSafeData.ValidateDataRow_String(dtTemplate.Rows[i], "TemplateNo");
//获取模板主题
string title = GetSafeData.ValidateDataRow_String(dtTemplate.Rows[i], "Title");
if (no == templateNo)
{
ddlTemplate.Items.Add(new ListItem(title, no));
//sbTemplateInfo.AppendLine("<option value=\"" + no + "\" selected=\"selected\">" + title + "</option>");
}
else
{
ddlTemplate.Items.Add(new ListItem(title, no));
//sbTemplateInfo.AppendLine("<option value=\"" + no + "\">" + title + "</option>");
}
}
ddlTemplate.SelectedValue = templateNo;
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
//从请求中获取排序列
string orderString = hidOrderBy.Value.Trim();
//排序：默认为升序
string orderBy = "asc";
//要排序的字段，如果为空，默认为"RectApplyNo"
string orderByCol = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "InterviewNo";
//降序时如果设置为降序
if (orderString.EndsWith("_d"))
{
//排序：降序
orderBy = "desc";
}
//从请求中获取当前页
//int pageIndex = Convert.ToInt32(txtToPage.Value);
////从请求中获取每页显示记录数
//int pageCount = Convert.ToInt32(txtShowPageCount.Value);
////跳过记录数
//int skipRecord = (pageIndex - 1) * pageCount;
//获取数据
RectInterviewModel searchModel = new RectInterviewModel();
//设置查询条件
//编号
searchModel.InterviewNo = txtRectInterviewNo.Text.Trim();
//面试日期
searchModel.InterviewDate = txtInterviewDate.Text.Trim();
searchModel.Attachment = txtInterviewToDate.Text.Trim();
searchModel.InterviewResult = Request.Form["ddlInterviewResult"].ToString();
//应聘岗位
searchModel.QuarterID = Request.Form["ddlQuarter"].ToString();
//姓名
searchModel.StaffName = UserTxtStaffName.Text.Trim();
//人力资源
searchModel.CheckDate = txtCheckStartDate.Text.Trim();
////部门主管
searchModel.CheckNote = txtCheckEndDate.Text.Trim();
//最终结果
searchModel.FinalResult = Request.Form["ddlFinalResult"].ToString();
searchModel.PlanID = Request.Form["ddlRectPlan"].ToString();
searchModel.RectType = Request.Form["ddlRectType"].ToString();
int aaa = searchModel.InterviewNo.IndexOf('%');///过滤字符串
if (aaa != -1)
{
searchModel.InterviewNo = searchModel.InterviewNo.Replace('%', ' ');
}
if (searchModel.StaffName != null)
{
int bbb = searchModel.StaffName.IndexOf('%');///过滤字符串
if (bbb != -1)
{
searchModel.StaffName = searchModel.StaffName.Replace('%', ' ');
}
}
string ord = orderByCol + " " + orderBy;
int TotalCount = 0;
//查询数据
DataTable dtRectApply = new DataTable();
if (!string.IsNullOrEmpty(txtToPage.Value))
{
dtRectApply = RectInterviewBus.SearchInterviewCSInfo(searchModel, 1, 10000, ord, ref TotalCount);
}
string[,] ht =
{
{ "面试编号", "InterviewNo" },
{ "对应招聘计划", "PlanName" },
{ "招聘方式", "RectType" },
{ "姓名", "StaffName" },
{ "应聘岗位", "QuarterName" },
{ "初试日期", "InterviewDate" },
{ "初试结果", "InterviewResult" },
{ "复试日期", "CheckDate" },
{ "复试结果", "FinalResult" }
};
ExportExcel(dtRectApply, ht, "", "面试记录列表");
}
/// <summary>
/// 类名：RectInterview_Info
/// 描述：面试记录列表处理
///
/// 作者：吴志强
/// 创建时间：2009/04/20
/// 最后修改时间：2009/04/20
/// </summary>
///
protected void Page_Load(object sender, EventArgs e)
{
//页面初期表示
if (!IsPostBack)
{
ddlRectPlan.Items.Clear();
ddlRectPlan.DataSource = RectInterviewBus.GetRectPlanInfo();
ddlRectPlan.DataValueField = "PlanNo";
ddlRectPlan.DataTextField = "Title";
ddlRectPlan.DataBind();
ddlRectPlan.Items.Insert(0, new ListItem("--请选择--", ""));
ddlRectPlan.SelectedIndex = 0;
//获取应聘岗位列表数据
ddlQuarter.DataSource = DeptQuarterBus.GetQuarterInfoWithCompanyCD();
ddlQuarter.DataValueField = "ID";
ddlQuarter.DataTextField = "QuarterName";
ddlQuarter.DataBind();
ddlQuarter.Items.Insert(0, new ListItem(ConstUtil.CODE_TYPE_INSERT_TEXT, ConstUtil.CODE_TYPE_INSERT_VALUE));
//新建模块ID
hidModuleID.Value = ConstUtil.MODULE_ID_HUMAN_RECTINTERVIEW_EDIT;
//获取请求参数
string requestParam = Request.QueryString.ToString();
//从列表过来时
int firstIndex = requestParam.IndexOf("&");
//返回回来时
if (firstIndex > 0)
{
////获取是否查询的标识
//string flag = Request.QueryString["Flag"];
////点击查询时，设置查询的条件，并执行查询
//if ("1".Equals(flag))
//{
// //面试记录编号
// txtRectInterviewNo.Text = Request.QueryString["InterviewNo"];
// //初试面试日期
// txtInterviewDate.Text = Request.QueryString["InterviewDate"];
// txtInterviewToDate.Text = Request.QueryString["InterviewToDate"];
// //复试面试日期
// txtCheckStartDate.Text = Request.QueryString["CheckStartDate"];
// txtCheckEndDate.Text = Request.QueryString["CheckEndDate"];
// //应聘岗位
// ddlQuarter.SelectedValue = Request.QueryString["QuarterID"];
// //姓名
// UserTxtStaffName.Text = Request.QueryString["StaffNameDisPlay"];
// //hidStaffName.Value = Request.QueryString["StaffName"];
// //招聘方式
// ddlRectType.SelectedValue = Request.QueryString["RectType"];
// //初试结果
// ddlInterviewResult.SelectedValue = Request.QueryString["InterviewResult"];
// //复试结果
// ddlFinalResult.SelectedValue = Request.QueryString["FinalResult"];
// //获取当前页
// string pageIndex = Request.QueryString["PageIndex"];
// //获取每页显示记录数
// string pageCount = Request.QueryString["PageCount"];
// //排序
// string OrderBy = Request.QueryString["OrderBy"];
// //执行查询
// ClientScript.RegisterStartupScript(this.GetType(), "SearchRectInterview"
// , "<script language=javascript>this.pageCount = parseInt(" + pageCount
// + ");this.OrderBy = \"" + OrderBy + "\";DoSearch('" + pageIndex + "');</script>");
//}
}
}
}
/// <summary>
/// 类名：RectInterview_Edit
/// 描述：新建面试维护处理
///
/// 作者：吴志强
/// 创建时间：2009/04/02
/// 最后修改时间：2009/04/02
/// </summary>
///
#region Page_Load
protected void Page_Load(object sender, EventArgs e)
{
//页面初期表示设置
if (!IsPostBack)
{
#region 新建、修改共通处理
//获取招聘活动列表数据
ddlRectPlan.Items.Clear();
ddlRectPlan.DataSource = RectInterviewBus.GetRectPlanInfo();
ddlRectPlan.DataValueField = "PlanNo";
ddlRectPlan.DataTextField = "Title";
ddlRectPlan.DataBind();
ddlRectPlan.Items.Insert(0, new ListItem("--请选择-- ", ""));
ddlRectPlan.SelectedIndex = 0;
ddlRectPlan.Attributes.Add("onchange", "InitQuterInfo();");
//获取消息渠道列表数据
//ddlInfoFrom.DataSource = RectInterviewBus.GetProxyInfo();
//ddlInfoFrom.DataValueField = "ID";
//ddlInfoFrom.DataTextField = "ProxyCompanyName";
//ddlInfoFrom.DataBind();
//获取应聘岗位列表数据
ddlQuarter.DataSource = DeptQuarterBus.GetQuarterInfoWithCompanyCD();
ddlQuarter.DataValueField = "ID";
ddlQuarter.DataTextField = "QuarterName";
ddlQuarter.DataBind();
ddlQuarter.SelectedIndex = 0;
//ddlQuarter.Items.Insert(0, new ListItem(ConstUtil.CODE_TYPE_INSERT_TEXT, ConstUtil.CODE_TYPE_INSERT_VALUE));
ddlQuarter.Attributes.Add("onchange", "InitTemplateInfo();");
ddlTemplate.Attributes.Add("onchange", "InitInterviewElem();");
//面试方式
ddlInterviewType.TypeFlag = ConstUtil.CODE_TYPE_HUMAN;
ddlInterviewType.TypeCode = ConstUtil.CODE_TYPE_INTERVIEW;
ddlInterviewType.IsInsertSelect = true;
ddlCheckType.TypeFlag = ConstUtil.CODE_TYPE_HUMAN;
ddlCheckType.TypeCode = ConstUtil.CODE_TYPE_INTERVIEW;
ddlCheckType.IsInsertSelect = true;
//模板列表模块ID
hidModuleID.Value = ConstUtil.MODULE_ID_HUMAN_RECTINTERVIEW_INFO;
hidEmployeeModuleID.Value = ConstUtil.MODULE_ID_HUMAN_EMPLOYEE_ADD;
FlowRectApply.BillTypeFlag = ConstUtil.BILL_TYPEFLAG_HUMAN;
FlowRectApply.BillTypeCode = ConstUtil.BILL_TYPECODE_HUMAN_RECT_INTERVIEW;
//获取请求参数
string requestParam = Request.QueryString.ToString();
//通过参数个数来判断是否从菜单过来
int firstIndex = requestParam.IndexOf("&");
//从列表过来时
if (firstIndex > 0)
{
//返回按钮可见
btnBack.Visible = true;
//获取列表的查询条件
string searchCondition = requestParam.Substring(firstIndex);
hidIsliebiao.Value = "1";
//设置检索条件
hidSearchCondition.Value = searchCondition;
}
else
{
//返回按钮不可见
btnBack.Visible = false;
}
#endregion
//获取面试记录ID
string interviewID = Request.QueryString["ID"];
if (Request.QueryString["isLieBiao"] != null)
{
hidIsliebiao.Value = "1";
}
//模板ID为空时，为新建模式
if (string.IsNullOrEmpty(interviewID))
{
#region 新建时初期处理
this.hidIsSearch.Value = "1";
//编号初期处理
codeRule.CodingType = ConstUtil.CODING_TYPE_HUMAN;
codeRule.ItemTypeID = ConstUtil.CODING_HUMAN_ITEM_INTERVIEW;
//设置编号不可见
divCodeNo.Attributes.Add("style", "display:none;");
//自动生成编号的控件设置为可见
divCodeRule.Attributes.Add("style", "display:block;");
//设置编辑模式
hidInterviewID.Value = string.Empty;
//生成表格
divElemScoreDetail.InnerHtml = CreateElemScoreTable() + EndTable();
//
txtInterviewDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
#endregion
}
else
{
#region 修改时初期处理
//设置标题
this.hidIsSearch.Value = "2";
divTitle.InnerText = "面试记录";
//获取并设置面试记录信息
InitInterviewInfo(interviewID);
//设置编辑模式
hidInterviewID.Value = interviewID;
#endregion
}
}
}
/// <summary>
/// 根据面试记录ID，获取信息，并设置到页面显示
/// </summary>
/// <param name="interviewID">面试记录ID</param>
private void InitInterviewInfo(string interviewID)
{
//设置编号可见
divCodeNo.Attributes.Add("style", "display:block;");
//自动生成编号的控件设置为不可见
divCodeRule.Attributes.Add("style", "display:none;");
//查询考试信息
DataSet dsInterviewInfo = RectInterviewBus.GetInterviewInfoWithID(interviewID);
//获取考试基本信息
DataTable dtBaseInfo = dsInterviewInfo.Tables[0];
//基本信息存在时
if (dtBaseInfo != null && dtBaseInfo.Rows.Count > 0)
{
#region 设置基本信息
// 编号
this.divCodeNo.InnerHtml = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "InterviewNo");
//招聘活动
ddlRectPlan.SelectedValue = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "PlanID");
//姓名
txtStaffName.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "StaffNameDisplay");
hidStaffName.Value = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "StaffName");
//招聘方式
ddlRectType.SelectedValue = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "RectType");
//应聘岗位
ddlQuarter.SelectedValue = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "QuarterID");
GetTempalte(GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "QuarterID"), GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TemplateNo"));
//初试日期
txtInterviewDate.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "InterviewDate");
//附件
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");
//初试面试方式
ddlInterviewType.SelectedValue = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "InterviewType");
//初试面试地点
txtInterviewPlace.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "InterviewPlace");
//初试人员意见
txtInterviewNote.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "InterviewNote");
//初试结果
ddlInterviewResult.SelectedValue = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "InterviewResult");
//复试日期
txtCheckDate.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "CheckDate");
//复试面试方式
ddlCheckType.SelectedValue = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "CheckType");
//复试面试地点
txtCheckPlace.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "CheckPlace");
//复试人员意见
txtCheckNote.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "CheckNote");
//复试结果
ddlFinalResult.SelectedValue = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "FinalResult");
//综合素质
txtManNote.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "ManNote");
//专业知识
txtKnowNote.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "KnowNote");
//工作经验
txtWorkNote.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "WorkNote");
//要求待遇
txtSalaryNote.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "SalaryNote");
//备注
txtRemark.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Remark");
//工作经验
txtOurSalary.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "OurSalary");
//要求待遇
txtFinalSalary.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "FinalSalary");
//备注
txtOtherNote.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "OtherNote");
#endregion
//设置要素信息
InitElemScoreInfo(dsInterviewInfo.Tables[1], GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TestScore"));
}
}
