public DataTable GetByProAndTypeAndYear(string proName, string type, string year)
{
string sql = "SELECT u_name,local_province_name,type,year,batch,average_score,min_score,pro_score FROM " +
"view_universityline WHERE belong_pro = '" + proName + "'AND type = '" + type + "' AND year = '" + year + "'";
return(PgHelper.ExcuteDataTable(sql));
}
public DataTable GetSpecialLineByYearAndType(string year, string type, string specialName)
{
string sql = "SELECT * FROM specialline WHERE year = '" + year + "' AND type = '" + type +
"'AND special_name like '%" + specialName + "%'";
return(PgHelper.ExcuteDataTable(sql));
}
public DataTable GetSpecialLineByYearAndTypeAndBatch(string year, string type, string batch)
{
string sql = "SELECT * FROM specialline WHERE year = '" + year + "' AND type = '" + type + "'AND batch = " +
"'" + batch + "'";
return(PgHelper.ExcuteDataTable(sql));
}
public DataTable GetByTypeAndBatchAndYear(string type, string batch, string year)
{
string sql = "SELECT * FROM universitylne WHERE type = '" + type + "'AND batch = '" + batch + "'AND " +
"year = '" + year + "'";
return(PgHelper.ExcuteDataTable(sql));
}
public DataTable GetSpecialLineByYearAndTypeAndPro(string year, string type, string proName)
{
string sql = "SELECT u_name,special_name,local_province_name,type,year,batch,average_score,min_score FROM " +
"view_specialline WHERE year = '" + year + "' AND type = '" + type + "' AND belong_pro = '" + proName + "'";
return(PgHelper.ExcuteDataTable(sql));
}
public DataTable GetByTypeAndYearAndName(string type, string year, string uName)
{
string sql = "SELECT * FROM universityline WHERE type = '" + type + "'AND year = '" + year + "'AND" +
" u_Name LIKE '%" + uName + "%'";
return(PgHelper.ExcuteDataTable(sql));
}
public DataTable GetSpecialLineByYearAndBatch(string year, string batch, string specialName)
{
string sql = "SELECT * FROM specialline WHERE year = '" + year + "' AND batch = '" + batch + "'AND " +
"special_name like '%" + specialName + "%'";
return(PgHelper.ExcuteDataTable(sql));
}
public DataTable GetByBatchAndYearAndName(string batch, string year, string uName)
{
string sql = "SELECT * FROM universityline WHERE batch = '" + batch + "'AND year = '" + year +
"'AND u_Name LIKE '%" + uName + "%'";
return(PgHelper.ExcuteDataTable(sql));
}
public DataTable GetByTypeAndProAndBatchAndYearAndName(string type, string proName, string batch, string year, string uName)
{
string sql = "SELECT u_name,local_province_name,type,year,batch,average_score,min_score,pro_score FROM " +
"view_universityline WHERE belong_pro = '" + proName + "'AND type = '" + type + "' AND year = '" + year + "'" +
"AND batch = '" + batch + "'AND u_Name LIKE '%" + uName + "%'";
return(PgHelper.ExcuteDataTable(sql));
}
public bool CheckLogin(string userName, string passWord)
{
string sql = "SELECT * FROM user_info WHERE username = '******'AND password = '******'";
NpgsqlParameter[] paras =
{
new NpgsqlParameter("@username", userName),
new NpgsqlParameter("@password", passWord)
};
return(PgHelper.CheckLogin(sql, paras));
}
public DataTable GetProLine(string proName)
{
string sql = "SELECT * FROM provinceline WHERE proname = '" + proName + "'";
return(PgHelper.ExcuteDataTable(sql));
}
public DataTable GetProLine(string proName, string year, string type, string batch)
{
string sql = "SELECT * FROM provinceline WHERE proname = '" + proName + "'AND year = '" + year + "'AND type = '" + type + "' AND batch = '" + batch + "'";
return(PgHelper.ExcuteDataTable(sql));
}
public DataTable GetByYear(string year)
{
string sql = "SELECT * FROM universityline WHERE year = '" + year + "'";
return(PgHelper.ExcuteDataTable(sql));
}
public DataTable GetByBatchAndYear(string batch, string year)
{
string sql = "SELECT * FROM universityline WHERE batch = '" + batch + "'AND year = '" + year + "'";
return(PgHelper.ExcuteDataTable(sql));
}
public DataTable GetSpecialLineByYear(string year)
{
string sql = "SELECT * FROM specialline WHERE year = '" + year + "'";
return(PgHelper.ExcuteDataTable(sql));
}
public DataTable GetByUniversityName(string universityName)
{
string sql = "SELECT * FROM universityline WHERE u_name LIKE '%" + universityName + "%'";
return(PgHelper.ExcuteDataTable(sql));
}
public DataTable GetSpecialLineBySpecialName(string specialName)
{
string sql = "SELECT * FROM specialline WHERE special_name like '%" + specialName + "%'";
return(PgHelper.ExcuteDataTable(sql));
}
