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) : "RectApplyNo"; //降序时如果设置为降序 if (orderString.EndsWith("_d")) { //排序:降序 orderBy = "desc"; } //从请求中获取当前页 //int pageIndex =Convert .ToInt32 ( txtToPage.Value); ////从请求中获取每页显示记录数 //int pageCount = Convert.ToInt32(txtShowPageCount.Value); ////跳过记录数 //int skipRecord = (pageIndex - 1) * pageCount; //获取数据 RectApplyModel searchModel = new RectApplyModel(); //设置查询条件 searchModel.RectApplyNo = txtRectApplyNo.Text.Trim(); searchModel.DeptID = hidDeptID.Value;//申请部门 //申请日期 //searchModel.UsedDate = request.QueryString["ApplyDate"]; //searchModel.JobName = request.QueryString["JobName"];//职位名称 searchModel.FlowStatusID = Request.Form["ddlFlowStatus"].ToString(); searchModel.BillStatus = Request.Form["DropDownList1"].ToString(); string ord = orderByCol + " " + orderBy; int TotalCount = 0; //查询数据 DataTable dtRectApply = new DataTable(); if (!string.IsNullOrEmpty(txtToPage.Value)) { dtRectApply = RectApplyBus.SearchRectApplyInfo(searchModel, 1, 10000, ord, ref TotalCount);//查询数据 } string[,] ht = { { "申请编号", "RectApplyNo" }, { "制单时间 ", "CreateDate" }, { "申请部门 ", "DeptName" }, { "编制定额 ", "MaxNum" }, { "现有人数 ", "NowNum" }, { "总需求人数", "RequireNum" }, { "审批状态", "FlowStatusName" } }; ExportExcel(dtRectApply, ht, "", "招聘申请列表"); }
//public void DataBindToYear() //{ // string year = string.Empty; // int yearTemp = DateTime.Now.Year - 10; // for (int i = 0; i <= 30; i++) // { // ddlYear.Items.Add(new ListItem((yearTemp + i).ToString() + "年度", (yearTemp + i).ToString())); // } // ddlYear.SelectedValue = DateTime.Now.Year.ToString(); //} //public void DataBindToMonth() //{ // string month = string.Empty; // int monthTemp = DateTime.Now.Month; // if (monthTemp < 10) // { // month = "0" + monthTemp.ToString(); // } // ddlEndMonth.SelectedValue = month; // this.ddlStartMonth.SelectedValue = month; //} //public void DataBindToDept() //{ // DataTable dt = PerformanceQueryBus.SearchDeptInfo(); // ddlDeptName.DataSource = dt; // ddlDeptName.DataTextField = "DeptName"; // ddlDeptName.DataValueField = "ID"; // ddlDeptName.DataBind(); // ddlDeptName.Items.Add(new System.Web.UI.WebControls.ListItem("--请选择--", "0")); // ddlDeptName.SelectedValue = "0"; //} private void Search(string rectApplyID) { UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //查询数据 DataTable dtData = RectApplyBus.GetRectApplyInfoWithIDByReport(rectApplyID); DataTable dtSub = RectApplyBus.GetRectApplyDetailsInfoByReport(rectApplyID); ReportDocument oRpt = new ReportDocument(); CrystalReportSource1.ReportDocument.Load(Server.MapPath(@"~/OperatingModel/CrystalReport/HumanManager/RectApplyEdit.rpt")); // SetDatabaseLogon 拉模式中必须用这个方法来设置登录信息,参数一:用户名;参数二:密码;参数三:服务器;参数四:数据库名 CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.SalaryReportSummary")); ReportDocument rdDetail = CrystalReportSource1.ReportDocument.Subreports["RectApplyDetailReport.rpt"]; rdDetail.SetDataSource(dtSub); //查询数据 CrystalReportSource1.ReportDocument.DataDefinition.FormulaFields["Creator"].Text = "\"" + "制表人:" + userInfo.EmployeeName + "\""; CrystalReportSource1.ReportDocument.SetDataSource(dtData); CrystalReportSource1.DataBind(); // CrystalReportViewer1是水晶报表浏览器,下面是给该浏览器赋上对像 CrystalReportViewer1.ReportSource = CrystalReportSource1; //CrystalReportViewer1.DataBind(); }
/// <summary> /// 设置招聘申请信息 /// </summary> /// <param name="rectApplyID">招聘申请ID</param> private void InitRectApplyInfo(string rectApplyID) { ////查询招聘申请信息 DataTable dtRectApply = RectApplyBus.GetRectApplyInfoWithID(rectApplyID); //数据存在时 if (dtRectApply != null && dtRectApply.Rows.Count > 0) { // hiddenBillStatus.Value = "2"; //申请编号 string billNo = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "RectApplyNo"); divRectApplyNo.InnerHtml = billNo; hidBillNo.Value = billNo; txtIndentityID.Value = rectApplyID; //申请部门 DeptApply.Text = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "DeptName"); hidDeptID.Value = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "DeptID"); //直接主管 txtMaxNum.Value = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "MaxNum"); //职位名称 txtNowNum.Value = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "NowNum"); //招聘人数 txtRequireNum.Value = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "RequireNum"); txtPrincipal.Value = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "Principal"); UserApplyUserName.Text = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "PrincipalName"); txtRequstReason.Text = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "RequstReason"); //备注 txtRemark.Text = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "Remark"); txtBillStatus.Text = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "BillStatus"); string FlowStatusName = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "FlowStatusName"); if (txtBillStatus.Text == "制单") { hiddenBillStatus.Value = "1"; if (FlowStatusName == "审批通过") { // btnSave.Attributes.Add("style", "display:none"); btnSave.Src = "../../../Images/Button/UnClick_bc.jpg"; btnSave.Attributes.Add("onclick", ""); } } else if (txtBillStatus.Text == "执行") { hiddenBillStatus.Value = "2"; //btnSave.Attributes.Add("style", "display:none"); btnSave.Src = "../../../Images/Button/UnClick_bc.jpg"; btnSave.Attributes.Add("onclick", ""); } else if (txtBillStatus.Text == "手工结单") { hiddenBillStatus.Value = "4"; //btnSave.Attributes.Add("style", "display:none"); btnSave.Src = "../../../Images/Button/UnClick_bc.jpg"; btnSave.Attributes.Add("onclick", ""); } if (FlowStatusName != null) { if (FlowStatusName == "待审批") { // btnSave.Attributes.Add("style", "display:none"); btnSave.Src = "../../../Images/Button/UnClick_bc.jpg"; btnSave.Attributes.Add("onclick", ""); } } txtCreator.Text = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "Creator"); this.txtConfirmor.Text = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "Confirmor"); this.txtCloser.Text = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "Closer"); this.txtCreateDate.Text = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "CreateDate"); this.txtConfirmDate.Text = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "ConfirmDate"); this.txtCloseDate.Text = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "CloseDate"); string companyCD = GetSafeData.ValidateDataRow_String(dtRectApply.Rows[0], "CompanyCD"); DataTable dtGoalDetails = RectApplyBus.GetGoalDetailsWithID(billNo, companyCD); InitGoalInfo(dtGoalDetails); } }