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