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