/// <summary> /// 根据面试模板ID,获取模板信息,并设置到页面显示 /// </summary> /// <param name="templateID">模板ID</param> private void InitTemplateInfo(string templateID) { //设置编号可见 divCodeNo.Attributes.Add("style", "display:block;"); //自动生成编号的控件设置为不可见 divCodeRule.Attributes.Add("style", "display:none;"); //查询考试信息 DataSet dsTemplateInfo = RectCheckTemplateBus.GetRectCheckTemplateInfoWithID(templateID); //获取考试基本信息 DataTable dtBaseInfo = dsTemplateInfo.Tables[0]; //基本信息存在时 if (dtBaseInfo != null && dtBaseInfo.Rows.Count > 0) { #region 设置基本信息 //模板编号 divCodeNo.InnerHtml = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "TemplateNo"); //主题 txtTitle.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Title"); //岗位 ddlQuarter.SelectedValue = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "QuarterID"); //考试状态 txtRemark.Text = GetSafeData.ValidateDataRow_String(dtBaseInfo.Rows[0], "Remark"); #endregion //设置要素信息 InitElemInfo(dsTemplateInfo.Tables[1]); } }
protected void btnImport_Click(object sender, System.Web.UI.ImageClickEventArgs e) { //从请求中获取排序列 string orderString = hidOrderBy.Value.Trim(); //排序:默认为升序 string orderBy = "asc"; //要排序的字段,如果为空,默认为"RectApplyNo" string orderByCol = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "TemplateNo"; //降序时如果设置为降序 if (orderString.EndsWith("_d")) { //排序:降序 orderBy = "desc"; } //从请求中获取当前页 //int pageIndex = Convert.ToInt32(txtToPage.Value); ////从请求中获取每页显示记录数 //int pageCount = Convert.ToInt32(txtShowPageCount.Value); ////跳过记录数 //int skipRecord = (pageIndex - 1) * pageCount; RectCheckTemplateModel searchModel = new RectCheckTemplateModel(); //设置查询条件 //考核编号 searchModel.TemplateNo = txtTemplateNo.Value.Trim(); //主题 searchModel.Title = txtTitle.Value.Trim(); //岗位 searchModel.QuarterID = Request.Form["ddlQuarter"].ToString(); if (searchModel.Title != null) { int bbb = searchModel.Title.IndexOf('%');///过滤字符串 if (bbb != -1) { searchModel.Title = searchModel.Title.Replace('%', ' '); } } string ord = orderByCol + " " + orderBy; int TotalCount = 0; //查询数据 DataTable dtTemp = new DataTable(); if (!string.IsNullOrEmpty(txtToPage.Value)) { dtTemp = RectCheckTemplateBus.SearchTemplateCSInfo(searchModel, 1, 10000, ord, ref TotalCount); } string[,] ht = { { "模板编号", "TemplateNo" }, { "主题", "Title" }, { "岗位", "QuarterName" } }; ExportExcel(dtTemp, ht, "", "面试评测模板列表"); }