protected void btnImport_Click(object sender, System.Web.UI.ImageClickEventArgs e) { try { string orderString = hiddExpOrder.Value.Trim(); //排序 string order = "asc"; //排序:降序 string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ModifiedDate"; //要排序的字段,如果为空,默认为"ID" if (orderString.EndsWith("_d")) { order = "desc";//排序:降序 } string ord = " ORDER BY " + orderBy + " " + order; //获取数据 EmployeeContractModel searchModel = new EmployeeContractModel(); //设置查询条件 //编号 searchModel.ContractNo = txtContractNo.Text.Trim(); //主题 searchModel.Title = txtTitle.Text.Trim(); //员工 searchModel.EmployeeID = hidEmployeeID.Value; //查询数据 DataTable dt = EmployeeContractBus.SearchEmployeeContractInfo(searchModel); OutputToExecl.ExportToTableFormat(this, dt, new string[] { "合同编号", "合同名称", "员工编号", "员工姓名", "签约时间", "生效时间", "失效时间" }, new string[] { "ContractNo", "Title", "EmployeeNo", "EmployeeName", "SigningDate", "StartDate", "EndDate" }, "合同列表"); } catch { ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>"); } }
/*绑定主表信息*/ protected void BindMainInfo() { /*接受参数*/ string OrderNo = Request.QueryString["no"].ToString(); /*读取数据*/ DataTable dt = EmployeeContractBus.GetRepOrder(OrderNo); /*绑定RPT*/ if (dt != null) { /*加载主报表*/ rd.Load(Server.MapPath(@"~/PrinttingModel/HumanManager/EmployeeContract.rpt")); crViewer.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.HumanManager_report_EmployeeContract")); UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //绑定数据 rd.SetDataSource(dt); rd.Refresh(); this.crViewer.ReportSource = rd; rd.SetParameterValue("Today", "制表人:" + userInfo.EmployeeName); } }
/// <summary> /// 获取并设置页面信息 /// </summary> /// <param name="ID">ID</param> private void InitContractInfo(string ID) { //获取数据 DataTable dtContract = EmployeeContractBus.GetEmployeeContractInfoWithID(ID); //数据存在时,设置值 if (dtContract != null && dtContract.Rows.Count > 0) { //编号 divCodeNo.InnerHtml = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "ContractNo"); //员工 UserEmployee.Text = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "EmployeeName"); txtEmployeeID.Value = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "EmployeeID"); //合同名称 ctContractName.SelectedValue = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "ContractName"); //主题 txtTitle.Text = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "Title"); //合同类型 ddlContractType.SelectedValue = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "ContractType"); //合同属性 ddlContractProperty.SelectedValue = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "ContractProperty"); //工种 //ddlContractKind.SelectedValue = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "ContractKind"); //合同状态 ddlContractStatus.SelectedValue = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "ContractStatus"); //合同期限 ddlContractPeriod.SelectedValue = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "ContractPeriod"); //试用月数 txtTestMonth.Text = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "TrialMonthCount"); //试用工资 txtTestWage.Text = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "TestWage"); //转正工资 txtWage.Text = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "Wage"); //签约时间 txtSigningDate.Text = GetSafeData.GetStringFromDateTime(dtContract.Rows[0], "SigningDate", "yyyy-MM-dd"); //生效时间 txtStartDate.Text = GetSafeData.GetStringFromDateTime(dtContract.Rows[0], "StartDate", "yyyy-MM-dd"); //失效时间 txtEndDate.Text = GetSafeData.GetStringFromDateTime(dtContract.Rows[0], "EndDate", "yyyy-MM-dd"); //转正标识 ddlFlag.SelectedValue = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "Flag"); //提醒人 UserReminder.Text = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "ReminderName"); hidReminder.Value = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "Reminder"); //提前时间 txtAheadDay.Text = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "AheadDay"); //附件 string attachment = GetSafeData.ValidateDataRow_String(dtContract.Rows[0], "Attachment"); hfAttachment.Value = attachment; hfPageAttachment.Value = attachment; //设置下载 上传的显示 if (string.IsNullOrEmpty(attachment)) { //简历处理不显示 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(dtContract.Rows[0], "AttachmentName"); } }
void LoadDataBind() { string No = Request.QueryString["No"].ToString(); //编号 string ID = Request.QueryString["ID"].ToString(); //ID string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD; DataTable dt = EmployeeInfoBus.PrintEmployee(CompanyCD, No); DataTable dtHis = EmployeeInfoBus.PrintHistory(CompanyCD, No); DataTable dtHisWork = new DataTable(); dtHisWork = dtHis.Clone(); DataTable dtHisStudy = new DataTable(); dtHisStudy = dtHis.Clone(); DataRow[] rows = dtHis.Select("Flag = 1"); foreach (DataRow row in rows) { dtHisWork.Rows.Add(row.ItemArray); } DataRow[] rows2 = dtHis.Select("Flag = 2"); foreach (DataRow row in rows2) { dtHisStudy.Rows.Add(row.ItemArray); } DataTable dtSkill = EmployeeInfoBus.PrintSkill(CompanyCD, No); DataTable dtContract = EmployeeContractBus.PrintContract(CompanyCD, ID); if (dt != null) { //主报表 rd.Load(Server.MapPath(@"~/PrinttingModel/HumanManager/EmployeeInfoPrint.rpt")); CrystalReportViewer1.LogOnInfo.Add(ReportUtil.GetTableLogOnInfo("officedba.EmployeeInfo")); //子报表 if (dtHisWork != null) { ReportDocument rdHisWork = rd.Subreports["EmployeeHistoryWork.rpt"]; rdHisWork.SetDataSource(dtHisWork); } if (dtHisStudy != null) { ReportDocument rdHisStudy = rd.Subreports["EmployeeHistoryStudy.rpt"]; rdHisStudy.SetDataSource(dtHisStudy); } if (dtSkill != null) { ReportDocument rdSkill = rd.Subreports["EmployeeSkill.rpt"]; rdSkill.SetDataSource(dtSkill); } if (dtContract != null) { ReportDocument rdContract = rd.Subreports["EmoloyeeContract.rpt"]; rdContract.SetDataSource(dtContract); } UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"]; //绑定数据 rd.SetDataSource(dt); rd.SetParameterValue("Today", "制表人:" + userInfo.EmployeeName); this.CrystalReportViewer1.ReportSource = rd; } }