using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Web;
using job_17;
/*
* AUTHOR:ZHANGLEI
* CREATE DATE:2007.1.5
* 功能：Ajax类，在本类中包含了
* 菜单级联的无刷新技术
* */
namespace job_17
{
/// <summary>
/// AjaxMethod 的摘要说明。
/// </summary>
public class AjaxMethod
{
//DataTable dt;
private readonly string P_Con=ConfigurationSettings.AppSettings["P_Con"].ToString();
public AjaxMethod()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
/// <summary>
/// 菜单级联
/// </summary>
//菜单级联
[Ajax.AjaxMethod]
//注:为区分是ajax方法与普通的cs代码中的方法,需在ajax方法前面加上 [Ajax.AjaxMethod].如上
public DataTable bind(string i)
{
SqlConnection myconn=new SqlConnection(P_Con);
string sql="select * from station where stationSortID="+i.ToString();
SqlDataAdapter adpt=new SqlDataAdapter(sql,myconn);
DataSet ds=new DataSet();
adpt.Fill(ds);
return ds.Tables[0];
}
[Ajax.AjaxMethod]
public DataTable GetDataTable()
{
SqlConnection myconn=new SqlConnection(P_Con);
string sql="select * from gonggao";
SqlDataAdapter adpt=new SqlDataAdapter(sql,myconn);
DataSet ds=new DataSet();
adpt.Fill(ds);
return ds.Tables[0];
}
[Ajax.AjaxMethod]
public string add(int i,int j)
{
return (i+j).ToString();
}
//个人注册页(p_manage/p_reg.aspx)中的检测userid是否已经存在
[Ajax.AjaxMethod]
public int usercheck(string i)
{
SqlConnection myconn=new SqlConnection(P_Con);
int result;
string sql="select * from person where userid='"+i+"'";
SqlDataAdapter adpt=new SqlDataAdapter(sql,myconn);
DataSet ds=new DataSet();
adpt.Fill(ds);
DataTable dt=ds.Tables[0];
if (dt.Rows.Count>0)
{
result=1;
}
else
{result=-1;}
return (int)result;
}
//个人注册页(p_manage/p_reg.aspx)中的检测email的合法性
[Ajax.AjaxMethod]
public int emailcheck(string j)
{
SqlConnection myconn=new SqlConnection(P_Con);
int nResult;
string sql="select * from person where email='"+j+"'";
SqlDataAdapter adpt=new SqlDataAdapter(sql,myconn);
DataSet ds=new DataSet();
adpt.Fill(ds);
DataTable dt=ds.Tables[0];
if (dt.Rows.Count>0)
{
nResult=1;
}
else
{
nResult=-1;
}
return (int)nResult;
}
//个人管理中心页（p_manage/P_admin1.aspx）中的时间刷新
[Ajax.AjaxMethod]
public int refresh(string uid)
{
int sResult;
if (uid.ToString()!="")
{
string sql="update person set modifydate='"+DateTime.Now.ToString()+"'";
job17 cls=new job17();
cls.ExecuteNonsql(sql);
sResult=1;
return (int)sResult;
}
else
{
sResult=-1;
return (int)sResult;
}
}
//个人管理中心页（p_manage/P_admin1.aspx）中的简历公开的设定
[Ajax.AjaxMethod]
public string statecheck(string uid,string hidden)
{
string sql="";
string updatesql="";
string stateResult="";
if (hidden.ToString()=="Y")
{
updatesql="update person set hidden='N' where userid='"+uid.ToString()+"'";
//return (string)stateResult.ToString();
}
else
{
updatesql="update person set hidden='Y' where userid='"+uid.ToString()+"'";
}
job17 cls=new job17();
cls.ExecuteNonsql(updatesql);
sql="select * from person where userid='"+uid.ToString()+"'";
SqlDataReader dr=cls.ExecuteDataReadersql(sql);
if (dr.Read())
{
stateResult=dr["hidden"].ToString();
}
dr.Close();
return (string)stateResult.ToString();
}
//菜单级联，通过职位大类，绑定具体职位
[Ajax.AjaxMethod]
public string BindZw(string id)
{
SqlConnection myconn=new SqlConnection(P_Con);
string sql="select * from _station where stationtypeid="+id.ToString();
SqlDataAdapter adpt=new SqlDataAdapter(sql,myconn);
DataSet ds=new DataSet();
adpt.Fill(ds);
DataTable dt=ds.Tables[0];
string sHtmlText="";
sHtmlText="<select id=/"ddl_Zw/" name=/"ddl_Zw/">";
sHtmlText+="<option value=/"0/">不限</option>";
foreach(DataRow row in dt.Rows)
{
//if (row)
sHtmlText+="<option value="+row["stationid"].ToString()+">"+row["stationname"].ToString()+"</option>";
}
sHtmlText+="</select>";
return (string)sHtmlText.ToString();
}
/// <summary>
/// /
/// </summary>
/// <param name="i"></param>
/// <returns></returns>
//菜单级联，通过职位大类，绑定具体职位
/*[Ajax.AjaxMethod]
public string BindZw(string id,int a)
{
string sql="select * from _station where stationtypeid="+id.ToString();
job17 cls=new job17();
DataTable dt=cls.ExecuteDataTablesql(sql);
string sHtmlText="";
sHtmlText="<select id=/"ddl_Zw/" onchange=/"salert(this.value)/" name=/"ddl_Zw/">";
sHtmlText+="<option value=/"0/">不限</option>";
foreach(DataRow row in dt.Rows)
{
//if (row)
sHtmlText+="<option value="+row["id"].ToString()+">"+row["stationname"].ToString()+"</option>";
}
sHtmlText+="</select>";
return (string)sHtmlText.ToString();
}*/
/// <summary>
/// /
/// </summary>
/// <param name="i"></param>
/// <returns></returns>
///
//企业注册页(c_manage/company_reg.aspx)中的检测userid是否已经存在
[Ajax.AjaxMethod]
public int companyuser(string i)
{
SqlConnection myconn=new SqlConnection(P_Con);
int result;
string sql="select * from company where userid='"+i+"'";
SqlDataAdapter adpt=new SqlDataAdapter(sql,myconn);
DataSet ds=new DataSet();
adpt.Fill(ds);
DataTable dt=ds.Tables[0];
if (dt.Rows.Count>0)
{
result=1;
}
else
{result=-1;}
return (int)result;
}
//企业注册页(c_manage/company_reg.aspx)中的检测email的合法性
[Ajax.AjaxMethod]
public int companyemail(string j)
{
SqlConnection myconn=new SqlConnection(P_Con);
int nResult;
string sql="select * from company where email='"+j+"'";
SqlDataAdapter adpt=new SqlDataAdapter(sql,myconn);
DataSet ds=new DataSet();
adpt.Fill(ds);
DataTable dt=ds.Tables[0];
if (dt.Rows.Count>0)
{
nResult=1;
}
else
{
nResult=-1;
}
return (int)nResult;
}
//个人注册页p_manage/p_jlmodify中的列表框绑定具体职位
[Ajax.AjaxMethod]
public string Bindzwlist(string id)
{
SqlConnection myconn=new SqlConnection(P_Con);
string sql=string.Format("select * from _station where stationtypeid={0}",""+id.ToString()+"");
SqlDataAdapter adpt=new SqlDataAdapter(sql,myconn);
DataSet ds=new DataSet();
adpt.Fill(ds);
DataTable dt=ds.Tables[0];
string strTemp="<select name=/"yingpinlist/" id=/"yingpinlist/" multiple=/"multiple/">";
foreach(DataRow row in dt.Rows)
{
strTemp+="<option value="+row["stationid"].ToString()+">"+row["stationname"].ToString()+"</option>";
}
strTemp+="</selected>";
return (string)strTemp.ToString();
}
}
}