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