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