public IEnumerable <object> QueryUniversity([FromBody] QUniNameParModel qunpm)
{
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.QueryUniversity(qunpm, localProvince);
return(re);
}
catch (Exception e)
{
return(new[] { e.Message });
}
}
public IEnumerable <object> QueryUniversity([FromBody] QUniNameParModel qunpm, string localProvince)
{
try
{
var addr = Server.GetUserIp(Request.HttpContext);
if (Server.IPHandle(addr) == 0)
{
return(new[] { "your ip can't using our api , please contact administrator" });
}
var re = NewHistoryDataQueryServer.QueryUniversity(qunpm, localProvince);
return(re);
}
catch (Exception e)
{
return(new[] { e.Message });
}
}
/// <summary>
/// 精确查询学校
/// </summary>
/// <param name="qunpm">查询参数</param>
/// <param name="localProvince">生源地</param>
/// <returns>查询结果</returns>
public static IEnumerable <object> QueryUniversity(QUniNameParModel qunpm, string localProvince)
{
using (var con = new SqlConnection(Server.SqlConString))
{
if (qunpm.classes == null) //如果没有必须的参数，则返回错误信息
{
return(new List <object>
{
new
{
code = "306",
msg = "No necessary parameters"
}
});
}
string sqlUniBatch = " ", sqlUniType = " ", sqlUniLocal = " ", sqlYear = " ";
if (qunpm.uniBatch != null)
{
sqlUniBatch = " and batch = '" + qunpm.uniBatch + "' ";
}
if (qunpm.uniLocal != null)
{
sqlUniLocal = " and University.address = '" + qunpm.uniLocal + "' ";
}
if (qunpm.uniType != null)
{
sqlUniType = " and University.subject = '" + qunpm.uniType + "' ";
}
if (qunpm.year != 0)
{
sqlYear = " and year = " + qunpm.year + " ";
}
con.Open();
var re = new List <object>();
var sqlStr =
"SELECT DISTINCT " + Server.Province[localProvince] +
"Admit.uniName , address , University.subject , batch , year , uniMin , uniAve , uniGap , uniNum " +
"FROM " + Server.Province[localProvince] + "Admit JOIN University ON " +
Server.Province[localProvince] +
"Admit.uniName = University.uniName " +
"WHERE province = '" + localProvince + "' " + " AND classes = '" + qunpm.classes + "' " +
"AND University.uniName like '%" + qunpm.uniName + "%' " + sqlUniBatch + sqlUniLocal + sqlUniType +
sqlYear +
" ORDER BY uniMin";
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],
uType = (string)reader[2],
uBatch = (string)reader[3],
year = (int)reader[4],
uMin = (int)reader[5],
uAve = (decimal)reader[6],
uGap = (decimal)reader[7],
uNum = (int)reader[8]
});
}
return(re);
}
}
