private void Load_JobPositionKindsList()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("SettingCategory='JobCategories' and DisplayName='非管理'").Tables[0];
DataList1.DataSource = dt;
DataList1.DataBind();
dt = generalBasicSettingBLL.GetList("SettingCategory='JobCategories' and DisplayName='管理'").Tables[0];
DataList2.DataSource = dt;
DataList2.DataBind();
}
private void Load_IndustrySectorList()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("DisplayName='制造行业' and CanUsable=1 order by OrderNumber asc").Tables[0];
DataList1.DataSource = dt;
DataList1.DataBind();
dt = generalBasicSettingBLL.GetList("DisplayName='第三产业' and CanUsable=1 order by OrderNumber asc").Tables[0];
DataList2.DataSource = dt;
DataList2.DataBind();
dt = generalBasicSettingBLL.GetList("DisplayName='第一产业' and CanUsable=1 order by OrderNumber asc").Tables[0];
DataList3.DataSource = dt;
DataList3.DataBind();
}
private void Load_NavigateConten(string strType)
{
if (strType == "hr")
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
System.Data.DataTable dt = generalBasicSettingBLL.GetList("DisplayName='" + strType + "'").Tables[0];
zlzw.BLL.ExchangeCornerListBLL exchangeCornerListBLL = new zlzw.BLL.ExchangeCornerListBLL();
System.Data.DataTable dt01 = exchangeCornerListBLL.GetList("ExchangeCornerTypeKey='" + dt.Rows[0]["SettingKey"].ToString() + "'").Tables[0];
titleName.Text = dt01.Rows[0]["ExchangeCornerTitle"].ToString();
System.Text.StringBuilder strBuilder = new System.Text.StringBuilder();
strBuilder.Append("<table style='width:100%;'><tr><td algin='center' style='width:38%;font-size:14px;'>文件名称</td><td style='font-size:14px;'>文件大小</td><td style='font-size:14px;'>发布日期</td><td style='font-size:14px;'>点击下载</td></tr>");
for (int nCount = 0; nCount < dt01.Rows.Count; nCount++)
{
strBuilder.Append("<tr><td algin='center'><a href='" + dt01.Rows[nCount]["ExchangeCornerFilePath"].ToString().Split('~')[1] + "' style='text-decoration:none;color:#000; href='" + dt01.Rows[nCount]["ExchangeCornerFilePath"].ToString().Split('~')[1] + "' style='color:#355F95;font-weight:bold;text-decoration:none;''>" + dt01.Rows[nCount]["ExchangeCornerTitle"].ToString() + "</a></td><td algin='center'>" + Get_FileSize(int.Parse(dt01.Rows[nCount]["ExchangeCornerFileSize"].ToString())) + "</td><td algin='center'>" + Set_DateFormat(dt01.Rows[nCount]["PublishDate"].ToString()) + "</td><td algin='center'><a href='" + dt01.Rows[nCount]["ExchangeCornerFilePath"].ToString().Split('~')[1] + "' style='color:#355F95;font-weight:bold;text-decoration:none;'>下载地址</td></tr>");
}
strBuilder.Append("</table>");
labContent.Text = strBuilder.ToString();
}
else
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
System.Data.DataTable dt = generalBasicSettingBLL.GetList("DisplayName='" + strType + "'").Tables[0];
zlzw.BLL.ExchangeCornerListBLL exchangeCornerListBLL = new zlzw.BLL.ExchangeCornerListBLL();
System.Data.DataTable dt01 = exchangeCornerListBLL.GetList("ExchangeCornerTypeKey='" + dt.Rows[0]["SettingKey"].ToString() + "'").Tables[0];
titleName.Text = dt01.Rows[0]["ExchangeCornerTitle"].ToString();
labContent.Text = dt01.Rows[0]["exchangecornercontent"].ToString();
}
}
private void Load_MenuList()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
System.Data.DataTable dt = generalBasicSettingBLL.GetList("SettingCategory='MerchantsJoin' and CanUsable=1").Tables[0];
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
private void Load_WorkAreasList()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("SettingCategory='WorkAreas' and CanUsable=1 order by OrderNumber asc").Tables[0];
DataList1.DataSource = dt;
DataList1.DataBind();
}
private void Load_ManageTypeList()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("DisplayName='管理' and CanUsable=1").Tables[0];
for (int nCount = 0; nCount < dt.Rows.Count; nCount++)
{
labManageType.Text += "<a href='SearchList.aspx?id=" + HttpUtility.UrlEncode(dt.Rows[nCount]["SettingValue"].ToString()) + "' style='text-decoration:none;color:#325C93;'>" + dt.Rows[nCount]["SettingValue"].ToString() + " </a>";
}
}
private void Set_ExchangeCornerList()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
System.Data.DataTable dt = generalBasicSettingBLL.GetList("CanUsable=1 and SettingCategory='ExchangeCornerType' order by OrderNumber asc").Tables[0];
if (dt.Rows.Count > 0)
{
linkBtnExchangeCorner.HRef = "../ExchangeCorner.aspx?id=" + dt.Rows[0]["DisplayName"].ToString();
}
}
private void Load_ExchangeCornerTypeList()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
System.Data.DataTable dt = generalBasicSettingBLL.GetList("CanUsable=1 and SettingCategory='ExchangeCornerType' order by OrderNumber").Tables[0];
drpExchangeCornerTypeKey.DataTextField = "SettingValue";
drpExchangeCornerTypeKey.DataValueField = "SettingKey";
drpExchangeCornerTypeKey.DataSource = dt;
drpExchangeCornerTypeKey.DataBind();
}
/// <summary>
/// 是否在首页显示
/// </summary>
private void Load_SpecialTypeList()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("SettingCategory='JobSpecialType'").Tables[0];
drpSpecialType.DataTextField = "SettingValue";
drpSpecialType.DataValueField = "SettingKey";
drpSpecialType.DataSource = dt;
drpSpecialType.DataBind();
}
/// <summary>
/// 简历状态
/// </summary>
private void Load_JobPositionStatusList()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("SettingCategory='JobPositionStatus'").Tables[0];
drpJobPositionStatus.DataTextField = "SettingValue";
drpJobPositionStatus.DataValueField = "SettingKey";
drpJobPositionStatus.DataSource = dt;
drpJobPositionStatus.DataBind();
}
private void Load_JobSalaryList()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
System.Data.DataTable dt = generalBasicSettingBLL.GetList("SettingCategory='JobSalary' order by OrderNumber asc").Tables[0];
drpJobSalary.DataTextField = "SettingValue";
drpJobSalary.DataValueField = "SettingKey";
drpJobSalary.DataSource = dt;
drpJobSalary.DataBind();
}
private void Load_UserEducationalBackground()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("SettingCategory='NeedEducation' and CanUsable=1 order by OrderNumber asc").Tables[0];
drpUserEducationalBackground.DataTextField = "SettingValue";
drpUserEducationalBackground.DataValueField = "SettingKey";
drpUserEducationalBackground.DataSource = dt;
drpUserEducationalBackground.DataBind();
}
private void Load_MaritalStatusList()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("SettingCategory='MaritalStatus' and CanUsable=1 order by OrderNumber asc").Tables[0];
drpMaritalStatus.DataTextField = "SettingValue";
drpMaritalStatus.DataValueField = "SettingKey";
drpMaritalStatus.DataSource = dt;
drpMaritalStatus.DataBind();
}
public string Get_JobPositionKindsList(string strJobPositionKindsType)
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
System.Data.DataTable dt = generalBasicSettingBLL.GetList("DisplayName='" + strJobPositionKindsType + "'").Tables[0];
if (dt.Rows.Count > 0)
{
System.Text.StringBuilder strBuilder = new System.Text.StringBuilder();
string strTemp = "";
for (int nCount = 0; nCount < dt.Rows.Count; nCount++)
{
strTemp = dt.Rows[nCount]["SettingValue"].ToString();
strBuilder.Append("<option value='" + strTemp + "'>" + strTemp + "</option>");
}
return strBuilder.ToString();
}
else
{
return "-1";
}
}
/// <summary>
/// 获取最低学历
/// </summary>
/// <param name="strType"></param>
/// <returns></returns>
private string Get_NeedEducation(string strType)
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
System.Data.DataTable dt = generalBasicSettingBLL.GetList("CanUsable=1 and SettingCategory='NeedEducation' and SettingKey='" + strType + "'").Tables[0];
if (dt.Rows.Count > 0)
{
return dt.Rows[0]["SettingValue"].ToString();
}
else
{
return "未知";
}
}
private void Load_MenuList()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
System.Data.DataTable dt = generalBasicSettingBLL.GetList("CanUsable=1 and SettingCategory='ExchangeCornerType' order by OrderNumber asc").Tables[0];
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
private string Get_labJobSalary(string strJobSalaryKey)
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
System.Data.DataTable dt = generalBasicSettingBLL.GetList("SettingKey='" + strJobSalaryKey + "'").Tables[0];
return dt.Rows[0]["SettingValue"].ToString();
}
private string Get_UserEducationalBackground(string strUserGUID)
{
if (ViewState["CoreUserDataTable"] != null)
{
System.Data.DataTable newDT = ViewState["CoreUserDataTable"] as System.Data.DataTable;
if (newDT.Rows[0]["UserEducationalBackground"].ToString() != "")
{
int nUserEducationalBackgroundID = int.Parse(newDT.Rows[0]["UserEducationalBackground"].ToString());
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
System.Data.DataTable dt01 = generalBasicSettingBLL.GetList("DisplayName='学历要求' and SettingKey='" + nUserEducationalBackgroundID + "'").Tables[0];
return dt01.Rows[0]["SettingValue"].ToString();
}
else
{
return "未提供";
}
}
else
{
zlzw.BLL.CoreUserBLL coreUserBLL = new zlzw.BLL.CoreUserBLL();
System.Data.DataTable dt = coreUserBLL.GetList("UserGuid='" + strUserGUID + "'").Tables[0];
if (dt.Rows[0]["UserEducationalBackground"].ToString() != "")
{
int nUserEducationalBackgroundID = int.Parse(dt.Rows[0]["UserEducationalBackground"].ToString());
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
System.Data.DataTable dt01 = generalBasicSettingBLL.GetList("DisplayName='学历要求' and SettingKey='" + nUserEducationalBackgroundID + "'").Tables[0];
return dt01.Rows[0]["SettingValue"].ToString();
}
else
{
return "未提供";
}
}
}
private void Load_zzyList()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("DisplayName='制造行业' and CanUsable=1").Tables[0];
for (int nCount = 0; nCount < dt.Rows.Count; nCount++)
{
if (nCount >= 11)
{
Label1.Text += "<a href='SearchList.aspx?type=2&id=" + HttpUtility.UrlEncode(dt.Rows[nCount]["SettingValue"].ToString()) + "' target='_blank' style='text-decoration:none;color:#325C93;'>" + dt.Rows[nCount]["SettingValue"].ToString() + "</a> ";
}
else {
labzzyType.Text += "<a href='SearchList.aspx?type=2&id=" + HttpUtility.UrlEncode(dt.Rows[nCount]["SettingValue"].ToString()) + "' target='_blank' style='text-decoration:none;color:#325C93;'>" + dt.Rows[nCount]["SettingValue"].ToString() + "</a> ";
}
}
}
private string Get_strExchangeCornerTypeName(string strTypeName)
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("CanUsable=1 and SettingKey='" + strTypeName + "' and SettingCategory='ExchangeCornerType'").Tables[0];
if (dt.Rows.Count > 0)
{
return dt.Rows[0]["SettingValue"].ToString();
}
else
{
return "未知类型";
}
}
private string Get_TypeName(string strTypeID)
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("SettingKey='" + strTypeID + "'").Tables[0];
if (dt.Rows.Count > 0)
{
return dt.Rows[0]["SettingValue"].ToString();
}
else
{
return "未知";
}
}
/// <summary>
/// 绑定工作经验
/// </summary>
private void Load_NeedWorkExperience()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("SettingCategory='NeedWorkExperience' order by OrderNumber asc").Tables[0];
drpNeedWorkExperience.DataTextField = "SettingValue";
drpNeedWorkExperience.DataValueField = "SettingKey";
drpNeedWorkExperience.DataSource = dt;
drpNeedWorkExperience.DataBind();
}
/// <summary>
/// 绑定行业类别（大类）
/// </summary>
private void Load_JobFeildKinds()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("SettingCategory='IndustrySector'").Tables[0];
System.Collections.ArrayList arrList = new System.Collections.ArrayList();
string strTemp="";
for (int nCount = 0; nCount < dt.Rows.Count; nCount++)
{
strTemp = dt.Rows[nCount]["DisPlayName"].ToString();
if (!arrList.Contains(strTemp))
{
arrList.Add(strTemp);
}
}
//drpJobFeildKinds.DataTextField = "DisPlayName";
//drpJobFeildKinds.DataValueField = "SettingID";
//drpJobFeildKinds.DataSource = arrList;
//drpJobFeildKinds.DataBind();
//Load_JobFeildKinds01(drpJobFeildKinds.SelectedValue);
}
private string Get_JobWorkTypename(string strJobWorkTypeID)
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("SettingCategory='JobWorkType' and CanUsable=1 and SettingKey='" + strJobWorkTypeID + "'").Tables[0];
if (dt.Rows.Count > 0)
{
return dt.Rows[0]["SettingValue"].ToString();
}
else
{
return "未知";
}
}
private string Get_CurrentValue(string strValue)
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("SettingValue='"+ strValue +"'").Tables[0];
if (dt.Rows.Count > 0)
{
return dt.Rows[0]["DisplayName"].ToString();
}
else
{
return "未知";
}
}
private string Get_JobSalary(string strID)
{
if (strID == "")
{
return "无";
}
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("SettingCategory='JobSalary' and SettingKey=" + strID).Tables[0];
if (dt.Rows.Count > 0)
{
return dt.Rows[0]["SettingValue"].ToString();
}
else
{
return "未知月薪";
}
}
private string Get_JobPositionStatus(string strID)
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("SettingCategory='JobPositionStatus' and SettingKey=" + strID).Tables[0];
if (dt.Rows.Count > 0)
{
return dt.Rows[0]["SettingValue"].ToString();
}
else
{
return "未知类型";
}
}
private string Get_UserEducation(string strResumeGUID)
{
if (Request.QueryString["type"] == "1")
{
zlzw.BLL.CoreUserBLL coreUserBLL = new zlzw.BLL.CoreUserBLL();
System.Data.DataTable dt01 = coreUserBLL.GetList("UserGuid='" + strResumeGUID + "'").Tables[0];
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
System.Data.DataTable dt02 = generalBasicSettingBLL.GetList("SettingCategory='NeedEducation' and SettingKey='" + dt01.Rows[0]["UserEducationalBackground"].ToString() + "'").Tables[0];
if (dt02.Rows.Count > 0)
{
return dt02.Rows[0]["SettingValue"].ToString();
}
else
{
return "未知";
}
}
else
{
zlzw.BLL.JobPersonResumeBLL jobPersonResumeBLL = new zlzw.BLL.JobPersonResumeBLL();
System.Data.DataTable dt = jobPersonResumeBLL.GetList("ResumeGuid='" + strResumeGUID + "'").Tables[0];
zlzw.BLL.CoreUserBLL coreUserBLL = new zlzw.BLL.CoreUserBLL();
System.Data.DataTable dt01 = coreUserBLL.GetList("UserGuid='" + dt.Rows[0]["OwnerUserKey"].ToString() + "'").Tables[0];
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
System.Data.DataTable dt02 = generalBasicSettingBLL.GetList("SettingCategory='NeedEducation' and SettingKey='" + dt01.Rows[0]["UserEducationalBackground"].ToString() + "'").Tables[0];
if (dt02.Rows.Count > 0)
{
return dt02.Rows[0]["SettingValue"].ToString();
}
else
{
return "未知";
}
}
}
private void Load_IndustryKey()
{
zlzw.BLL.GeneralBasicSettingBLL generalBasicSettingBLL = new zlzw.BLL.GeneralBasicSettingBLL();
DataTable dt = generalBasicSettingBLL.GetList("SettingCategory='IndustrySector'").Tables[0];
ArrayList arrList = new ArrayList();
string strTemp;
for (int nCount = 0; nCount < dt.Rows.Count; nCount++)
{
strTemp = dt.Rows[nCount]["DisplayName"].ToString();
if (!arrList.Contains(strTemp))
{
arrList.Add(strTemp);
}
}
drpIndustryKey.DataSource = arrList;
drpIndustryKey.DataBind();
}