private string Get_EnterprisePublishCount(string strEnterpriseGUID) { zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); System.Data.DataTable dt = jobEnterpriseJobPositionBLL.GetList("EnterpriseKey='" + strEnterpriseGUID + "' and JobPositionStatus=1 and CanUsable=1").Tables[0]; return dt.Rows.Count.ToString(); }
private void Get_RecordCount() { string strGangWei = Request.Params["txbJobPositionKinds"];//岗位类别 string strHangYe = Request.Params["txbJobFeildKinds"];//行业类别 string strWorkAreas = Request.Params["txbWorkAreas"];//工作地区 string strSearchKey = Request.Params["txbSearchKey"];//关键字 string strSex = drpSex.SelectedValue;//性别 string strShiSu = drpShiSu.SelectedValue;//食宿 if (Session["DefaultSearchWhere"] != null) { zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); System.Data.DataTable dt = jobEnterpriseJobPositionBLL.GetList(Session["DefaultSearchWhere"].ToString()).Tables[0]; AspNetPager1.RecordCount = dt.Rows.Count; if (dt.Rows.Count == 0) { labDataIsNull.Visible = true; } else if (dt.Rows.Count > 0) { labDataIsNull.Visible = false; Repeater1.DataSource = dt; Repeater1.DataBind(); } } else { System.Text.StringBuilder strBuilder = new System.Text.StringBuilder(); strBuilder.Append("CanUsable=1"); if (strGangWei != "") { strBuilder.Append(" and JobPositionKind like '%" + strGangWei + "%'"); } if (strHangYe != "") { strBuilder.Append(" and JobFeildKinds like '%" + strHangYe + "%'"); } if (strWorkAreas != "") { strBuilder.Append(" and JobWorkPlaceNames like '%" + strWorkAreas + "%'"); } if (strShiSu != "-1" && strShiSu != "0") { strBuilder.Append(" and HopeRoomAndBoard like '%" + strShiSu + "%'"); } if (strSex != "-1") { strBuilder.Append(" and NeedSex like '%" + strSex + "%'"); } if (strSearchKey != "") { strBuilder.Append(" or (JobPositionDesc like '%" + strSearchKey + "%' or EnterpriseName like '%" + strSearchKey + "%' or JobPositionName like '%" + strSearchKey + "%')"); } zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); //System.Data.DataTable dt = jobEnterpriseJobPositionBLL.GetList("CanUsable=1 and JobPositionKind like '%" + strGangWei + "%' and JobFeildKinds like '%" + strHangYe + "%' and JobWorkPlaceNames like '%" + strWorkAreas + "%' and NeedSex like '%" + strSex + "%' or (JobPositionDesc like '%" + strSearchKey + "%' or EnterpriseName like '%" + strSearchKey + "%' or JobPositionName like '%" + strSearchKey + "%')").Tables[0]; System.Data.DataTable dt = jobEnterpriseJobPositionBLL.GetList(strBuilder.ToString()).Tables[0]; AspNetPager1.RecordCount = dt.Rows.Count; } }
private void JobEnterpriseJobPositionList_BindGrid() { zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); DataTable dt = jobEnterpriseJobPositionBLL.GetList(grid1.PageSize, grid1.PageIndex + 1, "*", "CreateDate", 0, "desc", "CanUsable=1").Tables[0]; grid1.DataSource = dt; grid1.DataBind(); }
private void Load_DataList(string strEnterpriseGUID) { zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); int nPageIndex = AspNetPager1.CurrentPageIndex; int nPageSize = AspNetPager1.PageSize = 15; System.Data.DataTable dt = jobEnterpriseJobPositionBLL.GetList(nPageSize, nPageIndex, "*", "CreateDate", 0, "desc", "EnterpriseKey='" + strEnterpriseGUID + "' and CanUsable=1").Tables[0]; Repeater1.DataSource = dt; Repeater1.DataBind(); }
private void Get_EnterpriseJobList(string strEnterpriseID) { zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); System.Data.DataTable dt = jobEnterpriseJobPositionBLL.GetList("EnterpriseKey='"+ Request.QueryString["id"] +"' and CanUsable=1 order by CreateDate desc").Tables[0]; labBanner.Text = dt.Rows[0]["EnterpriseName"].ToString(); labEnterpriseContent.Text = Get_EnterpriseDesc(strEnterpriseID); txbTitle.Text = dt.Rows[0]["EnterpriseName"].ToString() + "-" + dt.Rows[0]["JobPositionName"].ToString(); DataList1.DataSource = dt; DataList1.DataBind(); }
private void Load_JobList(string strJobGUID) { zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); System.Data.DataTable dt = jobEnterpriseJobPositionBLL.GetList("EnterpriseKey='"+ strJobGUID +"' order by CreateDate desc").Tables[0]; labBanner.Text = dt.Rows[0]["EnterpriseName"].ToString() + "<br/>"; txbTitle.Text = dt.Rows[0]["EnterpriseName"].ToString() + "-" + dt.Rows[0]["JobPositionName"].ToString(); labEnterpriseContent.Text = Get_EnterpriseDesc(strJobGUID); DataList1.DataSource = dt; DataList1.DataBind(); }
private void Get_RecordCount(string strSearchKey) { if (Request.QueryString["type"] == "1") { //岗位类别 zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); System.Data.DataTable dt = jobEnterpriseJobPositionBLL.GetList("CanUsable=1 and JobPositionKind like '%" + strSearchKey + "%'").Tables[0]; AspNetPager1.RecordCount = dt.Rows.Count; if (dt.Rows.Count == 0) { labDataIsNull.Visible = true; } else if (dt.Rows.Count > 0) { labDataIsNull.Visible = false; Repeater1.DataSource = dt; Repeater1.DataBind(); } } else if (Request.QueryString["type"] == "2") { //行业类别 zlzw.BLL.GeneralEnterpriseBLL generalEnterpriseBLL = new zlzw.BLL.GeneralEnterpriseBLL(); System.Data.DataTable dt = generalEnterpriseBLL.GetList("IndustryKey like '%" + Request.QueryString["id"] + "%'").Tables[0]; System.Text.StringBuilder strBuilder = new System.Text.StringBuilder(); if (dt.Rows.Count == 0) { labDataIsNull.Visible = true; } else if(dt.Rows.Count > 0) { strBuilder.Append("CanUsable=1 and "); int nRowCount = dt.Rows.Count; for (int nCount = 0; nCount < nRowCount; nCount++) { if ((nCount + 1) == nRowCount) { strBuilder.Append("EnterpriseKey='" + dt.Rows[nCount]["EnterpriseGuid"].ToString() + "'"); } else { strBuilder.Append("EnterpriseKey='" + dt.Rows[nCount]["EnterpriseGuid"].ToString() + "' or "); } } zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); System.Data.DataTable dt01 = jobEnterpriseJobPositionBLL.GetList(strBuilder.ToString()).Tables[0]; labDataIsNull.Visible = false; Repeater1.DataSource = dt01; Repeater1.DataBind(); } } }
/// <summary> /// 获取总页数 /// </summary> /// <returns></returns> private int Get_JobEnterpriseJobPositionListTotalCount() { zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); DataTable dt = jobEnterpriseJobPositionBLL.GetList("CanUsable=1").Tables[0]; if (dt.Rows.Count > 0) { return dt.Rows.Count; } else { return 0; } }
private void Load_JobInfo(string strID) { zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); System.Data.DataTable dt = jobEnterpriseJobPositionBLL.GetList("jobPositionGuid='"+ strID +"'").Tables[0]; System.Text.StringBuilder strBuilder = new System.Text.StringBuilder(); strBuilder.Append("<table border='0' style='width:91%;'>"); strBuilder.Append("<tr>"); strBuilder.Append("<td>"); strBuilder.Append("<span style='color:#052C65;'>岗位名称:</span> " + dt.Rows[0]["JobPositionName"].ToString()); strBuilder.Append("</td>"); strBuilder.Append("<td>"); strBuilder.Append("<span style='color:#052C65;'>岗位类别: </span>" + dt.Rows[0]["JobPositionKind"].ToString()); strBuilder.Append("</td>"); strBuilder.Append("<td>"); strBuilder.Append("<span style='color:#052C65;'>食宿福利: </span>" + Get_IsHopeRoomAndBoard(dt.Rows[0]["HopeRoomAndBoard"].ToString())); strBuilder.Append("</td>"); strBuilder.Append("</tr>"); strBuilder.Append("<tr>"); strBuilder.Append("<td>"); strBuilder.Append("<span style='color:#052C65;'>性别要求: </span>" + Get_UserSex(dt.Rows[0]["NeedSex"].ToString())); strBuilder.Append("</td>"); strBuilder.Append("<td>"); strBuilder.Append("<span style='color:#052C65;'>年龄要求: </span>" + dt.Rows[0]["NeedAge"].ToString()); strBuilder.Append("</td>"); strBuilder.Append("<td>"); strBuilder.Append("<span style='color:#052C65;'>最低学历: </span>" + Get_NeedEducation(dt.Rows[0]["NeedEducation"].ToString())); strBuilder.Append("</td>"); strBuilder.Append("</tr>"); strBuilder.Append("<tr>"); strBuilder.Append("<td>"); strBuilder.Append("<span style='color:#052C65;'>综合薪资: </span>" + dt.Rows[0]["ComprehensivePayroll"].ToString()); strBuilder.Append("</td>"); strBuilder.Append("<td>"); strBuilder.Append("<span style='color:#052C65;'>工作性质: </span>" + Get_JobWorkType(dt.Rows[0]["JobWorkType"].ToString())); strBuilder.Append("</td>"); strBuilder.Append("<td>"); strBuilder.Append("<span style='color:#052C65;'>发布日期: </span>" + DateTime.Parse(dt.Rows[0]["CreateDate"].ToString()).ToString("yyyy年MM月dd")); strBuilder.Append("</td>"); strBuilder.Append("</tr>"); strBuilder.Append("<tr colspan='3'>"); strBuilder.Append("<td colspan='3'>"); strBuilder.Append("<p><span style='color:#052C65;'>职位描述:</span></p>"); strBuilder.Append(dt.Rows[0]["JobPositionDesc"].ToString()); strBuilder.Append("</tr>"); strBuilder.Append("</tr>"); labJobList.Text = strBuilder.ToString(); labEnterpriseAdd.Text = dt.Rows[0]["JobWorkPlaceNames"].ToString();//公司地址 labPhone.Text = dt.Rows[0]["ContactTelephone"].ToString();//联系电话 labEmail.Text = dt.Rows[0]["ContactMail"].ToString();//电子邮件 labLxr.Text = dt.Rows[0]["ContactPerson"].ToString();//联系人 }
private int Load_RecordCount(string strEnterpriseGUID) { zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); System.Data.DataTable dt = jobEnterpriseJobPositionBLL.GetList("EnterpriseKey='" + strEnterpriseGUID + "' and CanUsable=1").Tables[0]; if (dt.Rows.Count == 0) { labDataIsNull.Visible = true; } else { labDataIsNull.Visible = false; } return dt.Rows.Count; }
private string Get_Jobname(string strResumeGUID) { zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); System.Data.DataTable dt = jobEnterpriseJobPositionBLL.GetList("JobPositionGuid='"+ strResumeGUID +"'").Tables[0]; return dt.Rows[0]["JobPositionName"].ToString(); }
private string Get_EnterpriseType(string strGUID) { zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); DataTable dt = jobEnterpriseJobPositionBLL.GetList("EnterpriseKey='" + strGUID + "'").Tables[0]; if (dt.Rows.Count > 0) { return "无"; } else { zlzw.BLL.GeneralEnterpriseBLL generalEnterpriseBLL = new zlzw.BLL.GeneralEnterpriseBLL(); DataTable dt01 = generalEnterpriseBLL.GetList("EnterpriseGuid='"+ dt.Rows[0]["EnterpriseKey"].ToString() +"'").Tables[0]; if (dt01.Rows.Count > 0) { return dt.Rows[0]["IndustryKey"].ToString(); } else { return "未知"; } } }
protected void btnDel_Click(object sender, EventArgs e) { if (grid1.SelectedRowIndexArray != null && grid1.SelectedRowIndexArray.Length > 0) { string strSelectID = "0"; for (int i = 0, count = grid1.SelectedRowIndexArray.Length; i < count; i++) { int rowIndex = grid1.SelectedRowIndexArray[i]; foreach (object key in grid1.DataKeys[rowIndex]) { strSelectID = key.ToString(); } } #region 删除逻辑 zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); DataTable dt = jobEnterpriseJobPositionBLL.GetList("JobPositionGuid='" + strSelectID + "'").Tables[0]; zlzw.Model.JobEnterpriseJobPositionModel jobEnterpriseJobPositionModel = jobEnterpriseJobPositionBLL.GetModel(int.Parse(dt.Rows[0]["JobPositionID"].ToString())); jobEnterpriseJobPositionModel.CanUsable = 0; jobEnterpriseJobPositionBLL.Update(jobEnterpriseJobPositionModel); JobEnterpriseJobPositionList_BindGrid(); #endregion } else { return; } }
private void Load_SearchResultList(string strSearchKey) { int nPageIndex = AspNetPager1.CurrentPageIndex; int nPageSize = AspNetPager1.PageSize = 15; if (Request.QueryString["type"] == "1") { //岗位类别 zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); System.Data.DataTable dt = jobEnterpriseJobPositionBLL.GetList(nPageSize, nPageIndex, "*", "UpdateDate", 0, "desc", "CanUsable=1 and JobPositionKind like '%" + strSearchKey + "%'").Tables[0]; if (dt.Rows.Count == 0) { labDataIsNull.Visible = true; } else if (dt.Rows.Count > 0) { labDataIsNull.Visible = false; Repeater1.DataSource = dt; Repeater1.DataBind(); } } else if (Request.QueryString["type"] == "2") { zlzw.BLL.GeneralEnterpriseBLL generalEnterpriseBLL = new zlzw.BLL.GeneralEnterpriseBLL(); System.Data.DataTable dt = generalEnterpriseBLL.GetList("IndustryKey='" + Request.QueryString["id"] + "'").Tables[0]; System.Text.StringBuilder strBuilder = new System.Text.StringBuilder(); if (dt.Rows.Count == 0) { labDataIsNull.Visible = true; } else { strBuilder.Append("CanUsable=1 and "); int nRowCount = dt.Rows.Count; for (int nCount = 0; nCount < nRowCount; nCount++) { if ((nCount + 1) == nRowCount) { strBuilder.Append("EnterpriseKey='" + dt.Rows[nCount][""].ToString() + "' order by CreateDate desc"); } else { strBuilder.Append("EnterpriseKey='" + dt.Rows[nCount][""].ToString() + "' or "); } } } } }
//protected void Repeater3_ItemDataBound(object sender, RepeaterItemEventArgs e) //{ // System.Web.UI.WebControls.ListItemType lit = e.Item.ItemType; // if (lit == System.Web.UI.WebControls.ListItemType.Item || lit == System.Web.UI.WebControls.ListItemType.AlternatingItem) // { // System.Data.DataRowView drv = (System.Data.DataRowView)e.Item.DataItem; // Label labParticipatingCompaniesList = (Label)e.Item.FindControl("labParticipatingCompaniesList"); // labParticipatingCompaniesList.Text = "<p style='line-height: 25px;'><img style='border:0px;' src='image/img7.png' width='11' height='12' /><a style='color:#6e6e6e;text-decoration:none;' target='_blank' href='ParticipatingCompaniesInfo.aspx?id=" + drv["ParticipatingCompaniesGUID"].ToString() + "'>" + drv["ParticipatingCompaniesContent"].ToString() + "</p>"; // } //} #endregion #region 紧急招聘行绑定事件 //protected void Repeater4_ItemDataBound(object sender, RepeaterItemEventArgs e) //{ // System.Web.UI.WebControls.ListItemType lit = e.Item.ItemType; // if (lit == System.Web.UI.WebControls.ListItemType.Item || lit == System.Web.UI.WebControls.ListItemType.AlternatingItem) // { // System.Data.DataRowView drv = (System.Data.DataRowView)e.Item.DataItem; // Label labJobTitle = (Label)e.Item.FindControl("labJobTitle"); // //Label labAdd = (Label)e.Item.FindControl("labAdd"); // Label labXueLi = (Label)e.Item.FindControl("labXueLi"); // Label labTel = (Label)e.Item.FindControl("labTel"); // labJobTitle.Text = "<a href='EnterpriseInfo/EnterpriseInfo.aspx?type=" + drv["EnterpriseKey"].ToString() + "&id=" + drv["JobPositionGuid"].ToString() + "' target='_blank' title='" + drv["EnterpriseName"].ToString() + "' style='text-decoration:none;color:#6e6e6e;'>" + Set_TitleLength(drv["EnterpriseName"].ToString()) + "</a>"; // //labAdd.Text = "<a href='EnterpriseInfo/EnterpriseInfo.aspx?type=" + drv["EnterpriseKey"].ToString() + "&id=" + drv["JobPositionGuid"].ToString() + "' style='text-decoration:none;color:#6e6e6e;' target='_blank' title='" + drv["JobWorkPlaceNames"].ToString() + "'>" + Get_AddLength(drv["JobWorkPlaceNames"].ToString()) + "</a>"; // //labXueLi.Text = "<a href='EnterpriseInfo/EnterpriseInfo.aspx?type=" + drv["EnterpriseKey"].ToString() + "&id=" + drv["JobPositionGuid"].ToString() + "' style='text-decoration:none;color:#6e6e6e;'>" + drv["JobPositionKind"].ToString() + "</a> " + Get_JobList(drv["JobPositionGuid"].ToString()); // labXueLi.Text = Get_JobList(drv["EnterpriseKey"].ToString()); // labTel.Text = "<span style='text-decoration:none;color:#6e6e6e;'>" + drv["ContactTelephone"].ToString() + "</span>"; // } //} #endregion #region 根据当前的企业GUID获取该企业下的所有紧急招聘职位 private string Get_JobList(string strEnterpriseGUID) { zlzw.BLL.JobEnterpriseJobPositionBLL jobEnterpriseJobPositionBLL = new zlzw.BLL.JobEnterpriseJobPositionBLL(); System.Data.DataTable dt = jobEnterpriseJobPositionBLL.GetList(10,"EnterpriseKey='"+ strEnterpriseGUID +"' and SpecialType=1 and CanUsable=1","CreateDate desc").Tables[0]; if (dt.Rows.Count > 0) { System.Text.StringBuilder strBuilder = new System.Text.StringBuilder(); int nAllCount = dt.Rows.Count; for (int nCount = 0; nCount < nAllCount; nCount++) { if ((nCount + 1) != nAllCount) { strBuilder.Append("<a target='_blank' style='text-decoration:none;color:#325C93;' href='EnterpriseInfo/EnterpriseInfo.aspx?type=" + strEnterpriseGUID + "&id=" + dt.Rows[nCount]["JobPositionGuid"].ToString() + "'>" + dt.Rows[nCount]["JobPositionName"].ToString() + "</a><span style='color:#3277C9;font-weight:bold;'>/</span>"); } else { strBuilder.Append("<a target='_blank' style='text-decoration:none;color:#325C93;' href='EnterpriseInfo/EnterpriseInfo.aspx?type=" + strEnterpriseGUID + "&id=" + dt.Rows[nCount]["JobPositionGuid"].ToString() + "'>" + dt.Rows[nCount]["JobPositionName"].ToString() + "</a>"); } } return strBuilder.ToString(); } else { return ""; } }