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