public IEnumerable <object> QueryPNum([FromBody] QPNumParModel qppm) { try { var account = HttpContext.Session.GetString("user_Account"); var localProvince = HttpContext.Session.GetString("user_Province"); if (account == null || localProvince == null) { return(new[] { new { msg = "not login" } }); } if (Server.AccountHandle(account) == 0) { return(new[] { new { msg = "times exceeded" } }); } var re = NewHistoryDataQueryServer.QueryPNum(qppm, localProvince); return(re); } catch (Exception e) { return(new[] { e.Message }); } }
/// <summary> /// 位次查询 /// </summary> /// <param name="qppm">查询参数头</param> /// <param name="localProvince">生源地</param> /// <returns></returns> public static IEnumerable <object> QueryPNum(QPNumParModel qppm, string localProvince) { using (var con = new SqlConnection(Server.SqlConString)) { if (qppm.classes == null || qppm.year == 0 || qppm.rPNum == 0) { return(new List <object> { new { code = "306", msg = "No necessary parameters" } }); } string sqlUniLocal = " ", sqlBatch = " "; if (qppm.uniLocal != null) { sqlUniLocal = " and University.address = '" + qppm.uniLocal + "' "; } if (qppm.batch != null) { sqlBatch = " and batch = '" + qppm.batch + "' "; } con.Open(); var re = new List <object>(); var sqlStr = "SELECT DISTINCT " + Server.Province[localProvince] + "Admit.uniName , address , batch , uniMin , uniAve , uniMinP , uniNum " + "FROM " + Server.Province[localProvince] + "Admit JOIN University ON " + Server.Province[localProvince] + "Admit.uniName = University.uniName " + "WHERE province = '" + localProvince + "' " + sqlUniLocal + sqlBatch + " AND classes = '" + qppm.classes + "'" + "AND uniMinP >= " + qppm.lPNum + " AND uniMinP <= " + qppm.rPNum + " AND year = " + qppm.year + "ORDER BY uniMinP"; var sc = new SqlCommand(sqlStr, con); sc.ExecuteNonQuery(); var reader = sc.ExecuteReader(); while (reader.Read()) { re.Add(new { uName = (string)reader[0], uAddress = (string)reader[1], uBatch = (string)reader[2], uMin = reader[3] == DBNull.Value ? -1 : (int)reader[3], uAve = reader[4] == DBNull.Value ? decimal.MinusOne : (decimal)reader[4], uMinP = reader[5] == DBNull.Value ? -1 : (int)reader[5], uNum = reader[6] == DBNull.Value ? -1 : (int)reader[6] }); } return(re); } }