/// <summary>
/// 查询combox
/// </summary>
/// <returns></returns>
public List <teaminfo> GetCBO()
{
string sql = "SELECT* FROM teaminfo";
DataTable dt = DBHelper.ExcuteDateSet(sql);
List <teaminfo> list = new List <teaminfo>();
foreach (DataRow item in dt.Rows)
{
teaminfo info = new teaminfo();
info.id = Convert.ToInt32(item["id"].ToString());
info.teamname = item["teamname"].ToString();
list.Add(info);
}
return(list);
}
/// <summary>
/// 主要的查询
/// </summary>
/// <param name="name"></param>
/// <param name="type"></param>
/// <param name="people"></param>
/// <returns></returns>
public List <Super> GetDB(string name, string count, string people)
{
//这是试图查询
string sql = "SELECT * FROM view_cha where 1=1 ";
//试图的SQL语句
// SELECT COUNT, n2.teamname AS zhu,n1.teamname AS ke,competitiontime,competitionposition,score,entryperson
// FROM scheduleinfo INNER JOIN teaminfo n2
// ON scheduleinfo.hostteamid = n2.id
//INNER JOIN teaminfo n1 ON scheduleinfo.awayteamid = n1.id
// WHERE 1 = 1
List <SqlParameter> sqlps = new List <SqlParameter>();
//对于多个参数的判断
if (!string.IsNullOrWhiteSpace(name))
{
sql += " AND zhu like '%'+@name+'%'";
sqlps.Add(new SqlParameter("@name", name));
}
if (!string.IsNullOrWhiteSpace(count))
{
sql += " and COUNT=@count";
sqlps.Add(new SqlParameter("@count", count));
}
if (!string.IsNullOrWhiteSpace(people))
{
sql += " and author like '%'+@author+'%'";
sqlps.Add(new SqlParameter("@author", people));
}
DataTable dt = DBHelper.ExcuteDateSet(sql, sqlps.ToArray());
List <Super> list = new List <Super>();
try
{
foreach (DataRow item in dt.Rows)
{
Super info = new Super();
info.count = Convert.ToInt32(item["count"].ToString());
info.zhu = item["zhu"].ToString();
info.ke = item["ke"].ToString();
info.competitiontime = item["competitiontime"].ToString();
info.competitionposition = item["competitionposition"].ToString();
info.score = item["score"].ToString();
info.entryperson = item["entryperson"].ToString();
list.Add(info);
}
}
catch (Exception)
{
throw;
}
return(list);
}